departact.java~1~

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 {
    ResultSet rs = null;
    ArrayList list1 = new ArrayList();
    ArrayList list2 = new ArrayList();
    public DepartAct() {
        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(DepartPanel 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 {
    }

}