一、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();
……