package Service;
import dao.Update;
import dao.insert;
import dao.select;
public class AddProduct
{
public void addProduct(String email,String product_name,int amount)
{
int go = new select().checkCart(email,product_name);
if(go == 1)
{
new Update().addNum(product_name,amount,email);
}
else
{
int num = new getNum().getNum();
new insert().AddCart(num,product_name,email,amount);
}
}
}
package Service;
import dao.Update;
import dao.insert;
import dao.select;
public class AddProduct
{
public void addProduct(String email,String product_name,int amount)
{
int go = new select().checkCart(email,product_name);
if(go == 1)
{
new Update().addNum(product_name,amount,email);
}
else
{
int num = new getNum().getNum();
new insert().AddCart(num,product_name,email,amount);
}
}
}
package Service;
import bean.product;
import dao.select;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import static Enum.ProductStatue.available;
import static Enum.ProductStatue.soldOut;
public class Food
{
private ArrayList FoodList = new ArrayList();
public ArrayList getFoodList()
{
ResultSet resultSet = new select().getFood();
try
{
product product;
while(resultSet.next() == true)
{
product = new product();
product.setProduct_name(resultSet.getString("product_name"));
product.setBrand_name(resultSet.getString("brand_name"));
product.setDescription(resultSet.getString("description"));
int amount = Integer.parseInt(resultSet.getString("amount"));
product.setAmount(amount);
product.setPrice(Double.parseDouble(resultSet.getString("price")));
product.setType_name(resultSet.getString("type_name"));
if(amount > 0)
{
product.setStatue(available);
}
else
{
product.setStatue(soldOut);
}
FoodList.add(product);
}
}
catch(SQLException e)
{
e.printStackTrace();
}
return FoodList;
}
}
package Service;
import bean.product;
import dao.select;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import static Enum.ProductStatue.available;
import static Enum.ProductStatue.soldOut;
public class Food
{
private ArrayList FoodList = new ArrayList();
public ArrayList getFoodList()
{
ResultSet resultSet = new select().getFood();
try
{
product product;
while(resultSet.next() == true)
{
product = new product();
product.setProduct_name(resultSet.getString("product_name"));
product.setBrand_name(resultSet.getString("brand_name"));
product.setDescription(resultSet.getString("description"));
int amount = Integer.parseInt(resultSet.getString("amount"));
product.setAmount(amount);
product.setPrice(Double.parseDouble(resultSet.getString("price")));
product.setType_name(resultSet.getString("type_name"));
if(amount > 0)
{
product.setStatue(available);
}
else
{
product.setStatue(soldOut);
}
FoodList.add(product);
}
}
catch(SQLException e)
{
e.printStackTrace();
}
return FoodList;
}
}
package Service;
import bean.product;
import bean.shoppingCart;
import bean.user;
import dao.Mysql;
import dao.select;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.HashMap;
public class GetCart
{
private ResultSet resultSet = null;
public shoppingCart getCart(user user)
{
String sql = "select * from shoppingcart where email =" + "'" + user.getEmail() +"'";
shoppingCart shoppingCart = new GetCart().getShoppingCart(sql);
return shoppingCart;
}
public shoppingCart getShoppingCart(String sql)
{
shoppingCart shoppingCart = new shoppingCart();
HashMap hashMap = new HashMap<product, Integer>();
try
{
resultSet = new select().getStatement().executeQuery(sql);
while(resultSet.next())
{
String product_name = resultSet.getString("product_name");
product product = new select().getProduct(product_name);
Integer amount = Integer.parseInt(resultSet.getString("amount"));
if(product != null)
{
hashMap.put(product,amount);
}
shoppingCart.setCart(hashMap);
}
}
catch (SQLException e)
{
throw new RuntimeException(e);
}
finally
{
Mysql.close();
}
return shoppingCart;
}
}
package Service;
import bean.product;
import bean.shoppingCart;
import bean.user;
import dao.Mysql;
import dao.select;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.HashMap;
public class GetCart
{
private ResultSet resultSet = null;
public shoppingCart getCart(user user)
{
String sql = "select * from shoppingcart where email =" + "'" + user.getEmail() +"'";
shoppingCart shoppingCart = new GetCart().getShoppingCart(sql);
return shoppingCart;
}
public shoppingCart getShoppingCart(String sql)
{
shoppingCart shoppingCart = new shoppingCart();
HashMap hashMap = new HashMap<product, Integer>();
try
{
resultSet = new select().getStatement().executeQuery(sql);
while(resultSet.next())
{
String product_name = resultSet.getString("product_name");
product product = new select().getProduct(product_name);
Integer amount = Integer.parseInt(resultSet.getString("amount"));
if(product != null)
{
hashMap.put(product,amount);
}
shoppingCart.setCart(hashMap);
}
}
catch (SQLException e)
{
throw new RuntimeException(e);
}
finally
{
Mysql.close();
}
return shoppingCart;
}
}
package Service;
import dao.select;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
public class getNum
{
public ArrayList setNum()
{
ArrayList NumList = new ArrayList();
ResultSet resultSet = new select().getCart();
int pro = 0;
try
{
while(resultSet.next())
{
pro = Integer.parseInt(resultSet.getString("num"));
NumList.add(pro);
}
}
catch(SQLException e)
{
e.printStackTrace();
}
return NumList;
}
public int getNum()
{
ArrayList NumList = new getNum().setNum();
int num = 0;
for (int i = 0; i < NumList.size(); i++)
{
num = (Integer) NumList.get(i);
if((Integer) NumList.get(i) > num)
{
num = (Integer) NumList.get(i);
}
}
return (num + 1);
}
}
package Service;
import dao.select;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
public class getNum
{
public ArrayList setNum()
{
ArrayList NumList = new ArrayList();
ResultSet resultSet = new select().getCart();
int pro = 0;
try
{
while(resultSet.next())
{
pro = Integer.parseInt(resultSet.getString("num"));
NumList.add(pro);
}
}
catch(SQLException e)
{
e.printStackTrace();
}
return NumList;
}
public int getNum()
{
ArrayList NumList = new getNum().setNum();
int num = 0;
for (int i = 0; i < NumList.size(); i++)
{
num = (Integer) NumList.get(i);
if((Integer) NumList.get(i) > num)
{
num = (Integer) NumList.get(i);
}
}
return (num + 1);
}
}
package Service;
import dao.select;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
public class Login
{
private ArrayList EmailList = new ArrayList();
private ArrayList UsernameList = new ArrayList();
private ArrayList PasswordList = new ArrayList();
public String UserLogin(String inputEmail,String inputPassword)
{
String Result = null;
try
{
ResultSet resultSet = new select().LoginUser();
l:while(resultSet.next())
{
String email = resultSet.getString("email");
String userPassword = resultSet.getString("Pssword");
String username = resultSet.getString("username");
EmailList.add(email);
PasswordList.add(userPassword);
for (int i = 0; i < EmailList.size(); i++)
{
if(EmailList.get(i).equals(inputEmail))
{
for (int j = 0; j < PasswordList.size(); j++)
{
if (PasswordList.get(j).equals(inputPassword))
{
Result = username;
break l;
}
else
{
Result = null;
}
}
}
else
{
Result = null;
}
}
}
}
catch (SQLException e)
{
e.printStackTrace();
}
return Result;
}
public String ManagerLogin(String inputName,String inputPassword)
{
String Result = null;
try
{
ResultSet resultSet = new select().LoginManager();
l:while(resultSet.next())
{
String username = resultSet.getString("username");
String userPassword = resultSet.getString("pssword");
String email = resultSet.getString("email");
UsernameList.add(username);
PasswordList.add(userPassword);
for (int i = 0; i < UsernameList.size(); i++)
{
if(UsernameList.get(i).equals(inputName))
{
for(int j = 0; j < PasswordList.size(); j++)
{
if(PasswordList.get(j).equals(inputPassword))
{
Result = email;
break l;
}
else
{
Result = null;
}
}
}
else
{
Result = null;
}
}
}
}
catch (SQLException e)
{
e.printStackTrace();
}
return Result;
}
}
package Service;
import dao.select;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
public class Login
{
private ArrayList EmailList = new ArrayList();
private ArrayList UsernameList = new ArrayList();
private ArrayList PasswordList = new ArrayList();
public String UserLogin(String inputEmail,String inputPassword)
{
String Result = null;
try
{
ResultSet resultSet = new select().LoginUser();
l:while(resultSet.next())
{
String email = resultSet.getString("email");
String userPassword = resultSet.getString("Pssword");
String username = resultSet.getString("username");
EmailList.add(email);
PasswordList.add(userPassword);
for (int i = 0; i < EmailList.size(); i++)
{
if(EmailList.get(i).equals(inputEmail))
{
for (int j = 0; j < PasswordList.size(); j++)
{
if (PasswordList.get(j).equals(inputPassword))
{
Result = username;
break l;
}
else
{
Result = null;
}
}
}
else
{
Result = null;
}
}
}
}
catch (SQLException e)
{
e.printStackTrace();
}
return Result;
}
public String ManagerLogin(String inputName,String inputPassword)
{
String Result = null;
try
{
ResultSet resultSet = new select().LoginManager();
l:while(resultSet.next())
{
String username = resultSet.getString("username");
String userPassword = resultSet.getString("pssword");
String email = resultSet.getString("email");
UsernameList.add(username);
PasswordList.add(userPassword);
for (int i = 0; i < UsernameList.size(); i++)
{
if(UsernameList.get(i).equals(inputName))
{
for(int j = 0; j < PasswordList.size(); j++)
{
if(PasswordList.get(j).equals(inputPassword))
{
Result = email;
break l;
}
else
{
Result = null;
}
}
}
else
{
Result = null;
}
}
}
}
catch (SQLException e)
{
e.printStackTrace();
}
return Result;
}
}