基于struts2的宠物诊所系统

package dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import dto.History; import dto.Pet; import dto.PetType; import factory.DBConnection; public class PetDAO { public static boolean addPet(Pet pet){ Connection conn = null; PreparedStatement ps = null; int rs = 0; boolean flag=false; try { conn = DBConnection.getConn(); ps = conn.prepareStatement("insert into tb_pet(pet_name,pet_type,pet_birthday,pet_master) values(?,?,?,?)"); ps.setString(1,pet.getPet_name()); ps.setInt(2, pet.getPet_type_index()); ps.setString(3, pet.getPet_birthday()); ps.setString(4, pet.getPet_master()); rs = ps.executeUpdate(); if(rs==1) { flag=true; } } catch (SQLException e) { e.printStackTrace(); } return flag; } public static boolean delPet(Pet pet){ Connection conn = null; PreparedStatement ps = null; int rs = 0; boolean flag=false; try { conn = DBConnection.getConn(); ps = conn.prepareStatement("delete from tb_pet where pet_id=?"); ps.setInt(1, Integer.parseInt(pet.getPet_id())); rs = ps.executeUpdate(); if(rs==1) { flag=true; } } catch (SQLException e) { e.printStackTrace(); } return flag; } public static boolean updatePet(Pet pet){ Connection conn = null; PreparedStatement ps = null; int rs = 0; boolean flag=false; try { conn = DBConnection.getConn(); ps = conn.prepareStatement("update tb_pet set pet_name=?,pet_type=?,pet_birthday=?,pet_master=? where pet_id=?"); ps.setString(1, pet.getPet_name()); ps.setInt(2, pet.getPet_type_index()); ps.setString(3, pet.getPet_birthday()); ps.setString(4, pet.getPet_master()); ps.setInt(5, Integer.parseInt(pet.getPet_id())); rs = ps.executeUpdate(); if(rs==1) { flag=true; } } catch (SQLException e) { e.printStackTrace(); } return flag; } public static List<Pet> querryAll(){ List<Pet> petlist=new ArrayList<Pet>(); Connection conn = null; PreparedStatement ps = null; ResultSet rs = null; Pet pet=null; try { conn = DBConnection.getConn(); ps = conn.prepareStatement("select a.*,b.type_name from tb_pet a,tb_pet_type b where a.pet_type=b.type_id"); rs = ps.executeQuery(); while(rs.next()) { pet =new Pet(); pet.setPet_id(rs.getString("pet_id")); pet.setPet_name(rs.getString("pet_name")); pet.setPet_type(rs.getString("type_name")); pet.setPet_birthday(rs.getString("pet_birthday")); pet.setPet_master(rs.getString("pet_master")); petlist.add(pet); } } catch (SQLException e) { e.printStackTrace(); } return petlist; } public static List<Pet> querryByName(Pet pet){ List<Pet> petlist=new ArrayList<Pet>(); Connection conn = null; PreparedStatement ps = null; ResultSet rs = null; Pet returnpet=null; try { conn = DBConnection.getConn(); ps = conn.prepareStatement("select a.*,b.type_name from tb_pet a,tb_pet_type b where a.pet_type=b.type_id and pet_name=?"); ps.setString(1, pet.getPet_name()); rs = ps.executeQuery(); while(rs.next()) { returnpet =new Pet(); returnpet.setPet_id(rs.getString("pet_id")); returnpet.setPet_name(rs.getString("pet_name")); returnpet.setPet_type(rs.getString("type_name")); returnpet.setPet_birthday(rs.getString("pet_birthday")); returnpet.setPet_master(rs.getString("pet_master")); petlist.add(returnpet); } } catch (SQLException e) { e.printStackTrace(); } return petlist; } //通过主人名检索 public static List<Pet> querryByMaterName(Pet pet){ List<Pet> petlist=new ArrayList<Pet>(); Connection conn = null; PreparedStatement ps = null; ResultSet rs = null; Pet returnpet=null; try { conn = DBConnection.getConn(); ps = conn.prepareStatement("select a.*,b.type_name from tb_pet a,tb_pet_type b where a.pet_type=b.type_id and pet_master=?"); ps.setString(1, pet.getPet_master()); rs = ps.executeQuery(); while(rs.next()) { returnpet =new Pet(); returnpet.setPet_id(rs.getString("pet_id")); returnpet.setPet_name(rs.getString("pet_name")); returnpet.setPet_type(rs.getString("type_name")); returnpet.setPet_birthday(rs.getString("pet_birthday")); returnpet.setPet_master(rs.getString("pet_master")); petlist.add(returnpet); } } catch (SQLException e) { e.printStackTrace(); } return petlist; } public static Pet querryById(Integer id){ Connection conn = null; PreparedStatement ps = null; ResultSet rs = null; Pet returnpet=null; try { conn = DBConnection.getConn(); ps = conn.prepareStatement("select a.*,b.type_name from tb_pet a,tb_pet_type b where a.pet_type=b.type_id and pet_id=?"); ps.setInt(1, id); rs = ps.executeQuery(); if(rs.next()) { returnpet =new Pet(); returnpet.setPet_id(rs.getString("pet_id")); returnpet.setPet_name(rs.getString("pet_name")); returnpet.setPet_type(rs.getString("type_name")); returnpet.setPet_birthday(rs.getString("pet_birthday")); returnpet.setPet_master(rs.getString("pet_master")); returnpet.setPet_type_index(rs.getInt("pet_type")); } } catch (SQLException e) { e.printStackTrace(); } return returnpet; } public static List<PetType> getType(){ List<PetType> typelist=new ArrayList<PetType>(); Connection conn = null; PreparedStatement ps = null; ResultSet rs = null; PetType petType=null; try { conn = DBConnection.getConn(); ps = conn.prepareStatement("select * from tb_pet_type "); rs = ps.executeQuery(); while(rs.next()) { petType=new PetType(); petType.setType_id(rs.getInt("type_id")); petType.setType_name(rs.getString("type_name")); typelist.add(petType); } } catch (SQLException e) { e.printStackTrace(); } return typelist; } //添加病历 public static boolean addPetRecord(History his){ Connection conn = null; PreparedStatement ps = null; int rs = 0; boolean flag=false; try { conn = DBConnection.getConn(); ps = conn.prepareStatement("insert into tb_clinic_history(pet_id,record_details,record_doctor) values(?,?,?)"); ps.setInt(1, his.getPet_id()); ps.setString(2, his.getRecord_details()); ps.setString(3, his.getRecord_doctor()); rs = ps.executeUpdate(); if(rs==1) { flag=true; } } catch (SQLException e) { e.printStackTrace(); } return flag; } //查询病历 public static List<History> getHistory(Pet pet){ List<History> hislist=new ArrayList<History>(); Connection conn = null; PreparedStatement ps = null; ResultSet rs = null; History his=null; try { conn = DBConnection.getConn(); ps = conn.prepareStatement("select * from tb_clinic_history where pet_id=?"); ps.setInt(1, Integer.parseInt(pet.getPet_id())); rs = ps.executeQuery(); while(rs.next()) { his=new History(); his.setRecord_id(rs.getInt("record_id")); his.setRecord_time(rs.getString("record_time")); his.setRecord_details(rs.getString("record_details")); his.setRecord_doctor(rs.getString("record_doctor")); hislist.add(his); } } catch (SQLException e) { e.printStackTrace(); } return hislist; } }