SSM - JSP

1.什么是SSM？

两个核心配置文件web.xml,applicationContext.xml

web.xml
1.前端控制器DispatcherServlet
2.过滤器CharacterEncodingFilter

applicationContext.xml
1.扫描包
2.mvc驱动
3.事务驱动
4.配置数据源
5.SqlSessionFactoryBean
6.配置事务
7.数据映射器
8.视图解析器

2.案例 2.1 数据库

CREATE TABLE `t_student` (
  `sid` int(32) NOT NULL AUTO_INCREMENT,
  `sname` varchar(32) DEFAULT NULL,
  `spwd` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`sid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

默认就是InnoDB 引擎所以可以不写

INSERT INTO `t_student` VALUES ('1', 'zs', '123');
INSERT INTO `t_student` VALUES ('2', 'lisi', '555');
INSERT INTO `t_student` VALUES ('3', 'wangwu', '666');

2.2 创建maven工程，目录 ,js(jquery-1.8.3-min.js)

（二八原则）如下

2.3 web.xml



    
        CharacterEncodingFilter
        org.springframework.web.filter.CharacterEncodingFilter

        
            encoding
            utf-8
        
    
    
        CharacterEncodingFilter
        /*
    


    
        springmvc
        org.springframework.web.servlet.DispatcherServlet
        
            contextConfigLocation
            classpath:applicationContext.xml
        

        1
    
    
        springmvc
        *.do

2.4 applicationContext.xml

2.5 pom.xml


    UTF-8
    1.8
    1.8
    4.3.7.RELEASE
    2.5.4
  

  

    
      junit
      junit
      4.11
      test


    
      javax.servlet
      jstl
      1.2
    
    
      javax.servlet
      servlet-api
      2.5


    
      mysql
      mysql-connector-java
      8.0.21


    
      org.mybatis
      mybatis
      3.4.1


    
      org.mybatis
      mybatis-spring
      1.3.1


    
      org.springframework
      spring-context
      ${spring-version}
    
    
      org.springframework
      spring-core
      ${spring-version}
    
    
      org.springframework
      spring-beans
      ${spring-version}
    
    
      org.springframework
      spring-web
      ${spring-version}
    
    
      org.springframework
      spring-webmvc
      ${spring-version}
    
    
      org.springframework
      spring-jdbc
      ${spring-version}


    
      org.springframework
      spring-tx
      ${spring-version}


    
      com.alibaba
      druid
      1.1.1
    
 
    
      com.fasterxml.jackson.core
      jackson-core
      ${jackson.version}
    
    
      com.fasterxml.jackson.core
      jackson-databind
      ${jackson.version}
    

    
      com.github.pagehelper
      pagehelper
      4.1.6

2.6 Student

package cn.kgc.entity;

public class Student {
    private Integer sId;
    private String sName;
    private String sPwd;
  省略getter和setter方法
}

2.7 StudentMapper.java

package cn.kgc.mapper;
import cn.kgc.entity.Student;
import java.util.List;

public interface StudentMapper {
    //查询所有
    List findAll();
    //增加
    Integer addStudent(Student student);
    //删除
    Integer delById(Integer id);
    //修改
    Integer updateStudent(Student student);
    //通过id查询对象
    Student findById(Integer id);
}

2.8 StudentMapper.xml




    
        select * from t_student where sid =#{id}

2.9 StudentService.java

package cn.kgc.service;
import cn.kgc.entity.Student;
import java.util.List;

public interface StudentService {
    //查询所有
    List findAll();
    //增加
    Integer addStudent(Student student);
    //删除
    Integer delById(Integer id);
    //修改
    Integer updateStudent(Student student);
    //通过id查询对象
    Student findById(Integer id);
}

2.10 StudentServiceImpl.java (省略导包)

@Service
@Transactional
public class StudentServiceImpl implements StudentService {
    @Autowired
    private StudentMapper studentMapper;
    @Override
    public List findAll() { return studentMapper.findAll(); }

    @Override
    public Integer addStudent(Student student) { return studentMapper.addStudent(student); }

    @Override
    public Integer delById(Integer id) { return studentMapper.delById(id); }

    @Override
    public Integer updateStudent(Student student) { return studentMapper.updateStudent(student); }

    @Override
    public Student findById(Integer id) { return studentMapper.findById(id); }
}

2.11StudentController.java(省略导包)

@Controller
public class StudentController {
    @Autowired
    private StudentService studentService;

    @RequestMapping("/findAll.do")
    public String findAll(HttpServletRequest request){
        System.out.println("findAll.do");
        List list = studentService.findAll();
        request.setAttribute("list",list);
        return "findAll";
    }
    //第一种
    @RequestMapping("/addStudent.do")
    public String addStudent(Student student){
        studentService.addStudent(student);
        //不用写request.getParameter("xxx")，由传进来的参数决定，
        //所以后面的jsp要与实体类保持一致因为参数是student对象
        //下面是重定向
        return "redirect:/findAll.do";
    }
    //第二种
//    @RequestMapping("/addStudent2.do")
//    public void assStudent2(Student student, HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//        System.out.println("add2*************");
//        //Integer flag = studentService.addStudent(student);
//        request.getRequestDispatcher("/findAll.do").forward(request,response);
//    }
    @RequestMapping("/delById.do")
    public String delById(Integer id){
        studentService.delById(id);
        return "redirect:/findAll.do";
    }
    @RequestMapping("/toUpdateStudent.do")
    public String toUpdateStudent(Integer id,HttpServletRequest request){
        Student student = studentService.findById(id);
        request.setAttribute("stu",student);
        return "update";
    }
    @RequestMapping("/updateStudent.do")
    public String updateStudent(Student student){
        studentService.updateStudent(student);
        return "redirect:/findAll.do";
//        return "update";
        //进入update.jsp
    }
    @RequestMapping("/findById.do")
    public String findById(Integer id,HttpServletRequest request){
        Student student = studentService.findById(id);
        request.setAttribute("student",student);
        return "findById";
    }
}

2.12 findAll.jsp

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


    Title
    
<%--    引入类库不能有自闭结束标签，要写全--%>


    
        
                
            
                编号
                名称
                密码
                操作
            
            
                    ${stu.sId}
                    ${stu.sName}
                    ${stu.sPwd}
                    
                        修改
                        删除
                        <%--第一个用？第二个用&--%>

2.13 add.jsp(省略开头)

2.14 update.jsp(省略开头)

修改页面
名称:
密码:

2.15.findById.jsp(省略开头)


    
        
            编号
            名称
            密码
        
            
                ${student.sId}
                ${student.sName}
                ${student.sPwd}

2.16 测试

查询：
http://localhost:8080/findAll.do

中间不连贯，简化版增加：
http://localhost:8080/add.jsp

》

删除：
在前面基础上点击删除就删除成功（不演示了）

修改：
点击修改
http://localhost:8080/toUpdateStudent.do?id=4

》

通过id查询对象：
点击1就跳到对应的
http://localhost:8080/findById.do?id=1

----2021.12.15&12.16

编号	名称	密码	操作
${stu.sId}	${stu.sName}	${stu.sPwd}	修改删除 <%--第一个用？第二个用&--%>

SSM - JSP

Java相关栏目本月热门文章