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

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

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.createRaisedB
evelBorder());
s1.setBorder(BorderFactory.createLineBorder(Color.black));

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

String Tim="select * from Trai

nInformation";
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);
}
}


//部门管理类
package classsource;

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

public class Departmentmanage extends JInternalFrame{

JLabel lb1 = new JLabel("部 门 信 息");
JLabel lb2 = new JLabel("部门编号：");
JLabel lb3 = new J
Label("部门名称：");
JLabel lb4 = new JLabel("部门人数：");
JTextField tnumber = new JTextField();
JTextField tname = new JTextFiel

d();
JTextField tcount = new JTextField();
JButton btright = new JButton("<<");
JButton btleft = new JButton(">>");
JButton btdelet = new JButton("删除");
JButton btamend = new JButton("修改");
JButton btsave = new JButton("保存");
JButton btadd = new JButton("添加");
public Departmentmanage(){

setTitle("部门信息管理!");
btsave.setEnabled(false);

getContentPane().setLayout(null);
Font f = new Font("新宋体",0,14);
btleft.setFont(f);

lb1.setFont(new java.awt.Font("新宋体", 1, 18));
lb1.setForeground(new Color(0, 51, 255));
getContentPane().add(lb1);
lb1.setBounds(110, 20, 160, 30);

lb2.setFont(f);
getContentPane().add(lb2);
lb2.setBounds(40, 85, 70, 20);
lb3.setFont(f);
getContentPane().add(lb3);
lb3.setBounds(40, 125, 70, 20);
lb4.setFont(f);
getContentPane().add(lb4);
lb4.setBounds(40,165,70,20);

getContentPane().add(tnumber);
tnumber.setBounds(155,85,100,23);
getContentPane().add(tname);
tname.setBounds(155 …… 此处隐藏：3712字，全部文档内容请下载后查看。喜欢就下载吧 ……