depot.java

java语言编写的基于sql2000开发的图书馆管理系统

package depot;

import javax.swing.JPanel;
import javax.swing.JFrame;
import javax.swing.JLabel;
import java.awt.Rectangle;
import javax.swing.JButton;
import javax.swing.JTextField;
import javax.swing.JTextArea;
import javax.swing.JScrollPane;
import javax.swing.JList;
import javax.swing.DefaultListModel;
import main.PersonInfo;
import javax.swing.ListSelectionModel;
import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;
import java.awt.event.MouseListener;


import main.DataBase;

import java.sql.ResultSet;

public class Depot extends JFrame {

	private static final long serialVersionUID = 1L;

	private JPanel jContentPane = null;

	private JLabel jLabel = null;

	private JButton person = null;

	private JButton about = null;

	private JLabel jLabel1 = null;

	private JTextField isbn = null;

	private JLabel jLabel2 = null;

	private JTextField bookname = null;

	private JLabel jLabel3 = null;

	private JTextField author = null;

	private JLabel jLabel4 = null;

	private JTextField press = null;

	private JLabel jLabel5 = null;

	private JTextField quantity = null;

	private JLabel jLabel6 = null;

	private JTextField bookLocation = null;

	private JLabel jLabel7 = null;

	private JButton confirm = null;

	private JScrollPane jScrollPane = null;

	private JTextArea jTextArea = null;

	private static JList jList1 = null;

	private JLabel jLabel9 = null;
	//defaultListModel是jlist的模型
	private static DefaultListModel defaultListModel;
	
	private static JFrame frame;
	//
	private String contractNum;

	private JLabel jLabel8 = null;

	private JTextField price = null;

	/**
	 * This is the default constructor
	 */
	public Depot() {
		super();
		initialize();
		Depot.frame=this;
		//生成模型并设定
		Depot.defaultListModel=new DefaultListModel();
		Depot.jList1.setModel(defaultListModel);
		
		//update the contents of jlist
		Depot.paintJlist();
		
	}

	/**
	 * This method initializes this
	 * 
	 * @return void
	 */
	private void initialize() {
		this.setSize(702, 400);
		this.setResizable(false);
		this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		this.setContentPane(getJContentPane());
		this.setTitle("仓库");
		this.setLocation(200,200);
		this.setVisible(true);
		this.getJContentPanetwo();
		this.getJContentPanethree();
		this.getJContentPanefour();
		this.getJContentPanefive();
		this.getJContentPanesix();
	}

	/**
	 * This method initializes jContentPane
	 * 
	 * @return javax.swing.JPanel
	 */
	private JPanel getJContentPane() {
		if (jContentPane == null) {
			jLabel8 = new JLabel();
			jLabel8.setBounds(new Rectangle(441, 173, 65, 22));
			jLabel8.setText("单价");
			jLabel9 = new JLabel();
			jLabel9.setBounds(new Rectangle(41, 29, 77, 20));
			jLabel9.setText("购买的新书");
			jLabel7 = new JLabel();
			jLabel7.setBounds(new Rectangle(212, 171, 67, 26));
			jLabel7.setText("摘要");
			jLabel6 = new JLabel();
			jLabel6.setBounds(new Rectangle(441, 139, 66, 21));
			jLabel6.setText("馆藏地");
			jLabel5 = new JLabel();
			jLabel5.setBounds(new Rectangle(213, 139, 67, 21));
			jLabel5.setText("数量");
			jLabel4 = new JLabel();
			jLabel4.setBounds(new Rectangle(441, 93, 66, 24));
			jLabel4.setText("出版社");
			jLabel3 = new JLabel();
			jLabel3.setBounds(new Rectangle(213, 93, 67, 24));
			jLabel3.setText("作者");
			jLabel2 = new JLabel();
			jLabel2.setBounds(new Rectangle(441, 57, 66, 22));
			jLabel2.setText("书名");
			jLabel1 = new JLabel();
			jLabel1.setBounds(new Rectangle(213, 57, 67, 22));
			jLabel1.setText("isbn");
			jLabel = new JLabel();
			jLabel.setBounds(new Rectangle(215, 29, 94, 20));
			jLabel.setText("新书入库");
			jContentPane = new JPanel();
			jContentPane.setLayout(null);
			jContentPane.add(jLabel, null);
			jContentPane.add(getPerson(), null);
			jContentPane.add(getAbout(), null);
			jContentPane.add(jLabel1, null);
			jContentPane.add(getIsbn(), null);
			jContentPane.add(jLabel2, null);
			jContentPane.add(getBookname(), null);
			jContentPane.add(jLabel3, null);
			jContentPane.add(getAuthor(), null);
			jContentPane.add(jLabel4, null);
			jContentPane.add(getPress(), null);
			jContentPane.add(jLabel5, null);
			jContentPane.add(getQuantity(), null);
			jContentPane.add(jLabel6, null);
			jContentPane.add(getBookLocation(), null);
			jContentPane.add(jLabel7, null);
			jContentPane.add(getConfirm(), null);
			jContentPane.add(getJScrollPane(), null);
			jContentPane.add(getJList1(), null);
			jContentPane.add(jLabel9, null);
			jContentPane.add(jLabel8, null);
			jContentPane.add(getPrice(), null);
		}
		return jContentPane;
	}
	private void getJContentPanesix() {
		if (jContentPane == null) {
			jLabel8 = new JLabel();
			jLabel8.setBounds(new Rectangle(441, 173, 65, 22));
			jLabel8.setText("单价");
			jLabel9 = new JLabel();
			jLabel9.setBounds(new Rectangle(41, 29, 77, 20));
			jLabel9.setText("购买的新书");
			jLabel7 = new JLabel();
			jLabel7.setBounds(new Rectangle(212, 171, 67, 26));
			jLabel7.setText("摘要");
			jLabel6 = new JLabel();
			jLabel6.setBounds(new Rectangle(441, 139, 66, 21));
			jLabel6.setText("馆藏地");
			jLabel5 = new JLabel();
			jLabel5.setBounds(new Rectangle(213, 139, 67, 21));
			jLabel5.setText("数量");
			jLabel4 = new JLabel();
			jLabel4.setBounds(new Rectangle(441, 93, 66, 24));
			jLabel4.setText("出版社");
			jLabel3 = new JLabel();
			jLabel3.setBounds(new Rectangle(213, 93, 67, 24));
			jLabel3.setText("作者");
			jLabel2 = new JLabel();
			jLabel2.setBounds(new Rectangle(441, 57, 66, 22));
			jLabel2.setText("书名");
			jLabel1 = new JLabel();
			jLabel1.setBounds(new Rectangle(213, 57, 67, 22));
			jLabel1.setText("isbn");
			jLabel = new JLabel();
			jLabel.setBounds(new Rectangle(215, 29, 94, 20));
			jLabel.setText("新书入库");
			jContentPane = new JPanel();
			jContentPane.setLayout(null);
			jContentPane.add(jLabel, null);
			jContentPane.add(getPerson(), null);
			jContentPane.add(getAbout(), null);
			jContentPane.add(jLabel1, null);
			jContentPane.add(getIsbn(), null);
			jContentPane.add(jLabel2, null);
			jContentPane.add(getBookname(), null);
			jContentPane.add(jLabel3, null);
			jContentPane.add(getAuthor(), null);
			jContentPane.add(jLabel4, null);
			jContentPane.add(getPress(), null);
			jContentPane.add(jLabel5, null);
			jContentPane.add(getQuantity(), null);
			jContentPane.add(jLabel6, null);
			jContentPane.add(getBookLocation(), null);
			jContentPane.add(jLabel7, null);
			jContentPane.add(getConfirm(), null);
			jContentPane.add(getJScrollPane(), null);
			jContentPane.add(getJList1(), null);
			jContentPane.add(jLabel9, null);
			jContentPane.add(jLabel8, null);
			jContentPane.add(getPrice(), null);
		}
	}
	private void getJContentPanetwo() {
		if (jContentPane == null) {
			jLabel8 = new JLabel();
			jLabel8.setBounds(new Rectangle(441, 173, 65, 22));
			jLabel8.setText("单价");
			jLabel9 = new JLabel();
			jLabel9.setBounds(new Rectangle(41, 29, 77, 20));
			jLabel9.setText("购买的新书");
			jLabel7 = new JLabel();
			jLabel7.setBounds(new Rectangle(212, 171, 67, 26));
			jLabel7.setText("摘要");
			jLabel6 = new JLabel();
			jLabel6.setBounds(new Rectangle(441, 139, 66, 21));
			jLabel6.setText("馆藏地");
			jLabel5 = new JLabel();
			jLabel5.setBounds(new Rectangle(213, 139, 67, 21));
			jLabel5.setText("数量");
			jLabel4 = new JLabel();
			jLabel4.setBounds(new Rectangle(441, 93, 66, 24));
			jLabel4.setText("出版社");
			jLabel3 = new JLabel();
			jLabel3.setBounds(new Rectangle(213, 93, 67, 24));
			jLabel3.setText("作者");
			jLabel2 = new JLabel();
			jLabel2.setBounds(new Rectangle(441, 57, 66, 22));
			jLabel2.setText("书名");
			jLabel1 = new JLabel();
			jLabel1.setBounds(new Rectangle(213, 57, 67, 22));
			jLabel1.setText("isbn");
			jLabel = new JLabel();
			jLabel.setBounds(new Rectangle(215, 29, 94, 20));
			jLabel.setText("新书入库");
			jContentPane = new JPanel();
			jContentPane.setLayout(null);
			jContentPane.add(jLabel, null);
			jContentPane.add(getPerson(), null);
			jContentPane.add(getAbout(), null);
			jContentPane.add(jLabel1, null);
			jContentPane.add(getIsbn(), null);
			jContentPane.add(jLabel2, null);
			jContentPane.add(getBookname(), null);
			jContentPane.add(jLabel3, null);
			jContentPane.add(getAuthor(), null);
			jContentPane.add(jLabel4, null);
			jContentPane.add(getPress(), null);
			jContentPane.add(jLabel5, null);
			jContentPane.add(getQuantity(), null);
			jContentPane.add(jLabel6, null);
			jContentPane.add(getBookLocation(), null);
			jContentPane.add(jLabel7, null);
			jContentPane.add(getConfirm(), null);
			jContentPane.add(getJScrollPane(), null);
			jContentPane.add(getJList1(), null);
			jContentPane.add(jLabel9, null);
			jContentPane.add(jLabel8, null);
			jContentPane.add(getPrice(), null);
		}
	}

	private void getJContentPanethree() {
		if (jContentPane == null) {
			jLabel8 = new JLabel();
			jLabel8.setBounds(new Rectangle(441, 173, 65, 22));
			jLabel8.setText("单价");
			jLabel9 = new JLabel();
			jLabel9.setBounds(new Rectangle(41, 29, 77, 20));
			jLabel9.setText("购买的新书");
			jLabel7 = new JLabel();
			jLabel7.setBounds(new Rectangle(212, 171, 67, 26));
			jLabel7.setText("摘要");
			jLabel6 = new JLabel();
			jLabel6.setBounds(new Rectangle(441, 139, 66, 21));
			jLabel6.setText("馆藏地");
			jLabel5 = new JLabel();
			jLabel5.setBounds(new Rectangle(213, 139, 67, 21));
			jLabel5.setText("数量");
			jLabel4 = new JLabel();
			jLabel4.setBounds(new Rectangle(441, 93, 66, 24));
			jLabel4.setText("出版社");
			jLabel3 = new JLabel();
			jLabel3.setBounds(new Rectangle(213, 93, 67, 24));
			jLabel3.setText("作者");
			jLabel2 = new JLabel();
			jLabel2.setBounds(new Rectangle(441, 57, 66, 22));
			jLabel2.setText("书名");
			jLabel1 = new JLabel();
			jLabel1.setBounds(new Rectangle(213, 57, 67, 22));
			jLabel1.setText("isbn");
			jLabel = new JLabel();
			jLabel.setBounds(new Rectangle(215, 29, 94, 20));
			jLabel.setText("新书入库");
			jContentPane = new JPanel();
			jContentPane.setLayout(null);
			jContentPane.add(jLabel, null);
			jContentPane.add(getPerson(), null);
			jContentPane.add(getAbout(), null);
			jContentPane.add(jLabel1, null);
			jContentPane.add(getIsbn(), null);
			jContentPane.add(jLabel2, null);
			jContentPane.add(getBookname(), null);
			jContentPane.add(jLabel3, null);
			jContentPane.add(getAuthor(), null);
			jContentPane.add(jLabel4, null);
			jContentPane.add(getPress(), null);
			jContentPane.add(jLabel5, null);
			jContentPane.add(getQuantity(), null);
			jContentPane.add(jLabel6, null);
			jContentPane.add(getBookLocation(), null);
			jContentPane.add(jLabel7, null);
			jContentPane.add(getConfirm(), null);
			jContentPane.add(getJScrollPane(), null);
			jContentPane.add(getJList1(), null);
			jContentPane.add(jLabel9, null);
			jContentPane.add(jLabel8, null);
			jContentPane.add(getPrice(), null);
		}
	}
	/**
	 * This method initializes person	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getPerson() {
		if (person == null) {
			person = new JButton();
			person.setBounds(new Rectangle(382, 11, 101, 22));
			person.setText("个人信息");