Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Resource
- @POST
- @Path("/products")
- @Consumes(MediaType.APPLICATION_JSON)
- @Produces(MediaType.APPLICATION_JSON)
- public Products addProducts(Products products) throws ClassNotFoundException, SQLException{
- return ps.addProduct(products);
- }
- Service
- public Products addProduct(Products product) throws SQLException, ClassNotFoundException{
- Class.forName("org.postgresql.Driver");
- Connection con=DriverManager.getConnection(url,login,password);
- String ins="insert into products values (?,?,?,?,?,?,?)";
- PreparedStatement pst=con.prepareStatement(ins);
- pst.setInt(1, product.prodid);
- pst.setString(2,product.productname);
- pst.setDouble(3,product.productprice);
- pst.setInt(4,product.productqty);
- pst.setString(5,product.productdescription);
- pst.setString(6,product.productcategory);
- pst.setInt(7,product.productreorder);
- pst.executeUpdate();
- con.close();
- pst.close();
- return product;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement