devbox
小丑西瓜9
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

鲜花商店 完整代码_鲜花售卖网站代码

作者：小丑西瓜9 | 2024-04-14 02:46:24

赞

踩

鲜花售卖网站代码

 鲜花商店 1

第一关
文件：src/step1/entity/Flower.java

  1. package step1.entity;
  2.  
  3. /**
  4.  * 鲜花顾客实体类
  5.  */
  6. public class FlowerOwner {
  7.     private int id; //顾客标识符
  8.     private String name; //顾客名称
  9.     private String password; //顾客密码
  10.     private double money; //顾客资金
  11.  
  12.     //TODO-2 补全getter/setter方法
  13.  
  14.     public FlowerOwner(){}
  15.     public FlowerOwner(int id, String name, String password, double money) {
  16.         this.id = id;
  17.         this.name = name;
  18.         this.password = password;
  19.         this.money = money;
  20.     }
  21.  
  22.     public int getId() {
  23.         return id;
  24.     }
  25.  
  26.     public void setId(int id) {
  27.         this.id = id;
  28.     }
  29.  
  30.     public String getName() {
  31.         return name;
  32.     }
  33.  
  34.     public void setName(String name) {
  35.         this.name = name;
  36.     }
  37.  
  38.     public String getPassword() {
  39.         return password;
  40.     }
  41.  
  42.     public void setPassword(String password) {
  43.         this.password = password;
  44.     }
  45.  
  46.     public double getMoney() {
  47.         return money;
  48.     }
  49.  
  50.     public void setMoney(double money) {
  51.         this.money = money;
  52.     }
  53. }

 文件：src/step1/entity/FlowerOwner.java

  1. package step1.entity;
  2.  
  3. /**
  4.  * 鲜花实体类
  5.  */
  6. public class Flower {
  7.     private long id; //鲜花标识符
  8.     private String name; //鲜花名称
  9.     private String typeName; //鲜花类别
  10.     private int ownerId; //鲜花所属顾客标识符
  11.     private long storeId; //鲜花所属鲜花商店标识符
  12.     private double price; //鲜花价格
  13.  
  14.     //TODO-1 补齐getter/setter方法
  15.  
  16.     public Flower(){}
  17.     public Flower(long id, String name, String typeName, int ownerId, long storeId, double price) {
  18.         this.id = id;
  19.         this.name = name;
  20.         this.typeName = typeName;
  21.         this.ownerId = ownerId;
  22.         this.storeId = storeId;
  23.         this.price = price;
  24.     }
  25.  
  26.     public long getId() {
  27.         return id;
  28.     }
  29.  
  30.     public void setId(long id) {
  31.         this.id = id;
  32.     }
  33.  
  34.     public String getName() {
  35.         return name;
  36.     }
  37.  
  38.     public void setName(String name) {
  39.         this.name = name;
  40.     }
  41.  
  42.     public String getTypeName() {
  43.         return typeName;
  44.     }
  45.  
  46.     public void setTypeName(String typeName) {
  47.         this.typeName = typeName;
  48.     }
  49.  
  50.     public int getOwnerId() {
  51.         return ownerId;
  52.     }
  53.  
  54.     public void setOwnerId(int ownerId) {
  55.         this.ownerId = ownerId;
  56.     }
  57.  
  58.     public long getStoreId() {
  59.         return storeId;
  60.     }
  61.  
  62.     public void setStoreId(long storeId) {
  63.         this.storeId = storeId;
  64.     }
  65.  
  66.     public double getPrice() {
  67.         return price;
  68.     }
  69.  
  70.     public void setPrice(double price) {
  71.         this.price = price;
  72.     }
  73. }

文件：src/step1/entity/FlowerStore.java 

  1. package step1.entity;
  2.  
  3. /**
  4.  * 鲜花商店实体类
  5.  */
  6. public class FlowerStore {
  7.     private long id; //鲜花商店id
  8.     private String name; //鲜花商店名称
  9.     private String password; //鲜花商店密码
  10.     private double balance; //鲜花商店资金
  11.  
  12.     public FlowerStore(long id, String name, String password, double balance) {
  13.             this.id = id;
  14.             this.name = name;
  15.             this.password = password;
  16.             this.balance = balance;
  17.         }
  18.     public FlowerStore(){};
  19.  
  20.     public long getId() {
  21.         return id;
  22.     }
  23.  
  24.     public void setId(long id) {
  25.         this.id = id;
  26.     }
  27.     public String getName() {
  28.         return name;
  29.     }
  30.  
  31.     public void setName(String name) {
  32.         this.name = name;
  33.     }
  34.  
  35.     //TODO-3 补全name的getter/setter方法
  36.  
  37.     public String getPassword() {
  38.         return password;
  39.     }
  40.  
  41.     public void setPassword(String password) {
  42.         this.password = password;
  43.     }
  44.  
  45.     public double getBalance() {
  46.         return balance;
  47.     }
  48.  
  49.     public void setBalance(double balance) {
  50.         this.balance = balance;
  51.     }
  52. }

第二关

文件：src/step2/dao/impl/FlowerDaoImpl.java

  1. package step2.dao.impl;
  2.  
  3. import java.sql.Connection;
  4. import java.sql.PreparedStatement;
  5. import java.sql.ResultSet;
  6. import java.sql.SQLException;
  7. import java.util.ArrayList;
  8. import java.util.List;
  9.  
  10. import step2.dao.BaseDao;
  11. import step2.dao.FlowerDao;
  12. import step2.entity.Flower;
  13.  
  14. /**
  15.  * 鲜花数据库操作类
  16.  */
  17. public class FlowerDaoImpl extends BaseDao implements FlowerDao {
  18.     private Connection conn = null; // 保存数据库连接
  19.     private PreparedStatement pstmt = null; // 用于执行SQL语句
  20.     private ResultSet rs = null; // 用户保存查询结果集
  21.  
  22.     /**
  23.      * 查询所有鲜花
  24.      */
  25.     @Override
  26.     public List<Flower> getAllFlower() {
  27.         List<Flower> flowerList = new ArrayList<Flower>();
  28.         try {
  29.             conn = getConn();
  30.             pstmt = conn.prepareStatement("SELECT * FROM flower");
  31.             rs = pstmt.executeQuery();
  32.             while(rs.next()){               
  33.                 Flower f = new Flower();
  34.                 f.setId(rs.getLong(1));
  35.                 f.setName(rs.getString(2));
  36.                 f.setTypeName(rs.getString(3));
  37.                 f.setOwnerId(rs.getInt(4));
  38.                 f.setStoreId(rs.getLong(5));
  39.                 f.setPrice(rs.getLong(6));
  40.                 flowerList.add(f);
  41.             }
  42.             //TODO-1 获取所有鲜花
  43.  
  44.         } catch (SQLException e) {
  45.             e.printStackTrace();
  46.         } catch (ClassNotFoundException e) {
  47.             e.printStackTrace();
  48.         } finally {
  49.             super.closeAll(conn, pstmt, rs);
  50.         }
  51.         return flowerList;
  52.     }
  53.  
  54.     /**
  55.      * 根据参数查询相应符合条件鲜花
  56.      */
  57.     @Override
  58.     public List<Flower> selectFlower(String sql, String[] param) {
  59.         List<Flower> flowerList = new ArrayList<Flower>();
  60.         try {
  61.             conn = getConn(); // 得到数据库连接
  62.             pstmt = conn.prepareStatement(sql); // 得到PreparedStatement对象
  63.             if (param != null) {
  64.                 for (int i = 0; i < param.length; i++) {
  65.                     pstmt.setString(i + 1, param[i]); // 为预编译sql设置参数
  66.                 }
  67.             }
  68.             rs = pstmt.executeQuery(); // 执行SQL语句
  69.             while (rs.next()) {
  70.                 Flower flower = new Flower();
  71.                 flower.setId(rs.getInt(1));
  72.                 flower.setName(rs.getString(2));
  73.                 flower.setTypeName(rs.getString(3));
  74.                 flower.setOwnerId(rs.getInt(4));
  75.                 flower.setStoreId(rs.getInt(5));
  76.                 flower.setPrice(rs.getDouble(6));
  77.                 flowerList.add(flower);
  78.             }
  79.         } catch (SQLException e) {
  80.             e.printStackTrace();
  81.         } catch (ClassNotFoundException e) {
  82.             e.printStackTrace();
  83.         } finally {
  84.             super.closeAll(conn, pstmt, rs);
  85.         }
  86.         return flowerList;
  87.     }
  88.  
  89.     /**
  90.      * 更新鲜花信息
  91.      */
  92.     @Override
  93.     public int updateFlower(String sql, Object[] param) {
  94.         int count = super.executeSQL(sql, param);
  95.         return count;
  96.     }
  97. }

 文件：src/step2/dao/impl/FlowerStoreDaoImpl.java

  1. package step2.dao.impl;
  2.  
  3. import java.sql.Connection;
  4. import java.sql.PreparedStatement;
  5. import java.sql.ResultSet;
  6. import java.sql.SQLException;
  7. import java.util.ArrayList;
  8. import java.util.List;
  9.  
  10. import step2.dao.BaseDao;
  11. import step2.dao.FlowerStoreDao;
  12. import step2.entity.FlowerStore;
  13.  
  14.  
  15. public class FlowerStoreDaoImpl extends BaseDao implements FlowerStoreDao {
  16.     private Connection conn = null; // 保存数据库连接
  17.     private PreparedStatement pstmt = null; // 用于执行SQL语句
  18.     private ResultSet rs = null; // 用户保存查询到的鲜花商店结果集
  19.  
  20.     @Override
  21.     public List<FlowerStore> getAllStore() {
  22.         List<FlowerStore> storeList = new ArrayList<FlowerStore>();
  23.         try {
  24.             
  25.             //TODO-2 获取全部鲜花商店
  26.             conn = getConn();
  27.             pstmt = conn.prepareStatement("SELECT * FROM flowerstore");
  28.             rs = pstmt.executeQuery();
  29.             while(rs.next()){
  30.                 FlowerStore f = new FlowerStore();
  31.                 f.setId(rs.getLong(1));
  32.                 f.setName(rs.getString(2));
  33.                 f.setPassword(rs.getString(3));
  34.                 f.setBalance(rs.getDouble(4));
  35.                 
  36.                 storeList.add(f);
  37.             }
  38.  
  39.         } catch (SQLException e) {
  40.             e.printStackTrace();
  41.         } catch (ClassNotFoundException e) {
  42.             e.printStackTrace();
  43.         } finally {
  44.             super.closeAll(conn, pstmt, rs);
  45.         }
  46.         return storeList;
  47.     }
  48.  
  49.     @Override
  50.     public FlowerStore getFlowerStore(String sql, String[] param) {
  51.         FlowerStore flowerStore = null;
  52.         try {
  53.             //TODO-3 根据sql语句获取相应的鲜花商店
  54.             conn = getConn();
  55.             pstmt = conn.prepareStatement(sql);
  56.             for(int i=0;i<param.length;i++){
  57.                 pstmt.setString(i+1,param[i]);
  58.             }
  59.             rs = pstmt.executeQuery();
  60.             flowerStore = new FlowerStore();
  61.             
  62.  
  63.         } catch (SQLException e) {
  64.             e.printStackTrace();
  65.         } catch (ClassNotFoundException e) {
  66.             e.printStackTrace();
  67.         } finally {
  68.             super.closeAll(conn, pstmt, rs);
  69.         }
  70.         return flowerStore;
  71.     }
  72.  
  73.     @Override
  74.     public int updateStore(String sql, Object[] param) {
  75.         int i = 0;
  76.         //TODO-4 修改商店信息
  77.         try {
  78.         conn = getConn();
  79.         pstmt = conn.prepareStatement(sql);
  80.         for(int j=0;i<param.length;i++){
  81.             pstmt.setObject(i+1,param[i]);
  82.         }
  83.         i = pstmt.executeUpdate();
  84.  
  85.         } catch (SQLException e) {
  86.             e.printStackTrace();
  87.         } catch (ClassNotFoundException e) {
  88.             e.printStackTrace();
  89.         } finally {
  90.             super.closeAll(conn, pstmt, rs);
  91.         }
  92.         return i;
  93.             
  94.     }
  95. }

第三关

 文件：src/step3/service/impl/FlowerOwnerServiceImpl.java

  1. package step3.service.impl;
  2.  
  3. import java.text.SimpleDateFormat;
  4. import java.util.ArrayList;
  5. import java.util.Date;
  6. import java.util.List;
  7. import java.util.Scanner;
  8.  
  9. import step3.dao.AccountDao;
  10. import step3.dao.FlowerDao;
  11. import step3.dao.FlowerOwnerDao;
  12. import step3.dao.FlowerStoreDao;
  13. import step3.dao.impl.AccountDaoImpl;
  14. import step3.dao.impl.FlowerDaoImpl;
  15. import step3.dao.impl.FlowerOwnerDaoImpl;
  16. import step3.dao.impl.FlowerStoreDaoImpl;
  17. import step3.entity.Flower;
  18. import step3.entity.FlowerOwner;
  19. import step3.entity.FlowerStore;
  20. import step3.service.FlowerOwnerService;
  21. import step3.service.FlowerStoreService;
  22.  
  23. /**
  24.  * 
  25.  * @author 鲜花顾客实现类
  26.  *
  27.  */
  28. public class FlowerOwnerServiceImpl implements FlowerOwnerService{
  29. 	/**
  30. 	 * 顾客购买库存鲜花，根据用户控制台输入获得到的序号，来实际调用购买库存鲜花或者购买新培育的鲜花
  31. 	 */
  32. 	@Override
  33. 	public void sell(Flower flower) {
  34.         
  35. 	}
  36.  
  37. 	@Override
  38. 	public void FlowerOwnerbuy(Flower flower) {
  39. 	}
  40.  
  41. 	/**
  42. 	 *顾客登录
  43. 	 */
  44. 	@Override
  45. 	public FlowerOwner login() {
  46. 		FlowerOwner owner = new FlowerOwner();
  47. 		if (null != owner) {
  48. 			System.out.println("-------恭喜您成功登录-------");
  49. 			System.out.println("-------您的基本信息：-------");
  50. 			System.out.println("名字：" + owner.getName());
  51. 			System.out.println("资金：" + owner.getMoney());
  52. 		}
  53. 		return owner;
  54. 	}
  55. 	/**
  56. 	 * 
  57. 	 * 根据顾客标识符（id）获得到该顾客所有鲜花信息
  58. 	 */
  59. 	@Override
  60. 	public List<Flower> getMyFlower(int ownerId) {
  61. 		//TODO-1 根据顾客id获得到该顾客所有鲜花信息
  62.         FlowerDaoImpl flowerDao = new FlowerDaoImpl();
  63.         String[] param = {String.valueOf(ownerId)};
  64.         String sql = "select * from flower where owner_id = ?";
  65.         List<Flower> flowerList = flowerDao.selectFlower(sql, param);
  66.         return flowerList;
  67.  
  68. 	}
  69. }

文件：src/step3/service/impl/FlowerStoreServiceImpl.java 

  1. package step3.service.impl;
  2.  
  3. import java.text.SimpleDateFormat;
  4. import java.util.Date;
  5. import java.util.List;
  6. import java.util.Scanner;
  7.  
  8. import step3.dao.AccountDao;
  9. import step3.dao.FlowerDao;
  10. import step3.dao.FlowerOwnerDao;
  11. import step3.dao.FlowerStoreDao;
  12. import step3.dao.impl.AccountDaoImpl;
  13. import step3.dao.impl.FlowerDaoImpl;
  14. import step3.dao.impl.FlowerOwnerDaoImpl;
  15. import step3.dao.impl.FlowerStoreDaoImpl;
  16. import step3.entity.Account;
  17. import step3.entity.Flower;
  18. import step3.entity.FlowerOwner;
  19. import step3.entity.FlowerStore;
  20. import step3.service.FlowerStoreService;
  21.  
  22. /**
  23.  * 鲜花商店实现类
  24.  */
  25. public class FlowerStoreServiceImpl implements FlowerStoreService {
  26.     /**
  27.      * 查询鲜花商店账目 其中的1代表鲜花商店卖给顾客,2代表顾客卖给商店，代表鲜花商店的各种交易
  28.      */
  29.     @Override
  30.     public List<Account> account(long storeId) {
  31.         String sql = "select * from account where deal_type=? and seller_id=? union select * from account where deal_type=? and buyer_id=?";
  32.         String[] param = {"1", String.valueOf(storeId), "2", String.valueOf(storeId)};
  33.         AccountDao accountDao = new AccountDaoImpl();
  34.         List<Account> list = accountDao.getFlowerStoreAccount(sql, param);
  35.         return list;
  36.     }
  37.  
  38.     /**
  39.      * 修改鲜花商店资金信息
  40.      */
  41.     @Override
  42.     public int modifyAccount(Flower flower, FlowerOwner owner) {
  43.         String insertsql = "insert into account(deal_type,flower_id,seller_id,buyer_id,price,deal_time) values (?, ?, ?, ?, ?,?)";
  44.         String date = new SimpleDateFormat("yyyy-MM-dd").format(new Date());
  45.         Object[] accountParam = {1, flower.getId(), flower.getStoreId(), owner.getId(), flower.getPrice(), date};
  46.         AccountDao accountDao = new AccountDaoImpl();
  47.         int insertAccount = accountDao.updateAccount(insertsql, accountParam);
  48.         return insertAccount;
  49.     }
  50.  
  51.     /**
  52.      * 培育鲜花
  53.      */
  54.     @Override
  55.     public Flower bread(String flowerType, FlowerStore store) {
  56.         Scanner input = new Scanner(System.in);
  57.         System.out.println("请输入您期望培育的鲜花名字：");
  58.         String flowerName = input.nextLine();
  59.         System.out.println("请输入您期望的鲜花价格：");
  60.         String flowerprice = input.nextLine();
  61.         String storeId = String.valueOf(store.getId());
  62.         String[] flowerParam = {flowerName, flowerType, storeId, flowerprice};
  63.         FlowerFactoryImpl flowerFactory = new FlowerFactoryImpl();
  64.         Flower flower = flowerFactory.breadNewFlower(flowerParam);
  65.         String sql = "insert into flower(`name`,typeName,store_id,price) values(?,?,?,?)";
  66.         Object[] param = {flower.getName(), flower.getTypeName(),
  67.                 flower.getStoreId(), flower.getPrice()};
  68.         FlowerDao flowerDao = new FlowerDaoImpl();
  69.         int count = flowerDao.updateFlower(sql, param);
  70.         if (count > 0) {
  71.             System.out.println(store.getName() + "成功培育了一种" + flower.getTypeName() + "鲜花");
  72.         }
  73.         return flower;
  74.     }
  75.  
  76.     /**
  77.      * 鲜花商店购买鲜花
  78.      */
  79.     @Override
  80.     public void buy(Flower flower, FlowerStore oldstore) {
  81.         String sql = "select * from flowerStore where id=?";
  82.         String paramStore[] = {String.valueOf(oldstore.getId())};
  83.         FlowerStoreDao storeDao = new FlowerStoreDaoImpl();
  84.         FlowerStore store = storeDao.getFlowerStore(sql, paramStore);
  85.         FlowerOwnerDao ownerDao = new FlowerOwnerDaoImpl();
  86.         sql = "select * from flowerOwner where id = ?";
  87.         String paramOwner[] = {String.valueOf(flower.getOwnerId())};
  88.         FlowerOwner owner = ownerDao.selectOwner(sql, paramOwner);
  89.         int updateFlower = modifyFlower(flower, null, store);// 更新鲜花信息
  90.         if (updateFlower > 0) {// 更新顾客的信息
  91.             int updateOwner = modifyOwner(owner, flower, 1);
  92.             if (updateOwner > 0) {// 更新鲜花商店的信息
  93.                 int updateStore = modifyStore(flower, 1, store);
  94.                 if (updateStore > 0) {// 更新鲜花商店信息
  95.                     int insertAccount = modifyAccount(flower, owner);
  96.                     if (insertAccount > 0) {
  97.                         System.out.println(store.getName() + "已成功购买鲜花:" + flower.getName() + "价格为" + flower.getPrice());
  98.                     }
  99.                 }
  100.             }
  101.         } else {
  102.             System.out.println("修改鲜花信息失败");
  103.         }
  104.     }
  105.  
  106.     /**
  107.      * 商店卖鲜花
  108.      */
  109.     @Override
  110.     public void sell(Flower flower) {
  111.         FlowerDaoImpl FlowerDao = new FlowerDaoImpl();
  112.         FlowerStoreDaoImpl storeDao = new FlowerStoreDaoImpl();
  113.         FlowerOwnerDaoImpl ownerDao = new FlowerOwnerDaoImpl();
  114.         FlowerStoreService FlowerStore = new FlowerStoreServiceImpl();
  115.         String updatesql = "update Flower set store_id = null ,owner_id=? where id=?";
  116.         Object[] param = {flower.getOwnerId(), flower.getId()};
  117.         int updateFlower = FlowerDao.executeSQL(updatesql, param);// 更新鲜花信息
  118.         if (updateFlower > 0) {// 更新顾客的信息
  119.             String ownersql = "select * from Flowerowner where id=?";
  120.             String ownerparam[] = {String.valueOf(flower.getOwnerId())};
  121.  
  122.             FlowerOwner owner = ownerDao.selectOwner(ownersql, ownerparam);
  123.             String updateOwnerSql = "update Flowerowner set money=? where id=?";
  124.             double count = flower.getPrice();
  125.             Object[] ownerParam = {(owner.getMoney() - count), owner.getId()};
  126.             int updateOwner = ownerDao.executeSQL(updateOwnerSql, ownerParam);
  127.             if (updateOwner > 0) {// 更新鲜花商店的信息
  128.                 FlowerStore store = FlowerStore.getFlowerStore(flower.getStoreId());
  129.                 String updateStore = "update Flowerstore set balance=? where id=?";
  130.                 Object[] storeParam = {(store.getBalance() + count),
  131.                         store.getId()};
  132.                 int updatestore = storeDao.executeSQL(updateStore, storeParam);
  133.                 if (updatestore > 0) {// 更新鲜花商店账户的信息
  134.                     String insertsql = "insert into account(deal_type,Flower_id,seller_id,buyer_id,price,deal_time) values (?, ?, ?, ?, ?, ?)";
  135.                     String date = new SimpleDateFormat("yyyy-MM-dd")
  136.                             .format(new Date());
  137.                     Object[] accountParam = {1, flower.getId(), owner.getId(), flower.getStoreId(), count, date};
  138.                     AccountDao accountDao = new AccountDaoImpl();
  139.                     int insertAccount = accountDao.updateAccount(insertsql, accountParam);
  140.                     if (insertAccount > 0) {
  141.                         System.out.println(store.getName() + "已成功卖出价格为" + flower.getPrice() + "的鲜花" + flower.getName());
  142.                     }
  143.                 }
  144.             }
  145.         }
  146.     }
  147.  
  148.     /**
  149.      * 查询出所有库存鲜花
  150.      */
  151.     @Override
  152.     public List<Flower> getFlowersInstock(long storeId) {
  153.         FlowerDao flowerDao = new FlowerDaoImpl();
  154.         String[] param = {String.valueOf(storeId)};
  155.         String sql = "";
  156.         // 当storeId不为0时，要执行查询指定商店库存鲜花
  157.         if (storeId != 0) {
  158.             sql = "select * from flower where owner_id is null and store_id=?";
  159.         }
  160.         // 当storeId为0时，要执行查询所有商店的库存鲜花
  161.         if (0 == storeId) {
  162.             sql = "select * from flower where owner_id is null";
  163.             param = null;
  164.         }
  165.         List<Flower> flowerList = flowerDao.selectFlower(sql, param);
  166.         return flowerList;
  167.     }
  168.  
  169.     /**
  170.      * 查询出所有新培育的鲜花,
  171.      */
  172.     @Override
  173.     public List<Flower> getFlowersBread() {
  174.         FlowerDao FlowerDao = new FlowerDaoImpl();
  175.         String sql = "SELECT * FROM flower WHERE owner_id IS NULL AND typeName NOT IN (?,?,?) AND store_id IS Not NULL";
  176.         String[] flowerParam = {"香槟玫瑰", "白玫瑰", "粉玫瑰"};
  177.         List<Flower> flowerList = FlowerDao.selectFlower(sql, flowerParam);
  178.         return flowerList;
  179.     }
  180.  
  181.     /**
  182.      * 根据顾客信息修改鲜花信息 根据FlowerOwnerEntity和FlowerStoreEntity的值判断是顾客买鲜花或者鲜花商店买鲜花
  183.      * FlowerOwnerEntity=null是鲜花商店买鲜花，FlowerStoreEntity=null是顾客买鲜花
  184.      */
  185.     @Override
  186.     public int modifyFlower(Flower flower, FlowerOwner flowerOwner, FlowerStore store) {
  187.         String updatesql = null;
  188.         long id = 0;
  189.         if (null == store) {
  190.             updatesql = "update flower set owner_id=? where id=?";
  191.             id = flowerOwner.getId();
  192.         } else if (null == flowerOwner) {
  193.             updatesql = "update flower set store_id=?,owner_id=null where id=?";
  194.             id = store.getId();
  195.         }
  196.  
  197.         Object[] param = {id, flower.getId()};
  198.         FlowerDaoImpl flowerDao = new FlowerDaoImpl();
  199.         int updateFlower = flowerDao.executeSQL(updatesql, param);// 更新鲜花信息
  200.  
  201.         return updateFlower;
  202.     }
  203.  
  204.     /**
  205.      * 修改顾客信息 type=0是顾客买鲜花，type=1是鲜花商店买鲜花，价钱的变动
  206.      */
  207.     @Override
  208.     public int modifyOwner(FlowerOwner owner, Flower flower, int type) {
  209.         FlowerOwnerDaoImpl ownerDao = new FlowerOwnerDaoImpl();
  210.         String updateOwnerSql = "update flowerowner set money=? where id=?";
  211.  
  212.         double count = 0;
  213.         if (0 == type) {
  214.             count = (owner.getMoney() - flower.getPrice());
  215.         }
  216.         if (1 == type) {
  217.             count = (owner.getMoney() + flower.getPrice());
  218.         }
  219.         Object[] ownerParam = {count, owner.getId()};
  220.         int updateOwner = ownerDao.executeSQL(updateOwnerSql, ownerParam);
  221.         return updateOwner;
  222.     }
  223.  
  224.     /**
  225.      * 修改鲜花商店信息 type=0是顾客买鲜花，type=1是鲜花商店买鲜花
  226.      */
  227.     @Override
  228.     public int modifyStore(Flower flower, int type, FlowerStore oldstore) {
  229.         FlowerStoreService store = new FlowerStoreServiceImpl();
  230.         FlowerStore flowerStore = store.getFlowerStore(oldstore.getId());
  231.         String updateStore = "update flowerstore set balance=? where id=?";
  232.  
  233.         double count = 0;
  234.         if (0 == type) {
  235.             count = (flowerStore.getBalance() + flower.getPrice());
  236.         }
  237.         if (1 == type) {
  238.             count = (flowerStore.getBalance() - flower.getPrice());
  239.         }
  240.         Object[] storeParam = {count, oldstore.getId()};
  241.         FlowerStoreDaoImpl storeDao = new FlowerStoreDaoImpl();
  242.         int updatestore = storeDao.executeSQL(updateStore, storeParam);
  243.         return updatestore;
  244.     }
  245.  
  246.     /**
  247.      * 鲜花商店登录
  248.      */
  249.     @Override
  250.     public FlowerStore login() {
  251.         Scanner input = new Scanner(System.in);
  252.         FlowerStore flowerStore = null;
  253.         // 1、输入鲜花商店名字
  254.         boolean type = true;
  255.         while (type) {
  256.             System.out.println("请先登录，请输入鲜花商店名字：");
  257.             String storeName = input.nextLine().trim();
  258.             System.out.println("请输入鲜花商店的密码：");
  259.             String storePassword = input.nextLine().trim();
  260.             FlowerStoreDao storeDao = new FlowerStoreDaoImpl();
  261.             String sql = "select * from flowerstore where name=? and password=?";
  262.             String[] param = {storeName, storePassword};
  263.             flowerStore = storeDao.getFlowerStore(sql, param);
  264.             if (null != flowerStore) {
  265.                 System.out.println("-------恭喜成功登录-------");
  266.                 System.out.println("-------鲜花商店的基本信息：-------");
  267.                 System.out.println("名字：" + flowerStore.getName());
  268.                 System.out.println("资金：" + flowerStore.getBalance());
  269.                 type = false;
  270.             } else {
  271.                 System.out.println("登录失败，请确认您的用户名和密码是否正确,重新登录");
  272.                 type = true;
  273.             }
  274.         }
  275.         return flowerStore;
  276.     }
  277.  
  278.     /**
  279.      * 查询出所有鲜花商店正在出售的鲜花
  280.      */
  281.     @Override
  282.     public List<Flower> getFlowerSelling() {
  283.         FlowerDao flowerDao = new FlowerDaoImpl();
  284.         String sql = "select * from flower where owner_id is not null";
  285.         String[] flowerParam = null;
  286.         List<Flower> flowerList = flowerDao.selectFlower(sql, flowerParam);
  287.         return flowerList;
  288.     }
  289.  
  290.     /**
  291.      * 根据鲜花商店标识符查询鲜花商店信息
  292.      */
  293.     @Override
  294.     public FlowerStore getFlowerStore(long id) {
  295.         //TODO-2 根据鲜花商店标识符查询鲜花商店信息方法的实现
  296.         FlowerStoreDao storeDao = new FlowerStoreDaoImpl();
  297.         String sql = "select * from flowerStore where id=?";
  298.         String paramStore[] = {String.valueOf(id)};
  299.         FlowerStore store = storeDao.getFlowerStore(sql, paramStore);
  300.         return store;
  301.  
  302.     }
  303. }

第四关

文件：src/step4/service/impl/FlowerStoreServiceImpl.java

  1. package step4.service.impl;
  2.  
  3. import java.text.SimpleDateFormat;
  4. import java.util.Date;
  5. import java.util.List;
  6. import java.util.Scanner;
  7.  
  8. import step4.dao.*;
  9. import step4.dao.impl.*;
  10. import step4.entity.*;
  11. import step4.service.FlowerStoreService;
  12.  
  13. /**
  14.  * 鲜花商店实现类
  15.  */
  16. public class FlowerStoreServiceImpl implements FlowerStoreService {
  17.  
  18.     /**
  19.      * 查询鲜花商店账目 其中的1代表鲜花商店卖给顾客,2代表顾客卖给商店，代表鲜花商店的各种交易
  20.      */
  21.     @Override
  22.     public List<Account> account(long storeId) {
  23.         String sql = "select * from account where deal_type=? and seller_id=? union select * from account where deal_type=? and buyer_id=?";
  24.         String[] param = {"1", String.valueOf(storeId), "2", String.valueOf(storeId)};
  25.         AccountDao accountDao = new AccountDaoImpl();
  26.         List<Account> list = accountDao.getFlowerStoreAccount(sql, param);
  27.         return list;
  28.     }
  29.  
  30.     /**
  31.      * 修改鲜花商店资金信息
  32.      */
  33.     @Override
  34.     public int modifyAccount(Flower flower, FlowerOwner owner) {
  35.         String insertsql = "insert into account(deal_type,flower_id,seller_id,buyer_id,price,deal_time) values (?, ?, ?, ?, ?,?)";
  36.         String date = new SimpleDateFormat("yyyy-MM-dd").format(new Date());
  37.         Object[] accountParam = {1, flower.getId(), flower.getStoreId(), owner.getId(), flower.getPrice(), date};
  38.         AccountDao accountDao = new AccountDaoImpl();
  39.         int insertAccount = accountDao.updateAccount(insertsql, accountParam);
  40.         return insertAccount;
  41.     }
  42.  
  43.     /**
  44.      * 培育鲜花
  45.      */
  46.     @Override
  47.     public Flower bread(String flowerType, FlowerStore store) {
  48.         Scanner input = new Scanner(System.in);
  49.         System.out.println("请输入您期望培育的鲜花名字：");
  50.         String flowerName = input.nextLine();
  51.         System.out.println("请输入您期望的鲜花价格：");
  52.         String flowerprice = input.nextLine();
  53.         String storeId = String.valueOf(store.getId());
  54.         String[] flowerParam = {flowerName, flowerType, storeId, flowerprice};
  55.         FlowerFactoryImpl flowerFactory = new FlowerFactoryImpl();
  56.         Flower flower = flowerFactory.breadNewFlower(flowerParam);
  57.         String sql = "insert into flower(`name`,typeName,store_id,price) values(?,?,?,?)";
  58.         Object[] param = {flower.getName(), flower.getTypeName(), flower.getStoreId(), flower.getPrice()};
  59.         FlowerDao flowerDao = new FlowerDaoImpl();
  60.         int count = flowerDao.updateFlower(sql, param);
  61.         if (count > 0) {
  62.             System.out.println(store.getName() + "成功培育了一种" + flower.getTypeName() + "鲜花");
  63.         }
  64.         return flower;
  65.     }
  66.  
  67.     /**
  68.      * 鲜花商店购买鲜花
  69.      */
  70.     @Override
  71.     public void buy(Flower flower, FlowerStore oldstore) {
  72.         String sql = "select * from flowerStore where id=?";
  73.         String paramStore[] = {String.valueOf(oldstore.getId())};
  74.         FlowerStoreDao storeDao = new FlowerStoreDaoImpl();
  75.         FlowerStore store = storeDao.getFlowerStore(sql, paramStore);
  76.         FlowerOwnerDao ownerDao = new FlowerOwnerDaoImpl();
  77.         sql = "select * from flowerOwner where id = ?";
  78.         String paramOwner[] = {String.valueOf(flower.getOwnerId())};
  79.         FlowerOwner owner = ownerDao.selectOwner(sql, paramOwner);
  80.         int updateFlower = modifyFlower(flower, null, store);// 更新鲜花信息
  81.         if (updateFlower > 0) {// 更新顾客的信息
  82.             int updateOwner = modifyOwner(owner, flower, 1);
  83.             if (updateOwner > 0) {// 更新鲜花商店的信息
  84.                 int updateStore = modifyStore(flower, 1, store);
  85.                 if (updateStore > 0) {// 更新鲜花商店信息
  86.                     int insertAccount = modifyAccount(flower, owner);
  87.                     if (insertAccount > 0) {
  88.                         System.out.println(store.getName() + "已成功购买鲜花:" + flower.getName() + "价格为" + flower.getPrice());
  89.                     }
  90.                 }
  91.             }
  92.         } else {
  93.             System.out.println("修改鲜花信息失败");
  94.         }
  95.     }
  96.  
  97.     /**
  98.      * 商店卖鲜花
  99.      */
  100.     @Override
  101.     public void sell(Flower flower) {
  102.         FlowerDaoImpl FlowerDao = new FlowerDaoImpl();
  103.         FlowerStoreDaoImpl storeDao = new FlowerStoreDaoImpl();
  104.         FlowerOwnerDaoImpl ownerDao = new FlowerOwnerDaoImpl();
  105.         FlowerStoreService FlowerStore = new FlowerStoreServiceImpl();
  106.         String updatesql = "update Flower set store_id = null ,owner_id=? where id=?";
  107.         Object[] param = {flower.getOwnerId(), flower.getId()};
  108.         int updateFlower = FlowerDao.executeSQL(updatesql, param);// 更新鲜花信息
  109.         if (updateFlower > 0) {// 更新顾客的信息
  110.             String ownersql = "select * from Flowerowner where id=?";
  111.             String ownerparam[] = {String.valueOf(flower.getOwnerId())};
  112.  
  113.             FlowerOwner owner = ownerDao.selectOwner(ownersql, ownerparam);
  114.             String updateOwnerSql = "update Flowerowner set money=? where id=?";
  115.             double count = flower.getPrice();
  116.             Object[] ownerParam = {(owner.getMoney() - count), owner.getId()};
  117.             int updateOwner = ownerDao.executeSQL(updateOwnerSql, ownerParam);
  118.             if (updateOwner > 0) {// 更新鲜花商店的信息
  119.                 FlowerStore store = FlowerStore.getFlowerStore(flower.getStoreId());
  120.                 String updateStore = "update Flowerstore set balance=? where id=?";
  121.                 Object[] storeParam = {(store.getBalance() + count),
  122.                         store.getId()};
  123.                 int updatestore = storeDao.executeSQL(updateStore, storeParam);
  124.                 if (updatestore > 0) {// 更新鲜花商店账户的信息
  125.                     String insertsql = "insert into account(deal_type,Flower_id,seller_id,buyer_id,price,deal_time) values (?, ?, ?, ?, ?, ?)";
  126.                     String date = new SimpleDateFormat("yyyy-MM-dd")
  127.                             .format(new Date());
  128.                     Object[] accountParam = {1, flower.getId(), owner.getId(), flower.getStoreId(), count, date};
  129.                     AccountDao accountDao = new AccountDaoImpl();
  130.                     int insertAccount = accountDao.updateAccount(insertsql, accountParam);
  131.                     if (insertAccount > 0) {
  132.                         System.out.println(store.getName() + "已成功卖出价格为" + flower.getPrice() + "的鲜花" + flower.getName());
  133.                     }
  134.                 }
  135.             }
  136.         }
  137.     }
  138.  
  139.     /**
  140.      * 查询出所有库存鲜花
  141.      */
  142.     @Override
  143.     public List<Flower> getFlowersInstock(long storeId) {
  144.         FlowerDao flowerDao = new FlowerDaoImpl();
  145.         String[] param = {String.valueOf(storeId)};
  146.         String sql = "";
  147.         // 当storeId不为0时，要执行查询指定商店库存鲜花
  148.         if (storeId != 0) {
  149.             sql = "select * from flower where owner_id is null and store_id=?";
  150.         }
  151.         // 当storeId为0时，要执行查询所有商店的库存鲜花
  152.         if (0 == storeId) {
  153.             sql = "select * from flower where owner_id is null";
  154.             param = null;
  155.         }
  156.         List<Flower> flowerList = flowerDao.selectFlower(sql, param);
  157.         return flowerList;
  158.     }
  159.  
  160.     /**
  161.      * 查询出所有新培育的鲜花,
  162.      */
  163.     @Override
  164.     public List<Flower> getFlowersBread() {
  165.         FlowerDao FlowerDao = new FlowerDaoImpl();
  166.         String sql = "SELECT * FROM flower WHERE owner_id IS NULL AND typeName NOT IN (?,?,?) AND store_id IS Not NULL";
  167.         String[] flowerParam = {"香槟玫瑰", "白玫瑰", "粉玫瑰"};
  168.         List<Flower> flowerList = FlowerDao.selectFlower(sql, flowerParam);
  169.         return flowerList;
  170.     }
  171.  
  172.  
  173.     /**
  174.      * 根据顾客信息修改鲜花信息 根据FlowerOwnerEntity和FlowerStoreEntity的值判断是顾客买鲜花或者鲜花商店买鲜花
  175.      * FlowerOwnerEntity=null是鲜花商店买鲜花，FlowerStoreEntity=null是顾客买鲜花
  176.      */
  177.     @Override
  178.     public int modifyFlower(Flower flower, FlowerOwner flowerOwner, FlowerStore store) {
  179.         String updatesql = null;
  180.         long id = 0;
  181.         if (null == store) {
  182.             updatesql = "update flower set owner_id=? where id=?";
  183.             id = flowerOwner.getId();
  184.         } else if (null == flowerOwner) {
  185.             updatesql = "update flower set store_id=?,owner_id=null where id=?";
  186.             id = store.getId();
  187.         }
  188.  
  189.         Object[] param = {id, flower.getId()};
  190.         FlowerDaoImpl flowerDao = new FlowerDaoImpl();
  191.         int updateFlower = flowerDao.executeSQL(updatesql, param);// 更新鲜花信息
  192.  
  193.         return updateFlower;
  194.     }
  195.  
  196.     /**
  197.      * 修改顾客信息 type=0是顾客买鲜花，type=1是鲜花商店买鲜花，价钱的变动
  198.      */
  199.     @Override
  200.     public int modifyOwner(FlowerOwner owner, Flower flower, int type) {
  201.         FlowerOwnerDaoImpl ownerDao = new FlowerOwnerDaoImpl();
  202.         String updateOwnerSql = "update flowerowner set money=? where id=?";
  203.  
  204.         double count = 0;
  205.         if (0 == type) {
  206.             count = (owner.getMoney() - flower.getPrice());
  207.         }
  208.         if (1 == type) {
  209.             count = (owner.getMoney() + flower.getPrice());
  210.         }
  211.         Object[] ownerParam = {count, owner.getId()};
  212.         int updateOwner = ownerDao.executeSQL(updateOwnerSql, ownerParam);
  213.         return updateOwner;
  214.     }
  215.  
  216.  
  217.     /**
  218.      * 修改鲜花商店信息 type=0是顾客买鲜花，type=1是鲜花商店买鲜花
  219.      */
  220.     @Override
  221.     public int modifyStore(Flower flower, int type, FlowerStore oldstore) {
  222.         FlowerStoreService store = new FlowerStoreServiceImpl();
  223.         FlowerStore flowerStore = store.getFlowerStore(oldstore.getId());
  224.         String updateStore = "update flowerstore set balance=? where id=?";
  225.  
  226.         double count = 0;
  227.         if (0 == type) {
  228.             count = (flowerStore.getBalance() + flower.getPrice());
  229.         }
  230.         if (1 == type) {
  231.             count = (flowerStore.getBalance() - flower.getPrice());
  232.         }
  233.         Object[] storeParam = {count, oldstore.getId()};
  234.         FlowerStoreDaoImpl storeDao = new FlowerStoreDaoImpl();
  235.         int updatestore = storeDao.executeSQL(updateStore, storeParam);
  236.         return updatestore;
  237.     }
  238.  
  239.     /**
  240.      * 鲜花商店登录
  241.      *
  242.      * @param storeName
  243.      * @param storePassword
  244.      * @return
  245.      */
  246.     @Override
  247.     public FlowerStore login(String storeName, String storePassword) {
  248.         FlowerStore flowerStore;
  249.         FlowerStoreDao storeDao = new FlowerStoreDaoImpl();
  250.         //TODO-2 鲜花商店登录（访问数据库，查询鲜花商店名称和密码是否正确）
  251.         String sql = "select * from flowerStore where name=? and password=?";
  252.         String paramStore[] = {String.valueOf(storeName),String.valueOf(storePassword)};
  253.         flowerStore = storeDao.getFlowerStore(sql, paramStore);
  254.         
  255.         return flowerStore;
  256.     }
  257.  
  258.     /**
  259.      * 查询出所有鲜花商店正在出售的鲜花
  260.      */
  261.     @Override
  262.     public List<Flower> getFlowerSelling() {
  263.         FlowerDao flowerDao = new FlowerDaoImpl();
  264.         String sql = "select * from flower where owner_id is not null";
  265.         String[] flowerParam = null;
  266.         List<Flower> flowerList = flowerDao.selectFlower(sql, flowerParam);
  267.         return flowerList;
  268.     }
  269.  
  270.     /**
  271.      * 根据鲜花商店标识符查询鲜花信息
  272.      */
  273.     @Override
  274.     public FlowerStore getFlowerStore(long id) {
  275.         String sql = "select * from flowerstore where id=" + id;
  276.         FlowerStoreDao storeDao = new FlowerStoreDaoImpl();
  277.         FlowerStore flowerStore = storeDao.getFlowerStore(sql, null);
  278.         return flowerStore;
  279.     }
  280. }

 文件：src/step4/test/FlowerStoreApp.java

  1. package step4.test;
  2.  
  3. import dbtest.InitDB;
  4. import step4.entity.*;
  5. import step4.dao.*;
  6. import step4.dao.impl.*;
  7. import step4.service.*;
  8. import step4.service.impl.*;
  9.  
  10. import java.util.ArrayList;
  11. import java.util.List;
  12. import java.util.Scanner;
  13.  
  14. public class FlowerStoreApp {
  15.     private static Scanner input = new Scanner(System.in);
  16.  
  17.     public static void main(String[] args) {
  18.         //1-初始化 NySQL 数据库
  19.         InitDB db = new InitDB();
  20.         //2-启动鲜花商店系统
  21.         startFlowerShop();
  22.     }
  23.  
  24.     private static void startFlowerShop() {
  25.         System.out.println("----------------------鲜花商店启动-----------------");
  26.         System.out.println("鲜花信息");
  27.         System.out.println("****************************************************");
  28.         FlowerDao flowerDao = new FlowerDaoImpl();
  29.         List<Flower> flowerList = flowerDao.getAllFlower();
  30.         System.out.println("序号\t" + "鲜花名称\t" + "鲜花品种\t" + "鲜花售价\t" + "");
  31.         for (int i = 0; i < flowerList.size(); i++) {
  32.             Flower flower = flowerList.get(i);
  33.             System.out.println((i + 1) + "\t" + flower.getName() + "\t" + flower.getTypeName() + "\t" + flower.getPrice() + "\t");
  34.         }
  35.         System.out.println("****************************************************");
  36.         System.out.print("\n");
  37.         System.out.println("顾客信息");
  38.         FlowerOwnerDao ownerDao = new FlowerOwnerDaoImpl();
  39.         List<FlowerOwner> ownerList = ownerDao.getAllOwner();
  40.         System.out.println("****************************************************");
  41.         System.out.println("序号\t" + "顾客姓名\t");
  42.         for (int i = 0; i < ownerList.size(); i++) {
  43.             FlowerOwner owner = ownerList.get(i);
  44.             System.out.println((i + 1) + "\t" + owner.getName() + "\t");
  45.         }
  46.         System.out.println("****************************************************");
  47.         System.out.print("\n");
  48.         System.out.println("鲜花商店信息");
  49.         System.out.println("****************************************************");
  50.         FlowerStoreDao storeDao = new FlowerStoreDaoImpl();
  51.         List<FlowerStore> storeList = storeDao.getAllStore();
  52.         System.out.println("序号\t" + "鲜花商店名称\t");
  53.         for (int i = 0; i < storeList.size(); i++) {
  54.             FlowerStore store = storeList.get(i);
  55.             System.out.println((i + 1) + "\t" + store.getName() + "\t");
  56.         }
  57.         System.out.println("****************************************************");
  58.         System.out.print("\n");
  59.         //系统登录
  60.         FlowerStore flowerStore = storeLogin();
  61.     }
  62.  
  63.     //鲜花商店登录
  64.     private static FlowerStore storeLogin() {
  65.         // Scanner input = new Scanner(System.in);
  66.         FlowerStoreService fsService = new FlowerStoreServiceImpl();
  67.         FlowerStore flowerStore = null;
  68.         //TODO-1 鲜花商店登录代码实现（允许多次输入商店名称和密码）
  69.         while(true){
  70.             System.out.println("请先登录，请输入鲜花商店名字：");
  71.             String n = input.next();
  72.             System.out.println("请输入鲜花商店的密码：");
  73.             String p = input.next();
  74.             flowerStore = fsService.login(n,p);
  75.             if(flowerStore==null){
  76.                 System.out.println("登录失败，请确认您的用户名和密码是否正确,重新登录");
  77.                 continue;
  78.             }
  79.             break;
  80.         }
  81.         System.out.println("-------恭喜成功登录-------");
  82.         System.out.println("-------鲜花商店的基本信息：-------");
  83.         System.out.printf("名字：%s\n资金：%.1f\n",flowerStore.getName(),flowerStore.getBalance());
  84.  
  85.         System.out.println("您已登录成功，可以进行如下操作");
  86.         StoreChoose(flowerStore);
  87.  
  88.         return flowerStore;
  89.     }
  90.  
  91.     //创建鲜花商店
  92.     private static FlowerStore createFlowerStore(FlowerStore store) {
  93.         FlowerStoreFactory storeFactory = new FlowerStoreFactoryImpl();
  94.         storeFactory.createFlowerStore();
  95.         IsStoreLogOut(store);
  96.  
  97.         return store;//返回的是鲜花商店创建者
  98.     }
  99.  
  100.     private static void IsStoreLogOut(FlowerStore store) {
  101.         System.out.println("您是否继续其它操作若是请输入y,退出请按任意键");
  102.         //Scanner input = new Scanner(System.in);
  103.         String code = input.next();
  104.         if (code.equals("y")) {
  105.             StoreChoose(store);
  106.         } else {
  107.             System.out.println("您已成功退出系统");
  108.         }
  109.     }
  110.  
  111.     private static void StoreChoose(FlowerStore store) {
  112.         System.out.println("1：购买鲜花");
  113.         System.out.println("2：卖出鲜花");
  114.         System.out.println("3：培育鲜花");
  115.         System.out.println("4：查询待售鲜花");
  116.         System.out.println("5：查看商店结余");
  117.         System.out.println("6：查看商店账目");
  118.         System.out.println("7：开鲜花商店");
  119.         System.out.println("请根据需要执行的操作，选择序号输入，退出请输入0");
  120.         // Scanner input = new Scanner(System.in);
  121.         boolean type = true;
  122.         while (type) {
  123.  
  124.             int num = input.nextInt();
  125.             switch (num) {
  126.                 case 0:
  127.                     System.out.println("退出成功");
  128.                     type = false;
  129.                     break;
  130.                 case 1:
  131.                     storeBuy(store);
  132.                     type = false;
  133.                     break;
  134.                 case 2:
  135.                     storeSell(store);
  136.                     type = false;
  137.                     break;
  138.                 case 3:
  139.                     storeBread(store);//传入登录的商店
  140.                     type = false;
  141.                     break;
  142.                 case 4:
  143.                     queryFlowerStock(store.getId());
  144.                     type = false;
  145.                     break;
  146.                 case 5:
  147.                     queryStoreBalance(store);
  148.                     type = false;
  149.                     break;
  150.                 case 6:
  151.                     getAccount(store.getId());
  152.                     type = false;
  153.                     break;
  154.                 case 7:
  155.                     createFlowerStore(store);
  156.                     type = false;
  157.                     break;
  158.                 default:
  159.                     System.out.println("输入有误,请重新输入");
  160.                     type = true;
  161.                     break;
  162.             }
  163.         }
  164.     }
  165.  
  166.  
  167.     //获得鲜花商店的资金1代表商店顾客，2顾客卖给商店，3代表顾客之间的交易
  168.     private static FlowerStore getAccount(long id) {
  169.         FlowerStoreService storeService = new FlowerStoreServiceImpl();
  170.         FlowerStore store = storeService.getFlowerStore(id);
  171.         List<Account> list = storeService.account(id);
  172.         for (int i = 0; i < list.size(); i++) {
  173.             Account account = list.get(i);
  174.             String type = null;
  175.             if (1 == account.getDealType()) {
  176.                 type = "商店卖给顾客";
  177.             } else if (2 == account.getDealType()) {
  178.                 type = "顾客卖给商店";
  179.             } else {
  180.                 type = "顾客之间交易";
  181.             }
  182.             System.out.println("第" + (i + 1) + "笔交易,交易类型为：" + type + "，交易金额是:"
  183.                     + account.getPrice());
  184.         }
  185.         IsStoreLogOut(store);
  186.         return store;
  187.     }
  188.  
  189.     //查询商店余额
  190.     private static FlowerStore queryStoreBalance(FlowerStore store) {
  191.         double balance = store.getBalance();
  192.         System.out.println(store.getName() + "鲜花商店的结余为:" + balance);
  193.         IsStoreLogOut(store);
  194.         return store;
  195.     }
  196.  
  197.     //查询待售鲜花
  198.     private static FlowerStore queryFlowerStock(long storeId) {
  199.         FlowerStoreService flowerStoreService = new FlowerStoreServiceImpl();
  200.         FlowerStore store = flowerStoreService.getFlowerStore(storeId);
  201.         Flower flower = null;
  202.         List<Flower> flowerList = flowerStoreService.getFlowersInstock(storeId);
  203.         System.out.println("序号\t" + "鲜花名称\t" + "鲜花类型\t" + "鲜花价格\t");
  204.         for (int i = 0; i < flowerList.size(); i++) {
  205.             flower = flowerList.get(i);
  206.             System.out.println((i + 1) + "\t" + flower.getName() + "\t" + flower.getTypeName() + "\t" + flower.getPrice() + "\t");
  207.         }
  208.         IsStoreLogOut(store);
  209.         return store;
  210.     }
  211.  
  212.     //鲜花商店培育鲜花
  213.     private static FlowerStore storeBread(FlowerStore store) {
  214.         FlowerStoreService flowerStore = new FlowerStoreServiceImpl();
  215.         //Scanner input = new Scanner(System.in);
  216.         System.out.println("请输入要培育鲜花的品种(例如:玫瑰))");
  217.         String flowerType = input.next();
  218.         flowerStore.bread(flowerType, store);
  219.         IsStoreLogOut(store);
  220.         return store;
  221.     }
  222.  
  223.     //以商店的身份登录，商店向顾客出售鲜花
  224.     private static void storeSell(FlowerStore store) {
  225.         //Scanner input = new Scanner(System.in);
  226.         FlowerStoreService flowerStore = new FlowerStoreServiceImpl();
  227.         Flower flower = null;
  228.         List<Flower> flowerList = flowerStore.getFlowersInstock(store.getId());
  229.         System.out.println("-------以下是鲜花商店正在出售的鲜花-------");
  230.         System.out.println("序号\t" + "鲜花名称\t" + "鲜花类型\t" + "鲜花价格\t");
  231.         for (int i = 0; i < flowerList.size(); i++) {
  232.             flower = flowerList.get(i);
  233.             System.out.println((i + 1) + "\t" + flower.getName() + "\t" + flower.getTypeName() + "\t" + flower.getPrice() + "\t");
  234.         }
  235.         System.out.println("---------请选择要购买的鲜花序号--------");
  236.         boolean type = true;
  237.         while (type) {
  238.             int num = input.nextInt();
  239.             if ((num - 1) < flowerList.size() && (num - 1) >= 0) {
  240.                 flower = flowerList.get(num - 1);
  241.                 System.out.println("------要卖出的鲜花信息如下------");
  242.                 System.out.println("鲜花名称为：" + flower.getName() + " 鲜花类别是：" + flower.getTypeName() + "鲜花价格是:" + flower.getPrice());
  243.                 System.out.println("请确认是否卖出，y代表卖出，n代表不卖");
  244.                 String code = input.next();
  245.                 if (null != code) {
  246.                     if ("y".equals(code)) {
  247.                         System.out.println("------下面是现有顾客买家，请选择您要卖给买家序号------");
  248.                         List<FlowerOwner> ownerList = new ArrayList<FlowerOwner>();
  249.                         FlowerOwnerDao ownerDao = new FlowerOwnerDaoImpl();
  250.                         ownerList = ownerDao.getAllOwner();
  251.                         FlowerOwner flowerOwner = null;
  252.                         System.out.println("序号\t" + "顾客姓名\t");
  253.                         for (int i = 0; i < ownerList.size(); i++) {
  254.                             flowerOwner = ownerList.get(i);
  255.                             System.out.println((i + 1) + "\t" + flowerOwner.getName() + "\t");
  256.                         }
  257.                         num = input.nextInt();
  258.                         if ((num - 1) < ownerList.size() && (num - 1) >= 0) {
  259.                             flowerOwner = ownerList.get(num - 1);
  260.                         }
  261.                         flower.setOwnerId(flowerOwner.getId());
  262.                         flowerStore.sell(flower);
  263.                     } else if ("n".equals(code)) {
  264.                         System.out
  265.                                 .println("--------您选择放弃本次交易，希望您再次光顾----------");
  266.  
  267.                     } else {
  268.                         System.out.println("--------您的输入有误----------");
  269.                     }
  270.                 }
  271.                 type = true;
  272.             } else {
  273.                 System.out.println("输入有误，请按照序号重新输入");
  274.                 type = false;
  275.             }
  276.             type = false;// 标识符更改为false，退出系统
  277.         }
  278.         IsStoreLogOut(store);
  279.     }
  280.  
  281.     //以商店的身份登录，商店找顾客购买鲜花
  282.     private static void storeBuy(FlowerStore store) {
  283.         //Scanner input = new Scanner(System.in);
  284.         FlowerStoreService flowerStore = new FlowerStoreServiceImpl();
  285.         Flower flower = null;
  286.         List<Flower> flowerList = flowerStore.getFlowerSelling();
  287.         System.out.println("-------以下是顾客正在出售的鲜花-------");
  288.         System.out.println("序号\t" + "鲜花名称\t" + "鲜花类型\t" + "鲜花价格\t");
  289.         for (int i = 0; i < flowerList.size(); i++) {
  290.             flower = flowerList.get(i);
  291.             System.out.println((i + 1) + "\t" + flower.getName() + "\t" + flower.getTypeName() + "\t" + flower.getPrice() + "\t");
  292.         }
  293.         System.out.println("-------请选择要购买哪一种鲜花，并输入选择项的序号-------");
  294.         int num = input.nextInt();
  295.         flower = flowerList.get(num - 1);
  296.         //System.out.println("选中的鲜花信息"+flower.getName()+"id"+flower.getId());
  297.         flowerStore.buy(flower, store);
  298.         IsStoreLogOut(store);
  299.     }
  300.  
  301.     //顾客登录
  302.     private static FlowerOwner ownerLogin() {
  303.         //Scanner input = new Scanner(System.in);
  304.         System.out.println("请先登录，请您输入姓名：");
  305.         String ownerName = input.nextLine().trim();
  306.         System.out.println("请您输入密码：");
  307.         String ownerPassword = input.nextLine().trim();
  308.         FlowerOwnerService flowerOwner = new FlowerOwnerServiceImpl();
  309.         FlowerOwner Owner = flowerOwner.login(ownerName, ownerPassword);
  310.         boolean reg = true;
  311.         while (reg) {
  312.             if (null == Owner) {
  313.                 System.out.println("登录失败，请确认您的用户名和密码后重新输入");
  314.                 System.out.println("请先登录，请您输入姓名：");
  315.                 ownerName = input.nextLine().trim();
  316.                 System.out.println("请您输入密码：");
  317.                 ownerPassword = input.nextLine().trim();
  318.                 Owner = flowerOwner.login(ownerName, ownerPassword);
  319.                 reg = true;
  320.             } else {
  321.                 reg = false;
  322.                 System.out.println("登录成功，您可以购买和卖出鲜花，如果您想购买鲜花请输入1，如果想卖出鲜花请输入2");
  323.                 System.out.println("1：购买鲜花");
  324.                 System.out.println("2：卖出鲜花");
  325.                 boolean type = true;
  326.                 //----------------------
  327.                 FlowerCirculate(type, Owner);
  328.             }
  329.         }
  330.         return Owner;
  331.     }
  332.  
  333.     private static boolean FlowerCirculate(boolean type, FlowerOwner owner) {
  334.         while (type) {
  335.             int num = input.nextInt();
  336.             if (1 == num) {
  337.                 ownerBuy(owner);
  338.                 type = false;
  339.             } else if (2 == num) {
  340.                 ownerSell(owner);
  341.                 type = false;
  342.             } else {
  343.                 System.out.println("输入有误,请重新输入");
  344.                 type = true;
  345.             }
  346.         }
  347.         return type;
  348.     }
  349.  
  350.     //顾客向商店卖鲜花
  351.     private static void ownerSell(FlowerOwner flowerowner) {
  352.     }
  353.  
  354.     //顾客找鲜花商店买鲜花
  355.     private static void ownerBuy(FlowerOwner flowerowner) {
  356.     }
  357. }

鲜花商店 2

第一关：

 文件：src/step5/service/impl/FlowerStoreServiceImpl.java

  1. package step5.service.impl;
  2.  
  3. import step5.dao.AccountDao;
  4. import step5.dao.FlowerDao;
  5. import step5.dao.FlowerOwnerDao;
  6. import step5.dao.FlowerStoreDao;
  7. import step5.dao.impl.AccountDaoImpl;
  8. import step5.dao.impl.FlowerDaoImpl;
  9. import step5.dao.impl.FlowerOwnerDaoImpl;
  10. import step5.dao.impl.FlowerStoreDaoImpl;
  11. import step5.entity.Account;
  12. import step5.entity.Flower;
  13. import step5.entity.FlowerOwner;
  14. import step5.entity.FlowerStore;
  15. import step5.service.FlowerStoreService;
  16.  
  17. import java.text.SimpleDateFormat;
  18. import java.util.Date;
  19. import java.util.List;
  20. import java.util.Scanner;
  21.  
  22. /**
  23.  * 鲜花商店实现类
  24.  */
  25. public class FlowerStoreServiceImpl implements FlowerStoreService {
  26.     /**
  27.      * 查询鲜花商店账目 其中的1代表鲜花商店卖给顾客,2代表顾客卖给商店，代表鲜花商店的各种交易
  28.      */
  29.     @Override
  30.     public List<Account> account(long storeId) {
  31.         String sql = "select * from account where deal_type=? and seller_id=? union select * from account where deal_type=? and buyer_id=?";
  32.         String[] param = {"1", String.valueOf(storeId), "2", String.valueOf(storeId)};
  33.         AccountDao accountDao = new AccountDaoImpl();
  34.         List<Account> list = accountDao.getFlowerStoreAccount(sql, param);
  35.         return list;
  36.     }
  37.  
  38.     /**
  39.      * 修改鲜花商店资金信息
  40.      */
  41.     @Override
  42.     public int modifyAccount(Flower flower, FlowerOwner owner) {
  43.         String insertsql = "insert into account(deal_type,flower_id,seller_id,buyer_id,price,deal_time) values (?, ?, ?, ?, ?,?)";
  44.         String date = new SimpleDateFormat("yyyy-MM-dd").format(new Date());
  45.         Object[] accountParam = {1, flower.getId(), flower.getStoreId(), owner.getId(), flower.getPrice(), date};
  46.         AccountDao accountDao = new AccountDaoImpl();
  47.         int insertAccount = accountDao.updateAccount(insertsql, accountParam);
  48.         return insertAccount;
  49.     }
  50.  
  51.     /**
  52.      * 培育鲜花
  53.      */
  54.     @Override
  55.     public Flower bread(String flowerType, FlowerStore store) {
  56.         Scanner input = new Scanner(System.in);
  57.         System.out.println("请输入您期望培育的鲜花名字：");
  58.         String flowerName = input.nextLine();
  59.         System.out.println("请输入您期望的鲜花价格：");
  60.         String flowerprice = input.nextLine();
  61.         String storeId = String.valueOf(store.getId());
  62.         String[] flowerParam = {flowerName, flowerType, storeId, flowerprice};
  63.         FlowerFactoryImpl flowerFactory = new FlowerFactoryImpl();
  64.         Flower flower = flowerFactory.breadNewFlower(flowerParam);
  65.         String sql = "insert into flower(`name`,typeName,store_id,price) values(?,?,?,?)";
  66.         Object[] param = {flower.getName(), flower.getTypeName(), flower.getStoreId(), flower.getPrice()};
  67.         FlowerDao flowerDao = new FlowerDaoImpl();
  68.         int count = flowerDao.updateFlower(sql, param);
  69.         if (count > 0) {
  70.             System.out.println(store.getName() + "成功培育了一种" + flower.getTypeName() + "鲜花");
  71.         }
  72.         return flower;
  73.     }
  74.  
  75.     /**
  76.      * 鲜花商店购买鲜花
  77.      */
  78.     @Override
  79.     public void buy(Flower flower, FlowerStore oldstore) {
  80.         String sql = "select * from flowerStore where id=?";
  81.         String paramStore[] = {String.valueOf(oldstore.getId())};
  82.         FlowerStoreDao storeDao = new FlowerStoreDaoImpl();
  83.         FlowerStore store = storeDao.getFlowerStore(sql, paramStore);
  84.         FlowerOwnerDao ownerDao = new FlowerOwnerDaoImpl();
  85.         sql = "select * from flowerOwner where id = ?";
  86.         String paramOwner[] = {String.valueOf(flower.getOwnerId())};
  87.         FlowerOwner owner = ownerDao.selectOwner(sql, paramOwner);
  88.         int updateFlower = modifyFlower(flower, null, store);// 更新鲜花信息
  89.         if (updateFlower > 0) {// 更新顾客的信息
  90.             int updateOwner = modifyOwner(owner, flower, 1);
  91.             if (updateOwner > 0) {// 更新鲜花商店的信息
  92.                 int updateStore = modifyStore(flower, 1, store);
  93.                 if (updateStore > 0) {// 更新鲜花商店信息
  94.                     int insertAccount = modifyAccount(flower, owner);
  95.                     if (insertAccount > 0) {
  96.                         System.out.println(store.getName() + "已成功购买鲜花:" + flower.getName() + "价格为" + flower.getPrice());
  97.                     }
  98.                 }
  99.             }
  100.         } else {
  101.             System.out.println("修改鲜花信息失败");
  102.         }
  103.     }
  104.  
  105.     /**
  106.      * 商店卖鲜花
  107.      */
  108.     @Override
  109.     public void sell(Flower flower) {
  110.         FlowerDaoImpl FlowerDao = new FlowerDaoImpl();
  111.         FlowerStoreDaoImpl storeDao = new FlowerStoreDaoImpl();
  112.         FlowerOwnerDaoImpl ownerDao = new FlowerOwnerDaoImpl();
  113.         FlowerStoreService FlowerStore = new FlowerStoreServiceImpl();
  114.         String updatesql = "update Flower set store_id = null ,owner_id=? where id=?";
  115.         Object[] param = {flower.getOwnerId(), flower.getId()};
  116.         int updateFlower = FlowerDao.executeSQL(updatesql, param);// 更新鲜花信息
  117.         if (updateFlower > 0) {// 更新顾客的信息
  118.             String ownersql = "select * from Flowerowner where id=?";
  119.             String ownerparam[] = {String.valueOf(flower.getOwnerId())};
  120.  
  121.             FlowerOwner owner = ownerDao.selectOwner(ownersql, ownerparam);
  122.             String updateOwnerSql = "update Flowerowner set money=? where id=?";
  123.             double count = flower.getPrice();
  124.             Object[] ownerParam = {(owner.getMoney() - count), owner.getId()};
  125.             int updateOwner = ownerDao.executeSQL(updateOwnerSql, ownerParam);
  126.             if (updateOwner > 0) {// 更新鲜花商店的信息
  127.                 FlowerStore store = FlowerStore.getFlowerStore(flower.getStoreId());
  128.                 String updateStore = "update Flowerstore set balance=? where id=?";
  129.                 Object[] storeParam = {(store.getBalance() + count),
  130.                         store.getId()};
  131.                 int updatestore = storeDao.executeSQL(updateStore, storeParam);
  132.                 if (updatestore > 0) {// 更新鲜花商店账户的信息
  133.                     String insertsql = "insert into account(deal_type,Flower_id,seller_id,buyer_id,price,deal_time) values (?, ?, ?, ?, ?, ?)";
  134.                     String date = new SimpleDateFormat("yyyy-MM-dd")
  135.                             .format(new Date());
  136.                     Object[] accountParam = {1, flower.getId(), owner.getId(), flower.getStoreId(), count, date};
  137.                     AccountDao accountDao = new AccountDaoImpl();
  138.                     int insertAccount = accountDao.updateAccount(insertsql, accountParam);
  139.                     if (insertAccount > 0) {
  140.                         System.out.println(store.getName() + "已成功卖出价格为" + flower.getPrice() + "的鲜花" + flower.getName());
  141.                     }
  142.                 }
  143.             }
  144.         }
  145.     }
  146.  
  147.     /**
  148.      * 查询出所有库存鲜花
  149.      */
  150.     @Override
  151.     public List<Flower> getFlowersInstock(long storeId) {
  152.         FlowerDao flowerDao = new FlowerDaoImpl();
  153.         String[] param = {String.valueOf(storeId)};
  154.         String sql = "";
  155.         // 当storeId不为 0 时，要执行查询指定商店库存鲜花
  156.         if (storeId != 0) {
  157.         // if (storeId != 1) {
  158.             //TODO-2 填写查询指定商店库存鲜花SQL语句( sql="xxx"; )
  159.             sql = "select * from Flower where store_id != ? and owner_id is not null";
  160.  
  161.         }
  162.         // 当storeId为0时，要执行查询所有商店的库存鲜花
  163.         if (0 == storeId) {
  164.             //TODO-3 填写查询所有商店库存鲜花SQL语句( sql="xxx"; )
  165.             // sql = "select * from Flower";
  166.             sql = "select * from Flower where store_id <> 0 and owner_id is null";
  167.             
  168.             param = null;
  169.         }
  170.         List<Flower> flowerList = flowerDao.selectFlower(sql, param);
  171.         return flowerList;
  172.     }
  173.  
  174.     /**
  175.      * 查询出所有新培育的鲜花,
  176.      */
  177.     @Override
  178.     public List<Flower> getFlowersBread() {
  179.         FlowerDao FlowerDao = new FlowerDaoImpl();
  180.         String sql = "SELECT * FROM flower WHERE owner_id IS NULL AND typeName NOT IN (?,?,?) AND store_id IS Not NULL";
  181.         String[] flowerParam = {"香槟玫瑰", "白玫瑰", "粉玫瑰"};
  182.         List<Flower> flowerList = FlowerDao.selectFlower(sql, flowerParam);
  183.         return flowerList;
  184.     }
  185.  
  186.  
  187.     /**
  188.      * 根据顾客信息修改鲜花信息 根据FlowerOwnerEntity和FlowerStoreEntity的值判断是顾客买鲜花或者鲜花商店买鲜花
  189.      * FlowerOwnerEntity=null是鲜花商店买鲜花，FlowerStoreEntity=null是顾客买鲜花
  190.      */
  191.     @Override
  192.     public int modifyFlower(Flower flower, FlowerOwner flowerOwner, FlowerStore store) {
  193.         String updatesql = null;
  194.         long id = 0;
  195.         if (null == store) {
  196.             updatesql = "update flower set owner_id=? where id=?";
  197.             id = flowerOwner.getId();
  198.         } else if (null == flowerOwner) {
  199.             updatesql = "update flower set store_id=?,owner_id=null where id=?";
  200.             id = store.getId();
  201.         }
  202.  
  203.         Object[] param = {id, flower.getId()};
  204.         FlowerDaoImpl flowerDao = new FlowerDaoImpl();
  205.         int updateFlower = flowerDao.executeSQL(updatesql, param);// 更新鲜花信息
  206.  
  207.         return updateFlower;
  208.     }
  209.  
  210.     /**
  211.      * 修改顾客信息 type=0是顾客买鲜花，type=1是鲜花商店买鲜花，价钱的变动
  212.      */
  213.     @Override
  214.     public int modifyOwner(FlowerOwner owner, Flower flower, int type) {
  215.         FlowerOwnerDaoImpl ownerDao = new FlowerOwnerDaoImpl();
  216.         String updateOwnerSql = "update flowerowner set money=? where id=?";
  217.  
  218.         double count = 0;
  219.         if (0 == type) {
  220.             count = (owner.getMoney() - flower.getPrice());
  221.         }
  222.         if (1 == type) {
  223.             count = (owner.getMoney() + flower.getPrice());
  224.         }
  225.         Object[] ownerParam = {count, owner.getId()};
  226.         int updateOwner = ownerDao.executeSQL(updateOwnerSql, ownerParam);
  227.         return updateOwner;
  228.     }
  229.  
  230.  
  231.     /**
  232.      * 修改鲜花商店信息 type=0是顾客买鲜花，type=1是鲜花商店买鲜花
  233.      */
  234.     @Override
  235.     public int modifyStore(Flower flower, int type, FlowerStore oldstore) {
  236.         FlowerStoreService store = new FlowerStoreServiceImpl();
  237.         FlowerStore flowerStore = store.getFlowerStore(oldstore.getId());
  238.         String updateStore = "update flowerstore set balance=? where id=?";
  239.  
  240.         double count = 0;
  241.         if (0 == type) {
  242.             count = (flowerStore.getBalance() + flower.getPrice());
  243.         }
  244.         if (1 == type) {
  245.             count = (flowerStore.getBalance() - flower.getPrice());
  246.         }
  247.         Object[] storeParam = {count, oldstore.getId()};
  248.         FlowerStoreDaoImpl storeDao = new FlowerStoreDaoImpl();
  249.         int updatestore = storeDao.executeSQL(updateStore, storeParam);
  250.         return updatestore;
  251.     }
  252.  
  253.     /**
  254.      * 鲜花商店登录
  255.      *
  256.      * @param storeName
  257.      * @param storePassword
  258.      * @return
  259.      */
  260.     @Override
  261.     public FlowerStore login(String storeName, String storePassword) {
  262.         FlowerStore flowerStore;
  263.         FlowerStoreDao storeDao = new FlowerStoreDaoImpl();
  264.         String sql = "select * from flowerstore where name=? and password=?";
  265.         String[] param = {storeName, storePassword};
  266.         flowerStore = storeDao.getFlowerStore(sql, param);
  267.         return flowerStore;
  268.  
  269.     }
  270.  
  271.     /**
  272.      * 查询出所有鲜花商店正在出售的鲜花
  273.      */
  274.     @Override
  275.     public List<Flower> getFlowerSelling() {
  276.         FlowerDao flowerDao = new FlowerDaoImpl();
  277.         String sql = "select * from flower where owner_id is not null";
  278.         String[] flowerParam = null;
  279.         List<Flower> flowerList = flowerDao.selectFlower(sql, flowerParam);
  280.         return flowerList;
  281.     }
  282.  
  283.     /**
  284.      * 根据鲜花商店标识符查询鲜花信息
  285.      */
  286.     @Override
  287.     public FlowerStore getFlowerStore(long id) {
  288.         String sql = "select * from flowerstore where id=" + id;
  289.         FlowerStoreDao storeDao = new FlowerStoreDaoImpl();
  290.         FlowerStore flowerStore = storeDao.getFlowerStore(sql, null);
  291.         return flowerStore;
  292.     }
  293. }

文件：src/step5/test/FlowerStoreApp.java

  1. package step5.test;
  2.  
  3. import dbtest.InitDB;
  4. import step5.dao.*;
  5. import step5.dao.impl.*;
  6. import step5.entity.*;
  7. import step5.service.*;
  8. import step5.service.impl.*;
  9.  
  10. import java.util.ArrayList;
  11. import java.util.List;
  12. import java.util.Scanner;
  13.  
  14. public class FlowerStoreApp {
  15.     private static Scanner input = new Scanner(System.in);
  16.  
  17.     public static void main(String[] args) {
  18.         //1-初始化 NySQL 数据库
  19.         InitDB db = new InitDB();
  20.         //2-启动鲜花商店系统
  21.         startFlowerShop();
  22.     }
  23.  
  24.     private static void startFlowerShop() {
  25.         System.out.println("----------------------鲜花商店启动-----------------");
  26.         System.out.println("鲜花信息");
  27.         System.out.println("****************************************************");
  28.         FlowerDao flowerDao = new FlowerDaoImpl();
  29.         List<Flower> flowerList = flowerDao.getAllFlower();
  30.         System.out.println("序号\t" + "鲜花名称\t" + "鲜花品种\t" + "鲜花售价\t" + "");
  31.         for (int i = 0; i < flowerList.size(); i++) {
  32.             Flower flower = flowerList.get(i);
  33.             System.out.println((i + 1) + "\t" + flower.getName() + "\t" + flower.getTypeName() + "\t" + flower.getPrice() + "\t");
  34.         }
  35.         System.out.println("****************************************************");
  36.         System.out.print("\n");
  37.         System.out.println("顾客信息");
  38.         FlowerOwnerDao ownerDao = new FlowerOwnerDaoImpl();
  39.         List<FlowerOwner> ownerList = ownerDao.getAllOwner();
  40.         System.out.println("****************************************************");
  41.         System.out.println("序号\t" + "顾客姓名\t");
  42.         for (int i = 0; i < ownerList.size(); i++) {
  43.             FlowerOwner owner = ownerList.get(i);
  44.             System.out.println((i + 1) + "\t" + owner.getName() + "\t");
  45.         }
  46.         System.out.println("****************************************************");
  47.         System.out.print("\n");
  48.         System.out.println("鲜花商店信息");
  49.         System.out.println("****************************************************");
  50.         FlowerStoreDao storeDao = new FlowerStoreDaoImpl();
  51.         List<FlowerStore> storeList = storeDao.getAllStore();
  52.         System.out.println("序号\t" + "鲜花商店名称\t");
  53.         for (int i = 0; i < storeList.size(); i++) {
  54.             FlowerStore store = storeList.get(i);
  55.             System.out.println((i + 1) + "\t" + store.getName() + "\t");
  56.         }
  57.         System.out.println("****************************************************");
  58.         System.out.print("\n");
  59.         //系统登录
  60.         System.out.println("请选择输入登录模式，输入1为顾客登录，输入2为鲜花商店登录");
  61.         boolean type = true;
  62.         String num;
  63.         while (type) {
  64.             num = input.nextLine();
  65.             if ("1".equals(num)) {
  66.                 ownerLogin();
  67.                 type = false;
  68.             } else if ("2".equals(num)) {
  69.                 storeLogin();
  70.                 type = false;
  71.             } else {
  72.                 System.out.println("输入有误，请按照指定规则输入");
  73.                 System.out.println("请选择登录模式，输入1为顾客登录，输入2为鲜花商店登录");
  74.                 type = true;
  75.             }
  76.         }
  77.     }
  78.  
  79.     //鲜花商店登录
  80.     private static FlowerStore storeLogin() {
  81.         FlowerStoreService fsService = new FlowerStoreServiceImpl();
  82.         FlowerStore flowerStore = null;
  83.         //TODO-1 鲜花商店登录代码实现
  84.         boolean type = true;
  85.         while (type) {
  86.             System.out.println("请先登录，请输入鲜花商店名字：");
  87.             String storeName = input.nextLine().trim();
  88.             System.out.println("请输入鲜花商店的密码：");
  89.             String storePassword = input.nextLine().trim();
  90.             flowerStore = fsService.login(storeName, storePassword);
  91.             if (null != flowerStore) {
  92.                 System.out.println("-------恭喜成功登录-------");
  93.                 System.out.println("-------鲜花商店的基本信息：-------");
  94.                 System.out.println("名字：" + flowerStore.getName());
  95.                 System.out.println("资金：" + flowerStore.getBalance());
  96.                 type = false;
  97.             } else {
  98.                 System.out.println("登录失败，请确认您的用户名和密码是否正确,重新登录");
  99.                 type = true;
  100.             }
  101.         }
  102.  
  103.         System.out.println("您已登录成功，可以进行如下操作");
  104.         StoreChoose(flowerStore);
  105.  
  106.         return flowerStore;
  107.     }
  108.  
  109.     //创建鲜花商店
  110.     private static FlowerStore createFlowerStore(FlowerStore store) {
  111.         FlowerStoreFactory storeFactory = new FlowerStoreFactoryImpl();
  112.         storeFactory.createFlowerStore();
  113.         IsStoreLogOut(store);
  114.  
  115.         return store;//返回的是鲜花商店创建者
  116.     }
  117.  
  118.     private static void IsStoreLogOut(FlowerStore store) {
  119.         System.out.println("您是否继续其它操作若是请输入y,退出请按任意键");
  120.         String code = input.next();
  121.         if (code.equals("y")) {
  122.             StoreChoose(store);
  123.         } else {
  124.             System.out.println("您已成功退出系统");
  125.         }
  126.     }
  127.  
  128.     private static void StoreChoose(FlowerStore store) {
  129.         System.out.println("1：购买鲜花");
  130.         System.out.println("2：卖出鲜花");
  131.         System.out.println("3：培育鲜花");
  132.         System.out.println("4：查询待售鲜花");
  133.         System.out.println("5：查看商店结余");
  134.         System.out.println("6：查看商店账目");
  135.         System.out.println("7：开鲜花商店");
  136.         System.out.println("请根据需要执行的操作，选择序号输入，退出请输入0");
  137.         boolean type = true;
  138.         while (type) {
  139.             int num = input.nextInt();
  140.             switch (num) {
  141.                 case 0:
  142.                     System.out.println("退出成功");
  143.                     type = false;
  144.                     break;
  145.                 case 1:
  146.                     storeBuy(store);
  147.                     type = false;
  148.                     break;
  149.                 case 2:
  150.                     storeSell(store);
  151.                     type = false;
  152.                     break;
  153.                 case 3:
  154.                     storeBread(store);//传入登录的商店
  155.                     type = false;
  156.                     break;
  157.                 case 4:
  158.                     queryFlowerStock(store.getId());
  159.                     type = false;
  160.                     break;
  161.                 case 5:
  162.                     queryStoreBalance(store);
  163.                     type = false;
  164.                     break;
  165.                 case 6:
  166.                     getAccount(store.getId());
  167.                     type = false;
  168.                     break;
  169.                 case 7:
  170.                     createFlowerStore(store);
  171.                     type = false;
  172.                     break;
  173.                 default:
  174.                     System.out.println("输入有误,请重新输入");
  175.                     type = true;
  176.                     break;
  177.             }
  178.         }
  179.     }
  180.  
  181.  
  182.     //获得鲜花商店的资金1代表商店顾客，2顾客卖给商店，3代表顾客之间的交易
  183.     private static FlowerStore getAccount(long id) {
  184.         FlowerStoreService storeService = new FlowerStoreServiceImpl();
  185.         FlowerStore store = storeService.getFlowerStore(id);
  186.         List<Account> list = storeService.account(id);
  187.         for (int i = 0; i < list.size(); i++) {
  188.             Account account = list.get(i);
  189.             String type = null;
  190.             if (1 == account.getDealType()) {
  191.                 type = "商店卖给顾客";
  192.             } else if (2 == account.getDealType()) {
  193.                 type = "顾客卖给商店";
  194.             } else {
  195.                 type = "顾客之间交易";
  196.             }
  197.             System.out.println("第" + (i + 1) + "笔交易,交易类型为：" + type + "，交易金额是:"
  198.                     + account.getPrice());
  199.         }
  200.         IsStoreLogOut(store);
  201.         return store;
  202.     }
  203.  
  204.     //查询商店余额
  205.     private static FlowerStore queryStoreBalance(FlowerStore store) {
  206.         double balance = store.getBalance();
  207.         System.out.println(store.getName() + "鲜花商店的结余为:" + balance);
  208.         IsStoreLogOut(store);
  209.         return store;
  210.     }
  211.  
  212.     //查询待售鲜花
  213.     private static FlowerStore queryFlowerStock(long storeId) {
  214.         FlowerStoreService flowerStoreService = new FlowerStoreServiceImpl();
  215.         FlowerStore store = flowerStoreService.getFlowerStore(storeId);
  216.         Flower flower = null;
  217.         List<Flower> flowerList = flowerStoreService.getFlowersInstock(storeId);
  218.         System.out.println("序号\t" + "鲜花名称\t" + "鲜花类型\t" + "鲜花价格\t");
  219.         for (int i = 0; i < flowerList.size(); i++) {
  220.             flower = flowerList.get(i);
  221.             System.out.println((i + 1) + "\t" + flower.getName() + "\t" + flower.getTypeName() + "\t" + flower.getPrice() + "\t");
  222.         }
  223.         IsStoreLogOut(store);
  224.         return store;
  225.     }
  226.  
  227.     //鲜花商店培育鲜花
  228.     private static FlowerStore storeBread(FlowerStore store) {
  229.         FlowerStoreService flowerStore = new FlowerStoreServiceImpl();
  230.         System.out.println("请输入要培育鲜花的品种(例如:玫瑰))");
  231.         String flowerType = input.next();
  232.         flowerStore.bread(flowerType, store);
  233.         IsStoreLogOut(store);
  234.         return store;
  235.     }
  236.  
  237.     //以商店的身份登录，商店向顾客出售鲜花
  238.     private static void storeSell(FlowerStore store) {
  239.         FlowerStoreService flowerStore = new FlowerStoreServiceImpl();
  240.         Flower flower = null;
  241.         List<Flower> flowerList = flowerStore.getFlowersInstock(store.getId());
  242.         System.out.println("-------以下是鲜花商店正在出售的鲜花-------");
  243.         System.out.println("序号\t" + "鲜花名称\t" + "鲜花类型\t" + "鲜花价格\t");
  244.         for (int i = 0; i < flowerList.size(); i++) {
  245.             flower = flowerList.get(i);
  246.             System.out.println((i + 1) + "\t" + flower.getName() + "\t" + flower.getTypeName() + "\t" + flower.getPrice() + "\t");
  247.         }
  248.         System.out.println("---------请选择要购买的鲜花序号--------");
  249.         boolean type = true;
  250.         while (type) {
  251.             int num = input.nextInt();
  252.             if ((num - 1) < flowerList.size() && (num - 1) >= 0) {
  253.                 flower = flowerList.get(num - 1);
  254.                 System.out.println("------要卖出的鲜花信息如下------");
  255.                 System.out.println("鲜花名称为：" + flower.getName() + " 鲜花类别是：" + flower.getTypeName() + "鲜花价格是:" + flower.getPrice());
  256.                 System.out.println("请确认是否卖出，y代表卖出，n代表不卖");
  257.                 String code = input.next();
  258.                 if (null != code) {
  259.                     if ("y".equals(code)) {
  260.                         System.out.println("------下面是现有顾客买家，请选择您要卖给买家序号------");
  261.                         List<FlowerOwner> ownerList = new ArrayList<FlowerOwner>();
  262.                         FlowerOwnerDao ownerDao = new FlowerOwnerDaoImpl();
  263.                         ownerList = ownerDao.getAllOwner();
  264.                         FlowerOwner flowerOwner = null;
  265.                         System.out.println("序号\t" + "顾客姓名\t");
  266.                         for (int i = 0; i < ownerList.size(); i++) {
  267.                             flowerOwner = ownerList.get(i);
  268.                             System.out.println((i + 1) + "\t" + flowerOwner.getName() + "\t");
  269.                         }
  270.                         num = input.nextInt();
  271.                         if ((num - 1) < ownerList.size() && (num - 1) >= 0) {
  272.                             flowerOwner = ownerList.get(num - 1);
  273.                         }
  274.                         flower.setOwnerId(flowerOwner.getId());
  275.                         flowerStore.sell(flower);
  276.                     } else if ("n".equals(code)) {
  277.                         System.out
  278.                                 .println("--------您选择放弃本次交易，希望您再次光顾----------");
  279.  
  280.                     } else {
  281.                         System.out.println("--------您的输入有误----------");
  282.                     }
  283.                 }
  284.                 type = true;
  285.             } else {
  286.                 System.out.println("输入有误，请按照序号重新输入");
  287.                 type = false;
  288.             }
  289.             type = false;// 标识符更改为false，退出系统
  290.         }
  291.         IsStoreLogOut(store);
  292.     }
  293.  
  294.     //以商店的身份登录，商店找顾客购买鲜花
  295.     private static void storeBuy(FlowerStore store) {
  296.         FlowerStoreService flowerStore = new FlowerStoreServiceImpl();
  297.         Flower flower = null;
  298.         List<Flower> flowerList = flowerStore.getFlowerSelling();
  299.         System.out.println("-------以下是顾客正在出售的鲜花-------");
  300.         System.out.println("序号\t" + "鲜花名称\t" + "鲜花类型\t" + "鲜花价格\t");
  301.         for (int i = 0; i < flowerList.size(); i++) {
  302.             flower = flowerList.get(i);
  303.             System.out.println((i + 1) + "\t" + flower.getName() + "\t" + flower.getTypeName() + "\t" + flower.getPrice() + "\t");
  304.         }
  305.         System.out.println("-------请选择要购买哪一种鲜花，并输入选择项的序号-------");
  306.         int num = input.nextInt();
  307.         flower = flowerList.get(num - 1);
  308.         //System.out.println("选中的鲜花信息"+flower.getName()+"id"+flower.getId());
  309.         flowerStore.buy(flower, store);
  310.         IsStoreLogOut(store);
  311.     }
  312.  
  313.     //顾客登录
  314.     private static FlowerOwner ownerLogin() {
  315.         System.out.println("请先登录，请您输入姓名：");
  316.         String ownerName = input.nextLine().trim();
  317.         System.out.println("请您输入密码：");
  318.         String ownerPassword = input.nextLine().trim();
  319.         FlowerOwnerService flowerOwner = new FlowerOwnerServiceImpl();
  320.         FlowerOwner Owner = flowerOwner.login(ownerName, ownerPassword);
  321.         boolean reg = true;
  322.         while (reg) {
  323.             if (null == Owner) {
  324.                 System.out.println("登录失败，请确认您的用户名和密码后重新输入");
  325.                 System.out.println("请先登录，请您输入姓名：");
  326.                 ownerName = input.nextLine().trim();
  327.                 System.out.println("请您输入密码：");
  328.                 ownerPassword = input.nextLine().trim();
  329.                 Owner = flowerOwner.login(ownerName, ownerPassword);
  330.                 reg = true;
  331.             } else {
  332.                 reg = false;
  333.                 System.out.println("登录成功，您可以购买和卖出鲜花，如果您想购买鲜花请输入1，如果想卖出鲜花请输入2");
  334.                 System.out.println("1：购买鲜花");
  335.                 System.out.println("2：卖出鲜花");
  336.                 boolean type = true;
  337.                 //----------------------
  338.                 FlowerCirculate(type, Owner);
  339.             }
  340.         }
  341.         return Owner;
  342.     }
  343.  
  344.     private static boolean FlowerCirculate(boolean type, FlowerOwner owner) {
  345.         while (type) {
  346.             int num = input.nextInt();
  347.             if (1 == num) {
  348.                 ownerBuy(owner);
  349.                 type = false;
  350.             } else if (2 == num) {
  351.                 ownerSell(owner);
  352.                 type = false;
  353.             } else {
  354.                 System.out.println("输入有误,请重新输入");
  355.                 type = true;
  356.             }
  357.         }
  358.         return type;
  359.     }
  360.  
  361.     //顾客向商店卖鲜花
  362.     private static void ownerSell(FlowerOwner flowerowner) {
  363.     }
  364.  
  365.     //顾客找鲜花商店买鲜花
  366.     private static void ownerBuy(FlowerOwner flowerowner) {
  367.         System.out.println("-------请输入选择要购买范围：只需要按照下文要求输入选择项的序号即可--------");
  368.         System.out.println("1：购买库存鲜花");
  369.         System.out.println("2：购买新培育鲜花");
  370.         FlowerStoreService flowerStore = new FlowerStoreServiceImpl();
  371.         FlowerOwnerService flowerOwner = new FlowerOwnerServiceImpl();
  372.         Flower flower = null;
  373.         int num = input.nextInt();
  374.         List<Flower> flowerList = null;
  375.  
  376.         // num为1时购买库存鲜花
  377.         boolean type = true;
  378.         while (type) {
  379.             if (num == 1) {
  380.                 System.out.println(num + "库存鲜花:   -------以下是库存鲜花-------");
  381.                 //TODO-1 通过服务层接口查询库存鲜花 
  382.                 flowerList = flowerStore.getFlowersInstock(0);
  383.  
  384.                 //显示所有库存鲜花
  385.                 System.out.println("序号\t" + "鲜花名称\t" + "鲜花类型\t" + "鲜花价格\t");
  386.                 for (int i = 0; i < flowerList.size(); i++) {
  387.                     flower = flowerList.get(i);
  388.                     System.out.println((i + 1) + "\t" + flower.getName() + "\t" + flower.getTypeName() + "\t" + flower.getPrice() + "\t");
  389.                 }
  390.                 System.out.println("-------请选择要购买哪一种鲜花，并输入选择项的序号-------");
  391.                 num = input.nextInt();
  392.                 flower = flowerList.get(num - 1);
  393.                 flower.setOwnerId(flowerowner.getId());
  394.                 flowerOwner.FlowerOwnerbuy(flower);
  395.                 type = false;
  396.             } else if (num == 2) { // num为2时购买新培育鲜花
  397.                 System.out.println(num + "培育鲜花:   -------以下是库存鲜花-------");
  398.                 System.out.println("序号\t" + "鲜花名称\t" + "鲜花类型\t" + "鲜花价格\t");
  399.                 //通过服务层接口查询所有培育鲜花
  400.                 flowerList = flowerStore.getFlowersBread();
  401.                 //显示所有培育鲜花
  402.                 for (int i = 0; i < flowerList.size(); i++) {
  403.                     flower = flowerList.get(i);
  404.                     System.out.println((i + 1) + "\t" + flower.getName() + "\t" + flower.getTypeName() + "\t" + flower.getPrice() + "\t");
  405.                 }
  406.                 System.out.println("-------请选择要购买哪一种鲜花，并输入选择项的序号-------");
  407.                 String count = input.next();
  408.                 if (count.matches("[0-9]*")) {
  409.                     num = Integer.parseInt(count);
  410.                     flower = flowerList.get(num - 1);
  411.                     flower.setOwnerId(flowerowner.getId());
  412.                     flowerOwner.FlowerOwnerbuy(flower);
  413.                 }
  414.                 type = false;
  415.             } else {
  416.                 System.out.println("您的输入有误，请按照上诉提示输入");
  417.                 type = true;
  418.             }
  419.  
  420.         }
  421.         boolean isLogOut = true;
  422.         System.out.println("您是否要继续进行其它操作，若是请输入Y,否则输入任意字母退出系统");
  423.         String flag = input.next();
  424.         if (flag.equals("Y")) {
  425.             System.out.println("您可以购买和卖出鲜花，如果您想购买鲜花请输入1，如果想卖出鲜花请输入2");
  426.             System.out.println("1：购买鲜花");
  427.             System.out.println("2：卖出鲜花");
  428.             //循环
  429.             FlowerCirculate(isLogOut, flowerowner);
  430.         } else {
  431.             System.out.println("您已成功退出系统");
  432.         }
  433.     }
  434. }

 第二关：

文件：src/step6/service/impl/FlowerStoreServiceImpl.java

  1. package step6.service.impl;
  2.  
  3. import step6.dao.AccountDao;
  4. import step6.dao.FlowerDao;
  5. import step6.dao.FlowerOwnerDao;
  6. import step6.dao.FlowerStoreDao;
  7. import step6.dao.impl.AccountDaoImpl;
  8. import step6.dao.impl.FlowerDaoImpl;
  9. import step6.dao.impl.FlowerOwnerDaoImpl;
  10. import step6.dao.impl.FlowerStoreDaoImpl;
  11. import step6.entity.Account;
  12. import step6.entity.Flower;
  13. import step6.entity.FlowerOwner;
  14. import step6.entity.FlowerStore;
  15. import step6.service.FlowerStoreService;
  16.  
  17. import java.text.SimpleDateFormat;
  18. import java.util.Date;
  19. import java.util.List;
  20. import java.util.Scanner;
  21.  
  22. /**
  23.  * 鲜花商店实现类
  24.  */
  25. public class FlowerStoreServiceImpl implements FlowerStoreService {
  26.     /**
  27.      * 查询鲜花商店账目 其中的1代表鲜花商店卖给顾客,2代表顾客卖给商店，代表鲜花商店的各种交易
  28.      */
  29.     @Override
  30.     public List<Account> account(long storeId) {
  31.         String sql = "select * from account where deal_type=? and seller_id=? union select * from account where deal_type=? and buyer_id=?";
  32.         String[] param = {"1", String.valueOf(storeId), "2", String.valueOf(storeId)};
  33.         AccountDao accountDao = new AccountDaoImpl();
  34.         List<Account> list = accountDao.getFlowerStoreAccount(sql, param);
  35.         return list;
  36.     }
  37.  
  38.     /**
  39.      * 修改鲜花商店资金信息
  40.      */
  41.     @Override
  42.     public int modifyAccount(Flower flower, FlowerOwner owner) {
  43.         String insertsql = "insert into account(deal_type,flower_id,seller_id,buyer_id,price,deal_time) values (?, ?, ?, ?, ?,?)";
  44.         String date = new SimpleDateFormat("yyyy-MM-dd").format(new Date());
  45.         Object[] accountParam = {1, flower.getId(), flower.getStoreId(), owner.getId(), flower.getPrice(), date};
  46.         AccountDao accountDao = new AccountDaoImpl();
  47.         int insertAccount = accountDao.updateAccount(insertsql, accountParam);
  48.         return insertAccount;
  49.     }
  50.  
  51.     /**
  52.      * 培育鲜花
  53.      */
  54.     @Override
  55.     public Flower bread(String flowerType, FlowerStore store) {
  56.         Scanner input = new Scanner(System.in);
  57.         System.out.println("请输入您期望培育的鲜花名字：");
  58.         String flowerName = input.nextLine();
  59.         System.out.println("请输入您期望的鲜花价格：");
  60.         String flowerprice = input.nextLine();
  61.         String storeId = String.valueOf(store.getId());
  62.         String[] flowerParam = {flowerName, flowerType, storeId, flowerprice};
  63.         FlowerFactoryImpl flowerFactory = new FlowerFactoryImpl();
  64.         Flower flower = flowerFactory.breadNewFlower(flowerParam);
  65.         String sql = "insert into flower(`name`,typeName,store_id,price) values(?,?,?,?)";
  66.         Object[] param = {flower.getName(), flower.getTypeName(), flower.getStoreId(), flower.getPrice()};
  67.         FlowerDao flowerDao = new FlowerDaoImpl();
  68.         int count = flowerDao.updateFlower(sql, param);
  69.         if (count > 0) {
  70.             System.out.println(store.getName() + "成功培育了一种" + flower.getTypeName() + "鲜花");
  71.         }
  72.         return flower;
  73.     }
  74.  
  75.     /**
  76.      * 鲜花商店购买鲜花
  77.      */
  78.     @Override
  79.     public void buy(Flower flower, FlowerStore oldstore) {
  80.         String sql = "select * from flowerStore where id=?";
  81.         String paramStore[] = {String.valueOf(oldstore.getId())};
  82.         FlowerStoreDao storeDao = new FlowerStoreDaoImpl();
  83.         FlowerStore store = storeDao.getFlowerStore(sql, paramStore);
  84.         FlowerOwnerDao ownerDao = new FlowerOwnerDaoImpl();
  85.         sql = "select * from flowerOwner where id = ?";
  86.         String paramOwner[] = {String.valueOf(flower.getOwnerId())};
  87.         FlowerOwner owner = ownerDao.selectOwner(sql, paramOwner);
  88.         int updateFlower = modifyFlower(flower, null, store);// 更新鲜花信息
  89.         if (updateFlower > 0) {// 更新顾客的信息
  90.             int updateOwner = modifyOwner(owner, flower, 1);
  91.             if (updateOwner > 0) {// 更新鲜花商店的信息
  92.                 int updateStore = modifyStore(flower, 1, store);
  93.                 if (updateStore > 0) {// 更新鲜花商店信息
  94.                     int insertAccount = modifyAccount(flower, owner);
  95.                     if (insertAccount > 0) {
  96.                         System.out.println(store.getName() + "已成功购买鲜花:" + flower.getName() + "价格为" + flower.getPrice());
  97.                     }
  98.                 }
  99.             }
  100.         } else {
  101.             System.out.println("修改鲜花信息失败");
  102.         }
  103.     }
  104.  
  105.     /**
  106.      * 商店卖鲜花
  107.      */
  108.     @Override
  109.     public void sell(Flower flower) {
  110.         FlowerDaoImpl FlowerDao = new FlowerDaoImpl();
  111.         FlowerStoreDaoImpl storeDao = new FlowerStoreDaoImpl();
  112.         FlowerOwnerDaoImpl ownerDao = new FlowerOwnerDaoImpl();
  113.         FlowerStoreService FlowerStore = new FlowerStoreServiceImpl();
  114.         String updatesql = "update Flower set store_id = null ,owner_id=? where id=?";
  115.         Object[] param = {flower.getOwnerId(), flower.getId()};
  116.         int updateFlower = FlowerDao.executeSQL(updatesql, param);// 更新鲜花信息
  117.         if (updateFlower > 0) {// 更新顾客的信息
  118.             String ownersql = "select * from Flowerowner where id=?";
  119.             String ownerparam[] = {String.valueOf(flower.getOwnerId())};
  120.  
  121.             FlowerOwner owner = ownerDao.selectOwner(ownersql, ownerparam);
  122.             String updateOwnerSql = "update Flowerowner set money=? where id=?";
  123.             double count = flower.getPrice();
  124.             Object[] ownerParam = {(owner.getMoney() - count), owner.getId()};
  125.             int updateOwner = ownerDao.executeSQL(updateOwnerSql, ownerParam);
  126.             if (updateOwner > 0) {// 更新鲜花商店的信息
  127.                 FlowerStore store = FlowerStore.getFlowerStore(flower.getStoreId());
  128.                 String updateStore = "update Flowerstore set balance=? where id=?";
  129.                 Object[] storeParam = {(store.getBalance() + count),
  130.                         store.getId()};
  131.                 int updatestore = storeDao.executeSQL(updateStore, storeParam);
  132.                 if (updatestore > 0) {// 更新鲜花商店账户的信息
  133.                     String insertsql = "insert into account(deal_type,Flower_id,seller_id,buyer_id,price,deal_time) values (?, ?, ?, ?, ?, ?)";
  134.                     String date = new SimpleDateFormat("yyyy-MM-dd")
  135.                             .format(new Date());
  136.                     Object[] accountParam = {1, flower.getId(), owner.getId(), flower.getStoreId(), count, date};
  137.                     AccountDao accountDao = new AccountDaoImpl();
  138.                     int insertAccount = accountDao.updateAccount(insertsql, accountParam);
  139.                     if (insertAccount > 0) {
  140.                         System.out.println(store.getName() + "已成功卖出价格为" + flower.getPrice() + "的鲜花" + flower.getName());
  141.                     }
  142.                 }
  143.             }
  144.         }
  145.     }
  146.  
  147.     /**
  148.      * 查询出所有库存鲜花
  149.      */
  150.     @Override
  151.     public List<Flower> getFlowersInstock(long storeId) {
  152.         FlowerDao flowerDao = new FlowerDaoImpl();
  153.         String[] param = {String.valueOf(storeId)};
  154.         String sql = "";
  155.         // 当storeId不为 0 时，要执行查询指定商店库存鲜花
  156.         if (storeId != 0) {
  157.             //填写查询指定商店库存鲜花SQL语句
  158.             sql = "select * from flower where owner_id is null and store_id=?";
  159.         }
  160.         // 当storeId为0时，要执行查询所有商店的库存鲜花
  161.         if (0 == storeId) {
  162.             //填写查询所有商店库存鲜花SQL语句
  163.             sql = "select * from flower where owner_id is null";
  164.             param = null;
  165.         }
  166.         List<Flower> flowerList = flowerDao.selectFlower(sql, param);
  167.         return flowerList;
  168.     }
  169.  
  170.     /**
  171.      * 查询出所有新培育的鲜花,
  172.      */
  173.     @Override
  174.     public List<Flower> getFlowersBread() {
  175.         FlowerDao flowerDao = new FlowerDaoImpl();
  176.         String sql = "SELECT * FROM flower WHERE owner_id IS NULL AND typeName NOT IN (?,?,?) AND store_id IS Not NULL";
  177.         String[] flowerParam = {"香槟玫瑰", "白玫瑰", "粉玫瑰"};
  178.         //TODO-2 通过Dao层访问新培育的鲜花，并将结果返回
  179.         return flowerDao.selectFlower(sql, flowerParam);
  180.  
  181.         
  182.     }
  183.  
  184.  
  185.     /**
  186.      * 根据顾客信息修改鲜花信息 根据FlowerOwnerEntity和FlowerStoreEntity的值判断是顾客买鲜花或者鲜花商店买鲜花
  187.      * FlowerOwnerEntity=null是鲜花商店买鲜花，FlowerStoreEntity=null是顾客买鲜花
  188.      */
  189.     @Override
  190.     public int modifyFlower(Flower flower, FlowerOwner flowerOwner, FlowerStore store) {
  191.         String updatesql = null;
  192.         long id = 0;
  193.         if (null == store) {
  194.             updatesql = "update flower set owner_id=? where id=?";
  195.             id = flowerOwner.getId();
  196.         } else if (null == flowerOwner) {
  197.             updatesql = "update flower set store_id=?,owner_id=null where id=?";
  198.             id = store.getId();
  199.         }
  200.  
  201.         Object[] param = {id, flower.getId()};
  202.         FlowerDaoImpl flowerDao = new FlowerDaoImpl();
  203.         int updateFlower = flowerDao.executeSQL(updatesql, param);// 更新鲜花信息
  204.  
  205.         return updateFlower;
  206.     }
  207.  
  208.     /**
  209.      * 修改顾客信息 type=0是顾客买鲜花，type=1是鲜花商店买鲜花，价钱的变动
  210.      */
  211.     @Override
  212.     public int modifyOwner(FlowerOwner owner, Flower flower, int type) {
  213.         FlowerOwnerDaoImpl ownerDao = new FlowerOwnerDaoImpl();
  214.         String updateOwnerSql = "update flowerowner set money=? where id=?";
  215.  
  216.         double count = 0;
  217.         if (0 == type) {
  218.             count = (owner.getMoney() - flower.getPrice());
  219.         }
  220.         if (1 == type) {
  221.             count = (owner.getMoney() + flower.getPrice());
  222.         }
  223.         Object[] ownerParam = {count, owner.getId()};
  224.         int updateOwner = ownerDao.executeSQL(updateOwnerSql, ownerParam);
  225.         return updateOwner;
  226.     }
  227.  
  228.  
  229.     /**
  230.      * 修改鲜花商店信息 type=0是顾客买鲜花，type=1是鲜花商店买鲜花
  231.      */
  232.     @Override
  233.     public int modifyStore(Flower flower, int type, FlowerStore oldstore) {
  234.         FlowerStoreService store = new FlowerStoreServiceImpl();
  235.         FlowerStore flowerStore = store.getFlowerStore(oldstore.getId());
  236.         String updateStore = "update flowerstore set balance=? where id=?";
  237.  
  238.         double count = 0;
  239.         if (0 == type) {
  240.             count = (flowerStore.getBalance() + flower.getPrice());
  241.         }
  242.         if (1 == type) {
  243.             count = (flowerStore.getBalance() - flower.getPrice());
  244.         }
  245.         Object[] storeParam = {count, oldstore.getId()};
  246.         FlowerStoreDaoImpl storeDao = new FlowerStoreDaoImpl();
  247.         int updatestore = storeDao.executeSQL(updateStore, storeParam);
  248.         return updatestore;
  249.     }
  250.  
  251.     /**
  252.      * 鲜花商店登录
  253.      *
  254.      * @param storeName
  255.      * @param storePassword
  256.      * @return
  257.      */
  258.     @Override
  259.     public FlowerStore login(String storeName, String storePassword) {
  260.         FlowerStore flowerStore;
  261.         FlowerStoreDao storeDao = new FlowerStoreDaoImpl();
  262.         String sql = "select * from flowerstore where name=? and password=?";
  263.         String[] param = {storeName, storePassword};
  264.         flowerStore = storeDao.getFlowerStore(sql, param);
  265.         return flowerStore;
  266.  
  267.     }
  268.  
  269.     /**
  270.      * 查询出所有鲜花商店正在出售的鲜花
  271.      */
  272.     @Override
  273.     public List<Flower> getFlowerSelling() {
  274.         FlowerDao flowerDao = new FlowerDaoImpl();
  275.         String sql = "select * from flower where owner_id is not null";
  276.         String[] flowerParam = null;
  277.         List<Flower> flowerList = flowerDao.selectFlower(sql, flowerParam);
  278.         return flowerList;
  279.     }
  280.  
  281.     /**
  282.      * 根据鲜花商店标识符查询鲜花信息
  283.      */
  284.     @Override
  285.     public FlowerStore getFlowerStore(long id) {
  286.         String sql = "select * from flowerstore where id=" + id;
  287.         FlowerStoreDao storeDao = new FlowerStoreDaoImpl();
  288.         FlowerStore flowerStore = storeDao.getFlowerStore(sql, null);
  289.         return flowerStore;
  290.     }
  291. }

文件：src/step6/test/FlowerStoreApp.java

  1. package step6.test;
  2.  
  3. import dbtest.InitDB;
  4. import step6.dao.*;
  5. import step6.dao.impl.*;
  6. import step6.entity.*;
  7. import step6.service.*;
  8. import step6.service.impl.*;
  9.  
  10. import java.util.ArrayList;
  11. import java.util.List;
  12. import java.util.Scanner;
  13.  
  14. public class FlowerStoreApp {
  15.     private static Scanner input = new Scanner(System.in);
  16.  
  17.     public static void main(String[] args) {
  18.         //1-初始化 NySQL 数据库 ownerBuy TODO
  19.         InitDB db = new InitDB();
  20.         //2-启动鲜花商店系统
  21.         startFlowerShop();
  22.     }
  23.  
  24.     private static void startFlowerShop() {
  25.         System.out.println("----------------------鲜花商店启动-----------------");
  26.         System.out.println("鲜花信息");
  27.         System.out.println("****************************************************");
  28.         FlowerDao flowerDao = new FlowerDaoImpl();
  29.         List<Flower> flowerList = flowerDao.getAllFlower();
  30.         System.out.println("序号\t" + "鲜花名称\t" + "鲜花品种\t" + "鲜花售价\t" + "");
  31.         for (int i = 0; i < flowerList.size(); i++) {
  32.             Flower flower = flowerList.get(i);
  33.             System.out.println((i + 1) + "\t" + flower.getName() + "\t" + flower.getTypeName() + "\t" + flower.getPrice() + "\t");
  34.         }
  35.         System.out.println("****************************************************");
  36.         System.out.print("\n");
  37.         System.out.println("顾客信息");
  38.         FlowerOwnerDao ownerDao = new FlowerOwnerDaoImpl();
  39.         List<FlowerOwner> ownerList = ownerDao.getAllOwner();
  40.         System.out.println("****************************************************");
  41.         System.out.println("序号\t" + "顾客姓名\t");
  42.         for (int i = 0; i < ownerList.size(); i++) {
  43.             FlowerOwner owner = ownerList.get(i);
  44.             System.out.println((i + 1) + "\t" + owner.getName() + "\t");
  45.         }
  46.         System.out.println("****************************************************");
  47.         System.out.print("\n");
  48.         System.out.println("鲜花商店信息");
  49.         System.out.println("****************************************************");
  50.         FlowerStoreDao storeDao = new FlowerStoreDaoImpl();
  51.         List<FlowerStore> storeList = storeDao.getAllStore();
  52.         System.out.println("序号\t" + "鲜花商店名称\t");
  53.         for (int i = 0; i < storeList.size(); i++) {
  54.             FlowerStore store = storeList.get(i);
  55.             System.out.println((i + 1) + "\t" + store.getName() + "\t");
  56.         }
  57.         System.out.println("****************************************************");
  58.         System.out.print("\n");
  59.         //系统登录
  60.         System.out.println("请选择输入登录模式，输入1为顾客登录，输入2为鲜花商店登录");
  61.         boolean type = true;
  62.         String num;
  63.         while (type) {
  64.             num = input.nextLine();
  65.             if ("1".equals(num)) {
  66.                 ownerLogin();
  67.                 type = false;
  68.             } else if ("2".equals(num)) {
  69.                 storeLogin();
  70.                 type = false;
  71.             } else {
  72.                 System.out.println("输入有误，请按照指定规则输入");
  73.                 System.out.println("请选择登录模式，输入1为顾客登录，输入2为鲜花商店登录");
  74.                 type = true;
  75.             }
  76.         }
  77.     }
  78.  
  79.     //鲜花商店登录
  80.     private static FlowerStore storeLogin() {
  81.         FlowerStoreService fsService = new FlowerStoreServiceImpl();
  82.         FlowerStore flowerStore = null;
  83.         //TODO-1 鲜花商店登录代码实现
  84.         boolean type = true;
  85.         while (type) {
  86.             System.out.println("请先登录，请输入鲜花商店名字：");
  87.             String storeName = input.nextLine().trim();
  88.             System.out.println("请输入鲜花商店的密码：");
  89.             String storePassword = input.nextLine().trim();
  90.             flowerStore = fsService.login(storeName, storePassword);
  91.             if (null != flowerStore) {
  92.                 System.out.println("-------恭喜成功登录-------");
  93.                 System.out.println("-------鲜花商店的基本信息：-------");
  94.                 System.out.println("名字：" + flowerStore.getName());
  95.                 System.out.println("资金：" + flowerStore.getBalance());
  96.                 type = false;
  97.             } else {
  98.                 System.out.println("登录失败，请确认您的用户名和密码是否正确,重新登录");
  99.                 type = true;
  100.             }
  101.         }
  102.  
  103.         System.out.println("您已登录成功，可以进行如下操作");
  104.         StoreChoose(flowerStore);
  105.  
  106.         return flowerStore;
  107.     }
  108.  
  109.     //创建鲜花商店
  110.     private static FlowerStore createFlowerStore(FlowerStore store) {
  111.         FlowerStoreFactory storeFactory = new FlowerStoreFactoryImpl();
  112.         storeFactory.createFlowerStore();
  113.         IsStoreLogOut(store);
  114.  
  115.         return store;//返回的是鲜花商店创建者
  116.     }
  117.  
  118.     private static void IsStoreLogOut(FlowerStore store) {
  119.         System.out.println("您是否继续其它操作若是请输入y,退出请按任意键");
  120.         String code = input.next();
  121.         if (code.equals("y")) {
  122.             StoreChoose(store);
  123.         } else {
  124.             System.out.println("您已成功退出系统");
  125.         }
  126.     }
  127.  
  128.     private static void StoreChoose(FlowerStore store) {
  129.         System.out.println("1：购买鲜花");
  130.         System.out.println("2：卖出鲜花");
  131.         System.out.println("3：培育鲜花");
  132.         System.out.println("4：查询待售鲜花");
  133.         System.out.println("5：查看商店结余");
  134.         System.out.println("6：查看商店账目");
  135.         System.out.println("7：开鲜花商店");
  136.         System.out.println("请根据需要执行的操作，选择序号输入，退出请输入0");
  137.         boolean type = true;
  138.         while (type) {
  139.             int num = input.nextInt();
  140.             switch (num) {
  141.                 case 0:
  142.                     System.out.println("退出成功");
  143.                     type = false;
  144.                     break;
  145.                 case 1:
  146.                     storeBuy(store);
  147.                     type = false;
  148.                     break;
  149.                 case 2:
  150.                     storeSell(store);
  151.                     type = false;
  152.                     break;
  153.                 case 3:
  154.                     storeBread(store);//传入登录的商店
  155.                     type = false;
  156.                     break;
  157.                 case 4:
  158.                     queryFlowerStock(store.getId());
  159.                     type = false;
  160.                     break;
  161.                 case 5:
  162.                     queryStoreBalance(store);
  163.                     type = false;
  164.                     break;
  165.                 case 6:
  166.                     getAccount(store.getId());
  167.                     type = false;
  168.                     break;
  169.                 case 7:
  170.                     createFlowerStore(store);
  171.                     type = false;
  172.                     break;
  173.                 default:
  174.                     System.out.println("输入有误,请重新输入");
  175.                     type = true;
  176.                     break;
  177.             }
  178.         }
  179.     }
  180.  
  181.  
  182.     //获得鲜花商店的资金1代表商店顾客，2顾客卖给商店，3代表顾客之间的交易
  183.     private static FlowerStore getAccount(long id) {
  184.         FlowerStoreService storeService = new FlowerStoreServiceImpl();
  185.         FlowerStore store = storeService.getFlowerStore(id);
  186.         List<Account> list = storeService.account(id);
  187.         for (int i = 0; i < list.size(); i++) {
  188.             Account account = list.get(i);
  189.             String type = null;
  190.             if (1 == account.getDealType()) {
  191.                 type = "商店卖给顾客";
  192.             } else if (2 == account.getDealType()) {
  193.                 type = "顾客卖给商店";
  194.             } else {
  195.                 type = "顾客之间交易";
  196.             }
  197.             System.out.println("第" + (i + 1) + "笔交易,交易类型为：" + type + "，交易金额是:"
  198.                     + account.getPrice());
  199.         }
  200.         IsStoreLogOut(store);
  201.         return store;
  202.     }
  203.  
  204.     //查询商店余额
  205.     private static FlowerStore queryStoreBalance(FlowerStore store) {
  206.         double balance = store.getBalance();
  207.         System.out.println(store.getName() + "鲜花商店的结余为:" + balance);
  208.         IsStoreLogOut(store);
  209.         return store;
  210.     }
  211.  
  212.     //查询待售鲜花
  213.     private static FlowerStore queryFlowerStock(long storeId) {
  214.         FlowerStoreService flowerStoreService = new FlowerStoreServiceImpl();
  215.         FlowerStore store = flowerStoreService.getFlowerStore(storeId);
  216.         Flower flower = null;
  217.         List<Flower> flowerList = flowerStoreService.getFlowersInstock(storeId);
  218.         System.out.println("序号\t" + "鲜花名称\t" + "鲜花类型\t" + "鲜花价格\t");
  219.         for (int i = 0; i < flowerList.size(); i++) {
  220.             flower = flowerList.get(i);
  221.             System.out.println((i + 1) + "\t" + flower.getName() + "\t" + flower.getTypeName() + "\t" + flower.getPrice() + "\t");
  222.         }
  223.         IsStoreLogOut(store);
  224.         return store;
  225.     }
  226.  
  227.     //鲜花商店培育鲜花
  228.     private static FlowerStore storeBread(FlowerStore store) {
  229.         FlowerStoreService flowerStore = new FlowerStoreServiceImpl();
  230.         System.out.println("请输入要培育鲜花的品种(例如:玫瑰))");
  231.         String flowerType = input.next();
  232.         flowerStore.bread(flowerType, store);
  233.         IsStoreLogOut(store);
  234.         return store;
  235.     }
  236.  
  237.     //以商店的身份登录，商店向顾客出售鲜花
  238.     private static void storeSell(FlowerStore store) {
  239.         FlowerStoreService flowerStore = new FlowerStoreServiceImpl();
  240.         Flower flower = null;
  241.         List<Flower> flowerList = flowerStore.getFlowersInstock(store.getId());
  242.         System.out.println("-------以下是鲜花商店正在出售的鲜花-------");
  243.         System.out.println("序号\t" + "鲜花名称\t" + "鲜花类型\t" + "鲜花价格\t");
  244.         for (int i = 0; i < flowerList.size(); i++) {
  245.             flower = flowerList.get(i);
  246.             System.out.println((i + 1) + "\t" + flower.getName() + "\t" + flower.getTypeName() + "\t" + flower.getPrice() + "\t");
  247.         }
  248.         System.out.println("---------请选择要购买的鲜花序号--------");
  249.         boolean type = true;
  250.         while (type) {
  251.             int num = input.nextInt();
  252.             if ((num - 1) < flowerList.size() && (num - 1) >= 0) {
  253.                 flower = flowerList.get(num - 1);
  254.                 System.out.println("------要卖出的鲜花信息如下------");
  255.                 System.out.println("鲜花名称为：" + flower.getName() + " 鲜花类别是：" + flower.getTypeName() + "鲜花价格是:" + flower.getPrice());
  256.                 System.out.println("请确认是否卖出，y代表卖出，n代表不卖");
  257.                 String code = input.next();
  258.                 if (null != code) {
  259.                     if ("y".equals(code)) {
  260.                         System.out.println("------下面是现有顾客买家，请选择您要卖给买家序号------");
  261.                         List<FlowerOwner> ownerList = new ArrayList<FlowerOwner>();
  262.                         FlowerOwnerDao ownerDao = new FlowerOwnerDaoImpl();
  263.                         ownerList = ownerDao.getAllOwner();
  264.                         FlowerOwner flowerOwner = null;
  265.                         System.out.println("序号\t" + "顾客姓名\t");
  266.                         for (int i = 0; i < ownerList.size(); i++) {
  267.                             flowerOwner = ownerList.get(i);
  268.                             System.out.println((i + 1) + "\t" + flowerOwner.getName() + "\t");
  269.                         }
  270.                         num = input.nextInt();
  271.                         if ((num - 1) < ownerList.size() && (num - 1) >= 0) {
  272.                             flowerOwner = ownerList.get(num - 1);
  273.                         }
  274.                         flower.setOwnerId(flowerOwner.getId());
  275.                         flowerStore.sell(flower);
  276.                     } else if ("n".equals(code)) {
  277.                         System.out
  278.                                 .println("--------您选择放弃本次交易，希望您再次光顾----------");
  279.  
  280.                     } else {
  281.                         System.out.println("--------您的输入有误----------");
  282.                     }
  283.                 }
  284.                 type = true;
  285.             } else {
  286.                 System.out.println("输入有误，请按照序号重新输入");
  287.                 type = false;
  288.             }
  289.             type = false;// 标识符更改为false，退出系统
  290.         }
  291.         IsStoreLogOut(store);
  292.     }
  293.  
  294.     //以商店的身份登录，商店找顾客购买鲜花
  295.     private static void storeBuy(FlowerStore store) {
  296.         FlowerStoreService flowerStore = new FlowerStoreServiceImpl();
  297.         Flower flower = null;
  298.         List<Flower> flowerList = flowerStore.getFlowerSelling();
  299.         System.out.println("-------以下是顾客正在出售的鲜花-------");
  300.         System.out.println("序号\t" + "鲜花名称\t" + "鲜花类型\t" + "鲜花价格\t");
  301.         for (int i = 0; i < flowerList.size(); i++) {
  302.             flower = flowerList.get(i);
  303.             System.out.println((i + 1) + "\t" + flower.getName() + "\t" + flower.getTypeName() + "\t" + flower.getPrice() + "\t");
  304.         }
  305.         System.out.println("-------请选择要购买哪一种鲜花，并输入选择项的序号-------");
  306.         int num = input.nextInt();
  307.         flower = flowerList.get(num - 1);
  308.         //System.out.println("选中的鲜花信息"+flower.getName()+"id"+flower.getId());
  309.         flowerStore.buy(flower, store);
  310.         IsStoreLogOut(store);
  311.     }
  312.  
  313.     //顾客登录
  314.     private static FlowerOwner ownerLogin() {
  315.         System.out.println("请先登录，请您输入姓名：");
  316.         String ownerName = input.nextLine().trim();
  317.         System.out.println("请您输入密码：");
  318.         String ownerPassword = input.nextLine().trim();
  319.         FlowerOwnerService flowerOwner = new FlowerOwnerServiceImpl();
  320.         FlowerOwner Owner = flowerOwner.login(ownerName, ownerPassword);
  321.         boolean reg = true;
  322.         while (reg) {
  323.             if (null == Owner) {
  324.                 System.out.println("登录失败，请确认您的用户名和密码后重新输入");
  325.                 System.out.println("请先登录，请您输入姓名：");
  326.                 ownerName = input.nextLine().trim();
  327.                 System.out.println("请您输入密码：");
  328.                 ownerPassword = input.nextLine().trim();
  329.                 Owner = flowerOwner.login(ownerName, ownerPassword);
  330.                 reg = true;
  331.             } else {
  332.                 reg = false;
  333.                 System.out.println("登录成功，您可以购买和卖出鲜花，如果您想购买鲜花请输入1，如果想卖出鲜花请输入2");
  334.                 System.out.println("1：购买鲜花");
  335.                 System.out.println("2：卖出鲜花");
  336.                 boolean type = true;
  337.                 //----------------------
  338.                 FlowerCirculate(type, Owner);
  339.             }
  340.         }
  341.         return Owner;
  342.     }
  343.  
  344.     private static boolean FlowerCirculate(boolean type, FlowerOwner owner) {
  345.         while (type) {
  346.             int num = input.nextInt();
  347.             if (1 == num) {
  348.                 ownerBuy(owner);
  349.                 type = false;
  350.             } else if (2 == num) {
  351.                 ownerSell(owner);
  352.                 type = false;
  353.             } else {
  354.                 System.out.println("输入有误,请重新输入");
  355.                 type = true;
  356.             }
  357.         }
  358.         return type;
  359.     }
  360.  
  361.     //顾客向商店卖鲜花
  362.     private static void ownerSell(FlowerOwner flowerowner) {
  363.     }
  364.  
  365.     //顾客找鲜花商店买鲜花
  366.     private static void ownerBuy(FlowerOwner flowerowner) {
  367.         System.out.println("-------请输入选择要购买范围：只需要按照下文要求输入选择项的序号即可--------");
  368.         System.out.println("1：购买库存鲜花");
  369.         System.out.println("2：购买新培育鲜花");
  370.         FlowerStoreService flowerStore = new FlowerStoreServiceImpl();
  371.         FlowerOwnerService flowerOwner = new FlowerOwnerServiceImpl();
  372.         Flower flower = null;
  373.         int num = input.nextInt();
  374.         List<Flower> flowerList = null;
  375.  
  376.         // num为1时购买库存鲜花
  377.         boolean type = true;
  378.         while (type) {
  379.             if (num == 1) {
  380.                 System.out.println(num + "库存鲜花:   -------以下是库存鲜花-------");
  381.                 //通过服务层接口查询库存鲜花
  382.                 flowerList = flowerStore.getFlowersInstock(0);
  383.  
  384.                 //显示所有库存鲜花
  385.                 System.out.println("序号\t" + "鲜花名称\t" + "鲜花类型\t" + "鲜花价格\t");
  386.                 for (int i = 0; i < flowerList.size(); i++) {
  387.                     flower = flowerList.get(i);
  388.                     System.out.println((i + 1) + "\t" + flower.getName() + "\t" + flower.getTypeName() + "\t" + flower.getPrice() + "\t");
  389.                 }
  390.                 System.out.println("-------请选择要购买哪一种鲜花，并输入选择项的序号-------");
  391.                 num = input.nextInt();
  392.                 flower = flowerList.get(num - 1);
  393.                 flower.setOwnerId(flowerowner.getId());
  394.                 flowerOwner.FlowerOwnerbuy(flower);
  395.                 type = false;
  396.             } else if (num == 2) { // num为2时购买新培育鲜花
  397.                 System.out.println(num + "培育鲜花:   -------以下是库存鲜花-------");
  398.                 System.out.println("序号\t" + "鲜花名称\t" + "鲜花类型\t" + "鲜花价格\t");
  399.                 //TODO-1 通过服务层接口查询所有培育鲜花 FlowerStoreServiceImpl public List<Flower> getFlowersBread()
  400.                 flowerList = null;
  401.                 flowerList = flowerStore.getFlowersBread();
  402.  
  403.                 //显示所有培育鲜花
  404.                 for (int i = 0; i < flowerList.size(); i++) {
  405.                     flower = flowerList.get(i);
  406.                     System.out.println((i + 1) + "\t" + flower.getName() + "\t" + flower.getTypeName() + "\t" + flower.getPrice() + "\t");
  407.                 }
  408.                 System.out.println("-------请选择要购买哪一种鲜花，并输入选择项的序号-------");
  409.                 String count = input.next();
  410.                 if (count.matches("[0-9]*")) {
  411.                     num = Integer.parseInt(count);
  412.                     flower = flowerList.get(num - 1);
  413.                     flower.setOwnerId(flowerowner.getId());
  414.                     flowerOwner.FlowerOwnerbuy(flower);
  415.                 }
  416.                 type = false;
  417.             } else {
  418.                 System.out.println("您的输入有误，请按照上诉提示输入");
  419.                 type = true;
  420.             }
  421.  
  422.         }
  423.         boolean isLogOut = true;
  424.         System.out.println("您是否要继续进行其它操作，若是请输入Y,否则输入任意字母退出系统");
  425.         String flag = input.next();
  426.         if (flag.equals("Y")) {
  427.             System.out.println("您可以购买和卖出鲜花，如果您想购买鲜花请输入1，如果想卖出鲜花请输入2");
  428.             System.out.println("1：购买鲜花");
  429.             System.out.println("2：卖出鲜花");
  430.             //循环
  431.             FlowerCirculate(isLogOut, flowerowner);
  432.         } else {
  433.             System.out.println("您已成功退出系统");
  434.         }
  435.     }
  436. }

  第三关

文件：src/step7/service/impl/FlowerOwnerServiceImpl.java

  1. package step7.service.impl;
  2.  
  3. import step7.dao.AccountDao;
  4. import step7.dao.FlowerDao;
  5. import step7.dao.FlowerOwnerDao;
  6. import step7.dao.FlowerStoreDao;
  7. import step7.dao.impl.AccountDaoImpl;
  8. import step7.dao.impl.FlowerDaoImpl;
  9. import step7.dao.impl.FlowerOwnerDaoImpl;
  10. import step7.dao.impl.FlowerStoreDaoImpl;
  11. import step7.entity.Flower;
  12. import step7.entity.FlowerOwner;
  13. import step7.entity.FlowerStore;
  14. import step7.service.FlowerOwnerService;
  15. import step7.service.FlowerStoreService;
  16.  
  17. import java.text.SimpleDateFormat;
  18. import java.util.ArrayList;
  19. import java.util.Date;
  20. import java.util.List;
  21.  
  22. /**
  23.  * @author 鲜花顾客实现类
  24.  */
  25. public class FlowerOwnerServiceImpl implements FlowerOwnerService {
  26.     /**
  27.      * 顾客购买库存鲜花，根据用户控制台输入获得到的序号，来实际调用购买库存鲜花或者购买新培育的鲜花 sell
  28.      */
  29.     @Override
  30.     public void sell(Flower flower) {
  31.         FlowerDao flowerDao = new FlowerDaoImpl();
  32.         FlowerOwnerDao ownerDao = new FlowerOwnerDaoImpl();
  33.         String updatesql = "update flower set store_id=?,owner_id=NUll  where id=?";
  34.         Object[] param = {flower.getStoreId(), flower.getId()};
  35.         int updateFlower = flowerDao.updateFlower(updatesql, param);// 更新鲜花信息
  36.  
  37.         if (updateFlower > 0) {// 更新顾客的信息
  38.             String ownersql = "select * from flowerowner where id=?";
  39.             String ownerparam[] = {String.valueOf(flower.getOwnerId())};
  40.  
  41.             FlowerOwner owner = ownerDao.selectOwner(ownersql, ownerparam);
  42.             String updateOwnerSql = "update flowerowner set money=? where id=?";
  43.             String[] ownerParam = {String.valueOf((owner.getMoney() + flower.getPrice())), String.valueOf(owner.getId())};
  44.             int updateOwner = ownerDao.updateOwner(updateOwnerSql, ownerParam);
  45.             if (updateOwner > 0) {// 更新鲜花商店的信息
  46.                 FlowerStoreService store = new FlowerStoreServiceImpl();
  47.                 FlowerStoreDao storeDao = new FlowerStoreDaoImpl();
  48.                 FlowerStore flowerStore = store.getFlowerStore(flower.getStoreId());
  49.                 //TODO-4 在 Dao层更新鲜花商店的信息
  50.                 String sql = "update flowerstore set balance=? where id=?";
  51.                 Object[] ownerParam2 ={(flowerStore.getBalance()-flower.getPrice()),flowerStore.getId()};
  52.                 int updatestore = storeDao.updateStore(sql, ownerParam2);
  53.                 
  54.  
  55.                 if (updatestore > 0) {// 更新鲜花商店台帐信息
  56.                     String insertsql = "insert into account(deal_type,flower_id,seller_id,buyer_id,price,deal_time) values (?, ?, ?, ?, ?, ?)";
  57.                     String date = new SimpleDateFormat("yyyy-MM-dd").format(new Date());
  58.                     Object[] accountParam = {2, flower.getId(), owner.getId(), flower.getStoreId(), flower.getPrice(), date};
  59.                     //TODO-5 在 Dao层在 account表中插入数据
  60.                     AccountDaoImpl ac = new AccountDaoImpl();
  61.                     int insertAccount = ac.updateAccount(insertsql,accountParam);
  62.  
  63.                     if (insertAccount > 0) {
  64.                         System.out.println("您已成功卖出鲜花：" + flower.getName() + "获得收入" + flower.getPrice());
  65.                     }
  66.                 }
  67.             }
  68.         }
  69.     }
  70.  
  71.     @Override
  72.     public void FlowerOwnerbuy(Flower flower) {
  73.         String sql = "select * from flowerowner where id=?";
  74.         String param[] = {String.valueOf(flower.getOwnerId())};
  75.         FlowerOwnerDao ownerDao = new FlowerOwnerDaoImpl();
  76.         FlowerOwner owner = ownerDao.selectOwner(sql, param);
  77.         String sql1 = "select * from flowerStore where id=?";
  78.         String param1[] = {String.valueOf(flower.getStoreId())};
  79.         FlowerStoreDao storeDao = new FlowerStoreDaoImpl();
  80.         FlowerStore store = storeDao.getFlowerStore(sql, param1);
  81.         FlowerStoreService flowerStore = new FlowerStoreServiceImpl();
  82.         int updateFlower = flowerStore.modifyFlower(flower, owner, null);// 更新鲜花信息
  83.         if (updateFlower > 0) {// 更新顾客的信息
  84.             int updateOwner = flowerStore.modifyOwner(owner, flower, 0);
  85.             if (updateOwner > 0) {// 更新鲜花商店的信息
  86.                 int updateStore = flowerStore.modifyStore(flower, 0, store);
  87.                 if (updateStore > 0) {// 更新鲜花商店帐户信息
  88.                     int insertAccount = flowerStore.modifyAccount(flower, owner);
  89.                     if (insertAccount > 0) {
  90.                         System.out.println("您已成功购买价格为" + flower.getPrice() + "的" + flower.getName());
  91.                     }
  92.                 }
  93.             }
  94.         }
  95.     }
  96.  
  97.     /**
  98.      * 顾客登录
  99.      */
  100.     @Override
  101.     public FlowerOwner login(String ownerName,String ownerPassword) {
  102.         FlowerOwnerDao ownerDao = new FlowerOwnerDaoImpl();
  103.         String sql = "select * from flowerowner where name=? and password=?";
  104.         String[] param = {ownerName, ownerPassword};
  105.         FlowerOwner owner = ownerDao.selectOwner(sql, param);
  106.         return owner;
  107.     }
  108.  
  109.     /**
  110.      * 根据顾客标识符（id）获得到该顾客所有鲜花信息
  111.      */
  112.     @Override
  113.     public List<Flower> getMyFlower(int ownerId) {
  114.         List<Flower> flowerList = new ArrayList<Flower>();
  115.         String sql = "select * from flower where owner_id=?";
  116.         String[] param = {String.valueOf(ownerId)};
  117.         FlowerDao petDao = new FlowerDaoImpl();
  118.         flowerList = petDao.selectFlower(sql, param);
  119.         return flowerList;
  120.     }
  121. }

文件：src/step7/test/FlowerStoreApp.java

  1. package step7.test;
  2.  
  3. import dbtest.InitDB;
  4. import step7.dao.*;
  5. import step7.dao.impl.*;
  6. import step7.entity.*;
  7. import step7.service.*;
  8. import step7.service.impl.*;
  9.  
  10. import java.util.ArrayList;
  11. import java.util.List;
  12. import java.util.Scanner;
  13.  
  14. public class FlowerStoreApp {
  15.     private static Scanner input = new Scanner(System.in);
  16.  
  17.     public static void main(String[] args) {
  18.         //1-初始化 NySQL 数据库
  19.         InitDB db = new InitDB();
  20.         //2-启动鲜花商店系统
  21.         startFlowerShop();
  22.     }
  23.  
  24.     private static void startFlowerShop() {
  25.         System.out.println("----------------------鲜花商店启动-----------------");
  26.         System.out.println("鲜花信息");
  27.         System.out.println("****************************************************");
  28.         FlowerDao flowerDao = new FlowerDaoImpl();
  29.         List<Flower> flowerList = flowerDao.getAllFlower();
  30.         System.out.println("序号\t" + "鲜花名称\t" + "鲜花品种\t" + "鲜花售价\t" + "");
  31.         for (int i = 0; i < flowerList.size(); i++) {
  32.             Flower flower = flowerList.get(i);
  33.             System.out.println((i + 1) + "\t" + flower.getName() + "\t" + flower.getTypeName() + "\t" + flower.getPrice() + "\t");
  34.         }
  35.         System.out.println("****************************************************");
  36.         System.out.print("\n");
  37.         System.out.println("顾客信息");
  38.         FlowerOwnerDao ownerDao = new FlowerOwnerDaoImpl();
  39.         List<FlowerOwner> ownerList = ownerDao.getAllOwner();
  40.         System.out.println("****************************************************");
  41.         System.out.println("序号\t" + "顾客姓名\t");
  42.         for (int i = 0; i < ownerList.size(); i++) {
  43.             FlowerOwner owner = ownerList.get(i);
  44.             System.out.println((i + 1) + "\t" + owner.getName() + "\t");
  45.         }
  46.         System.out.println("****************************************************");
  47.         System.out.print("\n");
  48.         System.out.println("鲜花商店信息");
  49.         System.out.println("****************************************************");
  50.         FlowerStoreDao storeDao = new FlowerStoreDaoImpl();
  51.         List<FlowerStore> storeList = storeDao.getAllStore();
  52.         System.out.println("序号\t" + "鲜花商店名称\t");
  53.         for (int i = 0; i < storeList.size(); i++) {
  54.             FlowerStore store = storeList.get(i);
  55.             System.out.println((i + 1) + "\t" + store.getName() + "\t");
  56.         }
  57.         System.out.println("****************************************************");
  58.         System.out.print("\n");
  59.         //系统登录
  60.         System.out.println("请选择输入登录模式，输入1为顾客登录，输入2为鲜花商店登录");
  61.         boolean type = true;
  62.         String num;
  63.         while (type) {
  64.             num = input.nextLine();
  65.             if ("1".equals(num)) {
  66.                 ownerLogin();
  67.                 type = false;
  68.             } else if ("2".equals(num)) {
  69.                 storeLogin();
  70.                 type = false;
  71.             } else {
  72.                 System.out.println("输入有误，请按照指定规则输入");
  73.                 System.out.println("请选择登录模式，输入1为顾客登录，输入2为鲜花商店登录");
  74.                 type = true;
  75.             }
  76.         }
  77.     }
  78.  
  79.     //鲜花商店登录
  80.     private static FlowerStore storeLogin() {
  81.         FlowerStoreService fsService = new FlowerStoreServiceImpl();
  82.         FlowerStore flowerStore = null;
  83.         //TODO-1 鲜花商店登录代码实现
  84.         boolean type = true;
  85.         while (type) {
  86.             System.out.println("请先登录，请输入鲜花商店名字：");
  87.             String storeName = input.nextLine().trim();
  88.             System.out.println("请输入鲜花商店的密码：");
  89.             String storePassword = input.nextLine().trim();
  90.             flowerStore = fsService.login(storeName, storePassword);
  91.             if (null != flowerStore) {
  92.                 System.out.println("-------恭喜成功登录-------");
  93.                 System.out.println("-------鲜花商店的基本信息：-------");
  94.                 System.out.println("名字：" + flowerStore.getName());
  95.                 System.out.println("资金：" + flowerStore.getBalance());
  96.                 type = false;
  97.             } else {
  98.                 System.out.println("登录失败，请确认您的用户名和密码是否正确,重新登录");
  99.                 type = true;
  100.             }
  101.         }
  102.  
  103.         System.out.println("您已登录成功，可以进行如下操作");
  104.         StoreChoose(flowerStore);
  105.  
  106.         return flowerStore;
  107.     }
  108.  
  109.     //创建鲜花商店
  110.     private static FlowerStore createFlowerStore(FlowerStore store) {
  111.         FlowerStoreFactory storeFactory = new FlowerStoreFactoryImpl();
  112.         storeFactory.createFlowerStore();
  113.         IsStoreLogOut(store);
  114.  
  115.         return store;//返回的是鲜花商店创建者
  116.     }
  117.  
  118.     private static void IsStoreLogOut(FlowerStore store) {
  119.         System.out.println("您是否继续其它操作若是请输入y,退出请按任意键");
  120.         String code = input.next();
  121.         if (code.equals("y")) {
  122.             StoreChoose(store);
  123.         } else {
  124.             System.out.println("您已成功退出系统");
  125.         }
  126.     }
  127.  
  128.     private static void StoreChoose(FlowerStore store) {
  129.         System.out.println("1：购买鲜花");
  130.         System.out.println("2：卖出鲜花");
  131.         System.out.println("3：培育鲜花");
  132.         System.out.println("4：查询待售鲜花");
  133.         System.out.println("5：查看商店结余");
  134.         System.out.println("6：查看商店账目");
  135.         System.out.println("7：开鲜花商店");
  136.         System.out.println("请根据需要执行的操作，选择序号输入，退出请输入0");
  137.         boolean type = true;
  138.         while (type) {
  139.             int num = input.nextInt();
  140.             switch (num) {
  141.                 case 0:
  142.                     System.out.println("退出成功");
  143.                     type = false;
  144.                     break;
  145.                 case 1:
  146.                     storeBuy(store);
  147.                     type = false;
  148.                     break;
  149.                 case 2:
  150.                     storeSell(store);
  151.                     type = false;
  152.                     break;
  153.                 case 3:
  154.                     storeBread(store);//传入登录的商店
  155.                     type = false;
  156.                     break;
  157.                 case 4:
  158.                     queryFlowerStock(store.getId());
  159.                     type = false;
  160.                     break;
  161.                 case 5:
  162.                     queryStoreBalance(store);
  163.                     type = false;
  164.                     break;
  165.                 case 6:
  166.                     getAccount(store.getId());
  167.                     type = false;
  168.                     break;
  169.                 case 7:
  170.                     createFlowerStore(store);
  171.                     type = false;
  172.                     break;
  173.                 default:
  174.                     System.out.println("输入有误,请重新输入");
  175.                     type = true;
  176.                     break;
  177.             }
  178.         }
  179.     }
  180.  
  181.  
  182.     //获得鲜花商店的资金1代表商店顾客，2顾客卖给商店，3代表顾客之间的交易
  183.     private static FlowerStore getAccount(long id) {
  184.         FlowerStoreService storeService = new FlowerStoreServiceImpl();
  185.         FlowerStore store = storeService.getFlowerStore(id);
  186.         List<Account> list = storeService.account(id);
  187.         for (int i = 0; i < list.size(); i++) {
  188.             Account account = list.get(i);
  189.             String type = null;
  190.             if (1 == account.getDealType()) {
  191.                 type = "商店卖给顾客";
  192.             } else if (2 == account.getDealType()) {
  193.                 type = "顾客卖给商店";
  194.             } else {
  195.                 type = "顾客之间交易";
  196.             }
  197.             System.out.println("第" + (i + 1) + "笔交易,交易类型为：" + type + "，交易金额是:"
  198.                     + account.getPrice());
  199.         }
  200.         IsStoreLogOut(store);
  201.         return store;
  202.     }
  203.  
  204.     //查询商店余额
  205.     private static FlowerStore queryStoreBalance(FlowerStore store) {
  206.         double balance = store.getBalance();
  207.         System.out.println(store.getName() + "鲜花商店的结余为:" + balance);
  208.         IsStoreLogOut(store);
  209.         return store;
  210.     }
  211.  
  212.     //查询待售鲜花
  213.     private static FlowerStore queryFlowerStock(long storeId) {
  214.         FlowerStoreService flowerStoreService = new FlowerStoreServiceImpl();
  215.         FlowerStore store = flowerStoreService.getFlowerStore(storeId);
  216.         Flower flower = null;
  217.         List<Flower> flowerList = flowerStoreService.getFlowersInstock(storeId);
  218.         System.out.println("序号\t" + "鲜花名称\t" + "鲜花类型\t" + "鲜花价格\t");
  219.         for (int i = 0; i < flowerList.size(); i++) {
  220.             flower = flowerList.get(i);
  221.             System.out.println((i + 1) + "\t" + flower.getName() + "\t" + flower.getTypeName() + "\t" + flower.getPrice() + "\t");
  222.         }
  223.         IsStoreLogOut(store);
  224.         return store;
  225.     }
  226.  
  227.     //鲜花商店培育鲜花
  228.     private static FlowerStore storeBread(FlowerStore store) {
  229.         FlowerStoreService flowerStore = new FlowerStoreServiceImpl();
  230.         System.out.println("请输入要培育鲜花的品种(例如:玫瑰))");
  231.         String flowerType = input.next();
  232.         flowerStore.bread(flowerType, store);
  233.         IsStoreLogOut(store);
  234.         return store;
  235.     }
  236.  
  237.     //以商店的身份登录，商店向顾客出售鲜花
  238.     private static void storeSell(FlowerStore store) {
  239.         FlowerStoreService flowerStore = new FlowerStoreServiceImpl();
  240.         Flower flower = null;
  241.         List<Flower> flowerList = flowerStore.getFlowersInstock(store.getId());
  242.         System.out.println("-------以下是鲜花商店正在出售的鲜花-------");
  243.         System.out.println("序号\t" + "鲜花名称\t" + "鲜花类型\t" + "鲜花价格\t");
  244.         for (int i = 0; i < flowerList.size(); i++) {
  245.             flower = flowerList.get(i);
  246.             System.out.println((i + 1) + "\t" + flower.getName() + "\t" + flower.getTypeName() + "\t" + flower.getPrice() + "\t");
  247.         }
  248.         System.out.println("---------请选择要购买的鲜花序号--------");
  249.         boolean type = true;
  250.         while (type) {
  251.             int num = input.nextInt();
  252.             if ((num - 1) < flowerList.size() && (num - 1) >= 0) {
  253.                 flower = flowerList.get(num - 1);
  254.                 System.out.println("------要卖出的鲜花信息如下------");
  255.                 System.out.println("鲜花名称为：" + flower.getName() + " 鲜花类别是：" + flower.getTypeName() + "鲜花价格是:" + flower.getPrice());
  256.                 System.out.println("请确认是否卖出，y代表卖出，n代表不卖");
  257.                 String code = input.next();
  258.                 if (null != code) {
  259.                     if ("y".equals(code)) {
  260.                         System.out.println("------下面是现有顾客买家，请选择您要卖给买家序号------");
  261.                         List<FlowerOwner> ownerList = new ArrayList<FlowerOwner>();
  262.                         FlowerOwnerDao ownerDao = new FlowerOwnerDaoImpl();
  263.                         ownerList = ownerDao.getAllOwner();
  264.                         FlowerOwner flowerOwner = null;
  265.                         System.out.println("序号\t" + "顾客姓名\t");
  266.                         for (int i = 0; i < ownerList.size(); i++) {
  267.                             flowerOwner = ownerList.get(i);
  268.                             System.out.println((i + 1) + "\t" + flowerOwner.getName() + "\t");
  269.                         }
  270.                         num = input.nextInt();
  271.                         if ((num - 1) < ownerList.size() && (num - 1) >= 0) {
  272.                             flowerOwner = ownerList.get(num - 1);
  273.                         }
  274.                         flower.setOwnerId(flowerOwner.getId());
  275.                         flowerStore.sell(flower);
  276.                     } else if ("n".equals(code)) {
  277.                         System.out
  278.                                 .println("--------您选择放弃本次交易，希望您再次光顾----------");
  279.  
  280.                     } else {
  281.                         System.out.println("--------您的输入有误----------");
  282.                     }
  283.                 }
  284.                 type = true;
  285.             } else {
  286.                 System.out.println("输入有误，请按照序号重新输入");
  287.                 type = false;
  288.             }
  289.             type = false;// 标识符更改为false，退出系统
  290.         }
  291.         IsStoreLogOut(store);
  292.     }
  293.  
  294.     //以商店的身份登录，商店找顾客购买鲜花
  295.     private static void storeBuy(FlowerStore store) {
  296.         FlowerStoreService flowerStore = new FlowerStoreServiceImpl();
  297.         Flower flower = null;
  298.         List<Flower> flowerList = flowerStore.getFlowerSelling();
  299.         System.out.println("-------以下是顾客正在出售的鲜花-------");
  300.         System.out.println("序号\t" + "鲜花名称\t" + "鲜花类型\t" + "鲜花价格\t");
  301.         for (int i = 0; i < flowerList.size(); i++) {
  302.             flower = flowerList.get(i);
  303.             System.out.println((i + 1) + "\t" + flower.getName() + "\t" + flower.getTypeName() + "\t" + flower.getPrice() + "\t");
  304.         }
  305.         System.out.println("-------请选择要购买哪一种鲜花，并输入选择项的序号-------");
  306.         int num = input.nextInt();
  307.         flower = flowerList.get(num - 1);
  308.         //System.out.println("选中的鲜花信息"+flower.getName()+"id"+flower.getId());
  309.         flowerStore.buy(flower, store);
  310.         IsStoreLogOut(store);
  311.     }
  312.  
  313.     //顾客登录
  314.     private static FlowerOwner ownerLogin() {
  315.         System.out.println("请先登录，请您输入姓名：");
  316.         String ownerName = input.nextLine().trim();
  317.         System.out.println("请您输入密码：");
  318.         String ownerPassword = input.nextLine().trim();
  319.         FlowerOwnerService flowerOwner = new FlowerOwnerServiceImpl();
  320.         FlowerOwner Owner = flowerOwner.login(ownerName, ownerPassword);
  321.         boolean reg = true;
  322.         while (reg) {
  323.             if (null == Owner) {
  324.                 System.out.println("登录失败，请确认您的用户名和密码后重新输入");
  325.                 System.out.println("请先登录，请您输入姓名：");
  326.                 ownerName = input.nextLine().trim();
  327.                 System.out.println("请您输入密码：");
  328.                 ownerPassword = input.nextLine().trim();
  329.                 Owner = flowerOwner.login(ownerName, ownerPassword);
  330.                 reg = true;
  331.             } else {
  332.                 reg = false;
  333.                 System.out.println("登录成功，您可以购买和卖出鲜花，如果您想购买鲜花请输入1，如果想卖出鲜花请输入2");
  334.                 System.out.println("1：购买鲜花");
  335.                 System.out.println("2：卖出鲜花");
  336.                 boolean type = true;
  337.                 //----------------------
  338.                 FlowerCirculate(type, Owner);
  339.             }
  340.         }
  341.         return Owner;
  342.     }
  343.  
  344.     private static boolean FlowerCirculate(boolean type, FlowerOwner owner) {
  345.         while (type) {
  346.             int num = input.nextInt();
  347.             if (1 == num) {
  348.                 ownerBuy(owner);
  349.                 type = false;
  350.             } else if (2 == num) {
  351.                 ownerSell(owner);
  352.                 type = false;
  353.             } else {
  354.                 System.out.println("输入有误,请重新输入");
  355.                 type = true;
  356.             }
  357.         }
  358.         return type;
  359.     }
  360.  
  361.     //顾客向商店卖鲜花
  362.     private static void ownerSell(FlowerOwner flowerowner) {
  363.         FlowerOwnerService owner = new FlowerOwnerServiceImpl();
  364.         System.out.println("---------我的鲜花列表--------");
  365.         List<Flower> flowerList = owner.getMyFlower(flowerowner.getId());
  366.         System.out.println("序号\t" + "鲜花名称\t" + "鲜花类型\t" + "鲜花价格");
  367.         for (int i = 0; i < flowerList.size(); i++) {
  368.             Flower flower = flowerList.get(i);
  369.             System.out.println((i + 1) + "\t" + flower.getName() + "\t" + flower.getTypeName() + "\t" + flower.getPrice() + "\t");
  370.         }
  371.         System.out.println("---------请选择要出售的鲜花序号--------");
  372.         boolean type = true;
  373.         while (type) {
  374.             int num = input.nextInt();
  375.             if ((num - 1) < flowerList.size() && (num - 1) >= 0) {
  376.                 Flower flower = flowerList.get(num - 1);
  377.                 System.out.println("------您要卖出的鲜花信息如下------");
  378.                 System.out.println("鲜花名字为：" + flower.getName() + "鲜花类别是："
  379.                         + flower.getTypeName() + "鲜花价格为" + flower.getPrice());
  380.  
  381.                 boolean again = true;
  382.                 while (again)//y,n的循环
  383.                 {
  384.                     System.out.println("请确认是否卖出，Y代表卖出，N代表不卖");
  385.                     String code = input.next();
  386.  
  387.                     if (null != code) {
  388.                         if ("Y".equals(code)) {
  389.                             System.out.println("------下面是现有鲜花商店，请选择您要卖的商店序号------");
  390.                             List<FlowerStore> storeList = new ArrayList<FlowerStore>();
  391.                             //TODO-1 通过 Dao层查询所有的鲜花商店   您已成功卖出鲜花
  392.                             
  393.                             FlowerStoreDao storeDao = new FlowerStoreDaoImpl();
  394.                             storeList = storeDao.getAllStore();
  395.  
  396.                             FlowerStore flowerStore = null;
  397.                             System.out.println("序号\t" + "鲜花商店名字\t");
  398.                             for (int i = 0; i < storeList.size(); i++) {
  399.                                 flowerStore = storeList.get(i);
  400.                                 System.out.println((i + 1) + "\t" + flowerStore.getName() + "\t");
  401.                             }
  402.                             num = input.nextInt();
  403.                             if ((num - 1) < storeList.size() && (num - 1) >= 0) {
  404.                                 flowerStore = storeList.get(num - 1);
  405.                             }
  406.                             //TODO-2 要销售的鲜花设置商店 id
  407.                             flower.setStoreId(num);
  408.  
  409.                             //TODO-3 在 service 层顾客卖出该鲜花 Flower
  410.                             owner.sell(flower);
  411.                             
  412.  
  413.                             again = false;//退出 y,n的循环
  414.                         } else if ("N".equals(code)) {
  415.                             System.out.println("--------您选择放弃本次交易，希望您再次光顾----------");
  416.                             again = false;
  417.                         } else {
  418.                             System.out.println("--------您的输入有误,请按照上诉要求输入----------");
  419.                             again = true;
  420.                         }
  421.                     }
  422.                 }//y,n循环结束
  423.             } else {
  424.                 System.out.println("输入有误，请按照序号重新输入");
  425.                 type = true;//重新循环一次
  426.             }
  427.             type = false;
  428.         }
  429.         boolean isLogOut = true;
  430.         System.out.println("您是否要继续进行其它操作，若是请输入Y,否则退出系统");
  431.         String flag = input.next();
  432.         if (flag.equals("Y")) {
  433.             System.out.println("您可以购买和卖出鲜花，如果您想购买鲜花请输入1，如果想卖出鲜花请输入2");
  434.             System.out.println("1：购买鲜花");
  435.             System.out.println("2：卖出鲜花");
  436.             //循环
  437.             FlowerCirculate(isLogOut, flowerowner);
  438.         } else {
  439.             System.out.println("您已成功退出系统");
  440.         }
  441.     }
  442.  
  443.     //顾客找鲜花商店买鲜花
  444.     private static void ownerBuy(FlowerOwner flowerowner) {
  445.         System.out.println("-------请输入选择要购买范围：只需要按照下文要求输入选择项的序号即可--------");
  446.         System.out.println("1：购买库存鲜花");
  447.         System.out.println("2：购买新培育鲜花");
  448.         FlowerStoreService flowerStore = new FlowerStoreServiceImpl();
  449.         FlowerOwnerService flowerOwner = new FlowerOwnerServiceImpl();
  450.         Flower flower = null;
  451.         int num = input.nextInt();
  452.         List<Flower> flowerList = null;
  453.  
  454.         // num为1时购买库存鲜花
  455.         boolean type = true;
  456.         while (type) {
  457.             if (num == 1) {
  458.                 System.out.println(num + "库存鲜花:   -------以下是库存鲜花-------");
  459.                 //通过服务层接口查询库存鲜花
  460.                 flowerList = flowerStore.getFlowersInstock(0);
  461.  
  462.                 //显示所有库存鲜花
  463.                 System.out.println("序号\t" + "鲜花名称\t" + "鲜花类型\t" + "鲜花价格\t");
  464.                 for (int i = 0; i < flowerList.size(); i++) {
  465.                     flower = flowerList.get(i);
  466.                     System.out.println((i + 1) + "\t" + flower.getName() + "\t" + flower.getTypeName() + "\t" + flower.getPrice() + "\t");
  467.                 }
  468.                 System.out.println("-------请选择要购买哪一种鲜花，并输入选择项的序号-------");
  469.                 num = input.nextInt();
  470.                 flower = flowerList.get(num - 1);
  471.                 flower.setOwnerId(flowerowner.getId());
  472.                 flowerOwner.FlowerOwnerbuy(flower);
  473.                 type = false;
  474.             } else if (num == 2) { // num为2时购买新培育鲜花
  475.                 System.out.println(num + "培育鲜花:   -------以下是库存鲜花-------");
  476.                 System.out.println("序号\t" + "鲜花名称\t" + "鲜花类型\t" + "鲜花价格\t");
  477.                 //TODO-1 通过服务层接口查询所有培育鲜花
  478.                 flowerList = flowerStore.getFlowersBread();
  479.  
  480.                 //显示所有培育鲜花
  481.                 for (int i = 0; i < flowerList.size(); i++) {
  482.                     flower = flowerList.get(i);
  483.                     System.out.println((i + 1) + "\t" + flower.getName() + "\t" + flower.getTypeName() + "\t" + flower.getPrice() + "\t");
  484.                 }
  485.                 System.out.println("-------请选择要购买哪一种鲜花，并输入选择项的序号-------");
  486.                 String count = input.next();
  487.                 if (count.matches("[0-9]*")) {
  488.                     num = Integer.parseInt(count);
  489.                     flower = flowerList.get(num - 1);
  490.                     flower.setOwnerId(flowerowner.getId());
  491.                     flowerOwner.FlowerOwnerbuy(flower);
  492.                 }
  493.                 type = false;
  494.             } else {
  495.                 System.out.println("您的输入有误，请按照上诉提示输入");
  496.                 type = true;
  497.             }
  498.  
  499.         }
  500.         boolean isLogOut = true;
  501.         System.out.println("您是否要继续进行其它操作，若是请输入Y,否则输入任意字母退出系统");
  502.         String flag = input.next();
  503.         if (flag.equals("Y")) {
  504.             System.out.println("您可以购买和卖出鲜花，如果您想购买鲜花请输入1，如果想卖出鲜花请输入2");
  505.             System.out.println("1：购买鲜花");
  506.             System.out.println("2：卖出鲜花");
  507.             //循环
  508.             FlowerCirculate(isLogOut, flowerowner);
  509.         } else {
  510.             System.out.println("您已成功退出系统");
  511.         }
  512.     }
  513. }

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/小丑西瓜9/article/detail/419789
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号