开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > Java编程 > Jsp/Servlet > 查看源码
GoodsDao.java
资源名称：LibraryManage.rar　[点击查看]
上传用户：toby828
上传日期：2015-06-26
资源大小：8558k
文件大小：8k
源码类别：

Jsp/Servlet

开发平台：

Java

GoodsDao.java：源码内容
  1. package com.dao;
  3. import java.sql.*;
  4. import java.util.*;
  6. import com.tool.JDBConnection;
  7. import com.tool.FinalConstants;
  8. import com.domain.GoodsForm;
  10. //对商品表的操作
  11. public class GoodsDao {
  12.   private Connection connection = null; //定义连接的对象
  13.   private PreparedStatement ps = null; //定义预准备的对象
  14.   private JDBConnection jdbc = null; //定义数据库连接对象
  15.   public GoodsDao() {
  16.     jdbc = new JDBConnection();
  17.     connection = jdbc.connection; //利用构造方法取得数据库连接
  18.   }
  20. //根据商品的ID修改购买商品的数量
  21.   public void updateGoodsNumber(int number, Integer id) {
  22.     try {
  23.       ps = connection.prepareStatement(FinalConstants.goods_updateNumber);
  24.       ps.setInt(1, number);
  25.       ps.setInt(2, id.intValue());
  26.       ps.executeUpdate();
  27.       ps.close();
  28.     }
  29.     catch (SQLException ex) {
  30.     }
  32.   }
  34. //设置特价价格的方法
  35.   public void managerPrice(GoodsForm form) {
  36.     try {
  37.       ps = connection.prepareStatement(FinalConstants.goods_updatePirce);
  38.       ps.setFloat(1, form.getFreePrice().floatValue());
  39.       ps.setInt(2, form.getMark().intValue());
  40.       ps.setInt(3, form.getId().intValue());
  41.       ps.executeUpdate();
  42.       ps.close();
  43.     }
  44.     catch (SQLException ex) {
  45.     }
  46.   }
  48.   //以商品的是否特价为条件查询信息
  49.   public List selectMark(Integer mark) {
  50.     List list = new ArrayList();
  51.     GoodsForm goods = null;
  52.     try {
  53.       ps = connection.prepareStatement(FinalConstants.goods_selectMark);
  54.       ps.setInt(1, mark.intValue());
  55.       ResultSet rs = ps.executeQuery();
  56.       while (rs.next()) {
  57.         goods = new GoodsForm();
  58.         goods.setId(Integer.valueOf(rs.getString(1)));
  59.         goods.setBig(Integer.valueOf(rs.getString(2)));
  60.         goods.setSmall(Integer.valueOf(rs.getString(3)));
  61.         goods.setName(rs.getString(4));
  62.         goods.setFrom(rs.getString(5));
  63.         goods.setIntroduce(rs.getString(6));
  64.         goods.setCreaTime(rs.getString(7));
  65.         goods.setNowPrice(Float.valueOf(rs.getString(8)));
  66.         goods.setFreePrice(Float.valueOf(rs.getString(9)));
  67.         goods.setNumber(Integer.valueOf(rs.getString(10)));
  68.         goods.setPriture(rs.getString(11));
  69.         goods.setMark(Integer.valueOf(rs.getString(12)));
  70.         list.add(goods);
  71.       }
  72.     }
  73.     catch (SQLException ex) {
  74.     }
  75.     return list;
  76.   }
  78. //添加操作
  79.   public void insertGoods(GoodsForm form) {
  80.     try {
  81.       ps = connection.prepareStatement(FinalConstants.goods_insert);
  82.       ps.setInt(1, form.getBig().intValue());
  83.       ps.setInt(2, form.getSmall().intValue());
  84.       ps.setString(3, form.getName());
  85.       ps.setString(4, form.getFrom());
  86.       ps.setString(5, form.getIntroduce());
  87.       ps.setFloat(6, form.getNowPrice().floatValue());
  88.       ps.setFloat(7, form.getFreePrice().floatValue());
  89.       ps.setInt(8, 0);
  90.       ps.setString(9, form.getPicture());
  91.       ps.setInt(10, 0);
  92.       ps.executeUpdate();
  93.       ps.close();
  94.     }
  95.     catch (SQLException ex) {
  96.     }
  97.   }
  99. //以商品编号为条件删除信息
  100.   public void deleteGoods(Integer id) {
  101.     try {
  102.       ps = connection.prepareStatement(FinalConstants.goods_delete);
  103.       ps.setInt(1, id.intValue());
  104.       ps.executeUpdate();
  105.       ps.close();
  106.     }
  107.     catch (SQLException ex) {
  108.     }
  109.   }
  111. //以商品的编号为条件查询信息
  112.   public GoodsForm selectOneGoods(Integer id) {
  113.     GoodsForm goods = null;
  114.     try {
  115.       ps = connection.prepareStatement(FinalConstants.goods_selectOne);
  116.       ps.setInt(1, id.intValue());
  117.       ResultSet rs = ps.executeQuery();
  118.       while (rs.next()) {
  119.         goods = new GoodsForm();
  120.         goods.setId(Integer.valueOf(rs.getString(1)));
  121.         goods.setBig(Integer.valueOf(rs.getString(2)));
  122.         goods.setSmall(Integer.valueOf(rs.getString(3)));
  123.         goods.setName(rs.getString(4));
  124.         goods.setFrom(rs.getString(5));
  125.         goods.setIntroduce(rs.getString(6));
  126.         goods.setCreaTime(rs.getString(7));
  127.         goods.setNowPrice(Float.valueOf(rs.getString(8)));
  128.         goods.setFreePrice(Float.valueOf(rs.getString(9)));
  129.         goods.setNumber(Integer.valueOf(rs.getString(10)));
  130.         goods.setPriture(rs.getString(11));
  131.         goods.setMark(Integer.valueOf(rs.getString(12)));
  132.       }
  133.     }
  134.     catch (SQLException ex) {
  135.     }
  136.     return goods;
  137.   }
  139.   //以商品的小类别的编号为条件查询信息
  140.   public List selectSmall(Integer small) {
  141.     List list = new ArrayList();
  142.     GoodsForm goods = null;
  143.     try {
  144.       ps = connection.prepareStatement(FinalConstants.goods_selectSmall);
  145.       ps.setInt(1, small.intValue());
  146.       ResultSet rs = ps.executeQuery();
  147.       while (rs.next()) {
  148.         goods = new GoodsForm();
  149.         goods.setId(Integer.valueOf(rs.getString(1)));
  150.         goods.setBig(Integer.valueOf(rs.getString(2)));
  151.         goods.setSmall(Integer.valueOf(rs.getString(3)));
  152.         goods.setName(rs.getString(4));
  153.         goods.setFrom(rs.getString(5));
  154.         goods.setIntroduce(rs.getString(6));
  155.         goods.setCreaTime(rs.getString(7));
  156.         goods.setNowPrice(Float.valueOf(rs.getString(8)));
  157.         goods.setFreePrice(Float.valueOf(rs.getString(9)));
  158.         goods.setNumber(Integer.valueOf(rs.getString(10)));
  159.         goods.setPriture(rs.getString(11));
  160.         goods.setMark(Integer.valueOf(rs.getString(12)));
  161.         list.add(goods);
  162.       }
  163.     }
  164.     catch (SQLException ex) {
  165.     }
  166.     return list;
  167.   }
  169.   //以商品的大类别的编号为条件查询信息
  170.   public List selectBig(Integer big) {
  171.     List list = new ArrayList();
  172.     GoodsForm goods = null;
  173.     try {
  174.       ps = connection.prepareStatement(FinalConstants.goods_selectBig);
  175.       ps.setInt(1, big.intValue());
  176.       ResultSet rs = ps.executeQuery();
  177.       while (rs.next()) {
  178.         goods = new GoodsForm();
  179.         goods.setId(Integer.valueOf(rs.getString(1)));
  180.         goods.setBig(Integer.valueOf(rs.getString(2)));
  181.         goods.setSmall(Integer.valueOf(rs.getString(3)));
  182.         goods.setName(rs.getString(4));
  183.         goods.setFrom(rs.getString(5));
  184.         goods.setIntroduce(rs.getString(6));
  185.         goods.setCreaTime(rs.getString(7));
  186.         goods.setNowPrice(Float.valueOf(rs.getString(8)));
  187.         goods.setFreePrice(Float.valueOf(rs.getString(9)));
  188.         goods.setNumber(Integer.valueOf(rs.getString(10)));
  189.         goods.setPriture(rs.getString(11));
  190.         goods.setMark(Integer.valueOf(rs.getString(12)));
  191.         list.add(goods);
  192.       }
  193.     }
  194.     catch (SQLException ex) {
  195.     }
  196.     return list;
  197.   }
  199. //全部查询
  200.   public List selectGoods() {
  201.     List list = new ArrayList();
  202.     GoodsForm goods = null;
  203.     try {
  204.       ps = connection.prepareStatement(FinalConstants.goods_select);
  205.       ResultSet rs = ps.executeQuery();
  206.       while (rs.next()) {
  207.         goods = new GoodsForm();
  208.         goods.setId(Integer.valueOf(rs.getString(1)));
  209.         goods.setBig(Integer.valueOf(rs.getString(2)));
  210.         goods.setSmall(Integer.valueOf(rs.getString(3)));
  211.         goods.setName(rs.getString(4));
  212.         goods.setFrom(rs.getString(5));
  213.         goods.setIntroduce(rs.getString(6));
  214.         goods.setCreaTime(rs.getString(7));
  215.         goods.setNowPrice(Float.valueOf(rs.getString(8)));
  216.         goods.setFreePrice(Float.valueOf(rs.getString(9)));
  217.         goods.setNumber(Integer.valueOf(rs.getString(10)));
  218.         goods.setPriture(rs.getString(11));
  219.         goods.setMark(Integer.valueOf(rs.getString(12)));
  220.         list.add(goods);
  221.       }
  222.     }
  223.     catch (SQLException ex) {
  224.     }
  225.     return list;
  226.   }
  228.   //全部查询
  229.   public List selectGoodsNumber() {
  230.     List list = new ArrayList();
  231.     GoodsForm goods = null;
  232.     try {
  233.       ps = connection.prepareStatement(FinalConstants.goods_selectNumber);
  234.       ResultSet rs = ps.executeQuery();
  235.       while (rs.next()) {
  236.         goods = new GoodsForm();
  237.         goods.setId(Integer.valueOf(rs.getString(1)));
  238.         goods.setBig(Integer.valueOf(rs.getString(2)));
  239.         goods.setSmall(Integer.valueOf(rs.getString(3)));
  240.         goods.setName(rs.getString(4));
  241.         goods.setFrom(rs.getString(5));
  242.         goods.setIntroduce(rs.getString(6));
  243.         goods.setCreaTime(rs.getString(7));
  244.         goods.setNowPrice(Float.valueOf(rs.getString(8)));
  245.         goods.setFreePrice(Float.valueOf(rs.getString(9)));
  246.         goods.setNumber(Integer.valueOf(rs.getString(10)));
  247.         goods.setPriture(rs.getString(11));
  248.         goods.setMark(Integer.valueOf(rs.getString(12)));
  249.         list.add(goods);
  250.       }
  251.     }
  252.     catch (SQLException ex) {
  253.     }
  254.     return list;
  255.   }
  258. }