接上文“JDBC编程（MVC三层架构）（一） ”
4、控制层
package com.imooc.action;import java.sql.SQLException;import java.util.List;import java.util.Map;import com.imooc.loser.Loser;import com.imooc.model.Goddess;/** * 控制层 * * @author Administrator * */public class GoddessAction { /** * 添加女神 * * @param goddess * 一个女神对象 * @throws SQLException */ public void add(Goddess goddess) throws SQLException { // 创建一个屌丝操作者 Loser loser = new Loser(); // 添加女神 loser.addGoddess(goddess); } /** * 更新女神 * * @param goddess * 一个女神对象 * */ public void update(Goddess goddess) { // 创建一个屌丝操作者 Loser loser = new Loser(); // 更新女神 loser.updateGoddess(goddess); } /** * 删除女神 * * @param ID * 女神的ID号 */ public void del(Integer ID) { // 创建一个屌丝操作者 Loser loser = new Loser(); // 删除女神 loser.delGoddess(ID); } /** * * @return 获取全部女神资料 */ public List<Goddess> query() { // 创建一个屌丝操作者 Loser loser = new Loser(); // 返回女神资料 return loser.query(); } /** * * @param params * 自定义查询条件: connection 连接谓词 ,name 字段名 ,relation 关系词, value 字段值 * @return 获取女神资料 */ public List<Goddess> query(List<Map<String, Object>> params) { // 创建一个屌丝操作者 Loser loser = new Loser(); // 返回女神资料 return loser.query(params); } /** * * @param id * 女神的ID * @return 获得一个女神资料 */ public Goddess get(Integer id) { // 创建一个屌丝操作者 Loser loser = new Loser(); // 通过ID获得女神资料 return loser.get(id); }}　　5、视图层
package com.imooc.view;import java.sql.SQLException;import java.text.ParseException;import java.text.SimpleDateFormat;import java.util.ArrayList;import java.util.Date;import java.util.HashMap;import java.util.List;import java.util.Map;import java.util.Scanner;import com.imooc.action.GoddessAction;import com.imooc.model.Goddess;/** * 视图层 * * @author Administrator * */public class View { private static final String CONTEXT = "******欢迎来到女神禁区******\n" + "下面是女神禁区的功能列表\n" + "[MAIN/M]:主菜单\n" + "[QUERY/Q]:查看全部女神的基本信息\n" + "[GET/G]:查看某位女神的详细信息\n" + "[ADD/A]:添加女神信息\n" + "[UPDATE/U]:更新女神信息\n" + "[DELETE/D]:删除女神信息\n" + "[SERACH/S]:查询女神信息（根据姓名、手机号来查询）\n" + "[EXIT/E]:退出女神禁区\n" + "[BREAK]:退出当前功能，返回主菜单"; private static final String OPERATION_MAIN = "MAIN"; private static final String OPERATION_QUERY = "QUERY"; private static final String OPERATION_GET = "GET"; private static final String OPERATION_ADD = "ADD"; private static final String OPERATION_UPDATE = "UPDATE"; private static final String OPERATION_DELETE = "DELETE"; private static final String OPERATION_SEARCH = "SEARCH"; private static final String OPERATION_EXIT = "EXIT"; private static final String OPERATION_BREAK = "BREAK"; public static void main(String[] args) { // 菜单 System.out.println(CONTEXT); // Scanner对象 Scanner scan = new Scanner(System.in); // 女神 Goddess goddess = null; // 女神 Goddess goddessOld = null; // 操作 GoddessAction action = new GoddessAction(); // 前一个功能 String previous = null; // 输入的内容 String in = null; // 计数 Integer step = 1; // 输入检索字段 String inputMessage = null; // 进入某一个功能的标识，进入true，未进入flase boolean into = false; while (scan.hasNext()) { // 键盘输入的值 in = scan.next().toString(); if ((OPERATION_EXIT.equals(in.toUpperCase())// ***退出*** || OPERATION_EXIT.substring(0, 1).equals(in.toUpperCase())) && (into == false)) { System.out.println("您已成功退出女神禁区！"); break; } else if (OPERATION_BREAK.equals(in.toUpperCase()))// ***中断**务必放在其他功能的前面** { step = 1; // 恢复到初始值 previous = null; // 恢复到初始值 goddess = null; // 恢复到初始值 into = false; // 恢复到初始值 System.out.println("您已退出当前功能，且已返回主菜单！！！"); } else if (((OPERATION_SEARCH.equals(in.toUpperCase())// ***检索*** || OPERATION_SEARCH.substring(0, 1).equals(in.toUpperCase())) && (into == false)) || OPERATION_SEARCH.equals(previous)) { previous = OPERATION_SEARCH; List<Map<String, Object>> maps = null; Map<String, Object> map = null; List<Goddess> goddesses = null; if (step == 1) { into = true; System.out.println("请输入要查询的字段：\n" + "[NAME]姓名\n" + "[MOBILE]手机号"); } if (step == 2) { inputMessage = in.toUpperCase(); if ("NAME".equals(in.toUpperCase())) { System.out.println("请输入要查询女神的姓名："); } else if ("MOBILE".equals(in.toUpperCase())) { System.out.println("请输入查询女神的手机号："); } else { System.out.println("您输入的字段名错误，请重新输入"); step = 1; } } if (step == 3) { if ("NAME".equals(inputMessage)) { System.out.println("请输入要查询的姓名："); maps = new ArrayList<Map<String, Object>>(); map = new HashMap<String, Object>(); map.put("connection", "AND"); map.put("name", "user_name"); map.put("relation", "LIKE"); map.put("value", "'%" + in + "%'"); maps.add(map); goddesses = action.query(maps); } else if ("MOBILE".equals(inputMessage)) { maps = new ArrayList<Map<String, Object>>(); map = new HashMap<String, Object>(); map.put("connection", "AND"); map.put("name", "mobile"); map.put("relation", "LIKE"); map.put("value", "'%" + in + "%'"); maps.add(map); goddesses = action.query(maps); } for (Goddess g : goddesses) { // 显示女神详细资料 System.out.print("编号："); if (g.getId() != null) { System.out.print(g.getId()); } System.out.print("\n姓名："); if (g.getUser_name() != null) { System.out.print(g.getUser_name()); } System.out.print("\n性别："); if (g.getSex() != null) { if (g.getSex() > 0) { System.out.print("女"); } else { System.out.print("男"); } } System.out.print("\n年龄："); if (g.getAge() != null) { System.out.print(g.getAge()); } System.out.print("\n生日："); if (g.getBirthday() != null) { System.out.print(g.getBirthday()); } System.out.print("\n邮箱："); if (g.getEmail() != null) { System.out.print(g.getEmail()); } System.out.print("\n电话号码："); if (g.getMobile() != null) { System.out.print(g.getMobile() + "\n"); } else { System.out.println("\n"); } } step = 1; // 恢复初始值 previous = null;// 恢复初始值 into = false; // 恢复初始值 } if (OPERATION_SEARCH.equals(previous)) { step++; } } else if ((OPERATION_MAIN.equals(in.toUpperCase())// ***返回主菜单*** || OPERATION_MAIN.substring(0, 1).equals(in.toUpperCase())) && (into == false)) { System.out.println(CONTEXT); } else if ((OPERATION_QUERY.equals(in.toUpperCase())// ***查询*** || OPERATION_QUERY.substring(0, 1).equals(in.toUpperCase())) && (into == false)) { List<Goddess> g = action.query(); System.out.println("**下面是禁区女神的基本信息**"); for (Goddess go : g) { System.out.println("编号：" + go.getId() + ",姓名：" + go.getUser_name()); } } else if (((OPERATION_DELETE.equals(in.toUpperCase())// ***删除*** || OPERATION_DELETE.substring(0, 1).equals(in.toUpperCase())) && (into == false)) || OPERATION_DELETE.equals(previous)) { previous = OPERATION_DELETE; if (step == 1) { into = true; System.out.println("请输入女神的编号（可删除多个女神资料，用英文逗号分隔，如:1,2,3）："); } else if (step == 2) { goddess = new Goddess(); boolean flag = false; // true 找到女神的资料，false未找到女神的资料 try { String[] ids = in.split(","); for (String id : ids) { // 获得女神的资料 goddess = action.get(Integer.parseInt(id)); if (goddess != null) { // 删除女神资料 flag = true; action.del(Integer.parseInt(id)); } } if (flag) { System.out.println("女神信息删除成功！！！"); } else { System.out.println("未找到女神信息，删除失败！！！"); } step = 1; // 恢复到初始值 previous = null; // 恢复到初始值 goddess = null; // 恢复到初始值 into = false; // 恢复到初始值 } catch (NumberFormatException e) {// 捕获异常 step = 1; System.out.println("请输入数字,用英文逗号分隔，如:1,2,3！！！"); } } if (OPERATION_DELETE.equals(previous)) { step++; } } else if (((OPERATION_GET.equals(in.toUpperCase())// ***查询一个女神详细信息*** || OPERATION_GET.substring(0, 1).equals(in.toUpperCase())) && (into == false)) || OPERATION_GET.equals(previous)) { previous = OPERATION_GET; if (step == 1) { into = true; System.out.println("请输入女神的编号来查看女神的详细信息："); } else if (step == 2) { goddess = new Goddess(); try { // 检测是否正确输入数字 goddess = action.get(Integer.parseInt(in)); if (goddess != null) { // 显示女神详细资料 System.out.print("编号："); if (goddess.getId() != null) { System.out.print(goddess.getId()); } System.out.print("\n姓名："); if (goddess.getUser_name() != null) { System.out.print(goddess.getUser_name()); } System.out.print("\n性别："); if (goddess.getSex() != null) { if (goddess.getSex() > 0) { System.out.print("女"); } else { System.out.print("男"); } } System.out.print("\n年龄："); if (goddess.getAge() != null) { System.out.print(goddess.getAge()); } System.out.print("\n生日："); if (goddess.getBirthday() != null) { System.out.print(goddess.getBirthday()); } System.out.print("\n邮箱："); if (goddess.getEmail() != null) { System.out.print(goddess.getEmail()); } System.out.print("\n电话号码："); if (goddess.getMobile() != null) { System.out.print(goddess.getMobile() + "\n"); } else { System.out.println("\n"); } } else { System.out.println("编号是" + Integer.parseInt(in) + "的女神资料不存在！！！"); } step = 1; // 恢复到初始值 previous = null; // 恢复到初始值 goddess = null; // 恢复到初始值 into = false; // 恢复到初始值 } catch (NumberFormatException e) {// 捕获异常 step = 1; System.out.println("请输入数字！！！"); } } if (OPERATION_GET.equals(previous)) { step++; } } else if (((OPERATION_UPDATE.equals(in.toUpperCase())// ***更新*** || OPERATION_UPDATE.substring(0, 1).equals(in.toUpperCase())) && (into == false)) || OPERATION_UPDATE.equals(previous)) { previous = OPERATION_UPDATE; if (step == 1) { into = true; System.out.println("请输入要更新的女神编号:"); } else if (step == 2) { try { // 旧值 goddessOld = action.get(Integer.parseInt(in)); if (goddessOld != null) { goddess = new Goddess(); goddess.setId(Integer.parseInt(in)); System.out.println("请输入女神的[姓名](如果不更新该字段,请输入null):"); } else { System.out.println("女神资料不存在,请重新输入女神的编号！！！"); step = 1; // 提示重新输入女神编号 } } catch (NumberFormatException e) { step = 1; // 提示重新输入女神编号 System.out.println("请输入数字！！！"); } } else if (step == 3) { if (!in.equals("null")) { goddess.setUser_name(in); } else { goddess.setUser_name(goddessOld.getUser_name()); } System.out.println("请输入女神的[年龄](如果不更新该字段,请输入-1):"); } else if (step == 4) { try { if (Integer.parseInt(in) != -1) { goddess.setAge(Integer.parseInt(in)); } else { goddess.setAge(goddessOld.getAge()); } System.out .println("请输入女神的[生日],格式如：yyyy-MM-dd(如果不更新该字段,请输入0000-00-00):"); } catch (NumberFormatException e) { step = 3; // 提示重新输入年龄 System.out.println("请输入数字！！！"); } } else if (step == 5) { // 格式化日期 SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); try { // 日期对象 Date birthday = sdf.parse(in); if (!birthday.toString().equals("0000-00-00")) { goddess.setBirthday(birthday); } else { goddess.setBirthday(goddessOld.getBirthday()); } System.out.println("请输入女神的[邮箱](如果不更新该字段,请输入null):"); } catch (ParseException e) { step = 4;// 重新提示输入日期信息 System.out.println("您输入的日期格式错误,请重新输入！"); } } else if (step == 6) { if (!in.equals("null")) { goddess.setEmail(in); } else { goddess.setEmail(goddessOld.getEmail()); } System.out.println("请输入女神的[手机](如果不更新该字段,请输入null):"); } else if (step == 7) { if (!in.equals("null")) { goddess.setMobile(in); } else { goddess.setMobile(goddessOld.getMobile()); } action.update(goddess); System.out.println("女神信息更新成功！！！"); step = 1; // 恢复到初始值 previous = null; // 恢复到初始值 goddess = null; // 恢复到初始值 goddessOld = null; // 恢复到初始值 into = false; // 恢复到初始值 } if (OPERATION_UPDATE.equals(previous)) { step++; } } else if (((OPERATION_ADD.equals(in.toUpperCase())// ***新增*** || OPERATION_ADD.substring(0, 1).equals(in.toUpperCase())) && (into == false)) || OPERATION_ADD.equals(previous)) { previous = OPERATION_ADD; if (step == 1) { System.out.println("请输入女神的[姓名]:"); into = true; } else if (step == 2) { goddess = new Goddess(); goddess.setUser_name(in); System.out.println("请输入女神的[年龄]:"); } else if (step == 3) { try { goddess.setAge(Integer.parseInt(in)); System.out.println("请输入女神的[生日],格式如：yyyy-MM-dd:"); } catch (NumberFormatException e) { step = 2; // 提示重新输入年龄 System.out.println("请输入数字！！！"); } } else if (step == 4) { // 格式化日期 SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); try { // 日期对象 Date birthday = sdf.parse(in); // 添加日期 goddess.setBirthday(birthday); System.out.println("请输入女神的[邮箱]:"); } catch (ParseException e) { step = 3;// 重新提示输入日期信息 System.out.println("您输入的日期格式错误,请重新输入！"); } } else if (step == 5) { goddess.setEmail(in); System.out.println("请输入女神的[手机号]:"); } else if (step == 6) { goddess.setMobile(in); try { action.add(goddess); System.out.println("女神信息添加成功！！！"); } catch (SQLException e) { e.printStackTrace(); System.out.println("女神信息添加失败！！！"); } step = 1; // 恢复到初始值 previous = null; // 恢复到初始值 goddess = null; // 恢复到初始值 into = false; // 恢复到初始值 } // 只有是增加时才计数 if (OPERATION_ADD.equals(previous)) { step++; } } else { System.out.println("您输入的代号有误，请重新输入！！！"); } } }}