classofowners.java~12~

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

package com.richard.dao;

import java.util.*;

import com.richard.dto.*;
import java.sql.CallableStatement;
import java.sql.ResultSet;
import java.sql.PreparedStatement;

public class ClassOfOwners implements InterfaceOfOwners {
    DBOperate objDBOperate = new DBOperate();
    public ClassOfOwners() {
    }


    public void ownersDelete(Owners objOwners) {
        int ownersId = objOwners.getId();
        String sqlCommand = "delete from owners where id='" + ownersId + "'";
        objDBOperate.exeSql("petclinic", sqlCommand);
    }

    /**
     * ownersInsert
     *
     * @param objOwners Owners
     * @todo Implement this com.richard.dao.InterfaceOfOwners method
     */
    public void ownersInsert(Owners objOwners) {
        String name = objOwners.getName();
        String telephone = objOwners.getTelephone();
        String city = objOwners.getCity();
        String address = objOwners.getAddress();
        String sqlCommand =
                "insert into owners (name,address,city,telephone) values(?,?,?,?)";
        try {
            PreparedStatement ps = objDBOperate.getPreparedStatement(
                    "petclinic", sqlCommand);
            ps.setString(1, name);
            ps.setString(2, address);
            ps.setString(3, city);
            ps.setString(4, telephone);
            ps.execute();
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        }
    }

    /**
     * ownersQuery
     *
     * @param objOwners Owners
     * @return Owners
     * @todo Implement this com.richard.dao.InterfaceOfOwners method
     */
    public Owners ownersQuery(Owners objOwners) {
        return null;
    }

    /**
     * ownersQueryAll
     *
     * @return ArrayList
     * @todo Implement this com.richard.dao.InterfaceOfOwners method
     */
    public ArrayList ownersQueryAll(int perPage, int pageNumber) {
        ArrayList objArrayList = new ArrayList();
        String sqlCommand = "{call proc_owners (?,?)}";
        try {
            CallableStatement cs = objDBOperate.getConnect("petclinic").
                                   prepareCall(sqlCommand);
            cs.setInt(1, perPage);
            cs.setInt(2, pageNumber);
            ResultSet rs = cs.executeQuery();
            while (rs.next()) {
                Owners objOwners = new Owners();
                objOwners.setId(rs.getInt(1));
                objOwners.setName(rs.getString(2));
                objOwners.setAddress(rs.getString(3));
                objOwners.setCity(rs.getString(4));
                objOwners.setTelephone(rs.getString(5));
                objArrayList.add(objOwners);
            }
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        }
        return objArrayList;

    }

    /**
     * ownersUpdate
     *
     * @param objOwners Owners
     * @todo Implement this com.richard.dao.InterfaceOfOwners method
     */
    public void ownersUpdate(Owners objOwners) {
    }

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

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

    public ArrayList queryAll()
    {
        ArrayList objArrayList=new ArrayList();
        try
        {
            ResultSet rs=objDBOperate.getResultSet("petclinic","select id,name from owners");
            while(rs.next())
            {
                Owners objOwners = new Owners();
                objOwners.setId(rs.getInt(1));
                objOwners.setName(rs.getString(2));
                objArrayList.add(objOwners);
            }

        }catch(Exception ex)
        {
            System.out.println(ex.getMessage());
        }
        return objArrayList;
    }

    public int nameForId(String name)
    {
        int id=0;
        String sqlCommand="select id from owners where name='"+name+"'";
        try
        {
            ResultSet rs=objDBOperate.getResultSet("petclinic",sqlCommand);
            while(rs.next())
            {
                id=rs.getInt(1);
            }
        }catch(Exception ex)
        {
            System.out.println(ex.getMessage());
        }
        return id;
    }
}