votedto.java

来自「教你一天学会struts」· Java 代码 · 共 33 行

package com.soft136.strutsoneday.model;

import java.sql.SQLException;

import javax.sql.rowset.CachedRowSet;

import java.util.ArrayList;

import com.soft136.strutsoneday.dao.VoteDAO;

public class VoteDTO {

	public ArrayList<VoteBean> getVotes() throws SQLException,
			ClassNotFoundException {
		CachedRowSet crs = new VoteDAO().getVotes();
		if (crs != null) {
			ArrayList<VoteBean> list = new ArrayList<VoteBean>();
			while (crs.next()) {
				list.add(new VoteBean(crs.getInt(1), crs.getString(2), crs
						.getInt(3)));
			}
			return list;
		} else {
			return null;
		}
	}

	public void vote(int voteId) throws SQLException, ClassNotFoundException {
		new VoteDAO().vote(voteId);
	}

}