memberdao.java

一个完整的网络订餐系统

     whereStr = whereStr.substring(0, lenOfWhereStr - 4);
   }
   if (!whereStr.equals("")) {
     strSQL = strSQL + " WHERE " + whereStr;
     strSQLForCount = strSQLForCount + " WHERE " + whereStr;
   }
   if (! ( ("".equals(orderStr))) && (orderStr != null)) {
     strSQL = strSQL + " Order by " + orderStr;
   }

   try {
     dbc = new DBConnection();
     conn = dbc.getDBConnection();
     stmt = conn.createStatement();
     rs = stmt.executeQuery(strSQLForCount);
     if (!rs.next()) {
       throw new Exception("\u83B7\u5F97\u603B\u8BB0\u5F55\u6570\u5931\u8D25");
     }
     totalRecNum = rs.getInt(1);

     rs.close();
     rs = null;
     rs = stmt.executeQuery(strSQL);
     boolean rsresult = false;
     boolean hasnext = false;
     for (int j = 1; j <= startRecNum; j++)
       rsresult = rs.next();

     if (rsresult) {
       hasnext = true;
       for (int i = 1; i <= recNumOfPage && hasnext; i++) {
         Member model = new Member();
         model.setMemberID(rs.getString("memberID"));
         model.setMemberAccount(rs.getString("memberAccount"));
         model.setMemberPass(rs.getString("memberPass"));
         model.setMemberGrade(rs.getString("memberGrade"));
         model.setMemberPoint(rs.getInt("memberPoint"));
         model.setRealName(rs.getString("realName"));
         model.setGender(rs.getString("gender"));
         model.setBirthday(rs.getString("birthday"));
         model.setCompany(rs.getString("company"));
         model.setDepartment(rs.getString("department"));
         model.setAddress(rs.getString("address"));
         model.setPostCode(rs.getString("postCode"));
         model.setProvince(rs.getString("province"));
         model.setCity(rs.getString("city"));
         model.setPhone(rs.getString("phone"));
         model.setMSN(rs.getString("MSN"));
         model.setEmail(rs.getString("email"));
         model.setFoodhabit(rs.getString("foodhabit"));
         model.setRegDate(rs.getString("regDate"));
         model.setModifyDate(rs.getString("modifyDate"));
         model.setPrePaid(rs.getFloat("prePaid"));
         memberList.add(model);
         if (rs.next()) {
           hasnext = true;
         }
         else {
           hasnext = false;
         }
       }
     }

   }
   catch (Exception exception) {
     exception.printStackTrace();
   }
   finally {
     try {
       if (rs != null)
         rs.close();
       if (stmt != null)
         stmt.close();
       if (conn != null)
         dbc.closeDBConnection(conn);
     }
     catch (SQLException e) {}
   }

   bsrt.setMemberList(memberList);
   bsrt.setTotalRecNum(totalRecNum);
   return bsrt;
 }


 //获得一个会员的详细信息
 public Member getOneMemberByID(String memberID)
 {
   DBConnection dbc = null;
   Connection conn = null;
   Statement stmt = null;
   ResultSet rs = null;
   Member model = null;
   String strSQL = " SELECT * FROM member  where memberID='"+memberID+"'";
   try
   {
     dbc = new DBConnection();
     conn = dbc.getDBConnection();
     stmt = conn.createStatement();
     rs = stmt.executeQuery(strSQL);
     if (rs.next())
     {
       model = new Member();
       model.setMemberID(rs.getString("memberID"));
       model.setMemberAccount(rs.getString("memberAccount"));
       model.setMemberPass(rs.getString("memberPass"));
       model.setMemberGrade(rs.getString("memberGrade"));
       model.setMemberPoint(rs.getInt("memberPoint"));
       model.setRealName(rs.getString("realName"));
       model.setGender(rs.getString("gender"));
       model.setBirthday(rs.getString("birthday"));
       model.setCompany(rs.getString("company"));
       model.setDepartment(rs.getString("department"));
       model.setAddress(rs.getString("address"));
       model.setPostCode(rs.getString("postCode"));
       model.setProvince(rs.getString("province"));
       model.setCity(rs.getString("city"));
       model.setPhone(rs.getString("phone"));
       model.setMSN(rs.getString("MSN"));
       model.setEmail(rs.getString("email"));
       model.setFoodhabit(rs.getString("foodhabit"));
       model.setRegDate(rs.getString("regDate"));
       model.setModifyDate(rs.getString("modifyDate"));
       model.setPrePaid(rs.getFloat("prePaid"));
     }
    }
   catch (Exception exception) {
     exception.printStackTrace();
   }
   finally {
     try {
       if (rs != null)
         rs.close();
       if (stmt != null)
         stmt.close();
       if (conn != null)
         dbc.closeDBConnection(conn);
     }
     catch (SQLException e) {}
   }
   return model;
 }

 //获得一个会员的详细信息
public Member getOneMemberByAccount(String memberAccount)
{
  DBConnection dbc = null;
  Connection conn = null;
  Statement stmt = null;
  ResultSet rs = null;
  Member model = null;
  String strSQL = " SELECT * FROM member  where memberAccount='"+memberAccount+"'";
  try
  {
    dbc = new DBConnection();
    conn = dbc.getDBConnection();
    stmt = conn.createStatement();
    rs = stmt.executeQuery(strSQL);
    if (rs.next())
    {
      model = new Member();
      model.setMemberID(rs.getString("memberID"));
      model.setMemberAccount(rs.getString("memberAccount"));
      model.setMemberPass(rs.getString("memberPass"));
      model.setMemberGrade(rs.getString("memberGrade"));
      model.setMemberPoint(rs.getInt("memberPoint"));
      model.setRealName(rs.getString("realName"));
      model.setGender(rs.getString("gender"));
      model.setBirthday(rs.getString("birthday"));
      model.setCompany(rs.getString("company"));
      model.setDepartment(rs.getString("department"));
      model.setAddress(rs.getString("address"));
      model.setPostCode(rs.getString("postCode"));
      model.setProvince(rs.getString("province"));
      model.setCity(rs.getString("city"));
      model.setPhone(rs.getString("phone"));
      model.setMSN(rs.getString("MSN"));
      model.setEmail(rs.getString("email"));
      model.setFoodhabit(rs.getString("foodhabit"));
      model.setRegDate(rs.getString("regDate"));
      model.setModifyDate(rs.getString("modifyDate"));
      model.setPrePaid(rs.getFloat("prePaid"));
    }
   }
  catch (Exception exception) {
    exception.printStackTrace();
  }
  finally {
    try {
      if (rs != null)
        rs.close();
      if (stmt != null)
        stmt.close();
      if (conn != null)
        dbc.closeDBConnection(conn);
    }
    catch (SQLException e) {}
  }
  return model;
}


 public boolean checkMemberAccount(String account)
 {
   DBConnection dbc = null;
   Connection conn = null;
   Statement stmt = null;
   ResultSet rs = null;
   boolean isMemeber = false;
   String strSQL = " SELECT * FROM member  where memberAccount='" + account + "'";
   try {
     dbc = new DBConnection();
     conn = dbc.getDBConnection();
     stmt = conn.createStatement();
     rs = stmt.executeQuery(strSQL);
     if (rs.next()) {
       isMemeber = true;
     }
   }
   catch (Exception exception) {
     exception.printStackTrace();
   }
   finally {
     try {
       if (rs != null)
         rs.close();
       if (stmt != null)
         stmt.close();
       if (conn != null)
         dbc.closeDBConnection(conn);
     }
     catch (SQLException e) {}
   }
   return isMemeber;
 }


 public String logonEsnack(String account,String pass)
 {
   DBConnection dbc = null;
   Connection conn = null;
   Statement stmt = null;
   ResultSet rs = null;
   String address = null;
   String strSQL = " SELECT address FROM member  where memberAccount='" + account + "' and memberPass='"+pass+"'";

   try {
     dbc = new DBConnection();
     conn = dbc.getDBConnection();
     stmt = conn.createStatement();
     rs = stmt.executeQuery(strSQL);
     if (rs.next()) {
       address = rs.getString("address");
     }
   }
   catch (Exception exception) {
     exception.printStackTrace();
   }
   finally {
     try {
       if (rs != null)
         rs.close();
       if (stmt != null)
         stmt.close();
       if (conn != null)
         dbc.closeDBConnection(conn);
     }
     catch (SQLException e) {}
   }
   return address;
 }

 //插入会员为论坛会员
public int inserMemberToBBS(Member model) {
 int nRet = 0;
 DBConnection dbc = null;
 Connection conn = null;
 Statement stmt = null;
 String strSQL = null;

 try {
   dbc = new DBConnection();
   conn = dbc.getDBConnection();
   stmt = conn.createStatement();


   String memberID =model.getMemberID();
   String memberAccount =model.getMemberAccount();
   String memberPass = model.getMemberPass();
   String memberGrade = model.getMemberGrade();
   int memberPoint = model.getMemberPoint();
   String realName = model.getRealName();
   String gender = model.getGender();
   String birthday = model.getBirthday();
   String company = model.getCompany();
   String department = model.getDepartment();
   String address = model.getAddress();
   String postCode = model.getPostCode();
   String province = model.getProvince();
   String city = model.getCity();
   String phone = model.getPhone();
   String MSN = model.getMSN();
   String email = model.getEmail();
   String foodhabit = model.getFoodhabit();
   String remoteIP= model.getRemoteIP();

   String codedPass = Encoder.getMD5_Base64(memberPass);
   int nSex  =0;
   if(("男").equals(gender))
     nSex = 1;
    if(("").equals(email)||null==email)
       email = memberAccount+"@126.com";

   strSQL = "INSERT INTO mvnforumMember (MemberName, MemberPassword, MemberFirstEmail, MemberEmail, MemberEmailVisible, MemberNameVisible, "+
                                        "MemberFirstIP, MemberLastIP, MemberViewCount, MemberPostCount, MemberCreationDate, MemberModifiedDate,"+
                                        "MemberExpireDate, MemberLastLogon, MemberOption, MemberStatus, MemberActivateCode, MemberTempPassword, "+
                                        "MemberMessageCount, MemberMessageOption, MemberPostsPerPage, MemberWarnCount, MemberVoteCount, "+
                                        "MemberVoteTotalStars, MemberRewardPoints, MemberTitle, MemberTimeZone, MemberSignature, MemberAvatar,"+
                                        "MemberSkin, MemberLanguage, MemberFirstname, MemberLastname, MemberGender, MemberBirthday, MemberAddress,"+
                                        "MemberCity, MemberState, MemberCountry, MemberPhone, MemberMobile, MemberFax, MemberCareer, MemberHomepage,"+
                                        "MemberYahoo, MemberAol, MemberIcq, MemberMsn, MemberCoolLink1, MemberCoolLink2) VALUES ('"+
                                        memberAccount+"', '"+codedPass+"', '"+email+"', '"+email+"', '0', '1', '"+
                                        remoteIP+"', '"+remoteIP+"', '0', '0',GETDATE(), GETDATE(),"+
                                        "GETDATE(), GETDATE(), '0', '0','',  '',"+
                                        "'0', '0',  '10', '0', '0',"+
                                        "'0',  '0', '','0', '', '', "+
                                        "'',  '', '','', "+nSex+",'"+birthday+"','"+address+"','"+
                                        city+"', '"+province+"','', '"+phone+"',  '',  '', '','',"+
                                        "'', '', '',   '"+MSN+"', '','')";



   nRet = stmt.executeUpdate(strSQL);
 }
 catch (Exception e) {
   nRet = -1;
   e.printStackTrace();
   System.out.println("\n" + e.toString() + "插入会员记录" + strSQL); /////错误处理！
 }
 finally {
   try {
     if (stmt != null) {
       stmt.close();
     }
     if (conn != null) {
       dbc.closeDBConnection(conn);
     }
   }
   catch (Exception ex) {}
 }
 return nRet;
}





}