📄 select.jsp
字号:
<%@ page contentType="text/html; charset=GBK" %>
<%@ page language="java"%>
<%@ page import="java.util.*"%>
<%@ page import="com.censoft.gongshang.util.*"%>
<%@ page import="java.util.*,com.censoft.gongshang.util.*"%>
<%@ page import="com.censoft.gongshang.control.event.*"%>
<%@ page import="com.censoft.gongshang.component.enterprise.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>
<tr><td class="businessTd01">内容：<input type=text name="con" ><input type=submit name="searchCon" class="button" value="查询"><input type=button name=sel class="button" value="选定" onClick='ck()'></td></tr>
</table>
<table border="1" width="100%" class="businessTable00" >
<%
String bm = (String)request.getParameter("bm").toLowerCase();
String sql="";
String con = (String)request.getParameter("con");
//out.print(con);
//out.print(bm);
if (bm!=null && !bm.equals("") && bm.equals("dict_sex")) {
sql="select * from " + bm ;
if (con!=null && !con.equals("") ) sql+= " where content like '%" + PubFunc.toSql(con) + "%'" ;
}
else if (bm!=null && !bm.equals("") && bm.equals("a_bm_djjg"))
{
sql="select content,coding from " + bm ;
if (con!=null && !con.equals("") ) sql+= " where coding like '%" + PubFunc.toSql(con) + "%'" ;
}
else if (bm!=null && !bm.equals("") && bm.equals("gsshare_coding_registerorg"))
{
sql="select coding,content from " + bm ;
if (con!=null && !con.equals("") ) sql+= " where content like '%" + PubFunc.toSql(con) + "%'" ;
}
else if (bm!=null && !bm.equals("") && bm.equals("a_bm_gbdq"))
{
sql="select bm,bmnr from " + bm ;
if (con!=null && !con.equals("") ) sql+= " where bmnr like '%" + PubFunc.toSql(con) + "%'" ;
}
else if (bm!=null && !bm.equals("") && bm.equals("a_bm_jyfwgf"))
{
sql="select bm,nr from " + bm ;
if (con!=null && !con.equals("") ) sql+= " where nr like '%" + PubFunc.toSql(con) + "%'" ;
}
else if (bm!=null && !bm.equals("") && bm.equals("dict_alteration"))
{
sql="select coding,content from " + bm ;
if (con!=null && !con.equals("") ) sql+= " where content like '%" + PubFunc.toSql(con) + "%'" ;
}
else if (bm!=null && !bm.equals("") && bm.equals("gsgsjout_coding_trade"))
{
sql="select coding,content from " + bm ;
if (con!=null && !con.equals("") ) sql+= " where content like '%" + PubFunc.toSql(con) + "%'" ;
}
else if (bm!=null && !bm.equals("") && bm.equals("gs_dict_trade1"))
{
sql="select code,explain from " + bm ;
if (con!=null && !con.equals("") ) sql+= " where explain like '%" + PubFunc.toSql(con) + "%'" ;
}
else if (bm!=null && !bm.equals("") && bm.equals("gs_dict_trade2"))
{
sql="select code,explain from " + bm ;
if (con!=null && !con.equals("") ) sql+= " where explain like '%" + PubFunc.toSql(con) + "%'" ;
}
else if (bm!=null && !bm.equals(""))
{
sql="select * from " + bm ;
if (con!=null && !con.equals("") ) sql+= " where nr like '%" + PubFunc.toSql(con) + "%'" ;
}
//out.print(sql);
ArrayList sex = GetCodingTable.getCodeBySql(sql);
String td = "businessTd00Left";
%>
<tr>
<td nowrap height="31" width="20%" class="businessTdTitle00">选择</td>
<td nowrap height="31" width="80%" class="businessTdTitle00">内容</td>
</tr>
<%
EnterpriseCoding ec=null;
for(int count=0;count<sex.size();count++){
ec = (EnterpriseCoding)sex.get(count);
td=td.equals("businessTd00Left")?"businessTd01Left":"businessTd00Left";
%>
<tr >
<td nowrap height="31" width="20%" class="<%=td%>" ><input type=radio name=code value="<%=PubFunc.toShow(ec.getCode())%>" onclick="dosel(this.value)" > </td>
<td nowrap height="31" width="80%" class="<%=td%>" > <%=PubFunc.toShow(ec.getContent())%></td>
</tr>
<% } %>
</table>
</form>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -