departact_c.java

javaGUI编写的人事管理系统(毕业学生答辩可参考)

package project;

import java.sql.ResultSet;
import java.sql.*;
import java.util.ArrayList;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class DepartAct_C {
  ResultSet rs = null;
  ArrayList list1 = new ArrayList();
  ArrayList list2 = new ArrayList();
  public DepartAct_C() {
    super();

    try {
      jbInit();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  public void setDepart() {
    DataBase db = new DataBase();
    String sql = "select * from depart_table";

    rs = db.executeQuery(sql);
    try {
      while (rs.next()) {
        list1.add(rs.getString(2));
      }
    }
    catch (SQLException ex) {
    }
    db.close();
  }

  public void setPosi(DepartView dp) {
    DataBase db = new DataBase();
    String dpName = dp.jList1.getSelectedValue().toString();
    String sql =
        "select position_name from depart_table as t1 inner join position_table as " +
        "t2 on t1.depart_id = t2.depart_id or t2.depart_id = -1 where depart_name = '" +
        dpName + "'";
    rs = db.executeQuery(sql);
    try {
      while (rs.next()) {
        list2.add(rs.getString(1));
      }
    }
    catch (SQLException ex) {
    }
    db.close();
  }

  private void jbInit() throws Exception {
  }

}