使用JDBC连接数据库
使用jdbc连接数据库的五种方式(建议使用第五种)
@Test
public void TestConnection1() throws SQLException {
Driver driver=new com.mysql.jdbc.Driver();
String url = "jdbc:mysql://localhost:3306/user";
Properties info = new Properties();
info.setProperty("user", "root");
info.setProperty("password","root");
Connection conn=driver.connect(url, info);
System.out.println(conn);
}
@Test
public void TestConnection2() throws Exception {
Class clazz = Class.forName("com.mysql.jdbc.Driver");
Driver driver = (Driver) clazz.newInstance();
String url="jdbc:mysql://localhost:3306/user";
Properties info = new Properties();
info.setProperty("user", "root");
info.setProperty("password","root");
Connection conn = driver.connect(url, info);
System.out.println(conn);
}
@Test
public void TestConnection3() throws Exception {
Class clazz = Class.forName("com.mysql.jdbc.Driver");
Driver driver = (Driver) clazz.newInstance();
String url="jdbc:mysql://localhost:3306/user";
String user="root";
String password="root";
DriverManager.registerDriver(driver);
Connection conn = DriverManager.getConnection(url, user, password);
System.out.println(conn);
}
@Test
public void TestConnection4() throws Exception {
String url="jdbc:mysql://localhost:3306/user";
String user="root";
String password="root";
Class.forName("com.mysql.jdbc.Driver");
Class clazz = null;
Driver driver = (Driver) clazz.newInstance();
DriverManager.registerDriver(driver);
Connection conn = DriverManager.getConnection(url, user, password);
System.out.println(conn);
}
jdbc.properties:
user=root
password=root
url=jdbc:mysql://localhost:3306/user?useUnicode=true&characterEncoding=UTF-8
driverClass=com.mysql.jdbc.Driver
@Test
public void TestConnection5() throws Exception {
InputStream is = ConnectionTest.class.getClassLoader().getResourceAsStream("jdbc.properties");
Properties pro = new Properties();
pro.load(is);
String user = pro.getProperty("user");
String password = pro.getProperty("password");
String url = pro.getProperty("url");
String driverClass = pro.getProperty("driverClass");
Class.forName(driverClass);
Connection conn = DriverManager.getConnection(url, user, password);
System.out.println(conn);
}
以上为个人学习总结,如果有错误希望大神指点。