dbutil.java

来自「这个是jsp和servlet开发的在线考试系统」· Java 代码 · 共 42 行

package com.gton.util;

import java.sql.*;

public class DBUtil {
    public DBUtil() {
    }

    public static Connection getConnection(){
        Connection con = null;
        try{
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
            con = DriverManager.getConnection(
                    "jdbc:microsoft:sqlserver://localhost:1433;databasename=kaoshi","sa","123");
        }catch(Exception ex){
            ex.printStackTrace();
        }
        return con;
    }

    public static void closeConnection(ResultSet rs,
                                             PreparedStatement pstmt,
                                             Connection con){
        try{
            if(rs != null){
                rs.close();
                rs = null;
            }
            if(pstmt != null){
                pstmt.close();
                pstmt = null;
            }
            if(con != null){
                con.close();
                con = null;
            }
        }catch(Exception ex){
            ex.printStackTrace();
        }
    }
}