栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

SSM整合

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

SSM整合

SSM整合
基于【狂神说Java】Spring5最新完整教程IDEA版通俗易懂
视频地址:https://www.bilibili.com/video/BV1aE41167Tu
笔记地址:https://www.kuangstudy.com/zl/ssm#1381880045424898050
免责说明:笔记参照原来《狂神SSM教程》里的Spring MVC笔记为模板做的笔记。会有大量相同的笔记。仅用于个人学习。用来发博客

ssm是由mybatis,spring,spring-mvc组成的

  • Spring Mvc:主要作用,跳转页面,接收参数,负责Controller层。
  • Spring:管理bean,处理业务,负责Service层。
  • MyBatis:和数据打交道,处理Sql,Dao层。
1、使用MySQL数据库搭建一个简单的表
CREATE DATABASE `ssm`;
USE `ssm`;
DROp TABLE IF EXISTS `users`;
CREATE TABLE `ssm`.`users`  (
  `user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户名',
  `sex` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '性别,0男,1女',
  `tel` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系电话',
  `mail` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮件',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '状态,0正常,1禁用',
  PRIMARY KEY (`user_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;
INSERT INTO `users`(`user_name`, `sex`, `tel`, `mail`, `status`) VALUES 
('admin', '0', '123456', '', '0'),
('user1', '0', '123456', '', '0');
2、使用idea新建Maven项目

添加Pom依赖




  4.0.0

  org.example
  ssm-user
  1.0-SNAPSHOT
  war

  ssm-user Maven Webapp
  
  http://www.example.com

  
    UTF-8
    1.7
    1.7
  

  
    
    
      junit
      junit
      4.12
    
    
    
      mysql
      mysql-connector-java
      5.1.48
    
    
    
      com.mchange
      c3p0
      0.9.5.2
    
    
    
    
      javax.servlet
      javax.servlet-api
      4.0.1
      provided
    
    
    
      javax.servlet.jsp
      javax.servlet.jsp-api
      2.3.3
      provided
    
    
      javax.servlet
      jstl
      1.2
    
    
    
      org.mybatis
      mybatis
      3.5.2
    
    
      org.mybatis
      mybatis-spring
      2.0.2
    
    
    
      org.springframework
      spring-webmvc
      5.2.0.RELEASE
    
    
    
    
      org.springframework
      spring-jdbc
      5.2.0.RELEASE
    
    
    
      org.projectlombok
      lombok
      1.18.10
    

    
    
      javax.annotation
      javax.annotation-api
      1.3.2
    
  



  
    
      
        src/main/java
        
          ***.xml
        
        false
      
      
        src/main/resources
        
          ***.xml
        
        false
      
    
  


3、创建基本结构和配置框架!
  1. 建mapper包

  2. 建pojo包

  3. 建service包

  4. 建controller包

4、编写mybatis层 1、db.properties连接数据库
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssm
jdbc.username=root
jdbc.password=123456
2、实体类pojo

Users.java

package com.zl.pojo;

public class Users {
    private int userId;
    private String userName;
    private String sex;
    private String tel;
    private String mail;
    private String status;

    public Users() {
    }

    public Users(int userId, String userName, String sex, String tel, String mail, String status) {
        this.userId = userId;
        this.userName = userName;
        this.sex = sex;
        this.tel = tel;
        this.mail = mail;
        this.status = status;
    }
    public Users( String userName, String sex, String tel, String mail, String status) {
        this.userName = userName;
        this.sex = sex;
        this.tel = tel;
        this.mail = mail;
        this.status = status;
    }

    @Override
    public String toString() {
        return "Users{" +
                "userId=" + userId +
                ", userName='" + userName + ''' +
                ", sex='" + sex + ''' +
                ", tel='" + tel + ''' +
                ", mail='" + mail + ''' +
                ", status='" + status + ''' +
                '}';
    }

    public int getUserId() {
        return userId;
    }

    public void setUserId(int userId) {
        this.userId = userId;
    }

    public String getUserName() {
        return userName;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public String getTel() {
        return tel;
    }

    public void setTel(String tel) {
        this.tel = tel;
    }

    public String getMail() {
        return mail;
    }

    public void setMail(String mail) {
        this.mail = mail;
    }

    public String getStatus() {
        return status;
    }

    public void setStatus(String status) {
        this.status = status;
    }
}

3、mapper层接口

UsersMapper.java

package com.zl.mapper;

import com.zl.pojo.Users;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface UsersMapper {
//    添加
    int addUsers(Users users);
//    查询
    List allUsers(Users users);
//    根据ID查询
    Users getUsersById(@Param("id") int id);
//    修改
    int updateUsers(Users users);
//    删除
    int delUsers(@Param("id") int id);

}

4、创建对应的UsersMapper.xml



    
        insert into users (user_name, sex, tel, mail, status)
        values (#{userName},#{sex},#{tel},#{mail},#{status});
    
    
        delete
        from users
        where user_id=#{id};
    
    
        update users
        set user_name= #{userName},
        sex= #{sex},
        tel= #{tel},
        mail= #{mail},
        status= #{status}
        where user_id=#{userId};
    

    
        
        
        
        
        
        
    

    
        select *
        from users
        where user_id=#{id};
    


5、service层接口

UsersService.java

package com.zl.service;

import com.zl.pojo.Users;

import java.util.List;

public interface UsersService {
    //    添加
    int addUsers(Users users);
    //    查询
    List allUsers(Users users);
    //    根据ID查询
    Users getUsersById(int id);
    //    修改
    int updateUsers(Users users);
    //    删除
    int delUsers(int id);
}

6、service层接口的实现类

UsersServiceImpl.java

package com.zl.service.Impl;

import com.zl.mapper.UsersMapper;
import com.zl.pojo.Users;
import com.zl.service.UsersService;
import org.springframework.stereotype.Service;

import java.util.List;


public class UsersServiceImpl implements UsersService {
    private UsersMapper usersMapper;

    public void setUsersMapper(UsersMapper usersMapper) {
        this.usersMapper = usersMapper;
    }

    @Override
    public int addUsers(Users users) {
        users.setStatus("0");
        return usersMapper.addUsers(users);
    }

    @Override
    public List allUsers(Users users) {
        return usersMapper.allUsers(users);
    }

    @Override
    public Users getUsersById(int id) {
        return usersMapper.getUsersById(id);
    }

    @Override
    public int updateUsers(Users users) {
        return usersMapper.updateUsers(users);
    }

    @Override
    public int delUsers(int id) {
        return usersMapper.delUsers(id);
    }
}

6、建一个mybatis的xml文件

mybatis-config.xml





    
        
    

这步可以省略,为了展示是ssm我就把这个留下来了

5、spring层 1、编写Spring整合Mybatis的相关的配置文件spring-dao.xml;


    
    
    
    
    
    
        
        
        
        
        
        
        
        
        
        
        
        
        
        
    
    
    

        
        
        
        
        
        
        
        
            
                classpath:com/zl/mapper
    @RequestMapping("/allUsers")
    public String list(Users users,Model model) {
        System.out.println(users);
        List list = usersService.allUsers(users);
        model.addAttribute("list", list);
        return "allUsers";
    }

    
    @RequestMapping("/toadd")
    public String toadd(Model model) {
        return "addUsers";
    }
    
    @RequestMapping("/addUsers")
    public String toadd(Users users) {
        usersService.addUsers(users);
        return "redirect:allUsers";
    }

    
    @RequestMapping("/toupdate/{userId}")
    public String toupdate(@PathVariable int userId,Model model) {
        Users users = usersService.getUsersById(userId);
        model.addAttribute("users",users);
        return "updusers";
    }

    
    @RequestMapping("/updusers")
    public String updusers(Users users) {
        int i = usersService.updateUsers(users);
        return "redirect:allUsers";
    }

    
    @RequestMapping("/del/{userId}")
    public String del(@PathVariable int userId) {
        int count = usersService.delUsers(userId);
        if (count != 0) {
            System.out.println("删除成功");
        }

        return "redirect:allUsers";
    }
    
    @RequestMapping("/info/{userId}")
    public String info(@PathVariable int userId,Model model) {
        Users users = usersService.getUsersById(userId);
        model.addAttribute("users",users);
        return "info";
    }

}

8、前端页面编写jsp 1、首页:index.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>



    首页
    



    点击进入列表页



2、主页面:allUsers.jsp
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    用户列表
    
    
    


序号 用户名称 用户性别 用户电话 操作
${user.getUserId()} ${user.getUserName()} ${user.getSex()==0?"男":"女"} ${user.getTel()} 详情 | 更改 | 删除
3、添加页面:addUsers.jsp
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>


  添加用户
  
  
  


用户名称:


用户性别: 男 女


用户电话:


用户邮箱:


4、修改页面:updusers.jsp
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>


  修改用户
  
  
  


用户名称:


用户性别: 男 女


用户电话:


用户邮箱:


用户状态: 正常 禁用


5、用户详细:info.jsp
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>


  详情信息
  
  
  


用户名称:${users.userName}
用户性别:${users.sex==0?"男":"女"}
用户电话:${users.tel}
用户邮箱:${users.mail}
用户状态:${users.status==0?"正常":"禁用"}
返回
9、项目整体结构

10、测试

配置Tomcat,进行运行!

建议写一个功能就测试一下,不然一股脑敲完,出现问题人都麻了

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/956492.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号