一、连接sqlServer
1、Sql Server验证(用户名/密码方式连接)
public static Connection getConnectionForSqlServer() throws ClassNotFoundException, SQLException{
Connection conn = null;
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
conn = DriverManager.getConnection("jdbc:sqlserver://192.168.10.1:1433; DatabaseName=Meters", "sa", "123456");
conn.setAutoCommit(false);
System.out.println("SqlServer库数据库连接成功!");
return conn;
}
2、Windows身份验证(不需要用户名和密码)
public static void main(String[] args) throws ClassNotFoundException, SQLException {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn=DriverManager.getConnection("jdbc:sqlserver://192.168.10.1:1433;integratedSecurity=true;DatabaseName=Meters");
System.out.println("SQLServer连接成功:"+conn);//这里如果能打印出来表示数据库链接成功
}
最佳答案
如果使用 Window 身份验证,您可以执行以下操作:
String url = "jdbc:sqlserver://MYPC\\SQLEXPRESS;databaseName=MYDB;integratedSecurity=true";
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn = DriverManager.getConnection(url);
然后将路径添加到 sqljdbc_auth.dll 作为 VM 参数(构建路径中需要 sqljdbc4.jar)。
使用 Windows 身份验证:
String url ="jdbc:sqlserver://PC01\inst01;databaseName=DB01;integratedSecurity=true";
使用 SQL 身份验证:
String url ="jdbc:sqlserver://PC01\inst01;databaseName=DB01";
二、连接MySQL
public static Connection getConnectionForMysql() throws ClassNotFoundException, SQLException{
Connection conn = null;
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test?useSSL=false&useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC", "root", "root");
conn.setAutoCommit(false);
System.out.println("MySQL数据库连接成功!");
return conn;
}
三、连接Oracle
public static Connection getConnectionForOracle() throws ClassNotFoundException, SQLException {
Connection conn = null;
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@1127.0.0.1:1521:orcl", "test", "test");
conn.setAutoCommit(false);
System.out.println("Oracle库数据库连接成功!");
return conn;
}
四、连接Access数据库
public static Connection getConnectionForAccess() throws ClassNotFoundException, SQLException{
Connection conn = null;
Class.forName("com.hxtt.sql.access.AccessDriver");
conn = DriverManager.getConnection("jdbc:Access:///E://HuaDB.mdb", username, password);
conn.setAutoCommit(false);
System.out.println("access库数据库连接成功!");
return conn;
}