?? 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 + -