DB(42_1)

Title:DB
discription:1、将数据库的相关东西封装在一个类中，在用到的时候可以调用。    2、在封装时，可以运用重载。
@Copyright:
@Company:
@autor:firefly
@version:1.0
@time:2013.1.1

 

import java.sql.*;

public class DB {
 public static Connection getConn() {
  Connection conn = null;
  try {
   Class.forName("com.mysql.jdbc.Driver");
   conn = DriverManager.getConnection("jdbc:mysql://localhost/test?user=root&password=root");
  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException e) {
   e.printStackTrace();
  }
  
  return conn;
 }
 
 public static Statement getStatement(Connection conn) {
  Statement stmt = null;
  try {
   if(conn != null) {
    stmt = conn.createStatement();
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }
  return stmt;
 }
 
 public static ResultSet getResultSet(Statement stmt, String sql) {
  ResultSet rs = null;
  try {
   if(stmt != null) {
    rs = stmt.executeQuery(sql);
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }
  return rs;
 }
 
 public static void closeConn(Connection conn) {
  try {
   if(conn != null) {
    conn.close();
    conn = null;
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }
 }
 
 public static void closeStmt(Statement stmt) {
  try {
   if(stmt != null) {
    stmt.close();
    stmt = null;
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }
 }
 
 public static void closeRs(ResultSet rs) {
  try {
   if(rs != null) {
    rs.close();
    rs = null;
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }
 }
}