JDBC Example

Class.forName("org.postgresql.Driver"); // load database interface // connect to the database conn = DriverManager.getConnection("jdbc:postgresql://localhost:5432/ProductReviews", "postgres", "abcd"); stmt = conn.createStatement(); //st=conn.createStatement(); Date dat = new Date(System.currentTimeMillis()); ResultSet res = stmt.executeQuery( // send the query "select obj_id from object where obj_status_cd='C' and obj_modify_dt >= '18-DEC-10' and obj_modify_dt < '19-DEC-10' order by obj_id"); PreparedStatement pstmt = conn.prepareStatement("insert into event values(?,'C',?)"); if (res != null) while (res.next()) { String id = res.getString(1); //st.executeUpdate("insert into event values("+id+",'C','19-DEC-10')"); //Double d = new Double("2.9"); System.out.println("ID is: "+id); BigDecimal d = new BigDecimal(id); System.out.println("ID in double is: "+d); pstmt.setBigDecimal(1, d); java.sql.Date sqlDate = new java.sql.Date(new java.util.Date(System.currentTimeMillis()).getTime()); pstmt.setDate(2, sqlDate); pstmt.executeUpdate(); System.out.println(id); } res.close(); stmt.close(); pstmt.close(); conn.close();