springMVC、spring、mybatis整合测试

经过上一遍，咱们已经ssm框架已经整合完了，现在开始测试是否整合成功

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的数据。这里就不写sql了。

  2、编写java代码

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

Model类如下

package wqh.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="wqh.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 wqh.dao;

import wqh.model.User;

public interface UserMapper {
	

	public User selectByPrimaryKey(String id);

	
}

Service层代码如下

接口

package wqh.service;

import wqh.model.User;

public interface UserServiceI {

	public User getUserById(String id);


}

实现类

package wqh.service;

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

import wqh.dao.UserMapper;
import wqh.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 wqh.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 wqh.model.User;
import wqh.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

显示如下结果

最后SSM开发环境搭建成功。