spring boot 整合jsp页面项目搭建示例②

柔情只为你懂 2022-05-20 00:08 233阅读 0赞

上篇我们介绍了搭建spring boot+Mybatis+logback+Mysql的框架搭建[《spring boot项目搭建示例》][spring boot]

这篇博文我们介绍一下如何整合jsp页面以及将项目改成Mybatis映射文件xml的形式

步骤如下：

1.pom.xml加入jsp所需的jar包

<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/xsd/maven-4.0.0.xsd">
      	<modelVersion>4.0.0</modelVersion>
    	<groupId>com.hu</groupId>
    	<artifactId>SpringBootPro</artifactId>
    	<version>0.0.1-SNAPSHOT</version>
    	<packaging>war</packaging>
    	<name>SpringBootPro</name>
    	<url>http://maven.apache.org</url>
      
      <parent>
    		<groupId>org.springframework.boot</groupId>
    		<artifactId>spring-boot-starter-parent</artifactId>
    		<version>1.5.9.RELEASE</version>
    	</parent>
      <dependencies>
      <dependency>
    		<groupId>org.springframework.boot</groupId>
    		<artifactId>spring-boot-starter-web</artifactId>
    		
    		<exclusions>
    		 <exclusion>
    		 	<groupId>org.springframework.boot</groupId>
    		 	<artifactId>spring-boot-starter-tomcat</artifactId>
    		 </exclusion>
    		</exclusions>
    	</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-starter-logging</artifactId>
    	</dependency>
    	
    	<dependency>
    		<groupId>org.mybatis.spring.boot</groupId>
    		<artifactId>mybatis-spring-boot-starter</artifactId>
    		<version>1.3.1</version>
    	</dependency>
    	<dependency>
    		<groupId>mysql</groupId>
    		<artifactId>mysql-connector-java</artifactId>
    		<version>5.1.30</version>
    	</dependency>
    	
    	<dependency>
    	    <groupId>org.apache.maven.plugins</groupId>
    	    <artifactId>maven-compiler-plugin</artifactId>
    	    <version>3.1</version>
    	</dependency>
    	<dependency>
    	    <groupId>org.apache.maven.plugins</groupId>
    	    <artifactId>maven-surefire-plugin</artifactId>
    	    <version>2.12.4</version>
    	</dependency>
    	<dependency>
    	    <groupId>org.apache.maven.plugins</groupId>
    	    <artifactId>maven-install-plugin</artifactId>
    	    <version>2.4</version>
    	</dependency>
    	<dependency>
    	    <groupId>org.springframework.boot</groupId>
    	    <artifactId>spring-boot-maven-plugin</artifactId>
    	    <version>1.5.9.RELEASE</version>
    	</dependency>
    	<dependency>
    	    <groupId>org.apache.logging.log4j</groupId>
    	    <artifactId>log4j-core</artifactId>
    	    <version>2.7</version>
    	</dependency>
    	
    	<dependency>
    		 <groupId>javax.servlet</groupId>
    		 <artifactId>jstl</artifactId>
    		 <scope>provided</scope>
    		 </dependency>
    		 <dependency>
    		 <groupId>javax.servlet</groupId>
    		 <artifactId>javax.servlet-api</artifactId>
    		 <scope>provided</scope>
     	</dependency>
     	<dependency>
    			<groupId>org.apache.tomcat.embed</groupId>
    			<artifactId>tomcat-embed-jasper</artifactId>
    		</dependency>
    		
      </dependencies>
      
      <build>
    		<plugins>
    			<plugin>
    				<groupId>org.springframework.boot</groupId>
    				<artifactId>spring-boot-maven-plugin</artifactId>
    				<configuration>
    					<mainClass>com.hu.server.MainServer</mainClass>
    				</configuration>
    				<executions>
    			        <execution>
    			            <goals>
    			                <goal>repackage</goal>
    			            </goals>
    			        </execution>
        			</executions>
    			</plugin>
    		</plugins>
    		<finalName>springboot</finalName>
    	</build>
    	
    </project>

2.给启动类加入如下代码MainServer.java

package com.hu.server;
    
    import org.mybatis.spring.annotation.MapperScan;
    import org.slf4j.Logger;
    import org.slf4j.LoggerFactory;
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    import org.springframework.boot.builder.SpringApplicationBuilder;
    import org.springframework.boot.web.support.SpringBootServletInitializer;
    import org.springframework.context.annotation.ComponentScan;
    @SpringBootApplication
    @ComponentScan(basePackages={"com.hu"})
    @MapperScan({"com.hu.dao"})
    public class MainServer extends SpringBootServletInitializer{
    	private final Logger log = LoggerFactory.getLogger(MainServer.class);
    	public static void main(String[] args) {
    		SpringApplication.run(MainServer.class, args);
    	}
    	
    	//为了打包springboot-war项目
    	@Override
    	 protected SpringApplicationBuilder configure(SpringApplicationBuilder builder) {
    		 return builder.sources(MainServer.class);
    	 }
    	
    }

3.application.properties配置文件加入配置

server.port=8010
    server.contextPath=/springboot
    spring.datasource.url=jdbc:mysql://localhost:3306/test
    spring.datasource.username=root
    spring.datasource.password=root
    spring.datasource.driver-class-name=com.mysql.jdbc.Driver
    spring.datasource.max-idle=10
    spring.datasource.max-wait=10000
    spring.datasource.min-idle=5
    spring.datasource.initial-size=5
    
    spring.mvc.view.prefix=/WEB-INF/jsp/
    spring.mvc.view.suffix=.jsp
    spring.thymeleaf.cache=false
    spring.thymeleaf.enabled=false
    #mybatis
    mybatis.mapper-locations=classpath\:mybatis/mapper/*.xml

4.新建LoginController.java

package com.hu.Controller;
    
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RequestMethod;
    @Controller
    public class LoginController {
    	/**
    	  * 登录页面
    	  * @return
    	  */
    	 @RequestMapping(value = "/login",method = RequestMethod.GET)
    	 public String login(){
    		 System.out.println("进入到登陆页=====================");
    		 return "login";
    	 }
    }

5.更改UserDao.java

package com.hu.dao;
    
    import org.apache.ibatis.annotations.Mapper;
    import org.apache.ibatis.annotations.Param;
    
    import com.hu.entity.User;
    @Mapper
    public interface UserDao {
    	 User findByName(@Param("username") String username);
    	 int insert(@Param("username") String name, @Param("password") String password);
    }

6.在resources下面新建文件夹mybatis-->在mybatis下面新建mapper文件夹-->在mapper文件夹下面建UserMapper.xml

<?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" >
    <mapper namespace="com.hu.dao.UserDao" >
        <resultMap id="BaseResultMap" type="com.hu.entity.User" >
            <id column="id" property="id" jdbcType="INTEGER" />
            <result column="username" property="username" jdbcType="VARCHAR" />
            <result column="password" property="password" jdbcType="VARCHAR" />
        </resultMap>
        <sql id="Base_Column_List" >
            id, username, password
        </sql>
        <select id="findByName" resultMap="BaseResultMap" parameterType="java.lang.String" >
            select
            <include refid="Base_Column_List" />
            from userinfo
            where username = #{username,jdbcType=VARCHAR}
        </select>
        <insert id="insert" parameterType="com.hu.entity.User" >
            insert into userinfo (username, password)
            values (#{username,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR})
        </insert>
    </mapper>

7.运行MainServer 中的main方法进行测试

![70][]

①、在浏览器中输入http://localhost:8010/springboot/login

![70 1][]

证明我们的jsp页面整合成功。

②、在浏览器中输入http://localhost:8010/springboot/find?username=xiaoming

![70 2][]

![70 3][]

看到这也就证明我们整合Mybatis的xml文件成功，能看到数据前提是数据库中有数据，根据自己的库进行访问。

项目地址：[https://download.csdn.net/download/huxiangen/10530109][https_download.csdn.net_download_huxiangen_10530109]

[spring boot]: https://blog.csdn.net/huxiangen/article/details/80911192
[70]: /images/20220520/bfb892ba62394a409d17f2b0a9186ced.png
[70 1]: /images/20220520/b69d06c2a9664b5c8207459c6cf8a0c9.png
[70 2]: /images/20220520/134bec71db554815a0da04760cbda5f3.png
[70 3]: /images/20220520/ed91bf89553c4c168500b5e8d9952319.png
[https_download.csdn.net_download_huxiangen_10530109]: https://download.csdn.net/download/huxiangen/10530109