Spring整合Mybatis项目-影视资源管理

package top.wyyblog.demo; import java.util.List; import java.util.Scanner; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; import top.wyyblog.bean.Resourse; import top.wyyblog.bean.Type; import top.wyyblog.dao.ResourseMapper; import top.wyyblog.dao.TypeMapper; public class Demo { public static void main(String[] args) { start(); } private static void start() { boolean flag = true; while (flag) { System.out.println("-----------------------------------------当前资源说明-------------------------------------"); List<Type> types = getTypeMapper().findAll(); for (Type type : types) { System.out.println(type); } System.out.println("1.查询全部资源"); System.out.println("2.分类查询资源"); System.out.println("3.增添资源"); System.out.println("4.修改资源"); System.out.println("5.删除资源"); System.out.println("其他.退出程序"); Scanner scanner = new Scanner(System.in); int n = scanner.nextInt(); switch (n) { case 1: findAllResourse(); break; case 2: findTypeResourse(); break; case 3: addResourse(); break; case 4: updateResourse(); break; case 5: deleteResourse(); break; default: System.out.println("退出本程序"); flag = false; break; } } } /** * 插入资源 */ private static void addResourse() { Resourse resourse = addInputResourse(); if (resourse == null) { return; } int result = getResourseMapper().addResourse(resourse); if (result > 0) { System.out.println("插入成功"); getTypeMapper().updateCountById(resourse.getType()); } else { System.out.println("插入失败"); } System.out.println("---------------------------------------------------------------------------------------"); } /** * 删除资源 */ private static void deleteResourse() { Scanner scanner = new Scanner(System.in); int id = 0; System.out.println("------------------------------------------输入ID---------------------------------------"); try { id = scanner.nextInt(); } catch (Exception e) { System.out.println("输入不合法"); return; } Resourse resourse = getResourseMapper().findById(id); int result = getResourseMapper().deleteResourse(id); if (result > 0) { System.out.println("删除成功"); getTypeMapper().updateCountById(resourse.getType()); } else { System.out.println("删除失败"); } System.out.println("---------------------------------------------------------------------------------------"); } /** * 更新资源 */ private static void updateResourse() { Resourse resourse = UpdateInputResourse(); if (resourse == null) { return; } int result = getResourseMapper().updateResourse(resourse); if (result > 0) { System.out.println("修改成功"); } else { System.out.println("修改失败"); } System.out.println("---------------------------------------------------------------------------------------"); } /** * 查询指定分类的资源 * * @param type */ private static void findTypeResourse() { Scanner scanner = new Scanner(System.in); int type = 0; System.out.println("------------------------------------------输入类型ID-------------------------------------"); try { type = scanner.nextInt(); } catch (Exception e) { System.out.println("输入不合法"); return; } System.out.println("------------------------------------------查询结果---------------------------------------"); List<Resourse> resourses = getResourseMapper().findAllByType(type); for (Resourse resourse : resourses) { System.out.println(resourse); } System.out.println("---------------------------------------------------------------------------------------"); } /** * 输入要修改的资源参数 * * @return 返回资源 */ private static Resourse UpdateInputResourse() { Resourse resourse; System.out.println( "----------------------请输入资源,格式: id,name,context,type,score,date -----------------------------"); Scanner scanner = new Scanner(System.in); String[] strings = scanner.next().split(","); try { resourse = new Resourse(Integer.parseInt(strings[0]), strings[1], strings[2], Integer.parseInt(strings[3]), Double.valueOf(strings[4]), strings[5]); } catch (Exception e) { System.out.print("输入格式错误!!!"); return null; } return resourse; } private static Resourse addInputResourse() { Resourse resourse; System.out.println( "----------------------请输入资源,格式: name,context,type,score,date -----------------------------"); Scanner scanner = new Scanner(System.in); String[] strings = scanner.next().split(","); try { resourse = new Resourse( strings[0], strings[1], Integer.parseInt(strings[2]), Double.valueOf(strings[3]), strings[4]); } catch (Exception e) { System.out.print("输入格式错误!!!"); return null; } return resourse; } /** * 查询全部资源 */ private static void findAllResourse() { System.out.println("------------------------------------------查询结果---------------------------------------"); List<Type> types = getTypeMapper().findAll(); for (Type type : types) { System.out.println(type); List<Resourse> resourses = getResourseMapper().findAllByType(type.getId()); for (Resourse resourse : resourses) { System.out.println(resourse); } } System.out.println("---------------------------------------------------------------------------------------"); } private static ResourseMapper getResourseMapper() { ApplicationContext context = new ClassPathXmlApplicationContext("beans.xml"); ResourseMapper resourseMapper = (ResourseMapper) context.getBean("resourseMapper"); return resourseMapper; } private static TypeMapper getTypeMapper() { ApplicationContext context = new ClassPathXmlApplicationContext("beans.xml"); TypeMapper typeMapper = (TypeMapper) context.getBean("typeMapper"); return typeMapper; } }