java jdbc 连接数据库 crud操作

package com.java.jdbc; import com.java.jdbc.dao.AuserDao; import com.java.jdbc.dao.impl.AuserDaoImpl; import com.java.jdbc.pojo.Auser; import java.util.ArrayList; import java.util.List; import java.util.Scanner; public class JDBCTest { public static void main(String[] args) { while (true) { List<Auser> list = null; Scanner scan = new Scanner(System.in); System.out.println("1、增加 2、修改 3、删除 4、通过姓名查询 5、查询全部"); System.out.print("请输入您的操作："); String operationId = scan.nextLine(); AuserDao auserDao = new AuserDaoImpl(); try { switch (operationId) { case "1": List<Auser> insList = new ArrayList<>(); int count = 0; int sum = 0; System.out.println("1、填写信息以空格隔开"); System.out.println("2、批量输入完成后输入 y 进行结束"); System.out.println("请按照：姓名 性别 年龄 部门 级别 进行输入:"); while (true) { String insStr = scan.nextLine(); String[] insStrs = insStr.split("\\s+"); if (insStrs.length == 1 && "y".equals(insStrs[0].toLowerCase())) { break; } else if (insStrs.length == 5) { Auser insAuser = new Auser(); insAuser.setName(insStrs[0]); insAuser.setSex(insStrs[1]); insAuser.setAge(Integer.parseInt(insStrs[2])); insAuser.setDepartment(insStrs[3]); insAuser.setLevel(insStrs[4]); insList.add(insAuser); sum++; } else { System.out.println("输入本条信息有误，请重新输入"); } } for (Auser auser : insList) { Auser insert = auserDao.insert(auser); if (insert.getId() > 0) count++; } System.out.println("共添加" + sum + "条数据，成功添加" + count + "条数据"); break; case "2": list = auserDao.list(); Auser updAuser = new Auser(); for (Auser auser : list) { System.out.println("ID:" + auser.getId() + " 姓名:" + auser.getName() + " 性别:" + auser.getSex() + " 年龄:" + auser.getAge() + " 部门:" + auser.getDepartment() + " 级别:" + auser.getLevel()); } System.out.print("请输入需要修改的id："); String updateIdStr = scan.nextLine(); int updateId = Integer.parseInt(updateIdStr); Auser auserByUpd = auserDao.findById(updateId); if (auserByUpd == null) { System.out.println("请正确输入修改id"); break; } System.out.println("请输入修改内容（填写信息以空格隔开）："); String updateStr = scan.nextLine(); String[] updStrs = updateStr.split("\\s+"); if (updStrs.length == 5) { updAuser.setId(updateId); updAuser.setName(updStrs[0]); updAuser.setSex(updStrs[1]); updAuser.setAge(Integer.parseInt(updStrs[2])); updAuser.setDepartment(updStrs[3]); updAuser.setLevel(updStrs[4]); } else { System.out.println("输入信息有误，请重新操作"); } Auser update = auserDao.update(updAuser); if (update.getId() > 0) { System.out.println("操作成功"); } break; case "3": list = auserDao.list(); for (Auser auser : list) { System.out.println("ID:" + auser.getId() + " 姓名:" + auser.getName() + " 性别:" + auser.getSex() + " 年龄:" + auser.getAge() + " 部门:" + auser.getDepartment() + " 级别:" + auser.getLevel()); } System.out.print("请输入需要删除的id："); String deleteIdStr = scan.nextLine(); int deleteId = Integer.parseInt(deleteIdStr); boolean delete = auserDao.delete(deleteId); if (delete) { System.out.println("删除成功"); } else { System.out.println("删除失败，请核对对应编号"); } break; case "4": System.out.print("请输入姓名："); String name = scan.nextLine(); list = auserDao.findByName(name); for (Auser auser : list) { System.out.println("ID:" + auser.getId() + " 姓名:" + auser.getName() + " 性别:" + auser.getSex() + " 年龄:" + auser.getAge() + " 部门:" + auser.getDepartment() + " 级别:" + auser.getLevel()); } break; case "5": list = auserDao.list(); for (Auser auser : list) { System.out.println("ID:" + auser.getId() + " 姓名:" + auser.getName() + " 性别:" + auser.getSex() + " 年龄:" + auser.getAge() + " 部门:" + auser.getDepartment() + " 级别:" + auser.getLevel()); } break; } } catch (Exception e) { System.out.println("请正确输入"); } } } }