java jdbc的简单封装 用资源文件配置

package jdbc;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;


public class JDBCUtil {
	static Properties pros = null;//读取资源文件的信息
	
	static {//加载JDBCUtil类时候调用
		pros = new Properties();
		try {
			pros.load(Thread.currentThread().getContextClassLoader().getResourceAsStream("db.properties"));
		} catch (IOException e) {
			e.printStackTrace();
		}
	}
	public static Connection getMysqlConn() {
		try {
			Class.forName(pros.getProperty("mysqlDriver"));
			return  DriverManager.getConnection(pros.getProperty("mysqlUrl"),pros.getProperty("mysqlUser"),pros.getProperty("mysqlPwd"));
		} catch (Exception e) {
			return null;
		}
	}
	
	
	public static void close(ResultSet rs,Statement ps, Connection conn) {
		try {
			if (rs!= null) {
				rs.close();
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		try {
			if (ps!= null) {
				ps.close();
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		try {
			if (conn!= null) {
				conn.close();
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}

db.properties文件 资源文件

mysqlDriver:com.mysql.cj.jdbc.Driver
mysqlUrl:jdbc:mysql://localhost:3306/jdbcTest?serverTimezone=UTC&characterEncoding=utf-8&useSSL=false
mysqlUser:root
mysqlPwd:root

package jdbc;


import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class Demo14 {
	
	public static void main(String[] args) {
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;

		try {
		conn = JDBCUtil.getMysqlConn();
		ps = conn.prepareStatement("insert into to_user (username,regTime,lastLoginTime) values (?,?,?)");
		ps.setString(1, "john");
		ps.setObject(2, new java.sql.Date(System.currentTimeMillis()));
		ps.setObject(3, new java.sql.Date(System.currentTimeMillis()));
		ps.execute();
			
			} catch (Exception e) {
				e.printStackTrace();
		}finally {
			JDBCUtil.close(rs,ps,conn);
		}	
	}
}