DBUtil页面的编码 MYSQL数据库的连接

 1.新建web project工程

2.在lib中导入MYSQL驱动  mysql-connector-java-5.0.8-bin.jar

DBConfig.properties  配置文件

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/jdbc_db
username=root
password=123456

 

DBUtil.java

package com.tao.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Properties;

public class DBUtil {
	public static void main(String[] args) {
		DBUtil util = new DBUtil();
		Connection conn = util.openConnection();
		System.out.println(conn);
	}

	public Connection openConnection() {
		Properties prop = new Properties();
		String driver = null;
		String url = null;
		String username = null;
		String password = null;

		try {
			prop.load(this.getClass().getClassLoader()
					.getResourceAsStream("DBConfig.properties"));
			driver = prop.getProperty("driver");
			url = prop.getProperty("url");
			username = prop.getProperty("username");
			password = prop.getProperty("password");
			Class.forName(driver);
			return DriverManager.getConnection(url, username, password);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return null;
	}

}