📄 admin.jsp
字号:
<link rel=stylesheet href="style.css" type="text/css">
<body bgcolor="#DEDEDE">
<%@ page language="java" import="java.util.*" %>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="doit" scope="page" class="dbcon.doit" />
<jsp:useBean id="DB" scope="page" class="dbcon.mydb" />
<%
int intPageSize=20; //Records one page
int intRowCount=0; //Total records
int intPageCount=0; //Total pages
int intPage=0; //Current page
String strPage="",strAreaid="",strSql="",strUser="";
String strTask="",strButton="";
String strCkbox="",strValue="";
int intAllflag=0;
int i=0,j=0,intAreaid=0,intValue=0;
if(session.getValue("user")!=null){
strUser=(String)session.getValue("user");
String strShow=doit.changecode(strUser);
if(strUser.equals("admin")||strUser.equals((String)session.getValue("area_master"))){
if(request.getParameter("page")!=null){
strPage=(String)request.getParameter("page");
intPage = java.lang.Integer.parseInt(strPage);
if(intPage<1) intPage = 1;
}else{intPage = 1;
}
if(session.getValue("area_id")!=null){
strAreaid=(String)session.getValue("area_id");
}
if(request.getParameter("TASK")!=null&&request.getParameter("B1")!=null){
strTask=(String)request.getParameter("TASK");
strButton=(String)request.getParameter("B1");
if(strTask.equals("DO")){
if(strButton.equals("COOL")){
for(j=0;j<intPageSize;j++){
strCkbox="C"+j;
if (request.getParameter(strCkbox)!=null){
strValue=(String)request.getParameter(strCkbox);
intValue=java.lang.Integer.parseInt(strValue);
String sqlCool="UPDATE DATA SET INT_COOL=1-INT_COOL WHERE INT_ID="+intValue;
DB.executeUpdate(sqlCool);
}
}
}
if(strButton.equals("DELETE")){
for(j=0;j<intPageSize;j++){
strCkbox="C"+j;
if (request.getParameter(strCkbox)!=null){
strValue=(String)request.getParameter(strCkbox);
intValue=java.lang.Integer.parseInt(strValue);
String sqlDel="DELETE FROM DATA WHERE INT_ID="+intValue+" OR INT_ROOTID="+intValue;
DB.executeUpdate(sqlDel);
}
}
}
}
}
if(!strAreaid.equals("0")&&strAreaid!=null)
{intAreaid=java.lang.Integer.parseInt(strAreaid);
strSql= "SELECT INT_ID,STR_TITLE,STR_AUTHOR,INT_RPLYNUMB,INT_CLICKNUMB,STR_DATE,INT_TXTLEN,INT_COOL,INT_ICON";
strSql=strSql+ " FROM DATA WHERE INT_ROOTID=0 AND INT_AREAID="+intAreaid+" ORDER BY INT_ID DESC";
}
else{strSql="SELECT INT_ID,STR_TITLE,STR_AUTHOR,INT_RPLYNUMB,INT_CLICKNUMB,STR_DATE,INT_TXTLEN,INT_COOL,INT_ICON";
strSql=strSql+" FROM DATA WHERE INT_ROOTID=0 ORDER BY INT_ID DESC";
intAllflag=1;
}
%>
<%if(strUser.equals("admin")){ %>
<form >
<div align="center"><center><p><select onChange="{if(this.options[this.selectedIndex].value != '')window.open(this.options[this.selectedIndex].value)}"
name="D1" size="1">
<option value="">==Control Console==</option>
<option value="sql.html">SQL Management</option>
<option value="log.jsp">Check Logs</option>
<option value="area_admin.jsp">Board Management</option>
<option value="user_admin.jsp">User Management</option>
<option value="opennew.jsp">Open New Board</option>
</select></p>
</center></div>
</form>
<%} %>
<form METHOD="POST" action="admin.jsp">
<input type="hidden" name="TASK" value="DO">
<input type="submit" value="COOL" name="B1">
<table border="0" cellpadding="1" cellspacing="0" width="100%">
<tr bgcolor="#cc3333">
<td align="center" nowrap ><font color="#ffffff" ><strong>Title</strong></font></td>
<td align="center" nowrap><font color="#ffffff" ><strong>Author</strong></font></td>
<td align="center" nowrap><font color="#ffffff" ><strong>Reply/Click</strong></font></td>
<td align="center" nowrap><font color="#ffffff" ><strong>Date</strong></font></td>
</tr>
<jsp:include page=draw_admtb.js />
<%
ResultSet sqlRst=DB.executeQuery(strSql);
sqlRst.last();
intRowCount = sqlRst.getRow();
intPageCount = (intRowCount+intPageSize-1) / intPageSize;
if(intPage>intPageCount) intPage = intPageCount;
if(intPageCount>0){
int intCurrent=(intPage-1) * intPageSize +1;
if (intCurrent<=1){
sqlRst.beforeFirst();
}else{
sqlRst.absolute(intCurrent-1);
}
i = 0;
String s1,s2,s3,s4,s5,s6,s7;
String id,icon,area_nick,area_link,cool_flag;
String strChecker;
int all,s8,RowCount;
icon="";
s8=1;
all=0;
area_nick="";
area_link="";
RowCount=0;
while(i<intPageSize && sqlRst.next()){
id=sqlRst.getString("INT_ID");
s1=sqlRst.getString("STR_TITLE");
s2=sqlRst.getString("STR_AUTHOR");
s3=sqlRst.getString("INT_RPLYNUMB");
s4=sqlRst.getString("INT_CLICKNUMB");
s5=sqlRst.getString("STR_DATE");
s6="("+(String)sqlRst.getString("INT_TXTLEN")+" bytes)";
cool_flag=sqlRst.getString("INT_COOL");
icon=sqlRst.getString("INT_ICON");
s1=s1+s6;
strChecker="<input type=checkbox name=C"+i+" value="+id+">";
out.print("draw_table("+id+",'"+s1+"','"+s2+"',"+s3+","+s4+",'"+s5+"',"+cool_flag+","+icon+","+all+","+s8+",'"+area_nick+"','"+area_link+"','"+strChecker+"');");
i++;
}
}
%>
</script>
</table>
<input type="submit" value="DELETE" name="B1">
<table border="0" width="100%"><tr><td align="left">[Total <%=intPageCount%> Pages]</td><td align="right">
<%if(intPage>1){%><a href="admin.jsp?page=<%=intPage-1%>">Previous</a><%}%> Page<font color="red"><%=intPage%></font> <%if(intPage<intPageCount){%><a href="admin.jsp?page=<%=intPage+1%>">Next</a><%}%>
</td></tr></table>
</form>
<%
sqlRst.close();
if(intAllflag!=1){
%>
<p><big>(<em><strong><font color=#ff0000 ><%=strShow %></font> wanna speak</strong></em>)</big></p>
<form METHOD="POST" name=PostDoc action="post1.jsp" onsubmit="return CheckForm()">
<input type="hidden" name="task" value="insert">
<table border="1" borderColorDark="#ffffff" borderColorLight="#333333"
cellPadding="0" cellSpacing="0" width="60%">
<tr>
<td width="100%"><em><strong><font color=#42738c face="times new roman"><big>New Topic:</big></font></strong></em></td>
</tr>
<tr>
<td width="100%"><input TYPE="text" SIZE="60" NAME="title"
style="background-color: rgb(245,252,252)"></td>
</tr>
<tr>
<td width="100%"> <img alt height="20"
src="images/m1.gif" width="20"><input type="radio"
value="1" name="R1"> <img alt height="20"
src="images/m2.gif" width="20"> <input type="radio"
value="2" name="R1"> <img alt height="20"
src="images/m3.gif" width="20"> <input type="radio"
value="3" name="R1"> <img alt height="20"
src="images/m4.gif" width="20"> <input type="radio"
value="4" name="R1"></td>
</tr>
<tr>
<td width="100%"><em><strong><font color=#42738c face="times new roman"><big>Type Here:</font></strong></em><input
type="checkbox" name="htmltag" ><small>HTML</small>
</td>
</tr>
<tr>
<td width="100%"><textarea wrap="virtual" ROWS="15" COLS="60" NAME="content" maxlength="60"
style="background-color: rgb(245,252,252)"></textarea></td>
</tr>
<tr>
<td width="100%"><input TYPE="submit" VALUE="Send" NAME="B1"><input TYPE="reset"
VALUE="Cancel" NAME="B2"></td>
</tr>
</table>
</form>
<% }
}else{
out.print("You have no right to run this page!!!");
}
}else{
out.print("Please Login!!!");
}
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -