📄 kingframe1.java
字号:
//更换用户(完成)
public void jMenuItem6_actionPerformed(ActionEvent e) {
if (kingFrame1obj) {
kingFrame1obj = false;
jTextField1.setText("");
jPasswordField1.setText("");
cardLayout1.show(contentPane, "jPanel1");
} else {
mm();
}
}
//输出用户未登录消息 (完成)
void mm() {
JOptionPane.showMessageDialog(JF, "请先登陆您的帐户", "消息",
JOptionPane.CLOSED_OPTION);
}
//帮助文档(完成)
public void jMenuItem8_actionPerformed(ActionEvent e) {
JOptionPane.showMessageDialog(JF,JOptionPane.CLOSED_OPTION);
}
//登陆中的提交按钮 (完成)
public void jButton2_actionPerformed(ActionEvent e) {
String strobj1 = jTextField1.getText();
String strobj2 = jPasswordField1.getText();
if (strobj1.equals("")) {
JOptionPane.showMessageDialog(JF, "您的帐号不能为空", "错误",
JOptionPane.ERROR_MESSAGE);
} else if (strobj2.equals("")) {
JOptionPane.showMessageDialog(JF, "您的密码不能为空", "错误",
JOptionPane.ERROR_MESSAGE);
} else {
//查询数据库
try {
ss = con.createStatement();
} catch (SQLException ex1) {
}
strsql = "select * from kk where id =" +
"'" + strobj1 + "'";
select();
try {
if (result.next()) {
if (strobj1.equals(result.getObject(1))) {
if (strobj2.equals(result.getObject(2))) {
JOptionPane.showMessageDialog(JF, "用户登录成功", "消息",
JOptionPane.CANCEL_OPTION);
kingFrame1obj = true;
cardLayout1.show(contentPane, "jPanel2");
result.close();
ss.close();
} else {
JOptionPane.showMessageDialog(JF, "您输入的密码错误", "错误",
JOptionPane.ERROR_MESSAGE);
jTextField1.setText("");
jPasswordField1.setText("");
result.close();
ss.close();
}
}
} else {
JOptionPane.showMessageDialog(JF, "您输入的帐号不存在", "错误",
JOptionPane.ERROR_MESSAGE);
jTextField1.setText("");
jPasswordField1.setText("");
result.close();
ss.close();
}
} catch (SQLException ex) {
ex.printStackTrace();
}
}
}
//登陆中的重置按钮 (完成)
public void jButton1_actionPerformed(ActionEvent e) {
jTextField1.setText("");
jPasswordField1.setText("");
}
//查询语句 (完成)
void select() {
try {
result = ss.executeQuery(strsql);
} catch (SQLException e1) {
e1.printStackTrace();
}
}
//更改数据库的方法(方法)
void gengai() {
try {
ss.execute(strsql);
} catch (SQLException ex) {
}
}
//失误代码（暂时不管）
public void jComboBox1_actionPerformed(ActionEvent e) {
}
//更改界面的退出(完成)
public void jButton5_actionPerformed(ActionEvent e) {
cardLayout1.show(contentPane, "jPanel2");
}
//更改界面的重置(完成)
public void jButton4_actionPerformed(ActionEvent e) {
kk();
}
//重置更改界面的方法（完成）
void kk() {
jTextField2.setText("");
jComboBox1.setSelectedIndex(0);
jComboBox2.setSelectedIndex(0);
jComboBox3.setSelectedIndex(0);
}
//更改信息的确定(完成)
public void jButton3_actionPerformed(ActionEvent e) throws SQLException {
String ststrobj = jTextField2.getText();
String strname = jComboBox2.getSelectedItem().toString();
String strkemu = jComboBox3.getSelectedItem().toString();
int a = jComboBox1.getSelectedIndex();
if (ststrobj.equals("")) {
JOptionPane.showMessageDialog(JF, "更改信息不能为空", "消息",
JOptionPane.CLOSED_OPTION);
kk();
} else {
if (strname.equals(jComboBox2.getItemAt(0))) {
JOptionPane.showMessageDialog(JF, "更改用户不能为空", "消息",
JOptionPane.CLOSED_OPTION);
kk();
} else {
switch (a) {
case 0:
JOptionPane.showMessageDialog(JF, "您没有选择更改类型", "消息",
JOptionPane.CLOSED_OPTION);
kk();
break;
case 1:
ss = con.createStatement();
strsql = "update xuesheng set name = " + "'" + ststrobj +
"'" +
" where name =" +
"'" + strname + "'";
gengai();
ss.close();
JOptionPane.showMessageDialog(JF, "修改完成", "消息",
JOptionPane.CLOSED_OPTION);
kk();
break;
case 2:
ss = con.createStatement();
strsql = "update xuesheng set banji = " + "'" + ststrobj +
"'" +
" where name =" +
"'" + strname + "'";
gengai();
ss.close();
JOptionPane.showMessageDialog(JF, "修改完成", "消息",
JOptionPane.CLOSED_OPTION);
kk();
break;
case 3:
if (strkemu.equals(jComboBox3.getItemAt(0))) {
JOptionPane.showMessageDialog(JF, "科目不能为空", "消息",
JOptionPane.CLOSED_OPTION);
kk();
} else {
float objfenshu = Float.parseFloat(ststrobj);
if (objfenshu < 0 || objfenshu > 100) {
JOptionPane.showMessageDialog(JF, "成绩输入错误", "消息",
JOptionPane.CLOSED_OPTION);
} else {
ss = con.createStatement();
strsql = "update xuesheng set " + strkemu + " = " +
"'" +
ststrobj +
"'" +
" where name =" +
"'" + strname + "'";
gengai();
ss.close();
JOptionPane.showMessageDialog(JF, "修改完成", "消息",
JOptionPane.CLOSED_OPTION);
kk();
}
}
break;
}
}
}
}
//删除中的提交（完成）
public void jButton6_actionPerformed(ActionEvent e) {
String scstrobj = jComboBox4.getSelectedItem().toString();
if (scstrobj.equals(jComboBox4.getItemAt(0))) {
JOptionPane.showMessageDialog(JF, "您没有选择删除的对象", "消息",
JOptionPane.ERROR_MESSAGE);
} else {
try {
ss = con.createStatement();
strsql = "delete from xuesheng where name='" + scstrobj + "'";
gengai();
ss.close();
JOptionPane.showMessageDialog(JF, "删除学生信息成功", "消息",
JOptionPane.CLOSED_OPTION);
jComboBox4.setSelectedIndex(0);
jComboBox4 = null;
JComboBox jComboBoxobj1 = null;
jComboBoxobj1 = jComboBox4_getjComboBox();
jScrollPane3.getViewport().add(jComboBoxobj1);
JComboBox4_Public(jComboBoxobj1);
} catch (SQLException ex) {
ex.printStackTrace();
}
}
}
//删除中的重置（完成）
public void jButton7_actionPerformed(ActionEvent e) {
jComboBox4.setSelectedIndex(0);
}
//删除中的退出（完成）
public void jButton8_actionPerformed(ActionEvent e) {
cardLayout1.show(contentPane, "jPanel2");
}
//新建用户的退出（完成）
public void jButton11_actionPerformed(ActionEvent e) {
cardLayout1.show(contentPane, "jPanel2");
}
//新建用户的重置（完成）
public void jButton10_actionPerformed(ActionEvent e) {
jTextField3.setText("");
jPasswordField2.setText("");
}
//新建用户的确定按钮（完成）
public void jButton9_actionPerformed(ActionEvent e) {
String uername = jTextField3.getText();
String uerpasword = jPasswordField2.getText();
if (uername.equals("")) {
JOptionPane.showMessageDialog(JF, "您的帐号不能为空", "错误",
JOptionPane.ERROR_MESSAGE);
} else if (uerpasword.equals("")) {
JOptionPane.showMessageDialog(JF, "您的密码不能为空", "错误",
JOptionPane.ERROR_MESSAGE);
} else {
try {
ss = con.createStatement();
} catch (SQLException ex1) {
ex1.printStackTrace();
}
strsql = "select * from kk where id =" +
"'" + uername + "'";
select();
try {
if (result.next()) {
JOptionPane.showMessageDialog(JF, "您输入的帐号已经存在", "错误",
JOptionPane.ERROR_MESSAGE);
jTextField3.setText("");
jPasswordField2.setText("");
result.close();
ss.close();
} else {
result.close();
ss.close();
ss = con.createStatement();
strsql = "insert into kk values ('" + uername + "','" +
uerpasword + "')";
gengai();
ss.close();
JOptionPane.showMessageDialog(JF, "添加用户成功", "消息",
JOptionPane.CANCEL_OPTION);
jTextField3.setText("");
jPasswordField2.setText("");
}
} catch (SQLException ex) {
ex.printStackTrace();
}
}
}
//删除用户（完成）
public void jButton13_actionPerformed(ActionEvent e) {
cardLayout1.show(contentPane, "jPanel2");
}
//删除用户的重置按钮（完成）
public void jButton14_actionPerformed(ActionEvent e) {
jTextField4.setText("");
jTextField5.setText("");
jPasswordField3.setText("");
}
//删除用户的提交功能（完成）
public void jButton12_actionPerformed(ActionEvent e) {
String suername = jTextField5.getText();
String shanchuname = jTextField4.getText();
String suerpasswoer = jPasswordField3.getText();
if (suername.equals("enigma520") && suerpasswoer.equals("enigma520")) {
if (shanchuname.equals("enigma520")) {
JOptionPane.showMessageDialog(JF, "不可删除超级管理员用户", "错误",
JOptionPane.ERROR_MESSAGE);
jTextField4.setText("");
jTextField5.setText("");
jPasswordField3.setText("");
}else{
try {
ss = con.createStatement();
} catch (SQLException ex1) {
ex1.printStackTrace();
}
strsql = "select * from kk where id =" +
"'" + shanchuname + "'";
select();
try {
if (result.next()) {
result.close();
ss.close();
try {
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -