spring jdbcTemplate query

最新推荐文章于 2023-09-08 10:46:26 发布

weixin_33928137

最新推荐文章于 2023-09-08 10:46:26 发布

阅读量131

点赞数

文章标签： java

原文链接：http://www.cnblogs.com/rocky-fang/p/5501614.html

版权

1. spring jdbcTemplate query需要实现mapRow方法

package com.cdv.apolloagent.jdbc.dao.impl;

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

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.stereotype.Repository;

import com.cdv.apolloagent.jdbc.dao.TaskDao;
import com.cdv.apolloagent.model.Task;
@Repository
public class TaskDaoImpl implements TaskDao {

    @Autowired
    private JdbcTemplate jdbcTemplate;
    @Override
    public List<Task> findTaskList(int flag, int limit, int max){
        String sql = "select t.* from task t where t.flag = ? limit ?,?";
        List<Object> params = new ArrayList<Object>();
        params.add(flag);
        params.add(limit);
        params.add(max);
        
        Object[] para = params.toArray(new Object[params.size()]);
        List<Task> taskList = this.jdbcTemplate.query(sql.toString(),para,
                new RowMapper<Task>() {
                    public Task mapRow(ResultSet rs, int rowNum) throws SQLException {
                        Task task = new Task();
                        task.setId(rs.getLong("id"));
                        task.setWorkorderid(rs.getInt("workorderid"));
                        task.setFlag(rs.getInt("flag"));
                        return task;
                    }
                });
        return taskList;
    }
}