1.Java使用thin方式连接Oracle数据库的代码:
public Connection getDBConnection() throws Exception {
Connection conn=null;
String url="jdbc:oracle:@thin://192.168.1.10:1521:orcl";
String username="sysdba";
String password="root";
try{
Class.forName("com.oracle.driver.OracleDriver");
conn=DriverManager.getConnection(ur,username,password);
}
catch(ClassNotFoundException classNotFound){
throw classNotFound
}
catch(SQLException sqlExc){
throw sqlExc;
}
return conn;
}
2.Java连接Sql Server2000数据库的代码:
public Connection getDBConnection() throws Exception{
Connection conn=null;
String url="jdbc:microsoft:sqlserver://192.168.1.10:1433;DatabaseName=tdb";
String username="sa";
String password="12345678"
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn=DriverManager.getConnection(url,username,password);
}
catch(ClassNotFoundException classNotFound){
throw classNotFound;
}
catch(SQLException sqlException){
throw sqlException;
}
return conn;
}
3.Java连接MySql数据库的代码:
public Connection getDBConnection() throws ClassNotFoundException,SQLException{
Connection conn=null;
String url="jdbc:mysql://localhost:3306/tdb";
String username="test";
String password="123456";
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection(url,username,password);
return conn;
}
java中jdbc连接Oracle,Sql Server2000,MySql数据库的方法
于 2012-09-08 11:19:52 首次发布