public class JdbcUtils {

 

 private static ComboPooledDataSource cpds= new ComboPooledDataSource();

 

 public static DataSource getDataSource(){

  return cpds;

 }

 public static Connection getConnection(){

  try {

   return cpds.getConnection();

  } catch (SQLException e) {

   // TODO Auto-generated catch block

   e.printStackTrace();

   throw new RuntimeException("建立连接失败");

  }

 }

 public static void close(Connection conn){

  if (conn != null) {

   try {

    conn.close();

   } catch (SQLException e) {

    // TODO Auto-generated catch block

    e.printStackTrace();

   }

  }

 }

 public static void close(Connection conn ,Statement stm){

  if (stm != null) {

   try {

    stm.close();

   } catch (SQLException e) {

    // TODO Auto-generated catch block

    e.printStackTrace();

   }

   close(conn);

  }

 }

 public static void close(Connection conn ,Statement stm ,ResultSet rs){

  if (rs != null) {

   try {

    rs.close();

   } catch (SQLException e) {

    // TODO Auto-generated catch block

    e.printStackTrace();

   }

  }

  close(conn, stm);

 }

 public static void close(PreparedStatement pstm){

  if (pstm !=null) {

   try {

    pstm.close();

   } catch (SQLException e) {

    // TODO Auto-generated catch block

    e.printStackTrace();

   }

  }

 }

}