简单宠物诊所系统(jsp+javaBean)

package pethome; import java.sql.*; import java.util.*; public class OwnerBean { public ArrayList getAllOwnerName() throws Exception { String sql = "select name from owners"; ArrayList list = new ArrayList(); Connection con = ConnectionFactory.getConnection(); Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery(sql); Owner owner; while (rs.next()) { owner = new Owner(); owner.setName(rs.getString(1)); list.add(owner); } ConnectionFactory.close(rs); ConnectionFactory.close(stmt); ConnectionFactory.close(con); return list; } public ArrayList getAnyOwner(String field, String value) throws Exception { String sql = "select id,name,address,city,telephone from owners where "; ArrayList list = new ArrayList(); Connection con = ConnectionFactory.getConnection(); Statement stmt = con.createStatement(); if (field.equals("id")) { sql = sql + "id=" + value; } else { sql = sql + "name like '%" + value + "%'"; } ResultSet rs = stmt.executeQuery(sql); Owner owner; while (rs.next()) { owner = new Owner(rs.getInt(1), rs.getString(2), rs.getString(3), rs.getString(4), rs.getString(5)); list.add(owner); } ConnectionFactory.close(rs); ConnectionFactory.close(stmt); ConnectionFactory.close(con); return list; } public void insertRec(String value1, String value2, String value3, String value4) throws Exception { String sql = "select max(id) from owners"; int id; Connection con = ConnectionFactory.getConnection(); Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery(sql); rs.next(); id = rs.getInt(1) + 1; sql = "insert into owners values(?,?,?,?,?)"; PreparedStatement pst = con.prepareStatement(sql); pst.setInt(1, id); pst.setString(2, value1); pst.setString(3, value2); pst.setString(4, value3); pst.setString(5, value4); pst.executeUpdate(); ConnectionFactory.close(pst); ConnectionFactory.close(stmt); ConnectionFactory.close(con); } public void updateRec(int value0, String value1, String value2,String value3, String value4) throws Exception { String sql = "update owners set name=?,address=?,city=?,telephone=? where id=?"; Connection con = ConnectionFactory.getConnection(); PreparedStatement pst = con.prepareStatement(sql); pst.setString(1, value1); pst.setString(2, value2); pst.setString(3, value3); pst.setString(4, value4); pst.setInt(5, value0); pst.executeUpdate(); ConnectionFactory.close(pst); ConnectionFactory.close(con); } /*public void deleteRec(String value) throws Exception { String sql = "delete from owners where name=value"; Connection con = ConnectionFactory.getConnection(); Statement ps = con.createStatement(); ps.executeUpdate(sql); ConnectionFactory.close(ps); ConnectionFactory.close(con); }*/ public void deleteRec(String value)throws Exception{ String sql="delete from owners where name=?"; Connection con=ConnectionFactory.getConnection(); PreparedStatement pst=con.prepareStatement(sql); pst.setString(1, value); pst.executeUpdate(); ConnectionFactory.close(pst); ConnectionFactory.close(con); } }