一、MYSQL
需要mysql-connector-java-5.1.6-bin.jar的额外数据包
1、建立连接(默认的port为3306)
String url = "jdbc:mysql://" + ip + ":" + port + "/?userUnicode=true&characterEncoding=utf8";
conn = DriverManager.getConnection(url, loginname, loginpass);
2 创建Statement
Statement stmt=conn.createStatement();
3 执行sql语句
二、Oracle数据库
需要额外的数据包oracle.jdbc.Driver.OracleDriver
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
String user = "datauser";
String password = "123456";
Connection conn = DriverManager.getConnection(url, user, password);