📄 servlet.jsp
字号:
<%--
servlet.jsp
--%>
<%@page contentType="text/html;charset=GBK"%>
<%@page import="java.util.*,oa.main.*"%>
<jsp:useBean id="pb" class="oa.main.ParentBean" scope="page"/>
<html>
<title>数据库异常报告</title>
<body>
<%
request.setCharacterEncoding("GBK");
String uid = (String)session.getAttribute("zgbh");
if(pb.getConn()==null) throw new Exception("数据库无法响应");
DealString ds = new DealString();
out.println("<p align='left'>");
String strAction = ds.toString((String)request.getParameter("action"));
String strId = ds.toString((String)request.getParameter("id"));
int err = -1;
try{
if(uid==null)
{
response.sendRedirect("../../session_oa.htm");
return;
}
String person_ID = (String)session.getAttribute("zgbh");
//填写反馈意见
if(strAction.equals("back")){
String strBackId= ds.toString((String)request.getParameter("backid"));
String strBackTime = ds.toString((String)request.getParameter("txt_backtime"));
strBackTime = ds.getDateTime();
String strBackIdea = ds.toString((String)request.getParameter("txt_backidea"));
String sql = " update HG2_MEET_SUMMARY_MEN "
+ " set REBACK = '" + strBackIdea + "' "
+ " where ID='"+strBackId+"'";
err = pb.executeUpdate(sql);
}
//督办落实
if(strAction.equals("perform")){
String strPerform = ds.toString((String)request.getParameter("txt_perform"));
String strIsPerform = ds.toString((String)request.getParameter("txt_isperform"));
String sql = " update HG2_MEET_SUMMARY "
+ " set PERFORMER = '" + person_ID + "',"
+ " PERFORM = '" + strPerform + "',"
+ " ISPERFORM = '"+strIsPerform+"' "
+ " where ID = '" + strId + "'";
err = pb.executeUpdate(sql);
}
//归档
if (strAction.equals("pigeonhole")) {//成文归档
//把接收人姓名组合成逗号分隔
String sql = "select XM from HG2_MEET_SUMMARY_MEN,ZZ_ZGB where HG2_MEET_SUMMARY_MEN.RECEIVER=ZZ_ZGB.ZGBH and SUMMARYID='" + strId + "'";
out.println(sql);
Vector vect = pb.getDataBySql(sql);
String receivers="";
if(vect.size()>0){
receivers = ",";
for ( int i=0; i<vect.size(); i++){
Hashtable hashtable = (Hashtable)vect.get(i);
receivers += (String)hashtable.get("XM") + ",";
}
receivers=receivers.substring(1,receivers.length()-1);
}
//把会议纪要内容拷贝到历史表
pb.closeAutoCommit();//设置非自动提交
pb.createStatement();
pb.clearBatch();
//得到新的 HG2_MEET_SUMMARY_HISTORY.ID
int newID = pb.makeID("HG2_MEET_SUMMARY_HISTORY","ID","","",true);
sql = "insert into HG2_MEET_SUMMARY_HISTORY (select '" + newID + "',TITLE,"
+ "KEYWORD,WORD,MLEVEL,TIME,SENDER,CHECKER,CHECKWORD,CHECKERTIME,'"
+ receivers+"',PERFORMER,PERFORM from HG2_MEET_SUMMARY where id='" + strId + "')";
out.println(sql);
pb.addBatch(sql);
//清空纪要表、纪要接收人表
sql = "delete from HG2_MEET_SUMMARY where id='" + strId + "'";
out.println(sql);
pb.addBatch(sql);
sql = "delete from HG2_MEET_SUMMARY_MEN where SUMMARYID='" + strId + "'";
out.println(sql);
pb.addBatch(sql);
int[] errs = pb.executeBatch(); //执行批处理
if (errs != null) {
err=0;
for(int i=0;i<errs.length;i++){
if(errs[i]<0){
err=-1;
break;
}
}
}
if(err == 0) {
pb.commit(); //执行正确完成，数据库提交
}
else {
pb.rollback(); //执行出错，操作回滚
}
pb.closeStm();
}
if(err==0)
out.println("操作完成，正常结束，请稍等片刻...");
else
throw new Exception("数据提交出错");
%>
<script>
<%if(strAction.equals("back")){%>
window.location.replace("read.jsp?id=<%=strId%>");
<%}else{%>
window.location.replace("list.jsp");
<%}%>
</script>
<%
}catch(Exception e){
%>
<%=e.getMessage()%>，请单击返回按钮再试一次。
<input type="button" value="返回" onclick="javascript:history.back()">
<hr>
<%
}
finally{
pb.closeConn();
}
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -