📄 up_move.jsp
字号:
<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="java.util.*,com.ins.*" %>
<jsp:useBean id="GF" scope="session" class="com.bean.GeneralFun" />
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<link rel="stylesheet" href="../style/PageStyle.css" type="text/css">
</head>
<body topmargin="0" bgcolor="#FFFFFF" text="#000000" >
<%
String id=request.getParameter("org_id");
String managerId=request.getParameter("managerid");
exeQueryResult r = new exeQueryResult();
exeQueryResult r2 = new exeQueryResult();
String re[][] = r.getSelectResultWithStringArray("select manager_id ,manager_order from d_manager where org_id="+id+" order by manager_order" );
String re2[][] = r.getSelectResultWithStringArray("select manager_order from d_manager where manager_id="+managerId+" " );
String sql_one=new String();
String sql_two=new String();
int k=re.length;
if(re[k-1][1].equals(re2[0][0]))
{
sql_one="update d_manager set manager_order="+re[k-1][1]+" where manager_id="+re[k-1][0]+"";
}
else
{
for(int i=0;i<k;i++)
{
if(re[i][1].equals(re2[0][0]))
{
sql_one="update d_manager set manager_order="+re[i+1][1]+" where manager_id="+re[i][0]+"";
sql_two="update d_manager set manager_order="+re[i][1]+" where manager_id="+re[i+1][0]+"";
}
}
}
%>
<html>
<head>
<title></title>
<link rel="stylesheet" href="../style/PageStyle.css" type="text/css">
</head>
<body bgcolor="#FFFFFF" text="#000000" background="../images/background.gif">
<br>
<div align="center">
<p>
<%
exeInsertUpdateDelete iud = new exeInsertUpdateDelete();
boolean result1 ;
boolean result2 ;
result1 = iud.execSql(sql_one);
result2 = iud.execSql(sql_two);
if (result1&&result2){
out.println("<h5>业务数据提交从成功!</h5>");
out.println("<p><a href='javascript:history.back();'><h6>返回</h6></a></p>");
}
else{
out.println("<h5>业务数据提交从失败!</h5>");
out.println(result1);
//out.println(result2);
out.println("<p><a href='javascript:history.back();'><h6>返回</h6></a></p>");
}
%>
</p>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -