1. Spring JdbcTemplate query needs to implement the Maprow method
PackageCom.cdv.apolloagent.jdbc.dao.impl;ImportJava.sql.ResultSet;Importjava.sql.SQLException;Importjava.util.ArrayList;Importjava.util.List;Importorg.springframework.beans.factory.annotation.Autowired;Importorg.springframework.jdbc.core.JdbcTemplate;ImportOrg.springframework.jdbc.core.RowMapper;Importorg.springframework.stereotype.Repository;ImportCom.cdv.apolloagent.jdbc.dao.TaskDao;ImportCom.cdv.apolloagent.model.Task; @Repository Public classTaskdaoimplImplementsTaskdao {@AutowiredPrivateJdbcTemplate JdbcTemplate; @Override PublicList<task> Findtasklist (intFlagintLimitintmax) {String SQL= "Select t.* from Task t where T.flag =?" Limit?,? "; List<Object> params =NewArraylist<object>(); Params.add (flag); Params.add (limit); Params.add (max); Object[] Para= Params.toarray (Newobject[params.size ()]); List<Task> taskList = This. Jdbctemplate.query (sql.tostring (), para,NewRowmapper<task>() { PublicTask Maprow (ResultSet RS,intRowNum)throwsSQLException {Task Task=NewTask (); Task.setid (Rs.getlong ("id")); Task.setworkorderid (Rs.getint ("Workorderid")); Task.setflag (Rs.getint ("Flag")); returntask; } }); returntaskList; }}
Spring JdbcTemplate Query