insertbookframe.java

模拟图书馆管理系统 实现了各种图书馆管理功能

import java.awt.BorderLayout;

import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JFrame;
import java.awt.Dimension;
import javax.swing.JLabel;
import java.awt.Rectangle;
import javax.swing.*;
import java.lang.Object;
import java.io.*;
import java.sql.*;
import javax.swing.JTextPane;

public class InsertBookFrame extends JFrame {

	private static final long serialVersionUID = 1L;

	private JPanel jContentPane = null;

	private JLabel jLabel1 = null;

	private JLabel jLabel2 = null;

	private JLabel jLabel3 = null;

	private JLabel jLabel4 = null;

	private JScrollPane jScrollPane = null;

	private JLabel jLabel = null;

	private JScrollPane jScrollPane1 = null;

	private JLabel jLabel5 = null;

	private JLabel jLabel6 = null;

	private JLabel jLabel7 = null;

	private JLabel jLabel8 = null;

	private JTextField jTextField = null;

	private JButton jButton = null;

	private JTextField jTextField1 = null;

	private JTextField jTextField2 = null;

	private JTextField jTextField3 = null;

	private JTextField jTextField4 = null;

	private JComboBox jComboBox = null;

	private JTextField jTextField5 = null;

	private JButton jButton1 = null;

	private JButton jButton2 = null;

	private JLabel jLabel9 = null;
	
	private Connection connection = null;

	private JTextPane jTextPane = null;
	

	/**
	 * This is the default constructor
	 */
	public InsertBookFrame(Connection connection) {
		super();
		this.connection = connection;
		initialize();
	}

	/**
	 * This method initializes this
	 * 
	 * @return void
	 */
	private void initialize() {
		this.setSize(592, 428);
		this.setContentPane(getJContentPane());
		this.setTitle("插入图书信息");
		this.setResizable(false);
		this.setLocation(200, 20);
		this.setVisible(true);
		this.addWindowListener(new java.awt.event.WindowAdapter() {
			public void windowClosing(java.awt.event.WindowEvent e) {
				setVisible(false);
				//System.exit(1);
				//System.out.println("windowClosing()"); // TODO Auto-generated Event stub windowClosing()
			}
		});
	}

	/**
	 * This method initializes jContentPane
	 * 
	 * @return javax.swing.JPanel
	 */
	private JPanel getJContentPane() {
		if (jContentPane == null) {
			jLabel9 = new JLabel();
			jLabel9.setBounds(new Rectangle(336, 105, 20, 22));
			jLabel9.setText(" 元");
			jLabel8 = new JLabel();
			jLabel8.setBounds(new Rectangle(204, 145, 85, 24));
			jLabel8.setText("封面 图片文件");
			jLabel7 = new JLabel();
			jLabel7.setBounds(new Rectangle(202, 106, 34, 23));
			jLabel7.setText("价格");
			jLabel6 = new JLabel();
			jLabel6.setBounds(new Rectangle(381, 103, 43, 24));
			jLabel6.setText("出版社");
			jLabel5 = new JLabel();
			jLabel5.setBounds(new Rectangle(17, 210, 79, 25));
			jLabel5.setText("简介");
			jLabel4 = new JLabel();
			jLabel4.setBounds(new Rectangle(381, 60, 38, 27));
			jLabel4.setText("作者");
			jLabel3 = new JLabel();
			jLabel3.setBounds(new Rectangle(382, 23, 40, 28));
			jLabel3.setText("类别");
			jLabel2 = new JLabel();
			jLabel2.setBounds(new Rectangle(201, 62, 32, 26));
			jLabel2.setText("书名");
			jLabel1 = new JLabel();
			jLabel1.setBounds(new Rectangle(203, 24, 35, 24));
			jLabel1.setText("编号");
			jContentPane = new JPanel();
			jContentPane.setLayout(null);
			jContentPane.add(jLabel1, null);
			jContentPane.add(jLabel2, null);
			jContentPane.add(jLabel3, null);
			jContentPane.add(jLabel4, null);
			jContentPane.add(getJScrollPane(), null);
			jContentPane.add(getJScrollPane1(), null);
			jContentPane.add(jLabel5, null);
			jContentPane.add(jLabel6, null);
			jContentPane.add(jLabel7, null);
			jContentPane.add(jLabel8, null);
			jContentPane.add(getJTextField(), null);
			jContentPane.add(getJButton(), null);
			jContentPane.add(getJTextField1(), null);
			jContentPane.add(getJTextField2(), null);
			jContentPane.add(getJTextField3(), null);
			jContentPane.add(getJTextField4(), null);
			jContentPane.add(getJComboBox(), null);
			jContentPane.add(getJTextField5(), null);
			jContentPane.add(getJButton1(), null);
			jContentPane.add(getJButton2(), null);
			jContentPane.add(jLabel9, null);
		}
		return jContentPane;
	}

	/**
	 * This method initializes jScrollPane	
	 * 	
	 * @return javax.swing.JScrollPane	
	 */
	private JScrollPane getJScrollPane() {
		if (jScrollPane == null) {
			jLabel = new JLabel();
			jLabel.setText("");
			//jLabel.setIcon(new ImageIcon("Icon\\null.jpg"));
			jScrollPane = new JScrollPane();
			jScrollPane.setBounds(new Rectangle(14, 15, 169, 188));
			jScrollPane.setViewportView(jLabel);
		}
		return jScrollPane;
	}

	/**
	 * This method initializes jScrollPane1	
	 * 	
	 * @return javax.swing.JScrollPane	
	 */
	private JScrollPane getJScrollPane1() {
		if (jScrollPane1 == null) {
			jScrollPane1 = new JScrollPane();
			jScrollPane1.setBounds(new Rectangle(16, 238, 548, 106));
			jScrollPane1.setViewportView(getJTextPane());
			jScrollPane1.setHorizontalScrollBarPolicy(ScrollPaneConstants.HORIZONTAL_SCROLLBAR_NEVER);
		}
		return jScrollPane1;
	}

	/**
	 * This method initializes jTextField	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField() {
		if (jTextField == null) {
			jTextField = new JTextField();
			jTextField.setEditable(false);
			jTextField.setBounds(new Rectangle(200, 179, 300, 24));
		}
		return jTextField;
	}

	/**
	 * This method initializes jButton	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton() {
		if (jButton == null) {
			jButton = new JButton();
			jButton.setBounds(new Rectangle(509, 180, 63, 24));
			jButton.setText("选择");
			jButton.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					JFileChooser chooser = new JFileChooser();
					ExampleFileFilter filter = new ExampleFileFilter();
					filter.addExtension("jpg");
					filter.addExtension("gif");
					filter.setDescription("JPG & GIF Images");
				    chooser.setFileFilter(filter);
				    int returnVal = chooser.showOpenDialog(new JFrame());
				    if(returnVal == JFileChooser.APPROVE_OPTION) {
				       //System.out.println("You chose to open this file: " + chooser.getSelectedFile().getName());
				    	jTextField.setText(chooser.getSelectedFile().getPath());
				    	jLabel.setIcon(new ImageIcon(chooser.getSelectedFile().getAbsolutePath()));
				    }
					
					//System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
				}
			});
		}
		return jButton;
	}

	/**
	 * This method initializes jTextField1	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField1() {
		if (jTextField1 == null) {
			jTextField1 = new JTextField();
			jTextField1.setBounds(new Rectangle(250, 24, 112, 22));
		}
		return jTextField1;
	}

	/**
	 * This method initializes jTextField2	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField2() {
		if (jTextField2 == null) {
			jTextField2 = new JTextField();
			jTextField2.setBounds(new Rectangle(247, 65, 115, 22));
		}
		return jTextField2;
	}

	/**
	 * This method initializes jTextField3	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField3() {
		if (jTextField3 == null) {
			jTextField3 = new JTextField();
			jTextField3.setBounds(new Rectangle(433, 63, 104, 24));
		}
		return jTextField3;
	}

	/**
	 * This method initializes jTextField4	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField4() {
		if (jTextField4 == null) {
			jTextField4 = new JTextField();
			jTextField4.setBounds(new Rectangle(249, 105, 83, 21));
		}
		return jTextField4;
	}

	/**
	 * This method initializes jComboBox	
	 * 	
	 * @return javax.swing.JComboBox	
	 */
	private JComboBox getJComboBox() {
		String[] sort = {"地理","儿童","军事","创业","社科","计算机","小说","艺术","英语","宗教","其他"};
		if (jComboBox == null) {
			jComboBox = new JComboBox(sort);
			jComboBox.setEditable(true);
			jComboBox.setBounds(new Rectangle(436, 26, 102, 24));
		}
		return jComboBox;
	}

	/**
	 * This method initializes jTextField5	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField5() {
		if (jTextField5 == null) {
			jTextField5 = new JTextField();
			jTextField5.setBounds(new Rectangle(436, 106, 106, 25));
		}
		return jTextField5;
	}

	/**
	 * This method initializes jButton1	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton1() {
		if (jButton1 == null) {
			jButton1 = new JButton();
			jButton1.setBounds(new Rectangle(390, 356, 68, 25));
			jButton1.setText("插入");
			jButton1.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					String warn = "";
					String warnId = null;
					String warnName = null;
					String warnAuthor = null;
					String warnPrice = null;
					String warnPublish = null;
					String warnCover = null;
					String warnIntroduction = null;
					
					if (jTextField1.getText().length()==0){
						warnId = "编号不能为空\n";
					    warn += warnId;
					}
					
					if(jTextField2.getText().length()==0){
						warnName = "书名不能为空\n";
						warn += warnName;
					}
					
					if(jTextField3.getText().length()==0){
						warnAuthor = "作者信息不能为空\n";
						warn += warnAuthor;
					}
					
					if (jTextField4.getText().length()==0){
						warnPrice = "价格不能为空\n";
						warn += warnPrice;
					}
					else{
						if(IsFloat.isFloat(jTextField4.getText().trim())==false){
							warnPrice = "价格信息错误\n";
							warn += warnPrice;
						}
					}
					
					if(jTextField5.getText().length()==0){
						warnPublish = "出版社信息不能为空\n";
						warn += warnPublish;
					}
					
					if(jTextField.getText().length()==0){
						warnCover = "没有选择封面图片文件\n";
						warn += warnCover;
					}
					
					if(jTextPane.getText().length()==0){
						warnIntroduction = "没有简介信息\n";
						warn += warnIntroduction;
					}
					
					if(warn.length()==0){
						String id = jTextField1.getText();
						String name = jTextField2.getText();
						String sort = ((String)jComboBox.getSelectedItem());
						String author = jTextField3.getText();
						float price = Float.valueOf(jTextField4.getText());
						String publish = jTextField5.getText();
						String imageURL = jTextField.getText();
						String introduction = jTextPane.getText();
						
						try{
							Statement statement = connection.createStatement();
							String query = "insert into Book values("
						           + "'" + id + "',"
						           + "'" + name + "',"
						           + "'" + sort + "',"
						           + "'" + author + "',"
						           + "'" + publish + "',"
						           + "'" + introduction + "',"
						           + "'" + price + "',"
						           + "?"
						           +")";
							//System.out.println(query);
							FileInputStream imageStream = new FileInputStream(imageURL); 
							PreparedStatement pstmt = connection.prepareCall(query);
							pstmt.setBinaryStream(1,imageStream,imageStream.available());
							pstmt.execute();
							JOptionPane.showMessageDialog(null, "你已经成功插入这本书的信息","成功",JOptionPane.INFORMATION_MESSAGE);
							jLabel.setIcon(null);// real image
							jTextField.setText(null);//image url
							jTextField1.setText(null);//id
							jTextField2.setText(null);//name
							jTextField3.setText(null);//author
							jTextField4.setText(null);//price
							jTextField5.setText(null);//pub
							jTextPane.setText(null);//ins
							//jCombox sort
						}catch(Exception sqlE){
							sqlE.printStackTrace();
							JOptionPane.showMessageDialog(null, "插入新书籍信息不成功", "不成功", JOptionPane.ERROR_MESSAGE);
						}
						
					}
					else{
						//System.out.println(warn);
						JOptionPane.showMessageDialog(null, warn, "插入数据不成功", JOptionPane.ERROR_MESSAGE);
					}
					//System.out.println(warn);
					//System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
				}
			});
		}
		return jButton1;
	}

	/**
	 * This method initializes jButton2	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton2() {
		if (jButton2 == null) {
			jButton2 = new JButton();
			jButton2.setBounds(new Rectangle(482, 356, 68, 25));
			jButton2.setText("退出");
			jButton2.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					setVisible(false);
					//System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
				}
			});
		}
		return jButton2;
	}

	/**
	 * This method initializes jTextPane	
	 * 	
	 * @return javax.swing.JTextPane	
	 */
	private JTextPane getJTextPane() {
		if (jTextPane == null) {
			jTextPane = new JTextPane();
		}
		return jTextPane;
	}

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