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

try{
if(Database.query(sql)){
while(Database.rs.next()){
String name=Database.rs.getString("User_Name");
tf.addItem(name);
}
}
}
catch(Exception e){}

//为确定取消按钮加事件
b1.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){

String name="" + tf.getSelectedItem();
System.out.println(name);
String sql="select * from UserInformation where User_Name='"+ name +"'";
System.out.println(sql);
try{
if(Database.query(sql)){
Database.rs.next();
String ps1=pas1.getText();
String password=Database.rs.getString("Password");
if(ps1.equals(password)){
if(pas2.getText().equals(pas3.getText())){
String supdate="update UserInformation set Password='"+ pas3.getText()+"' where User_Name='"+ name +"'";
Database.executeSQL(supdate);
new JOptionPane().showMessageDialog(null,"密码更改成功！");
}
else{
new JOptionPane().showMessageDialog(null,"两次密码不同！");
}
}
else{
new JOptionPane().showMessageDialog(null,"旧密码不正确！");
}
}
}
catch(Exception el){
System.out.println(el);
}
}
});
b2.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
pas1.setText("");
pas2.setText("");
pas3.setText("");
}
});
}
}


//关于类
package classsource;

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

public class About extends JInternalFrame {
JLabel label = new JLabel("运行环境：Windows");
JLabel labe2 = new JLabel("开发语言：JAVA");
JLabel labe3 = new JLabel("数据库类型：SqlServer2000");

public About(){
setT
itle("关于");
Container con=getContentPane();
con.setLayout(new GridLayout(4,1));
con.add(label);
con.add(labe2);
con.add(labe3);

con.setBackground(Color.white);

setResizable(false);
setSize(380,220);
setVisible(true);
setClosable(true);
}
}

//员工信息查询类
package classsource;

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

public class BIQ extends JInternalFrame{

JLabel lbl1=new JLabel("基 本 信 息 查 询");
JLabel lbl2=new JLabel("员工编号：");
JLabel lbl3=new JLabel("员工姓名：");
JTextField btxtid=new JTextField(10);
JTextField btxtname=new JTextField(10);
JButton btn1=new JButton("查询");

JTable table;
DefaultTableModel dtm;

String columns[] = {"员工编号","员工姓名"," 性别 ","出生日期","婚姻状况","政治面貌"," 学历 ","进入公司时间","转正时间"," 部门 "," 职务 ","员工状态"," 备注 "};
public BIQ(){
setTitle("基 本 信 息 查 询");

dtm = new DefaultTableModel();
table = new JTable(dtm);


JScrollPane sl = new JScrollPane();
sl.getViewport().add(table);
dtm.setColumnCount(5);
dtm.setColumnIdentifiers(columns);

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

Font f=new Font("宋体",Font.PLAIN,12);
lbl2.setBounds(10,60,80,25);
lbl2.setFont(f);
getContentPane().add(lbl2);
btxtid.setBounds(80,60,80,23);
btxtid.setFont(f);
getContentPane().add(btxtid);
lbl3.setBounds(10,90,80,25);
lbl3.setFont(f);
getContentPane().add(lbl3);
btxtname.setBounds(80,90,80,23);
btxtname.setFont(f);
getContentPane().add(btxtname);
btn1.setBounds(90,130,60,25);
btn1.setFont(f);
getContentPane().add(btn1);


sl.setBounds(180,60,500,370);
getContentPane().add(sl);

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

//----连接数据库--------------------------------------------------------------------------
Database.joinDB();
String sql="select * from EmployeeInformation";
if(Database.query(sql)){
System.out.println(sql);
try{
while(Database.rs.next()){
String eNumber=(""+Database.rs.getInt("E_Number"));
System.out.println(eNumber);
String eName=Database.rs.getString("E_Name");
System.out.println(eName);
String eSex=Database.rs.getString("E_Sex");
System.out.println(eSex);
Stri
ng eBornDate=Database.rs.getString("E_BornDate");
System.out.println(eBornDate);
String eMarriage=Database.rs.getString("E_Marr

iage");
System.out.println(eMarriage);
String ePoliticsVisage=Database.rs.getString("E_PoliticsVisage");
System.out.println(ePoliticsVisage);
String eSchoolAge=Database.rs.getString("E_SchoolAge");
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" …… 此处隐藏：3960字，全部文档内容请下载后查看。喜欢就下载吧 ……