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

boolean executeFlag;
try {
st.execute(sqlString);
executeFlag = true;
} catch (Exception e) {
executeFlag = false;
System.out.println("sql exception:" + e.getMessage());
}
return executeFlag;
}


public static boolean query(String sqlString) {

try {
rs = null;
//System.out.println(sqlString);
rs = st.executeQuery(sqlString);
} catch (Exception Ex) {
System.out.println("sql exception:" + Ex);
return false;
}
return true;
}
}



//添加删除用户类


package classsource;

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

public class AddDeleteUser extends javax.swing.JInternalFrame {

private JButton butACancel,butDCancel,butDelete,butOk;
private JComboBox cbUserName;
private JLabel jLabel1,jLabel2,jLabel3,jLabel4,jLabel5;
private JPasswordField pas1,pas2,pas3;
private JTextField txtname;

public AddDeleteUser() {
initComponents();
this.setVisible(true);
this.setClosable(true);
this.setSize(268,350);

}

private void initComponents() {

jLabel1 = new JLabel();
jLabel2 = new JLabel();
jLabel3 = new JLabel();
txtname = new JTextField();
pas1 = new JPasswordField();
pas2 = new JPasswordField();
butOk = new JButton();
butACancel = new JButton();
jLabel4 = new JLabel();
cbUserName = new JComboBox();
jLabel5 = new JLabel();
pas3 = new JPasswordField();
butDelete = new JButton();
butDCancel = new JButton();

getContentPane().setLayout(null);


jLabel1.setText("新用户名:");
getContentPane().add(jLabel1);
jLabel1.setBounds(30, 30, 70, 20);

jLabel2.setText("输入密码:");

getContentPane().add(jLabel2);
jLabel2.setBounds(30, 60, 70, 18);

jLabel3.setText("确认密码:");
getContentPane().add(jLabel3);
jLabel3.setBounds(30, 90, 60, 18);

getContentPane().add(txtname);
txtname.setBounds(100, 30, 130, 24);

getContentPane().add(pas1);
pas1.setBounds(100, 60, 130, 24);

getContentPane().add(pas2);
pas2.setBounds(100, 90, 130, 24);

butOk.setText("添加");

getContentPane().add(butOk);
butOk.setBounds(80, 130, 70, 27);

butACancel.setText("清空");
getContentPane().add(butACancel);
butACancel.setBounds(160, 130, 70, 27);

jLabel4.setText("已有用户名:");
getContentPane().add(jLabel4);
jLabel4.setBounds(30, 180, 80, 18);

getContentPane().add(cbUserName);
cbUserName.setBounds(100, 180, 130, 24);

jLabel5.setText("密码:");
getContentPane().add(jLabel5);
jLabel5.setBounds(30, 210, 60, 18);

getContentPane().add(pas3);
pas3.setBounds(100, 216, 130, 24);

butDelete.setText("删除");
getContentPane().add(butDelete);
butDelete.setBounds(79, 260, 70, 27);

butDCancel.setText("清空");
getContentPane().add(butDCancel);
butDCancel.setBounds(160, 260, 70, 27);


//将所有用用户名读出来
Database.joinDB();
String sql="select * from UserInformation";
try{
if(Database.query(sql)){
while(Database.rs.next()){
String name=Database.rs.getString("User_Name");
cbUserName.addItem(name);
}
}
}
catch(Exception e){}

//为添加和取消按钮加事件-----------------------------------------
butOk.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
if(txtname.getText().equals("")){
new JOptionPane().showMessageDialog(null,"用户名不能为空!");
}
else if(pas1.getText().equals("")){
new JOptionPane().showMessageDialog(null,"密码不能为空!");
}
else if(pas1.getText().equals(pas2.getText())){
String sql="insert UserInformation values('"+ txtname.getText() +"','"+ pas1.getText() +"','B')";
try{
if(Database.executeSQL(sql)){
new JOptionPane().showMessageDialog(null,"添加成功！");
cbUserName.addItem(txtname.getText());
}
}
catch(Exception ea){}
}
}
});

butACancel.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
txtname.setText("");
pas
1.setText("");
pas2.setText("");
}
});

//为删除和取消按钮加事件---------------------------------------
butDelete.addActionListen

er(new ActionListener(){
public void actionPerformed(ActionEvent e){
String name="" + cbUserName.getSelectedItem();
String sql="select * from UserInformation where User_Name='"+ name +"'";
try{
if(Database.query(sql)){
Database.rs.next();
String pas=pas3.getText();
String password=Database.rs.getString("Password");
System.out.println(password);
if(pas.equals(password)){
String sdelete="delete from UserInformation where User_Name='"+ name +"'";
if(Database.executeSQL(sdelete)){
new JOptionPane().showMessageDialog(null,"删除成功！");
pas3.setText("");
cbUserName.removeAllItems();
String sql1="select * from UserInformation";
if(Database.query(sql1)){
while(Database.rs.next()){
String name1=Database.rs.getString("User_Name");
cbUserName.addItem(name1);
}
}
}
}
else{
new JOptionPane().showMessageDialog(null,"密码不正确！");
}
}
}
catch(Excep …… 此处隐藏：3987字，全部文档内容请下载后查看。喜欢就下载吧 ……