首页 > 代码库 > JDBCUtil
JDBCUtil
package cn.itsource.util; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.Properties; public class JDBCUtil { private static JDBCUtil instance = null; private static Properties p = null; private JDBCUtil() { } static { try { p = new Properties(); p.load(Thread.currentThread().getContextClassLoader() .getResourceAsStream("jdbc.properties")); Class.forName(p.getProperty("driverClassname")); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } instance = new JDBCUtil(); } public Connection getConnection() { try { return DriverManager.getConnection(p.getProperty("url"), p.getProperty("username"), p.getProperty("password")); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return null; } public static JDBCUtil getInstance() { return instance; } public void close(ResultSet rs, Statement st, Connection conn) { try { if (rs != null) rs.close(); } catch (SQLException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } finally { try { if (st != null) st.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { try { if (conn != null) conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } } }
JDBCUtil
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。