grouplist_jsp.java
来自「jsp_javabean+tomcat的web管理系统！」· Java 代码 · 共 362 行 · 第 1/2 页
JAVA
362 行
package org.apache.jsp;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import java.sql.*;
import msrv.PurviewVerify;
import msrv.GBCoding;
public final class groupList_jsp extends org.apache.jasper.runtime.HttpJspBase
implements org.apache.jasper.runtime.JspSourceDependent {
private static java.util.Vector _jspx_dependants;
static {
_jspx_dependants = new java.util.Vector(1);
_jspx_dependants.add("/verifys.inc");
}
public java.util.List getDependants() {
return _jspx_dependants;
}
public void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
JspFactory _jspxFactory = null;
PageContext pageContext = null;
HttpSession session = null;
ServletContext application = null;
ServletConfig config = null;
JspWriter out = null;
Object page = this;
JspWriter _jspx_out = null;
PageContext _jspx_page_context = null;
try {
_jspxFactory = JspFactory.getDefaultFactory();
response.setContentType("text/html; charset=gb2312");
pageContext = _jspxFactory.getPageContext(this, request, response,
"", true, 8192, true);
_jspx_page_context = pageContext;
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
_jspx_out = out;
out.write('\r');
out.write('\n');
out.write('\r');
out.write('\n');
msrv.PurviewVerify pv = null;
synchronized (_jspx_page_context) {
pv = (msrv.PurviewVerify) _jspx_page_context.getAttribute("pv", PageContext.PAGE_SCOPE);
if (pv == null){
pv = new msrv.PurviewVerify();
_jspx_page_context.setAttribute("pv", pv, PageContext.PAGE_SCOPE);
}
}
out.write('\r');
out.write('\n');
String msrvUserID="",projectID="",contextPath="",relativelyURI="",relativelyFile="";
if(session.getAttribute("msrvUserID")==null||session.getAttribute("msrvUserID").equals(""))
{
out.print("<script>alert('非法进入');window.location='main.jsp';window.parent.carnoc.location='left.jsp'</script>");
return;
}else{
msrvUserID=(String)session.getAttribute("msrvUserID");
contextPath=request.getContextPath();
relativelyURI=request.getRequestURI();
relativelyFile=relativelyURI.substring(contextPath.length()+1,relativelyURI.length());
}
pv.init(Integer.parseInt(msrvUserID),relativelyFile);
if(!pv.getViewPurview()){
out.print("<script>alert('你不具有此项权限，请与管理员联系！');</script>");
return;
}
out.write('\r');
out.write('\n');
msrv.NDBConn conn = null;
synchronized (_jspx_page_context) {
conn = (msrv.NDBConn) _jspx_page_context.getAttribute("conn", PageContext.PAGE_SCOPE);
if (conn == null){
conn = new msrv.NDBConn();
_jspx_page_context.setAttribute("conn", conn, PageContext.PAGE_SCOPE);
}
}
out.write("\r\n");
out.write("<html>\r\n");
out.write("<head>\r\n");
out.write("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n");
out.write("<title>无标题文档</title>\r\n");
out.write("<style type=\"text/css\">\r\n");
out.write("<!--\r\n");
out.write("body {\r\n");
out.write("\tmargin-left: 0px;\r\n");
out.write("\tmargin-top: 0px;\r\n");
out.write("\tmargin-right: 0px; \r\n");
out.write("\tmargin-bottom: 0px;\r\n");
out.write("}\r\n");
out.write(".style1 {color: #FFFFFF}\r\n");
out.write("-->\r\n");
out.write("</style>\r\n");
out.write("<script language=\"javascript\">\r\n");
out.write(" //分页跳转\r\n");
out.write(" function gotoPage(pageNum){\r\n");
out.write("\t document.pagiNation.pageNum.value=pageNum;\r\n");
out.write("\t document.pagiNation.submit();\r\n");
out.write("\t}\r\n");
out.write("\tfunction checkAdd(){\r\n");
out.write("\t if(document.addForm.groupName.value==''){\r\n");
out.write("\t alert(\"请输入组名称！\");\r\n");
out.write("\t\t document.addForm.groupName.focus();\r\n");
out.write("\t\t return false;\r\n");
out.write("\t }\r\n");
out.write("\t}\r\n");
out.write("</script>\r\n");
out.write("<link href=\"css/all.css\" rel=\"stylesheet\" type=\"text/css\">\r\n");
out.write("</head>\r\n");
out.write("\r\n");
out.write("<body>\r\n");
String sql="",groupPurviewSql="",cntrl="",groupID="",groupName="",groupClass="",group_ID="",auSql="";
ResultSet groupRS=null,groupInfoRS=null;
int groupInfoRSRows=0,rows=0,groupRows=0,gi=0;
if(request.getParameter("cntrl")!=null&&(request.getParameter("cntrl").equals("addGroupName")||request.getParameter("cntrl").equals("updateGroupName"))){
groupName=GBCoding.getStrFromISO(request.getParameter("groupName")).trim();
groupClass=request.getParameter("groupClass").trim();
if(request.getParameter("cntrl").equals("addGroupName"))
auSql="insert into tb_srv_group(tsg_name,tsg_handle_class) values('"+groupName+"',"+groupClass+")";
else if(request.getParameter("cntrl").equals("updateGroupName")){
group_ID=request.getParameter("group_ID");
auSql="update tb_srv_group set tsg_name='"+groupName+"',tsg_handle_class="+groupClass+" where tsg_id="+group_ID;
}
if(!auSql.equals("")){
try{
rows=conn.executeUpdate(auSql);
}catch(SQLException ex){out.println(ex.getMessage());}
finally{
conn.closeStatement();
}
if(rows>0) out.println("<script>alert('添加成功！');</script>");
else out.println("<script>alert('添加失败！');</script>");
}
groupName="";
groupClass="";
}
sql="select tsg_id,tsg_name,tsg_handle_class from tb_srv_group";
try{
groupRS=conn.executeQuery(sql);
}catch(SQLException ex){out.println(ex.getMessage());}
//查询群组信息
if(request.getParameter("cntrl")!=null&&request.getParameter("cntrl").equals("getGroupInfo")&&!request.getParameter("groupID").equals("")){
cntrl=request.getParameter("cntrl").trim();
groupID=request.getParameter("groupID");
}
try{
groupRS.last();
groupRows=groupRS.getRow();
groupRS.beforeFirst();
}catch(SQLException ex){out.println(ex.getMessage());}
String[][] group=new String[groupRows][3];
try{
while(groupRS.next()){
group[gi][0]=groupRS.getString(1);
group[gi][1]=groupRS.getString(2);
group[gi][2]=groupRS.getString(3);
gi++;
}
}catch(SQLException ex){out.println(ex.getMessage());}
finally{
if(groupRS!=null){
groupRS.close();
groupRS=null;
}
conn.closeStatement();
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?