tiq.java

Java+sqlserver2000做的员工管理系统

//培训查询类


package classsource;

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

public class TIQ extends JInternalFrame{

	JLabel lb1=new JLabel("培 训 信 息 查 询");
   	JLabel lb2=new JLabel("培训编号:");
   	JLabel lb3=new JLabel("员工姓名:");
   	JTextField ttxtid=new JTextField(10);
   	JTextField ttxtname=new JTextField(10);
   	JButton btn1=new JButton("查询");

   	JTable table;
	DefaultTableModel dtm;
	String columns[] = {"培训编号","培训内容","员工姓名","培训天数","培训费用"};
	public TIQ(){
		setTitle("培 训 信 息 查 询");

		dtm=new DefaultTableModel();
		table = new JTable(dtm);
		JScrollPane s1=new JScrollPane(table);
		//sl.HORIZONTAL_SCROLLBAR_ALWAYS;
		//sl.VERTICAL_SCROLLBAR_ALWAYS;
		dtm.setColumnCount(5);
		dtm.setColumnIdentifiers(columns);

		getContentPane().setLayout(null);
		lb1.setBounds(200,10,300,30);
		lb1.setFont(new Font("宋体",Font.BOLD,24));
		getContentPane().add(lb1);

		Font f=new Font("宋体",Font.PLAIN,12);
		lb2.setBounds(10,60,80,25);
		lb2.setFont(f);
		getContentPane().add(lb2);
		ttxtid.setBounds(80,60,80,23);
		ttxtid.setFont(f);
		getContentPane().add(ttxtid);
		lb3.setBounds(10,90,80,25);
		lb3.setFont(f);
   	    getContentPane().add(lb3);
   	    ttxtname.setBounds(80,90,80,23);
   	    ttxtname.setFont(f);
   	    getContentPane().add(ttxtname);
   	    btn1.setBounds(90,130,60,25);
   	    btn1.setFont(f);
   	    getContentPane().add(btn1);

		s1.setBounds(180,60,425,290);
		getContentPane().add(s1);

//设置边框---------------------------------------------------------------------------
		ttxtid.setBorder(BorderFactory.createLineBorder(Color.black));
   	    ttxtname.setBorder(BorderFactory.createLineBorder(Color.black));
   	    btn1.setBorder(BorderFactory.createRaisedBevelBorder());
		s1.setBorder(BorderFactory.createLineBorder(Color.black));

 //___________连接数据库_______________________________________________________________
		Database.joinDB();

		String Tim="select * from TrainInformation";
		if(Database.query(Tim)){
			System.out.println(Tim);
			try{
				while(Database.rs.next()){
					String number=(""+Database.rs.getString("T_Number"));
					System.out.println(number);
					String Content=Database.rs.getString("T_Content");
					System.out.println(Content);
					String name=Database.rs.getString("T_Name");
					System.out.println(name);
					String date=Database.rs.getString("T_Date");
					System.out.println(date);
					String Money=Database.rs.getString("T_Money");
					System.out.println(Money);

					Vector v=new Vector();
					v.add(number);
					v.add(Content);
					v.add(name);
					v.add(date);
					v.add(Money);

					dtm.addRow(v);


				}
			}
			catch(Exception eTIQ){
			  System.out.println("初始化表格失败！");
			}
		}
//为查询按钮加事件--------------------------------------------------------
        btn1.addActionListener(new ActionListener(){
        	public void actionPerformed(ActionEvent e){
        		System.out.println("查询按钮加事件");
        		String STIQ;
        		int rc=dtm.getRowCount();
        		for(int i=0;i<rc;i++){
        			dtm.removeRow(0);
        		}
      //------------------------
        		if(ttxtid.getText().equals("")&&ttxtname.getText().equals("")){
        		   STIQ="select * from TrainInformation";
        		}
        		else if(ttxtname.getText().equals("")){
        			STIQ="select * from TrainInformation where T_Number = '" + ttxtid.getText() +"'";
        			}
        		else{
        		   STIQ="select * from TrainInformation where T_Number = '" + ttxtid.getText() +"' or T_Name like '%"+ ttxtname.getText() +"%'";
          		}
        		System.out.println(STIQ);
        		if(Database.query(STIQ)){
        			try{
						while(Database.rs.next()){
							String number=(""+Database.rs.getString("T_Number"));
							System.out.println(number);
							String Content=Database.rs.getString("T_Content");
							System.out.println(Content);
							String name=Database.rs.getString("T_Name");
							System.out.println(name);
							String date=Database.rs.getString("T_Date");
							System.out.println(date);
							String Money=Database.rs.getString("T_Money");
							System.out.println(Money);

							Vector v=new Vector();
							v.add(number);
							v.add(Content);
							v.add(name);
							v.add(date);
							v.add(Money);

							dtm.addRow(v);


						}
        			}
        			catch(Exception eT){}

        		}
        	}

        });

		setSize(630,400);
		this.setClosable(true);
		setVisible(true);
		}
	}