1首先建立配置文件 必须跟连接的类放在一块 便于读取 DB.properties
内容:conn_type=
conn_url=jdbc:mysql://localhost:3306/buy
conn_user=root
conn_pwd=root
conn_driver=com.mysql.jdbc.Driver
2 建立读取配置文件的类
package dao;
import java.io.IOException;
import java.util.Properties;
public class DB {
private static Properties prop=new Properties();
static{
try{
//获得配置文件
prop.load(DB.class.getResourceAsStream("db.properties"));
}catch(IOException e)
{
e.printStackTrace();
}
}
//获得数据库连接信息
public static String Type=prop.getProperty("conn_type");
public static String url=prop.getProperty("conn_url");
public static String drv=prop.getProperty("conn_driver");
public static String pwd=prop.getProperty("conn_pwd");
public static String user=prop.getProperty("conn_user");
}
3 建立连接类
package dao;
import java.sql.*;
public class DBConnect {
public static Connection getConnection()
{
Connection conn=null;
try{
Class.forName(DB.drv).newInstance();
conn=DriverManager.getConnection(DB.url,DB.pwd,DB.user);
}catch(Exception e)
{
e.printStackTrace();
}
if(conn==null)
{
System.out.println("没有取得连接");
}
return conn;
}
}