bupdate.java

教材订购系统

package program;

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

import javax.swing.JPanel;
import javax.swing.JFrame;
import java.awt.Dimension;
import javax.swing.JLabel;
import java.awt.Rectangle;
import java.sql.SQLException;

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

public class Bupdate extends JFrame {

	private static final long serialVersionUID = 1L;
	
	private JFrame frame = null;

	private JPanel jContentPane = null;

	private JLabel jLabel = null;

	private JLabel jLabel1 = null;

	private JLabel jLabel2 = null;

	private JTextField jTextField1 = null;

	private JTextField jTextField2 = null;

	private JButton jButton = null;

	private JButton jButton1 = null;

	private JLabel jLabel3 = null;

	private JLabel jLabel4 = null;

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

	/**
	 * This method initializes this
	 * 
	 * @return void
	 */
	private void initialize(String sti) {
		this.setSize(355, 255);
		this.setContentPane(getJContentPane(sti));
				
		if(sti.equals("insert"))
		{
			this.setTitle("插入一览表信息");
		}
		else if(sti.equals("update"))
		{
			this.setTitle("修改一览表信息");
		}
		else if(sti.equals("delete"))
		{
			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) {
				frame.setVisible(false);
			}
		});
	}

	/**
	 * This method initializes jContentPane
	 * 
	 * @return javax.swing.JPanel
	 */
	private JPanel getJContentPane(String sti) {
		if (jContentPane == null) {
			jLabel4 = new JLabel();
			jLabel4.setBounds(new Rectangle(124, 119, 10, 33));
			jLabel4.setText(" (");
			jLabel3 = new JLabel();
			jLabel3.setBounds(new Rectangle(318, 121, 10, 30));
			jLabel3.setText(" )");
			jLabel2 = new JLabel();
			jLabel2.setBounds(new Rectangle(45, 120, 76, 31));
			jLabel1 = new JLabel();
			jLabel1.setBounds(new Rectangle(45, 75, 270, 31));
			jLabel = new JLabel();
			jLabel.setBounds(new Rectangle(45, 30, 272, 31));

			if(sti.equals("insert"))
			{
				jLabel.setText("      INSERT");
				jLabel1.setText("       INTO                一览表");
				jLabel2.setText("     VALUES  ");
			}
			else if(sti.equals("update"))
			{
				jLabel.setText("      UPDATE                一览表");
				jLabel1.setText("        SET");
				jLabel2.setText("      WHERE");	
			}
			else
			{
				jLabel.setText("      DELETE");
				jLabel1.setText("       FROM                一览表");
				jLabel2.setText("      WHERE");	
			}
			jContentPane = new JPanel();
			jContentPane.setLayout(null);
			jContentPane.add(jLabel, null);
			jContentPane.add(jLabel1, null);
			jContentPane.add(jLabel2, null);
			if(sti.equals("update"))
				jContentPane.add(getJTextField1(), null);
			jContentPane.add(getJTextField2(), null);
			jContentPane.add(getJButton(sti), null);
			jContentPane.add(getJButton1(), null);
			if(sti.equals("insert"))
			{
				jContentPane.add(jLabel3, null);
				jContentPane.add(jLabel4, null);
			}
		}	
		return jContentPane;
	}

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

		}
		return jTextField1;
	}

	/**
	 * This method initializes jTextField2	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField2() {
		if (jTextField2 == null) {
			jTextField2 = new JTextField();
			jTextField2.setText("");
			jTextField2.setBounds(new Rectangle(135, 120, 181, 31));

		}
		return jTextField2;
	}

	/**
	 * This method initializes jButton	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton(final String sti) {
		if (jButton == null) {
			jButton = new JButton();
			jButton.setBounds(new Rectangle(60, 165, 79, 31));
			jButton.setText("确定");
			jButton.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {	
					if(sti.equals("insert"))
					{
						if(jTextField2.getText().equals(""))
						{
							SysPoint dy = new SysPoint("    输入不能为空，请重新输入！");
						}
						else
						{
							try {
								Controltable con = new Controltable("INSERT INTO 书_inf VALUES("+jTextField2.getText()+")");
							} catch (ClassNotFoundException e1) {
								// TODO 自动生成 catch 块
								e1.printStackTrace();
							} catch (SQLException e1) {
								// TODO 自动生成 catch 块
								e1.printStackTrace();
							}
						}
					}
					else if(sti.equals("update"))
					{
						if(jTextField1.getText().equals("")||jTextField2.getText().equals(""))
						{
							SysPoint dy = new SysPoint("    输入不能为空，请重新输入！");
						}
						else
						{
							try {
								Controltable con = new Controltable("UPDATE 书_inf SET "+jTextField1.getText()+" WHERE "+jTextField2.getText());
							} catch (ClassNotFoundException e1) {
								// TODO 自动生成 catch 块
								e1.printStackTrace();
							} catch (SQLException e1) {
								// TODO 自动生成 catch 块
								e1.printStackTrace();
							}
						}
					}
					else//delete
					{
						if(jTextField2.getText().equals(""))
						{
							SysPoint dy = new SysPoint("    输入不能为空，请重新输入！");
						}
						else
						{
							try {
								Controltable con = new Controltable("DELETE FROM 书_inf WHERE "+jTextField2.getText());
							} 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(195, 165, 76, 31));
			jButton1.setText("取消");
			jButton1.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					jTextField1.setText("");
					jTextField2.setText("");
				}
			});
		}
		return jButton1;
	}

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