利用conn.properties配置文件进行数据库连接

DbUtil.java

public class DbUtil {
	private String driver;
	private String url;
	private String user;
	private String pass;
	public void initPara() throws Exception
	{
		Properties props = new Properties();
		props.load(this.getClass().getResourceAsStream("conn.properties"));
		driver=props.getProperty("driver");
	    url = props.getProperty("url");
	    user = props.getProperty("user");
	    pass = props.getProperty("pass");
	    Class.forName(driver);
	}
	
	//建立连接
	public Connection getCon() throws Exception
	{
		this.initPara();
		Connection con = DriverManager.getConnection(url, user, pass);
		return con;
	}
	
	//关闭连接
	public void closeCon(Connection con) throws SQLException{
		if(con != null){
			con.close();
		}
	}
	
	//测试
	public static void main(String[] args){
		DbUtil dbUtil = new DbUtil();
		try {
			dbUtil.getCon();
			System.out.println("连接成功！！");
		} catch (Exception e) {
			// TODO Auto-generated catch block
			System.out.println("连接失败！");
			e.printStackTrace();
		}
		
	}
}

conn.properties

driver = com.mysql.jdbc.Driver
url = jdbc:mysql://127.0.0.1:3306/数据库名
user = root
pass = 123456