Spring Frameworkクイックスタート｜プロジェクト作成・DB接続・DI

CREATE DATABASE spring_db CHARACTER SET utf8 COLLATE utf8_bin;

USE spring_db;

CREATE TABLE users (
    user_name VARCHAR(50) PRIMARY KEY,
    password VARCHAR(50) NOT NULL
);
  
INSERT INTO users(
    user_name
    , password
)VALUES(
    'tarou'
    , 'password'
),(
    'jirou'
    ,'password'
);

<!-- JDBC -->
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-jdbc</artifactId>
    <version>5.0.5.RELEASE</version>
</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.46</version>
</dependency>

<!-- CGLIB -->
<dependency>
    <groupId>cglib</groupId>
    <artifactId>cglib</artifactId>
    <version>3.2.6</version>
</dependency>

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/spring_db
jdbc.username=root
jdbc.password=

@Configuration
@PropertySource({"classpath:/jdbc.properties"})
public class DBConfig {

    @Autowired
    private Environment environment;

    @Bean
    public DataSource datasource() {
        final DriverManagerDataSource dataSource = new DriverManagerDataSource();
        dataSource.setDriverClassName(environment.getProperty("jdbc.driverClassName"));
        dataSource.setUrl(environment.getProperty("jdbc.url"));
        dataSource.setUsername(environment.getProperty("jdbc.username"));
        dataSource.setPassword(environment.getProperty("jdbc.password"));
        return dataSource;
    }

    @Bean
    public DataSourceTransactionManager transactionManager() {
      return new DataSourceTransactionManager(datasource());
    }

    @Bean
    public JdbcTemplate jdbcTemplate() {
      return new JdbcTemplate(datasource());
    }
}

@Controller
public class HomeController {

    private static final Logger logger = LoggerFactory.getLogger(HomeController.class);

    @Autowired
    JdbcTemplate jdbcTemplate;

    @RequestMapping(value = "/", method = RequestMethod.GET)
    public String home(Locale locale, Model model) {
        logger.info("Welcome home! The client locale is {}.", locale);

        Date date = new Date();
        DateFormat dateFormat = DateFormat.getDateTimeInstance(DateFormat.LONG, DateFormat.LONG, locale);

        String formattedDate = dateFormat.format(date);

        model.addAttribute("serverTime", formattedDate);

        //ユーザーを取得
        List<Map<String, Object>> users = jdbcTemplate.queryForList(
                "SELECT user_name, password FROM users");;

        model.addAttribute("users", users);

        return "home";
    }

}

<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ page session="false" %>
<html>
<head>
    <title>Home</title>
</head>
<body>
<h1>
    Hello world!
</h1>

<P>  The time on the server is ${serverTime}. </P>

<c:forEach var="user" items="${users}">
    <p>user_name: ${user.get("user_name")}</p>
    <p>password: ${user.get("password")}</p>
</c:forEach>

</html>