Advertisement
Guest User

Untitled

a guest
Apr 29th, 2016
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.96 KB | None | 0 0
  1. Resource
  2. @POST
  3. @Path("/products")
  4. @Consumes(MediaType.APPLICATION_JSON)
  5. @Produces(MediaType.APPLICATION_JSON)
  6. public Products addProducts(Products products) throws ClassNotFoundException, SQLException{
  7. return ps.addProduct(products);
  8. }
  9.  
  10.  
  11.  
  12. Service
  13.  
  14. public Products addProduct(Products product) throws SQLException, ClassNotFoundException{
  15. Class.forName("org.postgresql.Driver");
  16. Connection con=DriverManager.getConnection(url,login,password);
  17. String ins="insert into products values (?,?,?,?,?,?,?)";
  18. PreparedStatement pst=con.prepareStatement(ins);
  19. pst.setInt(1, product.prodid);
  20. pst.setString(2,product.productname);
  21. pst.setDouble(3,product.productprice);
  22. pst.setInt(4,product.productqty);
  23. pst.setString(5,product.productdescription);
  24. pst.setString(6,product.productcategory);
  25. pst.setInt(7,product.productreorder);
  26. pst.executeUpdate();
  27. con.close();
  28. pst.close();
  29.  
  30. return product;
  31. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement