1.新建maven项目(具体的新建过程就不细说了)
2.添加maven依赖,也就是在pom.xml文件添加项目的依赖jar包:
4.0.0 springboot-test bootTest war 0.0.1-SNAPSHOT bootTest Maven Webapp http://maven.apache.org org.springframework.boot spring-boot-starter-parent 1.4.0.RELEASE org.springframework.boot spring-boot-starter-web org.springframework.boot spring-boot-starter-data-jpa mysql mysql-connector-java org.springframework.boot spring-boot-starter-jdbc org.springframework.boot spring-boot-starter-test test org.springframework.boot spring-boot-starter-thymeleaf spring-boot-data-jpa org.apache.maven.plugins maven-compiler-plugin
3.在application.properties(放在resources目录下)中添加配置信息:
##JDBC Setting(Mysql的配置信息)spring.datasource.driver-class-name=com.mysql.jdbc.Driverspring.datasource.url=jdbc:mysql://127.0.0.1:3306/boottest?useUnicode=true&characterEncoding=utf-8spring.datasource.username=rootspring.datasource.password=rootspring.datasource.max-idle=10spring.datasource.max-wait=10000spring.datasource.min-idle=5spring.datasource.initial-size=5 ##服务器的配置信息server.port=8080server.session.timeout=10server.tomcat.uri-encoding=UTF-8## SpringDataJPA Settings #spring.jpa.generate-ddl:true ----->将这个属性设置为TRUE,就是设置数据库自动更新,即但数据库没有实体所对应的的表时,自动创建,有对应的表时执行更新,和hibernate的hbm2ddl.auto:updata功能差不多spring.jpa.generate-ddl: truespring.jpa.show-sql: truespring.jpa.properties.hibernate.format_sql: false#设置模板位置,即html文件的存放位置spring.thymeleaf.prefix=classpath:/templates/
4.项目的文件目录
5.测试
5.1 实体类User
package com.yxl.springboot.entity;import javax.persistence.Entity;import javax.persistence.GeneratedValue;import javax.persistence.Id;import javax.persistence.Table;@Entity@Table(name = "user") //声明实体对应得表,如果没有则创建(前提是application.properties文件中有相应的配置)public class User { @Id @GeneratedValue private int id; private String name; private String password; public User() { super(); // TODO Auto-generated constructor stub } public User(int id, String name, String password) { super(); this.id = id; this.name = name; this.password = password; } public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; }}
5.2 Mapper(Dao)层
package com.yxl.springboot.mapper;import org.springframework.data.jpa.repository.JpaRepository;import com.yxl.springboot.entity.User;//继承JpaRepository类public interface UserMapper extends JpaRepository{ public User findByName(String name);}
5.3 controller层
package com.yxl.springboot.controller;import java.util.List;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.springframework.ui.Model;import org.springframework.web.bind.annotation.RequestMapping;import com.yxl.springboot.entity.User;import com.yxl.springboot.mapper.UserMapper;@Controllerpublic class SpringBootTestController { @Autowired private UserMapper userMapper; @RequestMapping(value = "/find") public String springBootTest(Model model) { User findByName = userMapper.findByName("test"); model.addAttribute("user", findByName); return "test"; } @RequestMapping(value = "/all") public String selectAll(Model model) { ListselectAll = userMapper.findAll(); model.addAttribute("user", selectAll); return "test1"; } }
5.4 test.html
Insert title here 哈哈哈!成功了!
5.5 test1.html
Insert title here 哈哈哈!成功了!
编号 | 姓名 | 密码 |
5.5 程序入口Application.java
package com.yxl.springboot;import org.springframework.boot.SpringApplication;import org.springframework.boot.autoconfigure.SpringBootApplication;@SpringBootApplicationpublic class Application { public static void main(String[] args) { SpringApplication.run(Application.class, args); }}
5.6 数据库数据
5.7 运行结果
test.html
test1.html
参考博客: