orderbconfig_jsp.java
来自「jsp_javabean+tomcat的web管理系统！」· Java 代码 · 共 376 行
JAVA
376 行
package org.apache.jsp.customize;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import java.sql.*;
import java.util.*;
import msrv.Pagination;;
public final class orderBconfig_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("/customize/../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.DBConn conn = null;
synchronized (_jspx_page_context) {
conn = (msrv.DBConn) _jspx_page_context.getAttribute("conn", PageContext.PAGE_SCOPE);
if (conn == null){
conn = new msrv.DBConn();
_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("<link href=\"../css/all.css\" rel=\"stylesheet\" type=\"text/css\">\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 deleteConfirm(url){\r\n");
out.write("\t if(confirm(\"确认要删除此项吗？\")){\r\n");
out.write("\t window.location=url;\r\n");
out.write("\t }\r\n");
out.write("\t}\r\n");
out.write("</script>\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("</head>\r\n");
out.write("\r\n");
out.write("<body>\r\n");
out.write("<div id=popCal style=\"BORDER-RIGHT: 2px ridge; BORDER-TOP: 2px ridge; VISIBILITY: hidden; BORDER-LEFT: 2px ridge; WIDTH: 10px; BORDER-BOTTOM: 2px ridge; POSITION: absolute;z-index:100\">\r\n");
out.write("<iframe name=popFrame src=\"common/PopCalendar.htm\" frameBorder=0 width=183 scrolling=no height=188></iframe>\r\n");
out.write("</div>\r\n");
String sql="",cntrl="",option="",direction="",serviceNumber="",dstNumber="",sendContent="",gateway="";
ResultSet rs=null;
ResultSetMetaData rsmd=null;
int columns=0;
sql="select a.tot_id as '配置编号',a.tot_gatewayFlag as '网关标示',b.tob_name as '业务名称',a.tot_serviceID as";
sql+="'计费代码',a.tot_feetype as '计费类型',a.tot_feeCode as '费率',a.tot_longCode as '服务号码',a.tot_buying_return as '订购回复',";
sql+="a.tot_cancel_return as '取消回复',left(right(a.tot_buying_order,len(a.tot_buying_order)-1),len(a.tot_buying_order)-2) as '订购指令',";
sql+="a.tot_cancel_order as '取消指令',a.tot_second_order as '确认指令',a.tot_order_flag as '订购方式',a.tot_sencond_tips as '确认提示语',";
sql+="tot_free_serviceid as '免费代码',tot_free_FeeType as '免费类型',tot_free_FeeCode as '免费费率',tot_no_order_return as '无定制回复',";
sql+="tot_order_faild_return as '定制失败回复',tot_cancel_faild_return as '取消失败回复',tot_payed_info as '话单内容',tot_unreg_proc as '退订过程',";
sql+="a.tot_status as '状态' from Tb_order_type as a,tb_order_busi as b where a.tot_busiid=b.tob_id order by tot_gatewayFlag asc";
if(request.getParameter("gateway")!=null&&!request.getParameter("gateway").equals("")){
gateway=request.getParameter("gateway");
sql="select a.tot_id as '配置编号',a.tot_gatewayFlag as '网关标示',b.tob_name as '业务名称',a.tot_serviceID as";
sql+="'计费代码',a.tot_feetype as '计费类型',a.tot_feeCode as '费率',a.tot_longCode as '服务号码',a.tot_buying_return as '订购回复',";
sql+="a.tot_cancel_return as '取消回复',left(right(a.tot_buying_order,len(a.tot_buying_order)-1),len(a.tot_buying_order)-2) as '订购指令',";
sql+="a.tot_cancel_order as '取消指令',a.tot_second_order as '确认指令',a.tot_order_flag as '订购方式',a.tot_sencond_tips as '确认提示语',";
sql+="tot_free_serviceid as '免费代码',tot_free_FeeType as '免费类型',tot_free_FeeCode as '免费费率',tot_no_order_return as '无定制回复',";
sql+="tot_order_faild_return as '定制失败回复',tot_cancel_faild_return as '取消失败回复',tot_payed_info as '话单内容',tot_unreg_proc as '退订过程',";
sql+="a.tot_status as '状态' from Tb_order_type as a,tb_order_busi as b where a.tot_busiid=b.tob_id";
sql+=" and tot_gatewayFlag='"+gateway+"'";
}
rs=conn.executeQuery(sql);
rsmd = rs.getMetaData();
columns = rsmd.getColumnCount();
Pagination pageN=null; //分页
int pageNum=1,rows=0,pageSize=0; //页码及行码,页尺寸
try{
pageN=new Pagination(rs);
}catch(Exception ex){out.println(ex.getMessage());}
if(request.getParameter("pageSize")!=null){ //设置页面尺寸
pageSize=Integer.parseInt(request.getParameter("pageSize"));
}else pageSize=20;
pageN.setPageSize(pageSize);
if(request.getParameter("pageNum")!=null){ //设置页码
pageNum=Integer.parseInt(request.getParameter("pageNum"));
if(pageNum<=0) pageNum=1;
}
pageN.gotoPage(pageNum);
out.write("\r\n");
out.write("<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"1\" bgcolor=\"#666666\">\r\n");
out.write(" <tr>\r\n");
out.write(" <td height=\"23\" background=\"images/leftlan01.jpg\"> <span class=\"style1\">点播类业务--业务配置</span></td>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr>\r\n");
out.write(" <td bgcolor=\"#FFFFFF\"> </td>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr>\r\n");
out.write(" <td bgcolor=\"#FFFFFF\">\r\n");
out.write("\t <table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"1\" bgcolor=\"#333333\">\r\n");
out.write(" <tr height=\"16\" align=\"center\" bgcolor=\"#CCCCCC\">\r\n");
out.write(" ");
for(int i=1;i<=columns;i++){
out.write("\r\n");
out.write("\t\t <td align=\"center\" bgcolor=\"#efefef\"><strong>");
out.print(rsmd.getColumnName(i));
out.write("</strong></td>\r\n");
out.write("\t\t ");
}
out.write("\r\n");
out.write("\t\t <td width=\"50\" align=\"center\" bgcolor=\"#efefef\">\r\n");
out.write("\t\t ");
if(pv.getEditPurview()){
out.write("\r\n");
out.write("\t\t <a href=\"orderBcfgAdd.jsp\">增加</a>\r\n");
out.write("\t\t ");
}
out.write("\r\n");
out.write("\t\t </td>\r\n");
out.write(" </tr>\r\n");
out.write(" ");
if(pageN.getRowsCount()>0){
do{
out.write("\r\n");
out.write(" <tr bgcolor=\"#FFF4E6\">\r\n");
out.write(" ");
for(int i=1;i<=columns;i++){
out.write("\r\n");
out.write(" <td align=\"center\" bgcolor=\"#FFFFFF\">\r\n");
out.write(" ");
try{
if(pageN.getObject(i)==null){
out.print("空");
}else{
if(i==columns){
if(pageN.getInt(i)==0) out.println("禁用");
if(pageN.getInt(i)==1) out.println("启用");
}else{
out.print(pageN.getObject(i));
}
}
}catch(SQLException ex){
out.println(ex.getMessage());
}
out.write(" </td>\r\n");
out.write(" ");
}
out.write("\r\n");
out.write("\t\t <td align=\"center\" bgcolor=\"#efefef\">\r\n");
out.write("\t\t <a href=\"typeDetail.jsp?tot_typeid=");
out.print(pageN.getString(1));
out.write("\">配置</a>\r\n");
out.write("\t\t <br>\r\n");
out.write("\t\t ");
if(pv.getEditPurview()){
out.write("\r\n");
out.write("\t\t <a href=\"orderBcfgEdit.jsp?tot_id=");
out.print(pageN.getString(1));
out.write("&gateway=");
out.print(gateway);
out.write("&pageNum=");
out.print(pageNum);
out.write("&pageSize=");
out.print(pageSize);
out.write("\">修改</a>\r\n");
out.write("\t\t ");
}
out.write("<br>\r\n");
out.write("\t\t ");
if(pv.getDeletePurview()){
out.write("\r\n");
out.write("\t\t <a href=\"javascript:deleteConfirm('msrv.CustomizeSrv?cntrl=deleteOrderConfig&tot_id=");
out.print(pageN.getString(1));
out.write("')\">删除</a></td>\r\n");
out.write("\t\t ");
}
out.write("\r\n");
out.write(" </tr>\r\n");
out.write(" ");
rows++;
}while(pageN.next()&&rows<pageSize);
}
out.write("\r\n");
out.write(" ");
int pageCount=0;
pageCount=pageN.getPageCount();
out.write("\r\n");
out.write(" <form action=\"orderBconfig.jsp\" name=\"pagiNation\" method=\"post\">\r\n");
out.write(" <tr>\r\n");
out.write(" <td colspan=\"");
out.print(columns+1);
out.write("\" align=\"center\" bgcolor=\"#cccccc\"><font color=\"#FF9900\">共");
out.print(pageN.getRowsCount());
out.write("条记录 <a href=\"javascript:gotoPage(1);\">首页</a> <a href=\"javascript:gotoPage(");
out.print(pageN.getCurPage()-1);
out.write(");\">上一页</a> <a href=\"javascript:gotoPage(");
out.print(pageN.getCurPage()+1);
out.write(");\">下一页</a> <a href=\"javascript:gotoPage(");
out.print(pageCount);
out.write(");\">末页</a> 页码：");
out.print(pageN.getCurPage());
out.write('/');
out.print(pageCount);
out.write("页</font> 指定：\r\n");
out.write(" <select size=\"1\" onchange=\"javascript:document.pagiNation.submit()\" name=\"pageNum\">\r\n");
out.write(" ");
for(int i=1;i<=pageCount;i++){
out.write("\r\n");
out.write(" <option ");
if(pageNum==i) out.println("selected");
out.write(" value=\"");
out.print(i);
out.write('"');
out.write('>');
out.print(i);
out.write("</option>\r\n");
out.write(" ");
}
out.write("\r\n");
out.write(" </select>\r\n");
out.write(" 页每页显示\r\n");
out.write(" <select size=\"1\" onchange=\"javascript:document.pagiNation.submit()\" name=\"pageSize\">\r\n");
out.write(" ");
int pages=10;
while(pages<=100){
out.write("\r\n");
out.write(" <option\r\n");
out.write("\t\t\t\t\t\t\t\t ");
if(pages==pageSize) out.print("selected");
out.write(" \r\n");
out.write("\t\t\t\t\t\t\t\t value=\"");
out.print(pages);
out.write('"');
out.write('>');
out.print(pages);
out.write("</option>\r\n");
out.write(" ");
if(pages<50) pages=pages+10;
else pages=pages+50;
}
out.write("\r\n");
out.write(" <option value=\"");
out.print(pageN.getRowsCount());
out.write("\">全部</option>\r\n");
out.write(" </select>\r\n");
out.write("\t\t<input type=\"hidden\" name=\"gateway\" value=\"");
out.print(gateway);
out.write("\">\r\n");
out.write(" </td>\r\n");
out.write(" </tr>\r\n");
out.write(" </form>\r\n");
out.write(" </table></td>\r\n");
out.write(" </tr>\r\n");
out.write("</table>\r\n");
pageN.close();
try{
if(rs!=null){
rs.close();
rs=null;
}
}catch(SQLException ex){}
out.write('\r');
out.write('\n');
conn.close();
out.write("\r\n");
out.write("</body>\r\n");
out.write("</html>\r\n");
} catch (Throwable t) {
if (!(t instanceof SkipPageException)){
out = _jspx_out;
if (out != null && out.getBufferSize() != 0)
out.clearBuffer();
if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
}
} finally {
if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context);
}
}
}
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?