dbconn.java

学生考试系统 有学生和老师登录。 学生登录可以选择不同的题库进行考试或练习

package com.svse.db;

//导包
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.SQLException;

public class DBConn {
    //得到连接
    public static Connection getConn() {
        Connection conn = null;
        String strDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
        String url = "jdbc:sqlserver://localhost:1433;databasename=subject";
        try {
            Class.forName(strDriver);
            conn = DriverManager.getConnection(url, "sa", "123456");
        } catch (ClassNotFoundException ex) {
            System.err.println("驱动加载异常！");
            ex.printStackTrace();
        } catch (SQLException ex) {
            System.err.println("连接异常！");
            ex.printStackTrace();
        }

        return conn;
    }

    //关闭连接
    public static void closeDB(Statement stmt, Connection conn) {
        try {
            if (stmt != null) {
                stmt.close();
            }
            if (conn != null) {
                conn.close();
            }
        } catch (SQLException ex) {
            System.err.println("关闭异常！");
            ex.printStackTrace();
        }
    }
}