java连接数据库

1.java连接Oracle数据库：

 Class.forName("oracle.jdbc.driver.OracleDriver");
 String url="jdbc:oracle:thin:@127.0.0.1:1521:全局数据库名";
 String uname="用户名";
 String pwd="密码";
 Connection cn =DriverManager.getConnection(url,uname,pwd);
 Statement s=cn.createStatement();
 ResultSet rs=s.executeQuery(sql语句);

2.jdbc桥接odbc

 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 String url="jdbc:odbc:odbc数据源";
 String uname="用户名";
 String pwd="密码";
 Connection cn =DriverManager.getConnection(url,uname,pwd);
 Statement s=cn.createStatement();
 ResultSet rs=s.executeQuery(sql语句);

3.java连接mysql

Class.forName("com.mysql.jdbc.Driver");
 String url="jdbc:mysql://127.0.0.1:3306/数据库名";
 String uname="用户名";
 String pwd="密码";
 Connection cn =DriverManager.getConnection(url,uname,pwd);
 Statement s=cn.createStatement();
 ResultSet rs=s.executeQuery(sql语句);

4.java连接DB2

Dirver:COM.ibm.db2.jdbc.app.DB2Driver

url:jdbc:db2://<host_name>:6789/<dbname>

jar包：db2jcc.jar