card_edit.jsp
<%
/*
选项卡编辑
*/
%>
<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="check.jsp"%>
<%@ include file="top.jsp"%>
<%
request.setCharacterEncoding("UTF-8");
int IntID=Integer.parseInt(request.getParameter("id"));//将获取信息转换成INT类型。
String sql_editid="select * from crm_card where id='"+IntID+"'";
ResultSet rs_editid=stmt.executeQuery(sql_editid);
try{
if(rs_editid.next()){
}//if(rs_editid.next()){ end
}//try{ end
catch(SQLException ex){
System.err.println("执行错误:"+ex.getMessage() );
}//catch(SQLException ex){ end
%>
<form action="card_edit_save.jsp?id=<%=rs_editid.getString("id")%>" onsubmit="return validate_form(this)" method="post">
<table class="FormTable" width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="TD_Left">排序位置：</td>
<td class="TD_Right"><input type="text" name="InRow" value="<%=rs_editid.getString("InRow")%>" />
</td>
</tr>
<tr>
<td class="TD_Left">选项卡名称：</td>
<td class="TD_Right"><input type="text" name="CardName" value="<%=rs_editid.getString("CardName")%>" />
</td>
</tr>
<tr>
<td class="TD_Left">表名：</td>
<td class="TD_Right"><input type="text" name="CardValue" value="<%=rs_editid.getString("CardValue")%>" /> 可输入英文、下划线、数字</td>
</tr>
<tr>
<td class="TD_Left">是否在左侧导航显示：</td>
<td class="TD_Right">
<select name="isMenu" id="isMenu">
<%if(Integer.parseInt(rs_editid.getString("isMenu"))==1){%>
<option selected="selected"value ="1">显示</option>
<option value ="0">不显示</option>
<%}else{%>
<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="isDel" id="isDel">
<%if(Integer.parseInt(rs_editid.getString("isDel"))==1){%>
<option selected="selected"value ="1">可以删除</option>
<option value ="0">不可以删除</option>
<%}else{%>
<option selected="selected" value ="0">不可以删除</option>
<option value ="1">可以删除</option>
<%}%>
</select>
</td>
</tr>
<tr>
<td class="TD_Left"> </td>
<td class="TD_Right"><input type="submit" name="Submit" value="保存" /></td>
</tr>
</table>
</form>
<%@ include file="bottom.jsp"%>card_editsave.jsp
<%
/*
选项卡编辑 保存
*/
%>
<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="../data/conn.jsp"%>
<%@ include file="check.jsp"%>
<%
Statement stmt1=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
request.setCharacterEncoding("UTF-8");
try{
int IntID=Integer.parseInt(request.getParameter("id"));
//如果上一页面已经采用request.setCharacterEncoding("UTF-8");下面几句后面就无需添加.getBytes("ISO-8859-1"),"utf-8");
String CardName2 = new String(request.getParameter("CardName").trim());
String CardValue2 = new String(request.getParameter("CardValue").trim());
String InRow2 = new String(request.getParameter("InRow").trim());
String isMenu2 =request.getParameter("isMenu");
String isDel2 =request.getParameter("isDel");
String SCardName2,SCardValue2;
//out.print(CardValue2);
String sql_editid="select * from crm_card where id='"+IntID+"'";
ResultSet rs_editid=stmt.executeQuery(sql_editid);
if(rs_editid.next()){
SCardName2=rs_editid.getString("cardname");
SCardValue2=rs_editid.getString("cardvalue");
if(SCardName2.equals(CardName2)&&SCardValue2.equals(CardValue2)){
stmt.executeUpdate("UPDATE crm_card SET ismenu ='"+Integer.parseInt(isMenu2)+"',inrow ='"+Integer.parseInt(InRow2)+"',isdel ='"+Integer.parseInt(isDel2)+"' where id='"+IntID+"'");
//out.print("两个都一样");
out.print("更新成功,3秒后跳转");
}//if(SCardName2.equals(CardName2)&&SCardValue2.equals(CardValue2)){ end
if(SCardName2.equals(CardName2)&&!SCardValue2.equals(CardValue2)){
ResultSet rsCard=stmt1.executeQuery("select * from crm_card where cardvalue='"+CardValue2+"'");
if(rsCard.next()){
out.println("<script>alert('此表已经存在，请重新输入');history.back()</script>");}
else{
stmt.executeUpdate("UPDATE crm_card SET cardvalue ='"+CardValue2+"',ismenu ='"+Integer.parseInt(isMenu2)+"',inrow ='"+Integer.parseInt(InRow2)+"',isdel ='"+Integer.parseInt(isDel2)+"' where id='"+IntID+"'");
stmt.executeUpdate("RENAME TABLE `"+SCardValue2+"` TO `"+CardValue2+"`");
stmt.executeUpdate("ALTER TABLE `crm_level` CHANGE `"+SCardValue2+"` `"+CardValue2+"` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'C0N0E0D0'");
//out.print("名称一样，表名不一样");
out.print("更新成功,3秒后跳转");
}//else{ end
}//if(SCardName2.equals(CardName2)&&!SCardValue2.equals(CardValue2)){ end
if(!SCardName2.equals(CardName2)&&SCardValue2.equals(CardValue2)){
ResultSet rsCard=stmt1.executeQuery("select * from crm_card where cardname='"+CardName2+"'");
if(rsCard.next()){
out.println("<script>alert('选项卡已经存在，请重新输入');history.back()</script>");}
else{
stmt.executeUpdate("UPDATE crm_card SET cardname ='"+CardName2+"',ismenu ='"+Integer.parseInt(isMenu2)+"',inrow ='"+Integer.parseInt(InRow2)+"',isdel ='"+Integer.parseInt(isDel2)+"' where id='"+IntID+"'");
//out.print("名称不一样，表名一样");
out.print("更新成功,3秒后跳转");
}
}//if(SCardName2.equals(CardName2)&&!SCardValue2.equals(CardValue2)){ end
if(!SCardName2.equals(CardName2)&&!SCardValue2.equals(CardValue2)){
ResultSet rsCard=stmt1.executeQuery("select * from crm_card where cardname='"+CardName2+"' or cardvalue='"+CardValue2+"'");
if(rsCard.next()){
out.println("<script>alert('选项卡或表名已经存在，请重新输入');history.back()</script>");}
else{
stmt.executeUpdate("UPDATE crm_card SET cardname ='"+CardName2+"',cardvalue ='"+CardValue2+"',ismenu ='"+Integer.parseInt(isMenu2)+"',inrow ='"+Integer.parseInt(InRow2)+"',isdel ='"+Integer.parseInt(isDel2)+"' where id='"+IntID+"'");
stmt.executeUpdate("RENAME TABLE `"+SCardValue2+"` TO `"+CardValue2+"`");
stmt.executeUpdate("ALTER TABLE `crm_level` CHANGE `"+SCardValue2+"` `"+CardValue2+"` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'C0N0E0D0'");
//out.print("名称不一样，表名不一样");
out.print("更新成功,3秒后跳转");
}
}//if(SCardName2.equals(CardName2)&&!SCardValue2.equals(CardValue2)){ end
}//if(rs_editid.next()){ end
}//try{ end
catch(SQLException ex){
System.err.println("执行错误:"+ex.getMessage() );
}
response.setHeader("refresh", "3;url=card_list.jsp");
stmt.close();
conn.close();
%>
- 文章导航