?? userdelete.java~6~
字號:
package bookmanager;import javax.swing.*;import com.borland.jbcl.layout.*;import java.awt.*;import java.awt.event.*;import java.sql.*;/** * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2003</p> * <p>Company: </p> * @author not attributable * @version 1.0 */public class userDelete extends JFrame { //定義結果集 ResultSet rs; //定義數據庫操作對象 private DBManager db =new DBManager(); XYLayout xYLayout1 = new XYLayout(); JLabel jLabel2 = new JLabel(); JButton jButtonCancel = new JButton(); JLabel jLabel1 = new JLabel(); JTextField jTextFieldusername = new JTextField(); JButton jButtonOK = new JButton(); JPasswordField jPasswordold = new JPasswordField(); public userDelete() { try { jbInit(); } catch(Exception e) { e.printStackTrace(); } } public static void main(String[] args) { userDelete userDelete = new userDelete(); } private void jbInit() throws Exception { jPasswordold.setText(""); jButtonOK.setFont(new java.awt.Font("Dialog", 0, 16)); jButtonOK.setText("確定"); jButtonOK.addMouseListener(new userDelete_jButtonOK_mouseAdapter(this)); jTextFieldusername.setFont(new java.awt.Font("Dialog", 0, 16)); jTextFieldusername.setText(""); jLabel1.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel1.setText("用戶名"); jButtonCancel.setFont(new java.awt.Font("Dialog", 0, 16)); jButtonCancel.setText("取消"); jButtonCancel.addMouseListener(new userDelete_jButtonCancel_mouseAdapter(this)); jLabel2.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel2.setText("密碼"); this.getContentPane().setLayout(xYLayout1); xYLayout1.setWidth(400); xYLayout1.setHeight(239); this.getContentPane().add(jButtonOK, new XYConstraints(90, 174, 91, 31)); this.getContentPane().add(jButtonCancel, new XYConstraints(208, 175, 94, 30)); this.getContentPane().add(jLabel1, new XYConstraints(65, 37, 99, 34)); this.getContentPane().add(jLabel2, new XYConstraints(72, 90, 80, 34)); this.getContentPane().add(jTextFieldusername, new XYConstraints(201, 40, 111, 28)); this.getContentPane().add(jPasswordold, new XYConstraints(203, 92, 111, 26)); } void jButtonCancel_mouseClicked(MouseEvent e) { this.dispose(); } void jButtonOK_mouseClicked(MouseEvent e) { String strSQL ; //校驗用戶名是否為空 if(jTextFieldusername.getText().trim().equals("")) {JOptionPane.showMessageDialog(null,"書名不許為空!"); return;} //生成sql操作語句,查詢要刪除的用戶名是否存在,若存在執行刪除,若不存在提示并返回 strSQL="select * from user where username='"+jTextFieldusername.getText().trim() +"' and password='"+jPasswordold.getText().trim()+"'"; rs=db.getResult(strSQL) ; if(rs != null) {JOptionPane.showMessageDialog(null,"用戶名不存在,或原密碼不正確!"); } else { strSQL="delete from user where username='"+jTextFieldusername.getText().trim() +"'"; //由數據庫操作對象執行數據庫操作,并返回操作成功失敗的提示信息 if(db.executeSql(strSQL)) {JOptionPane.showMessageDialog(null,"成功刪除!"); } else { JOptionPane.showMessageDialog(null," 刪除失敗,請重新操作!"); } } }}class userDelete_jButtonCancel_mouseAdapter extends java.awt.event.MouseAdapter { userDelete adaptee; userDelete_jButtonCancel_mouseAdapter(userDelete adaptee) { this.adaptee = adaptee; } public void mouseClicked(MouseEvent e) { adaptee.jButtonCancel_mouseClicked(e); }}class userDelete_jButtonOK_mouseAdapter extends java.awt.event.MouseAdapter { userDelete adaptee; userDelete_jButtonOK_mouseAdapter(userDelete adaptee) { this.adaptee = adaptee; } public void mouseClicked(MouseEvent e) { adaptee.jButtonOK_mouseClicked(e); }}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -