spring-mvc-mybatis

首先安装tomcat 在windows中

注意:tomcat在安装的过程中出现的第一个路径不是tomcat安装路径 而是jre的文件路径 第2个路径才是tomcat的安装路径

创建一个maven webapp工程

进入maven 修改3个地方

加载tomcat

项目结构

pom.xml

<?xml version="1.0" encoding="UTF-8"?>

<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>cn.kgc</groupId>
  <artifactId>springmvcmybatis</artifactId>
  <version>1.0</version>
  <packaging>war</packaging>

  <name>springmvcmybatis Maven Webapp</name>
  <!-- FIXME change it to the project's website -->
  <url>http://www.example.com</url>

  <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <maven.compiler.source>1.8</maven.compiler.source>
    <maven.compiler.target>1.8</maven.compiler.target>
  </properties>

  <dependencies>
    <dependency>
      <groupId>log4j</groupId>
      <artifactId>log4j</artifactId>
      <version>1.2.17</version>
    </dependency>
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.47</version>
    </dependency>
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.5.6</version>
    </dependency>
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis-spring</artifactId>
      <version>2.0.6</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context</artifactId>
      <version>5.3.8</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>5.3.8</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-web</artifactId>
      <version>5.3.8</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-webmvc</artifactId>
      <version>5.3.8</version>
    </dependency>
    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <artifactId>jackson-databind</artifactId>
      <version>2.12.3</version>
    </dependency>
    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <artifactId>jackson-core</artifactId>
      <version>2.12.3</version>
    </dependency>
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>javax.servlet-api</artifactId>
      <version>4.0.1</version>
    </dependency>
  </dependencies>

  <build>
    <finalName>springmvcmybatis</finalName>
    <pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->
      <plugins>
        <plugin>
          <artifactId>maven-clean-plugin</artifactId>
          <version>3.1.0</version>
        </plugin>
        <!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging -->
        <plugin>
          <artifactId>maven-resources-plugin</artifactId>
          <version>3.0.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-compiler-plugin</artifactId>
          <version>3.8.0</version>
        </plugin>
        <plugin>
          <artifactId>maven-surefire-plugin</artifactId>
          <version>2.22.1</version>
        </plugin>
        <plugin>
          <artifactId>maven-war-plugin</artifactId>
          <version>3.2.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-install-plugin</artifactId>
          <version>2.5.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-deploy-plugin</artifactId>
          <version>2.8.2</version>
        </plugin>
      </plugins>
    </pluginManagement>
  </build>
</project>

UserMapper

package cn.kgc.smmvc.biz.mapper;

import cn.kgc.smmvc.entity.UserCond;
import cn.kgc.smmvc.entity.UserInfo;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface UserMapper {
    @Select("select * from user_info limit 0,10")
    List<UserInfo> top10();

    @Select("select * from user_info where user_id=#{user_id}")
    UserInfo findById(int user_id);

    @Select("select count(1) from user_info where user_account=#{acc} and user_pass=md5(#{pass})")
    int login(@Param("acc") String account,@Param("pass") String password);

    /**
     * 一个参数随便写
     * 两个以上三个以内参数 直接入参,但是要➕注解
     * >3个参数 ,封装入参
     * @return
     */
    List<UserInfo> findBy(UserCond uc);
}

UserService

package cn.kgc.smmvc.biz.service;


import cn.kgc.smmvc.biz.mapper.UserMapper;
import cn.kgc.smmvc.entity.UserCond;
import cn.kgc.smmvc.entity.UserInfo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class UserService {
    @Autowired
    UserMapper userMapper;

    public List<UserInfo> top10(){
        return userMapper.top10();
    }

    public boolean login(String acc,String pass){
        return userMapper.login(acc,pass)>0;
    }

    public List<UserInfo> findBy(UserCond uc){
        return userMapper.findBy(uc);
    }

    public UserInfo findById(int user_id){
        return userMapper.findById(user_id);
    }

}

UserControl

package cn.kgc.smmvc.control;


import cn.kgc.smmvc.biz.service.UserService;
import cn.kgc.smmvc.entity.Message;
import cn.kgc.smmvc.entity.UserCond;
import cn.kgc.smmvc.entity.UserInfo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.transaction.annotation.Isolation;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.bind.annotation.*;

import java.sql.SQLException;
import java.util.List;

//http://localhost:8080/user
@RestController
@CrossOrigin("*")
@RequestMapping("/user") //    /表示从根路径开始  http://localhost:8080/user
public class UserControl {
    @Autowired
    UserService userService;

    @RequestMapping("/top10.do")
    public Message top10(){
        return Message.succeed(userService.top10());
    }

    @Transactional(rollbackFor = SQLException.class,isolation = Isolation.READ_COMMITTED,propagation = Propagation.REQUIRED)
    @RequestMapping("/fb.do")
    public Message findBy(UserCond uc){
        return Message.succeed(userService.findBy(uc));
    }


    @RequestMapping("/login.do")
    public Message login(@RequestParam("acc") String acc,@RequestParam("pass") String pass){
        return Message.succeed(userService.login(acc,pass));
    }

    @RequestMapping("/{id}/fbi.do")
    public Message findById(@PathVariable("id") int user_id){
        return Message.succeed(userService.findById(user_id));
    }

}

Message 为页面加载成功失败准备的类对象

package cn.kgc.smmvc.entity;

public abstract class Message<T> {
    private int code;
    private T t;

    public static<T> Message succeed(T t){
        return new Message(200,t) {};
    }

    public static <T> Message fail(){
        return new Message(500,null) {};
    }

    private Message(int code,T t){
        this.code = code;
        this.t = t;
    }

    public int getCode() {
        return code;
    }

    public T getT() {
        return t;
    }
}

UserCond 为传参准备的用户对象

package cn.kgc.smmvc.entity;

public class UserCond {
    private String user_name;
    private String user_gender;
    private Integer user_id;

    public String getUser_name() {
        return user_name;
    }

    public String getUser_gender() {
        return user_gender;
    }

    public Integer getUser_id() {
        return user_id;
    }
}

UserInfo 与数据库中的列值 数据类型名称 是一一对应的关系

package cn.kgc.smmvc.entity;

public class UserInfo {
    private Integer user_id;
    private String user_name;
    private String user_account;
    private String user_pass;
    private String user_gender;
    private String user_phone;
    private String user_pid;
    private String user_province;
    private String user_city;
    private String user_district;
    private String user_address;
    private Double user_balance;

    public String getUser_gender() {
        return user_gender;
    }

    public void setUser_gender(String user_gender) {
        this.user_gender = user_gender;
    }

    public Integer getUser_id() {
        return user_id;
    }

    public void setUser_id(Integer user_id) {
        this.user_id = user_id;
    }

    public String getUser_name() {
        return user_name;
    }

    public void setUser_name(String user_name) {
        this.user_name = user_name;
    }

    public String getUser_account() {
        return user_account;
    }

    public void setUser_account(String user_account) {
        this.user_account = user_account;
    }

    public String getUser_pass() {
        return user_pass;
    }

    public void setUser_pass(String user_pass) {
        this.user_pass = user_pass;
    }

    public String getUser_phone() {
        return user_phone;
    }

    public void setUser_phone(String user_phone) {
        this.user_phone = user_phone;
    }

    public String getUser_pid() {
        return user_pid;
    }

    public void setUser_pid(String user_pid) {
        this.user_pid = user_pid;
    }

    public String getUser_province() {
        return user_province;
    }

    public void setUser_province(String user_province) {
        this.user_province = user_province;
    }

    public String getUser_city() {
        return user_city;
    }

    public void setUser_city(String user_city) {
        this.user_city = user_city;
    }

    public String getUser_district() {
        return user_district;
    }

    public void setUser_district(String user_district) {
        this.user_district = user_district;
    }

    public String getUser_address() {
        return user_address;
    }

    public void setUser_address(String user_address) {
        this.user_address = user_address;
    }

    public Double getUser_balance() {
        return user_balance;
    }

    public void setUser_balance(Double user_balance) {
        this.user_balance = user_balance;
    }
}

datasource.properties

mysql.driver=com.mysql.jdbc.Driver
mysql.url=jdbc:mysql://192.168.75.245:3306/test?useSSL=false
mysql.username=root
mysql.password=Fang@123

log4j.properties

log4j.rootLogger=INFO, stdout
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d %p [%c] - %m%n
log4j.appender.logfile=org.apache.log4j.FileAppender
log4j.appender.logfile.File=log/hd.log
log4j.appender.logfile.layout=org.apache.log4j.PatternLayout
log4j.appender.logfile.layout.ConversionPattern=%d %p [%c] - %m%n

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="cn.kgc.smmvc.biz.mapper.UserMapper">

    <select id="findBy" parameterType="UserCond" resultType="UserInfo">
        select * from user_info
        <where>
            <choose>
                <when test="null != user_id">
                    user_id=#{user_id}
                </when>
                <otherwise>
                    <if test="null != user_name">
                        and user_name like concat('%',#{user_name},'%')
                    </if>
                    <if test="null != user_gender">
                        and user_gender=#{user_gender}
                    </if>
                </otherwise>
            </choose>
        </where>
    </select>


</mapper>

spring-mybatis.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="
       http://www.springframework.org/schema/beans
       http://www.springframework.org/schema/beans/spring-beans.xsd
       http://www.springframework.org/schema/context
       http://www.springframework.org/schema/context/spring-context.xsd
">

    <context:property-placeholder location="classpath*:datasource.properties"/>
    <context:annotation-config/><!--启动注解配置-->
    <context:component-scan base-package="cn.kgc.smmvc.biz"/><!--将这个包下面的对象创建出来-->
    <!-- springframework 控制数据源连接和事务 -->
    <bean id="dataSource"  class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="${mysql.driver}"/>
        <property name="url" value="${mysql.url}"/>
        <property name="username" value="${mysql.username}"/>
        <property name="password" value="${mysql.password}"/>
    </bean>
    <!--springframework 声明式事务配置 -->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"/> <!--前面的dataSource是 上面class类里面的一个属性 后面的dataSource是 bean id-->
    </bean>

    <!--配mybatis-spring 创建sqlSessionFactory-->
    <bean id="sessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <property name="typeAliasesPackage" value="cn.kgc.smmvc.entity"/>
        <property name="mapperLocations" value="classpath*:mapping/*Mapper.xml"/>
    </bean>

    <!--mybatis-spring 配置扫描路径托管mapper对象给spring容器-->
    <bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="sqlSessionFactoryBeanName" value="sessionFactory"/>
        <property name="basePackage" value="cn.kgc.smmvc.biz.mapper"/><!--这样可以创建mapper对象 其他的都有bean mapper没有-->
    </bean>
</beans>

spring_mvc.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="
       http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
       http://www.springframework.org/schema/context  http://www.springframework.org/schema/context/spring-context.xsd
       http://www.springframework.org/schema/mvc  http://www.springframework.org/schema/mvc/spring-mvc.xsd

">


    <context:annotation-config/>
    <context:component-scan base-package="cn.kgc.smmvc.control"/>
    <mvc:annotation-driven/>
    <mvc:default-servlet-handler/>

</beans>

index.jsp

<html>
<body>
<h2>congratulations and welcome to springmvcmyubatis</h2>
</body>
</html>

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee
                  http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
         version="4.0">
  <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>classpath*:spring-mybatis.xml</param-value>
  </context-param>

  <listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>

  <filter>
    <filter-name>CharSetFilter</filter-name>
    <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
    <init-param>
      <param-name>encoding</param-name>
      <param-value>UTF-8</param-value>
    </init-param>
    <init-param>
      <param-name>forceEncoding</param-name>
      <param-value>true</param-value>
    </init-param>
  </filter>
  <filter-mapping>
    <filter-name>CharSetFilter</filter-name>
    <url-pattern>/*</url-pattern>
  </filter-mapping>

  <servlet>
    <servlet-name>DispatchedServlet</servlet-name>
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    <init-param>
      <param-name>contextConfigLocation</param-name>
      <param-value>classpath*:spring_mvc.xml</param-value>
    </init-param>
    <load-on-startup>1</load-on-startup>
  </servlet>
  <servlet-mapping>
    <servlet-name>DispatchedServlet</servlet-name>
    <url-pattern>*.do</url-pattern>
  </servlet-mapping>

  <welcome-file-list>
    <welcome-file>index.jsp</welcome-file>
  </welcome-file-list>

</web-app >

测试:

网页登录:
localhost:8080/user/top10.do
localhost:8080/user/fb.do?gender=女
localhost:8080/user/1/fbi.do
localhost:8080/user/login.do?acc=FangLiang&pass=123456