例如://建立和MS SQL SERVER的连接
public static Connection acquireConnection(
String host,String port,String dbName,String user,
String pwd) throws ClassNotFoundException,SQLException{
Connection connection=null;
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url ="jdbc:microsoft:sqlserver://"+
host+":"+port+";User="+user+";Password="+pwd;
connection= DriverManager.getConnection(url);
connection.setCatalog(dbName);
}catch(ClassNotFoundException e){
e.printStackTrace();
throw e;
}catch(SQLException e){
e.printStackTrace();
throw e;
}
return connection;
}
怎么改:
public static Connection acquireConnection(
String host,String port,String dbName,String user,
String pwd) throws ClassNotFoundException,SQLException{
Connection connection=null;
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url ="jdbc:microsoft:sqlserver://"+
host+":"+port+";User="+user+";Password="+pwd;
connection= DriverManager.getConnection(url);
connection.setCatalog(dbName);
}catch(ClassNotFoundException e){
e.printStackTrace();
throw e;
}catch(SQLException e){
e.printStackTrace();
throw e;
}
return connection;
}
怎么改:
try {
url="jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=D:/ATM/ATM.mdb"; //access
userName = "";
password = "";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//access
con = DriverManager.getConnection(
url,userName,password);
} catch (Exception e) {
e.printStackTrace();
}
return con;
}
try {
url="jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=D:/ATM/ATM.mdb"; //access
userName = "";
password = "";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//access
con = DriverManager.getConnection(
url,userName,password);
} catch (Exception e) {
e.printStackTrace();
}
return con;
}
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection(strurl) ;
Statement stmt=conn.createStatement();