?? 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>
<%
if(pb.getConn()==null) throw new Exception("數據庫無法響應");
DealString ds = new DealString();
request.setCharacterEncoding("GBK");
String str_cur = ds.toString(request.getParameter("cur")); //翻頁時傳遞頁碼
out.println("<p align='left'>");
String strAction = ds.toString((String)request.getParameter("action"));
String strId = ds.toString((String)request.getParameter("id"));
String strID=strId;
int err = 0;
try{
String uid = (String)session.getAttribute("zgbh");
if(uid==null)
{
response.sendRedirect("../../session_oa.htm");
return;
}
String person_ID = (String)session.getAttribute("zgbh");
//歸檔
if (strAction.equals("pigeonhole")) {//成文歸檔
//把接收人姓名組合成逗號分隔
String sql = "select XM,ZGBH 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="";
String receiversZGBH="";
if(vect.size()>0){
receivers = ",";
for ( int i=0; i<vect.size(); i++){
Hashtable hashtable = (Hashtable)vect.get(i);
receivers += (String)hashtable.get("XM") + ",";
receiversZGBH += (String)hashtable.get("ZGBH")+",";
}
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,'"+receiversZGBH+"' 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(strAction.equals("del")){
String WORD=ds.toString(pb.toName("HG2_MEET_SUMMARY","ID","WORD",strID)).trim();
pb.executeUpdate("delete from DOCUMENT_FILE where RECORDID='"+WORD+"'");
pb.executeUpdate("delete from HG2_MEET_SUMMARY_MEN where SUMMARYID='"+strID+"'");
pb.executeUpdate("delete from HG2_MEET_SUMMARY where ID='"+strID+"'");
err=0;
}
//新增操作
if (strAction.equals("add")) {
long newID = ds.makeID(Integer.parseInt(person_ID));
//把會議紀要內容拷貝到歷史表
pb.closeAutoCommit();//設置非自動提交
pb.createStatement();
pb.clearBatch();
String TITLE=ds.toString((String)request.getParameter("TITLE"));
String KEYWORD=ds.toString((String)request.getParameter("KEYWORD"));
String WORD=ds.toString((String)request.getParameter("WORD"));
String LEVEL=ds.toString((String)request.getParameter("LEVEL"));
String TIME=ds.toString((String)request.getParameter("TIME"));
String SENDER=person_ID;
String CHECKER=ds.toString((String)request.getParameter("CHECKER"));
String ISCHECK="0";
String PERFORMER=ds.toString((String)request.getParameter("PERFORMER"));
String ISPERFORM="0";
//把接收人姓名組合成逗號分隔
String sql="insert into HG2_MEET_SUMMARY (ID,TITLE,KEYWORD,WORD,MLEVEL,TIME,SENDER,CHECKER,ISCHECK,PERFORMER,ISPERFORM)"
+"values('"+newID+"','"+TITLE+"','"+KEYWORD+"','"+WORD+"',"+LEVEL+",'"+TIME+"','"+SENDER+"','"+CHECKER+"','"+ISCHECK+"','"+PERFORMER+"','"+ISPERFORM+"')";
//out.println("\n"+sql);
pb.addBatch(sql);
String RECEIVERs=ds.toString((String)request.getParameter("txt_receiverZGBH"));
RECEIVERs = RECEIVERs.replaceAll(",",";");
String[] receiver=RECEIVERs.split(";");
long id=ds.makeID(Integer.parseInt(person_ID));
for(int i=0;i<receiver.length;i++){
if(receiver[i].equals("")) continue;
id++;
sql="insert into HG2_MEET_SUMMARY_MEN(ID,SUMMARYID,RECEIVER)"
+"values('"+id+"','"+newID+"','"+receiver[i]+"')";
pb.addBatch(sql);
//out.println("\n"+sql);
}
int[] errs = pb.executeBatch(); //執行批處理
if (errs != null) {
err=0;
for(int i=0;i<errs.length;i++){
// out.println(errs[i]+"<br>");
if(errs[i]<0){
err=-1;
break;
}
}
}
if(err == 0) {
pb.commit(); //執行正確完成，數據庫提交
}
else {
pb.rollback(); //執行出錯，操作回滾
}
pb.closeStm();
}//新增操作完成
/*修改操作*/
if(strAction.equals("mod")){
if(strID.equals("")) throw new Exception("頁面參數傳遞錯誤！");
long newID=Long.parseLong(strID);
//把會議紀要內容拷貝到歷史表
pb.closeAutoCommit();//設置非自動提交
pb.createStatement();
pb.clearBatch();
String TITLE=ds.toString((String)request.getParameter("TITLE"));
String KEYWORD=ds.toString((String)request.getParameter("KEYWORD"));
String LEVEL=ds.toString((String)request.getParameter("LEVEL"));
String TIME=ds.toString((String)request.getParameter("TIME"));
String CHECKER=ds.toString((String)request.getParameter("CHECKER"));
String PERFORMER=ds.toString((String)request.getParameter("PERFORMER"));
//把接收人姓名組合成逗號分隔
String sql=new StringBuffer("update HG2_MEET_SUMMARY set ")
.append("TITLE='").append(TITLE)
.append("',KEYWORD='").append(KEYWORD)
.append("',MLEVEL='").append(LEVEL)
.append("',TIME='").append(TIME)
.append("',CHECKER='").append(CHECKER)
.append("',PERFORMER='").append(PERFORMER)
.append("' where ID='").append(strID).append("'").toString();
//out.println("\n"+sql);
pb.addBatch(sql);
pb.addBatch("delete from HG2_MEET_SUMMARY_MEN where SUMMARYID='"+strID+"'");
String RECEIVERs=ds.toString((String)request.getParameter("txt_receiverZGBH"));
RECEIVERs = RECEIVERs.replaceAll(",",";");
String[] receiver=RECEIVERs.split(";");
long id=ds.makeID(Integer.parseInt(person_ID));
for(int i=0;i<receiver.length;i++){
if(receiver[i].equals("")) continue;
id++;
sql="insert into HG2_MEET_SUMMARY_MEN (ID,SUMMARYID,RECEIVER)"
+"values('"+id+"','"+strID+"','"+receiver[i]+"')";
pb.addBatch(sql);
//out.println("\n"+sql);
}
int[] errs = pb.executeBatch(); //執行批處理
if (errs != null) {
err=0;
for(int i=0;i<errs.length;i++){
// out.println(errs[i]+"<br>");
if(errs[i]<0){
err=-1;
break;
}
}
}
if(err == 0) {
pb.commit(); //執行正確完成，數據庫提交
}
else {
pb.rollback(); //執行出錯，操作回滾
}
pb.closeStm();
}//修改操作完成
//審批
if(strAction.equals("check")){
String ISCHECK=ds.toString((String)request.getParameter("ISCHECK"));
String CHECKWORD=ds.toString((String)request.getParameter("CHECKWORD"));
//更新數據庫，設置審批信息、審批時間、審批狀態
String sql = "update HG2_MEET_SUMMARY set CHECKWORD='"
+ CHECKWORD + "',CHECKERTIME='" + ds.getDateTime() + "',ISCHECK="+ISCHECK
+ " where id='" + strId + "'";
pb.executeUpdate(sql);
err=0;
}
//成文
if(strAction.equals("filed")){
//更新數據庫，設置審批信息、審批時間、審批狀態
String sql = "update HG2_MEET_SUMMARY set ISFILED=1"
+ " where id='" + strId + "'";
pb.executeUpdate(sql);
//2005-1-7增加短消息功能
sql = "select RECEIVER from HG2_MEET_SUMMARY_MEN where SUMMARYID = '"+strId+"'";
Vector vectreceiver = (Vector)pb.getDataBySql(sql);
String strReceiver = "";
for(int k=0;k<vectreceiver.size();k++){
Hashtable hashre = (Hashtable)vectreceiver.get(k);
String strtempre = ds.toString((String)hashre.get("RECEIVER"));
if(strReceiver.equals("")&&!strtempre.equals("")) strReceiver += strtempre;
else if(!strReceiver.equals("")&&!strtempre.equals("")) strReceiver += ","+strtempre;
}
/* if(!strReceiver.equals("")){
//添加短消息操作
String strTempTitle = pb.toName("HG2_MEET_SUMMARY","ID","TITLE",strId);
String strTempTime = pb.toName("HG2_MEET_SUMMARY","ID","CHECKERTIME",strId);
Hashtable ht = new Hashtable();
ht.put("receiver",strReceiver);
ht.put("sender",person_ID);
ht.put("title","您有會議紀要,請查收!");
//修改：添加到查看會議的連接
String location = "window.opener.parent.frames[2].location='../oa/meeting/summaryquery/read.jsp?id="+strId+"'";
String look = "<a href=\"# \" onclick=\""+location+"\">[查看紀要]</a>" ;
ht.put("content","會議紀要:"+strTempTitle+",時間:"+strTempTime+">>"+look);
err = smsbean.addSMS(ht);
}
*/
pb.closePstm();
err=0;
}
if(err==0)
out.println("操作完成，正常結束，請稍等片刻...");
else
throw new Exception("數據提交出錯");
%>
<script>
window.location.replace("list.jsp?cur=<%=str_cur%>");
</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 + -