sellwindows.java

教材订购系统

package program;

import java.awt.Toolkit;

import javax.swing.JPanel;
import javax.swing.JFrame;
import java.awt.Dimension;
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 javax.swing.JTextArea;

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

public class SellWindows 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 userset = null;

	private JMenu help = null;

	private JLabel jLabel = null;

	private JLabel jLabel1 = null;

	private JTextField jTextField = null;

	private JTextField jTextField1 = null;

	private JButton jButton = null;

	private JButton jButton1 = null;

	private JMenu look = null;

	private JMenuItem change = null;

	private JMenuItem kucun = null;

	private JMenuItem user = null;

	private JMenuItem exit = null;

	private JMenu tableout = null;

	private JMenuItem softhelp = null;

	private JMenuItem about = null;

	private JLabel jLabel2 = null;

	private JTextField jTextField2 = null;

	private JMenuItem localize = null;

	private JMenuItem queshu = null;

	private JMenuItem dingshu = null;

	private JMenuItem b_inf = null;

	private JMenuItem outkucun = null;

	private JMenuItem outb_inf = null;

	private JMenu Utable = null;

	private JMenuItem binsert = null;

	private JMenuItem bupdate = null;

	private JMenuItem bdelete = null;

	private JButton jButton2 = null;

	/**
	 * This is the default constructor
	 */
	public SellWindows() {
		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(17, 30, 95, 31));
			jLabel2.setText("            班级");
			jLabel1 = new JLabel();
			jLabel1.setBounds(new Rectangle(269, 30, 108, 33));
			jLabel1.setText("               数量");
			jLabel = new JLabel();
			jLabel.setBounds(new Rectangle(136, 30, 108, 31));
			jLabel.setText("              书号");
			jContentPane = new JPanel();
			jContentPane.setLayout(null);
			jContentPane.add(jLabel, null);
			jContentPane.add(jLabel1, null);
			jContentPane.add(getJTextField(), null);
			jContentPane.add(getJTextField1(), null);
			jContentPane.add(getJButton(), null);
			jContentPane.add(getJButton1(), null);
			jContentPane.add(jLabel2, null);
			jContentPane.add(getJTextField2(), null);
			jContentPane.add(getJButton2(), 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(getLook());
			jJMenuBar.add(getUserset());
			jJMenuBar.add(getHelp());
		}
		return jJMenuBar;
	}

	/**
	 * This method initializes system	
	 * 	
	 * @return javax.swing.JMenu	
	 */
	private JMenu getSystem() {
		if (system == null) {
			system = new JMenu();
			system.setText("系统");
			system.add(getChange());
			system.add(getLocalize());
			system.add(getExit());
		}
		return system;
	}

	/**
	 * This method initializes userset	
	 * 	
	 * @return javax.swing.JMenu	
	 */
	private JMenu getUserset() {
		if (userset == null) {
			userset = new JMenu();
			userset.setText("用户设置");
			userset.add(getUser());
		}
		return userset;
	}

	/**
	 * This method initializes help	
	 * 	
	 * @return javax.swing.JMenu	
	 */
	private JMenu getHelp() {
		if (help == null) {
			help = new JMenu();
			help.setText("帮助");
			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(136, 75, 106, 31));
			jTextField.setText("");
		}
		return jTextField;
	}

	/**
	 * This method initializes jTextField1	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField1() {
		if (jTextField1 == null) {
			jTextField1 = new JTextField();
			jTextField1.setBounds(new Rectangle(270, 73, 106, 31));
			jTextField1.setText("");
		}
		return jTextField1;
	}
	/**
	 * This method initializes jTextField2	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField2() {
		if (jTextField2 == null) {
			jTextField2 = new JTextField();
			jTextField2.setBounds(new Rectangle(15, 75, 98, 31));
			jTextField2.setText("");
		}
		return jTextField2;
	}
	/**
	 * This method initializes jButton	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton() {
		if (jButton == null) {
			jButton = new JButton();
			jButton.setBounds(new Rectangle(58, 134, 62, 34));
			jButton.setText("确定");
			jButton.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
                    String bclass = jTextField2.getText();
                    String bno    = jTextField.getText();
                    String bcount = jTextField1.getText();
					
					StringOrInt soi = new StringOrInt();
					ExistSell 	ex	= new ExistSell();
					Intemp 		in 	= new Intemp();
					SysPoint 	str = null;
					
					if(bclass.equals("")||bno.equals("")||bcount.equals(""))
					{
						str = new SysPoint("    输入不能为空,请重新输入!");
						jTextField.setText("");
						jTextField1.setText("");
						jTextField2.setText("");
					}
					else if(!soi.StringOrInt(bcount))
					{
						str = new SysPoint("    输入格式错误,'数量'应为数值型!");
						jTextField1.setText("");
					}	
					else
					{
						try {
							if(ex.YOrN(bno,bcount).equals("N*")){
								str = new SysPoint("<html>从未有本书的销售记录<br/>请对照一览表,确认后输入"+
															"或添加一览表</html>");
								jTextField.setText("");
								jTextField1.setText("");
							}
							else if(ex.YOrN(bno,bcount).equals("Error")){
								str = new SysPoint("数据库记录错误,请联系专业人员!");
								jTextField.setText("");
								jTextField1.setText("");
							}
							else
							{
								in.intemp(bclass, bno, bcount);
								jTextField.setText("");
								jTextField1.setText("");
							}
						} catch (ClassNotFoundException e2) {
							// TODO Auto-generated catch block
							e2.printStackTrace();
						} catch (SQLException e2) {
							// TODO Auto-generated catch block
							e2.printStackTrace();
						}	 
					}

				}
			});
		}
		return jButton;
	}

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

	/**
	 * This method initializes look	
	 * 	
	 * @return javax.swing.JMenu	
	 */
	private JMenu getLook() {
		if (look == null) {
			look = new JMenu();
			look.setText("操作");
			look.add(getKucun());
			look.add(getQueshu());
			look.add(getDingshu());
			look.add(getB_inf());
			look.add(getTableout());
			look.add(getUtable());
		}
		return look;
	}

	/**
	 * This method initializes change	
	 * 	
	 * @return javax.swing.JMenuItem	
	 */
	private JMenuItem getChange() {
		if (change == null) {
			change = new JMenuItem();
			change.setText("采购系统");		
			change.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					frame.setVisible(false);
					BuyWindows bu = new BuyWindows();
				}
			});
		}
		return change;
	}