classofviewofpets.java~6~

基于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;
        }
    }

    public ArrayList ViewOfPetsQuery(int perPage, int pageNumber,
                                     String command) {
        ArrayList objArrayList = new ArrayList();
        System.out.println("yyyyyyyyyy");
        String sqlCommand = "{call proc_viewofpets (?,?,?)}";
        try {
            CallableStatement cs = objDBOperate.getConnect("petclinic").
                                   prepareCall(sqlCommand);
            cs.setInt(1, perPage);
            cs.setInt(2, pageNumber);
            cs.setString(3, command);
            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;
    }

}