dbhandle.java

来自「一个专门用来快速开发网站的框架」· Java 代码 · 共 69 行

package com.ksgl.body.index.tj;

/**
 * <p>Title: literature item </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author hj
 * @version 1.0
 */
import java.sql.*;

public class DBHandle
{
  public static Connection con=null;

        public static Connection getConn() {
                try {
                        Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
                    con = DriverManager
                                        .getConnection("jdbc:microsoft:sqlserver://localhost:1433;databasename=gjkj","sa","123");
                        return con;
                } catch (ClassNotFoundException e) {
                        // TODO Auto-generated catch block
                        e.printStackTrace();
                } catch (SQLException e) {
                        // TODO Auto-generated catch block
                        e.printStackTrace();
                }
                return con;
        }


         /////////////////////////////////////////////////////////////////
        public static void closeResource(Statement st, ResultSet rs, Connection cnn) {
        try {
            if (rs != null) {
                rs.close();
            }
        }
        catch (Exception es) {
            es.printStackTrace();
        }
        try {
            if (st != null) {
                st.close();
            }
        }
        catch (Exception es) {
            es.printStackTrace();
        }
        try {
            if (cnn != null) {
                cnn.close();
                cnn = null;
            }
        }
        catch (Exception es) {
            es.printStackTrace();
        }
    }


}