@Transactional(readOnly=true) public User findUserById(int id) { return jdbcTemplate.queryForObject("select * from users where id=?", new Object[]{id}, new UserRowMapper()); }
@RequestMapping("/") public String home(Model model) { model.addAttribute("users", userRepo.findAll()); return "home"; } }
@Bean @Conditional(MySQLDatabaseTypeCondition.class) public UserDAO jdbcUserDAO(){ return new JdbcUserDAO(); }
@Bean @Conditional(MongoDBDatabaseTypeCondition.class) public UserDAO mongoUserDAO(){ return new MongoUserDAO(); }
@Test public void test_get_all_usernames() { List<String> userNames = userDAO.getAllUserNames(); System.err.println(userNames); } }
@Test public void findUserById() { User user = userRepository.findUserById(1); assertNotNull(user); }
@Transactional(readOnly=true) public User findUserById(int id) { return jdbcTemplate.queryForObject("select * from users where id=?", new Object[]{id}, new UserRowMapper()); }
@Transactional(readOnly=true) public User findUserById(int id) { return jdbcTemplate.queryForObject("select * from users where id=?", new Object[]{id}, new UserRowMapper()); }
@Transactional(readOnly=true) public List<User> findAll() { return jdbcTemplate.query("select * from users", new UserRowMapper()); }
@Transactional(readOnly=true) public List<User> findAll() { return jdbcTemplate.query("select * from users", new UserRowMapper()); }
@Transactional(readOnly=true) public User findUserById(int id) { return jdbcTemplate.queryForObject("select * from users where id=?", new Object[]{id}, new UserRowMapper()); }