bookadd.java

图书馆系统

import java.awt.BorderLayout;
import javax.swing.JPanel;
import java.awt.GraphicsConfiguration;
import java.awt.HeadlessException;

import javax.swing.JFrame;
import java.awt.Dimension;
import javax.swing.JLabel;
import java.awt.Rectangle;
import java.awt.Point;

import javax.swing.JOptionPane;
import javax.swing.SwingConstants;
import javax.swing.JTextField;
import javax.swing.JButton;
import javax.swing.WindowConstants;

public class bookAdd extends JFrame {

	private static final long serialVersionUID = 1L;

	private JPanel jContentPane = null;

	private JLabel jLabel = null;

	private JLabel jLabel1 = null;

	private JLabel jLabel2 = null;

	private JLabel jLabel3 = null;

	private JLabel jLabel4 = null;

	private JLabel jLabel5 = null;

	private JLabel jLabel6 = null;

	private JTextField jTextFieldname = null;

	private JTextField jTextFieldpress = null;

	private JTextField jTextFieldauthor = null;

	private JTextField jTextFieldaddress = null;

	private JTextField jTextFieldpressdate = null;

	private JTextField jTextFieldprice = null;

	private JTextField jTextFieldcomment = null;

	private JButton jButtonClear = null;

	private JButton jButtonAdd = null;

	private JButton jButtonExit = null;
	private DBManager db=new DBManager();

	private JLabel jLabel7 = null;

	private JLabel jLabel8 = null;

	private JTextField jTextFieldtotalnum = null;

	public bookAdd() throws HeadlessException {
		// TODO 自动生成构造函数存根
		super();
		initialize();
	}

	public bookAdd(GraphicsConfiguration arg0) {
		super(arg0);
		// TODO 自动生成构造函数存根
		initialize();
	}

	public bookAdd(String arg0) throws HeadlessException {
		super(arg0);
		// TODO 自动生成构造函数存根
		initialize();
	}

	public bookAdd(String arg0, GraphicsConfiguration arg1) {
		super(arg0, arg1);
		// TODO 自动生成构造函数存根
		initialize();
	}

	/**
	 * This method initializes this
	 * 
	 * @return void
	 */
	private void initialize() {
		this.setSize(402, 414);
		this.setDefaultCloseOperation(WindowConstants.HIDE_ON_CLOSE);
		this.setContentPane(getJContentPane());
		this.setTitle("添加书籍信息");
	}

	/**
	 * This method initializes jContentPane
	 * 
	 * @return javax.swing.JPanel
	 */
	private JPanel getJContentPane() {
		if (jContentPane == null) {
			jLabel8 = new JLabel();
			jLabel8.setHorizontalAlignment(SwingConstants.CENTER);
			jLabel8.setLocation(new Point(70, 230));
			jLabel8.setSize(new Dimension(60, 20));
			jLabel8.setText("数量*");
			jLabel7 = new JLabel();
			jLabel7.setBounds(new Rectangle(50, 262, 129, 18));
			jLabel7.setText("带*为必填项");
			jLabel6 = new JLabel();
			jLabel6.setText("备注");
			jLabel6.setSize(new Dimension(60, 20));
			jLabel6.setHorizontalAlignment(SwingConstants.CENTER);
			jLabel6.setLocation(new Point(70, 200));
			jLabel5 = new JLabel();
			jLabel5.setText("价格*");
			jLabel5.setSize(new Dimension(60, 20));
			jLabel5.setHorizontalAlignment(SwingConstants.CENTER);
			jLabel5.setLocation(new Point(70, 170));
			jLabel4 = new JLabel();
			jLabel4.setText("出版日期");
			jLabel4.setSize(new Dimension(60, 20));
			jLabel4.setHorizontalAlignment(SwingConstants.CENTER);
			jLabel4.setLocation(new Point(70, 140));
			jLabel3 = new JLabel();
			jLabel3.setText("地址");
			jLabel3.setSize(new Dimension(60, 20));
			jLabel3.setHorizontalAlignment(SwingConstants.CENTER);
			jLabel3.setLocation(new Point(70, 110));
			jLabel2 = new JLabel();
			jLabel2.setText("作者*");
			jLabel2.setSize(new Dimension(60, 20));
			jLabel2.setHorizontalAlignment(SwingConstants.CENTER);
			jLabel2.setLocation(new Point(70, 80));
			jLabel1 = new JLabel();
			jLabel1.setText("出版社*");
			jLabel1.setSize(new Dimension(60, 20));
			jLabel1.setHorizontalAlignment(SwingConstants.CENTER);
			jLabel1.setLocation(new Point(70, 50));
			jLabel = new JLabel();
			jLabel.setText("名称*");
			jLabel.setSize(new Dimension(60, 20));
			jLabel.setHorizontalAlignment(SwingConstants.CENTER);
			jLabel.setLocation(new Point(70, 20));
			jContentPane = new JPanel();
			jContentPane.setLayout(null);
			jContentPane.add(jLabel, null);
			jContentPane.add(jLabel1, null);
			jContentPane.add(jLabel2, null);
			jContentPane.add(jLabel3, null);
			jContentPane.add(jLabel4, null);
			jContentPane.add(jLabel5, null);
			jContentPane.add(jLabel6, null);
			jContentPane.add(getJTextFieldname(), null);
			jContentPane.add(getJTextFieldpress(), null);
			jContentPane.add(getJTextFieldauthor(), null);
			jContentPane.add(getJTextFieldaddress(), null);
			jContentPane.add(getJTextFieldpressdate(), null);
			jContentPane.add(getJTextFieldprice(), null);
			jContentPane.add(getJTextFieldcomment(), null);
			jContentPane.add(getJButtonClear(), null);
			jContentPane.add(getJButtonAdd(), null);
			jContentPane.add(getJButtonExit(), null);
			jContentPane.add(jLabel7, null);
			jContentPane.add(jLabel8, null);
			jContentPane.add(getJTextFieldtotalnum(), null);
		}
		return jContentPane;
	}

	/**
	 * This method initializes jTextFieldname	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextFieldname() {
		if (jTextFieldname == null) {
			jTextFieldname = new JTextField();
			jTextFieldname.setLocation(new Point(173, 20));
			jTextFieldname.setSize(new Dimension(175, 20));
		}
		return jTextFieldname;
	}

	/**
	 * This method initializes jTextFieldpress	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextFieldpress() {
		if (jTextFieldpress == null) {
			jTextFieldpress = new JTextField();
			jTextFieldpress.setLocation(new Point(173, 50));
			jTextFieldpress.setSize(new Dimension(175, 20));
		}
		return jTextFieldpress;
	}

	/**
	 * This method initializes jTextFieldauthor	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextFieldauthor() {
		if (jTextFieldauthor == null) {
			jTextFieldauthor = new JTextField();
			jTextFieldauthor.setLocation(new Point(173, 80));
			jTextFieldauthor.setSize(new Dimension(175, 20));
		}
		return jTextFieldauthor;
	}

	/**
	 * This method initializes jTextFieldaddress	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextFieldaddress() {
		if (jTextFieldaddress == null) {
			jTextFieldaddress = new JTextField();
			jTextFieldaddress.setLocation(new Point(173, 110));
			jTextFieldaddress.setSize(new Dimension(175, 20));
		}
		return jTextFieldaddress;
	}

	/**
	 * This method initializes jTextFieldpressdate	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextFieldpressdate() {
		if (jTextFieldpressdate == null) {
			jTextFieldpressdate = new JTextField();
			jTextFieldpressdate.setLocation(new Point(173, 140));
			jTextFieldpressdate.setSize(new Dimension(175, 20));
		}
		return jTextFieldpressdate;
	}

	/**
	 * This method initializes jTextFieldprice	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextFieldprice() {
		if (jTextFieldprice == null) {
			jTextFieldprice = new JTextField();
			jTextFieldprice.setLocation(new Point(173, 170));
			jTextFieldprice.setSize(new Dimension(175, 20));
		}
		return jTextFieldprice;
	}

	/**
	 * This method initializes jTextFieldcomment	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextFieldcomment() {
		if (jTextFieldcomment == null) {
			jTextFieldcomment = new JTextField();
			jTextFieldcomment.setLocation(new Point(173, 200));
			jTextFieldcomment.setSize(new Dimension(175, 20));
		}
		return jTextFieldcomment;
	}

	/**
	 * This method initializes jButtonClear	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButtonClear() {
		if (jButtonClear == null) {
			jButtonClear = new JButton();
			jButtonClear.setLocation(new Point(80, 297));
			jButtonClear.setText("清空");
			jButtonClear.setSize(new Dimension(60, 20));
			jButtonClear.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
					jTextFieldname.setText("");
					jTextFieldauthor.setText("");
					jTextFieldpress.setText("");
					jTextFieldaddress.setText("");
					jTextFieldpressdate.setText("");
					jTextFieldprice.setText("");
					jTextFieldcomment.setText("");
					jTextFieldtotalnum.setText("");
				}
			});
		}
		return jButtonClear;
	}

	/**
	 * This method initializes jButtonAdd	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButtonAdd() {
		if (jButtonAdd == null) {
			jButtonAdd = new JButton();
			jButtonAdd.setLocation(new Point(160, 297));
			jButtonAdd.setText("添加");
			jButtonAdd.setSize(new Dimension(60, 20));
			jButtonAdd.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
					if(jTextFieldname.getText().trim().equals("")){
						JOptionPane.showMessageDialog(null, "书名不能为空", "错误", JOptionPane.ERROR_MESSAGE);
						return;
					}
					if(jTextFieldauthor.getText().trim().equals("")){
						JOptionPane.showMessageDialog(null, "作者不能为空", "错误", JOptionPane.ERROR_MESSAGE);
						return;
					}
					if(jTextFieldpress.getText().trim().equals("")){
						JOptionPane.showMessageDialog(null, "出版社不能为空", "错误", JOptionPane.ERROR_MESSAGE);
						return;
					}
					if(jTextFieldprice.getText().trim().equals("")){
						JOptionPane.showMessageDialog(null, "价格不能为空", "错误", JOptionPane.ERROR_MESSAGE);
						return;
					}
					if(jTextFieldtotalnum.getText().trim().equals("")){
						JOptionPane.showMessageDialog(null, "数量不能为空", "错误", JOptionPane.ERROR_MESSAGE);
						return;
					}
					String strSQL;
					strSQL="insert into Books(Bookname,Press,Author,Address,Pressdate,Price,Comment,Totalnum,Kejie)";
					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()+"','"+
					       jTextFieldtotalnum.getText().trim()+"','"+
					       jTextFieldtotalnum.getText().trim()+"')";
					System.out.println(strSQL);
					//由数据库操作，并返回信息
					if(db.executeSql(strSQL)){
						JOptionPane.showMessageDialog(null, "添加成功", "成功", JOptionPane.INFORMATION_MESSAGE);
						buttonexit();
					}
					else{
						JOptionPane.showMessageDialog(null, "添加失败，请重新操作", "错误", JOptionPane.ERROR_MESSAGE);
					}
				}
			});
		}
		return jButtonAdd;
	}

	/**
	 * This method initializes jButtonExit	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private void buttonexit(){
		this.dispose();
	}
	private JButton getJButtonExit() {
		if (jButtonExit == null) {
			jButtonExit = new JButton();
			jButtonExit.setLocation(new Point(240, 297));
			jButtonExit.setText("退出");
			jButtonExit.setSize(new Dimension(60, 20));
			jButtonExit.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
					buttonexit();					    
				}
			});
		}
		return jButtonExit;
	}

	/**
	 * This method initializes jTextFieldtotalnum	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextFieldtotalnum() {
		if (jTextFieldtotalnum == null) {
			jTextFieldtotalnum = new JTextField();
			jTextFieldtotalnum.setLocation(new Point(173, 230));
			jTextFieldtotalnum.setSize(new Dimension(175, 20));
		}
		return jTextFieldtotalnum;
	}

}  //  @jve:decl-index=0:visual-constraint="10,10"