📄 managerpurchase.java
字号:
//int APageParam[] = new int[10];
int pagecount;
int pagecount2;
int page1=0;
int page2;
int pt_st;
int pt_en;
int nextpage;
int prevpage;
int out_page;
Hashtable APageParam = new Hashtable();
if (!page.equals("")) page1 = Integer.parseInt(page);
pagecount = rows_count / pagesize;
if (pagesize * pagecount < rows_count) pagecount++;
if (Integer.parseInt(page) > pagecount) page1 = pagecount - 1;
else if (Integer.parseInt(page) < 0) page1 = 0;
pagecount2 = pagecount - 1;
page2 = page1 + 1;
pt_st = page1 * pagesize;
pt_en = pt_st + pagesize;
nextpage = page1 + 1;
prevpage = page1 - 1;
APageParam.put("pt_st",new Integer(pt_st));
APageParam.put("pt_en",new Integer(pt_en));
APageParam.put("nextpage",new Integer(nextpage));
APageParam.put("prevpage",new Integer(prevpage));
APageParam.put("pagesize",new Integer(pagesize));
APageParam.put("pagecount",new Integer(pagecount));
APageParam.put("pagecount2",new Integer(pagecount2));
APageParam.put("page1",new Integer(page1));
APageParam.put("page2",new Integer(page2));
return(APageParam);
}
public String search_turn(Hashtable APageParam,String SelfPage,String keywords,String type) throws Exception {
String turnpage_str="";
int i,j;
int nextpage = Integer.parseInt(java.lang.String.valueOf(APageParam.get("nextpage")));
int prevpage = Integer.parseInt(java.lang.String.valueOf(APageParam.get("prevpage")));
int pagesize = Integer.parseInt(java.lang.String.valueOf(APageParam.get("pagesize")));
int pagecount = Integer.parseInt(java.lang.String.valueOf(APageParam.get("pagecount")));
int pagecount2 = Integer.parseInt(java.lang.String.valueOf(APageParam.get("pagecount2")));
int page_inside = Integer.parseInt(java.lang.String.valueOf(APageParam.get("page1")));
int page2 = Integer.parseInt(java.lang.String.valueOf(APageParam.get("page2")));
keywords = handle.ISO2GBK(keywords);
//--- 显示搜索引擎 ---
turnpage_str += "<form name=form1 method=post action=" + SelfPage + ">\n";
turnpage_str += "<table width=100% border=0 cellspacing=0 cellpadding=0 align=center>\n";
turnpage_str += " <tr> \n";
turnpage_str += " <td bgcolor=999999> \n";
turnpage_str += " <table width=100% border=0 cellspacing=1 cellpadding=3>\n";
turnpage_str += " <tr bgcolor=f1f1f1>\n";
turnpage_str += " <td align=center valign=middle width=50%>关键词： \n";
turnpage_str += " <input type=text name=keywords value=" + keywords + ">\n";
turnpage_str += " \n";
turnpage_str += "<select name=type>\n";
turnpage_str += " <option value=orderid selected>订单编号</option>\n";
turnpage_str += " <option value=name>下单人</option>\n";
turnpage_str += " <option value=r_name>收件人</option>\n";
turnpage_str += "</select>\n";
turnpage_str += " <input type=submit name=Submit value=搜索>\n";
turnpage_str += " </td>\n";
turnpage_str += " <td align=center valign=middle width=50%>\n";
turnpage_str += " <table><tr><td align=center valign=middle width=30%>\n";
turnpage_str += " <SELECT onchange=\"var jmpURL1=this.options[this.selectedIndex].value; if(jmpURL1!='') {self.location=jmpURL1;} else {this.selectedIndex=0;}\" size=1 name=select>\n";
turnpage_str += " <option value=''>选择翻页</option>\n";
for (i=0; i<pagecount; i++) {
j = i + 1;
turnpage_str += " <option value=" + SelfPage + "?CurrentPage=" + i + "&keywords=" + keywords + "&type=" + type + ">第 " + j + " 页</option>\n";
}
turnpage_str += " </select>\n";
turnpage_str += " </td>\n";
turnpage_str += " <td align=center valign=middle width=20%>\n";
turnpage_str += " 当前页：" + page2 + "/" + pagecount;
turnpage_str += " </td>\n";
//--- 显示翻页按钮 ---
turnpage_str = turnpage_str + " <td align=center valign=middle width=40% style='font-family:Webdings'>\n";
if (pagecount != 0) turnpage_str = turnpage_str + "<a href=" + SelfPage + "?CurrentPage=0&keywords=" + keywords + "&type=" + type + " onMouseOver=\"this.style.color='red'\" onMouseOut=\"this.style.color='black'\">7</a> \n";
else turnpage_str = turnpage_str + "7 \n";
if (page_inside != 0) turnpage_str = turnpage_str + "<a href=" + SelfPage + "?CurrentPage=" + prevpage + "&keywords=" + keywords + "&type=" + type + " onMouseOver=\"this.style.color='red'\" onMouseOut=\"this.style.color='black'\">3</a>\n";
else turnpage_str += "3\n";
if (page_inside != pagecount2 && pagecount != 0) turnpage_str = turnpage_str + " <a href=" + SelfPage + "?CurrentPage=" + nextpage + "&keywords=" + keywords + "&type=" + type + " onMouseOver=\"this.style.color='red'\" onMouseOut=\"this.style.color='black'\">4</a> \n";
else turnpage_str = turnpage_str + " 4 \n";
int t_pagecount = pagecount-1;
if (pagecount != 0) turnpage_str = turnpage_str + "<a href=" + SelfPage + "?CurrentPage=" + t_pagecount + "&keywords=" + keywords + "&type=" + type + " onMouseOver=\"this.style.color='red'\" onMouseOut=\"this.style.color='black'\">8</a>\n";
else turnpage_str = turnpage_str + "8\n";
turnpage_str += "</td></tr></table>\n";
turnpage_str += " </td>\n";
turnpage_str += " </tr>\n";
turnpage_str += " </table>\n";
turnpage_str += " </td>\n";
turnpage_str += " </tr>\n";
turnpage_str += "</table>\n";
turnpage_str += "</form>\n";
return(turnpage_str);
}
//--- 用户查看订单 ---
public Hashtable myOrder(HttpServletRequest request,String tb_orders_main,String tb_orders_r_info,String tb_shop_catalog,String tb_shop_product_info) throws Exception {
Hashtable HashResultIn = new Hashtable();
Hashtable HashResultOut = new Hashtable();
ResultSet rs,rs2;
String SqlStr="",pro_name,note="",HtmlStr="",statusStr="";
int i=0,r_info_id=0;
float price,quantity,sum,all_sum=0;
HttpSession session = request.getSession(true);
String account = (String)session.getAttribute("LoginUser");
String orderid;
try {
SqlStr = "SELECT * FROM " + tb_orders_main + " AS a," + tb_orders_r_info + " AS b WHERE a.name = '" + account + "' AND a.r_info_id = b.id GROUP BY b.id ORDER BY b.id DESC";
rs2 = dbconn.ExeQuery(SqlStr);
while (rs2.next()) {
orderid = handle.Replace(" ","",rs2.getString("date_time"));
orderid = handle.Replace("-","",orderid);
orderid = handle.Replace(":","",orderid);
orderid = rs2.getString("r_info_id") + orderid;
HtmlStr += "<table width=770 border=0 align=center cellpadding=3 cellspacing=0>";
HtmlStr += " <tr>";
HtmlStr += " <td>※订单号：" + orderid + "</td>";
HtmlStr += " </tr>";
HtmlStr += "</table>";
HtmlStr += "<TABLE border=0 cellPadding=0 cellSpacing=1 width=770 bgcolor=black align=center>";
HtmlStr += " <TBODY>";
HtmlStr += " <TR>";
HtmlStr += " <TD bgColor=#99999>";
HtmlStr += " <TABLE border=0 cellPadding=3 cellSpacing=1 width=100%>";
HtmlStr += " <TBODY>";
HtmlStr += " <TR align=center valign=middle bgColor=f1f1f1> ";
HtmlStr += " <TD width=13%>订单序号</TD>";
HtmlStr += " <TD width=25%>商品名称</TD>";
HtmlStr += " <TD width=20%>商品价格</TD>";
HtmlStr += " <TD width=19%>订购数量</TD>";
HtmlStr += " <TD width=23%>单项总价</TD>";
HtmlStr += " </TR>";
r_info_id = rs2.getInt("r_info_id");
if (rs2.getInt("status") == 0) statusStr = "<font color=red>未处理</font>";
else if (rs2.getInt("status") == 1) statusStr = "<font color=blue>处理中。。。</font>";
else statusStr = "已处理";
//--- 计算总价钱，哎，痛苦！ ---
SqlStr = "SELECT * FROM " + tb_orders_main + " AS a," + tb_orders_r_info + " AS b WHERE a.r_info_id = " + r_info_id + " AND a.r_info_id = b.id";
rs = dbconn.ExeQuery(SqlStr);
while (rs.next()) {
price = rs.getFloat("price");
quantity = rs.getFloat("quantity");
sum = price * quantity;
all_sum += sum;
}
//--- 计算总价钱，哎，痛苦！ ---
SqlStr = "SELECT * FROM " + tb_orders_main + " AS a," + tb_orders_r_info + " AS b WHERE a.r_info_id = " + r_info_id + " AND a.r_info_id = b.id";
rs = dbconn.ExeQuery(SqlStr);
while (rs.next()) {
i++;
price = rs.getFloat("price");
quantity = rs.getFloat("quantity");
sum = price * quantity;
note = rs.getString("note");
HashResultIn = ManagerProduct.DetailProInfo(tb_shop_catalog,tb_shop_product_info,rs.getInt("product_id"));
pro_name = HashResultIn.get("name") + "";
HtmlStr += " <TR bgColor=#FFFFFF> ";
HtmlStr += " <TD align=center vAlign=middle>" + i + "</TD>";
HtmlStr += " <TD align=center vAlign=middle>" + pro_name + "</TD>";
HtmlStr += " <TD align=center vAlign=middle><FONT color=#ff0000>￥" + price + "</FONT></TD>";
HtmlStr += " <TD align=center vAlign=middle>" + (int)quantity + "</TD>";
HtmlStr += " <TD align=center vAlign=middle><FONT color=#ff0000>￥" + sum + "</FONT></TD>";
HtmlStr += " </TR>";
}
HtmlStr += " <TR> ";
HtmlStr += " <TD align=middle bgColor=#FFFFFF colSpan=3 vAlign=center> </TD>";
HtmlStr += " <TD align=center bgColor=f1f1f1 vAlign=middle>总价</TD>";
HtmlStr += " <TD align=center bgColor=#FFFFFF vAlign=middle><FONT color=#ff0000>￥" + all_sum + "</FONT></TD>";
HtmlStr += " </TR>";
HtmlStr += " <TR align=left> ";
HtmlStr += " <TD align=center vAlign=middle bgcolor=f1f1f1>备注留言</TD>";
HtmlStr += " <TD bgColor=#FFFFFF colSpan=4 vAlign=center>" + note + "</TD>";
HtmlStr += " </TR>";
HtmlStr += " <TR align=center valign=middle bgColor=f1f1f1> ";
HtmlStr += " <TD>下单人</TD>";
HtmlStr += " <TD>收件人</TD>";
HtmlStr += " <TD>联系电话</TD>";
HtmlStr += " <TD>下单时间</TD>";
HtmlStr += " <TD>处理状态</TD>";
HtmlStr += " </TR>";
HtmlStr += " <TR align=center valign=middle bgColor=#FFFFFF>";
HtmlStr += " <TD>" + rs2.getString("name") + "</TD>";
HtmlStr += " <TD>" + rs2.getString("r_name") + "</TD>";
HtmlStr += " <TD>" + rs2.getString("r_tel") + "</TD>";
HtmlStr += " <TD>" + rs2.getString("date_time") + "</TD>";
HtmlStr += " <TD>" + statusStr + "</TD>";
HtmlStr += " </TR>";
HtmlStr += " <TR align=left bgColor=#FFFFFF> ";
HtmlStr += " <TD align=center vAlign=middle bgcolor=f1f1f1>收件地址</TD>";
HtmlStr += " <TD colspan=4 align=middle vAlign=center>" + rs2.getString("r_address") + "</TD>";
HtmlStr += " </TR>";
HtmlStr += " </TBODY>";
HtmlStr += " </TABLE></TD></TR></TBODY></TABLE><br><br>";
all_sum = 0;
}
dbconn.CloseConn();
}
catch (SQLException ex) {
System.err.println("aq.executeQuery:"+ex.getMessage());
}
HashResultOut.put("HtmlStr",HtmlStr);
return(HashResultOut);
}
public boolean changePwd(HttpServletRequest request,String tb_shop_admin) throws Exception {
boolean flag = false;
String sqlStr="";
String old_pwd = handle.getString(request,"old_pwd");
old_pwd = md5.getMD5ofStr(old_pwd.trim());
String new_pwd1 = handle.getString(request,"new_pwd1");
new_pwd1 = md5.getMD5ofStr(new_pwd1.trim());
ResultSet rs;
HttpSession session = request.getSession(true);
administratorBean administratorBean = (administratorBean)session.getAttribute("administratorBean");
String name = administratorBean.getName();
try {
sqlStr = "SELECT * FROM " + tb_shop_admin + " WHERE name='" + name + "' AND pwd='" + old_pwd + "'";
rs = dbconn.ExeQuery(sqlStr);
if (rs.next()) {
sqlStr = "UPDATE " + tb_shop_admin + " SET pwd='" + new_pwd1 + "' WHERE name='" + name + "'";
dbconn.ExeUpdate(sqlStr);
flag = true;
}
dbconn.CloseConn();
}
catch (SQLException ex) {
System.err.println("aq.executeQuery:"+ex.getMessage());
}
return(flag);
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -