package?class0801.software.hgnu;

import?java.awt.Color;
import?java.awt.Container;
import?java.awt.FlowLayout;
import?java.awt.Font;
import?java.awt.event.ActionEvent;
import?java.awt.event.ActionListener;
import?java.sql.Connection;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;

import?javax.swing.JButton;
import?javax.swing.JCheckBox;
import?javax.swing.JDialog;
import?javax.swing.JLabel;
import?javax.swing.JOptionPane;
import?javax.swing.JTextField;

public?class?Addtion?extends?JDialog
{
	
	private?static?final?long?serialVersionUID?=?1L;
	
	private?String?base??sqlti[]??insert;
	private?JLabel[]?label?=?new?JLabel[8];
	private?JTextField[]?tf?=?new?JTextField[8];
	private?String?booktitle[]?=?{?“條形碼“?“書名“?“作者“?“出版社“?“類別“?“單價“?“現存“?“備注“?};
	private?String?usertitle[]?=?{?“學號“?“姓名“?“性別“?“班級“?“系別“?};
	
	private?JButton?quit??ok;
	private?JCheckBox?cb;
	private?boolean?isSelected?=?false;
	private?Font?f?=?new?Font（“楷體_GB2312“?Font.PLAIN?15）;
	
	private?Database?db?=?null;
	private?ResultSet?rs?=?null;
	private?Statement?smt?=?null;
	private?Connection?con?=?null;
	
	public?Addtion（String?base?String?sqlti[]）
	{
		this.base?=?base;
		this.sqlti?=?sqlti;
		
		db?=?new?Database（）;
		con?=?db.connect（）;
		
		Lanchframe（）;
	}
	
	public?void?Lanchframe（）
	{
		settitle（“注冊“）;
		setSize（250?300）;
		setLocationRelativeTo（null）;
		Container?c?=?this.getContentPane（）;
		c.setBackground（Color.cyan）;
		setLayout（new?FlowLayout（FlowLayout.RIGHT））;
		if?（base.equals（“BookInfo“））
		{
			for?（int?i?=?0;?i?tle.length;?i++）
			{
				label[i]?=?new?JLabel（booktitle[i]?+?“:“）;
				label[i].setFont（f）;
				tf[i]?=?new?JTextField（15）;
				c.add（label[i]）;
				c.add（tf[i]）;
			}
		}
		else?if?（base.equals（“Users“））
		{
			for?（int?i?=?0;?i?tle.length;?i++）
			{
				label[i]?=?new?JLabel（usertitle[i]?+?“:“）;
				label[i].setFont（f）;
				tf[i]?=?new?JTextField（15）;
				c.add（label[i]）;
				c.add（tf[i]）;
			}
			setSize（250?220）;
		}
		
		cb?=?new?JCheckBox（“提交“）;
		cb.setFont（f）;
		cb.setContentAreaFilled（false）;
		add（cb）;
		
		cb.addActionListener（new?ActionListener（）
		{
			public?void?actionPerformed（ActionEvent?e）
			{
				if?（cb.isSelected（）?&&?!tf[0].getText（）.equals（““）?&&?!tf[1].getText（）.equals（““）?&&?!tf[2].getText（）.equals（““））
				{
					isSelected?=?true;
				}
				else
				{
					JOptionPane.showMessageDialog（null?“請將必要信息填寫完整后再提交“?“警告“?JOptionPane.WARNING_MESSAGE）;
					cb.setSelected（false）;
				}
			}
		}）;
		
		quit?=?new?JButton（“取消“）;
		ok?=?new?JButton（“確定“）;
		quit.setFont（f）;
		ok.setFont（f）;
		quit.setContentAreaFilled（false）;
		ok.setContentAreaFilled（false）;
		add（ok）;
		add（quit）;
		
		ok.addActionListener（new?Listener（））;
		quit.addActionListener（new?Listener（））;
		setVisible（true）;
	}
	
	public?void?go（）
	{
		if?（base.equals（“BookInfo“））
		{
			

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????380??2010-03-15?11:14??Book\.project

?????文件???????6575??2010-03-17?00:02??Book\src\class0801\software\hgnu\Login.java

?????文件????????728??2010-03-15?12:12??Book\src\class0801\software\hgnu\Database.java

?????文件????????127??2010-03-17?15:27??Book\src\class0801\software\hgnu\Enter.java

?????文件???????1193??2010-03-20?01:34??Book\src\class0801\software\hgnu\UserInfo.java

?????文件???????1721??2010-03-18?12:05??Book\src\class0801\software\hgnu\BookInfo.java

?????文件???????2320??2010-03-20?02:12??Book\src\class0801\software\hgnu\Model.java

?????文件??????21425??2010-03-22?12:21??Book\src\class0801\software\hgnu\AdmiWindow.java

?????文件???????1586??2010-03-19?00:11??Book\src\class0801\software\hgnu\Check.java

?????文件???????1888??2010-03-18?20:42??Book\src\class0801\software\hgnu\Search.java

?????文件???????5309??2010-03-17?14:37??Book\src\class0801\software\hgnu\Addtion.java

?????文件???????1435??2010-03-18?23:29??Book\src\class0801\software\hgnu\Delete.java

?????文件???????4810??2010-03-17?15:31??Book\src\class0801\software\hgnu\Update.java

?????文件???????2981??2010-03-20?02:27??Book\src\class0801\software\hgnu\Record.java

?????文件???????1582??2010-03-20?01:34??Book\bin\class0801\software\hgnu\UserInfo.class

?????文件???????3574??2010-03-20?02:12??Book\bin\class0801\software\hgnu\Model.class

?????文件???????8038??2010-03-17?00:02??Book\bin\class0801\software\hgnu\Login.class

?????文件????????755??2010-03-17?00:02??Book\bin\class0801\software\hgnu\Login$3.class

?????文件????????896??2010-03-17?00:02??Book\bin\class0801\software\hgnu\Login$Adapter.class

?????文件???????1734??2010-03-17?00:02??Book\bin\class0801\software\hgnu\Login$2.class

?????文件???????1414??2010-03-17?00:02??Book\bin\class0801\software\hgnu\Login$1.class

?????文件????????456??2010-03-17?15:27??Book\bin\class0801\software\hgnu\Enter.class

?????文件???????1312??2010-03-15?17:50??Book\bin\class0801\software\hgnu\Database.class

?????文件???????2202??2010-03-18?12:05??Book\bin\class0801\software\hgnu\BookInfo.class

?????文件???????1943??2010-03-22?12:21??Book\bin\class0801\software\hgnu\AdmiWindow$1.class

?????文件??????20730??2010-03-22?12:21??Book\bin\class0801\software\hgnu\AdmiWindow.class

?????文件????????929??2010-03-22?12:21??Book\bin\class0801\software\hgnu\AdmiWindow$Adapter.class

?????文件???????2640??2010-03-19?00:11??Book\bin\class0801\software\hgnu\Check.class

?????文件???????3579??2010-03-20?01:34??Book\bin\class0801\software\hgnu\Search.class

?????文件???????4129??2010-03-22?12:21??Book\bin\class0801\software\hgnu\AdmiWindow$ButtonListener.class

............此處省略37個文件信息