classofviewofpets.java~1~

基于mvc的宠物管理系统。servlet+jsp

package com.richard.dao;

import java.util.*;

import java.sql.CallableStatement;
import java.sql.ResultSet;
import com.richard.dto.*;
public class ClassOfViewOfPets implements InterfaceOfViewOfPets {
     DBOperate objDBOperate = new DBOperate();
    public ClassOfViewOfPets() {
    }

    /**
     * ViewOfPetsQueryAll
     *
     * @param perPage int
     * @param pageNumber int
     * @return ArrayList
     * @todo Implement this com.richard.dao.InterfaceOfViewOfPets method
     */
    public ArrayList ViewOfPetsQueryAll(int perPage, int pageNumber) {
        ArrayList objArrayList = new ArrayList();
         String sqlCommand = "{call proc_employee (?,?)}";
         try {
             CallableStatement cs = objDBOperate.getConnect("petclinic").prepareCall(sqlCommand);
             cs.setInt(1, perPage);
             cs.setInt(2, pageNumber);
             ResultSet rs = cs.executeQuery();
             while (rs.next()) {
                ViewOfPets viewOfPets=new ViewOfPets();
                 viewOfPets.setTypes_name(rs.getString(1));
                 viewOfPets.setOwners_name(rs.getString(2));
                 viewOfPets.setPets_name(rs.getString(3));
                 viewOfPets.setBirth_date(rs.getString(4));
                 viewOfPets.setId(rs.getInt(5));
                 objArrayList.add(viewOfPets);
             }
         } catch (Exception ex) {
             System.out.println(ex.getMessage());
         }
         return objArrayList;

    }
}