?? 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 + -