SSM增删改查

项目结构

AccountController

package com.qcby.controller;

import com.qcby.entity.Account;
import com.qcby.service.AccountService;
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 java.util.List;

@Controller
public class AccountController {
    @Autowired
    private AccountService accountService;

    
    @RequestMapping(path = "/hello")
    public String sayHello(Model model){
        System.out.println("入门方法执行了2...");
        List accounts = accountService.findAll();
        for (Account account: accounts) {
            System.out.println(account.toString());
        }
        // 向模型中添加属性msg与值，可以在html页面中取出并渲染
        model.addAttribute("msg","hello,SpringMVC");
        // 配置了视图解析器后，写法
        return "suc";
    }
    
    @RequestMapping("/findAll.do")
    public String findAll(){
        System.out.println("执行了...");
        // 模拟异常
        int a = 10/0;
        return "suc";
    }
}

StudentController

package com.qcby.controller;

import com.qcby.entity.Student;
import com.qcby.service.StudentService;
import org.apache.ibatis.annotations.Param;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;

import java.util.Arrays;
import java.util.Date;
import java.util.List;


@Controller
@RequestMapping("/student")
public class StudentController {

    @Autowired
    private StudentService studentService;

    @RequestMapping("/insert")
    @ResponseBody
    public String insert(Student student){
        student.setCreate_time(new Date());
        int account = studentService.insert(student);
        String data;
        if(account == 1){
            data = ""code":"200","msg":"success"";
        } else{
            data = ""code":"404","msg":"error"";
        }
        return data;
    }

    @RequestMapping("/delete")
    @ResponseBody
    public String delete(int id){
        int account = studentService.delete(id);
        String data;
        if(account == 1){
            data = ""code":"200","msg":"success"";
        } else{
            data = ""code":"404","msg":"error"";
        }
        return data;
    }

    @RequestMapping("deletes")
    @ResponseBody
    public String deleteMoreByArray(@RequestParam("ids")Integer[] ids){
        int account = studentService.deleteMoreByArray(ids);
        String data;
        if(account == ids.length){
            data = ""code":"200","msg":"success"";
        } else{
            data = ""code":"404","msg":"error"";
        }
        return data;
    }

    @RequestMapping("update")
    @ResponseBody
    public String update(Student student){
        student.setCreate_time(new Date());
        int account = studentService.update(student);
        String data;
        if(account == 1){
            data = ""code":"200","msg":"success"";
        } else{
            data = ""code":"404","msg":"error"";
        }
        return data;
    }
    @RequestMapping("findAll")
    @ResponseBody
    public List findAll(@Param("pageSize")Integer pageSize, @Param("pageIndex")Integer pageIndex){
        return studentService.findAll(pageSize,pageIndex);
    }

    @RequestMapping("getStudentByClassName")
    @ResponseBody
    public List getStudentByClassName(Student student){
        return studentService.findStudent(student);
    }

    @RequestMapping("getStudentBySno")
    @ResponseBody
    public List getStudentBySno(Student student){
        return studentService.findStudent(student);
    }

    @RequestMapping("likeByName")
    @ResponseBody
    public List likeByName(Student student){
        return studentService.likeByName(student);
    }
}

StudentDao

package com.qcby.dao;

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

import java.util.List;


public interface StudentDao {

    
    int insert(Student student);

    
    int delete(int id);

    
    int deleteMoreByArray(@Param("ids") Integer[] ids);

    int update(Student student);

    List findAll(@Param("pageSize")Integer pageSize, @Param("pageIndex")Integer pageIndex);

    List findStudent(Student student);

    List likeByName(Student student);
}

UserDao

package com.qcby.dao;

import com.qcby.entity.Account;

import java.util.List;


public interface UserDao {
    List findAll();
}

Account

package com.qcby.entity;

public class Account {
    private int id;
    private String name;
    private Double money;

    public int getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Double getMoney() {
        return money;
    }

    public void setMoney(Double money) {
        this.money = money;
    }

    @Override
    public String toString() {
        return "Account{" +
                "id=" + id +
                ", name='" + name + ''' +
                ", money=" + money +
                '}';
    }
}

Class

package com.qcby.entity;

import java.util.Date;


public class Class {
    private Integer id;
    private String name;
    private String remarks;
    private Date create_time;

    public Integer getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getRemarks() {
        return remarks;
    }

    public void setRemarks(String remarks) {
        this.remarks = remarks;
    }

    public Date getCreate_time() {
        return create_time;
    }

    public void setCreate_time(Date create_time) {
        this.create_time = create_time;
    }

    @Override
    public String toString() {
        return "Class{" +
                "id=" + id +
                ", name='" + name + ''' +
                ", remarks='" + remarks + ''' +
                ", create_time=" + create_time +
                '}';
    }
}

Student

package com.qcby.entity;

import java.util.Date;


public class Student {
    private Integer id;
    private String name;
    private Integer sno;
    private String sex;
    private String className;
    private Date create_time;
    private Integer pageSize;
    private Integer pageIndex;

    public Integer getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Integer getSno() {
        return sno;
    }

    public void setSno(Integer sno) {
        this.sno = sno;
    }

    public String getSex() {
        return sex;
    }

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

    public String getClassName() {
        return className;
    }

    public void setClassName(String className) {
        this.className = className;
    }

    public Date getCreate_time() {
        return create_time;
    }

    public void setCreate_time(Date create_time) {
        this.create_time = create_time;
    }

    public Integer getPageSize() {
        return pageSize;
    }

    public void setPageSize(Integer pageSize) {
        this.pageSize = pageSize;
    }

    public Integer getPageIndex() {
        return pageIndex;
    }

    public void setPageIndex(Integer pageIndex) {
        this.pageIndex = pageIndex;
    }

    @Override
    public String toString() {
        return "Student{" +
                "id=" + id +
                ", name='" + name + ''' +
                ", sno=" + sno +
                ", sex='" + sex + ''' +
                ", className='" + className + ''' +
                ", create_time=" + create_time +
                ", pageSize=" + pageSize +
                ", pageIndex=" + pageIndex +
                '}';
    }
}

SysException

package com.qcby.entity;


public class SysException extends Exception{
    // 提示消息
    private String message;
    public SysException(String message){
        this.message = message;
    }

    @Override
    public String getMessage() {
        return message;
    }

    public void setMessage(String message) {
        this.message = message;
    }

    @Override
    public String toString() {
        return "SysException{" +
                "message='" + message + ''' +
                '}';
    }
}

Teacher

package com.qcby.entity;

import java.util.Date;


public class Teacher {
    private Integer id;
    private String name;
    private String sex;
    private Integer number;
    private Date create_name;

    public Integer getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getSex() {
        return sex;
    }

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

    public Integer getNumber() {
        return number;
    }

    public void setNumber(Integer number) {
        this.number = number;
    }

    public Date getCreate_name() {
        return create_name;
    }

    public void setCreate_name(Date create_name) {
        this.create_name = create_name;
    }

    @Override
    public String toString() {
        return "Teacher{" +
                "id=" + id +
                ", name='" + name + ''' +
                ", sex='" + sex + ''' +
                ", number=" + number +
                ", create_name=" + create_name +
                '}';
    }
}

AccountServiceImpl

package com.qcby.service.serviceimpl;

import com.qcby.dao.UserDao;
import com.qcby.entity.Account;
import com.qcby.service.AccountService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class AccountServiceImpl implements AccountService {
    @Autowired
    public UserDao userDao;

    @Override
    public List  findAll() {
        System.out.println("业务层：查询所有");
        return this.userDao.findAll();
    }
}

StudentServiceImpl

package com.qcby.service.serviceimpl;

import com.qcby.dao.StudentDao;
import com.qcby.entity.Student;
import com.qcby.service.StudentService;
import org.apache.ibatis.annotations.Param;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;


@Service
public class StudentServiceImpl implements StudentService {

    @Autowired
    private StudentDao studentDao;

    @Override
    public int insert(Student student) {
        return this.studentDao.insert(student);
    }

    @Override
    public int delete(int id) {
        return this.studentDao.delete(id);
    }

    @Override
    public int deleteMoreByArray(Integer[] ids) {
        return this.studentDao.deleteMoreByArray(ids);
    }

    @Override
    public int update(Student student) {
        return this.studentDao.update(student);
    }

    @Override
    public List findAll(@Param("pageSize")Integer pageSize, @Param("pageIndex")Integer pageIndex) {
        int pageCount = (pageIndex - 1) * pageSize;
        return this.studentDao.findAll(pageSize,pageCount);
    }

    @Override
    public List findStudent(Student student) {
        Student student1 = new Student();
        student1.setClassName(student.getClassName());
        student1.setSno(student.getSno());
        student1.setPageSize(student.getPageSize());
        student1.setPageIndex((student.getPageIndex() - 1) * student.getPageSize());
        return this.studentDao.findStudent(student1);
    }

    @Override
    public List likeByName(Student student) {
        return this.studentDao.likeByName(student);
    }
}

AccountService

package com.qcby.service;

import com.qcby.entity.Account;

import java.util.List;

public interface AccountService {
    //查询所有
    List findAll();
}

StudentService

package com.qcby.service;

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

import java.util.List;


public interface StudentService {

    int insert(Student student);

    int delete(int id);

    int deleteMoreByArray(Integer[] ids);

    int update(Student student);

    List findAll(@Param("pageSize")Integer pageSize, @Param("pageIndex")Integer pageIndex);

    List findStudent(Student student);

    List likeByName(Student student);
}

SysExceptionResolver

package com.qcby.util;

import com.qcby.entity.SysException;
import org.springframework.web.servlet.HandlerExceptionResolver;
import org.springframework.web.servlet.ModelAndView;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class SysExceptionResolver implements HandlerExceptionResolver {

    
    @Override
    public ModelAndView resolveException(HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse, Object o, Exception e) {
        e.printStackTrace(); //在命令行打印异常信息在程序中出错的位置及原因。
        // 做强转
        SysException exception = null;
        // 判断
        if(e instanceof SysException){
            exception = (SysException)e;
        }else{
            exception = new SysException("系统正在维护，请联系管理员");

        }
        ModelAndView mv = new ModelAndView();
        mv.addObject("errorMsg",exception.getMessage());
        // 设置跳转的页面
        mv.setViewName("404");
        return mv;
    }
}

AccountDao.xml




    
        select * from student limit #{pageSize} offset #{pageIndex}
    

    
        select * from student where name like '%${name}%'

jdbc.properties

jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssm?serverTimezone=UTC
jdbc.username=自己的账号
jdbc.password=你自己的密码

spring.xml

springmvc.xml

SqlMapConfig.xml

Demo

package com.qcby;

import com.qcby.service.AccountService;
import org.junit.Test;
import org.springframework.context.support.ClassPathXmlApplicationContext;

public class Demo {
    @Test
    public void run(){
        ClassPathXmlApplicationContext ac = new ClassPathXmlApplicationContext("classpath:spring.xml");
        AccountService service = ac.getBean(AccountService.class);
        service.findAll();
    }
}

404.html




  
  error

suc.html
Title Hello
web.xml
Archetype Created Web Application org.springframework.web.context.ContextLoaderListener contextConfigLocation classpath:spring.xml encodingFilter org.springframework.web.filter.CharacterEncodingFilter true encoding UTF-8 encodingFilter /* default *.html dispatcherServlet org.springframework.web.servlet.DispatcherServlet contextConfigLocation classpath:springmvc.xml 1 dispatcherServlet / /index.html
index.html
主页入门程序入门入门程序
pom.xml
4.0.0 com.qcby SSM1 1.0-SNAPSHOT war 5.0.2.RELEASE 1.6.6 1.2.12 8.0.28 3.4.5 2.9.4 org.aspectj aspectjweaver 1.6.8 org.springframework spring-aop ${spring.version} org.springframework spring-context ${spring.version} org.springframework spring-web ${spring.version} org.springframework spring-webmvc ${spring.version} org.springframework spring-test ${spring.version} org.springframework spring-tx ${spring.version} org.springframework spring-jdbc ${spring.version} junit junit 4.12 test mysql mysql-connector-java ${mysql.version} javax.servlet servlet-api 2.5 provided javax.servlet.jsp jsp-api 2.0 provided jstl jstl 1.2 log4j log4j ${log4j.version} org.slf4j slf4j-api ${slf4j.version} org.slf4j slf4j-log4j12 ${slf4j.version} org.mybatis mybatis ${mybatis.version} org.mybatis mybatis-spring 1.3.0 com.alibaba druid 1.1.10 org.mybatis.generator mybatis-generator-core 1.3.5 com.fasterxml.jackson.core jackson-core ${jackson.version} com.fasterxml.jackson.core jackson-databind ${jackson.version} com.github.pagehelper pagehelper 5.1.10 cn.hutool hutool-all 5.2.3 org.thymeleaf thymeleaf-spring4 3.0.9.RELEASE ssm org.apache.maven.plugins maven-compiler-plugin 3.2 1.8 1.8 UTF-8 true org.mybatis.generator mybatis-generator-maven-plugin 1.3.5 src/main/resources/mbg.xml true true

SSM增删改查

Java相关栏目本月热门文章