field_edit.jsp
<!--
时间：2013年10月25日 14：42
地点：深圳市龙岗区坂田五和悠宠居
作者：Tinwin
功能：系统分类信息编辑
-->
<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" pageEncoding="UTF-8" %>
<%@ include file="check.jsp"%>
<%@ include file="top.jsp"%>
<script type="text/javascript">
function switchItem(sfeilei)
{
var str=document.getElementById('fenlei');
if(sfeilei=='1'){str.style.display='';}else{str.style.display='none';}
}
</script>
<%
String str1=request.getParameter("CustomID");//获取从webinfo.jsp文件中传输过来的参数。
int gid=Integer.parseInt(str1);//将获取信息转换成INT类型。
String sql_editid="select * from crm_syscustom where CustomID='"+gid+"'";
ResultSet rs_editid=stmt.executeQuery(sql_editid);
String SEditCustom[]=new String[7];//用数组保存编辑前的信息；
request.setCharacterEncoding("utf-8"); //新增信息不需要此语句，编辑信息的时候需要添加此语句。
Statement stmt1=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
try
{
if(rs_editid.next())
{
String CustomBlank2=rs_editid.getString("CustomBlank");//是否为空
String SDisplay=rs_editid.getString("CustomDisplay");//是否显示
String CustomRow2=rs_editid.getString("CustomRow");//位置
//String CheckInput2=rs_editid.getString("CheckInput");//检测输入
int CheckInput2=Integer.parseInt(rs_editid.getString("CheckInput"));//检测输入
int intCustomInputWay=Integer.parseInt(rs_editid.getString("CustomInputWay"));//检测输入方式
int intCustomGroup=Integer.parseInt(rs_editid.getString("CustomGroup"));//
int intCustomType=Integer.parseInt(rs_editid.getString("CustomType"));
int DisplayWidth2=Integer.parseInt(rs_editid.getString("DisplayWidth"));
int CustomTypeWidth2=Integer.parseInt(rs_editid.getString("CustomTypeWidth"));
int IntInputValue=Integer.parseInt(rs_editid.getString("InputValue"));
int IntValueChange=intCustomInputWay;//改变前赋值
%>
<form id="webinfo_form" name="webinfo_form" method="post" action="field_edit_save.jsp?id=<%=rs_editid.getString("CustomID")%>">
<table class="FormTable" width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="TD_Left">字段名称：</td>
<td class="TD_Right"><input name="CustomName" value="<%=rs_editid.getString("CustomName")%>" type="text" size="30" /> 如：SystemName</td>
</tr>
<tr>
<td class="TD_Left">字段标签：</td>
<td class="TD_Right"><input name="CustomLabel" value="<%=rs_editid.getString("CustomLabel")%>" type="text" size="30" /> 如：系统名称</td>
</tr>
<tr>
<td class="TD_Left">字段分组：</td>
<td class="TD_Right">
<select name="CustomGroup" id="CustomGroup" disabled="disabled">
<%
String sqlCustomGroup="select * from crm_card where id='"+intCustomGroup+"'";
ResultSet rsCustomGroup=stmt.executeQuery(sqlCustomGroup);
while(rsCustomGroup.next()){%>
<option selected="selected" value ="<%=rsCustomGroup.getString("id")%>"><%=rsCustomGroup.getString("CardName")%></option>
<%}
String sql_Class="select * from crm_card where id<>'"+intCustomGroup+"'";
ResultSet rs_Class=stmt.executeQuery(sql_Class);
while(rs_Class.next()) {%>
<option value ="<%=rs_Class.getString("id")%>"><%=rs_Class.getString("CardName")%></option>
<%}%>
</select>
</td>
</tr>
<tr>
<td class="TD_Left">字段类型：</td>
<td class="TD_Right">
<select name="CustomType" id="CustomType">
<%
String SType[]=new String[9];
SType[0]="整型(数字)";
SType[1]="字符型";
SType[2]="真假";
SType[3]="日期时间型";
SType[4]="备注";
SType[5]="短整型（数字）";
SType[6]="日期型";
SType[7]="时间型";
SType[8]="double";
for(int i=0;i<9;i++){
if(i==intCustomType){%>
<option selected="selected" value ="<%=i%>" ><%=SType[i]%></option>
<%}else{%>
<option value ="<%=i%>" ><%=SType[i]%></option><%}}%>
</select>
</td>
</tr>
<tr>
<td class="TD_Left">字段长度：</td>
<td class="TD_Right"><input name="CustomTypeWidth" type="text" size="30" value="<%=CustomTypeWidth2%>" /> 设置字段长度</td>
</tr>
<tr>
<td class="TD_Left">可否为空：</td>
<td class="TD_Right">
<select name="CustomBlank" id="CustomBlank">
<%if(Integer.parseInt(CustomBlank2)==0){%>
<option selected="selected" value ="0">可以为空</option>
<option value ="1">不能为空</option>
<%}else{%>
<option selected="selected" value ="1">不能为空</option>
<option value ="0">可以为空</option>
<%}%>
</select>
在输入或编辑数据时是否为必填字段</td>
</tr>
<tr>
<td class="TD_Left">输入方式：</td>
<td class="TD_Right">
<select name="CustomInputWay" id="CustomInputWay" onchange="return switchItem(this.value)">
<%
String SWay[]=new String[9];
SWay[0]="输入框";
SWay[1]="下拉菜单";
SWay[2]="密码框";
SWay[3]="自动获取当前用户";
SWay[4]="备注";
SWay[5]="输入框(数字)";
SWay[6]="输入框（网址）";
SWay[7]="输入框（日期时间）";
SWay[8]="输入框（Email）";
//SWay[5]="可输入下拉菜单";
for(int i=0;i<9;i++){
if(i==intCustomInputWay){%>
<option selected="selected" value ="<%=i%>" ><%=SWay[i]%></option>
<%}else{%>
<option value ="<%=i%>" ><%=SWay[i]%></option><%}}%>
</select>
<%if(intCustomInputWay==1){%>
<select name="fenlei" id="fenlei">
<%
ResultSet rs_fenlei=stmt.executeQuery("select * from crm_class where FatherID=0 order by Class_Name");
while(rs_fenlei.next()) {
if(Integer.parseInt(rs_fenlei.getString("id"))==IntInputValue){%>
<option selected="selected" value ="<%=rs_fenlei.getString("id")%>"><%=rs_fenlei.getString("Class_Name")%></option>
<%}else{%>
<option value ="<%=rs_fenlei.getString("id")%>"><%=rs_fenlei.getString("Class_Name")%></option>
<%}//else{%>
<%}//while(rs_fenlei.next()) { end%>
</select>
<%}else{//if(intCustomInputWay==1){ end%>
<select name="fenlei" id="fenlei" style="display:none;">
<%
ResultSet rs_fenlei=stmt.executeQuery("select * from crm_class where FatherID=0 order by Class_Name");
while(rs_fenlei.next()) {
if(Integer.parseInt(rs_fenlei.getString("id"))==IntInputValue){%>
<option selected="selected" value ="<%=rs_fenlei.getString("id")%>"><%=rs_fenlei.getString("Class_Name")%></option>
<%}else{%>
<option value ="<%=rs_fenlei.getString("id")%>"><%=rs_fenlei.getString("Class_Name")%></option>
<%}//else{ end%>
<%}//while(rs_fenlei.next()) { end%>
</select><%}//else{//if(intCustomInputWay==1){ end%>
</td>
</tr>
<tr>
<td class="TD_Left">检测输入：</td>
<td class="TD_Right">
<select name="CheckInput" id="CheckInput">
<%
String SInput[]=new String[2];
SInput[0]="不检测";
SInput[1]="只能输入英文";
for(int j=0;j<2;j++){
if(j==CheckInput2){//如果一样 默认选择%>
<option selected="selected" value ="<%=j%>" ><%=SInput[j]%></option>
<%}else{%>
<option value ="<%=j%>" ><%=SInput[j]%></option><%}}%>
</select>
不检测时：什么都可以输入</td>
</tr>
<tr>
<td class="TD_Left">显示否：</td>
<td class="TD_Right">
<select name="CustomDisplay" id="CustomDisplay">
<%if(Integer.parseInt(SDisplay)==0){%>
<option selected="selected" value ="0">不显示</option>
<option value ="1">显示</option>
<%}else{%>
<option selected="selected" value ="1">显示</option>
<option value ="0">不显示</option>
<%}%>
</select>
在查询数据时，是否显示当前列</td>
</tr>
<tr>
<td class="TD_Left">显示位置：</td>
<td class="TD_Right"><input name="CustomRow" value="<%=CustomRow2%>" type="text" size="30" /> 数字越小排名越靠前，默认不靠前</td>
</tr>
<tr>
<td class="TD_Left">列宽：</td>
<td class="TD_Right"><input name="DisplayWidth" type="text" size="30" value="<%=DisplayWidth2%>" /> 当前列显示宽度</td>
</tr>
<tr>
<td class="TD_Left"> </td>
<td class="TD_Right"><input type="submit" class="SubmitButton" name="Submit" value="确认编辑" /></td>
</tr>
</table>
</form>
<%}
}
catch(SQLException ex)
{
System.err.println("执行错误:"+ex.getMessage() );
}
%>
<%rs_editid.close();
stmt.close();
conn.close();
%>
<%@ include file="bottom.jsp"%>
- 文章导航