c0e1ba6287ac001d105fa91adc11449d

超好用的企业员工信息管理系统

package frame;

import java.sql.*;
import com.DAO;
import java.awt.*;
import java.awt.Dimension;
import java.awt.Toolkit;
import model.FrameInit;
import javax.swing.*;
import java.awt.event.*;
public class QueryCondition extends JFrame{
	JFrame qc = new JFrame("条件查询员工信息");
	JPanel p = new JPanel();
	JPanel p1 = new JPanel();
	JComboBox cbo = new JComboBox();
	JComboBox cbocon = new JComboBox();
	JLabel lblcon = new JLabel("请选择查询条件");
	JButton btnquery = new JButton("查询");
	JTable tb = new JTable();
	JScrollPane scroll = new JScrollPane(tb);
	public QueryCondition(){
		init();
	}
	public void init(){
		FrameInit.InitFrame(qc, p);
		qc.add(p1,BorderLayout.NORTH);
		p1.add(lblcon);
		cbo.addItem("人员编码");
		cbo.addItem("姓名");
		cbo.addItem("职务");
		cbo.addItem("年龄");
		cbo.addItem("性别");
		cbo.addItem("职称");
		cbo.addItem("部门");
		cbo.addItem("受聘时间");
		cbo.addItem("籍贯");
		cbo.addItem("学位");
		cbo.addItem("政治面貌");
		p1.add(cbo);
		cbo.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
				String con = cbo.getSelectedItem().toString().trim();
				if(con.equals("人员编码")){
					try{
						cbocon.removeAll();
						ResultSet rs = DAO.getEmployeeId();
						while(rs.next()){
							cbocon.addItem(new Integer((rs.getInt("empid"))));
						}
					}catch(Exception ex){
						System.out.println(ex.getMessage());
					}
				}
				if(con.equals("姓名")){
					try{
						cbocon.removeAll();
						ResultSet rs = DAO.getEmployeeName();
						while(rs.next()){
							cbocon.addItem(rs.getString("ename"));
						}
					}catch(Exception ex){
						System.out.println(ex.getMessage());
					}
				}
				if(con.equals("职务")){
					try{
						cbocon.removeAll();
						ResultSet rs = DAO.getDutyName();
						while(rs.next()){
							cbocon.addItem(rs.getString("dutyname"));
						}
					}catch(Exception ex){
						System.out.println(ex.getMessage());
					}
				}
				if(con.equals("年龄")){
					try{
						cbocon.removeAll();
						ResultSet rs = DAO.getEmployeeAge();
						while(rs.next()){
							
							cbocon.addItem(rs.getString("birthday"));
						}
					}catch(Exception ex){
						System.out.println(ex.getMessage());
					}
				}
				if(con.equals("性别")){
					cbocon.removeAll();
					cbocon.addItem("男");
					cbocon.addItem("女");
				}
				if(con.equals("职称")){
					try{
						cbocon.removeAll();
						ResultSet rs = DAO.getSpecialDuty();
						while(rs.next()){
							cbocon.addItem(rs.getString("sdname"));
						}
					}catch(Exception ex){
						System.out.println(ex.getMessage());
					}
				}
				if(con.equals("部门")){
					try{
						cbocon.removeAll();
						ResultSet rs = DAO.getDeptKind();
						while(rs.next()){
							cbocon.addItem(rs.getString("dkind"));
						}
					}catch(Exception ex){
						System.out.println(ex.getMessage());
					}
				}
				if(con.equals("受聘时间")){
					try{
						cbocon.removeAll();
						ResultSet rs = DAO.getHiredate();
						while(rs.next()){
							cbocon.addItem(rs.getString("hiredate"));
						}
					}catch(Exception ex){
						System.out.println(ex.getMessage());
					}
				}
				if(con.equals("籍贯")){
					
				}
				if(con.equals("学位")){
					
				}
				if(con.equals("政治面貌")){
					
				}
				
			}
		});
		p1.add(cbocon);
		p1.add(btnquery);
		btnquery.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
				String con = cbo.getSelectedItem().toString().trim();
				String conc = cbocon.getSelectedItem().toString();
				
			}
		});
		qc.setVisible(true);
		
	}
	private void setupComponent(JComponent component,int gridx,int gridy,
			int gridwidth,int ipadx,boolean fill){
		final GridBagConstraints g = new GridBagConstraints();
	}
}