conferenceinterestdao.java

该源码包括了基于J2EE的数据持久层设计,设计中使用了DAO,Service,等模式,并在Struts下进行了测试．

package org.conference.datapersistence.Dao;

import java.io.Serializable;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import javax.sql.DataSource;

import org.javawing.component.jdbc.core.RowCallbackHandler;
import org.javawing.component.jdbc.core.support.JdbcDaoSupport;

public class ConferenceinterestDao extends JdbcDaoSupport implements
		Serializable {
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;

	public ConferenceinterestDao(DataSource dataSource) {
		this.setDataSource(dataSource);
	}

	public List doFindInterestsbyId(int id) {
		final List interests = new ArrayList();
		String Query = "select iid from cinterest where cid=" + id;
		this.getJdbcTemplate().query(Query, new RowCallbackHandler() {
			public void processRow(ResultSet rs) throws SQLException {
				interests.add(new Integer(rs.getInt("iid")));
			}
		});
		return interests;
	}

public int doStore(int conferenceid,int interestid){
		String storeQuery = "insert into cinterest(cid,iid)values(" + conferenceid+","+interestid+")";
		return this.getJdbcTemplate().update(storeQuery);
	}}