dbmanager.java~58~

模拟的JAVA房产管理系统

import java.sql.*;
import javax.swing.*;
import java.util.*;

//数据库操作类
public class DBManager {
  //定义返回结果集
  ResultSet rs;
  //创建指定数据库的URL
  String strurl = "jdbc:odbc:house";
  //缺省构造方法
  public DBManager() {
  }

  //查询方法，返回查询结果集
  public ResultSet getResult(String sql) {
    try {
      //加载驱动程序
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      //创建连接
      Connection conn = DriverManager.getConnection(strurl);
      //创建statement对象
      Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                                            ResultSet.CONCUR_UPDATABLE);
      //执行SQL语句，返回结果集
      ResultSet rs = stmt.executeQuery(sql);
      System.out.println("executeSql------" + sql);
      //返回
      return rs;
    }
    //异常处理
    catch (Exception e) {
      System.out.println("getResult------" + e.toString());
      //若有异常，返回null
      return null;
    }
  }

  //执行更新，删除语句方法
  public boolean executeSql(String sql) {
    try {
      //加载驱动程序
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      //创建连接
      Connection conn = DriverManager.getConnection(strurl);
      //创建statement对象
      Statement stmt = conn.createStatement();
      //执行SQL语句，返回结果集
      stmt.executeUpdate(sql);
      System.out.println("executeSql------" + sql);
      //提交到数据库
      conn.commit();
      //返回true，表示操作成功
      return true;
    }
    catch (Exception e) {
      System.out.println("executeSql------" + e.toString());
      //返回false，表示操作失败
      return false;
    }
  }

  //代码值与代码内容互换，当direction=1时，传入代码值得到代码内容；当direction=0时，传入代码内容得到代码值
  public String CodeDesConvert(String table, String code, String des,
                               int direction) {
    String sql = new String();
    String result = new String();
    if (code.equals("") && des.equals("")) {
      return "";
    }
    if (direction == 1) {
      sql = "select DESCRIPTION from " + table + " where CODE='" + code + "'";
    }
    else if (direction == 0) {
      sql = "select CODE from " + table + " where DESCRIPTION='" + des + "'";
    }
    System.out.println(sql);
    try {
      ResultSet rs = getResult(sql);
      if (rs.first()) {
        if (direction == 1) {
          result = rs.getString("DESCRIPTION");
        }
        else if (direction == 0) {
          result = rs.getString("CODE");
        }
      }
      else {
        rs.close();
      }
    }
    catch (Exception e) {
      e.printStackTrace();
    }
    finally {
      return result;
    }
  }

  public String getID(String table) {
    String sql = "select * from " + table + " order by ID desc";
    String id = new String();
    try {
      ResultSet rs = getResult(sql);
      System.out.println(rs.first());
      if (rs.first()) {
        id = rs.getString("ID");
        id = Integer.toString(Integer.parseInt(id) + 1);
      }
      else {
        rs.close();
        id = "1";
      }
    }
    catch (Exception e) {
      e.printStackTrace();
    }
    return id;
  }

  public void fullCombo(JComboBox cbo, String table) {
    String sql = "select * from " + table + " order by CODE";
    String content = new String();
    try {
      ResultSet rs = getResult(sql);
      System.out.println(rs.first());
      if (rs.first()) {
        rs.beforeFirst();
        while (rs.next()) {
          content = rs.getString("DESCRIPTION");
          System.out.println(content);
          cbo.addItem(content);
        }
      }
      else {
        rs.close();
      }
      cbo.setSelectedItem(null);
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }

  public Vector getCode(String table) {
    String sql = "select * from " + table + " order by CODE";
    Vector vecResult = new Vector();
    try {
      ResultSet rs = getResult(sql);
      if (rs.first()) {
        rs.beforeFirst();
        while (rs.next()) {
          String[] code = new String[2];
          code[0] = rs.getString("CODE");
          code[1] = rs.getString("DESCRIPTION");
          vecResult.add(code);
        }
      }
      else {
        rs.close();
      }
    }
    catch (Exception e) {
      e.printStackTrace();
    }
    return vecResult;
  }

  public String getByField(String table, String wantedField, String condition) {
    String sql = "select * from " + table + " where " + condition;
    String value = "";
    Vector vecResult = new Vector();
    try {
      ResultSet rs = getResult(sql);
      if (rs.first()) {
        value = rs.getString(wantedField);
      }
      else {
        rs.close();
      }
    }
    catch (Exception e) {
      e.printStackTrace();
    }
    return value;
  }

}