how to run java lambda function in aws

Question

try{ PreparedStatement pst=con.prepareStatement("INSERT INTO employee_details (E_NAME,E_PASSWORD,E_USERNAME,E_CONTACT," + "E_ROLE) VALUES (?,?,?,?,?);"); state=1;

        pst.setString(1,employee.getEname());//Step 7: calling getter() from getter/setter class
    //Step 10: setting getter values to corresponding query
        pst.setString(2,employee.getPass());//Step 7: calling getter() from getter/setter class
            //Step 10: setting getter values to corresponding
        pst.setString(3,employee.getUname());//Step 7: calling getter() from getter/setter class
            //Step 10: setting getter values to corresponding 
        pst.setString(4,employee.getEcontact());//Step 7: calling getter() from getter/setter class
            //Step 10: setting getter values to corresponding 
        pst.setInt(5,employee.getUrole());//Step 7: calling getter() from getter/setter class
            //Step 10: setting getter values to corresponding 
        pst.executeQuery();
        System.out.println("name:"+employee.getEname()+"  pass:"+employee.getPass()+"   uname:"+employee.getUname()+"  con:"+employee.getEcontact()+"  role:"+employee.getUrole());

    }
    catch(SQLException e){
        e.printStackTrace();
    }

not much to to go on. What does your table look like? What data were you trying to insert? — Scary Wombat, Aug 25 '16 at 05:17
might want to move the println to the first line of the try to see if your data is bad — Tibrogargan, Aug 25 '16 at 05:18
Refer Java Doc http://docs.oracle.com/javase/tutorial/jdbc/basics/prepared.html — Unknown, Aug 25 '16 at 05:20

score 0 · Accepted Answer · answered Aug 25 '16 at 05:45

There is an unwanted semi-colon at the end of your prepare statement so remove it.

Try this

 PreparedStatement pst=con.prepareStatement("INSERT INTO employee_details (E_NAME,E_PASSWORD,E_USERNAME,E_CONTACT,"
                + "E_ROLE) VALUES (?,?,?,?,?)");

instead of

 PreparedStatement pst=con.prepareStatement("INSERT INTO employee_details (E_NAME,E_PASSWORD,E_USERNAME,E_CONTACT,"
                + "E_ROLE) VALUES (?,?,?,?,?);");

how to run java lambda function in aws

1 Answers1