所有字段显示field_list.jsp
<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="check.jsp"%>
<%@ page import="java.util.Date"%>
<%@ page import="java.text.DateFormat"%>
<%@ include file="top.jsp"%>
<script language="javascript" src="../skins/default/js/list.js"></script>
<script type="text/javascript">
function firm(s)
{//利用对话框返回的值（true 或者 false）
if(confirm("确定删除?"))
{//如果是true ，那么就把页面转向
location.href=s;
}
}
</script>
<%
String sql,sql2,sqlID2,StrHref,StrID,Strxuhao,StrID2;//
ResultSet rs,rs2,rs3,rsID2;
int xuhao,xuhao2;
%>
<div class="container-fluid">
<h3><a href="field_add.jsp">新增字段</a></h3>
<ul id="myTab" class="nav nav-tabs">
<%
sql="select * from crm_card where isMenu=1 order by id";
rs=stmt.executeQuery(sql);
rs.last();
int intCount=rs.getRow();
rs.beforeFirst();
String strClass[]=new String[intCount];
xuhao=1;
while(rs.next()) {
strClass[xuhao-1]=rs.getString("CardName");
if(xuhao==1){
%>
<li class="active"><a href="#href_<%=xuhao%>" data-toggle="tab"><%=rs.getString("CardName")%></a></li>
<%}
else{%>
<li><a href="#href_<%=xuhao%>" data-toggle="tab"><%=rs.getString("CardName")%></a></li>
<%}xuhao=xuhao+1;}%>
</ul>
<div id="myTabContent" class="tab-content">
<%for(int i=1;i<xuhao;i++){
if(i==1){%>
<div class="tab-pane fade in active" id="href_<%=i%>">
<%}else{%>
<div class="tab-pane fade" id="href_<%=i%>">
<%}%>
<!--form name="listForm"-->
<table class="table table-striped table-hover" width="100%" border="0" cellspacing="0" cellpadding="0">
<thead class="TD_Title">
<tr>
<td>选择</td>
<td>序号</td>
<td title="数字越小越靠前">位置</td>
<td>字段名称</td>
<td>字段Label</td>
<td>字段类型</td>
<td>输入数据时可否为空</td>
<td>输入方式</td>
<td>检测输入</td>
<td>在查询时是否显示数据</td>
<td>列宽</td>
<td colspan="2">操作</td>
</tr>
</thead>
<tbody class="TD_List">
<%
//String className=rs.getString("Class_Name");
sql2="select * from crm_syscustom,crm_card where isMenu=1 and isLock=0 and CustomGroup=crm_card.id and crm_card.CardName='"+strClass[i-1]+"' order by CustomRow,CustomID";
rs2=stmt.executeQuery(sql2);
xuhao2=1;
while(rs2.next()) {%>
<tr>
<td><input name="FieldID" type="checkbox" value="<%=rs2.getString("CustomID")%>" /></td>
<td><%=xuhao2%></td>
<td title="数字越小越靠前"><%=rs2.getString("CustomRow")%></td>
<td><%=rs2.getString("CustomName")%></td>
<td><%=rs2.getString("CustomLabel")%></td>
<%switch(Integer.parseInt(rs2.getString("CustomType"))){
case 0:%>
<td >整型(数字)</td>
<%
break;
case 1:%>
<td >字符型</td>
<%
break;
case 2:%>
<td>真假</td>
<%
break;
case 3:%>
<td>日期时间型</td>
<%
break;
case 4:%>
<td>备注</td>
<%
break;
case 5:%>
<td>短整型（数字）</td>
<%
break;
case 6:%>
<td>日期型</td>
<%
break;
case 7:%>
<td>时间型</td>
<%
break;
case 8:%>
<td>duoble</td>
<%
break;
default:
out.print("错误信息或没有选项");}%>
<!--td><%=rs2.getString("CardName")%></td-->
<%if(Integer.parseInt(rs2.getString("CustomBlank"))==0){%>
<td title="可否为空值">可以为空</td>
<%}else{%>
<td title="可否为空值">不能为空</td>
<%}//是否为空 end%>
<%switch(Integer.parseInt(rs2.getString("CustomInputWay"))){
case 0:%>
<td>输入框</td>
<%
break;
case 1:%>
<td>下拉菜单</td>
<%
break;
case 2:%>
<td>密码框</td>
<%
break;
case 3:%>
<td>自动获取当前用户</td>
<%
break;
case 4:%>
<td>备注</td>
<%
break;
case 5:%>
<td>输入框（数字）</td>
<%
break;
case 6:%>
<td>输入框（网址）</td>
<%
break;
case 7:%>
<td>输入框（日期时间）</td>
<%
break;
case 8:%>
<td>输入框（Email）</td>
<%
break;
default:
out.print("错误信息或没有选项");}//输入方式结束%>
<%switch(Integer.parseInt(rs2.getString("CheckInput"))){
case 0:%>
<td title="不检测">不检测</td>
<%
break;
case 1:%>
<td title="只能输入英文">只能输入英文</td>
<%
break;
default:
out.print("错误信息或没有选项");}%>
<%if(Integer.parseInt(rs2.getString("CustomDisplay"))==1){%>
<td title="在查询数据的时候不显示此列">不显示</td>
<%}else{%>
<td title="在查询数据的时候显示此列">显示</td>
<%}//是否显示 end%>
<td><%=rs2.getString("DisplayWidth")%></td>
<%if(Integer.parseInt(rs2.getString("isSystem"))==1){%>
<td><a href="field_edit.jsp?CustomID=<%=rs2.getString("CustomID")%>">编辑</a></td>
<td><a href="#" onclick='firm("field_del.jsp?CustomID=<%=rs2.getString("CustomID")%>")'>删除</a></td>
<%}else{%>
<td colspan="2">系统保留字段</td><%}%>
</tr>
<%xuhao2=xuhao2+1;}%>
</tbody>
</table>
<!--div class="ButtonList">
<ul>
<li><a href="javascript:SelectAll()" class="ButtonList">全选</a></li>
<li><a href="javascript:ChangeSelect()" class="ButtonList">反选</a></li>
<li><a href="javascript:NoSelect()" class="ButtonList">取消</a></li>
<li><a href="javascript:UpdateSelect()" class="ButtonList">更新</a></li>
<li><a href="javascript:DelCustom()" class="ButtonList">删除</a></li>
</ul>
</div>
</form--></div>
<%}%>
</div>
</div>
<%@ include file="bottom.jsp"%>
- 文章导航