TIL 2022-11-24 spring boot 페이징 라이브러리

JYR00·2022년 11월 24일

TIL

목록 보기

40/60

새 프로젝트 생성

pageTest

7개 선택

주석처리 해놔야 연결됨

SELECT * FROM sakila.customer;

SELECT * FROM sakila.customer;

use sakila;

select host, user,authentication_string from user;

show grants for 'test1'@'localhost';


-- grant all privileges ON sakila.customer;
use sakila;
create view customers as select * from sakila.customer;

use mysql;
select host, user,authentication_string from user;

show grants for 'test1'@'localhost';

grant all privileges on sakila.customers to 'test1'@'localhost';

view 테이블 생성 -> sakila.customers;

package com.bitc.pagetest.configuration;

import com.zaxxer.hikari.HikariConfig;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.ApplicationContext;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.PropertySource;

@Configuration
@PropertySource("classpath:/application.properties")
public class DatabaseConfiguration {

    @Autowired
    private ApplicationContext applicationContext;
    @Bean
    @ConfigurationProperties(prefix = "spring.datasource.hikari")
    public HikariConfig hikariConfig(){
        return new HikariConfig();
    }
}

여기까지 하고 그레이들 주석 해제
주석해제하면 붉은 색 사라진다

configuration에 추가

resource->sql->sql-customer.xml 생성

mybatis -3에서 제공해줌
https://mybatis.org/mybatis-3/getting-started.html

page.html 생성

<!DOCTYPE html>
<html lang="ko" xmlns:th="http://www.thymeleaf.org">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@5.2.2/dist/css/bootstrap.min.css">
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.1/jquery.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.2.2/dist/js/bootstrap.bundle.min.js"></script>
</head>
<body>
<div class="container mt-5 p-5">
  <div class="row">
    <div class="col-sm">
      <table class="table table-hover table-striped">
        <thead>
        <tr>
          <th>고객번호</th>
          <th>이름</th>
          <th>이메일</th>
          <th>등록일</th>
          <th>수정일</th>
        </tr>
        </thead>
        <tbody>
        <tr th:if="${#lists.size(customersList)}>0" th:each="item:${customersList}">
          <td th:text="${item.customerId}"></td>
          <td th:text="|${item.lastName} ${item.firstName}|"></td>
          <td th:text="${item.email}"></td>
          <td th:text="${item.createDate}"></td>
          <td th:text="${item.lastUpdate}"></td>
        </tr>
        <tr th:unless="${#lists.size(customersList)}>0">
          <td>조회된 내용이 없습니다</td>
        </tr>
        </tbody>
      </table>
    </div>
  </div>
</div>
</body>
</html>