jsp宠物管理系统源码（含数据库脚本).rar

package cn.jbit.pet.dao.impl; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import cn.jbit.pet.dao.BaseDao; import cn.jbit.pet.dao.PetDao; import cn.jbit.pet.entity.Pet; import cn.jbit.pet.util.DatabaseUtil; public class PetDaoImpl extends BaseDao implements PetDao { @Override public List<Pet> petInfo() { List<Pet> petList = new ArrayList<Pet>(); ResultSet rs = null; Pet pet = null; String sql = "SELECT petId,petName,petBreed,petSex,birthday,description FROM pet"; try { rs = this.executeQuery(sql); // List<Pet> petList = new ArrayList<Pet>(); // ResultSet rs = null; // PreparedStatement pstm = null; // Pet pet = null; // String sql = "SELECT petId,petName,petBreed,petSex,birthday,description FROM pet"; // try { // pstm = DatabaseUtil.getConnection().prepareStatement(sql); // rs = pstm.executeQuery(); while (rs.next()) { pet = new Pet(); pet.setPetId(rs.getInt("petId")); pet.setPetName(rs.getString("petName")); pet.setPetBreed(rs.getInt("petBreed")); pet.setPetSex(rs.getInt("petSex")); pet.setBirthday(rs.getDate("birthday")); pet.setDescription(rs.getString("description")); petList.add(pet); } } catch (SQLException e) { e.printStackTrace(); } finally { DatabaseUtil.closeAll(null, null, rs); } return petList; } @Override public List<Pet> petByBreed(int breed) { List<Pet> petList = new ArrayList<Pet>(); ResultSet rs = null; Pet pet = null; String sql = "SELECT petId,petName,petBreed,petSex,birthday,description FROM pet where petBreed=?"; try { rs=this.executeQuery(sql, breed); while (rs.next()) { pet = new Pet(); pet.setPetId(rs.getInt("petId")); pet.setPetName(rs.getString("petName")); pet.setPetBreed(rs.getInt("petBreed")); pet.setPetSex(rs.getInt("petSex")); pet.setBirthday(rs.getDate("birthday")); pet.setDescription(rs.getString("description")); petList.add(pet); } } catch (SQLException e) { e.printStackTrace(); } finally { DatabaseUtil.closeAll(null, null, rs); } return petList; } @Override public Integer insert(Pet pet) { int result = 0; String sql = "INSERT INTO `pet`(petName,petBreed,petSex,birthday,description) VALUES (?, ?, ?, ?, ?);"; try { result = executeUpdate(sql, pet.getPetName(), pet.getPetBreed(), pet.getPetSex(), pet.getBirthday(), pet.getDescription()); } catch (SQLException e) { e.printStackTrace(); } return result; } @Override public Integer petbyName(String Name) { int result = 0; ResultSet rs = null; Pet pet = null; String sql = "SELECT (1) FROM pet WHERE `petName`=?"; try { rs = this.executeQuery(sql, Name); while (rs.next()) { pet = new Pet(); pet.setPetId(rs.getInt(1)); } } catch (SQLException e) { e.printStackTrace(); } finally { DatabaseUtil.closeAll(null, null, rs); } return result; } }