SpringMVC简单注解实例

package com.complaints.dao; import java.sql.ResultSet; import java.sql.SQLException; import java.util.List; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.jdbc.core.RowMapper; import org.springframework.jdbc.core.RowMapperResultSetExtractor; import com.complaints.entity.Author; public class AuthorDao { class UserRowMapper implements RowMapper { public Object mapRow(ResultSet rs, int index) throws SQLException { Author author = new Author(); author.setAuId(rs.getString(1)); author.setAuLname(rs.getString(2)); author.setPhone(rs.getString(3)); return author; } } private JdbcTemplate jdbcTemplate; public JdbcTemplate getJdbcTemplate() { return jdbcTemplate; } public void setJdbcTemplate(JdbcTemplate jdbcTemplate) { this.jdbcTemplate = jdbcTemplate; } public List select(String where) { List list; String sql = "select * from Author"; list = (List) jdbcTemplate.query(sql, new RowMapperResultSetExtractor( new UserRowMapper())); return list; } }