Advertisement
Guest User

Untitled

a guest
Dec 31st, 2017
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.44 KB | None | 0 0
  1. @POST
  2.     @Path("updateMember")
  3.     @Produces(MediaType.APPLICATION_JSON)
  4.     public Response updateMember(@QueryParam("name") String name,@QueryParam("phone") String phone,@QueryParam("address") String address,
  5.             @QueryParam("securityQuestion") Integer question,@QueryParam("securityAnswer") String answer,@QueryParam("age") Integer age,
  6.             @QueryParam("income") Integer income,@QueryParam("email") String email) {
  7.         try {
  8.             Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/islandfurniture-it07?zeroDateTimeBehavior=convertToNull&user=root&password=12345");
  9.             String stmt = "UPDATE memberentity SET NAME=?, PHONE=?, ADDRESS=?, SECURITYQUESTION=?, SECURITYANSWER=?, AGE=?, INCOME=? WHERE EMAIL=?";
  10.             PreparedStatement ps = conn.prepareStatement(stmt);
  11.            
  12.             ps.setString(1, name);
  13.             ps.setString(2, phone);
  14.             ps.setString(3, address);
  15.             ps.setInt(4, question);
  16.             ps.setString(5, answer);
  17.             ps.setInt(6, age);
  18.             ps.setInt(7, income);
  19.             ps.setString(8, email);
  20.            int result = ps.executeUpdate();
  21.             if(result > 0){
  22.                 return Response.status(Response.Status.OK).build();
  23.             }
  24.            
  25.         } catch (Exception ex) {
  26.             ex.printStackTrace();
  27.         }
  28.         return Response.status(Response.Status.BAD_REQUEST).build();
  29.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement