Spring Boot(二) 数据库操作 [基于Spring Boot、Mysql、Jpa]

1.添加Spring Boot Jpa、Mysql 依赖配置

<dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<!-- Mysql依赖-->
<dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
</dependency>

2.编写实体类

@Entity
//指定关联数据库的表名
@Table(name = "department")
public class Department {
    //定义唯一标识，设置为自动生成
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    private String name;

    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }
}

3.实体持久化

@Repository
public interface UserRepository extends JpaRepository<User, Long> {
    
}

4.配置datasource

#设置数据源和JPA的工作模式
spring:
  datasource:
    url: jdbc:mysql://localhost:3306/sboot?characterEncoding=utf8
    username: root
    password: root
  jpa:
    hibernate:
      #使用Hibernate来自动更新表结构
      ddl-auto: update

5.编写Controller 测试

@Controller
@RequestMapping(value = "/mysql")
public class MysqlTestController {
    private static Logger logger = LoggerFactory.getLogger(MysqlTestController.class);
    @Autowired
    UserRepository userRepository;
    @Autowired
    DepartmentRepository departmentRepository;
    @Autowired
    RoleRepository roleRepository;

    @RequestMapping(value = "/init")
    @ResponseBody
    public String initData() {
        Department department = new Department();
        department.setName("研发部门");
        departmentRepository.save(department);

        Role role = new Role();
        role.setName("admin");
        roleRepository.save(role);


        User user = new User();
        user.setName("于");
        user.setCreatedata(new Date());
        user.setDepartment(department);

        List<Role> roles = roleRepository.findAll();
        user.setRoles(roles);

        userRepository.save(user);

        return "success";
    }

    @RequestMapping(value = "/findPage")
    @ResponseBody
    public void findPage() {
        Pageable pageable = new PageRequest(0, 10, new Sort(Sort.Direction.ASC, "id"));
        Page<User> page = userRepository.findAll(pageable);
        for (User user : page.getContent()) {
            logger.info("====user==== user name:{}, department name:{}, role name:{}",
                    user.getName(), user.getDepartment().getName(), user.getRoles().get(0).getName());
        }
    }
}