com.gitee.qdbp.jdbc.result.KeyIntegerMapper Maven / Gradle / Ivy

Go to download

package com.gitee.qdbp.jdbc.result;

import java.sql.ResultSet;
import java.sql.SQLException;
import org.springframework.jdbc.core.RowMapper;
import com.gitee.qdbp.able.beans.KeyValue;

/**
 * KeyIntegerMapper

 * 第1列是KEY, 第2列是Integer的结果集, 转换为KeyValue<Integer>
 *
 * @author zhaohuihua
 * @version 190607
 */
public class KeyIntegerMapper implements RowMapper> {

    @Override
    public KeyValue mapRow(ResultSet rs, int rowNum) throws SQLException {
        KeyValue item = new KeyValue<>();
        item.setKey(rs.getString(1));
        item.setValue(rs.getInt(2));
        return item;
    }
}