JAVAWEB网上商城项目实现service的业务------JAVA

一时失言乱红尘 2024-03-03 08:58 122阅读 0赞

>     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;
>         }
>     }