commercedaoimpl.java~10~

来自「电子商务系统(系统主要分为前台和后台。前台包括产品的展示及会员购物等模块」· JAVA~10~ 代码 · 共 35 行

package com.wgh.dao;

import commerce.member;
import com.wgh.DB.connDB;
import java.util.List;

public class CommerceDaoImpl
    implements CommerceDao {
  private connDB conn = new connDB();
  //执行插入操作
  public int insert(member aa) {
    String sql = "Insert into tb_Member (username,truename,password,city,address,postcode,cardNO,CardType,tel,Email) values('" +
        aa.getUserName() + "','" + aa.getTrueName() + "','" + aa.getPWD() +
        "','" + aa.getCity() + "','" + aa.getaddress() + "','" + aa.getpostcode() +
        "','" + aa.getCardNO() + "','" + aa.getCardType() + "','" + aa.getTel() +
        "','" + aa.getEmail() + "')";
    int ret=conn.executeUpdate(sql);
    conn.close();
    return ret;
  }
  //执行修改操作
  public int update(member bb) {
    return 0;
  }
  //执行删除操作
  public int delete(member cc) {
    return 0;
  }
  //执行查询操作
  public List select() {
    return null;
  }

}