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 Letter extends LetterModel implements MouseListener, DocumentListener
{
	//總面板
	JPanel pane;
	//介紹信工具條
	JToolBar barLetter;
	JLabel[] lblTool=new JLabel[8];
	//介紹信明細面板
	JPanel paneLetter;
	JLabel[] lblMinxi=new JLabel[18];
	JTextField[] txtMinxi=new JTextField[16];
	JLabel lblTitle;
	//簡單查詢面板
	JPanel paneSimple;
	Choice choiceSimple;
	JTextField txtSimple;
	JLabel lblSimple,lblMore;
	//介紹信列表面板
	JPanel paneTable,paneTableSearch;
	JToolBar[] barTable=new JToolBar[2];
	Choice[] choice=new Choice[3];
	JLabel[] lblTable=new JLabel[2];
	JTextField[] txtTable=new JTextField[2];
	LockLetter lockMore;
	JLabel lblBack;
 	//構造函數
	Letter()
	{
		//初始化工具條
		barLetter=new JToolBar();
		barLetter.setBorder(BorderFactory.createLoweredBevelBorder());
		barLetter.setBackground(new Color(196,255,196));
		barLetter.setFloatable(false);
		barLetter.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)
			    barLetter.addSeparator();
			barLetter.add(lblTool[i]);
			barLetter.add(t);
		}
		lblTool[5].setEnabled(false);
		//介紹信明細面板初始化
		 lblTitle=new JLabel("介紹信");
		 lblTitle.setFont(new Font("隸書",Font.BOLD,30));
		 lblTitle.setForeground(new Color(89,89,255));		
		 lblMinxi[0]=new JLabel("編號:");
		 lblMinxi[1]=new JLabel("     茲介紹");
		 lblMinxi[2]=new JLabel("同志,身份證:");
         lblMinxi[3]=new JLabel("性別:");
         lblMinxi[4]=new JLabel("出生年月:");
         lblMinxi[5]=new JLabel("學歷:");
         lblMinxi[6]=new JLabel("所學專業:");
         lblMinxi[7]=new JLabel("籍貫:");
         lblMinxi[8]=new JLabel("前 往 貴 處");
         lblMinxi[9]=new JLabel("應 聘");
         lblMinxi[10]=new JLabel("崗位,工資:");
         lblMinxi[11]=new JLabel("其他待遇:");
         lblMinxi[12]=new JLabel("具體事項由雙方訂立《勞動合同》時商定，請給予接洽為荷!");
         lblMinxi[13]=new JLabel("單位:");
         lblMinxi[14]=new JLabel("地址:");
         lblMinxi[15]=new JLabel("電話:");
         lblMinxi[16]=new JLabel("聯系人:");
         lblMinxi[17]=new JLabel("介紹日期:");
         for(int i=0;i<18;i++)
         {
         	if(i==0)
         	   lblMinxi[i].setForeground(Color.red);
         	else   
               lblMinxi[i].setForeground(new Color(193,132,255));
         }
         for(int i=0;i<16;i++)
         {
         	txtMinxi[i]=new JTextField(10);
         	if(i==2||i==5||i==6||i==9||i==10)
         	   txtMinxi[i]=new JTextField(15);
         	if(i==7||i==11||i==12)
         	   txtMinxi[i]=new JTextField(40);
         	if(i==13)
         	   txtMinxi[i]=new JTextField(30); 
         	txtMinxi[i].setBackground(new Color(255,255,240));
         	if(i==0)
         	{
         	  
         	  txtMinxi[i].setBorder(BorderFactory.createMatteBorder(0,0,1,0,Color.red));        
              
            }
           	else
         	  txtMinxi[i].setBorder(BorderFactory.createMatteBorder(0,0,1,0,Color.blue));        
         }
         //初始化介紹信面板
         paneLetter=new JPanel();
         paneLetter.setBackground(new Color(255,255,240));
         paneLetter.setBorder(BorderFactory.createLoweredBevelBorder());
         paneLetter.setLayout(new GridBagLayout());
         GridBagConstraints c=new GridBagConstraints();
         //介紹信面板加入控件
         c.gridx=0;
		 c.gridy=0;
		 c.gridwidth=6;
		 c.gridheight=1;
		 c.insets=new Insets(8,0,8,8);
		 paneLetter.add(lblTitle,c);
		 //第二行
		
		 c.gridwidth=5;
		 c.anchor=GridBagConstraints.EAST;
		 c.gridy++;
		
	     paneLetter.add(lblMinxi[0],c);
		 c.gridx++;
		 c.gridwidth=6;
		 paneLetter.add(txtMinxi[0],c);
		
		 //第三行
		 c.gridwidth=1;
		 c.anchor=GridBagConstraints.WEST;
		 c.gridx=0;
		 c.gridy++;
		 paneLetter.add(lblMinxi[1],c);
		 c.gridx++;
		 paneLetter.add(txtMinxi[1],c);
		 c.gridx++;
		 paneLetter.add(lblMinxi[2],c);
		 c.gridx++;
		 paneLetter.add(txtMinxi[2],c);
		 c.anchor=GridBagConstraints.EAST;
		 c.gridx++;
		 paneLetter.add(lblMinxi[3],c);
		 c.gridx++;
		 paneLetter.add(txtMinxi[3],c);
		 //第四行
		 c.anchor=GridBagConstraints.WEST;
		 c.gridy++;
		 c.gridx=0;
		 paneLetter.add(lblMinxi[4],c);
		 c.gridx++;
		 paneLetter.add(txtMinxi[4],c);
		 c.gridx++;
		 paneLetter.add(lblMinxi[5],c);
		 c.gridx++;
		 paneLetter.add(txtMinxi[5],c);
		 c.gridx++;
		 paneLetter.add(lblMinxi[6],c);
		 c.gridx++;
		 paneLetter.add(txtMinxi[6],c);
		 //第五行
		 c.gridy++;
		 c.gridx=0;
		 paneLetter.add(lblMinxi[7],c);
		 c.gridx++;
		 c.gridwidth=4;
		 c.anchor=GridBagConstraints.EAST;
		 paneLetter.add(txtMinxi[7],c);
		 c.gridwidth=6;
		 c.anchor=GridBagConstraints.EAST;
		 paneLetter.add(lblMinxi[8],c);
		 //第六行
		 c.anchor=GridBagConstraints.WEST;
		 c.gridx=0;
		 c.gridy++;
		 paneLetter.add(lblMinxi[9],c);
		 c.gridx++;
		 paneLetter.add(txtMinxi[8],c);
		 c.gridx++;
	   	 paneLetter.add(lblMinxi[10],c);
		 c.gridx++;
		 paneLetter.add(txtMinxi[9],c);
		 c.gridx++;
		 paneLetter.add(lblMinxi[11],c);
		 c.gridx++;
		 c.anchor=GridBagConstraints.EAST;
		 paneLetter.add(txtMinxi[10],c);
		 //第七行
		 c.gridx=0;
		 c.gridy++;
		 c.anchor=GridBagConstraints.WEST;
		 paneLetter.add(lblMinxi[12],c);
		 //第八行
		 c.gridy++;
		 paneLetter.add(lblMinxi[13],c);
		 c.gridx++;
		 paneLetter.add(txtMinxi[11],c);
		 //第九行
		 c.gridx=0;
		 c.gridy++;
		 paneLetter.add(lblMinxi[14],c);
		 c.gridx++;
		 paneLetter.add(txtMinxi[12],c);
		 //第十行
		 c.gridx=0;
		 c.gridy++;
		 paneLetter.add(lblMinxi[15],c);
		 c.gridx++;
		 c.gridwidth=3;
		 paneLetter.add(txtMinxi[13],c);
		 c.gridwidth=4;
		 c.anchor=GridBagConstraints.EAST;
		 paneLetter.add(lblMinxi[16],c);
		 c.gridwidth=6;
		 paneLetter.add(txtMinxi[14],c);
		 //第十一行
		 c.gridx=0;
		 c.gridy++;
		 c.anchor=GridBagConstraints.WEST;
		 paneLetter.add(lblMinxi[17],c);
		 c.gridx++;
		 paneLetter.add(txtMinxi[15],c);
		 	//簡單查詢面板
		paneSimple=new JPanel();
		paneSimple.setLayout(new FlowLayout());
		paneSimple.setBackground(new Color(255,255,240));
		paneSimple.setBorder(BorderFactory.createMatteBorder(1,0,1,0,Color.red));
		lblSimple=new JLabel("簡單查詢");
		lblSimple.setForeground(Color.orange);
		lblMore=new JLabel("                        更多條件查詢");
	    lblMore.setForeground(Color.blue);
	    lblMore.setIcon(new ImageIcon("img/more.gif"));
	    lblMore.addMouseListener(this);
	    //lblMore.setHorizontalAlignment(SwingConstants.RIGHT);
	    lblMore.setHorizontalTextPosition(SwingConstants.LEFT);
	    choiceSimple=new Choice();
	    choiceSimple.addItem("編號");
	    choiceSimple.addItem("姓名");
		txtSimple=new JTextField(20);
		txtSimple.setBackground(new Color(255,255,240));
		txtSimple.getDocument().addDocumentListener(this);
		txtSimple.setBorder(BorderFactory.createMatteBorder(0,0,1,0,Color.blue));
		paneSimple.add(lblSimple);
		paneSimple.add(choiceSimple);
		paneSimple.add(txtSimple);
		paneSimple.add(lblMore);
		c.gridy++;
		paneLetter.add(paneSimple,c); 
		//總面板初始化
		pane=new JPanel();
		pane.setLayout(new BorderLayout());
		pane.add(barLetter,BorderLayout.WEST);
		pane.add(paneLetter,BorderLayout.CENTER);
		getinfo(1);
		//介紹信列表面板
		///////////////////////
		paneTableSearch=new JPanel();
		paneTableSearch.setBackground(Color.orange);
		
		paneTableSearch.setLayout(new FlowLayout());
		lblTable[0]=new JLabel("一級查詢");
		lblTable[1]=new JLabel("二級查詢");
		for(int i=0;i<3;i++)
		{
		    choice[i]=new Choice();
		    if(i!=1)
		       setchoice(choice[i],"select * from 介紹信");
		    else
		    {
		       choice[i].addItem("OR");
		       choice[i].addItem("AND");
		    }
		    choice[i].setForeground(new Color(89,89,255));
		          
		}
		for(int i=0;i<2;i++)
		{
			lblTable[i].setForeground(new Color(89,89,255));
			barTable[i]=new JToolBar();
			barTable[i].setBackground(Color.orange);
			barTable[i].setBorder(null);
			barTable[i].setFloatable(false);
		
			JTextField t=new JTextField(10);
			t.setBorder(BorderFactory.createMatteBorder(0,4,0,4,Color.orange));
			t.setBackground(new Color(255,255,240));
			t.setEditable(false);
			barTable[i].add(t);
			txtTable[i]=new JTextField(10);
			txtTable[i].setBorder(BorderFactory.createMatteBorder(0,0,1,0,Color.blue));
			txtTable[i].setBackground(Color.orange);
			txtTable[i].getDocument().addDocumentListener(this);
		}
		paneTableSearch.add(lblTable[0]);
		paneTableSearch.add(choice[0]);
		paneTableSearch.add(txtTable[0]);
		paneTableSearch.add(choice[1]);
		paneTableSearch.add(lblTable[1]);
		paneTableSearch.add(choice[2]);
		paneTableSearch.add(txtTable[1]);
		lblBack=new JLabel("返回上一頁");
		lblBack.setIcon(new ImageIcon("img/more.gif"));
		lblBack.addMouseListener(this);
		lblBack.setForeground(Color.red);
		paneTableSearch.add(lblBack);
		
		paneTable=new JPanel();
		paneTable.setLayout(new BorderLayout());
	
		
		paneTable.add(barTable[0],BorderLayout.WEST);
		paneTable.add(paneTableSearch,BorderLayout.NORTH);
		lockMore=new LockLetter("select * from 介紹信",0,3);
		lockMore.tableOne.addMouseListener(this);
		lockMore.tableTwo.addMouseListener(this);
		paneTable.add(lockMore.scroll,BorderLayout.CENTER);
		paneTable.add(barTable[1],BorderLayout.EAST);
	}
	//set choice
   void setchoice(Choice c,String str)
   {
   	  DataBase db=new DataBase();
   	  db.GetResultSet(str);
   	  try
   	  {
	   	  for(int i=0;i<db.rsmd.getColumnCount();i++)
	   	      c.addItem(db.rsmd.getColumnName(i+1));
	   	  db.st.close();    
	  }catch(SQLException e){}
   	      
   }
    //讀取介紹信信息
    void getinfo(int row)
    {
    	DataBase db=new DataBase();
    	db.GetResultSet("select * from 介紹信");
    	try
    	{
    		db.rs.absolute(row);
    		for(int i=2;i<=db.rsmd.getColumnCount();i++)
    		    txtMinxi[i-2].setText(db.rs.getString(i));
    		db.st.close();    
    	}catch(SQLException e){}
    }
	public void mouseClicked(MouseEvent parm1) 
	{
		//表格復選框代碼
		if(parm1.getClickCount()==1&&parm1.getSource()==lockMore.tableOne)
		{
			Point pt=parm1.getPoint();//得到鼠標坐標
	    	int row=lockMore.tableOne.rowAtPoint(pt);//得到該坐標表格行號
	    	String tstr=lockMore.tableOne.getValueAt(row,0).toString().trim();
	    	String tname=lockMore.tableOne.getValueAt(row,1).toString();
			if(tstr=="true")
			{
				DataBase dt=new DataBase();
				try
				{
					dt.GetResultSet("select * from 介紹信 ");