Object o = JdbcTemplate.queryForObject("sql문", RowMapper객체, 값, ... );

List l = JdbcTemplate.query("sql문", RowMapper객체, 값, ... );

@Component
class DAO {
    @Autowired
    JdbcTemplate jt;

    public List<DeptDomain> selectAllDept() throws DataAccessExcpetion {
        List<DeptDomain> list = null;

        // 조회결과를 Domain에 저장토록 설정, anonymous inner class 생성
        RowMapper<DeptDomain> rm = new RowMapper<DeptDomain>(){
            @Override
            public DeptDomain mapRow(ResultSet rs, int rowNum) {
                DeptDomain dd = new DeptDomain(
                    rs.getInt("deptno"), rs.getString("dname"),
                    rs.getString("loc"))

                return dd;
            }
        }

        // 쿼리문 생성
        String selectDept = "..." ;

        // 실행
        list = jt.query(selectDept, rm);

        return list;
    }
}

package kr.co.sist.domain;
public class Member {
      private String name, loc, highschool, img;
      private int num;
      // 기본, 인자있는 생성자, getter, setter
      ...

@Component
public class JdbcDAO {
      
      @Autowired(required=false)
      private JdbcTemplate jt;
...
      public List<Member> selectAllMember() throws DataAccessException {
            List<Member> list = null;
            
            // 조회결과를 Domain에 저장하는 객체 생성(RowMapper)
            RowMapper<Member> rm = new RowMapper<Member>() {
                  @Override
                  public Member mapRow(ResultSet rs, int rowNum) throws  SQLException {
                        Member member = new Member(rs.getString("name"),  rs.getString("loc"),
                                    rs.getString("highschool"),  rs.getString("img"), rs.getInt("num"));
                        return member;
                  }
            };
            
            // SQL문 작성
            String selectMember = "SELECT name, loc, highschool, img,  num FROM test_like";
            
            // 실행
            list = jt.query(selectMember, rm);
            
            return list;
      }
}

@Component
public class JdbcService {
      @Autowired(required=false)
      private JdbcDAO jdao;
...
      public List<Member> searchAllMember() {
            List<Member> list = null;
            try {
                  list = jdao.selectAllMember();
            } catch (DataAccessException dae) {
                  dae.printStackTrace();
            }
            return list;
      }
}

@Controller
public class JdbcController {
      @Autowired
      private JdbcService js;
...
      @RequestMapping(value="/search_member.do", method=GET)
      public String searchAllMember(Model model) {
            
            List<Member> list = js.searchAllMember();
            model.addAttribute("memberList", list);
            
            return "member/member_list";
      }
}

// JdbcDAO
...
      public DetailMember selectOneMember(int num) throws  DataAccessException {
            DetailMember dm = null;
            
            RowMapper<DetailMember> rm = new RowMapper<DetailMember>() {
                  @Override
                  public DetailMember mapRow(ResultSet rs, int rowNum)  throws SQLException {
                        DetailMember dm = new  DetailMember(rs.getString("name"),
                                    rs.getString("img"),  rs.getString("loc"), rs.getString("highschool"));
                        return dm;
                  }
            };
            
            String selectOneMember = "SELECT name, img, loc, highschool  FROM test_like WHERE num=?";
            
            dm = jt.queryForObject(selectOneMember, rm, num);
            
            return dm;
      }
}

// JdbcService
...
      public DetailMember searchOneMember(int num) {
            DetailMember dm = null;
            try {
                  dm = jdao.selectOneMember(num);
            } catch (DataAccessException dae) {
                  dae.printStackTrace();
            }
            return dm;
      }
}

// JdbcController
...
      @RequestMapping(value="/detail_member.do", method=GET)
      public String detailMember(@RequestParam(defaultValue="0") int num, Model model) {
            
            DetailMember dm = js.searchOneMember(num);
            model.addAttribute("detailMember", dm);
            
            return "member/detail_member";
      }
}