java连接数据库核心代码

一、oracle

String driver = "oracle.jdbc.driver.OracleDriver";

 String url = "jdbc:Oracle:thin:@10.61.6.185:1521:orcl";

 Statement stmt = null;

 Connection conn = null;

try {
           Class.forName(driver);
   conn = DriverManager.getConnection(url, "kygl0714", "kygl0714");
   stmt = conn.createStatement();
           String sql="select jsxm from b_js where jsbh='"+key+"'";
   ResultSet rs=stmt.executeQuery(sql);

……

二、mysql

Connection conn=null;
try{
Class.forName("com.mysql.jdbc.Driver");
System.out.println("数据库驱动载入成功！");
String url="jdbc:mysql://localhost:3306/DeCloud_HBase";
String user="root";
String password="root";
conn =DriverManager.getConnection(url,user,password);
String sql=null;
Statement statement=conn.createStatement();

……