databaseaccess.java~11~

一个基于JAVA的BS结构的宠物诊所管理系统.是当年在学校时写的,大家指点一下.

package gxaccp.t07.guoneng_wei.jdbc;

import java.sql.*;

public class DataBaseAccess {

  /**
   * 链接指定的数据库
   *
   */
  public static Connection getConnection() {
    return getConnection("PetClinic", "sa", "");
  }

  public static Connection getConnection(String databaseName, String user,
                                         String password) {
    Connection con = null;
    try {
      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
    }
    catch (ClassNotFoundException cnfe) {
      System.out.println("-----------数据库链接异常ClassNotFoundException---------");
      return null;
    }

    try {
      con = DriverManager.getConnection(
//          "jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=" +
          "jdbc:microsoft:sqlserver://127.0.0.1:1433;DataBaseName=" +
          databaseName,
          user,
          password);
      System.out.println(
          "-----------------测试程序走到了这里!DataBaseAccess.getConnection()并return connection");
      return con;
    }
    catch (SQLException se) {
      System.out.println("-------------数据库链接抛出SQLException异常------------");
    }
    return null;
  }

  public static ResultSet select(Connection con, String query) {
    ResultSet rs = null;
    try {
      rs = con.createStatement().executeQuery(query);
      return rs;
    }
    catch (SQLException se) {
      System.out.println("---------异常!!!!!!!!!!!!-------\n" + se.getMessage());
      se.printStackTrace();
    }
    return rs;
  }

  public static boolean insert_update(Connection con, String insertUpdate) {
    try {
      PreparedStatement pst = con.prepareStatement(insertUpdate);
      int insertState = pst.executeUpdate();
      closeStatement(pst);
      if (insertState > 0) {
        return true;
      }
    }
    catch (SQLException se) {
      se.printStackTrace();
    }
    return false;
  }

  public static boolean callProcedure(Connection con, String callproc) {
    boolean executeState = true;
    try {
      CallableStatement cst = con.prepareCall(callproc);
      executeState = cst.execute();
      closeStatement(cst);
    }
    catch (SQLException se) {
      se.printStackTrace();
    }
    return executeState;//注意:执行存储过程成功返回false,失败返回true,有异常则抛出异常
  }

  public static void method() {
  }

  public static void closeConnection(Connection con) {
    try {
      if (con != null) {
        con.close();
      }
    }
    catch (Exception ex) {
    }
  }

  public static void closeStatement(Statement st) {
    try {
      if (st != null) {
        st.close();
      }
    }
    catch (Exception ex) {
    }
  }

  public static void closeResultSet(ResultSet rs) {
    try {
      if (rs != null) {
        rs.close();
      }
    }
    catch (Exception ex) {
    }
  }
}