闲着没事总结下SSM框架搭建;现网上好多的SSM搭建框架教程的目录结构看上去都非常的乱,让我这个有强迫症的人来看,非常糟心,就想着自己总结个;
----------------------------------------------------------------------------------------------------------------------------------
我总结的这个搭建记录有一共用了2张数据库表;提供了两个访问链接;
以下为最终结果
一个:http://localhost:8080/ssm/role/findAllRole
另一个:http://localhost:8080/ssm/user/findAllUser
--------------------------------------------------------------------------------------------------------------------------------
环境:eclipse + mysql
mysql共涉及到2张表
t_user表
CREATE TABLE `t_user` (
`c_id` int(20) NOT NULL,
`c_user_code` varchar(255) DEFAULT NULL,
`c_user_name` varchar(255) DEFAULT NULL,
`c_password` varchar(255) DEFAULT NULL,
`c_age` int(20) DEFAULT NULL,
PRIMARY KEY (`c_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
auth_role_t表
CREATE TABLE `auth_role_t` (
`ROLE_ID` varchar(32) NOT NULL COMMENT '角色标识',
`ROLE_CODE` varchar(32) NOT NULL COMMENT '角色编码',
`ROLE_NAME` varchar(64) NOT NULL COMMENT '角色名称',
`SUP_ROLE_ID` varchar(32) DEFAULT NULL COMMENT '顶层默认为*',
`CREATE_BY` varchar(32) NOT NULL COMMENT '创建人',
`CREATE_DATE` datetime NOT NULL COMMENT '创建时间',
`UPDATE_BY` varchar(32) DEFAULT NULL COMMENT '修改人',
`UPDATE_DATE` datetime DEFAULT NULL COMMENT '修改时间',
`IS_ADMINROLE` char(1) DEFAULT NULL COMMENT '1 是 0 否',
PRIMARY KEY (`ROLE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色表';
-------------------------------------------------------------------------------------------------------------------------
Step1:新建Web项目
Step2:导入Jar包(可自行百度ssmjar包下载)至lib文件下;并建立好SSM所需配置文件
到此项目的目录结构为:
Step3:写入配置文件
一、写入jdbc.properties文件
#MYSQL
jdbc1.driverName=com.mysql.jdbc.Driver
jdbc1.url=jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf-8
jdbc1.user=root
jdbc1.password=root
二、写入mybatis-config.xml文件
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<!-- 别名定义 -->
<typeAliases>
<!-- 批量别名定义,指定包名,mybatis自动扫描包中的po类,自动定义别名,别名是类名(首字母大写或小写都可以,一般用小写) -->
<package name="com.test.ssm"/>
<!-- 针对单个别名定义 type:类型的路径 alias:别名 -->
<!-- <typeAlias alias="User" type="com.test.ssm.user.model.User"/>
<typeAlias alias="Role" type="com.test.ssm.role.model.Role"/> -->
</typeAliases>
</configuration>
三、写入spring.xml文件
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="
http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-4.0.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-4.0.xsd">
<!-- 加载配置文件 -->
<context:property-placeholder location="classpath:config/jdbc.properties"/>
<!-- 1. 数据源 : DriverManagerDataSource -->
<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="${jdbc1.driverName}" />
<property name="url" value="${jdbc1.url}" />
<property name="username" value="${jdbc1.user}" />
<property name="password" value="${jdbc1.password}" />
</bean>
<!-- sqlSessionFactory -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"></property>
<!-- 文件映射器,指定类文件 -->
<property name="configLocation" value="classpath:config/mybatis-config.xml" />
<!-- 自动扫描mapping.xml文件 -->
<property name="mapperLocations" value="classpath*:com/test/ssm/**/*Mapper.xml"/>
</bean>
<!-- 配置SqlSessionTemplate -->
<bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">
<!-- 通过构造函数注入 -->
<constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory" />
</bean>
<!-- 配置mybatis mapper接口 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.test.ssm.**.mapper"/>
<property name="sqlSessionTemplateBeanName" value="sqlSessionTemplate"/>
</bean>
<!--
4. 事务管理 : DataSourceTransactionManager dataSource:引用上面定义的数据源
-->
<bean id="txManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"></property>
</bean>
<!-- 5. 使用声明式事务
transaction-manager:引用上面定义的事务管理器
-->
<tx:annotation-driven transaction-manager="txManager" />
</beans>
四、写入spring-mvc.xml文件
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
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-4.0.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">
<!-- 注解扫描包 -->
<context:component-scan base-package="com.test.ssm" />
<!-- 开启注解 -->
<mvc:annotation-driven />
<!--
配置静态资源,直接映射到对应的文件夹,不被DispatcherServlet处理,3.04新增功能,需要重新设置spring-mvc-3.0.xsd
-->
<mvc:resources mapping="/img/**" location="/img/" />
<mvc:resources mapping="/js/**" location="/js/" />
<mvc:resources mapping="/css/**" location="/css/" />
<mvc:resources mapping="/html/**" location="/html/" />
<!-- 定义跳转的文件的前后缀 ,视图模式配置-->
<bean id="viewResolver"
class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<!-- 这里的配置我的理解是自动给后面action的方法return的字符串加上前缀和后缀,变成一个 可用的url地址 -->
<property name="prefix" value="/WEB-INF/jsp/" />
<property name="suffix" value=".jsp" />
</bean>
</beans>
五、写入web.xml文件
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
<!-- 加载Spring容器配置 -->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!-- 设置Spring容器加载所有的配置文件的路径 -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath*:config/spring.xml</param-value>
</context-param>
<!-- 配置SpringMVC核心控制器 -->
<servlet>
<servlet-name>springMVC</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath*:config/spring-mvc.xml</param-value>
</init-param>
<!-- 启动加载一次 -->
<load-on-startup>1</load-on-startup>
</servlet>
<!--为DispatcherServlet建立映射 -->
<servlet-mapping>
<servlet-name>springMVC</servlet-name>
<!-- 此处可以可以配置成*.do -->
<url-pattern>/</url-pattern>
</servlet-mapping>
<!-- 防止Spring内存溢出监听器 -->
<listener>
<listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class>
</listener>
<!-- 解决工程编码过滤器 -->
<filter>
<filter-name>encodingFilter</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>encodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
</web-app>
Step4:建立2张表所对应的模块的包及文件
至此目录结构为:
---------------------------------------------------------------------------------------------------------------
User模块的文件建立
User模块的目录结构如下图
1.user模块下model包下建立User.java文件
package com.test.ssm.user.model;
public class User {
private int userId;
private String userCode;
private String userName;
private String password;
private int age;
public int getUserId() {
return userId;
}
public void setUserId(int userId) {
this.userId = userId;
}
public String getUserCode() {
return userCode;
}
public void setUserCode(String userCode) {
this.userCode = userCode;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
}
2.user模块下mapper包下建立接口UserMapper.java文件
package com.test.ssm.user.mapper;
import java.util.List;
import org.springframework.stereotype.Repository;
import com.test.ssm.user.model.User;
@Repository
public interface UserMapper {
List<User> findAllUser();
}
3.User模块下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.test.ssm.user.mapper.UserMapper">
<!-- 解决表名与字段不匹配 -->
<resultMap type="User" id="userResultMap">
<id property="userId" column="c_id"/>
<result property="userName" column="c_user_name"/>
<result property="userCode" column="c_user_code"/>
<result property="password" column="c_password"/>
<result property="age" column="c_age"/>
</resultMap>
<select id="findAllUser" resultMap="userResultMap" resultType="User">
select * from t_user
</select>
</mapper>
4.User模块下service包下建立接口UserService.java文件
package com.test.ssm.user.service;
import java.util.List;
import com.test.ssm.user.model.User;
public interface UserService {
List<User> findAllUser();
}
5.User模块下service包下建立impl包;并在impl包下建立UserServiceImpl.java文件;该文件实现UserService接口
package com.test.ssm.user.service.impl;
import java.util.List;
import javax.annotation.Resource;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import com.test.ssm.user.mapper.UserMapper;
import com.test.ssm.user.model.User;
import com.test.ssm.user.service.UserService;
@Service(value="userService")
@Transactional
public class UserServiceImpl implements UserService {
@Resource
public UserMapper userMapper;
@Override
public List<User> findAllUser() {
List<User> findAllUser = userMapper.findAllUser();
return findAllUser;
}
}
6.User模块下Controller包下建立UserController.java文件
package com.test.ssm.user.controller;
import java.util.List;
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 com.test.ssm.user.model.User;
import com.test.ssm.user.service.UserService;
@Controller
@RequestMapping("/user")
public class UserController {
@Autowired
private UserService userService;
@RequestMapping("/findAllUser")
public String findAllUser(HttpServletRequest request) {
List<User> listUser = userService.findAllUser();
request.setAttribute("listUser", listUser);
return "/show";
}
}
至此User模块的java文件编写完成
-------------------------------------------------------------------------------------------------------------------------------
Role模块的编写
Role模块的目录结构如下图:
1.Role模块下model包下Role.java文件编写
package com.test.ssm.role.model;
public class Role {
private String roleId;
private String roleCode;
private String roleName;
private String supRoleId;
private String createBy;
private String createDate;
private String updateBy;
private String updateDate;
private String isAdminRole;
public String getRoleId() {
return roleId;
}
public void setRoleId(String roleId) {
this.roleId = roleId;
}
public String getRoleCode() {
return roleCode;
}
public void setRoleCode(String roleCode) {
this.roleCode = roleCode;
}
public String getRoleName() {
return roleName;
}
public void setRoleName(String roleName) {
this.roleName = roleName;
}
public String getSupRoleId() {
return supRoleId;
}
public void setSupRoleId(String supRoleId) {
this.supRoleId = supRoleId;
}
public String getCreateBy() {
return createBy;
}
public void setCreateBy(String createBy) {
this.createBy = createBy;
}
public String getCreateDate() {
return createDate;
}
public void setCreateDate(String createDate) {
this.createDate = createDate;
}
public String getUpdateBy() {
return updateBy;
}
public void setUpdateBy(String updateBy) {
this.updateBy = updateBy;
}
public String getUpdateDate() {
return updateDate;
}
public void setUpdateDate(String updateDate) {
this.updateDate = updateDate;
}
public String getIsAdminRole() {
return isAdminRole;
}
public void setIsAdminRole(String isAdminRole) {
this.isAdminRole = isAdminRole;
}
}
2.Role模块下mapper包下建立接口RoleMapper.java文件编写
package com.test.ssm.role.mapper;
import java.util.List;
import org.springframework.stereotype.Repository;
import com.test.ssm.role.model.Role;
@Repository
public interface RoleMapper {
List<Role> findAllRole();
}
3.Role模块下mapper包下建立RoleMapper.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.test.ssm.role.mapper.RoleMapper">
<!-- 解决表名与字段不匹配 -->
<resultMap type="Role" id="roleResultMap">
<id property="roleId" column="ROLE_ID"/>
<result property="roleCode" column="ROLE_CODE"/>
<result property="roleName" column="ROLE_NAME"/>
<result property="supRoleId" column="SUP_ROLE_ID"/>
<result property="createBy" column="CREATE_BY"/>
<result property="createDate" column="CREATE_DATE"/>
<result property="updateBy" column="UPDATE_BY"/>
<result property="updateDate" column="UPDATE_DATE"/>
<result property="isAdminRole" column="IS_ADMINROLE"/>
</resultMap>
<select id="findAllRole" resultMap="roleResultMap" resultType="Role">
select * from auth_role_t
</select>
</mapper>
4.Role模块下service包下建立接口RoleService.java文件
package com.test.ssm.role.service;
import java.util.List;
import com.test.ssm.role.model.Role;
public interface RoleService {
List<Role> findAllRole();
}
5.Role模块下service包下建立impl包;并在impl包下建立RoleServiceImpl.java文件并实现接口RoleService
RoleServiceImpl.java的文件编写如下:
package com.test.ssm.role.service.impl;
import java.util.List;
import javax.annotation.Resource;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import com.test.ssm.role.mapper.RoleMapper;
import com.test.ssm.role.model.Role;
import com.test.ssm.role.service.RoleService;
@Service(value="roleService")
@Transactional
public class RoleServiceImpl implements RoleService {
@Resource
public RoleMapper roleMapper;
@Override
public List<Role> findAllRole() {
List<Role> findAllRole = roleMapper.findAllRole();
return findAllRole;
}
}
6.Role模块下controller包下RoleController.java文件编写
package com.test.ssm.role.controller;
import java.util.List;
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 com.test.ssm.role.model.Role;
import com.test.ssm.role.service.RoleService;
@Controller
@RequestMapping("/role")
public class RoleController {
@Autowired
private RoleService roleService;
@RequestMapping("/findAllRole")
public String findAllRole(HttpServletRequest request) {
List<Role> listRole = roleService.findAllRole();
request.setAttribute("listRole", listRole);
return "/showRole";
}
}
至此Role模块的java代码编写完成
---------------------------------------------------------------------------------------------------------------------------------
Step5.建立前台jsp文件显示访问结果
1.建立文件及文件夹
目录结构如下
2.show.jsp文件编写
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>ssm</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<table border="1">
<tbody>
<tr>
<th>姓名</th>
<th>年龄</th>
<th>登录名</th>
<th>密码</th>
</tr>
<c:if test="${!empty listUser }">
<c:forEach items="${listUser}" var="list">
<tr>
<td>${list.userName }</td>
<td>${list.age }</td>
<td>${list.userCode }</td>
<td>${list.password }</td>
</tr>
</c:forEach>
</c:if>
</tbody>
</table>
</body>
</html>
3.showRole.jsp文件编写
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>ssm</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<table border="1">
<tbody>
<tr>
<th>角色编码</th>
<th>角色名称</th>
<th>创建时间</th>
<th>是否管理</th>
</tr>
<c:if test="${!empty listRole }">
<c:forEach items="${listRole}" var="list">
<tr>
<td>${list.roleCode }</td>
<td>${list.roleName }</td>
<td>${list.createDate }</td>
<td>${list.isAdminRole }</td>
</tr>
</c:forEach>
</c:if>
</tbody>
</table>
</body>
</html>
至此SSM简单框架搭建完成。对于强迫症的我来说;这个架子目录结构非常清晰,我很是喜欢。。嘿嘿
-------------------------------------------------------------------------------------------------------------------------------
将项目部署到tomcat中;启动并访问地址
http://localhost:8080/ssm/role/findAllRole
或
http://localhost:8080/ssm/user/findAllUser
-------------------------------------------------------------------------------------------------------------------------------
GitHub项目下载地址
https://github.com/yisuixiaotufei/SSM