📄 managerproduct.java
字号:
else
s12 = "[<a href=DealWithCenter.jsp?action=unimportanceshow&Pid=" + j1 + "><font color=#FF33CC>撤消重点</font></a>]";
s6 = s6 + " <tr align=center valign=middle bgcolor=" + s9 + "> ";
s6 = s6 + " <td><input type=checkbox name=checkbox value=" + j1 + "></td>";
s6 = s6 + " <td>" + (int)f + "-" + j1 + "</td>";
s6 = s6 + " <td><a href=detail.jsp?Pid=" + j1 + ">" + resultset.getString("name") + "</a></td>";
s6 = s6 + " <td><font color=red>" + resultset.getString("price") + "</font></td>";
s6 = s6 + " <td>" + resultset.getInt("click") + "</td>";
s6 = s6 + " <td>" + resultset.getInt("purchase_num") + "</td>";
s6 = s6 + " <td>" + resultset.getString("keywords") + "</td>";
s6 = s6 + " <td>" + resultset.getString("date_time") + "</td>";
s6 = s6 + " <td><a href=DealWithCenter.jsp?Pid=" + j1 + "><font color=blue>修改</font></a> <a href=DealWithCenter.jsp?action=del&Pid=" + j1 + " onclick=\"return (AlertDel('" + resultset.getString("name") + "'));\"><font color=red>删除</font></a><br>" + s10 + " " + s11 + "<br>" + s12 + "</td>";
s6 = s6 + " </tr>";
if(!resultset.next())
break;
}
dbconn.CloseConn();
}
catch(SQLException sqlexception)
{
System.err.println("aq.executeQuery:" + sqlexception.getMessage());
}
String s7 = search_turn(hashtable, s1, s2, s3);
hashtable1.put("RecordCount", String.valueOf(j));
hashtable1.put("HtmlStr", s6);
hashtable1.put("TurpageStr", s7);
return hashtable1;
}
public String SearchTurn_UnderCatalogPro(Hashtable hashtable, String s, int i, String s1, String s2)
throws Exception
{
String s3 = "";
int l = Integer.parseInt(String.valueOf(hashtable.get("nextpage")));
int i1 = Integer.parseInt(String.valueOf(hashtable.get("prevpage")));
int j1 = Integer.parseInt(String.valueOf(hashtable.get("pagesize")));
int k1 = Integer.parseInt(String.valueOf(hashtable.get("pagecount")));
int l1 = Integer.parseInt(String.valueOf(hashtable.get("pagecount2")));
int i2 = Integer.parseInt(String.valueOf(hashtable.get("page1")));
int j2 = Integer.parseInt(String.valueOf(hashtable.get("page2")));
s3 = s3 + "<table width=100% border=0 cellspacing=0 cellpadding=0 align=right>";
s3 = s3 + " <tr> ";
s3 = s3 + "\t <td align=center valign=middle>";
s3 = s3 + " <table><tr><td align=center valign=middle width=30%>";
s3 = s3 + " <SELECT onchange=\"var jmpURL1=this.options[this.selectedIndex].value; if(jmpURL1!='') {self.location=jmpURL1;} else {this.selectedIndex=0;}\" size=1 name=select>";
s3 = s3 + " <option value=''>选择翻页</option>";
for(int j = 0; j < k1; j++)
{
int k = j + 1;
s3 = s3 + " <option value=" + s + "?CurrentPage=" + j + "&Cid=" + i + "&Catalog_f=" + s1 + "&Catalog_s=" + s2 + ">第 " + k + " 页</option>";
}
s3 = s3 + " </select>";
s3 = s3 + " </td>";
s3 = s3 + " <td align=center valign=middle width=20%>";
s3 = s3 + " 当前页：" + j2 + "/" + k1;
s3 = s3 + " </td>";
s3 = s3 + " <td align=center valign=middle width=40% style='font-family:Webdings'>";
if(k1 != 0)
s3 = s3 + "<a href=" + s + "?CurrentPage=0&Cid=" + i + "&Catalog_f=" + s1 + "&Catalog_s=" + s2 + " onMouseOver=\"this.style.color='red'\" onMouseOut=\"this.style.color='black'\">7</a> ";
else
s3 = s3 + "7 ";
if(i2 != 0)
s3 = s3 + "<a href=" + s + "?CurrentPage=" + i1 + "&Cid=" + i + "&Catalog_f=" + s1 + "&Catalog_s=" + s2 + " onMouseOver=\"this.style.color='red'\" onMouseOut=\"this.style.color='black'\">3</a>";
else
s3 = s3 + "3";
if(i2 != l1 && k1 != 0)
s3 = s3 + " <a href=" + s + "?CurrentPage=" + l + "&Cid=" + i + "&Catalog_f=" + s1 + "&Catalog_s=" + s2 + " onMouseOver=\"this.style.color='red'\" onMouseOut=\"this.style.color='black'\">4</a> ";
else
s3 = s3 + " 4 ";
int k2 = k1 - 1;
if(k1 != 0)
s3 = s3 + "<a href=" + s + "?CurrentPage=" + k2 + "&Cid=" + i + "&Catalog_f=" + s1 + "&Catalog_s=" + s2 + " onMouseOver=\"this.style.color='red'\" onMouseOut=\"this.style.color='black'\">8</a>";
else
s3 = s3 + "8";
s3 = s3 + "</td></tr></table>";
s3 = s3 + "\t </td>";
s3 = s3 + " </tr>";
s3 = s3 + " </table>";
s3 = s3 + " </td>";
s3 = s3 + " </tr>";
s3 = s3 + "</table>";
return s3;
}
public String ShowCorrelationProduct(String s, HttpServletRequest httpservletrequest)
throws Exception
{
int i = handle.getInt(httpservletrequest, "Pid");
float f = 0.0F;
String s1 = "";
String s4 = "";
String s5 = "";
String s6 = "";
String s7 = "";
String s9 = "";
try
{
String s2 = "SELECT name,keywords FROM " + s + " WHERE id=" + i;
ResultSet resultset = dbconn.ExeQuery(s2);
resultset.next();
s5 = resultset.getString("keywords");
s6 = resultset.getString("name");
dbconn.CloseConn();
}
catch(SQLException sqlexception)
{
System.err.println("aq.executeQuery:" + sqlexception.getMessage());
}
s5 = handle.GBK2ISO(s5);
String as[] = handle.Split(",", s5);
if(as.length == 1)
{
s9 = s9 + "keywords LIKE '%" + as[0] + "%'";
} else
{
int j;
for(j = 0; j < as.length - 1; j++)
s9 = s9 + "keywords LIKE '%" + as[j] + "%' OR ";
s9 = s9 + "keywords LIKE '%" + as[j] + "%'";
}
try
{
String s3 = "SELECT * FROM " + s + " WHERE " + s9;
ResultSet resultset1 = dbconn.ExeQuery(s3);
s4 = s4 + "<table width=100% border=0 cellspacing=0 cellpadding=3>";
while(resultset1.next())
{
String s8 = resultset1.getString("name");
if(!s6.equals(s8))
{
if(f / 2.0F == (float)((int)f / 2))
s4 = s4 + " <tr bgcolor=white>";
else
s4 = s4 + " <tr>";
s4 = s4 + " <td width=90%><a href=" + handle.SystemURL + "DetailProInfo.jsp?Pid=" + resultset1.getInt("id") + ">" + s8 + "</a></td><td width=10%><font color=red>￥" + resultset1.getString("price") + "</font></td>";
s4 = s4 + " </tr>";
f++;
}
}
s4 = s4 + "</table>";
dbconn.CloseConn();
}
catch(SQLException sqlexception1)
{
System.err.println("aq.executeQuery:" + sqlexception1.getMessage());
}
return s4;
}
public void ShowOut(HttpServletRequest httpservletrequest, String s)
throws Exception
{
int i = handle.getInt(httpservletrequest, "Pid");
String s1 = "UPDATE " + s + " SET show_out=1 WHERE id=" + i;
dbconn.ExeUpdate(s1);
dbconn.CloseConn();
}
public String StatInfo(String s, String s1)
throws Exception
{
String s3 = "";
int i = 0;
int j = 0;
try
{
String s2 = "SELECT * FROM " + s;
ResultSet resultset = dbconn.ExeQuery(s2);
resultset.last();
i = resultset.getRow();
s2 = "SELECT * FROM " + s1;
resultset = dbconn.ExeQuery(s2);
resultset.last();
j = resultset.getRow();
dbconn.CloseConn();
}
catch(SQLException sqlexception)
{
System.err.println("aq.executeQuery:" + sqlexception.getMessage());
}
s3 = s3 + "<tr bgcolor=eeeeee> ";
s3 = s3 + " <td width=54%>商品总数：</td>";
s3 = s3 + " <td width=46% align=center valign=middle>" + i + "</td>";
s3 = s3 + "</tr>";
s3 = s3 + "<tr bgcolor=eeeeee> ";
s3 = s3 + " <td>注册会员：</td>";
s3 = s3 + " <td align=center valign=middle>" + j + "</td>";
s3 = s3 + "</tr>";
return s3;
}
public void UnMarkAbsence(HttpServletRequest httpservletrequest, String s)
throws Exception
{
int i = handle.getInt(httpservletrequest, "Pid");
String s1 = "UPDATE " + s + " SET absence=0 WHERE id=" + i;
dbconn.ExeUpdate(s1);
dbconn.CloseConn();
}
public void UnShowOut(HttpServletRequest httpservletrequest, String s)
throws Exception
{
int i = handle.getInt(httpservletrequest, "Pid");
String s1 = "UPDATE " + s + " SET show_out=0 WHERE id=" + i;
dbconn.ExeUpdate(s1);
dbconn.CloseConn();
}
public Hashtable UnderCatalogPro(HttpServletRequest httpservletrequest, int i, String s, String s1)
throws Exception
{
String s3 = "";
int j = 0;
boolean flag = false;
Hashtable hashtable = new Hashtable();
Hashtable hashtable1 = new Hashtable();
String s7 = handle.getString(httpservletrequest, "CurrentPage", "0");
String s8 = handle.getString(httpservletrequest, "Catalog_f");
String s9 = handle.getString(httpservletrequest, "Catalog_s");
int i1 = handle.getInt(httpservletrequest, "Cid");
try
{
String s2 = "SELECT * FROM " + s1 + " WHERE catalog_id=" + i1 + " ORDER BY id DESC";
ResultSet resultset = dbconn.ExeQuery(s2);
resultset.last();
j = resultset.getRow();
hashtable = turn_page(s7, i, j);
int j1 = Integer.parseInt(String.valueOf(hashtable.get("pt_st"))) + 1;
int k1 = Integer.parseInt(String.valueOf(hashtable.get("pt_en"))) + 1;
resultset.absolute(j1);
for(int k = j1; k < k1; k++)
{
int l = resultset.getInt("id");
String s4 = resultset.getString("img_path");
String s5 = resultset.getString("name");
String s6 = resultset.getString("description");
if(s6.length() > 150)
{
s6 = s6.substring(0, 150);
s6 = s6 + "......";
}
float f = resultset.getFloat("price");
s3 = s3 + "<table width=571 height=100 border=0 cellpadding=0 cellspacing=0>";
s3 = s3 + "<tr>";
s3 = s3 + "<td width=138 align=center valign=middle><a href=../../DetailProInfo.jsp?Pid=" + l + "><img src=../../" + s4 + " width=80 height=80 border=1></a></td>";
s3 = s3 + "<td width=433 align=center valign=top><table width=100% height=78 border=0 cellpadding=3 cellspacing=0>";
s3 = s3 + "<tr> ";
s3 = s3 + "<td><font color=#0000FF>商品名称：</font>" + s5 + "</td>";
s3 = s3 + "</tr>";
s3 = s3 + "<tr> ";
s3 = s3 + "<td height=18><font color=#0000FF>商品价格：<font color=red> ￥" + f + "</font></font></td>";
s3 = s3 + "</tr>";
s3 = s3 + "<tr> ";
s3 = s3 + "<td height=25><font color=#0000FF>商品简介：</font><br>" + s6 + "</td>";
s3 = s3 + "</tr>";
s3 = s3 + "</table></td>";
s3 = s3 + "</tr>";
s3 = s3 + "</table>";
s3 = s3 + "<table width=571 height=1 border=0 cellpadding=0 cellspacing=0>";
s3 = s3 + "<tr>";
s3 = s3 + "<td width=601 bgcolor=#000000></td>";
s3 = s3 + "</tr>";
s3 = s3 + "</table>";
if(!resultset.next())
break;
}
dbconn.CloseConn();
}
catch(SQLException sqlexception)
{
System.err.println("aq.executeQuery:" + sqlexception.getMessage());
}
String s10 = SearchTurn_UnderCatalogPro(hashtable, s, i1, s8, s9);
hashtable1.put("RecordCount", String.valueOf(j));
hashtable1.put("HtmlStr", s3);
hashtable1.put("TurpageStr", s10);
return hashtable1;
}
public Vector getHotClick(String s, int i)
throws Exception
{
String s1 = "";
String s3 = "";
Vector vector = new Vector();
try
{
String s2 = "SELECT * FROM " + s + " ORDER BY click DESC LIMIT " + i;
productBean productbean;
for(ResultSet resultset = dbconn.ExeQuery(s2); resultset.next(); vector.addElement(productbean))
{
productbean = new productBean();
productbean.setId(resultset.getInt("id"));
productbean.setName(resultset.getString("name"));
}
dbconn.CloseConn();
}
catch(SQLException sqlexception)
{
System.err.println("aq.executeQuery:" + sqlexception.getMessage());
}
return vector;
}
public Vector getHotTalkPro(String s, String s1, int i)
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -