DB2(48)数据库连接时的封装类

最新推荐文章于 2024-07-26 22:32:03 发布

firefly_shine

最新推荐文章于 2024-07-26 22:32:03 发布

阅读量394

点赞数

分类专栏： JDBC Servlet/JSP 文章标签： DB db dB

本文链接：https://blog.csdn.net/dapengaaa111/article/details/8490960

版权

Servlet/JSP 同时被 2 个专栏收录

18 篇文章 0 订阅

订阅专栏

JDBC

10 篇文章 0 订阅

订阅专栏

Title:DB2
discription:

1、 getConnection()
2、close(Statement st, Connection conn)
3、close(ResultSet rs, Statement st, Connection conn)
4、driver和url从配置文件中加载

@Copyright:
@Company:
@autor:firefly
@version:1.0
@time:2013.1.10

package cn.edu.hpu.db.util;

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

public class DBUtil {

   private static String driver = null;
   private static String url = null;

   private DBUtil()
   {

   }

   static
   {
       try {
           Properties p = new Properties();
           InputStream inStream = DBUtil.class.getClassLoader().getResourceAsStream("config.properties");
           p.load(inStream);
           driver = p.getProperty("driver");
           url = p.getProperty("url");

           Class.forName(driver);
       } catch (Exception e) {
           e.printStackTrace();
       }
   }

   public static Connection getConnection()
   {
       Connection conn = null;
       try {
           conn = DriverManager.getConnection(url);
       } catch (SQLException e) {
           e.printStackTrace();
       }
       return conn;
   }

   public static void close(Statement st, Connection conn)
   {
       try
       {
           if(st != null)
           {
               st.close();
           }
           if(conn != null)
           {
               conn.close();
           }
       }catch(Exception e)
       {
           e.printStackTrace();
       }finally
       {
           try
           {
               if(conn != null)
               {
                   conn.close();
               }
           }catch(Exception e)
           {
               e.printStackTrace();
           }
       }

   }

   public static void close(ResultSet rs, Statement st, Connection conn)
   {
       try
       {
           if(rs != null)
           {
               rs.close();
           }
       }catch(Exception ex)
       {
           ex.printStackTrace();
       }finally
       {
           try
           {
               if(st != null)
               {
                   st.close();
               }
           }catch(Exception e)
           {
               e.printStackTrace();
           }finally
           {
               try
               {
                   if(conn != null)
                   {
                       conn.close();
                   }
               }catch(Exception e)
               {
                   e.printStackTrace();
               }
           }
       }
   }


}