memberinfo_bean.java~31~

模仿Taobao购物网

package taobaoproject;

import java.sql.*;
import java.io.*;

public class MemberInfo_Bean {
    private static Connection con;
    private PreparedStatement pre;
    private ResultSet rs;
    private boolean isinsert;
    private boolean isupdate;
    private boolean isIsinsert=false;
    private boolean isIsupdate;
    private boolean isselect;
    private boolean isdelete;
    private boolean isIsselect=false;
    private boolean isIsdelete=false;
    //private void memberID;
    public MemberInfo_Bean() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
    }
//数据库连接
    public static Connection getCon() {
        con=DB_Bean.getConn();
        return con;

    }

    public void setIsinsert(boolean isinsert) {
        this.isinsert = isinsert;
    }

    public void setIsupdate(boolean isupdate) {
        this.isupdate = isupdate;
    }

    public void setIsdelete(boolean isdelete) {
        this.isdelete = isdelete;
    }
public String zhongwen(String s){
    try {
        String d = new String(s.getBytes("ISO-8859-1"), "GBK");
        return d;
    } catch (UnsupportedEncodingException ex) {
        //System.out.println(ex);
        return "";
    }
}
    //tb_Member（会员注册表）插入数据
    public boolean isIsinsert(MemberBean mb) {
       //MemberBean memberBean = new MemberBean();
       con=getCon();
       try {
           pre = con.prepareStatement(
                   "insert into tb_Member(Name,Sex,Psaaword,TrueName,Phonecode,Emails,City,Address,PostCode,LoadDate) values(?,?,?,?,?,?,?,?,?,?)");
           pre.setString(1,zhongwen(mb.getName()));
           pre.setString(2,zhongwen(mb.getSex()));
           pre.setString(3,zhongwen(mb.getPassword()));
           pre.setString(4,zhongwen(mb.getTrueName()));
           pre.setString(5,zhongwen(mb.getPhoneCode()));
           pre.setString(6,zhongwen(mb.getEmails()));
           pre.setString(7,zhongwen(mb.getCity()));
           pre.setString(8,zhongwen(mb.getAddress()));
           pre.setString(9,zhongwen(mb.getPostCode()));
           pre.setString(10,mb.getLoadDate());
           int i = pre.executeUpdate();
           if(i>0){
              isIsinsert=true;
           }
           pre.close();
           con.close();
       } catch (Exception ex) {
           System.out.println(ex);
           isIsinsert=false;
       }
        return isIsinsert;
    }
    //tb_Member（会员注册表）更新数据
    public boolean isIsupdate(MemberBean memberBean) {
        isIsupdate=false;
        //MemberBean memberBean = new MemberBean();
        getCon();
    try {
        pre = con.prepareStatement("update tb_Member set Sex=?,Psaaword=?,TrueName=?,Phonecode=?,Emails=?,City=?,Address=?,PostCode=? where Name=?");

        pre.setString(1,zhongwen(memberBean.getSex()));
        pre.setString(2,zhongwen(memberBean.getPassword()));
        pre.setString(3,zhongwen(memberBean.getTrueName()));
        pre.setString(4,zhongwen(memberBean.getPhoneCode()));
        pre.setString(5,zhongwen(memberBean.getEmails()));
        pre.setString(6,zhongwen(memberBean.getCity()));
        pre.setString(7,zhongwen(memberBean.getAddress()));
        pre.setString(8,zhongwen(memberBean.getPostCode()));
        pre.setString(9,zhongwen(memberBean.getName()));
        int i = pre.executeUpdate();
        if(i > 0) {
            isIsupdate = true;
        }
        pre.close();
        con.close();
    } catch (Exception ex) {
        System.out.println(ex);
        isIsupdate=false;
    }
        return isIsupdate;
    }
//查询会员注册信息
    public MemberBean isIsselect(String _name) {
       MemberBean memberBean = new MemberBean();
       getCon();
    try {
        pre = con.prepareStatement("select * from tb_Member where Name=?");
        pre.setString(1,_name);
        rs=pre.executeQuery();
        while(rs.next()){
            memberBean.setMemberID(rs.getInt("MemberID"));
            memberBean.setName(zhongwen(rs.getString("Name")));
            memberBean.setSex(zhongwen(rs.getString("Sex")));
            memberBean.setPassword(zhongwen(rs.getString("Psaaword")));
            memberBean.setTrueName(zhongwen(rs.getString("TrueName")));
            memberBean.setPhoneCode(zhongwen(rs.getString("Phonecode")));
            memberBean.setEmails(zhongwen(rs.getString("Emails")));
            memberBean.setCity(zhongwen(rs.getString("City")));
            memberBean.setAddress(zhongwen(rs.getString("Address")));
            memberBean.setPostCode(zhongwen(rs.getString("PostCode")));
            memberBean.setLoadDate(zhongwen(rs.getString("LoadDate")));
        }
        rs.close();
        pre.close();
        con.close();

    } catch (Exception ex) {
        System.out.println(ex);
    }
        return memberBean;
    }
    //删除会员注册信息
    public boolean isIsdelete() {
       MemberBean memberBean = new MemberBean();
       getCon();
    try {
        pre = con.prepareStatement("delete tb_Member set name=?,sex=?,password=?,trueName=?phonecode=?,emails=?,city=?,address=?postCode=?,loadDate=?  where MemberID=?");
        pre.setString(1,memberBean.getName());
        pre.setString(2,memberBean.getSex());
        pre.setString(3,memberBean.getPassword());
        pre.setString(4,memberBean.getTrueName());
        pre.setString(5,memberBean.getPhoneCode());
        pre.setString(6,memberBean.getEmails());
        pre.setString(7,memberBean.getCity());
        pre.setString(8,memberBean.getAddress());
        pre.setString(9,memberBean.getPostCode());
        pre.setString(10,memberBean.getLoadDate());
        pre.setInt(11,memberBean.getMemberID());
        int i = pre.executeUpdate();
        if(i>0){
          isIsdelete=true;
        }
        pre.close();
        con.close();
    } catch (Exception ex) {
        System.out.println(ex);
        isIsdelete=false;
    }
        return isIsdelete;
    }
}