public void addProductToDatabase(Product p) throws SQLException {
int number = p.getNumber();
String name = p.getName();
BigDecimal price = p.getUnitPrice();
int quantity = p.getQuantity();
String category = p.getCategory();
String car = p.getCar();
String image = p.getImage();
Statement stmt = con.createStatement();
String sql =
"INSERT INTO APP.PRODUCTS "
+ "VALUES ("
+ number
+ ",'"
+ name
+ "',"
+ quantity
+ ",'"
+ category
+ "','"
+ image
+ "','"
+ car
+ "',"
+ price
+ ")";
stmt.executeUpdate(sql);
}
public void insertSale(Customer c) throws SQLException {
int id = c.getId();
String name = c.getName();
String address = c.getAddress();
String phone = c.getPhoneNumber();
String cardType = c.getCardType();
String cardNumber = c.getCardNumber();
String cardExp = c.getCardExp();
String secCode = c.getSecCode();
String cartDetails = "";
for (Product p : c.getCart().getProductList())
cartDetails += p.getName() + "@" + p.getUnitPrice() + "x" + p.getQuantity() + " ";
BigDecimal cartTotal = c.getCart().getTotal().setScale(2);
Statement stmt = con.createStatement();
String sql =
"INSERT INTO App.SALES VALUES("
+ id
+ ",'"
+ name
+ "','"
+ address
+ "','"
+ phone
+ "','"
+ cardType
+ "','"
+ cardNumber
+ "','"
+ cardExp
+ "','"
+ secCode
+ "','"
+ cartDetails
+ "',"
+ cartTotal
+ ",'"
+ getCurrentTimeStamp()
+ "')";
stmt.executeUpdate(sql);
}
public void removeProductFromDatabase(Product p) throws SQLException {
int number = p.getNumber();
String name = p.getName();
BigDecimal price = p.getUnitPrice();
int quantity = p.getQuantity();
String category = p.getCategory();
String car = p.getCar();
String image = p.getImage();
Statement stmt = con.createStatement();
String sql = "DELETE FROM App.Products WHERE number=" + number;
stmt.executeUpdate(sql);
}
// ---TODO: This feels like a kludge. Find a better way to handle it.
public void respondToEditForm(HttpServletRequest request, HttpSession session) {
String pid = request.getParameter("productid");
if (pid != null) {
try {
int product_id = Integer.parseInt(pid);
Product prod = Product.loadProduct(new Integer(product_id));
if (prod == null) {
Util.noteError(
session, "Internal error: No product with ID " + product_id + " was found.");
} else {
setProduct(prod);
}
} catch (NumberFormatException e) {
Util.noteError(session, "Internal error: Illegal productid: " + pid);
}
}
super.respondToEditForm(request, session);
Debug.println("Version.respondToEditForm: Setting 'record' to " + getProduct());
session.setAttribute("record", getProduct());
}
private void initDefaults() {
setProduct(Product.getPrototype());
}
public AbstractList generateCollection(HttpSession session) {
Product prod = (Product) session.getAttribute("record");
String query = "select * from tbl_version where product = " + prod.getId();
return DatabaseRecord.loadRecords(query, Version.class);
}
/** @see DatabaseRecord#initializeNewRecord */
public void initializeNewRecord(HttpServletRequest request, HttpSession session) {
int product_id = Util.parseInt(Util.getRequiredField(request, session, "productid"), 0);
if (product_id != 0) {
setProduct(Product.loadProduct(new Integer(product_id)));
}
}
private void admitActionPerformed(
java.awt.event.ActionEvent evt) { // GEN-FIRST:event_admitActionPerformed
// String = purchase.getText();
String name = productName.getText();
String id = ProductID.getText();
String desc = descript.getText();
if (desc.isEmpty()) {
desc = "N/A";
}
if (name.length() == 0 || id.length() == 0 || desc.length() == 0) {
JOptionPane.showMessageDialog(null, "Please fill all fields");
} else {
try {
String editS = HomePage.toEdit;
Class.forName("com.mysql.jdbc.Driver");
Connection con =
DriverManager.getConnection("jdbc:mysql://localhost:3306/VunaFeeds", "root", "");
if (editS.equalsIgnoreCase("Null")) {
PreparedStatement psmt =
con.prepareStatement(
"INSERT into product(productID,productName,description) values (?,?,?)");
psmt.setString(1, id);
psmt.setString(2, name);
psmt.setString(3, desc);
PreparedStatement psmt1 =
con.prepareStatement(
"INSERT into new_Stock(productID,Date,units,direction,status,current) values (?,?,?,?,?,?)");
psmt1.setString(1, id);
psmt1.setString(2, dateForDB);
psmt1.setString(3, "0");
psmt1.setString(4, "In");
psmt1.setString(5, "Current");
psmt1.setString(6, "0");
psmt.executeUpdate();
psmt1.executeUpdate();
} else if (editS.equalsIgnoreCase("EditProduct")) {
PreparedStatement psmt =
con.prepareStatement(
"UPDATE product set productname = '"
+ name
+ "' , description = '"
+ desc
+ "' where ProductID = "
+ id
+ "");
psmt.executeUpdate();
}
JOptionPane.showMessageDialog(null, "Product Saved");
this.dispose();
HomePage.toEdit = " ";
Product win = new Product();
win.setVisible(true);
} catch (SQLException e) {
System.out.println("2 Error : " + e);
JOptionPane.showMessageDialog(null, "Oops!! An error occured. \n " + e);
} catch (Exception ex) {
System.out.println("Error 1:" + ex);
JOptionPane.showMessageDialog(null, "Oops!! An error occured. \n" + ex);
}
}
// TODO add your handling code here:
} // GEN-LAST:event_admitActionPerformed