commercedaoimpl.java~12~

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

package com.wgh.dao;

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

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() {
    List list=new ArrayList();
    String sql="select * from tb_member";
    ResultSet rs=conn.executeQuery(sql);
    while (rs.next()){
      
    }
    return null;
  }

  public member select1() {
    return null;
  }

}