1.sql Server 2000 database connection mode:
Copy Code code as follows:
Connection con;
Public Connection Getcon () {
try{class.forname ("Com.microsoft.jdbc.sqlserver.SQLServerDriver");//Load Driver
Con=drivermanger.getconnection ("Jdbc:microsoft:sqlserver://localhost:1433;databasename=aa", "sa", ""); An attempt was made to establish a connection to a given database URL
}catch (ClassNotFoundException e) {
E.printstacktrace ();
}catch (SQLException e) {
E.printstacktrace ();
}
return con;
}
2.sql Server 2005 database connection mode:
Copy Code code as follows:
Connection con;
Public Connection Getcon () {
try{
Class.forName ("Com.microsoft.sqlserver.jdbc.SQLServerDriver");//Load Driver
Con=drivermanger.getconnection ("Jdbc:microsoft:sqlserver://localhost:1433;databasename=aa", "sa", ""); An attempt was made to establish a connection to a given database URL
}catch (ClassNotFoundException e) {
E.printstacktrace ();
}catch (SQLException e) {
E.printstacktrace ();
}
return con;
}
How to connect 3.oracle data
Copy Code code as follows:
Connection con;
Public Connection Getcon () {
try{
Class.forName ("Oracle.jdbc.driver.OracleDriver");
Con=drivermanger.getconnection ("Jdbc:oracle:thin:@127.0.0.1:1521:oracle", "Scott", "Tiger");
}catch (Exception e) {
E.printstacktrace ();
}
return con;
}