bbsimpl.java~16~

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,int num) {
        ArrayList arrayList = new ArrayList();
        //分页查询语句
/*select  top 5 emp_id,fname,minit,lname,job_id,job_lvl,pub_id,hire_date
from employee where emp_id not in(select top 5 emp_id from employee order by emp_id desc)
order by emp_id desc
*/

        String strsql = "select top 5 bbsid,BBSUID,bbstime,bbsremark,uname,vname from bbs,users,vets"+
                        " where bbsid not in(select top "+num+" bbsid from bbs order by bbsid desc)"+
                        " and bbsuid=uid and BBSVID=vid and bbsvid=" +
                        VID+" order by bbsid desc";
        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").substring(0,10));
                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;
    }

}