diq.java

Java+sqlserver2000做的员工管理系统

//部门查询类



package classsource;

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

public class DIQ extends JInternalFrame{

	JLabel lb1=new JLabel("部 门 信 息 查 询");
   	JLabel lb2=new JLabel("部门编号：");
   	JLabel lb3=new JLabel("部门名称：");
   	JTextField setxtid=new JTextField(10);
   	JTextField setxtname=new JTextField(10);
   	JButton btn1=new JButton("查询");

   	JTable table;
	DefaultTableModel dtm;
	String columns[] = {"部门编号","部门名称","部门人数"};
	public DIQ(){
		setTitle("部 门 信 息 查 询");

		dtm = new DefaultTableModel();
		table = new JTable(dtm);
		//table.set PreferredScrollableViewportSize(new Dimension(400, 80));
        JScrollPane sl = new JScrollPane(table);


        dtm.setColumnCount(3);
		dtm.setColumnIdentifiers(columns);
		//dtm.insertRow(0,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);
		setxtid.setBounds(80,60,80,23);
		setxtid.setFont(f);
		getContentPane().add(setxtid);
		lb3.setBounds(10,90,80,25);
		lb3.setFont(f);
   	    getContentPane().add(lb3);
   	    setxtname.setBounds(80,90,80,23);
   	    setxtname.setFont(f);
   	    getContentPane().add(setxtname);
   	    btn1.setBounds(90,130,60,25);
   	    btn1.setFont(f);
   	    getContentPane().add(btn1);

		sl.setBounds(180,60,425,290);
		//getContentPane().add(table);
		getContentPane().add(sl);

//设置边框
		setxtid.setBorder(BorderFactory.createLineBorder(Color.black));
   	    setxtname.setBorder(BorderFactory.createLineBorder(Color.black));
   	    btn1.setBorder(BorderFactory.createRaisedBevelBorder());
		sl.setBorder(BorderFactory.createLineBorder(Color.black));

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

//为表格初使化数据------------------------------------------------------------
         String csf="select * from DepartmentInformation";
         if(Database.query(csf)){
         	try{
         		while(Database.rs.next()){
         			        					String num = ("" + Database.rs.getInt("D_Number"));
        					System.out.println(num);
        					String name = Database.rs.getString("D_Name");
        					System.out.println(name);
        					String count = Database.rs.getString("D_Count");
        					System.out.println(count);
        				//	String result[]=new String[3];
        				//	result[1] =num;
        				//	result[2] =name;
        				//	result[3] =count;
        				//1用集合
        					Vector v=new Vector();
        					v.add(num);
        					v.add(name);
        					v.add(count);
        					dtm.addRow(v);

         			}
         		}
         	catch(Exception ecsf){
         		System.out.println("初使化表格数据出错!");}
         	}
//------------------------------------------------------------------------------

//为查询按钮加事件------------------------------------------------------
        btn1.addActionListener(new ActionListener(){
        	public void actionPerformed(ActionEvent e){
        		String sql;
        		int rc=dtm.getRowCount();
        		//System.out.println(dtm.getRowCount());
        	    	for(int i=0;i<rc;i++){
        						dtm.removeRow(0);
        						}
        		if(setxtid.getText().equals("")&&setxtname.getText().equals("")){
        			sql="select * from DepartmentInformation";
        			}
        		else if(setxtname.getText().equals("")){
        			sql = "select * from DepartmentInformation where D_Number = '" + setxtid.getText() +"'";
        			}
        		else{
        		sql = "select * from DepartmentInformation where D_Number = '" + setxtid.getText() +"' or D_Name like '%"+ setxtname.getText() +"%'";
        		    }

        		System.out.println(sql);
        			if(Database.query(sql)){
        				try{
        				while(Database.rs.next()){
        					String num = ("" + Database.rs.getInt("D_Number"));
        					System.out.println(num);
        					String name = Database.rs.getString("D_Name");

        					System.out.println(name);
        					String count = Database.rs.getString("D_Count");
        					System.out.println(count);
        				//	String result[]=new String[3];
        				//	result[1] =num;
        				//	result[2] =name;
        				//	result[3] =count;
        				//1用集合
        					Vector v=new Vector();
        					v.add(num);
        					v.add(name);
        					v.add(count);
        					dtm.addRow(v);

        				//2用数组
        					//String result[]={num,name,count};
        					//dtm.addRow(result);
        					}
        				  }
        				 catch(Exception ee){}
        				}
        		}
        	});

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