package com.lp.utils;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;
public class LinkDB {
private Connection conn;
private String userName;
private String userPwd;
private String driver;
private String uRL;
public LinkDB() {
try {
InputStream in = LinkDB.class.getClassLoader().getResourceAsStream("database.properties");
Properties p = new Properties();
p.load(in);
userName = p.getProperty("userName");
userPwd = p.getProperty("userPwd");
driver = p.getProperty("driver");
uRL = p.getProperty("uRL");
} catch (FileNotFoundException e) {
System.out.println("系统找不到指定的文件。");
e.printStackTrace();
} catch (IOException e) {
System.out.println("文件加载失败");
e.printStackTrace();
}
}
public Connection getConn() {
try {
Class.forName(driver);
conn = DriverManager.getConnection(uRL, userName, userPwd);
System.out.println("连接成功");
} catch (ClassNotFoundException e) {
System.out.println("驱动加载失败");
e.printStackTrace();
} catch (SQLException e) {
System.out.println("连接数据库失败");
e.printStackTrace();
}
return conn;
}
}