memberdaoimpl.java~14~

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

package com.wgh.dao;

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

public class MemberDaoImpl
    implements MemberDao {
  private connDB conn = new connDB();
  //执行插入操作
  public int insert(member m) {
    int ret = -1;
    try {
      String sql = "Insert into tb_Member (UserName,TrueName,PassWord,City,address,postcode,CardNO,CardType,Tel,Email) values('" +
          m.getUserName() + "','" + m.getTrueName() + "','" + m.getPWD() +
          "','" + m.getCity() + "','" + m.getAddress() + "','" +
          m.getPostCode() +
          "','" + m.getCardNO() + "','" + m.getCardType() + "','" + m.getTel() +
          "','" + m.getEmail() + "')";
      System.out.println(sql);
      ret = conn.executeUpdate(sql);
    }
    catch (Exception e) {
      ret = 0;
    }
    conn.close();
    return ret;
  }

  //执行修改操作
  public int update(member m) {
    return 0;
  }

  //执行删除操作
  public int delete(member m) {
    //String sql = "delect from tb_member where ID="+m.getID();
    // int ret=conn.executeUpdate(sql);
    conn.close();
    return 0;
  }

  //执行查询操作
  public List select() {
    member form = null;
    List list = new ArrayList();
    String sql = "select * from tb_member";
    ResultSet rs = conn.executeQuery(sql);
    try {
      while (rs.next()) {
        form = new member();
        //form.setID(Integer.valueOf(rs.getString(1)));

        list.add(form);
      }
    }
    catch (SQLException ex) {
    }
    conn.close();
    return list;
  }

  public member select1() {
    return null;
  }

}