Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @POST
- @Path("updateMember")
- @Produces(MediaType.APPLICATION_JSON)
- public Response updateMember(@QueryParam("name") String name,@QueryParam("phone") String phone,@QueryParam("address") String address,
- @QueryParam("securityQuestion") Integer question,@QueryParam("securityAnswer") String answer,@QueryParam("age") Integer age,
- @QueryParam("income") Integer income,@QueryParam("email") String email) {
- try {
- Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/islandfurniture-it07?zeroDateTimeBehavior=convertToNull&user=root&password=12345");
- String stmt = "UPDATE memberentity SET NAME=?, PHONE=?, ADDRESS=?, SECURITYQUESTION=?, SECURITYANSWER=?, AGE=?, INCOME=? WHERE EMAIL=?";
- PreparedStatement ps = conn.prepareStatement(stmt);
- ps.setString(1, name);
- ps.setString(2, phone);
- ps.setString(3, address);
- ps.setInt(4, question);
- ps.setString(5, answer);
- ps.setInt(6, age);
- ps.setInt(7, income);
- ps.setString(8, email);
- int result = ps.executeUpdate();
- if(result > 0){
- return Response.status(Response.Status.OK).build();
- }
- } catch (Exception ex) {
- ex.printStackTrace();
- }
- return Response.status(Response.Status.BAD_REQUEST).build();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement