JAVA---JdbcUtil封装

 

import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

/**
 * 简单模拟：单例模式的应用
 * 
 */
public class JdbcUtil {

 

 //封装的私有成员
 private static Connection conn;

 

 /**
  * 私有构造器
  */
 private JdbcUtil() {

 }

 

 /**
  * 获取连接对象
  * @return
  */
 public static synchronized Connection getConn() {

  if (conn == null) {

   try {

    // 第一步加载驱动程序
    Class.forName("com.mysql.jdbc.Driver");

 

    File file = new File("src//jdbc.properties");

    InputStream is = new FileInputStream(file);

 

    Properties prop = new Properties();

    prop.load(is);

 

    // 第二步:获取连接对象
    conn = DriverManager.getConnection(prop.getProperty("url"),

      prop.getProperty("user"), prop.getProperty("pass"));

 

   } catch (Exception e) {

    e.printStackTrace();

   }

  }

 

  return conn;

 }

 

 /**
  * 释放资源
  * @param stmt
  * @param rs
  */
 public static void release(PreparedStatement pstmt, ResultSet rs) {

  if (rs != null) {

   try {

    rs.close();

   } catch (SQLException e) {

    e.printStackTrace();

   }
  }

  if (pstmt != null) {

   try {

    pstmt.close();

   } catch (SQLException e) {

    // TODO Auto-generated catch block

    e.printStackTrace();

   }
  }
 }
}