Springboot+MyBatis+mysql+jsp页面跳转详细示例

SpringBoot与MyBatis搭建环境，底层数据库为mysql，页面使用JSP(官网上不推荐使用jsp)，完成从数据库中查询出数据，在jsp页面中显示，并且实现页面的跳转功能。

项目下载链接： https://github.com/DFX339/springbootJsp.git

（1）新建数据库 springboot_mybatis

　　新建表 user，表的结构如下：

（2）新建maven项目---web项目 springbootJsp，项目目录结构如下

　　ApplicationMain.java ： SpringBoot项目的启动类

　　UserController.java ：前端控制类

　　UserMapper.java ：持久层的接口设计

　　User.java：实体类

　　UserIService.java：业务层接口

　　UserService.java：业务层接口实现类

　　mapper/UserMapper.xml：UserMapper接口对应的xml文件，里面是sql语句

　　application.properties ：这是SpringBoot的默认配置文件名，存放在resources目录下。必须命名为application.properties,否则读取不了需要另外配置

　　showUser.jsp ：访问findById方法返回的页面

　　skipped.jsp：从showUser.jsp页面请求/skip方法跳转到此页面

　　pom.xml：maven项目的配置文件

（3）springboot的配置文件： application.properties （放在src/main/resources目录下，会自动读取）

#指定跳转的前缀，这里表示所有的页面都存放在/WEB-INF/jsp文件下
spring.mvc.view.prefix=/WEB-INF/jsp/   
# 指定跳转页面的后缀，这里表示所有的页面都是jsp页面
spring.mvc.view.suffix=.jsp

#指定跳转的前缀
spring.mvc.view.prefix=/WEB-INF/jsp/
# 指定跳转页面的后缀
spring.mvc.view.suffix=.jsp

#访问的项目名
server.context-path=/SpringbootJsp

#数据库的配置
spring.datasource.driver-class-name =com.mysql.jdbc.Driver
spring.datasource.url =jdbc:mysql://localhost:3306/springboot_mybatis
spring.datasource.username =root
spring.datasource.password =root

#mybatis配置文件的配置
mybatis.typeAliasesPackage=SpringBoot_jsp.springbootJsp.pojo
mybatis.mapperLocations=classpath:/mapper/UserMapper.xml

（4）ApplicationMain.java ： SpringBoot项目的启动类

package SpringBoot_jsp.springbootJsp;

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

/**
 * SpringBoot的启动类
 * 自动启动内置的tomcat
 * @author Administrator
 *
 */
@SpringBootApplication
@EnableAutoConfiguration
public class ApplicationMain {

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

}

（5）UserController.java ：前端控制类

使用@Controller注解，可以跳转到jsp、html页面，也可以返回json数据

需要返回json数据的时候，在方法上添加@ResponseBody注解

package SpringBoot_jsp.springbootJsp.controller;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;

import SpringBoot_jsp.springbootJsp.pojo.User;
import SpringBoot_jsp.springbootJsp.service.UserService;

/**
 * 前端控制器类，调用业务层方法处理请求
 * @author Administrator
 *
 */
@Controller
@ComponentScan({"SpringBoot_jsp.springbootJsp.service"})
@MapperScan("SpringBoot_jsp.springbootJsp.mapper")
public class UserController {
    
    @Resource
    private UserService  userService;
    
    /**
     * 根据id查询出对应的用户
     * @param id
     * @param request
     * @return
     */
    @RequestMapping("/findById")
    public String findById(HttpServletRequest request){
        User user = userService.find(18);
        request.setAttribute("user", user);
        return "first/showUser";
    }
    
　　　/** * 跳转到skipped.jsp
　　　　　 * @param request
          * @return
    */
    @RequestMapping("/skip")
    public String skip(HttpServletRequest request){
        User user = userService.find(18);
        request.setAttribute("user", user);
        return "skip/skipped";
    }
    
}

（6）　UserMapper.java ：持久层的接口设计，使用@Mapper注解标明这是个mapper接口

package SpringBoot_jsp.springbootJsp.mapper;

import org.apache.ibatis.annotations.Mapper;

import SpringBoot_jsp.springbootJsp.pojo.User;

/**
 * 持久层接口，定义增删改查方法
 * @author Administrator
 *
 */
@Mapper
public interface UserMapper {
    
    void insert(User user);
    void delete(int id);
    void edit(User user);
    User find(int id);
}

（7）User.java：实体类 ,与数据库中的字段一一对应。

package SpringBoot_jsp.springbootJsp.pojo;
/**
 * 实体类
 * @author Administrator
 *
 */
public class User {
    
    private int id;
    private String username;
    private String password;
    private int age;
    
    public User(){}

   /** setter and getter 方法 */
    
}

（8）　UserIService.java：业务层接口

package SpringBoot_jsp.springbootJsp.service;

import SpringBoot_jsp.springbootJsp.pojo.User;

/**
 * 业务层接口
 * @author Administrator
 *
 */
public interface UserIService {
    
    void insert(User user);
    void delete(int id);
    void edit(User user);
    User find(int id);
}

（9）　UserService.java：业务层接口实现类，调用mapper接口中的方法完成对数据库的操作

package SpringBoot_jsp.springbootJsp.service;

import javax.annotation.Resource;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.stereotype.Service;

import SpringBoot_jsp.springbootJsp.mapper.UserMapper;
import SpringBoot_jsp.springbootJsp.pojo.User;
/**
 * 业务层实现类
 * @author Administrator
 *
 */

@Service("userService")
@ComponentScan({"SpringBoot_jsp.springbootJsp.mapper"})
public class UserService implements UserIService {

    @Resource 
    private UserMapper userMapper;
    
    @Override
    public void insert(User user) {
        userMapper.insert(user);
    }

    @Override
    public void delete(int id) {
        userMapper.delete(id);
        
    }

    @Override
    public void edit(User user) {
        userMapper.edit(user);        
    }

    @Override
    public User find(int id) {
        return userMapper.find(id);
    }

}

（10）mapper/UserMapper.xml：UserMapper接口对应的mapper.xml文件，里面是sql语句

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">  
  
<!-- 指定工作空间，要与接口名相同，源代码没有去看，猜测应该是通过"这里的namespace.下边方法的id"来定位方法的 -->  
<mapper namespace="SpringBoot_jsp.springbootJsp.mapper.UserMapper">  

    <!-- insert user --> 
    <insert id = "insert" parameterType="SpringBoot_jsp.springbootJsp.pojo.User">
        INSERT INTO USER(ID,USERNAME,PASSWORD,AGE) VALUES(#{id},#{username},#{password},#{age});
    </insert>
    
    <!-- update user -->
    <update id="edit" parameterType="SpringBoot_jsp.springbootJsp.pojo.User">
        UPDATE USER SET USERNAME=#{username} , PASSWORD=#{password} , AGE = #{age} WHERE ID=#{id}
    </update>
    
    <!-- find user -->
    <select id="find" parameterType="int" resultType="SpringBoot_jsp.springbootJsp.pojo.User">
        SELECT ID,USERNAME,PASSWORD,AGE FROM USER WHERE ID=#{0}
    </select>
    
    <!-- delete user -->
    <delete id="delete" parameterType="int">
        DELETE FROM USER WHERE ID=#{0}
    </delete>
</mapper>

（11）　showUser.jsp ：访问findById方法返回的页面

在页面发送请求使用 url="/项目名/请求名.do"

例如：<a href="/SpringbootJsp/skip.do">转到skip.jsp</a>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>显示用户信息</title>
</head>
<body>
    <h1>HELLO THIS IS SHOWUSER JSP.</h1>
    <h2>${user.id }</h2>
    <h2>${user.username }</h2>
    <h2>${user.password }</h2>
    <a href="/SpringbootJsp/skip.do">转到skip.jsp</a>
</body>
</html>

（12）skipped.jsp：从showUser.jsp页面请求/skip方法跳转到此页面

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>jsp跳转</title>
</head>
<body>
    <h1>Skip jsp</h1>
    <a href="/SpringbootJsp/findById.do">转到showUser.jsp</a>
</body>
</html>

（13）pom.xml：maven项目的配置文件

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>SpringBoot_jsp</groupId>
    <artifactId>springbootJsp</artifactId>
    <packaging>war</packaging>
    <version>0.0.1-SNAPSHOT</version>
    <name>springbootJsp Maven Webapp</name>
    <url>http://maven.apache.org</url>
    
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>1.5.6.RELEASE</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    
    <build>
        <finalName>bootdemo</finalName>
        <plugins>
            <plugin>
                <inherited>true</inherited>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-compiler-plugin</artifactId>
                <version>3.5.1</version>
                <configuration>
                    <source>${compiler.source}</source>
                    <target>${compiler.target}</target>
                    <encoding>${project.build.sourceEncoding}</encoding>
                    <compilerArguments>
                        <extdirs>${project.basedir}/src/main/webapp/WEB-INF/lib</extdirs>
                    </compilerArguments>
                </configuration>
            </plugin>
            
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>
    <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <compiler.source>1.7</compiler.source>
        <compiler.target>1.7</compiler.target>

        <!-- servlet/jsp/EL (2.4/2.0/?)(2.5/2.1/2.1),(3.0/2.2/2.2),(3.1/2.3/3.0) -->
        <servlet.version>3.1.0</servlet.version>
        <jsp.version>2.3.1</jsp.version>
        <jstl.version>1.2</jstl.version>
        <junit.version>4.12</junit.version>
    </properties>
    <dependencies>
        
    <!-- Springboot添加视图解析器的依赖包 -->
    <dependency> 
        <groupId>org.apache.tomcat.embed</groupId> 
        <artifactId>tomcat-embed-jasper</artifactId> 
        <scope>provided</scope> 
    </dependency> 
   
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>${junit.version}</version>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>${servlet.version}</version>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>javax.servlet.jsp</groupId>
            <artifactId>javax.servlet.jsp-api</artifactId>
            <version>${jsp.version}</version>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>jstl</artifactId>
            <version>${jstl.version}</version>
        </dependency>
        
        <dependency>
            <groupId>org.objenesis</groupId>
            <artifactId>objenesis</artifactId>
            <version>1.2</version>
        </dependency>
        
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.2.0</version>
        </dependency>
        
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-tomcat</artifactId>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-configuration-processor</artifactId>
            <optional>true</optional>
        </dependency>
        
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.6</version>
            <scope>runtime</scope>
        </dependency> 
    <!-- freemarker jar包导入 -->   
       <dependency>  
            <groupId>org.springframework.boot</groupId>  
            <artifactId>spring-boot-starter-freemarker</artifactId>  
        </dependency> 

    </dependencies>
    
</project>

（14）启动项目。

进入 ApplicationMain.java

右击 --》 Run As --》 Java Application

启动成功会出现如图结果：

（15）访问项目。

　　在浏览器中通过URL访问项目。格式： http://主机IP：8080/application.properties中指定的server.context-path的值/@Controller标识的类指定的RequestMapping值

　　例如： http://127.0.0.1:8080/SpringbootJsp/findById

　　访问结果如下：

　　点击页面中的超链接转到skip.jsp，进入skipped.jsp页面，结果如下：

相关阅读:
网络爬虫之Cookies解决
 高性能异步爬虫
 Python csv存储
 pandas ExcelWriter用法及代码示例
 pandas to_excel 用法详解
 pandas read_csv 与 to_csv 方法各参数详解
 pandas read_excel操作
 pandas DataFrame.groupby()所见的各种用法详解
 Pandas 中 DataFrame 基本函数整理
 Python 解析二维码输出文本
原文地址：https://www.cnblogs.com/DFX339/p/8862709.html