利用jdbc.properties进行JDBC的编写将会使JDBC的代码量大大的减小,使用起来也更加的方便;具体的代码和用法如下:
public class DBUtils {
private static String url;
private static String user;
private static String password;
private static String driver;
static{
String path =null;
try {
Properties properties = new Properties();
ClassLoader classLoader = DBUtils.class.getClassLoader();
URL res = classLoader.getResource("jdbc.properties");
path = res.getPath();
properties.load(new FileReader(path));
//获取数据
url = properties.getProperty("url");
user = properties.getProperty("user");
password = properties.getProperty("password");
driver = properties.getProperty("driver");
Class.forName("com.mysql.jdbc.Driver");
} catch (IOException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static Connection getConn() throws SQLException {
return DriverManager.getConnection(url, user, password);
}
public static void close(Statement stat, Connection conn, ResultSet rs) {
if( stat != null){
try {
stat.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if( conn != null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (rs !=null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public static void main(String[] args) {
try {
Connection conn = DBUtils.getConn();
if (conn != null) {
System.out.println("连接成功");
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
jdbc.properties放在src文件夹下
内容如下:
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/test
user=root
password=XXXXXX