import?java.awt.GridLayout;
import?java.awt.event.ActionEvent;
import?java.awt.event.ActionListener;
import?java.sql.PreparedStatement;
import?java.util.Calendar;
import?java.util.Date;

import?javax.swing.JButton;
import?javax.swing.JLabel;
import?javax.swing.JOptionPane;
import?javax.swing.JPanel;
import?javax.swing.JScrollPane;
import?javax.swing.JSpinner;
import?javax.swing.JTextArea;
import?javax.swing.JTextField;
import?javax.swing.SpinnerDateModel;
import?javax.swing.SpinnerNumberModel;

public?class?BookAdd?extends?JPanel?{
	//編號名稱作者出版社價格出版日期備注	
	public?BookAdd（）{
		this.setLayout（new?GridLayout（82））;
		this.add（new?JLabel（“圖書編號“JLabel.RIGHT））;
		final?JTextField?no=new?JTextField（10）;
		this.add（no）;
		this.add（new?JLabel（“圖書名稱“JLabel.RIGHT））;
		final?JTextField?name=new?JTextField（10）;
		this.add（name）;
		this.add（new?JLabel（“作者名稱“JLabel.RIGHT））;
		final?JTextField?auth=new?JTextField（10）;
		this.add（auth）;
		
		this.add（new?JLabel（“圖書價格“JLabel.RIGHT））;
		SpinnerNumberModel?snm=new?SpinnerNumberModel（2005000.5）;
		final?JSpinner?sPrice=new?JSpinner（snm）;
		this.add（sPrice）;
		
		this.add（new?JLabel（“出版社“JLabel.RIGHT））;
		final?JTextField?press=new?JTextField（10）;
		this.add（press）;
		
		this.add（new?JLabel（“出版日期“JLabel.RIGHT））;
		Calendar?c=Calendar.getInstance（）;
		Date?toDay=c.getTime（）;
		c.add（Calendar.YEAR?-20）;
		Date?minDay=c.getTime（）;
		c.add（Calendar.YEAR40）;
		Date?maxDay=c.getTime（）;
		SpinnerDateModel?sdm=new?SpinnerDateModel（toDayminDaymaxDayCalendar.YEAR）;
		final?JSpinner?sPressDate=new?JSpinner（sdm）;?
		sPressDate.setEditor（new?JSpinner.DateEditor（sPressDate?“yyyy-MM-dd“））;
		this.add（sPressDate）;
		
		this.add（new?JLabel（“內容簡介“JLabel.RIGHT））;
		final?JTextArea?taMemo=new?JTextArea（512）;
		JScrollPane?jsp=new?JScrollPane（taMemo）;
		this.add（jsp）;
		
		JButton?btnOk=new?JButton（“確定“）;
		btnOk.addActionListener（new?ActionListener（）{
			@Override
			public?void?actionPerformed（ActionEvent?arg0）?{
				//編號名稱作者出版社價格出版日期備注
				try{
					String?sql=“Insert?into?tbBook（nonameauthorpresspricepressDatememo）values（???????）“;
					PreparedStatement?ps=DBHandler.connection.prepareStatement（sql）;
					ps.setString（1?no.getText（））;
					ps.setString（2?name.getText（））;
					ps.setString（3?auth.getText（））;
					ps.setString（4?press.getText（））;
					ps.setDouble（5（double）sPrice.getValue（））;
					java.util.Date?date=（java.util.Date）sPressDate.getValue（）;
					ps.setDate（6new?java.sql.Date（date.getTime（）））;
					ps.setString（7?taMemo.getText（））;					
					ps.executeUpdate（）;
					JOptionPane.showMessageDialog（null?“圖書信息成功入庫!“）;
					
				}catch（Exception?ex）{
					JOptionPane.showMessageDialog（null?“圖書入庫出錯！\n“+ex.getMessage（））;
				}				
			}			
		}）;
		JButton?btnReset=new?JButton（“重置“）;
		this.add（btnOk）;this.add（btnReset）;
	}
}

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

?????文件????????598??2018-06-22?08:58??.settings\org.eclipse.jdt.core.prefs

?????文件???????2607??2018-06-30?12:47??bin\BookAdd$1.class

?????文件???????2757??2018-06-30?12:47??bin\BookAdd.class

?????文件???????2423??2018-06-30?12:47??bin\BookLend$1.class

?????文件???????2698??2018-06-30?12:47??bin\BookLend$2.class

?????文件???????2893??2018-06-30?12:47??bin\BookLend$3.class

?????文件???????2999??2018-06-30?12:47??bin\BookLend.class

?????文件???????1059??2018-06-30?12:47??bin\BookManage$1.class

?????文件????????736??2018-06-30?12:47??bin\BookManage$2.class

?????文件???????3787??2018-06-30?12:47??bin\BookManage.class

?????文件???????2865??2018-06-30?12:47??bin\BookReturn$1.class

?????文件???????2741??2018-06-30?12:47??bin\BookReturn.class

?????文件???????2350??2018-06-30?12:47??bin\ChangePasswordPane$1.class

?????文件???????1974??2018-06-30?12:47??bin\ChangePasswordPane.class

?????文件????????674??2018-06-30?12:47??bin\Childframe.class

?????文件???????1128??2018-06-30?12:47??bin\DBHandler.class

?????文件???????1703??2018-05-03?15:39??bin\Java用戶表字典.txt

?????文件???????2990??2018-06-30?12:47??bin\Loginframe$1.class

?????文件????????631??2018-06-30?12:47??bin\Loginframe$2.class

?????文件????????651??2018-06-30?12:47??bin\Loginframe$3.class

?????文件???????2962??2018-06-30?12:47??bin\Loginframe.class

?????文件????????930??2018-06-30?12:47??bin\Mainframe$1.class

?????文件????????981??2018-06-30?12:47??bin\Mainframe$10.class

?????文件???????1301??2018-06-30?12:47??bin\Mainframe$11.class

?????文件????????930??2018-06-30?12:47??bin\Mainframe$2.class

?????文件????????987??2018-06-30?12:47??bin\Mainframe$3.class

?????文件????????988??2018-06-30?12:47??bin\Mainframe$4.class

?????文件????????691??2018-06-30?12:47??bin\Mainframe$5.class

?????文件????????925??2018-06-30?12:47??bin\Mainframe$6.class

?????文件????????928??2018-06-30?12:47??bin\Mainframe$7.class

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