JDBC连接mysql的三种方式
(Java DataBase Connectivity)是一个独立于特定数据库管理系统,通用的SQL数据库存取和操作的公共接口(一组api)
JDBC为访问不同的数据库提供了一种统一的途径
JDBC连接数据库
首先:导入jar包
IDEA中在File -> Project Structure ->Libraries ->java 实现导包功能
方式一:
public void testConnection1() throws SQLException {
Driver driver = new com.mysql.jdbc.Driver();
//jdbc:mysql:协议
//localhost:IP地址
//3306:端口号
//test:test数据库
String url = "jdbc:mysql://localhost:3306/test";
//将用户名和密码封装到Properties中
Properties info = new Properties();
info.setProperty("user","root");
info.setProperty("password","1234");
Connection conn = driver.connect(url,info);
System.out.println(conn);
}
方式二:对方式一的迭代,是程序不出现第三放API
public void testConnection2() throws ClassNotFoundException, IllegalAccessException, InstantiationException, SQLException {
//1、获取Driver实现类对象,使用反射
Class clazz = Class.forName("com.mysql.jdbc.Driver");
Driver driver = (Driver) clazz.newInstance();
//2、提供要连接的数据库
String url = "jdbc:mysql://localhost:3306/test";
//3、提供连接需要的用户名和密码
Properties info = new Properties();
info.setProperty("user","root");
info.setProperty("password","1234");
//4、获取连接
Connection conn = driver.connect(url, info);
System.out.println(conn);
}
方式三:使用DriverManager替换Driver
public void testConnection3() throws Exception{
//1、获取Driver实现类对象
Class clazz = Class.forName("com.mysql.jdbc.Driver");
Driver driver = (Driver) clazz.newInstance();
//2、提供三个连接信息
String url = "jdbc:mysql://localhost:3306/test";
String user = "root";
String password = "1234";
//3、注册驱动
DriverManager.registerDriver(driver);
//4、连接数据库
Connection connection = DriverManager.getConnection(url, user, password);
System.out.println(connection);
}