方式1:使用DriverManager类来使用jdbc
使用registerDriver(Driver driver)
注册与给定的驱动程序 DriverManager
使用getConnection(String url, String user, String password)
尝试建立与给定数据库URL的连接。
方式2:不用properties直接写
方式3:直接不用注册驱动了,Driver方法已经帮我们注册了
方式4: 使用配置文件
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
一定要注意配置文件如果你用的是idea一定要放在src根目录下,我今天被坑了两个小时敲了30多遍代码
!!!!!!!!!!!!!!!!!!!!!!!!!!!!``!!!!!!!!!
package cn.zsp.test;
import java.io.*;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.util.Properties;
public class TestDemo {
//方式1利用反射
@org.junit.Test
public void testConn1() throws Exception {
Class cl=Class.forName("com.mysql.jdbc.Driver");
Driver driver=(Driver) cl.newInstance();
String url="jdbc:mysql://localhost:3306/test1";
Properties info =new Properties();
info.setProperty("user","root");
info.setProperty("password","123456");
Connection connect = driver.connect(url, info);
System.out.println(connect);
}
@org.junit.Test
public void testConn2() throws Exception {
//不用properties,比较方便
String url ="jdbc:mysql://localhost:3306/test1";
String ueser="root";
String password="123456";
Class cl =Class.forName("com.mysql.jdbc.Driver");
// 注册驱动
Driver driver =(Driver) cl.newInstance();
DriverManager.registerDriver(driver);
Connection connection = DriverManager.getConnection(url, ueser, password);
System.out.println(connection);
}
@org.junit.Test
public void testConn3() throws Exception {
String url ="jdbc:mysql://localhost:3306/test1";
String user="root";
String password="123456";
Class.forName("com.mysql.jdbc.Driver");//可以省但是尽量不要
// Driver driver =(Driver) cl.newInstance();
// DriverManager.registerDriver(driver);
// 不用注册驱动了因为Driver里的方法有静态代码块帮我们注册了
Connection connection = DriverManager.getConnection(url, user, password);
System.out.println(connection);
}
@org.junit.Test
public void testConn4() throws Exception {
InputStream resourceAsStream = TestDemo.class.getClassLoader().getResourceAsStream("jdbc.properties");
Properties pro=new Properties();
pro.load(resourceAsStream);
String user =pro.getProperty("user");
String password =pro.getProperty("password");
String url =pro.getProperty("url");
String driverClass =pro.getProperty("driverClass");
Class.forName(driverClass);
Connection connection = DriverManager.getConnection(url,user,
password);
System.out.println(connection);
}
}