1publicvoidmenu()2{3do{4System.out.println("\t==========宠物管理系统==========");5System.out.println("\t1.添加宠物\n\t2.更新健康值和亲密度\n\t3.查看宠物信息\n\t4.删除宠物信息\n\t5.退出");6System.out.print("请选择：");7intchoose=input.nextInt();8switch(choose){9case1:10System.out.println("\t========添加宠物========");11add();12continue;13case2:14System.out.println("2");1516continue;17case3:18show();19continue;20case4:21delete();22continue;23case5:24System.out.println("拜拜！");25break;26default:27System.out.println("选择错误！");28continue;29}30break;31}while(true);32}添加宠物方法
1publicvoidadd()2{3getConnection();4try{5ps=con.prepareStatement("insertintodog(name,strain,health,love)values(,,,)");6System.out.print("请输入狗狗昵称：");7Stringname=input.next();8System.out.print("请输入品种:");9Stringbrand=input.next();10System.out.print("请输入健康值：");11inthy=input.nextInt();12System.out.print("请输入亲密值：");13intlove=input.nextInt();14ps.setString(1,name);15ps.setString(2,brand);16ps.setInt(3,hy);17ps.setInt(4,love);18intcount=ps.executeUpdate();19if(count>0){20System.out.println("添加成功！");21show();22}else23{24System.out.println("添加失败！");25}2627}catch(SQLExceptione){28//TODOAuto-generatedcatchblock29e.printStackTrace();30}finally31{32try{33ps.close();34}catch(SQLExceptione){35//TODOAuto-generatedcatchblock36e.printStackTrace();37}38}39}展示所有宠物信息方法
1publicvoidshow()2{3getConnection();4try{5System.out.println("******************狗狗信息表******************");6System.out.println("编号\t姓名\t健康值\t亲密度\t品种");7ps=con.prepareStatement("select*fromdog");8rs=ps.executeQuery();9while(rs.next()){10System.out.print(rs.getInt(1)+"\t");11System.out.print(rs.getString(2)+"\t");12System.out.print(rs.getInt(3)+"\t");13System.out.print(rs.getInt(4)+"\t");14System.out.println(rs.getString(5)+"\t");15}16}catch(SQLExceptione){17//TODOAuto-generatedcatchblock18e.printStackTrace();19}20finally21{22try{23con.close();24rs.close();25ps.close();26}catch(SQLExceptione){27//TODOAuto-generatedcatchblock28e.printStackTrace();29}3031}32}删除宠物方法
1publicvoiddelete()2{3try{4ps=con.prepareStatement("deletefromdogwhereid=");5System.out.println("请输入你要删除的狗狗id");6intid=input.nextInt();7ps.setInt(1,id);8ps.setInt(1,9);9intcount=ps.executeUpdate();10if(count>0){11System.out.println("删除成功！");12show();13}else14{15System.out.println("删除失败！");16}17}catch(SQLExceptione){18//TODOAuto-generatedcatchblock19e.printStackTrace();20}2122}调用方法
1publicstaticvoidmain(String[]args){2//TODOAuto-generatedmethodstub3Connconn=newConn();4conn.menu();5}