📄 opennew.jsp
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<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){
String strUser=(String)session.getValue("user");
if(strUser.equals("admin")){
if(request.getParameter("task")!=null){
String strJob=(String)request.getParameter("task");
String strMaster="",strType="",strOption="",strBname="";
if(strJob.equals("opennew")){
strMaster=(String)request.getParameter("master");
//--------whether open new group------------
strOption=(String)request.getParameter("R1");
if(strOption.equals("old")){
strType=(String)request.getParameter("type");
} else{
strType=(String)request.getParameter("newtype");
}
//------------------------------
strBname=(String)request.getParameter("newboard");
strBname=doit.replace(strBname,true);
strType=doit.replace(strType,true);
String sqlOpennew="INSERT INTO AREA (STR_AREATYPE,STR_AREANAME,STR_AREAMASTER) VALUES ('";
sqlOpennew=sqlOpennew+strType+"','";
sqlOpennew=sqlOpennew+strBname+"','";
sqlOpennew=sqlOpennew+strMaster+"')";
DB.executeUpdate(sqlOpennew);
out.print("<center><big><big>Done!!</big></big></center>");
}
}else{
%>
<body>
<br>
<center>
<big><big><strong><font face="Arial">Open New Boards</strong></big></big>
<br>Please Don't Type Space in Board Name and Group Name!!
<form method="POST" action="opennew.jsp">
<input type="hidden" name="task" value="opennew"><table border="1" width="60%">
<tr>
<td width="30%" align="right"></font>Master</td>
<td align="left"><input type="text" name="master" size="10"></td>
</tr>
<tr>
<td width="30%" align="right">Exist Groups</td>
<td align="left"><input type="radio" value="old" name="R1" checked><select name="type"
size="1" class="song9pt">
<%
String strSql="SELECT DISTINCT STR_AREATYPE FROM AREA ";
ResultSet sqlRst=DB.executeQuery(strSql);
while(sqlRst.next())
{String strCell=sqlRst.getString("STR_AREATYPE");
out.print("<option>"+strCell+"</option>");
}
sqlRst.close();
%>
</select></td>
</tr>
<tr>
<td width="30%" align="right">Open A New Group</td>
<td align="left"><input type="radio" value="new" name="R1"><input type="text"
name="newtype" size="10"></td>
</tr>
<tr>
<td width="30%" align="right">New Board Name</td>
<td width="50%" align="left"><div align="left"><p><input type="text" name="newboard"
size="20"></td>
</tr>
<tr>
<td width="100%" align="center" colspan="2"><input type="submit" value="Open" name="B1"><input
type="reset" value="Cancel" name="B2"></td>
</tr>
</table>
</form>
</center>
</body>
</html>
<%}
} 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 + -