資源簡介
該項目中包含功能點（java導出excel文件、jcombobox省市區三級聯動、jdbc中java反射的應用、swing組件用戶登錄，顯示數據、jdbc操作mysql數據庫），有對應jar包，對應sql文件。
代碼片段和文件信息
package?com.shichuang.dao;
import?org.apache.poi.hssf.usermodel.HSSFWorkbook;
import?org.apache.poi.ss.usermodel.Cell;
import?org.apache.poi.ss.usermodel.Row;
import?org.apache.poi.ss.usermodel.Sheet;
import?org.apache.poi.ss.usermodel.Workbook;
import?java.io.FileOutputStream;
import?java.lang.reflect.Method;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ParametermetaData;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.ResultSetmetaData;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.util.ArrayList;
import?java.util.List;
import?org.apache.poi.hssf.usermodel.HSSFWorkbook;
import?org.apache.poi.ss.usermodel.Cell;
import?org.apache.poi.ss.usermodel.Row;
import?org.apache.poi.ss.usermodel.Sheet;
import?org.apache.poi.ss.usermodel.Workbook;
/**
?*?數據庫連接與關閉工具類
*/
public?class?baseDao?{
????private?String?driver?=?“com.mysql.jdbc.Driver“;//?數據庫驅動字符串
private?String?url?=?“jdbc:mysql://localhost:3306/customerdb“;//?連接URL字符串
private?String?user?=?“root“;?//?數據庫用戶名
private?String?password?=?“admin“;?//?用戶密碼
????Connection?conn?=?null; //?數據連接對象
????/**
?????*?獲取數據庫連接對象
?????*/
????public?Connection?getConnection（）?{
????????if（conn==null）?{
????????????//?獲取連接并捕獲異常
????????????try?{
????????????????Class.forName（driver）;
????????????????conn?=?DriverManager.getConnection（url?user?password）;
????????????}?catch?（Exception?e）?{
????????????????e.printStackTrace（）; //?異常處理
????????????}
????????}
????????return?conn; //?返回連接對象
????}
????/**
?????*?關閉數據庫連接
?????*?@param?conn?數據庫連接
?????*?@param?stmt?Statement對象
?????*?@param?rs?結果集
?????*/
????public?void?closeAll（Connection?conn?Statement?stmt?
???????????????????ResultSet?rs）?{
????????//?若結果集對象不為空則關閉
????????if?（rs?!=?null）?{
????????????try?{
????????????????rs.close（）;
????????????}?catch?（Exception?e）?{
????????????????e.printStackTrace（）;
????????????}
????????}
????????//?若Statement對象不為空則關閉
????????if?（stmt?!=?null）?{
????????????try?{
????????????????stmt.close（）;
????????????}?catch?（Exception?e）?{
????????????????e.printStackTrace（）;
????????????}
????????}
????????//?若數據庫連接對象不為空則關閉
????????if?（conn?!=?null）?{
????????????try?{
????????????????conn.close（）;
????????????}?catch?（Exception?e）?{
????????????????e.printStackTrace（）;
????????????}
????????}
????}
????
?/**
?*?增、刪、改的操作
?*?@param?sql?預編譯的?SQL?語句??????????
?*?@param?param?參數的字符串數組??????????
?*?@return?影響的行數
?*/
public?int?exceuteUpdate?（String?preparedSql?object[]?param）?{
PreparedStatement?pstmt?=?null;
int?num?=?0;
conn?=??getConnection（）;?
try?{
pstmt?=?conn.prepareStatement（preparedSql）;
if?（param?!=?null）?{
for?（int?i?=?0;?i?????????????????????? //為預編譯sql設置參數
pstmt.setobject（i?+?1?param[i]）;?
}
}
num?=?pstmt.executeUpdate（）;?
}?catch?（SQLException?e）?{
e.printSt ?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-12-25?11:01??項目和對應Jar和數據庫sql文件\
?????文件??????255634??2018-12-25?11:01??項目和對應Jar和數據庫sql文件\customerdb.sql
?????目錄???????????0??2018-12-25?10:59??項目和對應Jar和數據庫sql文件\CustomerSystem\
?????文件?????????953??2018-12-23?14:50??項目和對應Jar和數據庫sql文件\CustomerSystem\.classpath
?????文件?????????390??2018-12-17?09:34??項目和對應Jar和數據庫sql文件\CustomerSystem\.project
?????目錄???????????0??2018-12-25?10:59??項目和對應Jar和數據庫sql文件\CustomerSystem\.settings\
?????文件?????????598??2018-12-17?09:32??項目和對應Jar和數據庫sql文件\CustomerSystem\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2018-12-25?10:59??項目和對應Jar和數據庫sql文件\CustomerSystem\bin\
?????目錄???????????0??2018-12-25?10:59??項目和對應Jar和數據庫sql文件\CustomerSystem\bin\com\
?????目錄???????????0??2018-12-25?10:59??項目和對應Jar和數據庫sql文件\CustomerSystem\bin\com\shichuang\
?????目錄???????????0??2018-12-25?10:59??項目和對應Jar和數據庫sql文件\CustomerSystem\bin\com\shichuang\dao\
?????文件????????7260??2018-12-24?10:43??項目和對應Jar和數據庫sql文件\CustomerSystem\bin\com\shichuang\dao\ba
?????目錄???????????0??2018-12-25?10:59??項目和對應Jar和數據庫sql文件\CustomerSystem\bin\com\shichuang\entity\
?????文件????????1101??2018-12-24?10:43??項目和對應Jar和數據庫sql文件\CustomerSystem\bin\com\shichuang\entity\Areas.class
?????文件????????1113??2018-12-24?10:43??項目和對應Jar和數據庫sql文件\CustomerSystem\bin\com\shichuang\entity\Citys.class
?????文件????????1871??2018-12-24?10:43??項目和對應Jar和數據庫sql文件\CustomerSystem\bin\com\shichuang\entity\Customers.class
?????文件?????????949??2018-12-24?10:43??項目和對應Jar和數據庫sql文件\CustomerSystem\bin\com\shichuang\entity\Provinces.class
?????文件????????1149??2018-12-24?10:43??項目和對應Jar和數據庫sql文件\CustomerSystem\bin\com\shichuang\entity\Users.class
?????目錄???????????0??2018-12-25?10:59??項目和對應Jar和數據庫sql文件\CustomerSystem\bin\com\shichuang\impl\
?????文件?????????982??2018-12-24?10:43??項目和對應Jar和數據庫sql文件\CustomerSystem\bin\com\shichuang\impl\CityImpl.class
?????文件????????1630??2018-12-24?10:43??項目和對應Jar和數據庫sql文件\CustomerSystem\bin\com\shichuang\impl\CustomersImpl.class
?????文件????????1580??2018-12-24?10:43??項目和對應Jar和數據庫sql文件\CustomerSystem\bin\com\shichuang\impl\DataImpl.class
?????文件????????1204??2018-12-24?10:43??項目和對應Jar和數據庫sql文件\CustomerSystem\bin\com\shichuang\impl\UsersImpl.class
?????目錄???????????0??2018-12-25?10:59??項目和對應Jar和數據庫sql文件\CustomerSystem\bin\com\shichuang\view\
?????文件?????????765??2018-12-24?10:43??項目和對應Jar和數據庫sql文件\CustomerSystem\bin\com\shichuang\view\FrmAddCustomers$1.class
?????文件?????????765??2018-12-24?10:43??項目和對應Jar和數據庫sql文件\CustomerSystem\bin\com\shichuang\view\FrmAddCustomers$2.class
?????文件????????4576??2018-12-24?10:43??項目和對應Jar和數據庫sql文件\CustomerSystem\bin\com\shichuang\view\FrmAddCustomers.class
?????文件?????????723??2018-12-24?10:43??項目和對應Jar和數據庫sql文件\CustomerSystem\bin\com\shichuang\view\FrmLogin$1.class
?????文件?????????723??2018-12-24?10:43??項目和對應Jar和數據庫sql文件\CustomerSystem\bin\com\shichuang\view\FrmLogin$2.class
?????文件????????4332??2018-12-24?10:43??項目和對應Jar和數據庫sql文件\CustomerSystem\bin\com\shichuang\view\FrmLogin.class
?????文件?????????778??2018-12-24?10:43??項目和對應Jar和數據庫sql文件\CustomerSystem\bin\com\shichuang\view\FrmMain$1.class
............此處省略43個文件信息
評論
共有 條評論
川公網安備 51152502000135號