JDBC连接数据库（配置文件方法）

废话不多说直接上代码

Java类

/**
	 * 使用Driver连接
	 * @throws SQLException
	 */
	public void testDriver() throws SQLException{
		//1. 创建driver实现类对象
		Driver driver = new com.mysql.cj.jdbc.Driver();
		
		//2.准备连接的基本信息
		String url = "jdbc:mysql://localhost:3306/test?useSSL=false&sserverTimezone=UTC";
		Properties info = new Properties();
		info.put("user", "root");
		info.put("password", "123456");
		
		//3.调用driver接口的connect  获取数据库连接
		Connection connection = driver.connect(url, info);
		System.out.println(connection);
	}

---

通过配置文件编写通用方法

/**
	 * 通过配置文件编写通用方法
	 * 
	 * */
	
	public Connection getConnection() throws Exception{
		String driverClass = null;
		String jdbcUrl = null;
		String user = null;
		String password = null;
		
		//通过读取类路径下的jdbc.properties文件获取配置信息
		InputStream in = getClass().getClassLoader().getResourceAsStream("jdbc.properties");
		
		Properties properties = new Properties();
		properties.load(in);
		driverClass = properties.getProperty("driver");
		jdbcUrl = properties.getProperty("jdbcUrl");
		user = properties.getProperty("user");
		password = properties.getProperty("password");
		
		//通过反射进行实例化
		Driver driver = 
				(Driver) Class.forName(driverClass).newInstance();
		
		Properties info = new Properties();
		info.put("user",user);
		info.put("password", password);
		
		Connection connection = driver.connect(jdbcUrl, info);
		return connection;
		
	}

---

DriverManager

/**
	 * DriverManager 是驱动的管理类  相比较于driver 更为方便
	 * **/
	
	public Connection testDriverManager() throws Exception{
		//1准备4个字符串
		String driverClass = "com.mysql.cj.jdbc.Driver";
		String dbUrl = "jdbc:mysql://localhost:3306/test";
		String user = "root";
		String password = "123456";
		
		//2.加载数据库驱动程序（注册驱动）
		Class.forName(driverClass);
		
		//3.通过DriverManager的getConnection()方法获取数据库连接
		Connection connection = DriverManager.getConnection(dbUrl,user,password);
		
		return connection;
	}

---

配置文件

driver=com.mysql.jdbc.Driver
jdbcUrl=jdbc:mysql://localhost:3306/test?useSSL=false&serverTimezone=UTC
user=root
password=123456

为了爱学习的淼哥而写的博客