Java连接数据库的几种方式

方式1:Driver获取连接

Driver driver = new com.mysql.cj.jdbc.Driver();
//	Driver driver = new com.mysql.jdbc.Driver();
		 
	String url = "jdbc:mysql://localhost:3306/test";
	//将用户名和密码封装在Properties中
	Properties info = new Properties();
	info.setProperty("user","root");
	info.setProperty("password","123456");
	Connection conn = driver.connect(url,info);
		
	System.out.println(conn);

方式2:使用反射获取连接驱动

//1.获取Driver实现类对象:通过反射
		Class clazz = Class.forName("com.mysql.cj.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","123456");
		//4.获取连接
		Connection conn = driver.connect(url,info);
		System.out.println(conn);

方式3:使用DriverManager

//1.获取 Driver实现类的对象
		Class clazz = Class.forName("com.mysql.cj.jdbc.Driver");
		Driver driver = (Driver) clazz.newInstance();
		
		//2、提供另外三个连接的基本信息
		String url = "jdbc:mysql://localhost:3306/test";
		String user = "root";
		String password = "123456";
		//注册驱动
		DriverManager.registerDriver(driver);
		
		//获取连接
		Connection conn = DriverManager.getConnection(url, user, password);
		System.out.println(conn);

方式4:使用DriverManager

//1、提供另外三个连接的基本信息
		String url = "jdbc:mysql://localhost:3306/test";
		String user = "root";
		String password = "123456";
		//2.获取 Driver实现类的对象(可省略)
		Class.forName("com.mysql.cj.jdbc.Driver");
		
		//获取连接
		Connection conn = DriverManager.getConnection(url, user, password);
		System.out.println(conn);
经验分享 程序员 微信小程序 职场和发展