ssm（spring+springmvc+mybatis）框架

原创 于 2018-10-19 11:52:33 发布 · 207 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#ssm

本文详细介绍了一个基于Spring、SpringMVC和MyBatis（SSM）框架的项目搭建过程，包括项目目录结构、web.xml配置、Controller、Service、Mapper、Model等关键组件的实现，以及配置文件、数据库表设计和页面展示。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

一、项目目录结构及所需jar包链接：https://pan.baidu.com/s/1B8LOvRXOIQnk8kT_uK-sxA 密码：l985

二、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> -->  
        <param-value>classpath:spring-common.xml,classpath:spring-mvc.xml</param-value>  
          
    </context-param>  
  
    <!-- 配置SpringMVC核心控制器 -->  
    <servlet>  
        <servlet-name>springMVC</servlet-name>  
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>  
        <!-- 配置初始配置化文件,前面contextConfigLocation看情况二选一 -->    
        <init-param>  
            <param-name>contextConfigLocation</param-name>  
            <param-value>classpath:spring-common.xml,classpath:spring-mvc.xml</param-value>  
        </init-param>  
        <!-- 启动加载一次 -->    
        <load-on-startup>1</load-on-startup>  
    </servlet>  
  
    <!--为DispatcherServlet建立映射 -->  
    <servlet-mapping>  
        <servlet-name>springMVC</servlet-name>  
        <!-- 此处可以可以配置成*.do，对应struts的后缀习惯 -->  
        <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>

三、相关包、类controller、service、service.Impl、mapper、model

UserController类：

package com.pmm.controller;

import java.io.IOException;  
import java.io.PrintWriter;  
import java.util.List;  
  
import javax.servlet.http.HttpServletRequest;  
import javax.servlet.http.HttpServletResponse;  
  
import org.springframework.beans.factory.annotation.Autowired;  
import org.springframework.stereotype.Controller;  
import org.springframework.ui.Model;  
import org.springframework.web.bind.annotation.RequestMapping;  
  
import com.pmm.model.User;  
import com.pmm.service.UserService;  
 
@Controller  
@RequestMapping("/user")  
public class UserController {  
    @Autowired  
    private UserService userService;  
    /**  
     * 获取所有用户列表  
     * @param request  
     * @return  
     */  
    @RequestMapping("/getAllUser")  
    public String getAllUser(HttpServletRequest request,Model model){  
        List<User> user = userService.findAll();  
        model.addAttribute("userList", user);  
        request.setAttribute("userList", user);  
        return "/allUser";  
    }  
    /**  
     * 跳转到添加用户界面  
     * @param request  
     * @return  
     */  
    @RequestMapping("/toAddUser")  
    public String toAddUser(){  
        return "/addUser";  
    }  
    /**  
     * 添加用户并重定向  
     * @param user  
     * @param request  
     * @return  
     */  
    @RequestMapping("/addUser")  
    public String addUser(User user,Model model){  
        userService.save(user);  
        return "redirect:/user/getAllUser";  
    }  
    /**  
     *编辑用户  
     * @param user  
     * @param request  
     * @return  
     */  
    @RequestMapping("/updateUser")  
    public String updateUser(User user,HttpServletRequest request,Model model){  
        if(userService.update(user)==1){  
            user = userService.findById(user.getId());  
            request.setAttribute("user", user);  
            model.addAttribute("user", user);  
            return "redirect:/user/getAllUser";  
        }else{  
            return "/error";   
        }  
    }  
    /**  
     * 根据id查询单个用户  
     * @param id  
     * @param request  
     * @return  
     */  
    @RequestMapping("/getUser")  
    public String getUser(int id,HttpServletRequest request,Model model){  
        request.setAttribute("user", userService.findById(id));  
        model.addAttribute("user", userService.findById(id));  
        return "/editUser";  
    }  
    /**  
     * 删除用户  
     * @param id  
     * @param request  
     * @param response  
     */  
    @RequestMapping("/delUser")  
    public String delUser(int id,HttpServletRequest request,HttpServletResponse response){  
        if(userService.delete(id)==1){  
        	return "redirect:/user/getAllUser";
        }else{
        	return "/error";
        }
        	
    }  
}

UserMapper接口

package com.pmm.mapper;
import java.util.List;
import com.pmm.model.User;

public interface UserMapper {    
    void save(User user);    
    int update(User user);    
    int delete(int id);    
    User findById(int id);    
    List<User> findAll();    
}

User类

package com.pmm.model;

public class User {    
    
    private int id;    
    private String userName;   
    private String age;    
      
    @Override  
    public String toString() {  
        return "User [id=" + id + ", age=" + age + ", userName=" + userName  
                + "]";  
    }  
    public User(){    
        super();    
    }    
    public int getId() {    
        return id;    
    }    
    public void setId(int id) {    
        this.id = id;    
    }    
    public String getAge() {    
        return age;    
    }    
    public void setAge(String age) {    
        this.age = age;    
    }    
    public String getUserName() {    
        return userName;    
    }    
    public void setUserName(String userName) {    
        this.userName = userName;    
    }    
    public User(int id, String age, String userName) {    
        super();    
        this.id = id;    
        this.age = age;    
        this.userName = userName;    
    }    
}

UserService接口

package com.pmm.service;

import java.util.List;

import com.pmm.model.User;

public interface UserService {  
    void save(User user);  
    int update(User user);  
    int delete(int id);  
    User findById(int id);  
    List<User> findAll();  
}

UserServiceImpl类

package com.pmm.service.impl;
import java.util.List;  
  
import javax.annotation.Resource;  
  
import org.springframework.stereotype.Service;  
import org.springframework.transaction.annotation.Transactional;  
  
import com.pmm.mapper.UserMapper;  
import com.pmm.model.User;  
import com.pmm.service.UserService;  
 
@Service  
@Transactional  
// 此处不再进行创建SqlSession和提交事务，都已交由spring去管理了。  
public class UserServiceImpl implements UserService {  
 
    @Resource  
    private UserMapper mapper;  
  
    /**  
     * 根据  id  删除 数据  
     */  
    public int delete(int id) {  
        return mapper.delete(id);  
    }  
    /**  
     * 查询User的全部数据  
     */  
    public List<User> findAll() {  
        List<User> findAllList = mapper.findAll();  
        return findAllList;  
    }  
    /**  
     * 根据 id 查询 对应数据  
     */  
    public User findById(int id) {  
        User user = mapper.findById(id);  
        return user;  
    }  
    /**  
     * 新增数据  
     */  
    public void save(User user) {  
        mapper.save(user);  
    }  
    /**  
     * 根据 id 修改对应数据  
     */  
    public int update(User user) {  
        return mapper.update(user);  
    }  
  
}

四、配置文件config（log4j.properties、mybatis-config.xml、spring-common.xml、spring-mvc.xml、userMapper.xml）

### set log levels ###   
log4j.rootLogger = info , Console , D  
#Console  
log4j.appender.Console=org.apache.log4j.ConsoleAppender  
log4j.appender.Console.layout=org.apache.log4j.PatternLayout  
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n  
log4j.logger.java.sql.ResultSet=INFO  
log4j.logger.org.apache=INFO  
log4j.logger.java.sql.Connection=INFO  
log4j.logger.java.sql.Statement=INFO  
log4j.logger.java.sql.PreparedStatement=INFO  
#output2file  
log4j.appender.D = org.apache.log4j.DailyRollingFileAppender   
log4j.appender.D.File = D\:/logs/log.log   
log4j.appender.D.Append = true   
log4j.appender.D.Threshold = INFO \#\# \u00E8\u00BE\u0093\u00E5\u0087\u00BAinfo\u00E7\u00BA\u00A7\u00E5\u0088\u00AB\u00E4\u00BB\u00A5\u00E4\u00B8\u008A\u00E7\u009A\u0084\u00E6\u0097\u00A5\u00E5\u00BF\u0097   
log4j.appender.D.layout = org.apache.log4j.PatternLayout   
log4j.appender.D.layout.ConversionPattern =%-d{yyyy-MM-dd HH\:mm\:ss} [ %t\:%r ] - [ %p ] %m%n

 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>  
        <typeAlias alias="User" type="com.pmm.model.User" />  
    </typeAliases>  
    <!-- 实体接口映射资源 -->  
    <!--  
        说明：如果xxMapper.xml配置文件放在和xxMapper.java统一目录下，mappers也可以省略，因为org.mybatis.spring.mapper.MapperFactoryBean默认会去查找与xxMapper.java相同目录和名称的xxMapper.xml  
    -->  
    <mappers>  
        <mapper resource="userMapper.xml" />  
    </mappers>  
</configuration>

 spring-common.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">  
  
<!-- Mybatis和Spring的整合 -->  
    <!-- 1. 数据源 : DriverManagerDataSource -->  
    <bean id="dataSource"  
        class="org.springframework.jdbc.datasource.DriverManagerDataSource">  
        <property name="driverClassName" value="com.mysql.jdbc.Driver" />  
        <property name="url" value="jdbc:mysql://localhost:3306/ssm" />  
        <property name="username" value="root" />  
        <property name="password" value="123456" />  
    </bean>  
  
    <!--  
        2. mybatis的SqlSession的工厂: SqlSessionFactoryBean dataSource:引用数据源  
  
        MyBatis定义数据源,同意加载配置  
    -->  
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">  
        <property name="dataSource" ref="dataSource"></property>  
        <property name="configLocation" value="classpath:mybatis-config.xml" />   
    </bean>  
  
    <!--  
        3. mybatis自动扫描加载Sql映射文件/接口 : MapperScannerConfigurer sqlSessionFactory  
  
        basePackage:指定sql映射文件/接口所在的包（自动扫描）  
    -->  
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">  
        <property name="basePackage" value="com.pmm.mapper"></property>  
        <property name="sqlSessionFactory" ref="sqlSessionFactory"></property>  
    </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-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/mvc  
    http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">  
  
    <!-- 注解扫描包 -->  
    <context:component-scan base-package="com.pmm.controller" />  
    <context:component-scan base-package="com.pmm.service" />  
  
    <!-- 开启注解 -->  
    <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>

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">    
<!--     
    namespace：必须与对应的接口全类名一致  UserMapper.java  
    id ：必须与对应接口的某个对应的方法名一致即必须要和UserMapper.java接口中的方法同名。  
 -->    
 <mapper namespace="com.pmm.mapper.UserMapper">  
   
    <insert id="save" parameterType="User">  
        insert into t_user(user_name,user_age) values(#{userName},#{age})  
    </insert>  
      
    <update id="update" parameterType="User">    
        update t_user set user_name=#{userName},user_age=#{age} where user_id=#{id}    
    </update>   
      
    <delete id="delete" parameterType="int">    
        delete from t_user where user_id=#{id}    
    </delete>    
        
     <!-- mybsits_config中配置的alias类别名,也可直接配置resultType为类路径 -->      
    <select id="findById" parameterType="int" resultType="User">    
        select user_id id,user_name userName,user_age age from t_user where user_id=#{id}    
    </select>    
        
    <select id="findAll" resultType="User">    
        select user_id id,user_name userName,user_age age from t_user    
    </select>   
      
 </mapper>

五、数据库  （数据库名：ssm      另外两张表：t_user、user_t）

CREATE TABLE `t_user` (  
  `user_id` INT(11) NOT NULL AUTO_INCREMENT,  
  `user_name` VARCHAR(20) NOT NULL,  
  `user_age` VARCHAR(20) NOT NULL,  
  PRIMARY KEY (`user_id`)  
) ENGINE=INNODB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8; 

CREATE TABLE `user_t` (  
  `id` INT(11) NOT NULL AUTO_INCREMENT,  
  `user_name` VARCHAR(40) NOT NULL,  
  `password` VARCHAR(255) NOT NULL,  
  `age` INT(4) NOT NULL,  
  PRIMARY KEY (`id`)  
) ENGINE=INNODB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

六、页面 （index.jsp）  WEB-INF新建jsp目录（包含addUser.jsp、allUser.jsp、editUser.jsp、error.jsp）

index.jsp

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>  
<%  
    String path = request.getContextPath();  
    String basePath = request.getScheme() + "://"  
            + request.getServerName() + ":" + request.getServerPort()  
            + path + "/";  
%>  
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">  
<html>  
<head>  
<base href="<%=basePath%>">  
<title>首页</title>  
</head>  
<body>  
    <h5>  
        <a href="<%=basePath%>user/getAllUser">进入用户管理页</a>  
    </h5>  
</body>  
</html>

 addUser.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>添加用户</title>  
      
    <script type="text/javascript">  
    function addUser(){  
        var form = document.forms[0];  
        form.action = "<%=basePath%>user/addUser";  
        form.method="post";  
        form.submit();  
    }  
</script>  
  
  </head>  
    
  <body>  
    <h1><%=path%>添加用户<%=basePath%></h1>  
    <form action="" name="userForm">  
        姓名：<input type="text" name="userName">  
        年龄：<input type="text" name="age">  
        <input type="button" value="添加" onclick="addUser()">  
    </form>  
  </body>  
</html>

allUser.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%>">  
    <script type="text/javascript" src="js/jquery-1.7.1.js"></script>  
    <title>用户列表</title>  
  </head>  
    
  <body>  
    <h6><a href="<%=basePath%>user/toAddUser">添加用户</a></h6>  
    <table border="1">  
        <tbody>  
            <tr>  
                <th>姓名</th>  
                <th>年龄</th>  
                <th>操作</th>  
            </tr>  
            <c:if test="${!empty userList }">  
                <c:forEach items="${userList}" var="user">  
                    <tr>  
                        <td>${user.userName }</td>  
                        <td>${user.age }</td>  
                        <td>  
                            <a href="<%=basePath%>user/getUser?id=${user.id}">编辑</a>  
                            <a href="<%=basePath%>user/delUser?id=${user.id}">删除</a> 
                        </td>  
                    </tr>               
                </c:forEach>  
            </c:if>  
        </tbody>  
    </table>  
  </body>  
</html>

editUser.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>编辑用户</title>  
      
    <script type="text/javascript">  
    function updateUser(){  
        var form = document.forms[0];  
        form.action = "<%=basePath%>user/updateUser";  
        form.method="post";  
        form.submit();  
    }  
</script>  
  
  </head>  
    
  <body>  
    <h1>添加用户</h1>  
    <form action="" name="userForm">  
        <input type="hidden" name="id" value="${user.id }"/>  
        姓名：<input type="text" name="userName" value="${user.userName }"/>  
        年龄：<input type="text" name="age" value="${user.age }"/>  
        <input type="button" value="编辑" onclick="updateUser()"/>  
    </form>  
  </body>  
    
</html>

error.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'error.jsp' starting page</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>
    Error. <br>
  </body>
</html>

七、整个项目搭建完成、可进行增删改查操作

傻蛋丫
关注
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值