roadmapdaojdbc.java

来自「Java的框架」· Java 代码 · 共 99 行

package mcaps.apps.prrm.roaddefect.dao.jdbc;

import java.util.List;

import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.support.JdbcDaoSupport;

import mcap.core.base.dao.util.SortOrder;
import mcaps.apps.prrm.roaddefect.dao.RoadDAO;
import mcaps.apps.prrm.roaddefect.dao.jdbc.query.RoadQuery;
import mcaps.apps.prrm.roaddefect.dao.util.RoadField;
import mcaps.apps.prrm.roaddefect.model.Road;





/**
 * This class provides the dao implementation for road using
 * JDBC. The dao operation like query, insert, update, delete
 * are supported.
 * @author jov
 * @date Nov 10, 2005
 * @version 1.0.1.0
 */
public class RoadMapDAOJdbc extends JdbcDaoSupport implements RoadDAO {

	private RoadQuery roadMapQuery;
	private RoadQuery roadMapByIdQuery;
	private RoadQuery roadMapAdvQuery;
	
	/* (non-Javadoc)
	 * @see org.springframework.dao.support.DaoSupport#initDao()
	 */
	public void initDao() {
		this.roadMapQuery = new RoadQuery(
				getDataSource(),
				new int[]{RoadField.ROADNAME},
				new SortOrder[]{SortOrder.ASCENDING}
			);

		this.roadMapByIdQuery = new RoadQuery(
				getDataSource(),
				RoadField.FIELDS[RoadField.GID] + " = ?",
				new int[] {RoadField.FIELDTYPES[RoadField.GID]},
				new int[]{RoadField.ROADNAME},
				new SortOrder[]{SortOrder.ASCENDING}
			);
		System.out.println("this.roadMapByIdQuery: " + this.roadMapByIdQuery);

		this.roadMapAdvQuery = new RoadQuery(
				getDataSource(),
				RoadField.FIELDS[RoadField.ROADNAME] + " LIKE ?",
				new int[] {RoadField.FIELDTYPES[RoadField.ROADNAME]},
				new int[]{RoadField.ROADNAME},
				new SortOrder[]{SortOrder.ASCENDING}
			);
	}
	
	/* (non-Javadoc)
	 * @see mcap.prrm.roaddefect.dao.RoadMapDAO#getRoad(java.lang.Integer)
	 */
	public Road getRoad(Integer gid) throws DataAccessException {
		Object[] params = new Object[]{gid};
		List roadList = roadMapByIdQuery.execute(params);
		if(roadList.size() > 0) {
	    return (Road)roadList.get(0);
		}  
	  return null;		
	}

	/* (non-Javadoc)
	 * @see mcap.prrm.roaddefect.dao.RoadMapDAO#getRoad(java.lang.String)
	 */
	public Road getRoad(String roadName) throws DataAccessException {
		Object[] params = new Object[]{roadName};
		List roadList = roadMapAdvQuery.execute(params);
		if(roadList.size() > 0) {
	    return (Road)roadList.get(0);
		}  
	  return null;		
	}

	/* (non-Javadoc)
	 * @see mcap.prrm.roaddefect.dao.RoadMapDAO#getAllRoads()
	 */
	public List getAllRoads () throws DataAccessException {
		return roadMapQuery.execute();
	}

	/* (non-Javadoc)
	 * @see mcap.prrm.roaddefect.dao.RoadMapDAO#getRoads(java.lang.String)
	 */
	public List getRoads (String roadName) throws DataAccessException {
		return roadMapAdvQuery.execute(new Object[]{roadName});
	}

}