bbsimpl.java~10~

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

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

import java.util.*;

import com.pet.bbs.model.DAO.*;
import java.sql.*;
import com.pet.util.DBCon;
import com.pet.bbs.model.DTO.BbsBean;

public class Bbsimpl implements BbsDao {
    public Bbsimpl() {
    }

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

    /**
     * allbbs
     *
     * @param VID int
     * @return ArrayList
     * @todo Implement this com.pet.bbs.model.DAO.BbsDao method
     */
    public ArrayList allbbs(int VID) {
        ArrayList arrayList = new ArrayList();
        String strsql = "select bbsid,BBSUID,bbstime,bbsremark,uname,vname from bbs,users,vets where bbsuid=uid and BBSVID=vid and bbsvid=" +
                        VID;
        try {
            rs = db.querySQL(strsql);
            while (rs.next()) {
                BbsBean bbsbean = new BbsBean();
                bbsbean.setBBSID(rs.getInt("bbsid"));
                bbsbean.setBBSUID(rs.getInt("BBSUID"));
                bbsbean.setBBSVID(VID);
                bbsbean.setBBSTime(rs.getString("bbstime"));
                bbsbean.setBBSRemark(rs.getString("bbsremark"));
                bbsbean.setOne(rs.getString("uname"));
                bbsbean.setTwo(rs.getString("vname"));

                arrayList.add(bbsbean);
            }
        } catch (ClassNotFoundException ex) {
        } catch (SQLException ex) {
        }
        return arrayList;
    }

    /**
     * 声明通过兽医ID查找bbs所有该兽医记录数的接口方法。
     * @param VID int
     * @return String
     */

    public String queryEmployeeAll(int VID) {
        String count = "";
        try {
            ResultSet rs1 = db.querySQL(
                    "select  count(*) from bbs where bbsvid=" + VID);
            while (rs1.next()) {
                count = rs1.getString(1);
            }
        } catch (Exception ex1) {
            ex1.printStackTrace();
        }

        return count;
    }

}