ConnectionFactory获取连接的简单工厂类

来源：互联网发布：centos libgcc s.so 编辑：程序博客网时间：2024/06/10 02:53

package factory;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class ConnectionFactory {

   private static final String DRIVER = "com.mysql.jdbc.Driver";
   private static final String URL = "jdbc:mysql://127.0.0.1:3306/online_inf";
   private static final String USER = "root";
   private static final String PASSWORD = "root";

   /**
   * 获取数据库连接的方法
   * @return 返回数据库的连接对象
   *            失败返回null
   * */
   public static Connection getConnection(){
       try {
           Class.forName(DRIVER);
           return DriverManager.getConnection(URL,USER,PASSWORD);
       } catch (Exception e) {
           e.printStackTrace();
           return null;
       }
   }

   /**
   * 关闭数据库连接的方法
   * @param Connection con,Statement stm,ResultSet rs
   * */
   public static void close(Connection con,Statement stm,ResultSet rs){
       try {
           if(rs != null)
               rs.close();
           if(stm != null)
               stm.close();
           if(con != null){
               con.close();
           }
       } catch (Exception e) {
           e.printStackTrace();
       }

   }

}