classofviewofpets.java~4~

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

package com.richard.dao;

import java.util.*;

import java.sql.CallableStatement;
import java.sql.ResultSet;
import com.richard.dto.*;
import java.sql.PreparedStatement;
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_viewofpets (?,?)}";
         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;

    }

    public int totalPages()
    {
        int totalPages = 0;
       String sqlCommand = "select count(*) from view_pets";

       try {
           PreparedStatement objStatement = objDBOperate.getPreparedStatement("petclinic",sqlCommand);
           ResultSet rs = objStatement.executeQuery();
           while(rs.next())
           {
           totalPages = rs.getInt(1);
           }

       } catch (Exception ex) {
           System.out.println("错误提示:" + ex.getMessage());
       }
       if(totalPages%15==0)
           return totalPages/15;
       else
           return (totalPages/15)+1;
   }

    }