java jdbc工具类抽取_JDBCUtils-抽取工具类

packagecn.itcast.util;importjava.io.FileReader;importjava.io.IOException;importjava.net.URL;import java.sql.*;importjava.util.Properties;public classJDBCUtils {private staticString url;private staticString user;private staticString password;private staticString driver;/*** 获取资源值，通过静态代码块实现*/

static{try{

Properties pro= newProperties();

ClassLoader classLoader= JDBCUtils.class.getClassLoader();

URL res= classLoader.getResource("jdbc.properties");

String path=res.getPath();

pro.load(newFileReader(path));

url= pro.getProperty("url");

user= pro.getProperty("user");

password= pro.getProperty("password");

driver= pro.getProperty("driver");

Class.forName(driver);

}catch(IOException e) {

e.printStackTrace();

}catch(ClassNotFoundException e) {

e.printStackTrace();

}

}/*** 获取连接对象

*@return连接对象

*@throwsSQLException*/

public static Connection getConnection() throwsSQLException {returnDriverManager.getConnection(url,user,password);

}/*** 释放资源

*@paramstmt

*@paramconn*/

public static voidclose(Statement stmt,Connection conn){if(stmt != null){try{

stmt.close();

}catch(SQLException e) {

e.printStackTrace();

}

}if(conn != null){try{

conn.close();

}catch(SQLException e) {

e.printStackTrace();

}

}

}public static voidclose(ResultSet rs,Statement stmt, Connection conn){if(rs != null){try{

rs.close();

}catch(SQLException e) {

e.printStackTrace();

}

}if(stmt != null){try{

stmt.close();

}catch(SQLException e) {

e.printStackTrace();

}

}if(conn != null){try{

conn.close();

}catch(SQLException e) {

e.printStackTrace();

}

}

}

}