Hi everyone
I'm trying to create a small webite for sports products and trying to right up the database in PostgeSQL but I don't know how to connect to it.
Can anyone look at this code and tell me if there's any problems, the name of the PostgreSQL database is postgres and the tables are Product, customer and Cart
Any help you give will be greatly appreciated.
package Website;
import java.io.*;
import java.sql.*;
import javax.naming.*;
import javax.sql.*;
import java.util.*;
import java.sql.Date;
public class SporticusDao
{
//prepared statements
//--------------------------------------------------------------------------
private PreparedStatement profileEdit;
private PreparedStatement register;
private PreparedStatement checkoutOrders;
private PreparedStatement checkoutReports;
private PreparedStatement addToCartStmt;
//resultsets
//--------------------------------------------------------------------------
private ResultSet rsetCheckout;
private ResultSet rsetCheckout1;
private ResultSet rsetCheckout2;
private ResultSet rsetCheckItem;
private ResultSet rsetCheckQty;
private ResultSet rsetreports;
private ResultSet rsetOrders;
private ResultSet rsetProfile;
private ResultSet rsetlogin;
private ResultSet rsetSearch;
private ResultSet rsetAddToCart;
//Customer table.
//--------------------------------------------------------------------------
private String id;
private String name;
private String surname;
private String gender;
private String address1;
private String address2;
private String address3;
private String country;
private String phone;
private String email;
private static String username;//username is static to save it while logged in.
private String password;
private String alerts;
private String preferences;
//orders table
//--------------------------------------------------------------------------
String order_id;
String cust_id;
String prod_id;
String quantity;
String order_date;
String total_price;
//reports table
//--------------------------------------------------------------------------
String ProductID;
String ProductName;
String ProductDesc;
String StockLevel;
String Price;
String NumSold;
//Product table for searching.
//--------------------------------------------------------------------------
String prod_name;
String prod_desc;
String prod_price;
String prod_desc2;
String prod_image;
//checkout and Shopping cart.
//--------------------------------------------------------------------------
private String coutID;
private String coutName;
private String coutCartUsername;
private String coutProdName;
private String coutTotalPrice;
private int cartUserID;
private String coutQuantity;
//set methods for the cart table.
//--------------------------------------------------------------------------
public void setCart_id (String cart_id ) {coutID = cart_id; }
public void setCustomer_id (String Cust_id ) {coutName = Cust_id; }
public void setCartUsername (String coutCartUser) {coutProdName = coutCartUser;}
public void setCartProd_name (String Product_name) {coutProdName = Product_name;}
public void setCartQuantity (String qty ) {coutQuantity = qty; }
public void setCart_price_total (String price ) {coutTotalPrice = price; }
//set methods for the checkout REPORTS table
//--------------------------------------------------------------------------
public void setProductID (String pID ) {ProductID = pID; }
public void setProductName (String pNAME ) {ProductName = pNAME;}
public void setProductDesc (String DESC ) {ProductDesc = DESC; }
public void setStockLevel (String STOCK ) {StockLevel = STOCK; }
public void setPrice (String PRICE ) {Price = PRICE; }
public void setNumSold (String TOTAL ) {NumSold = TOTAL; }
//set methods for the checkout ORDERS table
//--------------------------------------------------------------------------
public void setorder_id (String pID ) {ProductID = pID; }
public void setcust_id (String pNAME ) {ProductName = pNAME;}
public void setprod_id (String DESC ) {ProductDesc = DESC; }
public void setquantity (String STOCK ) {StockLevel = STOCK;}
public void setorder_date (String PRICE ) {Price = PRICE;}
public void settotal_price (String TOTAL ) {NumSold = TOTAL;}
//get methods for the cart table.
//--------------------------------------------------------------------------
public String getCart_id (){return coutID; }
public String getCustomer_id (){return coutName; }
public String getCartUsername (){return coutProdName; }
public String getCartProd_name (){return coutProdName; }
public String getCartQuantity (){return coutQuantity; }
public String getCart_price_total (){return coutTotalPrice;}
//get methods for the REPORTS table.
//--------------------------------------------------------------------------
public String getProductID () {return ProductID; }
public String getProductName () {return ProductName;}
public String getProductDesc () {return ProductDesc;}
public String getStockLevel () {return StockLevel; }
public String getorder_date () {return Price; }
public String gettotal_price () {return NumSold; }
//get methods for the ORDERS table.
//--------------------------------------------------------------------------
public String getorder_id () {return order_id; }
public String getcust_id () {return cust_id; }
public String getprod_id () {return prod_id; }
public String getquantity () {return quantity; }
public String getPrice () {return prod_price;}
public String getNumSold () {return prod_desc2;}
//set methods for the product table.
//--------------------------------------------------------------------------
public void setProd_name (String pname ) {prod_name = pname; }
public void setProd_desc (String pdesc ) {prod_desc = pdesc; }
public void setProd_price(String price ) {prod_price = price; }
public void setProd_desc2(String desc2 ) {prod_desc2 = desc2; }
public void setProd_image(String image ) {prod_image = image; }
//get methods for the product table.
//--------------------------------------------------------------------------
public String getProd_name () {return prod_name; }
public String getProd_desc () {return prod_desc; }
public String getProd_price() {return prod_price;}
public String getProd_desc2() {return prod_desc2;}
public String getProd_image() {return prod_image;}
//set methods for the registration method.
//--------------------------------------------------------------------------
public void setid (String Id) { id = Id; }
public void setname (String name1) { name = name1; }
public void setsurname (String surname1) { surname = surname1; }
public void setgender (String gender1) { gender = gender1; }
public void setaddress1 (String addres1) { address1 = addres1; }
public void setaddress2 (String addres2) { address2 = addres2; }
public void setaddress3 (String addres3) { address3 = addres3; }
public void setcountry (String country1) { country = country1; }
public void setphone (String phone1) { phone = phone1; }
public void setemail (String email1) { email = email1; }
public void setusername (String username1) { username = username1; }
public void setpassword (String password1) { password = password1; }
public void setalerts (String alerts1) { alerts = alerts1; }
public void setpreferences (String preferences1) { preferences = preferences1;}
//get methods for the registration method.
//these methods will get the data entered into the text fields.
//--------------------------------------------------------------------------
public String getid () {return id; }
public String getname () {return name; }
public String getsurname () {return surname; }
public String getgender () {return gender; }
public String getaddress1 () {return address1; }
public String getaddress2 () {return address2; }
public String getaddress3 () {return address3; }
public String getcountry () {return country; }
public String getphone () {return phone; }
public String getemail () {return email; }
public String getusername () {return username; }
public String getpassword () {return password; }
public String getalerts () {return alerts; }
public String getpreferences() {return preferences;}
//view profile methods
//--------------------------------------------------------------------------
public void viewProfile()
{
try
{
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
rsetProfile = stmt.executeQuery("SELECT * FROM Customer WHERE Username = '"+getusername()+"'");
rsetProfile.next();
//methods to get the data from the database table.
setid (rsetProfile.getString(1) );
setname (rsetProfile.getString(2) );
setsurname (rsetProfile.getString(3) );
setgender (rsetProfile.getString(4) );
setaddress1 (rsetProfile.getString(5) );
setaddress2 (rsetProfile.getString(6) );
setaddress3 (rsetProfile.getString(7) );
setcountry (rsetProfile.getString(8) );
setemail (rsetProfile.getString(9) );
setphone (rsetProfile.getString(10));
setusername (rsetProfile.getString(11));
setpassword (rsetProfile.getString(12));
setalerts (rsetProfile.getString(13));
setpreferences (rsetProfile.getString(14));
}
catch (SQLException e)
{
System.out.print("Error Viewing Profile at:");
e.printStackTrace();
}
}
//connection open and close
//------------------------------------------------------------------------------
private Connection con;
public void Connect() throws SQLException, NamingException
{
Context init = new InitialContext();
Context ctx = (Context) init.lookup("java:comp/env");
DataSource ds = (DataSource) ctx.lookup("jdbc/postgres");
con = ds.getConnection();
profileEdit = con.prepareStatement("UPDATE Customer SET First_name = ?,Last_name = ?,Gender = ?,Address1 = ?,Address2 = ?,Address3 = ?,Country = ?,Email = ?,Phone = ?,Cust_password = ?,Newsletter = ?,Prefered_Sport =? where Username =?");
register = con.prepareStatement("INSERT INTO Customer VALUES( Cust_id_SEQUENCE.nextval,?,?,?,?,?,?,?,?,?,?,?,?,?)");
checkoutOrders = con.prepareStatement("INSERT INTO Orders VALUES( Ord_id_SEQUENCE.nextval,?,?,)");
checkoutReports = con.prepareStatement("INSERT INTO Reports VALUES( Rep_id_SEQUENCE.nextval,?,?,)");
}
//method to close the connection.
//------------------------------------------------------------------------------
public void close()
{
try
{
con.close();
}
catch (Exception e)
{
System.out.print("error at database close");
e.printStackTrace();
}
}
//variables used for the log in method.
//------------------------------------------------------------------------------
boolean validpass = false;
//method to log in.
//------------------------------------------------------------------------------
public boolean getbool(){return validpass;}
public void login()
{
String usernameIn;
String passwordIn;
try
{
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
rsetlogin = stmt.executeQuery("SELECT Username,Cust_Password, Prefered_Sport FROM Customer WHERE Username ='"+getusername()+"'");
while(rsetlogin.next())
{
usernameIn = rsetlogin.getString(1);
passwordIn = rsetlogin.getString(2);
setpreferences(rsetlogin.getString(3));
if(usernameIn.equals(getusername()) && passwordIn.equals(getpassword()))
{
validpass = true;
System.out.println("log in success");
setusername(rsetlogin.getString(1));
setpassword(rsetlogin.getString(2)) ;
}
else if(!usernameIn.equals(getusername()) || !passwordIn.equals(getpassword()))
{
System.out.println("log in failure");
validpass = false;
}
}
}
catch (SQLException e)
{
System.out.print("Error at login");
e.printStackTrace();
}
}
//method to search for an item in the database.
//------------------------------------------------------------------------------
public void search()
{
try
{
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
rsetSearch = stmt.executeQuery("SELECT Product_name, Product_price, Product_Desc, Product_Desc2, Product_image FROM Product WHERE Product_name like '%"+prod_name+"%'");
rsetSearch.first();
search_wrap();
}
catch(SQLException e )
{
System.out.println("Error at search item");
e.printStackTrace();
}
}
//fill method used to call when assigning text fields to the data.
//------------------------------------------------------------------------------
public void search_wrap()
{
try
{
setProd_name (rsetSearch.getString(1));
setProd_price(rsetSearch.getString(2));
setProd_desc (rsetSearch.getString(3));
setProd_desc2(rsetSearch.getString(4));
setProd_image(rsetSearch.getString(5));
}
catch (SQLException e)
{
System.out.print("SQL Exception " + e);
}
}
//method to get the Waterpolo item from database.
//------------------------------------------------------------------------------
public ResultSet rsetWaterpolo;
public void Waterpolo()
{
try
{
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
rsetWaterpolo = stmt.executeQuery("SELECT Product_name, Product_price, Product_Desc, Product_Desc2, Product_image FROM Product WHERE Product_name = 'Waterpolo'");
rsetWaterpolo.first();
setProd_name (rsetWaterpolo.getString(1));
setProd_price(rsetWaterpolo.getString(2));
setProd_desc (rsetWaterpolo.getString(3));
setProd_desc2(rsetWaterpolo.getString(4));
setProd_image(rsetWaterpolo.getString(5));
}
catch(SQLException e )
{
System.out.println("Error at Waterpolo");
e.printStackTrace();
}
}
//method to get the snockeler item from database.
//------------------------------------------------------------------------------
public ResultSet rsetsnockeler;
public void snockeler()
{
try
{
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
rsetsnockeler = stmt.executeQuery("SELECT Product_name, Product_price, Product_Desc, Product_Desc2, Product_image FROM Product WHERE Product_name = 'snockeler'");
rsetsnockeler.first();
setProd_name (rsetsnockeler.getString(1));
setProd_price(rsetsnockeler.getString(2));
setProd_desc (rsetsnockeler.getString(3));
setProd_desc2(rsetsnockeler.getString(4));
setProd_image(rsetsnockeler.getString(5));
}
catch(SQLException e )
{
System.out.println("Error at snockeler");
e.printStackTrace();
}
}
//method to get the Wetsuits item from database.
//------------------------------------------------------------------------------
public ResultSet rsetWetsuits;
public void Wetsuits()
{
try
{
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
rsetWetsuits = stmt.executeQuery("SELECT Product_name, Product_price, Product_Desc, Product_Desc2, Product_image FROM Product WHERE Product_name = 'Wetsuits'");
rsetWetsuits.first();
setProd_name (rsetWetsuits.getString(1));
setProd_price(rsetWetsuits.getString(2));
setProd_desc (rsetWetsuits.getString(3));
setProd_desc2(rsetWetsuits.getString(4));
setProd_image(rsetWetsuits.getString(5));
}
catch(SQLException e )
{
System.out.println("Error at Wetsuits");
e.printStackTrace();
}
}
//method to get the RacketOne item from database.
//------------------------------------------------------------------------------
public ResultSet rsetRacketOne;
public void RacketOne()
{
try
{
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
rsetRacketOne = stmt.executeQuery("SELECT Product_name, Product_price, Product_Desc, Product_Desc2, Product_image FROM Product WHERE Product_name = 'RacketOne'");
rsetRacketOne.first();
setProd_name (rsetRacketOne.getString(1));
setProd_price(rsetRacketOne.getString(2));
setProd_desc (rsetRacketOne.getString(3));
setProd_desc2(rsetRacketOne.getString(4));
setProd_image(rsetRacketOne.getString(5));
}
catch(SQLException e )
{
System.out.println("Error at RacketOne");
e.printStackTrace();
}
}
//method to get the RacketTwo item from database.
//------------------------------------------------------------------------------
public ResultSet rsetRacketTwo;
public void RacketTwo()
{
try
{
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
rsetRacketTwo = stmt.executeQuery("SELECT Product_name, Product_price, Product_Desc, Product_Desc2, Product_image FROM Product WHERE Product_name = 'RacketTwo'");
rsetRacketTwo.first();
setProd_name (rsetRacketTwo.getString(1));
setProd_price(rsetRacketTwo.getString(2));
setProd_desc (rsetRacketTwo.getString(3));
setProd_desc2(rsetRacketTwo.getString(4));
setProd_image(rsetRacketTwo.getString(5));
}
catch(SQLException e )
{
System.out.println("Error at RacketTwo");
e.printStackTrace();
}
}
//method to get the RacketThree item from database.
//------------------------------------------------------------------------------
public ResultSet rsetRacketThree;
public void RacketThree()
{
try
{
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
rsetRacketThree = stmt.executeQuery("SELECT Product_name, Product_price, Product_Desc, Product_Desc2, Product_image FROM Product WHERE Product_name = 'RacketThree'");
rsetRacketThree.first();
setProd_name (rsetRacketThree.getString(1));
setProd_price(rsetRacketThree.getString(2));
setProd_desc (rsetRacketThree.getString(3));
setProd_desc2(rsetRacketThree.getString(4));
setProd_image(rsetRacketThree.getString(5));
}
catch(SQLException e )
{
System.out.println("Error at RacketThree");
e.printStackTrace();
}
}
//method to get the AdidasEuro item from database.
//------------------------------------------------------------------------------
public ResultSet rsetAdidasEuro;
public void AdidasEuro()
{
try
{
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
rsetAdidasEuro = stmt.executeQuery("SELECT Product_name, Product_price, Product_Desc, Product_Desc2, Product_image FROM Product WHERE Product_name = 'AdidasEuro'");
rsetAdidasEuro.first();
setProd_name (rsetAdidasEuro.getString(1));
setProd_price(rsetAdidasEuro.getString(2));
setProd_desc (rsetAdidasEuro.getString(3));
setProd_desc2(rsetAdidasEuro.getString(4));
setProd_image(rsetAdidasEuro.getString(5));
}
catch(SQLException e )
{
System.out.println("Error at man AdidasEuro");
e.printStackTrace();
}
}
//method to get the Soccerball item from database.
//------------------------------------------------------------------------------
public ResultSet rsetSoccerball;
public void Soccerball()
{
try
{
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
rsetSoccerball = stmt.executeQuery("SELECT Product_name, Product_price, Product_Desc, Product_Desc2, Product_image FROM Product WHERE Product_name = 'Soccerball'");
rsetSoccerball.first();
setProd_name (rsetSoccerball.getString(1));
setProd_price(rsetSoccerball.getString(2));
setProd_desc (rsetSoccerball.getString(3));
setProd_desc2(rsetSoccerball.getString(4));
setProd_image(rsetSoccerball.getString(5));
}
catch(SQLException e )
{
System.out.println("Error at Soccerball");
e.printStackTrace();
}
}
//method to get the NikeGloves item from database.
//------------------------------------------------------------------------------
public ResultSet rsetNikeGloves;
public void NikeGloves()
{
try
{
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
rsetNikeGloves = stmt.executeQuery("SELECT Product_name, Product_price, Product_Desc, Product_Desc2, Product_image FROM Product WHERE Product_name = 'NikeGloves'");
rsetNikeGloves.first();
setProd_name (rsetNikeGloves.getString(1));
setProd_price(rsetNikeGloves.getString(2));
setProd_desc (rsetNikeGloves.getString(3));
setProd_desc2(rsetNikeGloves.getString(4));
setProd_image(rsetNikeGloves.getString(5));
}
catch(SQLException e )
{
System.out.println("Error at NikeGloves");
e.printStackTrace();
}
}
//method to register the user
//------------------------------------------------------------------------------
public void register()
{
try
{
register.setString(1, getname ());
register.setString(2, getsurname ());
register.setString(3, getgender ());
register.setString(4, getaddress1 ());
register.setString(5, getaddress2 ());
register.setString(6, getaddress3 ());
register.setString(7, getcountry ());
register.setString(8, getemail ());
register.setString(9, getphone ());
register.setString(10,getusername ());
register.setString(11,getpassword ());
register.setString(12,getalerts ());
register.setString(13,getpreferences());
register.executeUpdate();
}
catch (SQLException e)
{
System.out.print("error at registration: ");
e.printStackTrace();
}
}
// editing the members profile.
//------------------------------------------------------------------------------
public void member_edit()
{
try
{
profileEdit.setString(1, getname ());
profileEdit.setString(2, getsurname ());
profileEdit.setString(3, getgender ());
profileEdit.setString(4, getaddress1 ());
profileEdit.setString(5, getaddress2 ());
profileEdit.setString(6, getaddress3 ());
profileEdit.setString(7, getcountry ());
profileEdit.setString(8, getemail ());
profileEdit.setString(9, getphone ());
profileEdit.setString(10,getpassword ());
profileEdit.setString(11,getalerts ());
profileEdit.setString(12,getpreferences());
profileEdit.setString(13,getusername ());
System.out.println("Before update");
profileEdit.executeUpdate();
System.out.println("Update complete");
}
catch (SQLException e)
{
System.out.print("error at update profile");
e.printStackTrace();
}
}
//method to add items to cart.
//--------------------------------------------------------------------------
public void addToCart(String usernameIn,String ProductNameIn,String ProductPriceIn)
{
String username = usernameIn;
String cartProduct = ProductNameIn;
String ProductPrice = ProductPriceIn;
double productPrice = Double.parseDouble(ProductPrice);
String Product_check = "";
int quantity;
int qtyUpdate;
//test that the data is being passed back from web page "ADD TO CART BUTTON".
System.out.println("\n"+username);
System.out.println("\n"+cartProduct);
System.out.println("\n"+ProductPrice);
try
{
/*testing string*/
System.out.println("attempting to get cust_id");
/*testing string*/
if(username != "null")
{
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
rsetAddToCart = stmt.executeQuery("SELECT Cust_id from Customer WHERE username='"+username+"'");
rsetAddToCart.next();
cartUserID = rsetAddToCart.getInt(1);
addToCartStmt = con.prepareStatement("INSERT INTO Cart VALUES(cart_id_SEQUENCE.nextval,'"+cartUserID+"','"+username+"','"+cartProduct+"','"+ProductPrice+"')");
addToCartStmt.executeUpdate();
}
else
{
username = "guest";
cartUserID = rsetAddToCart.getInt(1);
addToCartStmt = con.prepareStatement("INSERT INTO Cart VALUES(cart_id_SEQUENCE.nextval,','1101','"+username+"','"+cartProduct+"','"+ProductPrice+"')");
addToCartStmt.executeUpdate();
}
//verify if another item is in the cart table and just increment the quantity.
/*testing string*/
System.out.println("attempting to get product name");
/*testing string*/
Statement stmt1 = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
rsetCheckItem = stmt1.executeQuery("SELECT Product_name FROM Cart WHERE Product_name = '"+cartProduct+"'");
rsetCheckItem.first();
Product_check = rsetCheckItem.getString(1);
/*testing string*/
System.out.println("before if statement");
/*testing string*/
if(Product_check == cartProduct)
{
/*testing string*/
System.out.println("attepmting to update the quantity");
/*testing string*/
Statement stmt3 = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
rsetCheckQty = stmt3.executeQuery("SELECT quantity FROM Cart WHERE Product_name = '"+cartProduct+"'");
quantity = rsetCheckQty.getInt(1);
qtyUpdate = quantity + 1;
rsetCheckQty = stmt3.executeQuery("UPDATE Cart SET quantity ="+qtyUpdate+" WHERE Product_name = '"+cartProduct+"'");
}
else
{
cartUserID = rsetAddToCart.getInt(1);
addToCartStmt = con.prepareStatement("INSERT INTO Cart VALUES(cart_id_SEQUENCE.nextval,'"+cartUserID+"','"+username+"','"+cartProduct+"','"+ProductPrice+"')");
addToCartStmt.executeUpdate();
}
}
catch (SQLException e)
{
System.out.print("Error at Add to cart: ");
e.printStackTrace();
}
}
//method to checkout
//--------------------------------------------------------------------------
public void checkout()
{
try
{
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
rsetCheckout = stmt.executeQuery("SELECT Username, Product_name, quantity FROM Cart WHERE Username = '"+username+"'");
rsetCheckout.first();
//SQL query to retrieve all the products information based on the products name in the cart table.
Statement stmtProduct = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
rsetCheckout1 = stmtProduct.executeQuery("SELECT Product_name, Product_Desc2, Product_price FROM Product WHERE username = '"+rsetCheckout.getString(2)+"'");
rsetCheckout1.first();
Statement stmtCount = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
rsetCheckout2 = stmtCount.executeQuery("SELECT COUNT(Product_name) FROM Cart WHERE Product_name = '"+rsetCheckout.getString(2)+"'");
System.out.println(getCartProd_name());
System.out.println(getProd_price());
System.out.println(getProd_desc2());
setCart_price_total (rsetCheckout1.getString(5));
}
catch(SQLException e)
{
System.out.println("Error at Checkout: ");
e.printStackTrace();
}
}
public void viewCheckout()
{
try
{
rsetCheckout1.next();
setCartProd_name (rsetCheckout1.getString(1));
setProd_price (rsetCheckout1.getString(2));
setProd_desc2 (rsetCheckout1.getString(3));
setCartQuantity (rsetCheckout1.getString(4));
}
catch(SQLException e)
{
System.out.println("Error at view checkout...");
e.printStackTrace();
}
}
}