mars-maven springMVC、spring、mybatis整合测试

1、搭建测试环境

使用MySQL数据库，新建wqh数据库，后新建表，创建表的sql如下

CREATE TABLE `tmenu` (
  `ID` varchar(36) NOT NULL,
  `ICONCLS` varchar(100) DEFAULT NULL,
  `SEQ` decimal(22,0) DEFAULT NULL,
  `TEXT` varchar(100) DEFAULT NULL,
  `URL` varchar(200) DEFAULT NULL,
  `PID` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `tresource` (
  `ID` varchar(36) NOT NULL,
  `SEQ` decimal(22,0) DEFAULT NULL,
  `TEXT` varchar(100) DEFAULT NULL,
  `URL` varchar(200) DEFAULT NULL,
  `PID` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `trole` (
  `ID` varchar(36) NOT NULL,
  `TEXT` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `tuser` (
  `ID` varchar(36) NOT NULL,
  `CREATEDATETIME` timestamp NULL DEFAULT NULL,
  `MODIFYDATETIME` timestamp NULL DEFAULT NULL,
  `NAME` varchar(100) DEFAULT NULL,
  `PWD` varchar(50) DEFAULT NULL,
  `CREATE_TIME` date DEFAULT NULL,
  `UPDATE_TIME` date DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `trole_tresource` (
  `ID` varchar(255) NOT NULL,
  `RESOURCE_ID` varchar(36) DEFAULT NULL,
  `ROLE_ID` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `TRESOURCEID` (`RESOURCE_ID`),
  KEY `TROLEID` (`ROLE_ID`),
  CONSTRAINT `TRESOURCEID` FOREIGN KEY (`RESOURCE_ID`) REFERENCES `tresource` (`ID`),
  CONSTRAINT `TROLEID` FOREIGN KEY (`ROLE_ID`) REFERENCES `trole` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `trole_tuser` (
  `ID` varchar(36) NOT NULL,
  `ROLE_ID` varchar(36) DEFAULT NULL,
  `USER_ID` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `tuser_trole` (
  `USER_ID` varchar(36) NOT NULL,
  `ID` varchar(36) DEFAULT NULL,
  `ROLE_ID` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`USER_ID`),
  KEY `TROLE_ID` (`ROLE_ID`),
  CONSTRAINT `TROLE_ID` FOREIGN KEY (`ROLE_ID`) REFERENCES `trole` (`ID`),
  CONSTRAINT `TUSER_ID` FOREIGN KEY (`USER_ID`) REFERENCES `tuser` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

向tuser表里面插入一条id为1的数据。

  2、编写Java代码

在src/main/java文件夹下面编写java代码

Model类如下

package snake.model;

import java.util.Date;

public class User {

    private String id;

    private Date createdatetime;

    private Date modifydatetime;

    private String name;

    private String pwd;

    private Date createTime;

    private Date updateTime;

    public String getId() {
        return id;
    }

    public void setId(String id) {
        this.id = id == null ? null : id.trim();
    }

    public Date getCreatedatetime() {
        return createdatetime;
    }

    public void setCreatedatetime(Date createdatetime) {
        this.createdatetime = createdatetime;
    }

    public Date getModifydatetime() {
        return modifydatetime;
    }

    public void setModifydatetime(Date modifydatetime) {
        this.modifydatetime = modifydatetime;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name == null ? null : name.trim();
    }

    public String getPwd() {
        return pwd;
    }

    public void setPwd(String pwd) {
        this.pwd = pwd == null ? null : pwd.trim();
    }

    public Date getCreateTime() {
        return createTime;
    }

    public void setCreateTime(Date createTime) {
        this.createTime = createTime;
    }

    public Date getUpdateTime() {
        return updateTime;
    }

    public void setUpdateTime(Date updateTime) {
        this.updateTime = updateTime;
    }
}

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="wqh.dao.UserMapper">
    <resultMap id="BaseResultMap" type="snake.model.User">
        <id column="ID" property="id" jdbcType="VARCHAR" />
        <result column="CREATEDATETIME" property="createdatetime" jdbcType="TIMESTAMP" />
        <result column="MODIFYDATETIME" property="modifydatetime" jdbcType="TIMESTAMP" />
        <result column="NAME" property="name" jdbcType="VARCHAR" />
        <result column="PWD" property="pwd" jdbcType="VARCHAR" />
        <result column="CREATE_TIME" property="createTime" jdbcType="DATE" />
        <result column="UPDATE_TIME" property="updateTime" jdbcType="DATE" />
    </resultMap>
    <sql id="Base_Column_List">
        ID, CREATEDATETIME, MODIFYDATETIME, NAME, PWD, CREATE_TIME, UPDATE_TIME
    </sql>
    <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.String">
        select
        <include refid="Base_Column_List" />
        from tuser
        where ID = #{id,jdbcType=VARCHAR}
    </select>
</mapper>

UserMapper.java文件如下

package snake.dao;

import snake.model.User;

public interface UserMapper {
    

    public User selectByPrimaryKey(String id);

    
}

Service层代码如下

接口

package snake.service;

import snake.model.User;

public interface UserServiceI {

    public User getUserById(String id);


}

实现类

package snake.service;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import snake.dao.UserMapper;
import snake.model.User;

@Service("userService")
public class UserServiceImpl implements UserServiceI {

	private UserMapper userMapper;

	public UserMapper getUserMapper() {
		return userMapper;
	}

	@Autowired
	public void setUserMapper(UserMapper userMapper) {
		this.userMapper = userMapper;
	}

	public User getUserById(String id) {
		return userMapper.selectByPrimaryKey(id);
	}

}

　　Controller层代码

package snake.controller;

import javax.servlet.http.HttpServletRequest;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;

import snake.model.User;
import snake.service.UserServiceI;

@Controller
@RequestMapping("/userController")
public class UserController {

    private UserServiceI userService;

    public UserServiceI getUserService() {
        return userService;
    }

    @Autowired
    public void setUserService(UserServiceI userService) {
        this.userService = userService;
    }

    @RequestMapping("/showUser")
    public String showUser(String id, HttpServletRequest request) {
        User u = userService.getUserById(id);
        request.setAttribute("user", u);
        return "showUser";
    }

}

最后在src/main/webapp文件夹下面新建showUser.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<!DOCTYPE html >
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>${user.name}
</body>
</html>

到此，所有测试代码已经写完，进行最后的测试
右键项目名称 -> Run as -> 5Maven Build  -> Goals: 输入clean package

最后在浏览器地址栏输入：http://localhost:8080/webdemo/userController/showUser.do?id=1