使用spring操作数据库

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

import com.chinasofti.ynyc.dao.TodoDao;
import com.chinasofti.ynyc.model.SystemModel;
import com.chinasofti.ynyc.model.TodoTypeModel;
import com.chinasofti.ynyc.model.TodoModel;
import com.chinasofti.ynyc.model.TypeTypeModel;
import com.chinasofti.ynyc.model.TypeModel;

public class TodoDaoImpl extends JdbcDaoSupport implements TodoDao{


public List<TodoModel> getTodo1(String userId, String sysId, int rowNum) {

String sql="SELECT URL,START_TIME,TITLE FROM TODO_INFO ti where "+
"ti.SYS_ID = '"+sysId+"' and ti.USER_ID = '"+userId+"' and ROWNUM <="+rowNum;

List list =getJdbcTemplate().queryForList(sql);
if(list==null||list.size()==0){
return null;
}
List<TodoModel> listTodo = new ArrayList();
for (Iterator i = list.iterator(); i.hasNext();)
{
Map map=(Map)i.next();
TodoModel todo=new TodoModel();
todo.setStartTime((Date)(map.get("START_TIME")));
todo.setTitle(String.valueOf(map.get("title")));
todo.setUrl(String.valueOf(map.get("URL")));
listTodo.add(todo);

}
return listTodo;
}

@Override
public List<TodoTypeModel> getTodo2(String userId, String sysId, int rowNum) {

String sql = "SELECT URL,START_TIME,TITLE,TYPE_ID1 FROM ("+
"SELECT ROW_NUMBER() OVER(PARTITION BY TYPE_ID1 ORDER BY TYPE_ID1) AS rnk,URL,START_TIME,TITLE,TYPE_ID1 "+
"FROM TODO_INFO ti where ti.SYS_ID = '"+sysId+"' and ti.USER_ID = '"+userId+"') t WHERE rnk<="+rowNum;

List list =getJdbcTemplate().queryForList(sql);
if(list==null||list.size()==0){
return null;
}
List<TodoTypeModel> listTodo = new ArrayList();
for (Iterator i = list.iterator(); i.hasNext();)
{
Map map=(Map)i.next();
TodoTypeModel todo=new TodoTypeModel();
todo.setStartTime((Date)(map.get("START_TIME")));
todo.setTitle(String.valueOf(map.get("title")));
todo.setUrl(String.valueOf(map.get("URL")));
todo.setTypeId((BigDecimal)map.get("TYPE_ID1"));
listTodo.add(todo);

}
return listTodo;
}