<%@ page import="java.sql.*"%>
<%@ page import="java.lang.*,java.util.*,com.csc.library.utilities.CscCalendar"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
</HEAD>
<BODY>
<FORM NAME="cscform" ACTION="#" METHOD="post">
DATABASE <INPUT NAME="databasename" VALUE="<%=request.getParameter("databasename")%>"> <BR>
USER <INPUT NAME="user" VALUE="<%=request.getParameter("user")%>"> <BR>
PASSWORD <INPUT NAME="password" VALUE="<%=request.getParameter("password")%>"><BR>
<INPUT TYPE="SUBMIT" NAME="SAVE" VALUE="CONVERSR">
</FORM>
<%
if(request.getParameter("user")!=null){
try{
String url="jdbc:oracle:thin:@10.226.1.31:1521:"+request.getParameter("databasename");
Class.forName("oracle.jdbc.driver.OracleDriver");
out.println("url : "+url);
String sql="select * from mcomplain";
Properties prop = new Properties();
prop.put("user",request.getParameter("user"));
prop.put("password",request.getParameter("password"));
out.print("START CONVERS<br>");
Connection con = DriverManager.getConnection(url,prop);
Statement stmt = con.createStatement(ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_UPDATABLE);
Statement stmt1 = con.createStatement ();
out.print("<br>Connect = "+con);
String update="";
ResultSet rs = stmt.executeQuery(sql);
int i=1;
CscCalendar cs=null;
cs=new CscCalendar("2007-06-01 00:00:00");
while (rs.next()) {
cs=new CscCalendar(rs.getString("approvedate")+" 00:00:00");
update ="UPDATE MCOMPLAIN SET APPROVETIME="+cs.getTimeInMillis()+" WHERE COMPLAINID='"+rs.getString("complainid")+"'";
stmt1.executeUpdate(update);
out.println("<br>"+(i++)+":"+rs.getString("complainid") + " " +rs.getString("approvedate") +" => "+cs.getTimeInMillis());
}
stmt1.close();
rs.close();
stmt.close();
con.close();
}catch(Exception ex){
ex.printStackTrace();
}
out.print("<br>COMPLETE");
}
%>
</BODY>
</HTML>