数据库连接

//数据库连接工具类
public class DbUtil {
	
/*	private String dbUrl = "jdbc:mysql://localhost:3306/db_news1";
	private String dbUserName = "root";
	private String dbPassword = "123456";
	private String jdbcName = "com.mysql.jdbc.Driver";*/
	
	public Connection getCon() throws Exception  {
//		Class.forName(jdbcName);
//		Connection con = DriverManager.getConnection(dbUrl, dbUserName, dbPassword);

		Class.forName(PropertiesUtil.getValue("jdbcName"));
		Connection con = DriverManager.getConnection(PropertiesUtil.getValue("dbUrl"), PropertiesUtil.getValue("dbUserName"), PropertiesUtil.getValue("dbPassword"));
		return con;
	}
	
	public void closeCon(Connection con)throws Exception{
		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
			e.printStackTrace();
			System.out.println("数据库连接失败");
		}
	}
}

src文件夹下的properties文件例如：news.properties

dbUrl=jdbc:mysql://localhost:3306/db_news1
dbUserName=root
dbPassword=123456
jdbcName=com.mysql.jdbc.Driver
userImage=userImage/
pageSize=5

获取properties文件里面对应值的方法（也封装为工具类）：

public class PropertiesUtil {

	public static String getValue(String key) {
		Properties prop = new Properties();
		InputStream in = new PropertiesUtil().getClass().getResourceAsStream("/news.properties");
		try {
			prop.load(in);
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return prop.getProperty(key);
	}
}