bbsimpl.java~9~

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