/**
*
*/
package y2sjdao;
import java.sql.SQLException;
import java.util.ArrayList;
import y2sjentity.*;
/**
* @author Administrator
*
*/
public class FoodDAO extends BaseDAO {
/**
* 增加的方法
* 继承父类的方法
*
* @throws SQLException
* @throws ClassNotFoundException
*/
// /**
// * 查询方法
// */
// public ArrayList<Product> query(int num) {
// ArrayList<Product> lst = new ArrayList<Product>();
// try {
// String sql = String.format("select top 5 * from Product where productid not in(select top %d productid from Product ) ",
// 5 * (num - 1));
// conn = getConn();
// stm = conn.createStatement();
// rs = stm.executeQuery(sql);
// while (rs.next()) {
// Product product = new Product();
// product.setProductID(rs.getInt(1));
// product.setSerialNumber(rs.getString(2));
// product.setProductName(rs.getString(3));
// product.setBrand(rs.getString(4));
// product.setModel(rs.getString(5));
// product.setPrice(rs.getDouble(6));
// product.setPicture(rs.getString(7));
// product.setDecription(rs.getString(8));
// lst.add(product);
//
// }
// } catch (ClassNotFoundException e) {
// // TODO Auto-generated catch block
// logger.debug(e.getMessage());
// } catch (SQLException e) {
// // TODO Auto-generated catch block
// logger.debug(e.getMessage());
// } finally {
// closeAll();
// }
// return lst;
//
// }
// /**
// * 查询方法
// */
// public ArrayList<Product> queryAllProduct(int num) {
// ArrayList<Product> lst = new ArrayList<Product>();
// try {
// String sql = String.format("select top 15 * from Product where productid not in(select top %d productid from Product ) ",
// 15 * (num - 1));
// conn = getConn();
// stm = conn.createStatement();
// rs = stm.executeQuery(sql);
//
// while (rs.next()) {
// Product product = new Product();
// product.setProductID(rs.getInt(1));
// product.setSerialNumber(rs.getString(2));
// product.setProductName(rs.getString(3));
// product.setBrand(rs.getString(4));
// product.setModel(rs.getString(5));
// product.setPrice(rs.getDouble(6));
// product.setPicture(rs.getString(7));
// product.setDecription(rs.getString(8));
// lst.add(product);
//
// }
// } catch (ClassNotFoundException e) {
// // TODO Auto-generated catch block
// logger.debug(e.getMessage());
// } catch (SQLException e) {
// // TODO Auto-generated catch block
// logger.debug(e.getMessage());
// } finally {
// closeAll();
// }
// return lst;
//
// }
// public ArrayList<Product> queryAll(int num) {
// ArrayList<Product> lst = new ArrayList<Product>();
// try {
// String sql = String.format("select top 10 * from Product where productid not in(select top %d productid from Product ) ",
// 10 * (num - 1));
// conn = getConn();
// stm = conn.createStatement();
// rs = stm.executeQuery(sql);
//
// while (rs.next()) {
// Product product = new Product();
// product.setProductID(rs.getInt(1));
// product.setSerialNumber(rs.getString(2));
// product.setProductName(rs.getString(3));
// product.setBrand(rs.getString(4));
// product.setModel(rs.getString(5));
// product.setPrice(rs.getDouble(6));
// product.setPicture(rs.getString(7));
// product.setDecription(rs.getString(8));
// lst.add(product);
//
// }
// } catch (ClassNotFoundException e) {
// // TODO Auto-generated catch block
// logger.debug(e.getMessage());
// } catch (SQLException e) {
// // TODO Auto-generated catch block
// logger.debug(e.getMessage());
// } finally {
// closeAll();
// }
// return lst;
//
// }
// /**
// * 根据ID来获取商品的详细信息
// */
// public Product findProductByID(int productID){
// Product product=new Product();
// try {
// String sql=String.format("select * from product where productID=%d", productID);
// conn=getConn();
// stm=conn.createStatement();
// rs=stm.executeQuery(sql);
// while(rs.next()){
// product.setProductID(rs.getInt(1));
// product.setSerialNumber(rs.getString("serialNumber"));
// product.setProductName(rs.getString("productName"));
// product.setBrand(rs.getString("brand"));
// product.setModel(rs.getString("model"));
// product.setPrice(rs.getDouble("price"));
// product.setPicture(rs.getString("picture"));
// product.setDecription(rs.getString("description"));
// }
// } catch (ClassNotFoundException e) {
// // TODO Auto-generated catch block
// logger.debug(e.getMessage());
// } catch (SQLException e) {
// // TODO Auto-generated catch block
// logger.debug(e.getMessage());
// }finally
// {
// closeAll();
// }
// return product;
// }
//
// public int getCount()
// {
// String sql="select count(*) from product";
// int count=0;
// try {
// conn=getConn();
// stm=conn.createStatement();
// rs=stm.executeQuery(sql);
// while(rs.next())
// {
// count=rs.getInt(1);
// }
// } catch (ClassNotFoundException e) {
// logger.debug(e.getMessage());
// } catch (SQLException e) {
// logger.debug(e.getMessage());
// }finally{
// closeAll();
// }
// return count;
// }
// public ArrayList<Product> findAll() {
// ArrayList<Product> lst = new ArrayList<Product>();
// try {
// String sql ="select top 8 * from Product ";
// conn = getConn();
// stm = conn.createStatement();
// rs = stm.executeQuery(sql);
// while (rs.next()) {
// Product product = new Product();
// product.setProductID(rs.getInt(1));
// product.setSerialNumber(rs.getString(2));
// product.setProductName(rs.getString(3));
// product.setBrand(rs.getString(4));
// product.setModel(rs.getString(5));
// product.setPrice(rs.getDouble(6));
// product.setPicture(rs.getString(7));
// product.setDecription(rs.getString(8));
// lst.add(product);
//
// }
// } catch (ClassNotFoundException e) {
// // TODO Auto-generated catch block
// logger.debug(e.getMessage());
// } catch (SQLException e) {
// // TODO Auto-generated catch block
// logger.debug(e.getMessage());
// } finally {
// closeAll();
// }
// return lst;
// }
/**
* 从数据库中取出所有的菜单列表的方法
*/
public ArrayList<ShowFood> queryAll(){
ArrayList<ShowFood> lst=new ArrayList<ShowFood>();
try {
String sql="select * from showfood";
conn=getConn();
stm=conn.createStatement();
rs=stm.executeQuery(sql);
while(rs.next()){
ShowFood food=new ShowFood();
food.setId(rs.getString("id"));
food.setName(rs.getString("name"));
food.setButton1(rs.getString("button1"));
food.setButton2(rs.getString("button2"));
food.setDescription(rs.getString("description"));
food.setPicture(rs.getString("picture"));
food.setPrice(rs.getDouble("price"));
lst.add(food);
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
logger.debug(e.getMessage());
} catch (SQLException e) {
// TODO Auto-generated catch block
logger.debug(e.getMessage());
}finally{
closeAll();
}
return lst;
}
/**
* 详细信息的页面，不用取出详细信息的图片
* 根据ID取出所有的信息
*/
public ShowFood findShowFoodByID(String id){
ShowFood show=new ShowFood();
try {
String sql=String.format("select * from showfood where id=%s", id);
conn=getConn();
stm =conn.createStatement();
rs=stm.executeQuery(sql);
while(rs.next()){
show.setId(rs.getString("id"));
show.setButton1(rs.getString("button1"));
show.setButton2(rs.getString("button2"));
show.setDescription(rs.getString("description"));
show.setName(rs.getString("name"));
show.setPicture(rs.getString("picture"));
show.setPrice(rs.getDouble("price"));
}
} catch (ClassNotFoundExcepti
---mvc.rar （81个子文件） 
restrant src y2sjentity 
ShowFood.java 2KB log4j.properties 619B y2sjdao BaseDAO.java 3KB FoodDAO.java 8KB .project 1KB WebRoot css styles.css 772B cho1 details.jsp 3KB show.jsp 4KB images 
500033.jpg 39KB 500023.jpg 18KB jb_logo.jpg 4KB 500008.jpg 18KB
5.gif 563B 500046.jpg 4KB 2.gif 574B 002.gif 65B 005.gif 57B 0.gif 575B insider_cn.gif 2KB 500024.jpg 12KB dynamic_cn.gif 2KB 004.gif 59B 001.gif 129B 500045.jpg 28KB detail_cn.gif 1KB 500047.jpg 11KB 500026.jpg 15KB buy_cn.gif 1KB link_cn.gif 2KB 500041.jpg 10KB DateTime2.js 762B 500044.jpg 47KB 001.jpg 11KB 002.jpg 17KB 003.gif 52B Thumbs.db 131KB 500038.jpg 14KB 500034.jpg 14KB 500022.jpg 9KB 500036.jpg 17KB 500042.jpg 12KB 500035.jpg 11KB tp009.gif 5KB left_top.jpg 337KB lcart_cn.gif 2KB 500043.jpg 18KB 500025.jpg 17KB META-INF MANIFEST.MF 39B WEB-INF scriptfree.tld 2KB c-1_0.tld 11KB fmt-1_0.tld 12KB fn.tld 7KB web.xml 375B fmt.tld 19KB x.tld 12KB x-1_0-rt.tld 7KB fmt-1_0-rt.tld 11KB x-1_0.tld 7KB sql.tld 8KB classes y2sjentity ShowFood.class 2KB log4j.properties 619B y2sjdao FoodDAO.class 3KB BaseDAO.class 2KB sql-1_0.tld 6KB sql-1_0-rt.tld 5KB lib 
sqljdbc.jar 247KB log4j-1.2.9.jar 344KB standard.jar 343KB jstl.jar 17KB c-1_0-rt.tld 11KB permittedTaglibs.tld 1KB c.tld 16KB index.jsp 834B public BodyFoot.jsp 749B BodyInnerTop.jsp 834B BodyTop.jsp 2KB BodyLeft.jsp 1KB Food_log.ldf 1024KB .mymetadata 297B .classpath 622B .myeclipse Food.mdf 3MB资源评论
