cusbuybooksdialog.java

一个图书管理系统

package com.UI;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Types;
import java.util.ArrayList;
import java.util.Date;
import java.util.GregorianCalendar;

import javax.swing.ComboBoxModel;
import javax.swing.DefaultComboBoxModel;
import javax.swing.JButton;
import javax.swing.JComboBox;

import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JTextField;

import com.DAO.BooksDAO;
import com.VO.BooksVO;
import com.database.DBAccess;
import com.exception.DataBaseException;

/**
* This code was edited or generated using CloudGarden's Jigloo
* SWT/Swing GUI Builder, which is free for non-commercial
* use. If Jigloo is being used commercially (ie, by a corporation,
* company or business for any purpose whatever) then you
* should purchase a license for each developer using Jigloo.
* Please visit www.cloudgarden.com for details.
* Use of Jigloo implies acceptance of these licensing terms.
* A COMMERCIAL LICENSE HAS NOT BEEN PURCHASED FOR
* THIS MACHINE, SO JIGLOO OR THIS CODE CANNOT BE USED
* LEGALLY FOR ANY CORPORATE OR COMMERCIAL PURPOSE.
*/
public class CusBuyBooksDialog extends javax.swing.JDialog {
	private JLabel jLabel1;
	private JLabel jLabel2;
	private JLabel jLabel4;
	private JComboBox month;
	private JLabel jLabel8;
	private JButton butExit;
	private JButton butConfirm;
	private JLabel jLabel10;
	private JLabel jLabel9;
	private JComboBox day;
	private JComboBox year;
	private JLabel jLabel7;
	private JTextField bookSum;
	private JLabel jLabel6;
	private JComboBox bookID;
	private JLabel jLabel5;
	private JTextField cusEail;
	private JTextField cusPhone;
	private JLabel jLabel3;
	private JTextField cusName;
	private JTextField cusID;

	/**
	* Auto-generated main method to display this JDialog
	*/
	
	
	public CusBuyBooksDialog(JFrame frame) {
		super(frame);
		initGUI();
	}
	
	private void initGUI() {
		DBAccess db=null;
		String custerID=null;			
		try {
			db = DBAccess.getDBAccess();
			CallableStatement pro=db.getConnection().prepareCall("{call pro_custID(?)}");
			pro.registerOutParameter(1,Types.VARCHAR);
			pro.execute();
			custerID=pro.getString(1);
			pro.close();
		} catch (SQLException e1) {
			// TODO 自动生成 catch 块
			e1.printStackTrace();
		}catch (DataBaseException e1) {
			// TODO 自动生成 catch 块
			e1.printStackTrace();
		}
		
		
		try {
			{
				getContentPane().setLayout(null);
				this.setResizable(false);
				setSize(400, 300);
				this.setLocation(250,180);
				{
					jLabel1 = new JLabel();
					getContentPane().add(jLabel1);
					jLabel1.setText("\u987e\u5ba2\u53f7:");
					jLabel1.setBounds(21, 21, 56, 28);
					jLabel1.setFont(new java.awt.Font("宋体",0,14));
				}
				{
					cusID = new JTextField();
					cusID.setText(custerID);
					getContentPane().add(cusID);
					cusID.setBounds(91, 21, 91, 28);
					cusID.setEditable(false);
				}
				{
					jLabel2 = new JLabel();
					getContentPane().add(jLabel2);
					jLabel2.setText("\u987e\u5ba2\u59d3\u540d:");
					jLabel2.setBounds(21, 70, 63, 28);
					jLabel2.setFont(new java.awt.Font("宋体",0,14));
				}
				{
					cusName = new JTextField();
					getContentPane().add(cusName);
					cusName.setBounds(91, 70, 91, 28);
				}
				{
					jLabel3 = new JLabel();
					getContentPane().add(jLabel3);
					jLabel3.setText("\u987e\u5ba2\u7535\u8bdd:");
					jLabel3.setBounds(21, 112, 63, 28);
					jLabel3.setFont(new java.awt.Font("宋体",0,14));
				}
				{
					cusPhone = new JTextField();
					getContentPane().add(cusPhone);
					cusPhone.setBounds(91, 112, 91, 28);
				}
				{
					jLabel4 = new JLabel();
					getContentPane().add(jLabel4);
					jLabel4.setText("\u987e\u5ba2Email:");
					jLabel4.setBounds(189, 112, 77, 28);
					jLabel4.setFont(new java.awt.Font("宋体",0,14));
				}
				{
					cusEail = new JTextField();
					getContentPane().add(cusEail);
					cusEail.setBounds(259, 112, 112, 28);
				}
				{
					jLabel5 = new JLabel();
					getContentPane().add(jLabel5);
					jLabel5.setText("\u56fe\u4e66\u7f16\u53f7:");
					jLabel5.setBounds(189, 21, 63, 28);
					jLabel5.setFont(new java.awt.Font("宋体",0,14));
				}
				{
					BooksDAO books=new BooksDAO();
					ArrayList list=books.findBookAll();
					bookID = new JComboBox();					
					bookID.removeAll();					
					for (int i=0;i<list.size();i++){
						bookID.addItem(((BooksVO)list.get(i)).getBookId());
					}
					
					getContentPane().add(bookID);
					
					bookID.setBounds(259, 21, 119, 28);
				}
				{
					jLabel6 = new JLabel();
					getContentPane().add(jLabel6);
					jLabel6.setText("\u8d2d\u4e66\u6570\u91cf:");
					jLabel6.setBounds(189, 70, 63, 28);
					jLabel6.setFont(new java.awt.Font("宋体",0,14));
				}
				{
					bookSum = new JTextField();
					getContentPane().add(bookSum);
					bookSum.setBounds(259, 70, 119, 28);
				}
				{
					jLabel7 = new JLabel();
					getContentPane().add(jLabel7);
					jLabel7.setText("\u8d2d\u4e66\u65f6\u95f4:");
					jLabel7.setBounds(28, 161, 63, 28);
					jLabel7.setFont(new java.awt.Font("宋体",0,14));
				}
				{
				
					year = new JComboBox();
					year.removeAll();
					for (int i=1990;i<2099;i++){
						year.addItem(""+i);
					}
					getContentPane().add(year);
					
					year.setBounds(105, 161, 63, 28);
					year.setEditable(true);
				}
				{
					
					month = new JComboBox();
					month.removeAll();
					for (int i=1;i<13;i++){
						month.addItem(""+i);
					}
					getContentPane().add(month);
				//	month.setModel(monthModel);
					month.setBounds(196, 161, 56, 28);
					month.setEditable(true);
				}
				{
					
					day = new JComboBox();
					day.removeAll();
					for (int i=1;i<32;i++){
						day.addItem(""+i);
					}
					getContentPane().add(day);
					
					day.setBounds(287, 161, 63, 28);
					day.setEditable(true);
				}
				{
					jLabel8 = new JLabel();
					getContentPane().add(jLabel8);
					jLabel8.setText("\u5e74");
					jLabel8.setBounds(175, 161, 14, 28);
					jLabel8.setFont(new java.awt.Font("宋体",0,14));
				}
				{
					jLabel9 = new JLabel();
					getContentPane().add(jLabel9);
					jLabel9.setText("\u6708");
					jLabel9.setBounds(266, 161, 14, 28);
					jLabel9.setFont(new java.awt.Font("宋体",0,14));
				}
				{
					jLabel10 = new JLabel();
					getContentPane().add(jLabel10);
					jLabel10.setText("\u65e5");
					jLabel10.setBounds(357, 161, 21, 28);
					jLabel10.setFont(new java.awt.Font("宋体",0,14));
				}
				{
					butConfirm = new JButton();
					getContentPane().add(butConfirm);
					butConfirm.setText("\u786e\u5b9a");
					butConfirm.setBounds(98, 224, 63, 28);
					butConfirm.setFont(new java.awt.Font("宋体",0,14));
				}
				{
					butExit = new JButton();
					getContentPane().add(butExit);
					butExit.setText("\u53d6\u6d88");
					butExit.setBounds(231, 224, 63, 28);
					butExit.setFont(new java.awt.Font("宋体",0,14));
				}
			}
			
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	class MyActionListener implements ActionListener{

		public void actionPerformed(ActionEvent e) {
			Object obj=e.getSource();
			if (obj==butConfirm){
				DBAccess db;
				try {
					db = DBAccess.getDBAccess();
					Connection con=db.getConnection();
					CallableStatement pro=con.prepareCall("{call pro_Cust_Books(?,?,?,?,?,?,?)}");
					pro.setString(1,cusID.getText());
					pro.setString(2,cusName.getText());
					pro.setString(3,cusPhone.getText());
					pro.setString(4,cusEail.getText());
					pro.setString(5,(String)bookID.getSelectedItem());
					pro.setInt(6,Integer.parseInt(bookSum.getText()));
					GregorianCalendar cal=new GregorianCalendar(Integer.parseInt((String)year.getSelectedItem()),Integer.parseInt((String)month.getSelectedItem()),Integer.parseInt((String)day.getSelectedItem()));
					Date date1=cal.getTime();
				//	pro.setDate(7,date1);
					pro.execute();
				} catch (DataBaseException e1) {
					// TODO 自动生成 catch 块
					e1.printStackTrace();
				}catch (SQLException e1) {
					// TODO 自动生成 catch 块
					e1.printStackTrace();
				}
				
			}else{
				dispose();
			}
			
		}
		
	}
	
}