?? bookadd.java~7~
字號:
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 bookAdd extends JFrame {//定義數據庫操作對象 private DBManager db =new DBManager(); XYLayout xYLayout1 = new XYLayout(); JLabel jLabel1 = new JLabel(); JLabel jLabel2 = new JLabel(); JLabel jLabel3 = new JLabel(); JLabel jLabel4 = new JLabel(); JLabel jLabel5 = new JLabel(); JLabel jLabel6 = new JLabel(); JLabel jLabel7 = new JLabel(); JTextField jTextFieldname = new JTextField(); JTextField jTextFieldpress = new JTextField(); JTextField jTextFieldauthor = new JTextField(); JTextField jTextFieldaddress = new JTextField(); JTextField jTextFieldpressdate = new JTextField(); JTextField jTextFieldprice = new JTextField(); JTextField jTextFieldcomment = new JTextField(); JButton jButtonClear = new JButton(); JButton jButtonAdd = new JButton(); JButton jButtonExit = new JButton(); public bookAdd() { try { jbInit(); } catch(Exception e) { e.printStackTrace(); } } public static void main(String[] args) { bookAdd bookAdd = new bookAdd(); } private void jbInit() throws Exception { jLabel1.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel1.setText("名稱"); this.getContentPane().setLayout(xYLayout1); jLabel2.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel2.setText("出版社"); jLabel3.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel3.setText("作者"); jLabel4.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel4.setText("地址"); jLabel5.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel5.setText("出版日期"); jLabel6.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel6.setText("價格"); jLabel7.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel7.setText("備注"); xYLayout1.setWidth(433); xYLayout1.setHeight(344); jTextFieldname.setFont(new java.awt.Font("Dialog", 0, 16)); jTextFieldname.setText(""); jTextFieldpress.setFont(new java.awt.Font("Dialog", 0, 16)); jTextFieldpress.setText(""); jTextFieldauthor.setFont(new java.awt.Font("Dialog", 0, 16)); jTextFieldauthor.setText(""); jTextFieldaddress.setFont(new java.awt.Font("Dialog", 0, 16)); jTextFieldaddress.setText(""); jTextFieldpressdate.setFont(new java.awt.Font("Dialog", 0, 16)); jTextFieldpressdate.setText(""); jTextFieldprice.setFont(new java.awt.Font("Dialog", 0, 16)); jTextFieldprice.setText(""); jTextFieldcomment.setFont(new java.awt.Font("Dialog", 0, 16)); jTextFieldcomment.setText(""); jButtonClear.setFont(new java.awt.Font("Dialog", 0, 16)); jButtonClear.setText("清空"); jButtonClear.addMouseListener(new bookAdd_jButtonClear_mouseAdapter(this)); jButtonAdd.setFont(new java.awt.Font("Dialog", 0, 16)); jButtonAdd.setText("添加"); jButtonAdd.addMouseListener(new bookAdd_jButtonAdd_mouseAdapter(this)); jButtonExit.setFont(new java.awt.Font("Dialog", 0, 16)); jButtonExit.setText("退出"); jButtonExit.addMouseListener(new bookAdd_jButtonExit_mouseAdapter(this)); //將對象添加到相應容器 this.getContentPane().add(jLabel1, new XYConstraints(59, 16, 72, 23)); this.getContentPane().add(jLabel2, new XYConstraints(57, 51, 89, 21)); this.getContentPane().add(jLabel3, new XYConstraints(56, 87, 57, 21)); this.getContentPane().add(jLabel4, new XYConstraints(56, 124, 51, 21)); this.getContentPane().add(jLabel5, new XYConstraints(54, 163, 98, -1)); this.getContentPane().add(jLabel6, new XYConstraints(56, 201, 62, 26)); this.getContentPane().add(jLabel7, new XYConstraints(55, 242, 54, 20)); this.getContentPane().add(jTextFieldname, new XYConstraints(181, 19, 131, 27)); this.getContentPane().add(jTextFieldpress, new XYConstraints(181, 58, 132, 23)); this.getContentPane().add(jTextFieldauthor, new XYConstraints(182, 89, 133, 24)); this.getContentPane().add(jTextFieldaddress, new XYConstraints(181, 119, 134, 27)); this.getContentPane().add(jTextFieldpressdate, new XYConstraints(179, 163, 137, 21)); this.getContentPane().add(jTextFieldprice, new XYConstraints(177, 202, 139, 27)); this.getContentPane().add(jTextFieldcomment, new XYConstraints(178, 239, 137, 23)); this.getContentPane().add(jButtonClear, new XYConstraints(67, 294, 66, 28)); this.getContentPane().add(jButtonAdd, new XYConstraints(173, 294, -1, 28)); this.getContentPane().add(jButtonExit, new XYConstraints(293, 294, 66, 27)); }//退出本窗口 void jButtonExit_mouseClicked(MouseEvent e) { this.dispose(); } //清空文本框 void jButtonClear_mouseClicked(MouseEvent e) { jTextFieldname.setText(""); jTextFieldpress.setText(""); jTextFieldauthor.setText(""); jTextFieldaddress.setText(""); jTextFieldpressdate.setText(""); jTextFieldprice.setText(""); jTextFieldcomment.setText(""); }//添加一條新記錄 void jButtonAdd_mouseClicked(MouseEvent e) { //校驗書名是否為空 if(jTextFieldname.getText().trim().equals("")) {JOptionPane.showMessageDialog(null,"書名不許為空！"); return;} //校驗作者是否為空 if(jTextFieldauthor.getText().trim().equals("")) {JOptionPane.showMessageDialog(null,"作者不許為空！"); return;} //校驗出版社是否為空 if(jTextFieldpress.getText().trim().equals("")) {JOptionPane.showMessageDialog(null,"出版社不許為空！"); return;} //校驗價格是否為空 if(jTextFieldprice.getText().trim().equals("")) {JOptionPane.showMessageDialog(null,"價格不許為空！"); return;} String strSQL ; //生成sql操作語句 strSQL="insert into Books(bookname,press,author,address,pressdate,price,comment) "; strSQL= strSQL+"values('"+jTextFieldname.getText().trim() +"','"+jTextFieldpress.getText().trim()+"',"; strSQL= strSQL+" '"+jTextFieldauthor.getText().trim() +"','"+jTextFieldaddress.getText().trim()+"',"; strSQL= strSQL+" '"+jTextFieldpressdate.getText().trim() +"','"+jTextFieldprice.getText().trim()+"',"; strSQL= strSQL+" '"+jTextFieldcomment.getText().trim() +"')"; //由數據庫操作對象執行數據庫操作，并返回操作成功失敗的提示信息 if(db.executeSql(strSQL)) {JOptionPane.showMessageDialog(null,"成功添加！"); } else { JOptionPane.showMessageDialog(null," 添加失敗，請重新操作！"); } }class bookAdd_jButtonExit_mouseAdapter extends java.awt.event.MouseAdapter { bookAdd adaptee; bookAdd_jButtonExit_mouseAdapter(bookAdd adaptee) { this.adaptee = adaptee; } public void mouseClicked(MouseEvent e) { adaptee.jButtonExit_mouseClicked(e); }}class bookAdd_jButtonClear_mouseAdapter extends java.awt.event.MouseAdapter { bookAdd adaptee; bookAdd_jButtonClear_mouseAdapter(bookAdd adaptee) { this.adaptee = adaptee; } public void mouseClicked(MouseEvent e) { adaptee.jButtonClear_mouseClicked(e); }}class bookAdd_jButtonAdd_mouseAdapter extends java.awt.event.MouseAdapter { bookAdd adaptee; bookAdd_jButtonAdd_mouseAdapter(bookAdd adaptee) { this.adaptee = adaptee; } public void mouseClicked(MouseEvent e) { adaptee.jButtonAdd_mouseClicked(e); }}}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -