jsp 框架式留言

/*************************************************** * * 源文件名: AdminClass.java * 功 能： 梦想年华新闻系统 - 新闻类别管理类 * 作者：梦想年华 [DreamTime] * Email:fanwsp@126.com * QQ:122142023 * CopyRight(c)2005-2006 by DreamTime * **************************************************** */ package dreamtime.dreamnews; //指定类所在的包 import java.sql.*; import dreamtime.dreamnews.Function; import dreamtime.dreamnews.DBConnection; public class AdminReply { DBConnection DBConn = new DBConnection(); Function Fun = new Function(); /********************************************************* * 函数名：ReadClass * 作 用：读取所有类别 * 参 数：无 * 返回值：字符串 ***********************************************************/ public String ReadClass() { try { Connection Conn = DBConn.getConn(); Statement stmt = Conn.createStatement(1004,1007); Statement stmt1 = Conn.createStatement(1004,1007); String sql = "select * from BigClass order by BigClassID"; ResultSet rs = stmt.executeQuery(sql); StringBuffer sb = new StringBuffer(); sb.append("<br><br><table width=\"90%\" border=\"1\" align=\"center\" cellpadding=\"2\" cellspacing=\"0\">\r\n"); sb.append("<tr><td height=\"27\" colspan=\"3\" background=\"images/bg.gif\">"); sb.append("<div align=\"center\" class=\"title\"><strong>新闻类别管理</strong></div></td>"); sb.append("</tr>\r\n"); // sb.append("<tr>\r\n"); // sb.append("<td height=\"25\" colspan=\"4\"><strong>&nbsp;<a href=\"Admin_Class.jsp?Action=AddBigClass\">"); // sb.append("<font color=\"#ff6600\">[增加大类]</font></a></strong></td>\r\n"); // sb.append("</tr>\r\n"); sb.append("<tr>\r\n"); sb.append("<td height=\"25\"><div align=\"center\" class=\"chinese\"><b>类别名称</b></div></td>\r\n"); sb.append("<td><div align=\"center\" class=\"chinese\"><b>添加时间</b></div></td>\r\n"); sb.append("<td><div align=\"center\" class=\"chinese\"><b>操作</b></div></td>\r\n"); sb.append("</tr>\r\n"); //如果表中没有任何记录，刚给出提示信息 if (!rs.next()) { sb.append("<tr height=\"25\" bgcolor=\"#d6dff7\" class=\"info1\"><td colspan=\"3\">\r\n"); sb.append("<div align=\"center\"><b>暂时没有任何大类!</b></div></td></tr>\r\n"); } else { while(!rs.isAfterLast()) { int BigClassID = rs.getInt("BigClassID"); String BigClassName = rs.getString("BigClassName"); String BigClassInfo = rs.getString("BigClassInfo"); //int [] iBNum = ReadClassNews(BigClassID,true,false); sb.append("<tr class=\"chinese\">\r\n"); sb.append("<td width=\"40%\" height='22' title=\""); sb.append(BigClassInfo); sb.append("\"><div align=\"left\">&nbsp;<img src='images/+.gif'><b>"); sb.append(BigClassName + "</b>&nbsp;[" + BigClassID + "]"); //sb.append("&nbsp;[" + iBNum[0] + "/" + iBNum[1] + "]</div></td>\r\n"); sb.append("<td width=\"30%\"><div align=\"center\">"); sb.append(rs.getString("AddTime")); sb.append("</div></td>\r\n"); sb.append("<td width=\"30%\" class=\"chinese\"><div align=\"right\">[<a href=\"Admin_reply.jsp?Action=BNote&BigClassID="); sb.append(BigClassID); sb.append("\"><font color=\"#ff6600\">发布</font></a>] [<a href=\"Admin_reply.jsp?Action=BCover&BigClassID="); sb.append(BigClassID); sb.append("\"><font color=\"#ff6600\">屏蔽</font></a>]</div></td>\r\n"); sb.append("</tr>\r\n"); String sql1 = "select * from SmallClass where BigClassID=" + BigClassID + " order by SmallClassID"; ResultSet rs1= stmt1.executeQuery(sql1); while(rs1.next()) { int SClassID = rs1.getInt("SmallClassID"); String classInfo = rs1.getString("SmallClassInfo")==null ? "&nbsp;" : rs1.getString("SmallClassInfo") ; //int [] iSNum = ReadClassNews(SClassID,false,false); sb.append("<tr bgcolor=\"#d6dff7\">\r\n"); sb.append("<td class=\"chinese\" height=\"20\" Title=\"" + classInfo + "\"><div align=\"left\" class=\"chines\">"); sb.append("&nbsp;&nbsp;&nbsp;<img src='images/-.gif'>"); //sb.append(rs1.getString("SmallClassName") + "&nbsp;[" + SClassID + "]&nbsp;[" + iSNum[0] + "]</div></td>\r\n"); sb.append(rs1.getString("SmallClassName") + "&nbsp;[" + SClassID + "]&nbsp;</div></td>\r\n"); sb.append("<td class=\"chinese\"><div align=\"center\" class=\"chines\">"); sb.append(rs1.getString("AddTime")==null ? "&nbsp;" : rs1.getString("AddTime") + "</div></td>\r\n"); sb.append("<td><div align=\"right\" class=\"chinese\">[<a href=\"Admin_reply.jsp?Action=SNote&SClassID="); sb.append(SClassID); sb.append("\">发布</a>] [<a href=\"Admin_reply.jsp?Action=SCover&SClassID="); sb.append(SClassID); sb.append("\">屏蔽</a>]</div></td>\r\n"); sb.append("</tr>\r\n"); } rs.next(); } } sb.append("</table>"); sb.append("<br><br>"); rs.close(); stmt.close(); Conn.close(); return sb.toString(); }catch(Exception e) { e.printStackTrace(); //System.out.print(e.getMessage()); return "No"; } } /********************************************************* EditBigClass(BigClassID,AdminName,IP); ***********************************************************/ public String EditBigClass(String s1,String s2,String s3,String s4) { Connection Conn = DBConn.getConn(); int BigClassID = Fun.StrToInt(s1); String [] sLog = new String[5]; String sql=""; String sql1=""; try { Statement stmt = Conn.createStatement(1004,1007); Statement stmt1 = Conn.createStatement(1004,1007); Statement stmt2 = Conn.createStatement(1004,1007); ResultSet rs1 = null; ResultSet rs2 = null; int DBSmallClassID=0; sql1="select SmallClassID from SmallClass where BigClassID=" + BigClassID; rs1=stmt1.executeQuery(sql1); rs2=stmt2.executeQuery(sql1); if(s4.equals("true")){ while(rs1.next()){ DBSmallClassID=rs1.getInt("SmallClassID"); sql = "update SmallClass set Svisliuyan=1 where SmallClassID=" + DBSmallClassID; stmt.executeUpdate(sql); System.out.println(sql); } sLog[1] = "发布留言"; } else{ while(rs2.next()){ DBSmallClassID=rs2.getInt("SmallClassID"); sql = "update SmallClass set Svisliuyan=0 where SmallClassID=" + DBSmallClassID; stmt.executeUpdate(sql); System.out.println(sql); } sLog[1] = "屏蔽留言"; } //更改JDBC默认事务提交方式 stmt.close(); stmt1.close(); stmt2.close(); rs1.close(); rs2.close(); Conn.close(); } catch (SQLException e) { e.printStackTrace(); return "操作失败!"; } //设为默认 String NowTime = Fun.getDateStr(); sLog[0] = Fun.CheckReplace(s2); sLog[2] = NowTime; sLog[3] = Fun.CheckReplace(s3); sLog[4] = "Yes"; Fun.AddLog(sLog); return "Yes"; } /********************************************************* aReply.EditSmallClass(SmallClassID,AdminName,IP,fabu); * ***********************************************************/ public String EditSmallClass(String s1,String s2,String s3,String s4) { Connection Conn = DBConn.getConn(); int SmallClassID = Fun.StrToInt(s1); String [] sLog = new String[5]; String sql=""; try { Statement stmt = Conn.createStatement(1004,1007); if(s4.equals("true")){ sql = "update