goodsdaoimpl.java~4~

电子商务系统 系统主要分为前台和后台。前台包括产品的展示及会员购物等模块

package com.wgh.dao;

import commerce.goods;
import com.wgh.DB.chStr;
import com.wgh.DB.connDB;

public class GoodsDaoImpl
    implements GoodsDao {
  connDB conn = new connDB();
  chStr chStr = new chStr();
  public int insert(goods g) {
    int ret = -1;
    try {
      String sql = "Insert into tb_goods (TypeID,GoodsName,Introduce,Pirce,nowPirce,picture,newgoods,sale) values(" +
          g.getTypeID() + ",'" + chStr.chStr(g.getGoodsName()) + "','" +
          chStr.chStr(g.getIntroduce()) + "'," + g.getPrice() + "," +
          g.getPrice() + ",'" + chStr.chStr(g.getPicture()) + "'," +
          g.getNewGoods() + "," + g.getSale() + ")";
      ret = conn.executeUpdate(sql);
    }
    catch (Exception e) {
      ret = 0;
    }
    conn.close();
    return ret;
  }

  public int update(goods g) {
    int ret = -1;
   chStr chStr = new chStr();
   try {
     String sql = "update tb_member set TrueName='" +
         chStr.chStr(m.getTruename()) +
         "',PassWord='" + chStr.chStr(m.getPwd()) + "',City='" +
         chStr.chStr(m.getCity()) + "',address='" + chStr.chStr(m.getAddress()) +
         "',postcode='" + chStr.chStr(m.getPostcode()) +
         "',CardNO='" + chStr.chStr(m.getCardno()) + "',CardType='" +
         chStr.chStr(m.getCardtype()) + "',Tel='" + chStr.chStr(m.getTel()) +
         "',Email='" + chStr.chStr(m.getEmail()) + "' where ID=" + m.getID();
     ret = conn.executeUpdate(sql);
   }
   catch (Exception e) {
     ret = 0;
   }
   conn.close();
   return ret;
 }


  public int delete(goods g) {
    return 0;
  }

}