classofviewofvetsdetails.java

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

package com.richard.dao;

import java.util.*;
import com.richard.dto.*;
import java.sql.*;

public class ClassOfViewOfVetsDetails implements InterfaceOfViewOfVetsDetails {

    DBOperate objDBOperate=new DBOperate();

    public ClassOfViewOfVetsDetails() {
    }

    /**
     * VetsDetailsQueryAll
     *
     * @return ArrayList
     * @todo Implement this com.richard.dao.InterfaceOfViewOfVetsDetails
     *   method
     */
    public ArrayList VetsDetailsQueryAll(int perPage,int pageNumber) {
        ArrayList objArrayList=new ArrayList();
        String sqlCommand = "{call proc_viewofvetsdetails (?,?)}";

        try {
            CallableStatement objStatement=objDBOperate.getConnect("petclinic").prepareCall(sqlCommand);
            objStatement.setInt(1,perPage);
            objStatement.setInt(2,pageNumber);
            ResultSet rs=objStatement.executeQuery();
            while(rs.next())
            {
                ViewOfVetsDetails objVetsDetails=new ViewOfVetsDetails();
                objVetsDetails.setName(rs.getString(1));
                objVetsDetails.setSpecialtiesname(rs.getString(2));
                 objVetsDetails.setId(rs.getInt(3));
                objArrayList.add(objVetsDetails);
            }
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        }
        return objArrayList;
    }

    /**
     * totalPage
     *
     * @return int
     * @todo Implement this com.richard.dao.InterfaceOfViewOfVetsDetails
     *   method
     */
    public int totalPage() {
        int totalPages = 0;
       String sqlCommand = "select count(*) from vetsdetail";

       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%12==0)
           return totalPages/12;
       else
           return (totalPages/12)+1;

    }
}