欢迎使用CSDN-markdown编辑器

springboot+mybatis+jsp，web项目

首先new一个maven 项目


建立好一个Maven项目后，如果Java Resources资源文件下没有src/main/java文件夹则手动创建，如果创建包报错，如下图：
正确的项目结构是这样的：
首先加入springboot+jsp+mybatis依赖pom文件如下：

 <parent>  <groupId>org.springframework.boot</groupId>  <artifactId>spring-boot-starter-parent</artifactId>  <version>1.4.3.RELEASE</version></parent>  <dependencies>  <dependency>        <groupId>org.springframework.boot</groupId>        <artifactId>spring-boot-starter-web</artifactId>    </dependency>    <dependency>      <groupId>javax.servlet</groupId>      <artifactId>javax.servlet-api</artifactId>      <scope>provided</scope>    </dependency>    <dependency>      <groupId>javax.servlet</groupId>      <artifactId>jstl</artifactId>     </dependency>     <dependency>       <groupId>org.springframework.boot</groupId>       <artifactId>spring-boot-starter-tomcat</artifactId>       <scope>provided</scope>     </dependency>     <dependency>         <groupId>org.apache.tomcat.embed</groupId>         <artifactId>tomcat-embed-jasper</artifactId>         <scope>provided</scope>     </dependency>     <!-- mybatis整合springboot依赖 -->     <dependency>  <groupId>mysql</groupId>  <artifactId>mysql-connector-java</artifactId></dependency><dependency>  <groupId>org.springframework.boot</groupId>  <artifactId>spring-boot-starter-jdbc</artifactId></dependency><dependency>  <groupId>org.springframework.boot</groupId>  <artifactId>spring-boot-starter-data-jpa</artifactId></dependency>    <dependency>      <groupId>junit</groupId>      <artifactId>junit</artifactId>      <version>3.8.1</version>      <scope>test</scope>    </dependency>  </dependencies>  <build>    <finalName>springboot_mybatis_jsp</finalName>  </build>

src/main/resources下创建配置文件application.properties代码如下：

#等同视图解析器spring.mvc.view.prefix: /spring.mvc.view.suffix: .jspserver.port=9090#配置数据源spring.datasource.url=jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=UTF-8spring.datasource.username=rootspring.datasource.password=spring.datasource.driverClassName = com.mysql.jdbc.Driver#解决乱码spring.http.encoding.force=truespring.http.encoding.charset=UTF-8spring.http.encoding.enabled=trueserver.tomcat.uri-encoding=UTF-8spring.jpa.database = MYSQLspring.jpa.show-sql = true#自动创建表spring.jpa.hibernate.ddl-auto = update spring.jpa.hibernate.naming-strategy = org.hibernate.cfg.ImprovedNamingStrategyspring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MySQL5Dialect

开始写代码

1.在src/main/java下新建包名apple，包下创建AppleApplication.java启动类代码如下：

import org.springframework.boot.SpringApplication;import org.springframework.boot.autoconfigure.EnableAutoConfiguration;import org.springframework.boot.autoconfigure.SpringBootApplication;import org.springframework.boot.builder.SpringApplicationBuilder;import org.springframework.boot.web.support.SpringBootServletInitializer;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RestController;@SpringBootApplicationpublic class AppleApplication extends SpringBootServletInitializer{    @Override//启动类继承自SpringBootServletInitializer方可正常部署至常规tomcat下，其主要能够起到web.xml的作用    protected SpringApplicationBuilder configure(SpringApplicationBuilder application) {        return application.sources(AppleApplication.class);    }    public static void main(String[] args) {        SpringApplication.run(AppleApplication.class, args);    }}

2.在apple包下创建controller包（控制层）创建LoginController.java代码如下：

package apple.controller;import java.util.Map;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RequestMethod;import apple.model.Student;import apple.respositroy.StudentRespositroy;@Controllerpublic class LoginController {    @Autowired    StudentRespositroy studentRepository;    @RequestMapping("/")    public String home() {        return "index";    }    @RequestMapping("/find")    public String testDataBase(Map<String, Object> model){        int id =  1;        Student stu = studentRepository.findStudentById(id);        model.put("student", stu);        System.out.println(stu.getName());        return "find";    }}

3.apple包下创建model包创建实体类Student.java，代码：

package apple.model;import javax.persistence.*;@Entity(name="Student")//name="Student"必须有表名，否则不能创建表public class Student {    @Id//设置为主键    @GeneratedValue//自增    private int id;    @Column    private String name;    @Column    private int age;    @Column    private String telephone;    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 int getAge() {        return age;    }    public void setAge(int age) {        this.age = age;    }    public String getTelephone() {        return telephone;    }    public void setTelephone(String telephone) {        this.telephone = telephone;    }}

4.apple包下创建respositroy包创建dao层接口StudentRespositroy.java代码：

package apple.respositroy;import org.springframework.data.repository.CrudRepository;import org.springframework.stereotype.Repository;import apple.model.Student;@Repository         //继承CrudRespositroy因为该接口已经实现了save,delete,deleteAll,findOne和findAllpublic interface StudentRespositroy extends CrudRepository<Student, Integer>{    Student findStudentById(int id);}

5.创建find.jsp，代码：

<!DOCTYPE html><%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%><%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%><%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt"%> <html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /></head><body>   <table border="1">       <tr>       <td>姓名</td>       <td>年龄</td>       <td>手机号码</td>       </tr>       <tr>       <td>${student.name}</td>       <td>${student.age}</td>       <td>${student.telephone}</td>       </tr>   </table></body><script src="/static/js/jquery-3.1.1.min.js"></script></html>

6.启动项目，如图：

为了获取数据在find.jsp显示，首先数据库插入几条数据

打开浏览器输入：http://localhost:9090/find结果如图：

至此springboot+mybatis+jsp整合完毕