基于Mysql数据库的实现,要完成一个宠物管理系统,这是要求
以下是我完成的部分功能
package com.gg.pet.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
import com.gg.entity.Pet;
import com.gg.jdbc.helper.DBHelper;
public class PetDao {
//1 显示所有的宠物
public static List<Pet> showAllPets() throws Exception{
List<Pet> pets = new ArrayList<Pet>();
//1
Connection con = DBHelper.getConnection();
//2 SQL
String sql = "select * from pet ";
//3
PreparedStatement ps = con.prepareStatement(sql);
ResultSet rs= ps.executeQuery();
while(rs.next()) {
String pid = rs.getString("pid");
String pname = rs.getString("pname");
String pgender = rs.getString("pgender");
int page = rs.getInt("page");
Pet pet = new Pet(pid, pname, page, pgender);
pets.add(pet);
}
return pets ;
}
//2
//3
//4
}
package com.gg.pet.view;
import java.util.List;
import java.util.Scanner;
import com.gg.entity.Pet;
import com.gg.pet.dao.PetDao;
public class MainView {
//主界面
public static void showMainView() throws Exception {
while(true) {
Scanner scanner = new Scanner(System.in);
System.out.println("请选择 1~4 ");
System.out.println("**********************************");
System.out.println("* 1.显示所用宠物 *");
System.out.println("* 2.添加宠物 *");
System.out.println("* 3.按编号修改宠物 *");
System.out.println("* 4.按编号删除宠物 *");
System.out.println("* *");
System.out.println("* *");
System.out.println("**********************************");
int number = scanner.nextInt();
switch (number) {
case 1:
List<Pet> pets = PetDao.showAllPets();
for (Pet pet : pets) {
System.out.println(pet);
}
break;
case 2:
break;
case 3:
break;
case 4:
break;
default:
System.out.println("输入有问题!!!");
break;
}
}
}
}