<%@ page contentType="text/html; charset=UTF-8"%> <%@ page import="com.csc.library.system.*,com.csc.library.utilities.*,com.csc.library.cscimport.*,java.util.*"%> <%@ page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*" %> <%@ page import="java.sql.*" %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <HTML> <HEAD> <META http-equiv="Content-Type" content="text/html; charset=UTF-8"> <META name="GENERATOR" content="IBM WebSphere Studio"> <META http-equiv="Content-Style-Type" content="text/css"> <LINK href="THEME/MASTER.css" rel="stylesheet" type="text/css"> <TITLE>TEST.jsp</TITLE> </HEAD> <BODY> <% Statement stm = null; CscConnection con = null; out.print("<br>result: start process........"); try { InitialEnvironment en = new InitialEnvironment("GLOBAL"); con = (CscConnection) StaticProperties.myConnection.getConnection(en.getValue("db-name")); con.setAutoCommit(false); con.setClassName("delete"); //String sql="update msalatype1 set posted='2' where posted='1'"; // String sql2="delete from tptime_current1 where dateid>='2010-07-23' and dateid<='2010-08-22' "; stm = con.createStatement(); stm.addBatch("update workflow_data set completion_time='0',wf_status='1' where doc_no='67739'"); stm.addBatch("update actor_parameter set doc_no='66808' where wf_seq_no='67093'"); stm.addBatch("update actor_parameter set doc_no='67298' where wf_seq_no='67583'"); stm.addBatch("update actor_parameter set doc_no='66952' where wf_seq_no='67238'"); stm.addBatch("ALTER TABLE MYHR04.MEMPLOYEE MODIFY( COMPEN_TAXTABLE DEFAULT '02' "+ ", TAXTABLE DEFAULT '01' )"); // stm.addBatch(sql2); stm.executeBatch(); out.print("<br>result: complete........"); con.commit(); }catch (SQLException e) { out.print("<br>result: not complete........"); con.rollback(); e.printStackTrace(); }finally{ try { if(stm!=null) stm.close(); if(con!=null) con.close(); } catch (SQLException e1) { e1.printStackTrace(); } } %> </BODY> </HTML>