buywindows.java

教材订购系统

package program;

import java.awt.BorderLayout;
import java.awt.Dimension;
import java.awt.Toolkit;

import javax.swing.JPanel;
import javax.swing.JFrame;
import javax.swing.JMenuBar;
import javax.swing.JMenu;
import javax.swing.JLabel;
import java.awt.Rectangle;
import java.io.IOException;
import java.sql.SQLException;

import javax.swing.JTextField;
import javax.swing.JButton;
import javax.swing.JMenuItem;

import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;

public class BuyWindows extends JFrame {

	private static final long serialVersionUID = 1L;

	private JFrame frame = null;
	
	private JPanel jContentPane = null;

	private JMenuBar jJMenuBar = null;

	private JMenu system = null;

	private JMenu look1 = null;

	private JMenu user = null;

	private JMenu help = null;

	private JLabel jLabel = null;

	private JLabel jLabel2 = null;

	private JTextField jTextField = null;

	private JTextField jTextField1 = null;

	private JButton jButton = null;

	private JButton jButton1 = null;

	private JMenuItem change1 = null;

	private JMenuItem exit = null;

	private JMenu tableout1 = null;

	private JMenuItem user1 = null;

	private JMenuItem softhelp = null;

	private JMenuItem about = null;

	private JMenuItem localize1 = null;

	private JMenu Utable = null;

	private JMenuItem binsert = null;

	private JMenuItem bupdate = null;

	private JMenuItem bdelete = null;

	private JMenuItem kucunb = null;

	private JMenuItem goushu = null;

	private JMenuItem b_inf = null;

	private JMenuItem outkucun = null;

	private JMenuItem outb_inf = null;

	private JMenuItem outgoushu = null;

	/**
	 * This is the default constructor
	 */
	public BuyWindows() {
		super();
		frame = this;
		initialize();
	}

	/**
	 * This method initializes this
	 * 
	 * @return void
	 */
	private void initialize() {
		this.setSize(403, 255);
		this.setJMenuBar(getJJMenuBar());
		this.setContentPane(getJContentPane());
		this.setTitle("采购系统");
		
		frame.setResizable(false); //锁定JFrame
		Toolkit tkit = Toolkit.getDefaultToolkit();
        Dimension screenSize = tkit.getScreenSize();
        Dimension frameSize =  frame.getSize();
        if(frameSize.height>screenSize.height){
			frameSize.height=screenSize.height;
		}
		if(frameSize.width>screenSize.width){
			frameSize.width=screenSize.width;
		}
        frame.setLocation((screenSize.width-frameSize.width)/2, 
        		           (screenSize.height-frameSize.height)/2);
		
		frame.setVisible(true);
		frame.addWindowListener(new java.awt.event.WindowAdapter() {
			public void windowClosing(java.awt.event.WindowEvent e) {
				System.exit(0);
			}
		});
	}

	/**
	 * This method initializes jContentPane
	 * 
	 * @return javax.swing.JPanel
	 */
	private JPanel getJContentPane() {
		if (jContentPane == null) {
			jLabel2 = new JLabel();
			jLabel2.setBounds(new Rectangle(208, 30, 122, 31));
			jLabel2.setText("                数量");
			jLabel = new JLabel();
			jLabel.setBounds(new Rectangle(43, 30, 123, 33));
			jLabel.setText("                书号");
			jContentPane = new JPanel();
			jContentPane.setLayout(null);
			jContentPane.add(jLabel, null);
			jContentPane.add(jLabel2, null);
			jContentPane.add(getJTextField(), null);
			jContentPane.add(getJTextField1(), null);
			jContentPane.add(getJButton(), null);
			jContentPane.add(getJButton1(), null);
		}
		return jContentPane;
	}

	/**
	 * This method initializes jJMenuBar	
	 * 	
	 * @return javax.swing.JMenuBar	
	 */
	private JMenuBar getJJMenuBar() {
		if (jJMenuBar == null) {
			jJMenuBar = new JMenuBar();
			jJMenuBar.add(getSystem());
			jJMenuBar.add(getLook1());
			jJMenuBar.add(getUser());
			jJMenuBar.add(getHelp());
		}
		return jJMenuBar;
	}

	/**
	 * This method initializes system	
	 * 	
	 * @return javax.swing.JMenu	
	 */
	private JMenu getSystem() {
		if (system == null) {
			system = new JMenu();
			system.setText("\u7cfb\u7edf");
			system.add(getLocalize1());
			system.add(getChange1());
			system.add(getExit());
		}
		return system;
	}

	/**
	 * This method initializes look1	
	 * 	
	 * @return javax.swing.JMenu	
	 */
	private JMenu getLook1() {
		if (look1 == null) {
			look1 = new JMenu();
			look1.setText("操作");
			look1.add(getKucunb());
			look1.add(getGoushu());
			look1.add(getB_inf());
			look1.add(getTableout1());
			look1.add(getUtable());
		}
		return look1;
	}

	/**
	 * This method initializes user	
	 * 	
	 * @return javax.swing.JMenu	
	 */
	private JMenu getUser() {
		if (user == null) {
			user = new JMenu();
			user.setText("\u7528\u6237\u8bbe\u7f6e");
			user.add(getUser1());
		}
		return user;
	}

	/**
	 * This method initializes help	
	 * 	
	 * @return javax.swing.JMenu	
	 */
	private JMenu getHelp() {
		if (help == null) {
			help = new JMenu();
			help.setText("\u5e2e\u52a9");
			help.add(getSofthelp());
			help.add(getAbout());
		}
		return help;
	}

	/**
	 * This method initializes jTextField	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField() {
		if (jTextField == null) {
			jTextField = new JTextField("");
			jTextField.setBounds(new Rectangle(45, 75, 121, 31));
		}
		return jTextField;
	}

	/**
	 * This method initializes jTextField1	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField1() {
		if (jTextField1 == null) {
			jTextField1 = new JTextField("");
			jTextField1.setBounds(new Rectangle(209, 75, 123, 31));
		}
		return jTextField1;
	}

	/**
	 * This method initializes jButton	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton() {
		if (jButton == null) {
			jButton = new JButton();
			jButton.setBounds(new Rectangle(86, 135, 64, 31));
			jButton.setText("确定");
			jButton.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					 String bno    = jTextField.getText();
					 String bcount = jTextField1.getText();
						
					 StringOrInt soi = new StringOrInt();
					 ExistBuy 	 ex	 = new ExistBuy();
					 SysPoint 	str  = null;
					 
					 if(bno.equals("")||bcount.equals(""))
					 {
						 str = new SysPoint("    输入不能为空,请重新输入!");
						 jTextField.setText("");
						 jTextField1.setText("");
					 }
					 else if(!soi.StringOrInt(bcount))
					 {
						 str = new SysPoint("    输入格式错误,'数量'应为数值型!");
						 jTextField1.setText("");
					 }
					 else
					 {
						 try {
							if(ex.YOrN(bno,bcount).equals("Y"))
							 {
/////////////////////////////////进入Y分支
								Y yy = new Y(bno,bcount);
								jTextField.setText("");
								jTextField1.setText("");	
							 }
						} catch (ClassNotFoundException e1) {
							// TODO 自动生成 catch 块
							e1.printStackTrace();
						} catch (SQLException e1) {
							// TODO 自动生成 catch 块
							e1.printStackTrace();
						}
						 try {
							if(ex.YOrN(bno,bcount).equals("N"))
							{
////////////////////////////////进入N分支			
								str = new SysPoint("<html>从未有本书的销售记录<br/>请对照一览表,确认后输入"+
													"或添加一览表</html>");
								jTextField.setText("");
								jTextField1.setText("");
							}
						} catch (ClassNotFoundException e1) {
							// TODO 自动生成 catch 块
							e1.printStackTrace();
						} catch (SQLException e1) {
							// TODO 自动生成 catch 块
							e1.printStackTrace();
						}
					 }				
				}
			});
		}
		return jButton;
	}

	/**
	 * This method initializes jButton1	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton1() {
		if (jButton1 == null) {
			jButton1 = new JButton();
			jButton1.setBounds(new Rectangle(224, 135, 61, 31));
			jButton1.setText("取消");
			jButton1.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					jTextField.setText("");
					jTextField1.setText("");
				}
			});
		}
		return jButton1;
	}

	/**
	 * This method initializes change1	
	 * 	
	 * @return javax.swing.JMenuItem	
	 */
	private JMenuItem getChange1() {
		if (change1 == null) {
			change1 = new JMenuItem();
			change1.setText("销售系统");
			change1.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					frame.setVisible(false);
					SellWindows se = new SellWindows();
				}
			});
			
		}
		return change1;