field_add.jsp
<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="check.jsp"%>
<%@ include file="top.jsp"%>
<script language="javascript" src="/skins/default/js/list.js"></script>
<script type="text/javascript">
function switchItem(sfeilei)
{
var str=document.getElementById('fenlei');
if(sfeilei=='1'){str.style.display='';}else{str.style.display='none';}
}
</script>
<form action="field_addsave.jsp" onsubmit="return validate_form(this)" name="addForm" method="post">
<table class="FormTable" width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="TD_Left">字段名称：</td>
<td class="TD_Right"><input name="CustomName" type="text" size="30" required /> 如：SystemName</td>
</tr>
<tr>
<td class="TD_Left">字段标签：</td>
<td class="TD_Right"><input name="CustomLabel" type="text" size="30" required /> 如：系统名称</td>
</tr>
<tr>
<td class="TD_Left">所属选项卡：</td>
<td class="TD_Right">
<select name="CustomGroup" id="CustomGroup">
<%
//request.setCharacterEncoding("utf-8");新增信息不需要此语句，编辑信息的时候需要添加此语句。
String sql_Class="select * from crm_card order by InRow desc,id";
ResultSet rs_Class=stmt.executeQuery(sql_Class);
while(rs_Class.next()) {%>
<option value ="<%=rs_Class.getString("id")%>"><%=rs_Class.getString("CardName")%></option>
<%}%>
</select>
如需设置显示顺序请到选项卡管理菜单 设置排序位置 数字越大越靠前 默认不靠前 0</td>
</tr>
<tr>
<td class="TD_Left">字段类型：</td>
<td class="TD_Right">
<select name="CustomType" id="CustomType">
<option value ="0" >整型(数字)</option>
<option value ="1">字符型</option>
<option value ="2">真假</option>
<option value ="3">日期时间型</option>
<option value ="4">备注</option>
<option value ="5" >短整型(数字)</option>
<option value ="6" >日期型</option>
<option value ="7" >时间型</option>
<option selected="selected" value ="8" >double</option>
</select>
</td>
</tr>
<tr>
<td class="TD_Left">字段长度：</td>
<td class="TD_Right"><input name="CustomTypeWidth" type="text" size="30" value="100" required /> 设置字段长度</td>
</tr>
<tr>
<td class="TD_Left">可否为空：</td>
<td class="TD_Right">
<select name="CustomBlank" id="CustomBlank">
<option selected="selected" value ="0">可以为空</option>
<option value ="1">不能为空</option>
</select>
在输入或编辑数据时是否为必填字段</td>
</tr>
<tr>
<td class="TD_Left">输入方式：</td>
<td class="TD_Right">
<select name="CustomInputWay" id="CustomInputWay" onchange="return switchItem(this.value)">
<option selected="selected" value ="0">输入框</option>
<option value ="1">下拉菜单</option>
<option value ="2">秘密框</option>
<option value ="3">自动获取当前用户</option>
<option value ="4">备注</option>
<option value ="5">输入框（数字）</option>
<option value ="6">输入框（网址）</option>
<option value ="7">输入框（日期时间）</option>
<option value ="8">输入框（Email）</option>
<!--<option value ="5">可输入下拉菜单</option-->
</select>
<select name="fenlei" id="fenlei" style="display:none;">
<%int fenlei=0;
ResultSet rs_fenlei=stmt.executeQuery("select * from crm_class where FatherID=0 order by Class_Name");
while(rs_fenlei.next()){%>
<option value ="<%=rs_fenlei.getString("id")%>"><%=rs_fenlei.getString("Class_Name")%></option>
<%}%>
</select>
输入框：用户自行输入，下拉菜单：用户选择系统定义分类或自定义分类</td>
</tr>
</tr>
<tr>
<td class="TD_Left">检测输入：</td>
<td class="TD_Right">
<select name="CheckInput" id="CheckInput">
<option selected="selected" value ="0">不检测</option>
<option value ="1">只能输入英文</option>
</select>
不检测时：什么都可以输入</td>
</tr>
<tr>
<td class="TD_Left">显示否：</td>
<td class="TD_Right">
<select name="CustomDisplay" id="CustomDisplay">
<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" type="text" size="30" value="99" required /> 数字越小排名越靠前</td>
</tr>
<tr>
<td class="TD_Left">列宽：</td>
<td class="TD_Right"><input name="DisplayWidth" type="text" size="30" value="30" required /> 当前列显示宽度</td>
</tr>
<tr>
<td class="TD_Left"> </td>
<td class="TD_Right"><input type="submit" name="Submit" value="保存" /></td>
</tr>
</table>
</form>
<%
rs_Class.close();
stmt.close();
conn.close();
%>
<%@ include file="bottom.jsp"%>field_addsave.jsp
<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="../data/conn.jsp"%>
<%@ include file="check.jsp"%>
<%
String CustomName2 = new String(request.getParameter("CustomName").getBytes("ISO-8859-1"),"utf-8");//字段名称
String CustomLabel2 = new String(request.getParameter("CustomLabel").getBytes("ISO-8859-1"),"utf-8");//字段标签
int CustomGroup2 = Integer.parseInt(request.getParameter("CustomGroup"));//字段选项卡
int CustomType2=Integer.parseInt(request.getParameter("CustomType"));//字段类型
int CustomTypeWidth2=Integer.parseInt(request.getParameter("CustomTypeWidth"));//字段类型长度
int CustomBlank2=Integer.parseInt(request.getParameter("CustomBlank"));//是否为空
int CustomInputWay2=Integer.parseInt(request.getParameter("CustomInputWay"));//输入方式
int fenlei2=Integer.parseInt(request.getParameter("fenlei"));//下拉菜单时绑定值
int CheckInput2 = Integer.parseInt(request.getParameter("CheckInput"));//获取检测输入类型
int CustomDisplay2 =Integer.parseInt(request.getParameter("CustomDisplay"));//获取是否显示
int CustomRow2 = Integer.parseInt(request.getParameter("CustomRow"));//位置排序
int DisplayWidth2=Integer.parseInt(request.getParameter("DisplayWidth"));//当列数据显示宽度
String sqlGroupID="select * from crm_card where id='"+CustomGroup2+"'"; //判断选项卡ID与绑定的选项卡ID一致的信息
ResultSet rsGroupID=stmt.executeQuery(sqlGroupID);
if(rsGroupID.next()){
String sTableName=rsGroupID.getString("CardValue");//表名（选项卡英文名）
String sqlType="select * from crm_syscustom where CustomName='"+CustomName2+"' and CustomGroup='"+CustomGroup2+"'";
ResultSet rsType=stmt.executeQuery(sqlType);
if(rsType.next()){
out.print("已经存在，请重新输入");
}else{
if(CustomInputWay2==1){//输入方式为下拉菜单方式
String sql_id="INSERT INTO crm_syscustom (CustomRow,CustomName,CustomLabel,CustomGroup,CustomType,CustomBlank,CustomInputWay,CustomDisplay,CheckInput,InputValue,DisplayWidth,isSystem,CustomTypeWidth) VALUES ('"+CustomRow2+"','"+CustomName2+"','"+CustomLabel2+"','"+CustomGroup2+"','"+CustomType2+"','"+CustomBlank2+"','"+CustomInputWay2+"','"+CustomDisplay2+"','"+CheckInput2+"','"+fenlei2+"','"+DisplayWidth2+"','1','"+CustomTypeWidth2+"')";
stmt.executeUpdate(sql_id);
}else{
String sql_id="INSERT INTO crm_syscustom (CustomRow,CustomName,CustomLabel,CustomGroup,CustomType,CustomBlank,CustomInputWay,CustomDisplay,CheckInput,DisplayWidth,isSystem,CustomTypeWidth) VALUES ('"+CustomRow2+"','"+CustomName2+"','"+CustomLabel2+"','"+CustomGroup2+"','"+CustomType2+"','"+CustomBlank2+"','"+CustomInputWay2+"','"+CustomDisplay2+"','"+CheckInput2+"','"+DisplayWidth2+"','1','"+CustomTypeWidth2+"')";
stmt.executeUpdate(sql_id);
}
switch(CustomType2){//字段类型
case 0://整型
if(CustomBlank2==0){//如果输入可以为空
stmt.executeUpdate("ALTER TABLE "+sTableName+" ADD "+CustomName2+" INT( "+CustomTypeWidth2+" ) NULL DEFAULT '0' COMMENT '"+CustomLabel2+"'");
}else{
stmt.executeUpdate("ALTER TABLE "+sTableName+" ADD "+CustomName2+" INT( "+CustomTypeWidth2+" ) NOT NULL DEFAULT '0' COMMENT '"+CustomLabel2+"'");}
break;
case 1://字符串
if(CustomBlank2==0){//如果输入可以为空
stmt.executeUpdate("ALTER TABLE "+sTableName+" ADD "+CustomName2+" VARCHAR( "+CustomTypeWidth2+" ) NULL DEFAULT '空' COMMENT '"+CustomLabel2+"'");
}else{
stmt.executeUpdate("ALTER TABLE "+sTableName+" ADD "+CustomName2+" VARCHAR( "+CustomTypeWidth2+" ) NOT NULL DEFAULT '空' COMMENT '"+CustomLabel2+"'");}
break;
case 2://真假
if(CustomBlank2==0){//如果输入可以为空
stmt.executeUpdate("ALTER TABLE "+sTableName+" ADD "+CustomName2+" INT( "+CustomTypeWidth2+" ) NULL DEFAULT '0' COMMENT '"+CustomLabel2+"'");
}else{
stmt.executeUpdate("ALTER TABLE "+sTableName+" ADD "+CustomName2+" INT( "+CustomTypeWidth2+" ) NOT NULL DEFAULT '0' COMMENT '"+CustomLabel2+"'");}
break;
case 3://日期时间
if(CustomBlank2==0){//如果输入可以为空
stmt.executeUpdate("ALTER TABLE "+sTableName+" ADD "+CustomName2+" DATETIME NULL DEFAULT '0000-00-00 00:00:00' COMMENT '"+CustomLabel2+"'");
}else{
stmt.executeUpdate("ALTER TABLE "+sTableName+" ADD "+CustomName2+" DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '"+CustomLabel2+"'");}
break;
case 4://备注
if(CustomBlank2==0){//如果输入可以为空
stmt.executeUpdate("ALTER TABLE "+sTableName+" ADD "+CustomName2+" TEXT NULL COMMENT '"+CustomLabel2+"'");
}else{
stmt.executeUpdate("ALTER TABLE "+sTableName+" ADD "+CustomName2+" TEXT NOT NULL COMMENT '"+CustomLabel2+"'");}
break;
case 5://短整型
if(CustomBlank2==0){//如果输入可以为空
stmt.executeUpdate("ALTER TABLE "+sTableName+" ADD "+CustomName2+" TINYINT( "+CustomTypeWidth2+" ) NULL DEFAULT '0' COMMENT '"+CustomLabel2+"'");
}else{
stmt.executeUpdate("ALTER TABLE "+sTableName+" ADD "+CustomName2+" TINYINT( "+CustomTypeWidth2+" ) NOT NULL DEFAULT '0' COMMENT '"+CustomLabel2+"'");}
break;
case 6://日期型
if(CustomBlank2==0){//如果输入可以为空
stmt.executeUpdate("ALTER TABLE "+sTableName+" ADD "+CustomName2+" DATE NULL DEFAULT '0000-00-00' COMMENT '"+CustomLabel2+"'");
}else{
stmt.executeUpdate("ALTER TABLE "+sTableName+" ADD "+CustomName2+" DATE NOT NULL DEFAULT '0000-00-00' COMMENT '"+CustomLabel2+"'");}
break;
case 7://时间性
if(CustomBlank2==0){//如果输入可以为空
stmt.executeUpdate("ALTER TABLE "+sTableName+" ADD "+CustomName2+" TIME NULL DEFAULT '00:00:00' COMMENT '"+CustomLabel2+"'");
}else{
stmt.executeUpdate("ALTER TABLE "+sTableName+" ADD "+CustomName2+" TIME NOT NULL DEFAULT '00:00:00' COMMENT '"+CustomLabel2+"'");}
break;
case 8://时间性
if(CustomBlank2==0){//如果输入可以为空
stmt.executeUpdate("ALTER TABLE "+sTableName+" ADD "+CustomName2+" DOUBLE NULL DEFAULT '0' COMMENT '"+CustomLabel2+"'");
}else{
stmt.executeUpdate("ALTER TABLE "+sTableName+" ADD "+CustomName2+" DOUBLE NOT NULL DEFAULT '0' COMMENT '"+CustomLabel2+"'");}
break;
default:
out.print("错误信息或没有选项");
}
out.print("添加成功");//
}
}
stmt.close();
conn.close();
response.setHeader("refresh", "3;url=field_list.jsp");
%>
- 文章导航