<%@ 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>