?? managermember.java
字號:
package myshop.member_sys;
import myshop.*;
import myshop.member_sys.administratorBean;
import java.sql.*;
import java.util.*;
import javax.servlet.http.*;
public class ManagerMember {
Handle handle;
DBconn dbconn;
Md5 md5;
Config config;
String SystemURL;
public ManagerMember() throws Exception {
dbconn = new DBconn();
handle = new Handle();
md5 = new Md5();
config = new Config();
SystemURL = config.systemURL + config.systemFolder;
}
//--- 用戶注冊 ---
public String Regedit(String tb_member_info,HttpServletRequest request,HttpSession session) throws Exception {
ResultSet rs;
String SqlStr;
String Msg = "";
String account = handle.getString(request,"account");
String pwd = handle.getString(request,"pwd");
String name = handle.getString(request,"name");
String tel = handle.getString(request,"tel");
String address = handle.getString(request,"address");
String email = handle.getString(request,"email");
int age = handle.getInt(request,"age");
int sex = handle.getInt(request,"sex");
pwd = handle.GBK2ISO(pwd);
pwd = md5.getMD5ofStr(pwd);
name = handle.GBK2ISO(name);
tel = handle.GBK2ISO(tel);
address = handle.GBK2ISO(address);
email = handle.GBK2ISO(email);
try {
SqlStr = "SELECT * FROM " + tb_member_info + " WHERE name='" + name + "'";
rs = dbconn.ExeQuery(SqlStr);
if (rs.next()) Msg = "帳號已經存在！<br>[<a href=javascript:history.back()>返回</a>]";
}
catch (SQLException ex) {
System.err.println("aq.executeQuery:"+ex.getMessage());
}
if (!Msg.equals("")) return(Msg);
SqlStr = "INSERT INTO " + tb_member_info + "(account,pwd,name,age,sex,address,tel,email,date_time) VALUES('" + account + "','" + pwd + "','" + name + "'," + age + "," + sex + ",'" + address + "','" + tel + "','" + email + "',sysdate())";
dbconn.ExeUpdate(SqlStr);
dbconn.CloseConn();
session.setAttribute("LoginUser",account);
return("注冊成功！");
}
//--- 檢測帳號 ---
public String CheckAccount(String tb_member_info,HttpServletRequest request) throws Exception {
ResultSet rs;
String SqlStr;
String Msg = "";
String account = handle.getString(request,"account");
try {
SqlStr = "SELECT * FROM " + tb_member_info + " WHERE account='" + account + "'";
rs = dbconn.ExeQuery(SqlStr);
if (!rs.next()) Msg = "恭喜！！該帳號還沒有人使用。";
else Msg = "不好意思，該帳號已經存在！";
dbconn.CloseConn();
}
catch (SQLException ex) {
System.err.println("aq.executeQuery:"+ex.getMessage());
}
return(Msg);
}
//--- 刪除帳號 ---
public void Del(String tb_member_info,HttpServletRequest request) throws Exception {
int Mid = handle.getInt(request,"Mid");
if (Mid != 0) {
String SqlStr = "DELETE FROM " + tb_member_info + " WHERE id=" + Mid;
dbconn.ExeUpdate(SqlStr);
dbconn.CloseConn();
}
}
//--- 顯示登陸界面或用戶信息 ---
public String LoginORInfo(String tb_member_info,HttpServletRequest request,HttpSession session) throws Exception {
String TableStr = "";
String ParaStr = "";
String account="",SqlStr="";
ResultSet rs;
int ProInCar=0,LogNum=0;
Vector tmpVec;
Enumeration e = request.getParameterNames();
while (e.hasMoreElements()) {
String name = (String) e.nextElement();
ParaStr += name + "=" + request.getParameter(name) + "&";
}
ParaStr = "?" + ParaStr;
if (session.getAttribute("LoginUser") == null) {
TableStr += " <form name=form3 method=post action=admin/member_sys/DealWithCenter.jsp?action=login&reference=../../.." + request.getServletPath() + ParaStr + ">";
TableStr += "<table width='100%' border='0' cellspacing='0' cellpadding='0'>";
TableStr += " <tr> ";
TableStr += " <td class='line234'><table width=100% height=138 border=0 cellpadding=0 cellspacing=0>";
TableStr += " <tr> ";
TableStr += " <td height=20 colspan=2 align=center valign=middle><table width='100%' height='22' border='0' cellpadding='0' cellspacing='0'>";
TableStr += " <tr> ";
TableStr += " <td align='center' valign='middle' background='" + SystemURL + "img/top_bg2.jpg'><font color=#FFFFFF>會 ";
TableStr += " 員 登 陸</font></td>";
TableStr += " </tr>";
TableStr += " </table></td>";
TableStr += " </tr>";
TableStr += " <tr> ";
TableStr += " <td width=31% height='41' align=center valign=middle bgcolor='eeeeee'>帳號</td>";
TableStr += " <td width=69% align=center valign=middle bgcolor='eeeeee'><input name=account type=text size=15></td>";
TableStr += " </tr>";
TableStr += " <tr> ";
TableStr += " <td width=31% height='41' align=center valign=middle bgcolor='eeeeee'>密碼</td>";
TableStr += " <td align=center valign=middle bgcolor='eeeeee'><input name=pwd size=15 type=password></td>";
TableStr += " </tr>";
TableStr += " <tr> ";
TableStr += " <td colspan=2 align=center valign=middle bgcolor='eeeeee'><input type=submit name=Submit2 value=登陸> ";
TableStr += " <input type=button name=Submit value=注冊 onClick=location='admin/member_sys/regedit.jsp'> ";
TableStr += " </td>";
TableStr += " </tr>";
TableStr += " <tr align='right'> ";
TableStr += " <td colspan=2 valign=middle bgcolor='eeeeee'><br>";
TableStr += " <img src='" + SystemURL + "img/buttom_line.gif' width='158' height='22'></td>";
TableStr += " </tr>";
TableStr += " </table></td>";
TableStr += " </tr>";
TableStr += "</table>";
TableStr += " </form>";
}
else {
account = (String)session.getAttribute("LoginUser");
account = handle.GBK2ISO(account);
try {
SqlStr = "SELECT * FROM " + tb_member_info + " WHERE account='" + account + "'";
rs = dbconn.ExeQuery(SqlStr);
rs.next();
LogNum = rs.getInt("log_times");
dbconn.CloseConn();
}
catch (SQLException ex) {
System.err.println("aq.executeQuery:"+ex.getMessage());
}
if (session.getAttribute("Car") != null) {
tmpVec = (Vector)session.getAttribute("Car");
ProInCar = tmpVec.size();
}
TableStr += "<table width=100% border=0 cellspacing=0 cellpadding=0>";
TableStr += " <tr> ";
TableStr += " <td align=center valign=top class=line234><table width=100% height=122 border=0 cellpadding=3 cellspacing=1>";
TableStr += " <tr> ";
TableStr += " <td height=20 colspan=2 align=center valign=middle background=" + SystemURL + "img/top_bg2.jpg><font color=#FFFFFF>你 ";
TableStr += " 的 信 息</font></td>";
TableStr += " </tr>";
TableStr += " <tr> ";
TableStr += " <td width=50% align=center valign=middle bgcolor=eeeeee>帳號：</td>";
TableStr += " <td width=50% align=center valign=middle bgcolor=eeeeee>" + account + "</td>";
TableStr += " </tr>";
TableStr += " <tr> ";
TableStr += " <td align=center valign=middle bgcolor=eeeeee>購物車：</td>";
TableStr += " <td align=center valign=middle bgcolor=eeeeee>" + ProInCar + "</td>";
TableStr += " </tr>";
TableStr += " <tr> ";
TableStr += " <td align=center valign=middle bgcolor=eeeeee>登陸：</td>";
TableStr += " <td align=center valign=middle bgcolor=eeeeee>" + LogNum + "</td>";
TableStr += " </tr>";
TableStr += " <tr> ";
TableStr += " <td colspan=2 align=center valign=middle bgcolor=eeeeee><a href=admin/member_sys/modify.jsp>修改資料</a> <a href=admin/purchase_sys/my_order.jsp>查詢訂單</a></td>";
TableStr += " </tr>";
TableStr += " </table></td>";
TableStr += " </tr>";
TableStr += "</table>";
}
return(TableStr);
}
//--- 用戶登陸 ---
public void Login(String tb_member_info,HttpServletRequest request,HttpSession session) throws Exception {
ResultSet rs;
String SqlStr = "";
String account = handle.getString(request,"account");
String pwd = handle.getString(request,"pwd");
account = handle.GBK2ISO(account);
pwd = handle.GBK2ISO(pwd);
pwd = md5.getMD5ofStr(pwd);
try {
SqlStr = "SELECT * FROM " + tb_member_info + " WHERE account='" + account + "' AND pwd='" + pwd + "'";
rs = dbconn.ExeQuery(SqlStr);
if (rs.next()) {
session.setAttribute("LoginUser",account);
//--- 增加登陸次數 ---
SqlStr = "UPDATE " + tb_member_info + " SET log_times=log_times+1 WHERE account='" + account + "'";
dbconn.ExeUpdate(SqlStr);
}
dbconn.CloseConn();
}
catch (SQLException ex) {
System.err.println("aq.executeQuery:"+ex.getMessage());
}
}
//--- 讀取首頁數據 ---
public Hashtable ReadData(String page,int pagesize,String SelfPage,String keywords,String type,String tb_name) throws Exception {
String qry_string;
String HtmlStr="";
String str_rows_count;
int rows_count = 0;
float i=0;
int z;
int ii=0;
Statement stmt;
ResultSet rs;
Hashtable APageParam = new Hashtable();
Hashtable AOutParam = new Hashtable();
try {
keywords = handle.GBK2ISO(keywords);
if (type.equals("name")) qry_string = "SELECT * FROM " + tb_name + " WHERE name LIKE '%" + keywords + "%' ORDER BY id DESC";
else if (type.equals("address")) qry_string = "SELECT * FROM " + tb_name + " WHERE address LIKE '%" + keywords + "%' ORDER BY id DESC";
else qry_string = "SELECT * FROM " + tb_name + " ORDER BY id DESC";
rs = dbconn.ExeQuery(qry_string);
rs.last();
rows_count = rs.getRow();
APageParam = turn_page(page, pagesize, rows_count);
int pt_st = Integer.parseInt(java.lang.String.valueOf(APageParam.get("pt_st"))) + 1;
int pt_en = Integer.parseInt(java.lang.String.valueOf(APageParam.get("pt_en"))) + 1;
rs.absolute(pt_st);
for (ii=pt_st; ii<pt_en; ii++) {
i++;
int id = rs.getInt("id");
String td_bg_color;
if ((i / 2) == (int)(i / 2)) td_bg_color = "f1f1f1";
else td_bg_color = "ffffff";
HtmlStr += " <tr align=center valign=middle bgcolor=" + td_bg_color + "> ";
HtmlStr += " <td>" + (int)i + "-" + id + "</td>";
HtmlStr += " <td>" + rs.getString("account") + "</td>";
HtmlStr += " <td>" + rs.getString("name") + "</td>";
HtmlStr += " <td>" + rs.getInt("sex") + "</td>";
HtmlStr += " <td>" + rs.getInt("age") + "</td>";
HtmlStr += " <td>" + rs.getString("tel") + "</td>";
HtmlStr += " <td>" + rs.getString("address") + "</td>";
HtmlStr += " <td>" + rs.getString("email") + "</td>";
HtmlStr += " <td>" + rs.getString("date_time") + "</td>";
HtmlStr += " <td><a href=DealWithCenter.jsp?action=del&Mid=" + id + " onclick=\"return (AlertDel('" + rs.getString("name") + "'));\"><font color=red>刪除</font></a></td>";
HtmlStr += " </tr>";
if (!rs.next()) break;
}
dbconn.CloseConn();
}
catch(SQLException ex) {
System.err.println("aq.executeQuery:"+ex.getMessage());
}
String turnpage_str = search_turn(APageParam, SelfPage, keywords, type);
AOutParam.put("RecordCount",java.lang.String.valueOf(rows_count));
AOutParam.put("HtmlStr",HtmlStr);
AOutParam.put("TurpageStr",turnpage_str);
return(AOutParam);
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -