经过上一遍,咱们已经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开发环境搭建成功。