📄 adma.java
字号:
}
catch (SQLException ex) {
ex.printStackTrace();
}
}
else {
JOptionPane.showMessageDialog(null, "此帐号不存在,请核实!", "警告",
JOptionPane.WARNING_MESSAGE);
}
}
catch (SQLException ex3) {
ex3.printStackTrace();
}
}
else {
JOptionPane.showMessageDialog(null, "新密码不匹配", "警告",
JOptionPane.WARNING_MESSAGE);
}
}
else if (jRadioButton2.isSelected()) {
//添加管理员帐号
//获取输入信息
String id = jTextField1.getText().trim();
char[] newpas1 = jPasswordField2.getPassword();
char[] newpas2 = jPasswordField3.getPassword();
String new1 = new String(newpas1);
String new2 = new String(newpas2);
if (id.equals("")) {
JOptionPane.showMessageDialog(null, "帐号不能为空", "警告",
JOptionPane.WARNING_MESSAGE);
}
else if (new1.equals("")) {
JOptionPane.showMessageDialog(null, "新密码不可为空", "警告",
JOptionPane.WARNING_MESSAGE);
}
else if (new1.equals(new2)) {
//获得Staetment对象
Statement stmt = linkData.getStatement();
try {
//执行号码查询 存在则提示,不存在则添加
ResultSet rs = stmt.executeQuery(
"SELECT * FROM Ad WHERE id='" + id + "'");
if (rs.next()) {
JOptionPane.showMessageDialog(null, "已存在的帐号", "警告",
JOptionPane.WARNING_MESSAGE);
}
else {
//执行添加
stmt.executeUpdate("INSERT INTO Ad VALUES('" +
id + "','" + new1 + "','" + "一般管理员" +
"','" + "[第一次登录]" + "','" + 0 + "')");
JOptionPane.showMessageDialog(null,
"管理员添加成功!\n请保存好自己的密码!", "成功",
JOptionPane.INFORMATION_MESSAGE);
//输入栏清空
jTextField1.setText("");
jPasswordField1.setText("");
jPasswordField2.setText("");
jPasswordField3.setText("");
}
}
catch (SQLException ex1) {
ex1.printStackTrace();
}
}
else {
JOptionPane.showMessageDialog(null, "新密码不匹配", "警告",
JOptionPane.WARNING_MESSAGE);
}
}
else if (jRadioButton3.isSelected()) {
//删除管理员帐号
//获取输入的信息
String id = jTextField1.getText().trim();
char[] oldpas = jPasswordField1.getPassword();
String old = new String(oldpas);
if (id.equals("")) {
JOptionPane.showMessageDialog(null, "帐号不能为空", "警告",
JOptionPane.WARNING_MESSAGE);
}
else if (old.equals("")) {
JOptionPane.showMessageDialog(null, "密码不可为空", "警告",
JOptionPane.WARNING_MESSAGE);
}
else {
//获得Staetment对象
Statement stmt = linkData.getStatement();
try {
//帐号和密码匹配查询
ResultSet rs = stmt.executeQuery(
"SELECT * FROM Ad WHERE id='" + id + "'AND Password='" +
old + "'");
if (rs.next()) {
/*此处进行是否为超级管理员查询,其中超级管理不允许被删除*/
String ll = rs.getString(5);
if (ll.equals("1")) {
JOptionPane.showMessageDialog(null, "此帐号不允许被删除!",
"警告", JOptionPane.WARNING_MESSAGE);
}
else {
Object[] options = {
"确定", "取消"};
int agr = JOptionPane.showOptionDialog(null,
"删除管理员:" + id + "\n删除后不可恢复!\n确定删除?",
"警告",
JOptionPane.YES_OPTION,
JOptionPane.WARNING_MESSAGE, null,
options, options[0]);
if (agr == 0) {
//执行删除管理员
stmt.executeUpdate(
"Delete From Ad where ID = '" +
id + "'");
JOptionPane.showMessageDialog(null,
"管理员:" + id + "\n删除成功!", "成功",
JOptionPane.INFORMATION_MESSAGE);
//清空输入栏
jTextField1.setText("");
jPasswordField1.setText("");
}
}
}
else {
JOptionPane.showMessageDialog(null, "帐号或者密码错误!", "错误",
JOptionPane.ERROR_MESSAGE);
}
}
catch (SQLException ex2) {
ex2.printStackTrace();
}
}
}
}
//取消键
public void jButton2_actionPerformed(ActionEvent e) {
//管理员管理窗口关闭
this.dispose();
}
}
class adma_jButton2_actionAdapter
implements ActionListener {
private adma adaptee;
adma_jButton2_actionAdapter(adma adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton2_actionPerformed(e);
}
}
class adma_jButton1_actionAdapter
implements ActionListener {
private adma adaptee;
adma_jButton1_actionAdapter(adma adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton1_actionPerformed(e);
}
}
class adma_jRadioButton3_actionAdapter
implements ActionListener {
private adma adaptee;
adma_jRadioButton3_actionAdapter(adma adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jRadioButton3_actionPerformed(e);
}
}
class adma_jRadioButton2_actionAdapter
implements ActionListener {
private adma adaptee;
adma_jRadioButton2_actionAdapter(adma adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jRadioButton2_actionPerformed(e);
}
}
class adma_jRadioButton1_actionAdapter
implements ActionListener {
private adma adaptee;
adma_jRadioButton1_actionAdapter(adma adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jRadioButton1_actionPerformed(e);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -