dbconnect.java

学生成绩课程管理系统 看看

package com.accp;

import java.sql.*;


public class DBConnect {

    

    private static String SQL_URL =
            "jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=StuDB";
    private static String SQL_USER = "sa";
    private static String SQL_PASS = "sa";
    private static String SQL_DRIVER_CLASS =
            "com.microsoft.jdbc.sqlserver.SQLServerDriver";

    public static Connection getConnection() {
        Connection con = null;

        try {
            Class.forName(SQL_DRIVER_CLASS);
            con = DriverManager.getConnection(SQL_URL, SQL_USER, SQL_PASS);
        } 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 closeResult(ResultSet rs) {
    try {
      if (rs != null) {
        rs.close();
      }
    }
    catch (SQLException ex) {
      ex.printStackTrace();
    }
  }

  /*关闭Statement对象*/
  public static void closeStatement(Statement stm) {
    try {
      if (stm != null) {
        stm.close();
      }
    }
    catch (SQLException ex) {
      ex.printStackTrace();
    }
  }

  /*关闭PreparedStatement对象*/
  public static void closePreparedStatement(PreparedStatement pst) {
    try {
      if (pst != null) {
        pst.close();
      }
    }
    catch (SQLException ex) {
      ex.printStackTrace();
    }
  }

  /*关闭Connection对象*/
  public static void closeConnection(Connection conn) {
    try {
      if (conn != null) {
        conn.close();
      }
    }
    catch (SQLException ex) {
      ex.printStackTrace();
    }
  }
}