Write to DB

import lrapi.lr;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class Actions
{
    private Connection con;
    private PreparedStatement ps;
    ResultSet rs = null;
    String insertTableSQL = "INSERT INTO ABCD.job_dateReport(sessionid, reportid,measurenumber, measuredate, status)  SELECT 468302271, 5, a.measurenumber, c.measuredate,c.status    FROM ABCD.schedule c, ABCD.job  a WHERE c.measurenumber = a.measurenumber  AND (c.status = 18 OR c.status = 6)  AND a.storetype = 'ST'  AND a.storenumber = 2014234  AND c.measuredate >=TO_DATE('03/20/14','mm/dd/yy')  AND c.measuredate <=TO_DATE('04/19/14','mm/dd/yy')";

    public int init() throws Throwable {
   DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
   con = DriverManager.getConnection("jdbc:oracle:thin:@abc.com:5555:abcd", "abcdtest", "abcdtest");
   return 0;
}//end of init


public int action() throws Throwable {
   ps = con.prepareStatement(insertTableSQL);
//    ps.executeUpdate();
   rs = ps.executeQuery();
   System.out.println("RS: "+rs);

            System.out.println("Record is inserted into DBUSER table!");
return 0;
}//end of action


public int end() throws Throwable {
return 0;
}//end of end
}