package?librarySyatem;

import?javax.swing.JDialog;
import?javax.swing.*;
import?java.awt.*;
import?java.awt.event.ActionEvent;
import?java.awt.event.ActionListener;
import?java.sql.Statement;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.*;

public?class?Add?extends?JDialog?implements?ActionListener?{
	//?定義我需要的swing組件
	JLabel?jl1?jl2?jl3?jl4?jl5?jl6;
	JTextField?jf1?jf2?jf3?jf4?jf5?jf6;
	JPanel?jp1?jp2?jp3;
	JButton?jb1?jb2;

	//?owner代筆父窗口title是窗口的名字modal指定是模式窗口（）或者非模式窗口
	public?Add（frame?owner?String?title?boolean?modal）?{
		//?調用父類方法
		super（owner?title?modal）;

		jl1?=?new?JLabel（“圖書號“）;
		jl2?=?new?JLabel（“圖書名“）;
		jl3?=?new?JLabel（“作者“）;
		jl4?=?new?JLabel（“圖書數量“）;
		jl5?=?new?JLabel（“出版社“）;
		jl6?=?new?JLabel（“價格“）;

		jf1?=?new?JTextField（10）;
		jf2?=?new?JTextField（10）;
		jf3?=?new?JTextField（10）;
		jf4?=?new?JTextField（10）;
		jf5?=?new?JTextField（10）;
		jf6?=?new?JTextField（10）;

		jb1?=?new?JButton（“添加“）;
		jb1.addActionListener（this）;
		jb2?=?new?JButton（“取消“）;

		jp1?=?new?JPanel（）;
		jp2?=?new?JPanel（）;
		jp3?=?new?JPanel（）;

		//?設置布局
		jp1.setLayout（new?GridLayout（6?1））;
		jp2.setLayout（new?GridLayout（6?1））;

		jp3.add（jb1）;
		jp3.add（jb2）;

		jp1.add（jl1）;
		jp1.add（jl2）;
		jp1.add（jl3）;
		jp1.add（jl4）;
		jp1.add（jl5）;
		jp1.add（jl6）;

		jp2.add（jf1）;
		jp2.add（jf2）;
		jp2.add（jf3）;
		jp2.add（jf4）;
		jp2.add（jf5）;
		jp2.add（jf6）;

		this.add（jp1?BorderLayout.WEST）;
		this.add（jp2?BorderLayout.CENTER）;
		this.add（jp3?BorderLayout.SOUTH）;

		this.setSize（300?200）;
		this.setVisible（true）;
	}

	@Override
	public?void?actionPerformed（ActionEvent?e）?{
		//?TODO?Auto-generated?method?stub
		if?（e.getSource（）?==?jb1）?{
			Connection?ct?=?null;
			PreparedStatement?pstmt?=?null;
			ResultSet?rs?=?null;

			try?{
				//?1.加載驅動
				Class.forName（“com.mysql.cj.jdbc.Driver“）;
				System.out.println（“加載成功“）;
				//?2.連接數據庫
				//?定義幾個常量
				String?url?=?“jdbc:mysql://localhost:3306/book?useSSL=false&serverTimezone=UTC“;
				String?user?=?“root“;
				String?passwd?=?“123356“;
				ct?=?DriverManager.getConnection（url?user?passwd）;

				//?與編譯語句對象

				String?strsql?=?“insert?into?books?values（??????）“;
				pstmt?=?ct.prepareStatement（strsql）;

				//?給對象賦值
				pstmt.setString（1?jf1.getText（））;
				pstmt.setString（2?jf2.getText（））;
				pstmt.setString（3?jf3.getText（））;
				pstmt.setString（4?jf4.getText（））;
				pstmt.setString（5?jf5.getText（））;
				pstmt.setString（6?jf6.getText（））;

				pstmt.executeUpdate（）;

				this.dispose（）;//?關閉對話框

			}?catch?（Exception?arg1）?{
				arg1.printStackTrace（）;
			}?finally?{
				try?{
					if?（rs?!=?null）?{
						rs.close（）;
						rs?=?null;
					}
					if?（pstmt?!=?null）?{
						pstmt.close（）;
						pstmt?=?null;
					}
					if?（ct?!=?null）?{
						ct.close（）;
						ct?=?null;
					}
				}?

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-09-12?07:53??librarySyatem\
?????文件?????????402??2018-09-12?07:53??librarySyatem\.classpath
?????文件?????????389??2018-09-12?07:52??librarySyatem\.project
?????目錄???????????0??2018-09-12?07:52??librarySyatem\.settings\
?????文件?????????598??2018-09-12?07:52??librarySyatem\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2018-09-13?14:18??librarySyatem\bin\
?????目錄???????????0??2018-09-13?14:18??librarySyatem\bin\librarySyatem\
?????文件????????4358??2018-09-13?14:18??librarySyatem\bin\librarySyatem\Add.class
?????文件????????2058??2018-09-13?14:18??librarySyatem\bin\librarySyatem\Landing$1.class
?????文件?????????646??2018-09-13?14:18??librarySyatem\bin\librarySyatem\Landing$2.class
?????文件????????2633??2018-09-13?14:18??librarySyatem\bin\librarySyatem\Landing.class
?????文件????????6576??2018-09-13?14:18??librarySyatem\bin\librarySyatem\Main.class
?????文件????????3487??2018-09-13?14:18??librarySyatem\bin\librarySyatem\Model.class
?????文件????????4794??2018-09-13?14:18??librarySyatem\bin\librarySyatem\Update.class
?????文件????????3051??2018-09-13?14:18??librarySyatem\bin\librarySyatem\general.class
?????文件?????2020431??2018-09-12?07:53??librarySyatem\mysql-connector-java-8.0.12.jar
?????目錄???????????0??2018-09-12?07:53??librarySyatem\src\
?????目錄???????????0??2018-09-12?15:01??librarySyatem\src\librarySyatem\
?????文件????????3189??2018-09-12?16:26??librarySyatem\src\librarySyatem\Add.java
?????文件????????3300??2018-09-12?16:23??librarySyatem\src\librarySyatem\Landing.java
?????文件????????5539??2018-09-13?11:31??librarySyatem\src\librarySyatem\Main.java
?????文件????????2884??2018-09-12?10:59??librarySyatem\src\librarySyatem\Model.java
?????文件????????4102??2018-09-12?10:57??librarySyatem\src\librarySyatem\Update.java
?????文件????????2207??2018-09-12?15:06??librarySyatem\src\librarySyatem\general.java