package?kcsxz;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
/**
?*
?*?@author?LiYuwei
?*/
/*數(shù)據(jù)表：
???????create?table?bookInformationShow（ISBN?varchar（20）
????????????id??bigint?auto_increment?
????????????bookName?varchar（100）
????????????author?varchar（50）
????????????press?varchar（40）
????????????pressTime?varchar（20）
????????????introduce?varchar（1000）
????????????imglink???varchar（300）????
????????????nowPrice??varchar（10）??
????????????prePrice??varchar（10）???
????????????discount??varchar（10）??????????????
????????????common????varchar（30）
????????????primary?key（ISBN））;
?*/
public?class?Database?{
????private?
??????//?JDBC?驅動名及數(shù)據(jù)庫?URL
??????static?String?JDBC_DRIVER?=?“com.mysql.jdbc.Driver“;??

??????static?String?DB_URL?=?“jdbc:mysql://localhost:3306/dangdangData“;
??????static?String?USER?=?“root“;
??????static?String?PASS?=?“miaomiao“;
??????static?Connection?conn?=?null;
??????static?Statement?stmt?=?null;??
????public?static?ResultSet?rs?=?null;
????public?void?inital（）//初始化數(shù)據(jù)庫
????{????
?????????try{
????????????//?注冊?JDBC?驅動
????????????Class.forName（“com.mysql.jdbc.Driver“）;
????????????//?打開鏈接
????????????System.out.println（“連接數(shù)據(jù)庫...“）;
????????????conn?=?DriverManager.getConnection（DB_URLUSERPASS）;
????????????stmt?=?conn.createStatement（）;

????????}catch（SQLException?se）{
????????????//?處理?JDBC?錯誤
????????????se.printStackTrace（）;
????????}catch（Exception?e）{
????????????//?處理?Class.forName?錯誤
????????????e.printStackTrace（）;
????????}
????????System.out.println（“Goodbye!“）;
????}
????public??boolean?sqlQuery（String?sql）throws?Exception//將數(shù)據(jù)插入到數(shù)據(jù)庫中
????{
????????
???????????//?執(zhí)行查詢
???????????try{
????????????????stmt.executeUpdate（sql）;
????????????????Main.nnk++;
????????????????Main.totalnum++;
????????????????opertion.bookArray.add（sql）;
???????????}catch?（Exception?e）{return?false;}
???????????return?true;
????}
????public??void?sqlsearch（String?sql）?throws?Exception//從數(shù)據(jù)庫中查詢圖書
????{
???????????//?執(zhí)行查詢
????????rs?=?stmt.executeQuery（sql）;
???????????//?展開結果集數(shù)據(jù)庫
????????????String?isbn?=?rs.getString（“ISBN“）;
????????????String?bookName?=?rs.getString（“bookName“）;
????}
????public??void?closeDatabase（）?throws?Exception//關閉數(shù)據(jù)庫
????{
?????????try{
????????????????if（conn!=null）?conn.close（）;
?????????}catch（SQLException?se）{
????????????????se.printStackTrace（）;
?????????}
?????????try{
????????????????if（stmt!=null）?stmt.close（）;
????????????}catch（SQLException?se2）{
?????????}
?????}
}

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

?????文件?????????77??2018-07-03?14:03??kcsxz\build\built-jar.properties

?????文件??????????0??2018-07-03?14:03??kcsxz\build\classes\.netbeans_automatic_build

?????文件??????????0??2018-07-03?14:03??kcsxz\build\classes\.netbeans_update_resources

?????文件???????2632??2018-07-03?14:09??kcsxz\build\classes\kcsxz\Database.class

?????文件???????9696??2018-07-03?14:09??kcsxz\build\classes\kcsxz\Main.class

?????文件????????727??2018-07-03?14:09??kcsxz\build\classes\kcsxz\opertion$1.class

?????文件????????522??2018-07-03?14:09??kcsxz\build\classes\kcsxz\opertion$10.class

?????文件????????727??2018-07-03?14:09??kcsxz\build\classes\kcsxz\opertion$2.class

?????文件????????727??2018-07-03?14:09??kcsxz\build\classes\kcsxz\opertion$3.class

?????文件????????727??2018-07-03?14:09??kcsxz\build\classes\kcsxz\opertion$4.class

?????文件????????727??2018-07-03?14:09??kcsxz\build\classes\kcsxz\opertion$5.class

?????文件????????727??2018-07-03?14:09??kcsxz\build\classes\kcsxz\opertion$6.class

?????文件????????727??2018-07-03?14:09??kcsxz\build\classes\kcsxz\opertion$7.class

?????文件????????727??2018-07-03?14:09??kcsxz\build\classes\kcsxz\opertion$8.class

?????文件????????727??2018-07-03?14:09??kcsxz\build\classes\kcsxz\opertion$9.class

?????文件??????16712??2018-07-03?14:09??kcsxz\build\classes\kcsxz\opertion.class

?????文件??????18274??2018-07-03?14:03??kcsxz\build\classes\kcsxz\opertion.form

?????文件???????3600??2018-06-19?14:37??kcsxz\build.xml

?????文件??????38670??2018-07-03?14:03??kcsxz\dist\kcsxz.jar

?????文件?????284184??2018-07-03?14:03??kcsxz\dist\lib\commons-codec-1.10.jar

?????文件??????46725??2018-07-03?14:03??kcsxz\dist\lib\commons-codec-1.3.jar

?????文件?????305001??2018-07-03?14:03??kcsxz\dist\lib\commons-httpclient-3.1.jar

?????文件??????61829??2018-07-03?14:03??kcsxz\dist\lib\commons-logging-1.2.jar

?????文件??????38015??2018-07-03?14:03??kcsxz\dist\lib\commons-logging.jar

?????文件????8478776??2018-07-03?14:03??kcsxz\dist\lib\eclipselink.jar

?????文件??????31427??2018-07-03?14:03??kcsxz\dist\lib\fluent-hc-4.5.5.jar

?????文件?????288098??2018-07-03?14:03??kcsxz\dist\lib\htmlparser.jar

?????文件?????766123??2018-07-03?14:03??kcsxz\dist\lib\httpclient-4.5.5.jar

?????文件?????161550??2018-07-03?14:03??kcsxz\dist\lib\httpclient-cache-4.5.5.jar

?????文件??????17726??2018-07-03?14:03??kcsxz\dist\lib\httpclient-win-4.5.5.jar

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