📄 selectdjjg.jsp
字号:
<%@ page contentType="text/html; charset=GBK" %>
<%@ page language="java"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<%@ page import="com.censoft.gongshang.util.*"%>
<%@ page import="com.censoft.gongshang.control.event.*"%>
<%@ page import="com.censoft.gongshang.component.enterprise.model.*"%>
<%@ page import="com.censoft.gongshang.component.sysadmin.model.*"%>
<html>
<HEAD>
<meta content="no-cache" http-equiv="Pragma"/>
<link href="<%=request.getContextPath()%>/include/style/<%=(String)(session.getAttribute("frameworkStylePath"))%>/style.css" rel="stylesheet" type="text/css">
<SCRIPT LANGUAGE="JavaScript">
function ck(){
//alert (window.returnValue);
window.close();
}
function dosel(zz){
//alert (zz);
window.returnValue=zz;
window.close();
}
</script>
<base target="_self">
<link rel="stylesheet" href="../calendar/scroll.css">
<link rel="stylesheet" href="calendar/ioa-1.css">
<body class="businessBody01" scroll=auto>
<form name="search" method="post">
<table border="1" width="100%" class="businessTable00" >
<%
String sql= null;
UserModel user = (UserModel) session.getAttribute("userModel");
String userDjjg = (String)user.getAreaCoding();
String selectedDjjg = (String)request.getParameter("selectedDjjg");
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
ArrayList DjjgPart = null;//存放省级登记机关
ArrayList DjjgAll = null;//存放所选省下的登记机关
try{
conn = Common.getConnection();
stmt = conn.createStatement();
%>
<tr>
<td nowrap colspan="3" height="31" class="businessTdTitle00">省名称</td>
</tr>
<%
//取得所有省级登记机关
sql="select * from a_bm_djjg where content like '%0000' order by content" ;
//DjjgPart = GetCodingTable.getCodeBySql(sql);
rs = stmt.executeQuery(sql);
String td = "businessTd00Left";
int rowNum = 0;
while(rs.next()){
String djjgCode = PubFunc.toShow(rs.getString("content"));
String djjgContent = PubFunc.toShow(rs.getString("coding"));
rowNum = rs.getRow();
if(rowNum%3==1){
out.print("<tr>");
td=td.equals("businessTd00Left")?"businessTd01Left":"businessTd00Left";
}
%>
<td height="31" width="33%" class="<%=td%>"><A href="<%=request.getContextPath()%>/include/tools/djjg/selectDJJG.jsp?selectedDjjg=<%=djjgCode%>"><%=djjgContent%></A></td>
<% if(rowNum%3==0)out.print("</tr>");%>
<% } //end while%>
<% if(rowNum%3!=0){
for(int i=0;i<3 - rowNum%3;i++){
%>
<td height="31" width="33%" class="<%=td%>"></td>
<%
}
out.print("</tr>");
}
%>
</table>
<table border="1" width="100%" class="businessTable00" >
<tr>
<td nowrap colspan="2" height="31"class="businessTdTitle00">省所辖范围内市县级登记机关</td>
</tr>
<%
//取得当前用户所在省的各级登记机关
sql="select * from a_bm_djjg" ;
if(selectedDjjg!=null && !selectedDjjg.equals("")){
sql += " where content like '"+selectedDjjg.substring(0,2)+"%' order by content";
}else if(userDjjg != null && !userDjjg.equals("")){
sql += " where content like '"+userDjjg.substring(0,2)+"%' order by content";
}
td = "businessTd00Left";
rowNum = 0;//查询结果集的当前行号
//记录当前的TD是行首还是行末
String TrStart = "true";//true 当前列是行首； false 当前行不是行首
String TrEnd = "false";//false 当前列不是行末； true 当前列是行末
//记录上一行的TD是行首还是行末
String TrStartP = "false";//true 上一行是行首； false 上一行不是行首
String TrEndP = "false";//false 上一行不是行末； true上一行是行末
//记录上一行的登记机关编码
String djjgCodeP = "";
rs = stmt.executeQuery(sql);
while(rs.next()){
String djjgCode = PubFunc.toShow(rs.getString("content"));
String djjgContent = PubFunc.toShow(rs.getString("coding"));
String spacePrint = "";//市县级登记机关名称前加的空格。 省级前为""；市级前为" "；县级前为" "
String colspanStr = "";
rowNum = rs.getRow();//获取rs中当前记录的行号
if(djjgCode.substring(2).equals("0000")){//省级登记机关
if(TrEndP.equals("false") && rowNum>1)out.print("<td height='31' class='"+td+"'></td></tr>");
colspanStr = "colspan=2";
TrStart = "true";
TrEnd = "true";
}else if(djjgCode.substring(4).equals("00")){//市级登记机关
if(TrStartP.equals("true") && TrEndP.equals("false") && rowNum>1)out.print("<td height='31' class='"+td+"'></td></tr>");
spacePrint += " ";
colspanStr = "colspan=2";
TrStart = "true";
TrEnd = "true";
}else{//县级登记机关
if(TrStartP.equals("true") && TrEndP.equals("false")){
TrStart = "fasle";
TrEnd = "true";
}else{
if(!djjgCodeP.substring(0,4).equals(djjgCode.substring(0,4))){
if(TrStartP.equals("true") && TrEndP.equals("false") && rowNum>1)out.print("<td height='31' class='"+td+"'></td></tr>");
out.print("<tr><td colspan='2' height='31' class='"+td+"'></td></tr>");
}
TrStart = "true";
TrEnd = "false";
}
spacePrint += " ";
}
if(TrStart.equals("true")){
out.print("<tr>");
td=td.equals("businessTd00Left")?"businessTd01Left":"businessTd00Left";
}
%>
<td nowrap <%out.print(colspanStr);%> height="31" class="<%=td%>"><%out.print(spacePrint);%><A href="#" onClick="dosel('<%=djjgCode%>');"><%=djjgContent%>（<%=djjgCode%>）</A></td>
<%
if(TrEnd.equals("true")){
if(rowNum>1)out.print("</tr>");
}
TrStartP = TrStart;
TrEndP = TrEnd;
djjgCodeP = djjgCode;
%>
<%}//end while%>
<%if(TrEnd.equals("false")){%>
<td height="31" width="50%" class="<%=td%>"></td></tr>
<%}%>
</table>
</form>
</body>
</html>
<%
}catch(Exception ex){
Debug.println("[selectDJJG.jsp]--->>>Exception:"+ex.getMessage());
}finally{
try{
Common.clearUp(rs,stmt,conn);
//if(rs != null) rs.close();
//if(stmt != null) stmt.close();
//if(conn != null && !conn.isClosed()) conn.close();
Debug.print("[selectDJJG.jsp]--->>>conn已关闭：" + conn);
} catch(Exception e){
Debug.print("[selectDJJG.jsp]--->>>关闭数据库连接出错");
}
}%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -