Spring boot 入门学习4. 使用MySQL

最新推荐文章于 2023-11-06 10:21:56 发布

编程圈子

最新推荐文章于 2023-11-06 10:21:56 发布

阅读量305

点赞数

分类专栏： # SpringCloud/SpringBoot

本文链接：https://blog.csdn.net/xundh/article/details/82413780

版权

SpringCloud/SpringBoot 专栏收录该内容

17 篇文章 3 订阅

订阅专栏

项目结构

这里写图片描述

mysql 表结构

CREATE TABLE `users` (
  `id` int(10) UNSIGNED NOT NULL COMMENT 'ID',
  `username` varchar(20) NOT NULL DEFAULT '' COMMENT '用户名',
  `password` varchar(32) NOT NULL DEFAULT '' COMMENT '密码'

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户表' ROW_FORMAT=COMPACT;

maven引用

     <!-- https://mvnrepository.com/artifact/org.springframework.boot/spring-boot-starter-data-jpa -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
            <version>2.2.2.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>

application.properties

### mysql
spring.datasource.url=jdbc:mysql://localhost:3306/testdb
spring.datasource.username=root
spring.datasource.password=1
spring.datasource.driver-class-name=com.mysql.jdbc.Driver


spring.thymeleaf.mode=HTML5
spring.thymeleaf.suffix=.html
spring.thymeleaf.encoding=UTF-8
spring.thymeleaf.content-type=text/html
spring.thymeleaf.cache=false

list.html

<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org">
<head>
    <meta charset="UTF-8" />
    <title>list.html</title>
</head>
<body>
  <h2>用户列表</h2>
  <div>
     <ul>
         <li th:each="user:${users}">
             <p>ID:<span th:text="${user.id}"></span></p>
             <p>名字:<span th:text="${user.username}"></span></p>
             <p>密码:<span th:text="${user.password}"></span></p>
         </li>
     </ul>
   </div>
</body>
</html>

UserController.java

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

import javax.annotation.Resource;

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;

import com.xundh.demo.model.User;


@RequestMapping("user")
@Controller
public class UserController {

	@Resource
	private JdbcTemplate jdbcTemplate;

	@RequestMapping("/list")
	public String list(Model model) {
		String sql = "SELECT id,username,password FROM users";
		List<User> userList = (List<User>)jdbcTemplate.query(sql, new RowMapper<User>(){

			public User mapRow(ResultSet rs, int rowNum) throws SQLException {
				User user = new User();
				user.setId(rs.getInt("id"));
				user.setUsername(rs.getString("username"));
				user.setPassword(rs.getString("password"));
				return user;
			}
			
		});
		System.out.println("success");
		for(User user:userList){
			System.out.println("username:"+user.getUsername());
		}
		model.addAttribute("users",userList);
		return "/user/list";

	}
}

User.java


public class User {
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	private int id;
	private String username;
	private String password;
}

DemoApplication.java

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
public class DemoApplication {

    public static void main(String[] args) {
        SpringApplication.run(DemoApplication.class, args);
    }
}