Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package com.itstep.mvn.app.jdbc.dao;
- import java.sql.Connection;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- import java.util.List;
- import com.itstep.mvn.app.model.jdbc.Product;
- import com.itstep.mvn.app.util.DBUtils;
- public class ProductDaoImpl implements ProductDao {
- @Override
- public Product getProduct(String pCode) {
- Connection conn = null;
- Statement stmt = null;
- ResultSet rs = null;
- Product product = null;
- String sql = "SELECT * FROM products WHERE productCode = '" + pCode + "'";
- try {
- conn = DBUtils.getConnection();
- stmt = conn.createStatement();
- rs = stmt.executeQuery(sql);
- if (rs.next()) {
- product.setProductCode(pCode);
- product = new Product();
- product.setBuyPrice(rs.getDouble(8));
- product.setMSRP(rs.getDouble(9));
- product.setProductDescription(rs.getString(6));
- product.setProductLine(rs.getString(3));
- product.setProductName(rs.getString(2));
- product.setProductScale(rs.getString(4));
- product.setProductVendor(rs.getString(5));
- product.setQuantityInStock(rs.getInt(7));
- }else {
- System.out.println("product is not found");
- }
- } catch (SQLException e) {
- e.printStackTrace();
- }
- DBUtils.release(conn, stmt, rs);
- return product;
- }
- @Override
- public boolean addProduct(Product pCode) {
- String sql = "INSERT INTO `products` (`productCode`, `productName`, `productLine`, `productScale`, `productVendor`, `productDescription`, `quantityInStock`, `buyPrice`, `MSRP`) "
- + "VALUES ('"+pCode.getProductCode()+"', '"+pCode.getProductName()+"', '"+pCode.getProductLine()+"', '"+pCode.getProductScale()+"', '"+pCode.getProductVendor()+"', "
- + "'"+pCode.getProductDescription()+"', '"+pCode.getQuantityInStock()+"', '"+pCode.getBuyPrice()+"', '"+pCode.getMSRP()+"'";
- Connection conn = null;
- Statement stmt = null;
- try {
- conn = DBUtils.getConnection();
- stmt = conn.createStatement();
- int result = stmt.executeUpdate(sql);
- if (result == 1) {
- System.out.println("Product '" + pCode.getProductCode() + "' was created.");
- } else {
- throw new RuntimeException("Bad DESIGN!!!");
- }
- } catch (SQLException e) {
- e.printStackTrace();
- } finally {
- DBUtils.release(conn, stmt, null);
- }
- return false;
- }
- @Override
- public boolean editProduct(Product pCode) {
- String sql = "DELETE FROM classicmodel.product WHERE productCode = " + pCode;
- Connection conn = null;
- Statement stmt = null;
- try {
- conn = DBUtils.getConnection();
- stmt = conn.createStatement();
- int res = stmt.executeUpdate(sql);
- } catch (SQLException e) {
- e.printStackTrace();
- } finally {
- DBUtils.release(conn, stmt, null);
- }
- return false;
- }
- @Override
- public boolean removeProduct(String pCode) {
- String sql = "DELETE FROM classicmodel.product WHERE productCode = " + pCode;
- Connection conn = null;
- Statement stmt = null;
- try {
- conn = DBUtils.getConnection();
- stmt = conn.createStatement();
- int res = stmt.executeUpdate(sql);
- if(res == 1 ) {
- System.out.println("Product["+pCode+"] was removed");
- return true;
- } else {
- System.out.println("Product["+pCode+"] not found");
- }
- } catch (SQLException e) {
- e.printStackTrace();
- } finally {
- DBUtils.release(conn, stmt, null);
- }
- return false;
- }
- @Override
- public List<Product> allProduct() {
- // TODO Auto-generated method stub
- return null;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement