《数据库应用》课程设计人事管理系统(java源代码)(5)

oolAge");
System.out.println(eSchoolAge);
String eEnterDate=Database.rs.getString("E_EnterDate");
System.out.println(eEnterDate);
String eInDueFormDate=Database.rs.getString("E_InDueFormDate");
System.out.println(eInDueFormDate);
String eDepartment=Database.rs.getString("E_Department");
System.out.println(eDepartment);
String eHeadship=Database.rs.getString("E_Headship");
System.out.println(eHeadship);
String eEstate=Database.rs.getString("E_Estate");
System.out.println(eEstate);
String eRemark=Database.rs.getString("E_Remark");
System.out.println(eRemark);

Vector v=new Vector();
v.add(eNumber);
v.add(eName);
v.add(eSex);
v.add(eBornDate);
v.add(eMarriage);
v.add(ePoliticsVisage);
v.add(eSchoolAge);
v.add(eEnterDate);
v.add(eInDueFormDate);
v.add(eDepartment);
v.add(eHeadship);
v.add(eEstate);
v.add(eRemark);
dtm.addRow(v);
}
}
catch(Exception eB){
}
}
}
});

setSize(700,480);
this.setClosable(true);
setVisible(true);
}
}



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);

JScrollPane sl = new JScrollPane(table);


dtm.setColumnCount(3);
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);
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(sl);

//设置边框
setxtid.setBorder(BorderFactory.createLineBorder(Color.black));
setxtn

ame.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);

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);

Vector v=new Vector();
v.add(num);
v.add(name);
v.add(count);
dtm.addRow(v);

}
}
catch(Exception ee){}
}
}
});

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

//奖惩查询类

package classsource;

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

public class E
PIQ extend …… 此处隐藏：4046字，全部文档内容请下载后查看。喜欢就下载吧 ……