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

SSM整合案例

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

SSM整合案例

ssm+elementui+vue+axios完成单表的crud.

com.lqh下的每个包

controller

        StudentController

package com.lqh.controller;

import com.lqh.entity.Student;
import com.lqh.service.IStudent;
import com.lqh.utils.CommentResult;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
import java.util.List;


@RestController(value = "sc")
public class StudentController {

    @Autowired
    private IStudent istu;

    @RequestMapping("findAll")
    public CommentResult testFindAll(){
        List list = istu.findAll();
       if(list!=null){
            return new CommentResult(2000,"查询成功",list);
       }else
            return new CommentResult(5000,"查询失败",null);
    }

    @RequestMapping(value = "/insert")
    public CommentResult testInsert(Student stu){
        
        istu.addStudent(stu);

        return new CommentResult(2000,"添加成功",null);
    }

    @RequestMapping(value = "/delete")
    public CommentResult testDelete(Integer stuId){
        
        istu.delete(stuId);
        return new CommentResult(2000,"删除成功",null);
    }

    @RequestMapping(value = "/exit")
    public CommentResult testExit(HttpServletRequest req){
        HttpSession session = req.getSession();
        session.removeAttribute("user");

        return new CommentResult(2000,"退出成功",null);
    }

    @RequestMapping(value = "update")
    public CommentResult testUpdate(Student stu){
        
        

        istu.update(stu.getStuId(),stu.getStuName(),stu.getStuSex(),stu.getStuAge(),stu.getStuAddress());
        return new CommentResult(2000,"修改成功",null);
    }
}

        UserController

package com.lqh.controller;

import com.lqh.entity.User;
import com.lqh.service.IService;
import com.lqh.utils.CommentResult;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.RestController;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;


@RestController(value = "uc")
public class UserController {

    @Autowired
    private IService is;

    @RequestMapping(value = "/findOne")
    public CommentResult testFindOne(String username, String pwd,HttpSession session){
        User user = is.findOne(username, pwd);
        session.setAttribute("user",user);
        if(user!=null){
            CommentResult result=new CommentResult(2000,"登录成功",user);
            return result;
        }else{
            CommentResult result=new CommentResult(5000,"登录失败",null);
            return result;
        }
    }

    @RequestMapping(value = "/insertUser")
    public CommentResult testInsertUser(User user){
        is.insertUser(user);
        return new CommentResult(2000,"注册成功",null);
    }
}

dao

        StudentMapper

package com.lqh.dao;

import com.lqh.entity.Student;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface StudentMapper {
    int deleteByPrimaryKey(Integer stuId);

    int insert(Student record);

    int insertSelective(Student record);

    Student selectByPrimaryKey(Integer stuId);

    int updateByPrimaryKeySelective(Student record);

    int updateByPrimaryKey(Student record);

    List findAll();

    void addStudent(Student stu);

    void delete(@Param("id")Integer id);

    void update(@Param("stuId")Integer stuId,@Param("stuName")String stuName,@Param("stuSex")Integer stuSex,@Param("stuAge")Integer stuAge,@Param("stuAddress")String stuAddress);
    //void update(Student stu);
}

        UserMapper

package com.lqh.dao;

import com.lqh.entity.User;
import org.apache.ibatis.annotations.Param;

public interface UserMapper {
    int insert(User record);

    int insertSelective(User record);

    User findOne(@Param("username")String username,@Param("pwd")String pwd);

    void insertUser(User user);
}

entity

        Student

package com.lqh.entity;

import java.io.Serializable;

public class Student implements Serializable{
    private Integer stuId;

    private String stuName;

    private Integer stuAge;

    private Integer stuSex;

    private String stuAddress;

    public Student() {
    }

    public Integer getStuId() {
        return stuId;
    }

    public void setStuId(Integer stuId) {
        this.stuId = stuId;
    }

    public String getStuName() {
        return stuName;
    }

    public void setStuName(String stuName) {
        this.stuName = stuName == null ? null : stuName.trim();
    }

    public Integer getStuAge() {
        return stuAge;
    }

    public void setStuAge(Integer stuAge) {
        this.stuAge = stuAge;
    }

    public Integer getStuSex() {
        return stuSex;
    }

    public void setStuSex(Integer stuSex) {
        this.stuSex = stuSex;
    }

    public String getStuAddress() {
        return stuAddress;
    }

    public Student(String stuName, Integer stuAge, Integer stuSex, String stuAddress) {
        this.stuName = stuName;
        this.stuAge = stuAge;
        this.stuSex = stuSex;
        this.stuAddress = stuAddress;
    }

    public void setStuAddress(String stuAddress) {
        this.stuAddress = stuAddress == null ? null : stuAddress.trim();
    }
}

        User

package com.lqh.entity;

import java.io.Serializable;

public class User implements Serializable {
    private Integer id;

    private String username;

    private String pwd;

    private String realname;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username == null ? null : username.trim();
    }

    public String getPwd() {
        return pwd;
    }

    public void setPwd(String pwd) {
        this.pwd = pwd == null ? null : pwd.trim();
    }

    public String getRealname() {
        return realname;
    }

    public User(String username, String pwd, String realname) {
        this.username = username;
        this.pwd = pwd;
        this.realname = realname;
    }

    public void setRealname(String realname) {
        this.realname = realname == null ? null : realname.trim();
    }
}

interceptor

        LogInInterceptor

package com.lqh.interceptor;

import com.fasterxml.jackson.databind.ObjectMapper;
import com.lqh.utils.CommentResult;
import org.springframework.web.servlet.HandlerInterceptor;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.PrintWriter;


public class LogInInterceptor implements HandlerInterceptor {
    public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) throws Exception {
        response.setContentType("application/json;charset=utf-8");
        HttpSession session = request.getSession();
        Object user = session.getAttribute("user");
        if(user!=null){
            return true;
        }
        CommentResult result=new CommentResult(5001,"没有登录",null);
        PrintWriter out = response.getWriter();
        ObjectMapper objectMapper=new ObjectMapper();
        String jsons = objectMapper.writeValueAsString(result);
        System.out.println(jsons);
        out.print(jsons);
        out.flush();
        out.close();
        return false;
    }
}

service

        impl

                StudentServiceImpl

package com.lqh.service.Impl;

import com.lqh.dao.StudentMapper;
import com.lqh.entity.Student;
import com.lqh.service.IStudent;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;


@Service(value = "ss")
public class StudentServiceImpl implements IStudent {

    @Autowired
    private StudentMapper sm;

    public List findAll() {
        List list = sm.findAll();
        return list;
    }

    public void addStudent(Student stu){
        sm.addStudent(stu);

    }

    public void delete(Integer id){
        sm.delete(id);
    }


    public void update(Integer stuId,String stuName,Integer stuSex, Integer stuAge,  String stuAddress) {
        sm.update(stuId, stuName,stuSex, stuAge,  stuAddress);
    }


}

                UserServiceImpl

package com.lqh.service.Impl;

import com.lqh.dao.UserMapper;
import com.lqh.entity.User;
import com.lqh.service.IService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;


@Service(value = "us")
public class UserServiceImpl implements IService {

    @Autowired
    private UserMapper um;

    public User findOne(String username, String pwd) {
        User user = um.findOne(username, pwd);
        return user;
    }

    public void insertUser(User user) {
        um.insertUser(user);
    }
}

        IUser

package com.lqh.service;

import com.lqh.entity.User;

public interface IService {
    User findOne(String username,String pwd);
    void insertUser(User user);
}

        IStudent

package com.lqh.service;

import com.lqh.entity.Student;

import java.util.List;

public interface IStudent {

    List findAll();

    void addStudent(Student stu);

    void delete(Integer id);

    void update(Integer stuId,String stuName,Integer stuSex,Integer stuAge,String stuAddress);
}

Test

        TestGenerator

package com.lqh.Test;

import org.mybatis.generator.api.MyBatisGenerator;
import org.mybatis.generator.config.Configuration;
import org.mybatis.generator.config.xml.ConfigurationParser;
import org.mybatis.generator.internal.DefaultShellCallback;

import java.io.File;
import java.util.ArrayList;
import java.util.List;

public class TestGenerator {
    public static void main(String[] args) throws Exception{
        List warnings = new ArrayList();
        boolean overwrite = true;
        //new file中的名字必须和generator生成器的名字一致
        File configFile = new File("generator.xml");
        ConfigurationParser cp = new ConfigurationParser(warnings);
        Configuration config = cp.parseConfiguration(configFile);
        DefaultShellCallback callback = new DefaultShellCallback(overwrite);
        MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings);
        myBatisGenerator.generate(null);
    }
}

utils

        COmmentResult

package com.lqh.utils;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;


@Data
@AllArgsConstructor
@NoArgsConstructor
public class CommentResult {
    private Integer code;
    private String msg;
    private Object data;
}

===============

resources下的配置文件和mapper包

mapper

        StudentMapper.xml




  
    
    
    
    
    
  
  
    stu_id, stu_name, stu_age, stu_sex, stu_address
  
  
    select  from student
  
  
    insert into student values (null,#{stuName},#{stuAge},#{stuSex},#{stuAddress})
  
  
    delete from student where stu_id=#{id}
  
  
    update student
        
          
            stu_name=#{stuName},
          
          
            stu_sex=#{stuSex},
          
          
            stu_age=#{stuAge},
          
          
            stu_address=#{stuAddress},
          
          
        
        where stu_id=#{stuId}
  


        UserMapper.xml




  
    
    
    
    
  
  
    insert into user (id, username, pwd, 
      realname)
    values (#{id,jdbcType=INTEGER}, #{username,jdbcType=VARCHAR}, #{pwd,jdbcType=VARCHAR}, 
      #{realname,jdbcType=VARCHAR})
  
  
    insert into user
    
      
        id,
      
      
        username,
      
      
        pwd,
      
      
        realname,
      
    
    
      
        #{id,jdbcType=INTEGER},
      
      
        #{username,jdbcType=VARCHAR},
      
      
        #{pwd,jdbcType=VARCHAR},
      
      
        #{realname,jdbcType=VARCHAR},
      
    
  



    
  
    insert into user values (null,#{username},#{pwd},#{realname})
  

spring.xml、log4j.properties配置文件参考上一篇文档内容

==========

web下的css,js,jsp页面

login.jsp

<%--
  Created by IntelliJ IDEA.
  User: 李青华
  Date: 2022/6/14
  Time: 18:47
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    登录
    
    
    
    
    
    
    

>

    
        
            >
                
            
            >
                

            
            >
                
            
        
        
                    取 消
                    保 存
                
    
    
        
        
            
        
        
            
                
            
            
                
            
            
                登录
                                            
                注册
            
        
    




main.jsp

<%--
  Created by IntelliJ IDEA.
  User: 李青华
  Date: 2022/6/14
  Time: 19:02
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>


    学生信息
    
    
    
    
    
    


欢迎${sessionScope.user.realname}进入学生管理系统

    添加学生
    退出登录
    
        
            >
                
            
            >
                男
                女
            
            >
                
            
            >
                
            
        
        
    取 消
    确 定
  
    
    
        
        
        
        
        
            
        
        
        
        
        
        
            
            
                
                    >
                        
                    
                    >
                        男
                        女
                    
                    >
                        
                    
                    >
                        
                    
                
                
                    取 消
                    保 存
                
            
        
    
    
        
            >
                
            
            >
                男
                女
            
            >
                
            
            >
                
            
        
        
                    取 消
                    保 存
                
    




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

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

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