public interface RowMapper { public T mapRow(ResultSet rs, int rowNum) throws Exception; }
public class Member { private String username; private String password; private String nickName; private int age; private String addr; //get&set略}
//这里我们不进行继承JdbcTemplate类,原因是继承会重写很多方法public class MemberDao{ private JdbcTemplate jdbc = new JdbcTemplate(null); public List query(){ String sql = "SELECT * FORM member "; return jdbc.executeQuery(sql,new RowMapper () { public Member mapRow(ResultSet rs, int rowNum) throws Exception{ Member member = new Member(); member.setUsername(rs.getString("username")); member.setPassword(rs.getString("password")); member.setAge(rs.getInt("age")); member.setAddr(rs.getString("addr")); return member; } },null); } public Object processResult(ResultSet rs, int rowNum)throws Exception { Member member = new Member(); member.setUsername(rs.getString("username")); member.setPassword(rs.getString("password")); member.setAge(rs.getInt("age")); member.setAddr(rs.getString("addr")); return member; } }
public class MemberDaoTest { public static void main(String[] args) { MemberDao memberDao = new MemberDao(); memberDao.query(); } }