dataInterOperation.jsp
1.65 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ include file="/systeminfo/init_wev8.jsp" %>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page"/>
<%
String flag="0";//0保存失败,1保存成功
//save--保存,update--修改,delete-删除
String opera=Util.null2String(request.getParameter("opera"));
String id=Util.null2String(request.getParameter("sid"));
if(!"".equals(id)&&(id.length()==(id.lastIndexOf(",")+1)))
{
id=id.substring(0,(id.length()-1));
}
String dataname=Util.null2String(request.getParameter("dataname"));
String datadesc=Util.null2String(request.getParameter("datadesc"));
String sql="";
if("save".equals(opera))
{
if(!"".equals(dataname))
{
sql=" insert into int_dataInter (dataname,datadesc) values ('"+dataname+"','"+datadesc+"')";
if(rs.execute(sql))
{
flag="1";
}
}
}else if("update".equals(opera))
{
sql=" update int_dataInter set ";
if(!"".equals(dataname))
{
sql+=" dataname='"+dataname+"' ,";
}
sql+=" datadesc='"+datadesc+"' ,";
//去掉最后一个逗号
sql=sql.substring(0,sql.lastIndexOf(","));
sql+=" where id ='"+id+"'";
if(rs.execute(sql))
{
flag="1";
}
}else if("delete".equals(opera))
{
sql=" delete int_dataInter where id in("+id+")";
if(rs.execute(sql))
{
flag="1";
}
}
%>
<script type="text/javascript">
<!--
if(<%=flag%>==1)
{
alert("<%=SystemEnv.getHtmlLabelName(30700 ,user.getLanguage())%>"+"!");
}else
{
alert("<%=SystemEnv.getHtmlLabelName(30651 ,user.getLanguage())%>"+"!");
}
window.location.href="/integration/dataInterlist.jsp";
//-->
</script>