?? bookdelete.java~4~
字號:
package bookmanager;import javax.swing.*;import java.sql.*;import com.borland.jbcl.layout.*;import java.awt.*;import java.awt.event.*;/** * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2003</p> * <p>Company: </p> * @author not attributable * @version 1.0 */public class bookDelete extends JFrame { //定義結(jié)果集 ResultSet rs; //定義數(shù)據(jù)庫操作對象 private DBManager db =new DBManager(); XYLayout xYLayout1 = new XYLayout(); JLabel jLabel1 = new JLabel(); JTextField jTextFieldname = new JTextField(); JButton jButtonOk = new JButton(); JButton jButtonCancel = new JButton(); public bookDelete() { try { jbInit(); } catch(Exception e) { e.printStackTrace(); } } public static void main(String[] args) { bookDelete bookDelete = new bookDelete(); } private void jbInit() throws Exception { jLabel1.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel1.setText("請輸入您要刪除的書的名稱:"); this.getContentPane().setLayout(xYLayout1); jButtonOk.setFont(new java.awt.Font("Dialog", 0, 16)); jButtonOk.setText("確定"); jButtonOk.addMouseListener(new bookDelete_jButtonOk_mouseAdapter(this)); jButtonCancel.setFont(new java.awt.Font("Dialog", 0, 16)); jButtonCancel.setText("退出"); jButtonCancel.addMouseListener(new bookDelete_jButtonCancel_mouseAdapter(this)); xYLayout1.setWidth(363); xYLayout1.setHeight(219); jTextFieldname.setFont(new java.awt.Font("Dialog", 0, 16)); jTextFieldname.setText(""); this.getContentPane().add(jLabel1, new XYConstraints(28, 19, 226, 32)); this.getContentPane().add(jTextFieldname, new XYConstraints(99, 85, 161, 27)); this.getContentPane().add(jButtonOk, new XYConstraints(73, 159, 76, 28)); this.getContentPane().add(jButtonCancel, new XYConstraints(195, 156, 81, 28)); } void jButtonCancel_mouseClicked(MouseEvent e) { this.dispose(); } void jButtonOk_mouseClicked(MouseEvent e) { String strSQL ; //校驗書名是否為空 if(jTextFieldname.getText().trim().equals("")) {JOptionPane.showMessageDialog(null,"書名不許為空!"); return;} //生成sql操作語句,查詢要刪除的書是否存在,若存在執(zhí)行刪除,若不存在提示并返回 strSQL="select * from Books where bookname='"+jTextFieldname.getText().trim() +"'"; rs=db.getResult(strSQL) ; if(rs != null) {JOptionPane.showMessageDialog(null,"此書不存在!"); } else { //生成刪除此書的sql語句 strSQL="delete from Books where bookname='"+jTextFieldname.getText().trim() +"'"; //由數(shù)據(jù)庫操作對象執(zhí)行數(shù)據(jù)庫操作,并返回操作成功失敗的提示信息 if(db.executeSql(strSQL)) {JOptionPane.showMessageDialog(null,"成功刪除!"); } else { JOptionPane.showMessageDialog(null," 刪除失敗,請重新操作!"); } } }}class bookDelete_jButtonCancel_mouseAdapter extends java.awt.event.MouseAdapter { bookDelete adaptee; bookDelete_jButtonCancel_mouseAdapter(bookDelete adaptee) { this.adaptee = adaptee; } public void mouseClicked(MouseEvent e) { adaptee.jButtonCancel_mouseClicked(e); }}class bookDelete_jButtonOk_mouseAdapter extends java.awt.event.MouseAdapter { bookDelete adaptee; bookDelete_jButtonOk_mouseAdapter(bookDelete adaptee) { this.adaptee = adaptee; } public void mouseClicked(MouseEvent e) { adaptee.jButtonOk_mouseClicked(e); }}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -