ConnectionUtils

 
package day1;

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

/**连接工具类*/
public class ConnectionUtils {
 private static String driver = null;
 private static String url = null;
 private static String dbUser = null;
 private static String dbPassword = null;
 //获取参数
 public static void getParam(){
  String filename = "src/db_mysql.properties";
  File file = new File(filename);
   try {
    FileInputStream fis = new FileInputStream(file);
    //Map接口的子类Properties,键值对对象
    Properties props = new Properties();
    //fis中的键值对信息装载到props对象中
    props.load(fis);
    //从键值对对象props中通过key找到value
    driver = props.getProperty("driver");
    url = props.getProperty("url");
    dbUser = props.getProperty("dbUser");
    dbPassword = props.getProperty("dbPassword");
   } catch (Exception e) {
    e.printStackTrace();
   }
 }
 public static Connection getConnection(){
  Connection conn = null;
  getParam();
  try {
   Class.forName(driver);
   conn = DriverManager.getConnection(url,dbUser,dbPassword);
  } catch (Exception e) {
   e.printStackTrace();
  }
  return conn;
 }
 public static void close(Connection conn){
  try {
   if (conn != null)
    conn.close();
  } catch (Exception e) {
   e.printStackTrace();
  }
 }
 public static void close(Statement stmt){
  try{
   if(stmt!=null)
    stmt.close();
  }catch(Exception e){
   e.printStackTrace();
  }
 }
 public static void close(ResultSet rs){
  try{
   if(rs!=null)
    rs.close();
  }catch(Exception e){
   e.printStackTrace();
  }
 }
}