seleperform_c.java

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

package project;

import java.sql.*;
import javax.swing.JOptionPane;
import java.awt.*;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class SelePerform_C {
    protected String com1 = null;
    protected String com2 = null;
    protected String jt = null;

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

    public ResultSet set() {

        DataBase db = new DataBase();
        String sql1 = "select employee_id as '工号', name as '员工姓名', convert(varchar(10),birth_date,111) as '出生日期'" +
                     ",lengder as '性别', depart_name as '部门名称', position_name as '职务', telephone as '家庭电话'" +
                     ",address as '家庭住址', convert(varchar(20),hire_date,111) as '入职日期'" +
                     ",convert(varchar(20),contract_expire_date,111) as '合同到期日期', salary as '工资', education as '文化水平'" +
                     " from employee_table as t1 inner join depart_table as t2 on t1.dep_id = t2.depart_id " +
                     "inner join position_table as t3 on t1.position_id = t3.position_id " +
                     "inner join sex_table as t4 on t1.sex = t4.sex ";
        String sql2 = "where " + com1 + " " + com2 + " " + "'" + jt + "'";
        if(com1 == null){
           sql2 = "";
         }

         String sql = sql1 + sql2;

        ResultSet rs = db.executeQuery(sql);

        return rs;
    }

    private void jbInit() throws Exception {
    }


}