package?dao;

import?entity.Category;
import?util.DBUtil;

import?java.sql.*;
import?java.util.ArrayList;
import?java.util.List;

public?class?CategoryDAO?{
????public?int?getTotal（）{
????????int?total?=?0;
????????try（Connection?c?=?DBUtil.getConnection（）;?Statement?s?=?（（Connection）?c）.createStatement（））{
????????????ResultSet?rs?=?s.executeQuery（“SELECT?COUNT（*）?FROM?category“）;
????????????while（rs.next（））{
????????????????total?=?rs.getInt（“1“）;
????????????}
????????}catch?（SQLException?e）{
????????????e.printStackTrace（）;
????????}
????????return?total;
????}

????public?void?add（Category?category）{
????????String?sql?=?“INSERT?INTO?category（idname）?VALUES（null?）“;
????????try（Connection?c?=?DBUtil.getConnection（）;?PreparedStatement?ps?=?c.prepareStatement（sql））{
????????????ps.se

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2020-04-11?20:15??hutubill-master\
?????目錄???????????0??2020-04-11?20:14??hutubill-master\.idea\
?????文件?????????288??2019-04-14?22:19??hutubill-master\.idea\encodings.xml
?????目錄???????????0??2020-04-11?20:14??hutubill-master\.idea\libraries\
?????文件?????????513??2019-04-14?22:19??hutubill-master\.idea\libraries\chart.xml
?????文件?????????208??2019-04-14?22:19??hutubill-master\.idea\libraries\liquidlnf.xml
?????文件?????????250??2019-04-14?22:19??hutubill-master\.idea\libraries\mysql_connector_java_5_0_8_bin.xml
?????文件?????????273??2019-04-14?22:19??hutubill-master\.idea\misc.xml
?????文件?????????256??2019-04-14?22:19??hutubill-master\.idea\modules.xml
?????文件????????8792??2019-04-14?22:19??hutubill-master\.idea\uiDesigner.xml
?????文件?????????167??2019-04-14?22:19??hutubill-master\.idea\vcs.xml
?????文件????????9732??2020-04-05?00:09??hutubill-master\.idea\workspace.xml
?????文件?????????716??2019-04-14?22:19??hutubill-master\hutubill.iml
?????目錄???????????0??2020-04-11?20:14??hutubill-master\img\
?????文件????????1547??2019-04-14?22:19??hutubill-master\img\backup.png
?????文件????????1314??2019-04-14?22:19??hutubill-master\img\category1.png
?????文件????????2125??2019-04-14?22:19??hutubill-master\img\category2.png
?????文件????????1862??2019-04-14?22:19??hutubill-master\img\config.png
?????文件????????1292??2019-04-14?22:19??hutubill-master\img\home.png
?????文件????????1389??2019-04-14?22:19??hutubill-master\img\record.png
?????文件????????1225??2019-04-14?22:19??hutubill-master\img\report.png
?????文件????????1719??2019-04-14?22:19??hutubill-master\img\restore.png
?????目錄???????????0??2020-04-11?20:14??hutubill-master\lib\
?????文件??????167801??2019-04-14?22:19??hutubill-master\lib\chart.jar
?????文件??????373967??2019-04-14?22:19??hutubill-master\lib\liquidlnf.jar
?????文件??????540852??2019-04-14?22:19??hutubill-master\lib\mysql-connector-java-5.0.8-bin.jar
?????文件?????1447793??2019-04-14?22:19??hutubill-master\lib\swingx-core-1.6.2.jar
?????目錄???????????0??2019-04-14?22:19??hutubill-master\out\
?????目錄???????????0??2019-04-14?22:19??hutubill-master\out\production\
?????目錄???????????0??2020-03-19?00:30??hutubill-master\out\production\hutubill\
?????目錄???????????0??2020-04-11?20:14??hutubill-master\out\production\hutubill\dao\
............此處省略108個(gè)文件信息