fenyedao.java

爱心”宠物诊所的职员需要使用系统提供的如下功能： 浏览诊所的兽医以及他们的专业特长； 浏览宠物的主人（即诊所的客户）的相关信息； 更新宠物的主人的相关信息； 向系统中增加一个新客户； 浏览宠

package com.wzxy.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import com.wzxy.pojos.Fenye;

import com.wzxy.utils.DBUtils;

public class FenyeDao {
	public PreparedStatement pstmt = null;

	public Connection con = null;

	public ResultSet rset;

	Fenye fy = new Fenye();
    public String petName="";
    public String ownerName="";
	public FenyeDao() {

	}

	public Connection getCon() {
		try {
			con = new DBUtils().getCon();
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return con;
	}

	public Fenye stuFenye(String s,String petName,String ownerName) {
        this.petName=petName;
        this.ownerName=ownerName;
		alllist();
		fy.setAllpage((fy.getAlllist() % fy.getShowlist()) == 0 ? (fy
				.getAlllist() / fy.getShowlist()) : (fy.getAlllist()
				/ fy.getShowlist() + 1));

		try {
			int sp = Integer.parseInt(s);
			fy.setShowpage(sp);
		} catch (Exception e) {
			// TODO: handle exception
			fy.setShowpage(1);
		}
		setPage();
		return fy;
	}

	public int lastpage() {
		alllist();
		fy.setAllpage((fy.getAlllist() % fy.getShowlist()) == 0 ? (fy
				.getAlllist() / fy.getShowlist()) : (fy.getAlllist()
				/ fy.getShowlist() + 1));
		int lastpage = fy.getAllpage();
		return lastpage;
	}

	public void alllist() {
		con = this.getCon();
		String sql = "select count(*) from pets p,owners o where p.name like '%"
				+ petName
				+ "%' and o.name like '%"
				+ ownerName
				+ "%'"
				+ "and p.owner_id=o.id";
		try {
			pstmt = con.prepareStatement(sql);
			rset = pstmt.executeQuery();
			if (rset.next()) {
				fy.setAlllist(rset.getInt(1));

			} else {
				fy.setAlllist(0);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			new DBUtils().reaseSource(con, pstmt, rset);
		}
	}

	public void setPage() {
		fy.setFristpage(1);
		fy.setLastpage(fy.getAllpage());
		if (fy.getShowpage() <= 1) {
			if (fy.getAllpage() == 1) {
				fy.setPreviouspage(1);
				fy.setNextpage(1);

			} else {
				fy.setPreviouspage(1);
				fy.setNextpage(2);
			}
		} else if (fy.getShowpage() >= fy.getAllpage()) {
			fy.setPreviouspage(fy.getAllpage() - 1);
			fy.setNextpage(fy.getAllpage());
		} else {
			fy.setPreviouspage(fy.getShowpage() - 1);
			fy.setNextpage(fy.getShowpage() + 1);
		}

	}

}