当前位置：首页 > news >正文

广东像一起做网店的网站百度竞价规则

news 2025/8/5 19:51:50

广东像一起做网店的网站,百度竞价规则,企业网站黄页怎么做,深圳网站设计服务商上篇我们介绍了搭建spring bootMybatislogbackMysql的框架搭建《spring boot项目搭建示例》这篇博文我们介绍一下如何整合jsp页面以及将项目改成Mybatis映射文件xml的形式步骤如下： 1.pom.xml加入jsp所需的jar包 <project xmlns"http://maven.apache.org/…

上篇我们介绍了搭建spring boot+Mybatis+logback+Mysql的框架搭建《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><!-- spring boot jar --><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><!-- 移除嵌入式tomcat插件 --><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><!-- logback jar --><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-logging</artifactId></dependency><!-- Mybatis/Mysql jar --><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><!-- package jar start--><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><!-- 整合jsp页面 --><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><!-- 整合jsp页面结束 --></dependencies><!-- 打包 jar --><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><!-- package jar end-->
</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项目@Overrideprotected 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=5spring.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 userinfowhere 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方法进行测试