package?com.sun.dao;

import?com.sun.dbm.Dbmanage;
import?com.sun.vo.RecipeVo;

import?java.sql.Connection;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.util.ArrayList;

/**
?*?Created?by?sunyang?on?2016/12/8.
?*?這個類用于操作對數據庫的菜譜進行顯示
?*/
public?class?DisDAO?{//從數據庫中選擇菜譜顯示

????public?static?ArrayList?idlist=new?ArrayList（）;
????static?{//直接生成的靜態代碼塊
????????Connection?conn?=?null;
????????Statement?sta?=?null;
????????ResultSet?rs?=?null;
????????Dbmanage?dbmanage?=?new?Dbmanage（）;

????????try?{
????????????conn?=?dbmanage.initDB（）;
????????????sta?=?conn.createStatement（）;
????????????System.out.println（“Created?statement...“）;
????????????String?sql?=?“SELECT?‘菜譜‘.‘菜譜ID‘?FROM?‘菜譜‘“;
????????????rs?=?sta.executeQuery（sql）;
????????????while?（rs.next（））{
????????????????int?z=rs.getInt（“菜譜ID“）;
????????????????idlist.add（z）;
????????????}
????????}?catch?（SQLException?e）?{
????????????e.printStackTrace（）;
????????}?finally?{
????????????//?執行完關閉數據庫
????????????dbmanage.closeDB（rs?sta?conn）;
????????}
????}
????int?disNum=20;//每頁顯示的數目
????int?totalPage=idlist.size（）/disNum+1;
????public?int?gettotalPage（）{
????????return?totalPage;
????}
????public?RecipeVo?createRes（ResultSet?rs）{
????????RecipeVo?recipe=null;
????????try?{
????????????while?（rs.next（））{
????????????????recipe=new?RecipeVo（）;
????????????????recipe.setId（rs.getInt（“菜譜ID“））;
????????????????recipe.setName（rs.getString（“菜譜名稱“））;
????????????????recipe.setZuofa（rs.getString（“做法“））;
????????????????recipe.setTexing（rs.getString（“特性“））;
????????????????recipe.setTishi（rs.getString（“提示“））;
????????????????recipe.setTiaoliao（rs.getString（“調料“））;
????????????????recipe.setYuanliao（rs.getString（“原料“））;
????????????}
????????}?catch?（SQLException?e）?{
????????????e.printStackTrace（）;
????????}
????????return?recipe;
????}

????public?ArrayList?display（int?pageNum）{//返回動態數組里面都是RecipeVo
????????int?page=pageNum;//分頁顯示

????????Dbmanage?dbmanage?=?new?Dbmanage（）;
????????Connection?conn?=?null;
????????Statement?sta?=?null;
????????ResultSet?rs?=?null;
????????ArrayList?rvl=new?ArrayList（）;

????????int?start=（page-1）*disNum;

????????try?{
????????????conn?=?dbmanage.initDB（）;
????????????sta?=?conn.createStatement（）;
????????????for（int?i=start;i????????????????if（i>=idlist.size（））{
????????????????????break;
????????????????}
????????????????String?sql=“SELECT?*?FROM?‘菜譜‘?WHERE?‘菜譜‘.‘菜譜ID‘=“+idlist.get（i）;
????????????????rs?=?sta.executeQuery（sql）;
????????????????rvl.add（createRes（rs））;
????????????}
????????}?catch?（SQLException?e）?{

????????????e.printStackTrace（）;
????????}?finally?{
????????????//?執行完關閉數據庫
????????????dbmanage.closeDB（rs?sta?conn）;
????????}
????????return?rvl;
????}


????public?ArrayList?display（int[]?displaylist）{//方法不同顯示的不同這次是按照給定的列表顯示
????????int[]?dislist=displaylist;

????????ArrayList?rvl=new?ArrayList（）;
????????Dbmanage?dbm

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-12-26?16:50??推薦系統畢業論文\
?????文件?????3792896??2017-12-26?15:10??推薦系統畢業論文\caipu.mdb
?????文件?????1633949??2017-12-26?15:11??推薦系統畢業論文\基于內容的推薦算法（推薦系統）（二）.png
?????目錄???????????0??2017-12-26?10:01??推薦系統畢業論文\畢業設計\
?????文件?????3563171??2017-06-10?22:27??推薦系統畢業論文\畢業設計\數據庫.sql
?????目錄???????????0??2017-12-26?10:01??推薦系統畢業論文\畢業設計\源代碼\
?????目錄???????????0??2017-12-26?10:01??推薦系統畢業論文\畢業設計\源代碼\__MACOSX\
?????目錄???????????0??2017-12-26?10:01??推薦系統畢業論文\畢業設計\源代碼\__MACOSX\rec_sys\
?????文件?????????120??2017-04-23?00:20??推薦系統畢業論文\畢業設計\源代碼\__MACOSX\rec_sys\._.DS_Store
?????目錄???????????0??2017-12-26?10:01??推薦系統畢業論文\畢業設計\源代碼\__MACOSX\rec_sys\src\
?????文件?????????120??2017-05-16?20:11??推薦系統畢業論文\畢業設計\源代碼\__MACOSX\rec_sys\src\._.DS_Store
?????目錄???????????0??2017-12-26?10:01??推薦系統畢業論文\畢業設計\源代碼\__MACOSX\rec_sys\src\src\
?????文件?????????120??2017-04-25?11:39??推薦系統畢業論文\畢業設計\源代碼\__MACOSX\rec_sys\src\src\._.DS_Store
?????目錄???????????0??2017-12-26?10:01??推薦系統畢業論文\畢業設計\源代碼\__MACOSX\rec_sys\src\src\main\
?????文件?????????120??2017-04-30?15:59??推薦系統畢業論文\畢業設計\源代碼\__MACOSX\rec_sys\src\src\main\._.DS_Store
?????目錄???????????0??2017-12-26?10:01??推薦系統畢業論文\畢業設計\源代碼\__MACOSX\rec_sys\src\src\main\java\
?????文件?????????120??2017-04-25?11:39??推薦系統畢業論文\畢業設計\源代碼\__MACOSX\rec_sys\src\src\main\java\._.DS_Store
?????目錄???????????0??2017-12-26?10:01??推薦系統畢業論文\畢業設計\源代碼\__MACOSX\rec_sys\src\src\main\java\com\
?????文件?????????120??2017-04-25?11:39??推薦系統畢業論文\畢業設計\源代碼\__MACOSX\rec_sys\src\src\main\java\com\._.DS_Store
?????目錄???????????0??2017-12-26?10:01??推薦系統畢業論文\畢業設計\源代碼\__MACOSX\rec_sys\src\src\main\java\com\sun\
?????文件?????????120??2017-04-25?11:39??推薦系統畢業論文\畢業設計\源代碼\__MACOSX\rec_sys\src\src\main\java\com\sun\._.DS_Store
?????目錄???????????0??2017-12-26?10:01??推薦系統畢業論文\畢業設計\源代碼\__MACOSX\rec_sys\src\src\main\resources\
?????文件?????????222??2017-03-31?06:10??推薦系統畢業論文\畢業設計\源代碼\__MACOSX\rec_sys\src\src\main\resources\._cilin.txt
?????目錄???????????0??2017-12-26?10:01??推薦系統畢業論文\畢業設計\源代碼\__MACOSX\rec_sys\src\web\
?????文件?????????120??2017-04-23?00:04??推薦系統畢業論文\畢業設計\源代碼\__MACOSX\rec_sys\src\web\._.DS_Store
?????目錄???????????0??2017-12-26?10:01??推薦系統畢業論文\畢業設計\源代碼\__MACOSX\rec_sys\src\web\WEB-INF\
?????文件?????????120??2017-04-23?00:21??推薦系統畢業論文\畢業設計\源代碼\__MACOSX\rec_sys\src\web\WEB-INF\._.DS_Store
?????目錄???????????0??2017-12-26?10:01??推薦系統畢業論文\畢業設計\源代碼\rec_sys\
?????文件????????6148??2017-04-23?00:20??推薦系統畢業論文\畢業設計\源代碼\rec_sys\.DS_Store
?????文件?????????554??2016-12-08?11:56??推薦系統畢業論文\畢業設計\源代碼\rec_sys\rec_sys.iml
?????目錄???????????0??2017-12-26?10:01??推薦系統畢業論文\畢業設計\源代碼\rec_sys\src\
............此處省略153個文件信息