Question

JAVA JDBC驱动使用JDBC包 如何新建一个Connection

比如我使用了JTDS,端口是1433,然后我如何新建Connection,实例化它,打开联接..使用Hlibernate就没那么麻烦,如果不用,该怎么办?

Answer 1

public static Connection getConnection() {
try {
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:1433/JTDS", "name", "password");
return conn;
} catch (Exception e) {
e.printStackTrace();
return null;
}
}
name password填写用户名和密码

Answer 2

public static Connection getConnection() {
try {
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
return conn;
} catch (Exception e) {
e.printStackTrace();
return null;
}
}