Dev log - 69, Java Spring #5

스프링(Spring) 프레임워크

Spring 실습

mysql -u root -p
use mysql;
create user 'javacafe'@localhost identified by 'javacafe'; // javacafe 호스트 생성
select host, user from user; // 생성 확인
create database javacafe default character set utf8; // javacafe 생성
show databases; // 생성 확인
grant all privileges on javacafe.* to 'javacafe'@localhost with grant option; // 사용자 권한 설정
flush privileges; // 변경 내용 적용

JSP 페이지 연결

https://mvnrepository.com/artifact/org.springframework.data/spring-data-commons/2.7.2

*. pom.xml

<!-- https://mvnrepository.com/artifact/org.springframework.data/spring-data-commons -->
<dependency>
    <groupId>org.springframework.data</groupId>
    <artifactId>spring-data-commons</artifactId>
    <version>2.7.2</version>
</dependency>

*. AccountDao

@Repository("accountDao")
public class AccountDao {
	private JdbcTemplate jdbcTemplate;

	@Autowired
	public AccountDao(DataSource dataSource) {
		jdbcTemplate = new JdbcTemplate(dataSource);
	}
    	
	public Page<Account> findAll(Pageable pageable) {
		Order order = pageable.getSort().isEmpty() ? Order.by("aid") : pageable.getSort().toList().get(0);
		String sql = "SELECT a.aid, a.customerId, a.accountNum, a.accType, a.balance, a.interestRate, a.overAmount, a.regDate"
				+ " FROM Account a INNER JOIN Customer c ON a.customerId = c.cid ORDER BY " + order.getProperty() + " "
				+ order.getDirection().name() + " LIMIT " + pageable.getPageSize() + "OFFSET " + pageable.getOffset();

		return new PageImpl<Account>(jdbcTemplate.query(sql, new CustomerAccountRowMapper()), pageable, countAccount());
	}

	public long countAccount() {
		String sql = "SELECT count(*) FROM Account";
		return jdbcTemplate.queryForObject(sql, Long.class);
	}

*. AccountDaoTest

public class AccountDaoTest {
	static private AccountDao dao;

	public static void main(String[] args) {
		AnnotationConfigApplicationContext context = new AnnotationConfigApplicationContext(DataSourceConfig.class);
		dao = context.getBean("accountDao", AccountDao.class);

		findAll();

		context.close();
	}

	public static void findAll() {
		System.out.println("-findAll()-");
		Pageable pageable = PageRequest.of(0, 5, Sort.Direction.DESC, "regDate");
		dao.findAll(pageable).forEach(c -> System.out.println(c));
	}
}