📄 area_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" />
<%
if(session.getValue("user")!=null){
int intPageSize=40; //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="",strChecker="",strAll;
String strS1="",strS2="",strS3="";
int i=0,j=0,intAreaid=0,intValue=0;
strUser=(String)session.getValue("user");
String strShow=doit.changecode(strUser);
if(strUser.equals("admin")){
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("ALTER")){
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);
strS1=request.getParameter("T"+j);
strS2=request.getParameter("N"+j);
strS3=request.getParameter("A"+j);
String sqlAlter="UPDATE AREA SET STR_AREATYPE='"+strS1+"', STR_AREANAME='"+strS2+"' , STR_AREAMASTER='"+strS3+"' WHERE INT_AREAID="+intValue;
DB.executeUpdate(sqlAlter);
}
}
}
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 AREA WHERE INT_AREAID="+intValue;
DB.executeUpdate(sqlDel);
}
}
}
}
}
strSql="SELECT * FROM AREA ORDER BY STR_AREATYPE";
%>
<center><font face="times new roman"><big><strong>Boards Management</strong></big></font></center>
<form METHOD="POST" action="area_admin.jsp">
<input type="hidden" name="TASK" value="DO">
<input type="submit" value="ALTER" name="B1">
<table border="0" cellpadding="1" cellspacing="0" width="100%">
<tr bgcolor="#cc3333">
<td align="center" nowrap ><font color="#ffffff" face="times new roman" ><strong>CONFIRM</strong></font></td>
<td align="center" nowrap><font color="#ffffff" face="times new roman"><strong>AREA_ID</strong></font></td>
<td align="center" nowrap><font color="#ffffff" face="times new roman"><strong>AREA_TYPE</strong></font></td>
<td align="center" nowrap><font color="#ffffff" face="times new roman"><strong>AREA_NAME</strong></font></td>
<td align="center" nowrap><font color="#ffffff" face="times new roman"><strong>AREA_MASTER</strong></font></td>
<td align="center" nowrap><font color="#ffffff" face="times new roman"><strong>ARTICLE_NUMBER</strong></font></td>
</tr>
<%
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,id,ss;
int n=1;
while(i<intPageSize && sqlRst.next()){
if(n==1){
ss="bgcolor=#F5FCFC";
n=1-n;
}else{
ss="";
n=1-n;
}
s1=sqlRst.getString("STR_AREATYPE");
s2=sqlRst.getString("STR_AREANAME");
id=sqlRst.getString("INT_AREAID");
s3=sqlRst.getString("STR_AREAMASTER");
s4=sqlRst.getString("INT_ARTICLENUMB");
strChecker="<input type=checkbox name=C"+i+" value="+id+">";
s1="<input type=text NAME='T"+i+"' value="+s1+">";
s2="<input type=text NAME='N"+i+"' value="+s2+">";
s3="<input type=text NAME='A"+i+"' value="+s3+">";
strAll="<tr "+ss+"><td align='center'>"+strChecker+"</td><td align='center'>"+id+"</td><td align='center'>"+s1+"</td><td align='center'>"+s2+"</td><td align='center'>"+s3+"</td><td align='center'>"+s4+"</td></tr>";
out.print(strAll);
i++;
}
}
%>
</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="area_admin.jsp?page=<%=intPage-1%>">Previous</a><%}%> Page<font color="red"><%=intPage%></font> <%if(intPage<intPageCount){%><a href="area_admin.jsp?page=<%=intPage+1%>">Next</a><%}%>
</td></tr></table>
</form>
<%
sqlRst.close();
}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 + -