petimpl.java~43~

JBuilder 2006 +SQL Server2000 +JavaBean+JSP开发的宠物医院管理系统

package com.pet.pets.model.DAO.impl;

import com.pet.pets.model.DAO.*;
import com.pet.pets.model.DTO.*;
import java.sql.*;
import com.pet.util.DBCon;
import java.util.ArrayList;

public class Petimpl implements PetDao {
    public Petimpl() {
    }

    ResultSet rs = null;
    DBCon db = new DBCon();

    /**
     * getpetbean
     * 宠物登记的方法
     * @param PUID int
     * @param Pname String
     * @param Page String
     * @param Psex String
     * @param Ptype int
     * @param Premark String
     * @return PetBean
     * @todo Implement this com.pet.pets.model.DAO.PetDao method
     */
    public PetBean getpetbean(int PUID, String Pname, String Page, String Psex,
                              int Ptype, String Premark) {
        PetBean petbean = new PetBean();
        //拼写sql语句
        String sqlstr =
                "insert into pets(PUID,Pname,Page,Psex,Ptype,Premark) values(" +
                PUID + ",'" +
                Pname + "','" + Page + "','" + Psex + "'," +
                Ptype + ",'" + Premark + "')";
        try {
            db.updateResult(sqlstr);
            petbean.setPUID(PUID);
            petbean.setPname(Pname);
            petbean.setPage(Page);
            petbean.setPsex(Psex);
            petbean.setPtype(Ptype);
            petbean.setPremark(Premark);
            db.closeConn();
        } catch (ClassNotFoundException ex) {
        } catch (SQLException ex) {
        }
        return petbean;
    }

    /**
     * 通过宠物类型ID查询宠物类型
     * @param uid int
     * @return String
     */

    public String gettype(int uid) {
        String type = "";
        String strsql = "select Tname from types where TID=" + uid;
        try {
            rs = db.querySQL(strsql);
            rs.next();
            type = rs.getString(1);
        } catch (ClassNotFoundException ex) {
        } catch (SQLException ex) {
        }

        return type;
    }

    /**
     * 通过宠物ID查询宠物信息
     * @param PUID int
     * @return PetBean
     */

    public PetBean getpet(int PID) {
        PetBean petbean = new PetBean();
        String strsql = "select * from pets where PID=" + PID;
        try {
            rs = db.querySQL(strsql);
            while (rs.next()) {
                petbean.setPID(rs.getInt("PID"));
                petbean.setPUID(PID);
                petbean.setPname(rs.getString("Pname"));
                petbean.setPage(rs.getString("Page"));
                petbean.setPsex(rs.getString("Psex"));
                petbean.setPtype(rs.getInt("Ptype"));
                petbean.setPremark(rs.getString("Premark"));
            }
            db.closeConn();
        } catch (ClassNotFoundException ex) {
        } catch (SQLException ex) {
        }

        return petbean;
    }

    /**
     * 通过宠物ID删除宠物
     * @param PID int
     * @return int
     */

    public int delpet(int PID) {
        int i = 0;
        try {
            i = db.updateResult("delete from pets where PID=" + PID);
        } catch (ClassNotFoundException ex) {
        } catch (SQLException ex) {
        }
        return i;
    }

    /**
     * 通过宠物ID修改宠物信息
     * @param PID int
     * @return int
     */

    public PetBean update(int PID, String Pname, String Page, String Psex,
                          int Ptype, String Premark) {
        PetBean petbean = new PetBean();
        //拼写sql语句
        String sqlstr =
                "update pets set  Pname = '" + Pname + "',Page='" +
                Page + "',Psex='" + Psex +
                "',Ptype=" + Ptype + ",Premark='" +
                Premark + "' where pid=" + PID;
        try {
            db.updateResult(sqlstr);
            // petbean.setPUID(PID);
            petbean.setPname(Pname);
            petbean.setPage(Page);
            petbean.setPsex(Psex);
            petbean.setPtype(Ptype);
            petbean.setPremark(Premark);
            db.closeConn();
        } catch (ClassNotFoundException ex) {
        } catch (SQLException ex) {
        }
        return petbean;

    }

    /**
     * 宠物看病预约的方法
     * @param BPID int
     * @param BVID int
     * @param BUID int
     * @param Btime String
     * @param Bsymptom String
     * @return BespokeBean
     */

    public BespokeBean getbespoke(int BPID, int BVID, int BUID, String Btime,
                                  String Bsymptom) {
        BespokeBean bespokbean = new BespokeBean();
        String strsql =
                "insert bespoke(BPID,BViD,BUID,Btime,Bsymptom) values(" + BPID +
                "," + BVID + "," + BUID + ",'" + Btime + "','" + Bsymptom +
                "')";
        try {
            db.updateResult(strsql);
            bespokbean.setBPID(BPID);
            bespokbean.setBViD(BVID);
            bespokbean.setBUID(BUID);
            bespokbean.setBtime(Btime);
            bespokbean.setBsymptom(Bsymptom);
            db.closeConn();
        } catch (ClassNotFoundException ex) {
        } catch (SQLException ex) {
        }

        return bespokbean;
    }

    /**
     * 生成预约单
     * @param bespokebean BespokeBean
     * @return ReserveBean
     */

    public ReserveBean getReserve(BespokeBean bespokebean) {
        ReserveBean reservebean = new ReserveBean();
        try {
            rs = db.querySQL(
                    "select pname,page,psex,tname,uname,uphone,uaddress from pets,types,users where tid=ptype and uid=puid and pid=" +
                    bespokebean.getBPID());
            rs.next();
            reservebean.setPname(rs.getString(1));
            reservebean.setPage(rs.getString(2));
            reservebean.setPsex(rs.getString(3));
            reservebean.setTname(rs.getString(4));
            reservebean.setUname(rs.getString(5));
            reservebean.setUphone(rs.getString(6));
            reservebean.setUaddress(rs.getString(7));
            db.closeConn();
            rs = db.querySQL(
                    "select vname,vphone,vaddress from vets where vid=" +
                    bespokebean.getBViD());
            rs.next();
            reservebean.setVname(rs.getString(1));
            reservebean.setVphone(rs.getString(2));
            reservebean.setVaddress(rs.getString(3));
            db.closeConn();
            reservebean.setBtime(bespokebean.getBtime());
            reservebean.setBsymptom(bespokebean.getBsymptom());
        } catch (ClassNotFoundException ex) {
        } catch (SQLException ex) {
        }
        return reservebean;
    }

    /**
     * 获得所有宠物类型
     * @return ArrayList
     */

    public ArrayList allType() {
        ArrayList arraylist = new ArrayList();
        try {
            rs = db.querySQL("select * from types");
            while (rs.next()) {
                TypeBean typeBean = new TypeBean();
                typeBean.setTID(rs.getInt("TID"));
                typeBean.setTname(rs.getString("Tname"));
                arraylist.add(typeBean);
            }
            db.closeConn();
        } catch (Exception ex) {
            ex.printStackTrace();
        }

        return arraylist;
    }

    /**
     * 根据兽医ID查看所有预约单
     * @param vid int
     * @param num int
     * @return ArrayList
     */

    public ArrayList allBespoke(int vid, int num) {
        ArrayList arraylist = new ArrayList();
        try {
            rs = db.querySQL(
                    "select top " + num +
                    " pname,page,psex,tname,uname,uphone,uaddress,Btime,Bsymptom,bid" +
                    " from pets,types,users,bespoke where" +
                    " bid not in(select top " + num +
                    "bid from bespoke order by bid desc)" +
                    " and tid=ptype and bpid=pid and uid=puid and Bvid=" +
                    vid + " order by bid desc");
            while (rs.next()) {
                ReserveBean reservebean = new ReserveBean();
                reservebean.setPname(rs.getString(1));
                reservebean.setPage(rs.getString(2));
                reservebean.setPsex(rs.getString(3));
                reservebean.setTname(rs.getString(4));
                reservebean.setUname(rs.getString(5));
                reservebean.setUphone(rs.getString(6));
                reservebean.setUaddress(rs.getString(7));
                reservebean.setBtime(rs.getString(8).substring(0, 10));
                reservebean.setBsymptom(rs.getString(9));
                reservebean.setBid(rs.getInt(10));
                arraylist.add(reservebean);
            }
            db.closeConn();
        } catch (ClassNotFoundException ex) {
        } catch (SQLException ex) {
        }

        return arraylist;
    }

    /**
     * 查看所有预约单shu
     * @param VID int
     * @return String
     */
    public String queryEmployeeAll(int VID) {
        String count = "";
        try {
            ResultSet rs1 = db.querySQL(
                    "select  count(*) from bespoke where bvid=" + VID);
            while (rs1.next()) {
                count = rs1.getString(1);
            }
        } catch (Exception ex1) {
            ex1.printStackTrace();
        }

        return count;
    }

    /**
     * 查询预约单
     * @return BespokeBean
     */
    public BespokeBean cxbes(int BID) {
        BespokeBean bespokbean = new BespokeBean();
        String strsql = "select BPID,BViD,BUID from bespoke where BID="+BID;
        try {
            rs = db.querySQL(strsql);
            while(rs.next()){
                bespokbean.setBPID(rs.getInt(1));
                bespokbean.setBViD(rs.getInt(2));
                bespokbean.setBUID(rs.getInt(3));
            }
        } catch (ClassNotFoundException ex) {
        } catch (SQLException ex) {
        }
        return bespokbean;
    }

}