factory.java

档案管理(java).rar

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.text.*;
import javax.swing.text.*;
import java.sql.*;
import javax.swing.event.*;
import javax.swing.table.*;
import java.util.Vector;

//企业信息窗口
class Factory extends ModleTable implements MouseListener, DocumentListener 
{
	//总面板
	JPanel pane;
	//企业信息面板
	JPanel paneFactory,paneMinxiFactory;
	
	//factory工具条
	JToolBar barFactory;
	JLabel[] lblTool=new JLabel[8];
	//企业明细信息标签
	JLabel lblNo,lblMore;
	JTextField txtNo;
	JLabel[] lblFactory=new JLabel[11];
	JTextField[] txtFactory=new JTextField[10];
	JTextArea areaFactory;
	//招聘信息表格
	LockTableModel lockZhaopin;
	//招聘明细
	JPanel paneMinxizp;
	JLabel lblMinxiNo;
	JTextField txtMinxiNo;
	JLabel[] lblMinxizp=new JLabel[11];
	JTextField[] txtMinxizp=new JTextField[10];
	JTextArea areaMinxizp;
	JFrame f;
	JToolBar barZhaopin;
	JLabel[] toolZhaopin=new JLabel[4];
	
	//更多条件查询面板
	JPanel paneMore,paneMoreFactory,paneMoreZhaopin,paneMoreFactorySearch,paneMoreZhaopinSearch;
	JToolBar barMore;
	LockTableModel lockMoreFactory,lockMoreZhaopin;
	JLabel[] toolMore=new JLabel[3];
	JLabel[] lblMoreFactorySearch=new JLabel[2];
	Choice choice1,choice2,choiceFactory1,choiceFactory2,choiceZhaopin1,choiceZhaopin2;
	JTextField[] txtMoreFactory=new JTextField[2];
	JTextField[] txtMoreZhaopin=new JTextField[2];
	JLabel[] lblMoreZhaopinSearch=new JLabel[3];
	//构造函数
	Factory()
	{
		///////////////////////////////
		//////初始化factory工具条//////
		///////////////////////////////
		barFactory=new JToolBar();
		barFactory.setBorder(BorderFactory.createLoweredBevelBorder());
		barFactory.setBackground(new Color(196,255,196));
		barFactory.setFloatable(false);
		barFactory.setOrientation(JToolBar.VERTICAL);
		//工具条按钮设置
		lblTool[0]=new JLabel("首条记录");
		lblTool[1]=new JLabel("末条记录");
		lblTool[2]=new JLabel("前条记录");
		lblTool[3]=new JLabel("后条记录");
		lblTool[4]=new JLabel("新增记录");
		lblTool[5]=new JLabel("保存记录");
		lblTool[6]=new JLabel("更新记录");
		lblTool[7]=new JLabel("删除记录");
		//工具条加入按钮
		for(int i=0;i<8;i++)
		{
			lblTool[i].addMouseListener(this);
			if(i<4)
			    lblTool[i].setIcon(new ImageIcon("img/tool.gif"));
			else
			    lblTool[i].setIcon(new ImageIcon("img/edit.gif"));    
			lblTool[i].setForeground(new Color(148,139,253));
			JTextField t=new JTextField(2);
			t.setBackground(new Color(239,251,198));
			t.setEditable(false);
			t.setBorder(BorderFactory.createMatteBorder(0,0,0,0,Color.red));
			if(i==0)
			    barFactory.addSeparator();
			barFactory.add(lblTool[i]);
			barFactory.add(t);
		}
		lblTool[5].setEnabled(false);
				
		////////////////////////////
		//////企业信息面板设置//////
		////////////////////////////
		//企业明细信息组件初始化
		lblNo=new JLabel("单位编号查询");
		lblNo.setForeground(Color.red);
		//lblNo.setBorder(BorderFactory.createMatteBorder(1,1,1,1,Color.blue));
		txtNo=new JTextField(10);
		txtNo.getDocument().addDocumentListener(this);
		txtNo.setBackground(new Color(255,255,240));
		txtNo.setBorder(BorderFactory.createMatteBorder(0,0,1,0,Color.blue));
		lblMore=new JLabel("更多条件查询");
		lblMore.addMouseListener(this);
		lblMore.setIcon(new ImageIcon("img/more.gif"));
		lblMore.setForeground(Color.blue);
		lblMore.setBorder(BorderFactory.createMatteBorder(0,0,1,0,Color.blue));
		lblFactory[0]=new JLabel("编号");
	    lblFactory[1]=new JLabel("单位名称");
	    lblFactory[2]=new JLabel("行业");
	    lblFactory[3]=new JLabel("性质");
	    lblFactory[4]=new JLabel("电话");
	    lblFactory[5]=new JLabel("工商执照");
	    lblFactory[6]=new JLabel("地址");
	    lblFactory[7]=new JLabel("联系人");
	    lblFactory[8]=new JLabel("邮编");
	    lblFactory[9]=new JLabel("登记日期");
	    lblFactory[10]=new JLabel("备注");
	    for(int i=0;i<10;i++)
	    {
	    	lblFactory[i].setForeground(new Color(77,199,199));
	    	txtFactory[i]=new JTextField(20);
	    	txtFactory[i].setBackground(new Color(255,255,240));
	    	txtFactory[i].setBorder(BorderFactory.createMatteBorder(0,0,1,0,Color.black));
	    }
	    txtFactory[0].addMouseListener(this);
	    lblFactory[10].setForeground(new Color(77,199,199));
	    areaFactory=new JTextArea(7,51);
	    areaFactory.setBackground(new Color(255,255,240));
	    areaFactory.setBorder(BorderFactory.createMatteBorder(1,1,1,1,Color.black));
	    //企业信息明细面板初始化
		paneMinxiFactory=new JPanel();
		paneMinxiFactory.setBackground(new Color(255,255,240));
		paneMinxiFactory.setBorder(BorderFactory.createLoweredBevelBorder());
		paneMinxiFactory.setLayout(new GridBagLayout());
		GridBagConstraints c=new GridBagConstraints();
		c.gridy=0;
		c.insets=new Insets(5,0,5,5);
		c.anchor=GridBagConstraints.EAST;
		c.gridwidth=2;
		paneMinxiFactory.add(lblNo,c);
		c.gridwidth=1;
		paneMinxiFactory.add(txtNo,c);
		c.gridwidth=2;
		paneMinxiFactory.add(lblMore,c);
		c.gridy++;
		c.gridwidth=1;
		paneMinxiFactory.add(lblFactory[0],c);
		paneMinxiFactory.add(txtFactory[0],c);
		paneMinxiFactory.add(lblFactory[1],c);
		paneMinxiFactory.add(txtFactory[1],c);
		c.gridy++;
		paneMinxiFactory.add(lblFactory[2],c);
	    paneMinxiFactory.add(txtFactory[2],c);
		paneMinxiFactory.add(lblFactory[3],c);
		paneMinxiFactory.add(txtFactory[3],c);
		c.gridy+=8;
		paneMinxiFactory.add(lblFactory[4],c);
	    paneMinxiFactory.add(txtFactory[4],c);
		paneMinxiFactory.add(lblFactory[5],c);
		paneMinxiFactory.add(txtFactory[5],c);
		c.gridy++;
		paneMinxiFactory.add(lblFactory[6],c);
	    paneMinxiFactory.add(txtFactory[6],c);
		paneMinxiFactory.add(lblFactory[7],c);
		paneMinxiFactory.add(txtFactory[7],c);
		c.gridy++;
		paneMinxiFactory.add(lblFactory[8],c);
	    paneMinxiFactory.add(txtFactory[8],c);
		paneMinxiFactory.add(lblFactory[9],c);
		paneMinxiFactory.add(txtFactory[9],c);
		c.gridy++;
		paneMinxiFactory.add(lblFactory[10],c);
		c.gridwidth=5;
		paneMinxiFactory.add(areaFactory,c);
	    //企业信息面板初始化
		paneFactory=new JPanel();
		paneFactory.setBorder(BorderFactory.createLoweredBevelBorder());
		paneFactory.setLayout(new BorderLayout());
		//企业信息面板加入组件
		paneFactory.add(barFactory,BorderLayout.WEST);
		paneFactory.add(paneMinxiFactory,BorderLayout.CENTER);
		////////////////////////
		////招聘信息表格///////
		///////////////////////
		lockZhaopin =new LockTableModel("select * from 招聘信息",1,3);
		lockZhaopin.tableOne.addMouseListener(this);
		lockZhaopin.tableTwo.addMouseListener(this);
		////////////////////////
		//////总面板初始化//////
		////////////////////////
		pane=new JPanel();
		pane.setLayout(new BorderLayout());
		pane.add(paneFactory,BorderLayout.NORTH);
		pane.add(lockZhaopin.scroll,BorderLayout.CENTER);
		getinfo(1);
		//更多条件查询面板
		barMore=new JToolBar();
		barMore.setOrientation(JToolBar.VERTICAL);
		barMore.setBackground(new Color(239,251,198));
		barMore.setFloatable(false);
		barMore.setBorder(BorderFactory.createLoweredBevelBorder());
		toolMore[0]=new JLabel("企业信息列表");
		toolMore[1]=new JLabel("招聘信息列表");
		toolMore[2]=new JLabel("返回上一页");
		for(int i=0;i<3;i++)
		{
			toolMore[i].setIcon(new ImageIcon("img/tool.gif"));
			toolMore[i].setForeground(new Color(148,139,253));
			toolMore[i].addMouseListener(this);
			if(i==2)
			{
			   toolMore[i].setIcon(new ImageIcon("img/home.gif"));
			   toolMore[i].setForeground(Color.blue);
			}
			barMore.addSeparator();
			barMore.addSeparator();
			barMore.add(toolMore[i]);
			barMore.addSeparator();
			
		}
		//panemoreFactory
		//
		paneMoreFactorySearch=new JPanel();
		paneMoreFactorySearch.setBackground(new Color(255,255,240));
		paneMoreFactorySearch.setBorder(BorderFactory.createLoweredBevelBorder());
		paneMoreFactorySearch.setLayout(new FlowLayout());
		//
		lblMoreFactorySearch[0]=new JLabel("一级查询");
		lblMoreFactorySearch[1]=new JLabel("二级查询");
		choice1=new Choice();
		choice1.addItem("OR");
		choice1.addItem("AND");
		
		choiceFactory1=new Choice();
		setchoice(choiceFactory1,"select * from 企业信息");
		choiceFactory2=new Choice();
		setchoice(choiceFactory2,"select * from 企业信息");
		for(int i=0;i<2;i++)
		{
			lblMoreFactorySearch[i].setForeground(new Color(77,199,199));
			txtMoreFactory[i]=new JTextField(15);
			txtMoreFactory[i].setBackground(new Color(255,255,240));
			txtMoreFactory[i].setBorder(BorderFactory.createMatteBorder(0,0,1,0,Color.black));
			txtMoreFactory[i].getDocument().addDocumentListener(this);
		}
		paneMoreFactorySearch.add(lblMoreFactorySearch[0]);
		paneMoreFactorySearch.add(choiceFactory1);
		paneMoreFactorySearch.add(txtMoreFactory[0]);
		paneMoreFactorySearch.add(choice1);
		paneMoreFactorySearch.add(lblMoreFactorySearch[1]);
		paneMoreFactorySearch.add(choiceFactory2);
		paneMoreFactorySearch.add(txtMoreFactory[1]);
		
		lockMoreFactory=new LockTableModel("select * from 企业信息",0,2);
		lockMoreFactory.tableOne.addMouseListener(this);
		lockMoreFactory.tableTwo.addMouseListener(this);
		paneMoreFactory=new JPanel();
		paneMoreFactory.setLayout(new BorderLayout());
		paneMoreFactory.add(paneMoreFactorySearch,BorderLayout.NORTH);
		paneMoreFactory.add(lockMoreFactory.scroll,BorderLayout.CENTER);
		//
		//panemoreZha0pin
		//
		paneMoreZhaopinSearch=new JPanel();
	    paneMoreZhaopinSearch.setBackground(new Color(255,255,240));
		paneMoreZhaopinSearch.setBorder(BorderFactory.createLoweredBevelBorder());
		
		paneMoreZhaopinSearch.setLayout(new FlowLayout());
		//
		lblMoreZhaopinSearch[0]=new JLabel("一级查询");
		lblMoreZhaopinSearch[1]=new JLabel("二级查询");
		
		choice2=new Choice();
		
		choice2.addItem("OR");
		choice2.addItem("AND");
		
		choiceZhaopin1=new Choice();
		setchoice(choiceZhaopin1,"select * from 招聘信息");
		choiceZhaopin2=new Choice();
		setchoice(choiceZhaopin2,"select * from 招聘信息");
		for(int i=0;i<2;i++)
		{
			lblMoreZhaopinSearch[i].setForeground(new Color(77,199,199));
			
			txtMoreZhaopin[i]=new JTextField(15);
			txtMoreZhaopin[i].setBackground(new Color(255,255,240));
			txtMoreZhaopin[i].setBorder(BorderFactory.createMatteBorder(0,0,1,0,Color.black));
			txtMoreZhaopin[i].getDocument().addDocumentListener(this);
		}
		paneMoreZhaopinSearch.add(lblMoreZhaopinSearch[0]);
		paneMoreZhaopinSearch.add(choiceZhaopin1);
		paneMoreZhaopinSearch.add(txtMoreZhaopin[0]);
		paneMoreZhaopinSearch.add(choice2);
		paneMoreZhaopinSearch.add(lblMoreZhaopinSearch[1]);
		paneMoreZhaopinSearch.add(choiceZhaopin2);
		paneMoreZhaopinSearch.add(txtMoreZhaopin[1]);
		
		lockMoreZhaopin=new LockTableModel("select * from 招聘信息",0,2);
		lockMoreZhaopin.tableOne.addMouseListener(this);
		lockMoreZhaopin.tableTwo.addMouseListener(this);
		paneMoreZhaopin=new JPanel();
		paneMoreZhaopin.setLayout(new BorderLayout());
		paneMoreZhaopin.add(paneMoreZhaopinSearch,BorderLayout.NORTH);
		paneMoreZhaopin.add(lockMoreZhaopin.scroll,BorderLayout.CENTER);
		
		paneMore=new JPanel();
		paneMore.setLayout(new BorderLayout());
		paneMore.add(barMore,BorderLayout.WEST);
		paneMore.add(paneMoreFactory,BorderLayout.CENTER);
	}
	////////////////////////////////////////////////
	////////////////////////////////////////////////
	////////////////////////////////////////////////
	//招聘信息明细
	void showzhaopin()
	{
		/////////////////////////
		//招聘信息明细面板///////
		/////////////////////////
	    paneMinxizp=new JPanel();
	    paneMinxizp.setBorder(BorderFactory.createLoweredBevelBorder());
	    paneMinxizp.setBackground(new Color(255,255,240));
	    paneMinxizp.setBorder(BorderFactory.createLoweredBevelBorder());
	    lblMinxiNo=new JLabel("单位编号");
	    lblMinxiNo.setForeground(Color.red);
	    txtMinxiNo=new JTextField(15);
	    txtMinxiNo.setEditable(false);
	    txtMinxiNo.setBorder(BorderFactory.createMatteBorder(0,0,1,0,Color.blue));
	    txtMinxiNo.setBackground(new Color(255,255,240));
	    lblMinxizp[0]=new JLabel("招聘专业");
	    lblMinxizp[1]=new JLabel("招聘人数");
	    lblMinxizp[2]=new JLabel("待遇");
	    lblMinxizp[3]=new JLabel("登记日期");
	    lblMinxizp[4]=new JLabel("年龄");
	    lblMinxizp[5]=new JLabel("身高");
	    lblMinxizp[6]=new JLabel("视力");
	    lblMinxizp[7]=new JLabel("文化程度");
	    lblMinxizp[8]=new JLabel("工作年限");
	    lblMinxizp[9]=new JLabel("技术等级");
	    lblMinxizp[10]=new JLabel("其他要求");
	    for(int i=0;i<10;i++)
	    {
	    	lblMinxizp[i].setForeground(new Color(77,199,199));
	    	txtMinxizp[i]=new JTextField(15);
	    	txtMinxizp[i].setBackground(new Color(255,255,240));
	    	txtMinxizp[i].setBorder(BorderFactory.createMatteBorder(0,0,1,0,Color.black));
	    }
	    lblMinxizp[10].setForeground(new Color(77,199,199));
	    areaMinxizp=new JTextArea(5,38);
	    areaMinxizp.setBackground(new Color(255,255,240));
	    areaMinxizp.setBorder(BorderFactory.createMatteBorder(1,1,1,1,Color.black));
	    //加入控件
		paneMinxizp.setLayout(new GridBagLayout());
		GridBagConstraints zp=new GridBagConstraints();
		zp.gridy=0;
		zp.insets=new Insets(5,0,5,5);
		paneMinxizp.add(lblMinxiNo,zp);
		paneMinxizp.add(txtMinxiNo,zp);
		zp.gridy++;
		paneMinxizp.add(lblMinxizp[0],zp);
		paneMinxizp.add(txtMinxizp[0],zp);
		paneMinxizp.add(lblMinxizp[1],zp);
		paneMinxizp.add(txtMinxizp[1],zp);
		zp.gridy++;
		paneMinxizp.add(lblMinxizp[2],zp);
	    paneMinxizp.add(txtMinxizp[2],zp);
		paneMinxizp.add(lblMinxizp[3],zp);
		paneMinxizp.add(txtMinxizp[3],zp);
		zp.gridy+=8;
		paneMinxizp.add(lblMinxizp[4],zp);
	    paneMinxizp.add(txtMinxizp[4],zp);
		paneMinxizp.add(lblMinxizp[5],zp);
		paneMinxizp.add(txtMinxizp[5],zp);
		zp.gridy++;
		paneMinxizp.add(lblMinxizp[6],zp);
	    paneMinxizp.add(txtMinxizp[6],zp);
		paneMinxizp.add(lblMinxizp[7],zp);
		paneMinxizp.add(txtMinxizp[7],zp);