📄 managerpurchase.java
字号:
s4 = md5.getMD5ofStr(s4.trim());
String s5 = handle.getString(httpservletrequest, "new_pwd1");
s5 = md5.getMD5ofStr(s5.trim());
HttpSession httpsession = httpservletrequest.getSession(true);
administratorBean administratorbean = (administratorBean)httpsession.getValue("administratorBean");
String s6 = administratorbean.getName();
try
{
String s2 = "SELECT * FROM " + s + " WHERE name='" + s6 + "' AND pwd='" + s4 + "'";
ResultSet resultset = dbconn.ExeQuery(s2);
if(resultset.next())
{
String s3 = "UPDATE " + s + " SET pwd='" + s5 + "' WHERE name='" + s6 + "'";
dbconn.ExeUpdate(s3);
flag = true;
}
dbconn.CloseConn();
}
catch(SQLException sqlexception)
{
System.err.println("aq.executeQuery:" + sqlexception.getMessage());
}
return flag;
}
private Car getCar(HttpServletRequest httpservletrequest)
{
Car car = new Car();
int i = handle.getInt(httpservletrequest, "Pid");
int j = handle.getInt(httpservletrequest, "Quantity");
if(j == 0)
j = 1;
car.setPid(i);
car.setQuantity(j);
return car;
}
public Hashtable myOrder(HttpServletRequest httpservletrequest, String s, String s1, String s2, String s3)
throws Exception
{
Hashtable hashtable = new Hashtable();
Hashtable hashtable2 = new Hashtable();
String s4 = "";
String s8 = "";
String s9 = "";
String s10 = "";
int i = 0;
boolean flag = false;
float f6 = 0.0F;
HttpSession httpsession = httpservletrequest.getSession(true);
String s12 = (String)httpsession.getValue("LoginUser");
try
{
String s5 = "SELECT * FROM " + s + " AS a," + s1 + " AS b WHERE a.name = '" + s12 + "' AND a.r_info_id = b.id GROUP BY b.id ORDER BY b.id DESC";
for(ResultSet resultset2 = dbconn.ExeQuery(s5); resultset2.next();)
{
String s13 = handle.Replace(" ", "", resultset2.getString("date_time"));
s13 = handle.Replace("-", "", s13);
s13 = handle.Replace(":", "", s13);
s13 = resultset2.getString("r_info_id") + s13;
s9 = s9 + "<table width=770 border=0 align=center cellpadding=3 cellspacing=0>";
s9 = s9 + " <tr>";
s9 = s9 + " <td>※订单号：" + s13 + "</td>";
s9 = s9 + " </tr>";
s9 = s9 + "</table>";
s9 = s9 + "<TABLE border=0 cellPadding=0 cellSpacing=1 width=770 bgcolor=black align=center>";
s9 = s9 + " <TBODY>";
s9 = s9 + " <TR>";
s9 = s9 + " <TD bgColor=#99999>";
s9 = s9 + " <TABLE border=0 cellPadding=3 cellSpacing=1 width=100%>";
s9 = s9 + " <TBODY>";
s9 = s9 + " <TR align=center valign=middle bgColor=f1f1f1> ";
s9 = s9 + " <TD width=13%>订单序号</TD>";
s9 = s9 + " <TD width=25%>商品名称</TD>";
s9 = s9 + " <TD width=20%>商品价格</TD>";
s9 = s9 + " <TD width=19%>订购数量</TD>";
s9 = s9 + " <TD width=23%>单项总价</TD>";
s9 = s9 + " </TR>";
int j = resultset2.getInt("r_info_id");
String s11;
if(resultset2.getInt("status") == 0)
s11 = "<font color=red>未处理</font>";
else
if(resultset2.getInt("status") == 1)
s11 = "<font color=blue>处理中。。。</font>";
else
s11 = "已处理";
String s6 = "SELECT * FROM " + s + " AS a," + s1 + " AS b WHERE a.r_info_id = " + j + " AND a.r_info_id = b.id";
for(ResultSet resultset = dbconn.ExeQuery(s6); resultset.next();)
{
float f = resultset.getFloat("price");
float f2 = resultset.getFloat("quantity");
float f4 = f * f2;
f6 += f4;
}
s6 = "SELECT * FROM " + s + " AS a," + s1 + " AS b WHERE a.r_info_id = " + j + " AND a.r_info_id = b.id";
for(ResultSet resultset1 = dbconn.ExeQuery(s6); resultset1.next();)
{
i++;
float f1 = resultset1.getFloat("price");
float f3 = resultset1.getFloat("quantity");
float f5 = f1 * f3;
s8 = resultset1.getString("note");
Hashtable hashtable1 = ManagerProduct.DetailProInfo(s2, s3, resultset1.getInt("product_id"));
String s7 = String.valueOf(String.valueOf(hashtable1.get("name")));
s9 = s9 + " <TR bgColor=#FFFFFF> ";
s9 = s9 + " <TD align=center vAlign=middle>" + i + "</TD>";
s9 = s9 + " <TD align=center vAlign=middle>" + s7 + "</TD>";
s9 = s9 + " <TD align=center vAlign=middle><FONT color=#ff0000>￥" + f1 + "</FONT></TD>";
s9 = s9 + " <TD align=center vAlign=middle>" + (int)f3 + "</TD>";
s9 = s9 + " <TD align=center vAlign=middle><FONT color=#ff0000>￥" + f5 + "</FONT></TD>";
s9 = s9 + " </TR>";
}
s9 = s9 + " <TR> ";
s9 = s9 + " <TD align=middle bgColor=#FFFFFF colSpan=3 vAlign=center> </TD>";
s9 = s9 + " <TD align=center bgColor=f1f1f1 vAlign=middle>总价</TD>";
s9 = s9 + " <TD align=center bgColor=#FFFFFF vAlign=middle><FONT color=#ff0000>￥" + f6 + "</FONT></TD>";
s9 = s9 + " </TR>";
s9 = s9 + " <TR align=left> ";
s9 = s9 + " <TD align=center vAlign=middle bgcolor=f1f1f1>备注留言</TD>";
s9 = s9 + " <TD bgColor=#FFFFFF colSpan=4 vAlign=center>" + s8 + "</TD>";
s9 = s9 + " </TR>";
s9 = s9 + " <TR align=center valign=middle bgColor=f1f1f1> ";
s9 = s9 + " <TD>下单人</TD>";
s9 = s9 + " <TD>收件人</TD>";
s9 = s9 + " <TD>联系电话</TD>";
s9 = s9 + " <TD>下单时间</TD>";
s9 = s9 + " <TD>处理状态</TD>";
s9 = s9 + " </TR>";
s9 = s9 + "\t\t\t<TR align=center valign=middle bgColor=#FFFFFF>";
s9 = s9 + "\t\t\t<TD>" + resultset2.getString("name") + "</TD>";
s9 = s9 + "\t\t\t<TD>" + resultset2.getString("r_name") + "</TD>";
s9 = s9 + "\t\t\t<TD>" + resultset2.getString("r_tel") + "</TD>";
s9 = s9 + "\t\t\t<TD>" + resultset2.getString("date_time") + "</TD>";
s9 = s9 + "\t\t\t<TD>" + s11 + "</TD>";
s9 = s9 + "\t\t\t</TR>";
s9 = s9 + " <TR align=left bgColor=#FFFFFF> ";
s9 = s9 + " <TD align=center vAlign=middle bgcolor=f1f1f1>收件地址</TD>";
s9 = s9 + " <TD colspan=4 align=middle vAlign=center>" + resultset2.getString("r_address") + "</TD>";
s9 = s9 + " </TR>";
s9 = s9 + " </TBODY>";
s9 = s9 + " </TABLE></TD></TR></TBODY></TABLE><br><br>";
f6 = 0.0F;
}
dbconn.CloseConn();
}
catch(SQLException sqlexception)
{
System.err.println("aq.executeQuery:" + sqlexception.getMessage());
}
hashtable2.put("HtmlStr", s9);
return hashtable2;
}
public String search_turn(Hashtable hashtable, String s, String s1, String s2)
throws Exception
{
String s3 = "";
int k = Integer.parseInt(String.valueOf(hashtable.get("nextpage")));
int l = Integer.parseInt(String.valueOf(hashtable.get("prevpage")));
int i1 = Integer.parseInt(String.valueOf(hashtable.get("pagesize")));
int j1 = Integer.parseInt(String.valueOf(hashtable.get("pagecount")));
int k1 = Integer.parseInt(String.valueOf(hashtable.get("pagecount2")));
int l1 = Integer.parseInt(String.valueOf(hashtable.get("page1")));
int i2 = Integer.parseInt(String.valueOf(hashtable.get("page2")));
s1 = handle.ISO2GBK(s1);
s3 = s3 + "<form name=form1 method=post action=" + s + ">\n";
s3 = s3 + "<table width=100% border=0 cellspacing=0 cellpadding=0 align=center>\n";
s3 = s3 + " <tr> \n";
s3 = s3 + " <td bgcolor=999999> \n";
s3 = s3 + " <table width=100% border=0 cellspacing=1 cellpadding=3>\n";
s3 = s3 + " <tr bgcolor=f1f1f1>\n";
s3 = s3 + "\t <td align=center valign=middle width=50%>关键词： \n";
s3 = s3 + " <input type=text name=keywords value=" + s1 + ">\n";
s3 = s3 + " \n";
s3 = s3 + "<select name=type>\n";
s3 = s3 + " <option value=orderid selected>订单编号</option>\n";
s3 = s3 + " <option value=name>下单人</option>\n";
s3 = s3 + " <option value=r_name>收件人</option>\n";
s3 = s3 + "</select>\n";
s3 = s3 + " <input type=submit name=Submit value=搜索>\n";
s3 = s3 + " </td>\n";
s3 = s3 + "\t <td align=center valign=middle width=50%>\n";
s3 = s3 + " <table><tr><td align=center valign=middle width=30%>\n";
s3 = s3 + " <SELECT onchange=\"var jmpURL1=this.options[this.selectedIndex].value; if(jmpURL1!='') {self.location=jmpURL1;} else {this.selectedIndex=0;}\" size=1 name=select>\n";
s3 = s3 + " <option value=''>选择翻页</option>\n";
for(int i = 0; i < j1; i++)
{
int j = i + 1;
s3 = s3 + " <option value=" + s + "?CurrentPage=" + i + "&keywords=" + s1 + "&type=" + s2 + ">第 " + j + " 页</option>\n";
}
s3 = s3 + " </select>\n";
s3 = s3 + " </td>\n";
s3 = s3 + " <td align=center valign=middle width=20%>\n";
s3 = s3 + " 当前页：" + i2 + "/" + j1;
s3 = s3 + " </td>\n";
s3 = s3 + " <td align=center valign=middle width=40% style='font-family:Webdings'>\n";
if(j1 != 0)
s3 = s3 + "<a href=" + s + "?CurrentPage=0&keywords=" + s1 + "&type=" + s2 + " onMouseOver=\"this.style.color='red'\" onMouseOut=\"this.style.color='black'\">7</a> \n";
else
s3 = s3 + "7 \n";
if(l1 != 0)
s3 = s3 + "<a href=" + s + "?CurrentPage=" + l + "&keywords=" + s1 + "&type=" + s2 + " onMouseOver=\"this.style.color='red'\" onMouseOut=\"this.style.color='black'\">3</a>\n";
else
s3 = s3 + "3\n";
if(l1 != k1 && j1 != 0)
s3 = s3 + " <a href=" + s + "?CurrentPage=" + k + "&keywords=" + s1 + "&type=" + s2 + " onMouseOver=\"this.style.color='red'\" onMouseOut=\"this.style.color='black'\">4</a> \n";
else
s3 = s3 + " 4 \n";
int j2 = j1 - 1;
if(j1 != 0)
s3 = s3 + "<a href=" + s + "?CurrentPage=" + j2 + "&keywords=" + s1 + "&type=" + s2 + " onMouseOver=\"this.style.color='red'\" onMouseOut=\"this.style.color='black'\">8</a>\n";
else
s3 = s3 + "8\n";
s3 = s3 + "</td></tr></table>\n";
s3 = s3 + "\t </td>\n";
s3 = s3 + " </tr>\n";
s3 = s3 + " </table>\n";
s3 = s3 + " </td>\n";
s3 = s3 + " </tr>\n";
s3 = s3 + "</table>\n";
s3 = s3 + "</form>\n";
return s3;
}
public Hashtable turn_page(String s, int i, int j)
{
int i1 = 0;
Hashtable hashtable = new Hashtable();
if(!s.equals(""))
i1 = Integer.parseInt(s);
int k = j / i;
if(i * k < j)
k++;
if(Integer.parseInt(s) > k)
i1 = k - 1;
else
if(Integer.parseInt(s) < 0)
i1 = 0;
int l = k - 1;
int j1 = i1 + 1;
int k1 = i1 * i;
int l1 = k1 + i;
int i2 = i1 + 1;
int j2 = i1 - 1;
hashtable.put("pt_st", new Integer(k1));
hashtable.put("pt_en", new Integer(l1));
hashtable.put("nextpage", new Integer(i2));
hashtable.put("prevpage", new Integer(j2));
hashtable.put("pagesize", new Integer(i));
hashtable.put("pagecount", new Integer(k));
hashtable.put("pagecount2", new Integer(l));
hashtable.put("page1", new Integer(i1));
hashtable.put("page2", new Integer(j1));
return hashtable;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -