spring boot + gradle + mysql

二：一个简单的 spring boot + gradle + mysql 项目

gradle 中的依赖
dependencies {
compile(‘org.springframework.boot:spring-boot-starter-aop’)
compile(‘org.springframework.boot:spring-boot-starter-data-jpa’)
compile(‘org.springframework.boot:spring-boot-starter-thymeleaf’)
compile(‘org.springframework.boot:spring-boot-starter-web’)
runtime(‘mysql:mysql-connector-java’)
testCompile(‘org.springframework.boot:spring-boot-starter-test’)
}
在resources 目录下的application.properties 下增加mysql 的连接信息

spring boot 默认是使用hibernate，在依赖org.springframework.boot:spring-boot-starter-data-jpa中有hibernate 的jar 包，包括spring-data-jpa、spring-orm、hibernate
操作数据库
(1) entity

(2) dao(操作数据库)

     @Repository
public interface UserRepositoty extends JpaRepository<User,Long> {
    @Query("select t from User  t where t.name = :name")
    User findByUserName(@Param("name") String name);
}

(3) service

    @Service
public class UserService {
    @Autowired
    private UserRepositoty userRepositoty;
    public User findUserByName(String name) {
        User user = null;
        try {
            user = userRepositoty.findByUserName(name);
        } catch (Exception e) {
        }
        return user;
    }
}

(4) controller

@Controller
@RequestMapping(value = "/user")
public class UserController {
    @Autowired
    private UserService userService;

    @RequestMapping(value = "/show")
    @ResponseBody
    public String show(@RequestParam(value = "name") String name) {
        User user = userService.findUserByName(name);
        if (null != user)
            return user.getId() + " & " + user.getName() + " & " + user.getPassword();
        else return "null";
    }
}