jdbctemplatemappingquery.java

来自「《精通Spring》源代码」· Java 代码 · 共 38 行

/*
 * Created on 2004-11-13
 *
 * http://www.open-v.com 提供代码的维护工作
 */
package com.openv.spring;

import org.springframework.jdbc.core.SqlParameter;
import org.springframework.jdbc.object.MappingSqlQuery;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Types;

import javax.sql.DataSource;


/**
 * MappingSqlQuery实现
 *
 * @author luoshifei
 */
public class JdbcTemplateMappingQuery extends MappingSqlQuery {
    public JdbcTemplateMappingQuery(DataSource ds) {
        super(ds, "select id, templatename from jdbctemplate where id = ?");
        super.declareParameter(new SqlParameter("id", Types.INTEGER));
        compile();
    }

    public Object mapRow(ResultSet rs, int rowNumber) throws SQLException {
        JdbcTemplateVO jtVO = new JdbcTemplateVO();
        jtVO.setId(rs.getString("id"));
        jtVO.setTemplatename(rs.getString("templatename"));

        return jtVO;
    }
}