SSM 整合简单实现crud

向右看齐 2022-05-17 11:17 316阅读 0赞

SSM 整合

整合之前先看看各自的配置文件：

Spring：Ioc控制反转、AOP面向切面。  
      
            需配置web.xml(spring监听器、spring配置信息)、

applicationContext.xml(数据库相关bean：dataSource、sessionFactory、transactionManager)

SpringMVC：控制器，流程、页面显示的控制。

需配置web.xml(dispatcherServlet分发器servlet的配置)、

\[servlet-name\]-servlet.xml(配置自动扫描控制器，注解的启动，视图解析器)

Mybatis：提供ORM服务，优秀的持久层框架。

需配置mybatis.config.xml(配置数据库连接信息属性文件、数据源环境、实体类映射文件的路径)

\[entity-name\]-mapper.xml(sql语句的映射)

整合后配置文件：

web.xml(spring监听器、spring+mybatis配置文件路径信息、dispatcherServlet分发器servlet)

spring-mybatis.xml(结合applicationContext.xml和mybatis.config.xml)

spring-mvc.xml(原\[servlet-name\]-servlet.xml，基本不变 可扩充)

\[entity-name\]-mapper.xml(不变)

配置文件的整合方法看了很多，其中最主要的是Spring对其他所有配置的bean管理。

1、项目目录如下：

![70][]

2、其中test、tool包测试用，可以不用。使用的实体类表如下：

![70 1][]

package com.gan.model;
    
    public class Student {
    	
    	private int sno;
    	private String sname;
    	private double score;
    
           get/set
    }

3、spring-mybatis配置文件：

<?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:mvc="http://www.springframework.org/schema/mvc"  
        xsi:schemaLocation="http://www.springframework.org/schema/beans    
        http://www.springframework.org/schema/beans/spring-beans-3.1.xsd    
        http://www.springframework.org/schema/context    
        http://www.springframework.org/schema/context/spring-context-3.1.xsd    
        http://www.springframework.org/schema/mvc    
        http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd"> 
        
          
        <context:component-scan base-package="com.gan" />  
        <mvc:annotation-driven/> 
        
          
        <context:property-placeholder location="classpath:*.properties" />  
      
        
        <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"  
            destroy-method="close">  
            <property name="driverClassName" value="${driver}" />  
            <property name="url" value="${url}" />  
            <property name="username" value="${user}" />  
            <property name="password" value="${password}" />  
        </bean>  
      
          
        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">  
            <property name="dataSource" ref="dataSource" />  
              
            <property name="mapperLocations" value="classpath:com/gan/mapper/*.xml"/>  
        </bean>  
      
          
        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">  
            <property name="basePackage" value="com.gan.mapper" />  
            <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>  
        </bean>  
      
          
        <bean id="transactionManager"  
            class="org.springframework.jdbc.datasource.DataSourceTransactionManager">  
            <property name="dataSource" ref="dataSource" />  
        </bean>  
      
    </beans>

3、spring-mvc.xml配置文件

4、web.xml配置文件

<?xml version="1.0" encoding="UTF-8"?>
    <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
     xmlns="http://java.sun.com/xml/ns/javaee"
      xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
       http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" version="3.0">
       
      
      <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:spring-mybatis.xml</param-value>
      </context-param>
      
      
      <filter>
        <filter-name>encodingFilter</filter-name>
        <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
        <async-supported>true</async-supported>
        <init-param>
          <param-name>encoding</param-name>
          <param-value>UTF-8</param-value>
        </init-param>
      </filter>
      <filter-mapping>
        <filter-name>encodingFilter</filter-name>
        <url-pattern>/*</url-pattern>
      </filter-mapping>
      
      
      <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
      </listener>
      
      
      <servlet>
        <servlet-name>SpringMVC</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <init-param>
          <param-name>contextConfigLocation</param-name>
          <param-value>classpath:spring-mvc.xml</param-value>
        </init-param>
        <load-on-startup>1</load-on-startup>
      </servlet>
      <servlet-mapping>
        <servlet-name>SpringMVC</servlet-name>
        <url-pattern>/</url-pattern>
      </servlet-mapping>
      
      <welcome-file-list>
        <welcome-file>/index.jsp</welcome-file>
      </welcome-file-list>
      
    </web-app>

5、主页index.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
        pageEncoding="utf-8"%>
    <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
    <title>SSM crud</title>
    </head>
    <body>
    	
    	<table border="1" style="text-align:center;width:600px;margin:0 auto;">
    		<tr>
    			<caption style="font-size:36px">Student CURD</caption>
    		</tr>
    		<tr>
    			<td>
    				<a href="/spring-springMVC-mybatis/jsp/add.jsp">
    					<button type="button">ADD</button>
    				</a>
    			</td>
    			<td>
    				<a href="/spring-springMVC-mybatis/jsp/delete.jsp">
    					<button type="button">DELETE</button>
    				</a>
    			</td>
    			<td>
    				<a href="/spring-springMVC-mybatis/update">
    					<button type="button">UPDATE</button>
    				</a>
    			</td>
    			<td>
    				<a href="/spring-springMVC-mybatis/show">
    					<button type="button">SHOW</button>
    				</a>
    			</td>
    		</tr>
    	</table>
    </body>
    </html>

## ![70 2][] ##

##  2  接下来是功能实现 ##

### （1）查找所有(show) ###

mapper包

![70 3][]

mapper接口方法

package com.gan.mapper;
    
    import java.util.List;
    
    import com.gan.model.Student;
    
    public interface StudentMapper {
    
    	public List<Student> getAllStudent();
    	
    }

mapper.xml配置sql映射

<?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">
    <mapper namespace="com.gan.mapper.StudentMapper">
    
    	<select id="getAllStudent" resultType="com.gan.model.Student">
    		select * from student
    	</select>
    
    </mapper>

service包

![70 4][]

service接口方法

package com.gan.service;
    
    import java.util.List;
    
    import com.gan.model.Student;
    
    public interface InterStudentService {
    
    	public List<Student> showStudentList();
    	
    }

service实现方法

package com.gan.service;
    
    import java.util.List;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    import org.springframework.transaction.annotation.Transactional;
    
    import com.gan.mapper.StudentMapper;
    import com.gan.model.Student;
    
    @Service
    @Transactional
    public class StudentServiceImpl implements InterStudentService {
    
    	@Autowired(required=true)
    	private StudentMapper studentDao;
    	
    	@Override
    	public List<Student> showStudentList() {
    		// TODO Auto-generated method stub
    		return studentDao.getAllStudent();
    	}
    
    }

controller控制器

![70 5][]

package com.gan.controller;
    
    import java.util.HashMap;
    import java.util.List;
    import java.util.Map;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.ui.Model;
    import org.springframework.web.bind.annotation.ModelAttribute;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RequestMethod;
    import org.springframework.web.bind.annotation.RequestParam;
    import org.springframework.web.bind.annotation.ResponseBody;
    
    import com.gan.model.Student;
    import com.gan.service.InterStudentService;
    
    @Controller
    public class StudentController {
    
    	@Autowired(required=true)
    	private InterStudentService service;
    	
    	@RequestMapping(value="/index",method=RequestMethod.GET)
    	public String index(){
    		return "index";
    	}
    	
    
    	@RequestMapping(value="/show",method=RequestMethod.GET)
    	public String getAllStudent(Model model){
    		List<Student> stus=service.showStudentList();
    		model.addAttribute("stus",stus);
    		System.out.println(stus);
    		return "show";
    	}
    	
    		
    }

show.jsp

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
    <%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> 
    
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
    <html>
      <head>
        
        <title>show</title>
    
      </head>
      <style>
      	td{
      	width:100px;
      	}
      	table{text-align:center}
      </style>
      <body>
      <h2>Student Info</h2>
      <table border="1">
      	<tr>
      		<td>sno</td>
      		<td>sname</td>
      		<td>score</td>
      	</tr>
        <c:forEach items="${stus}" var="stu">
        	<tr>
        		<td>${stu.sno}</td>
        		<td>${stu.sname}</td>
        		<td>${stu.score}</td>
        	</tr>
        </c:forEach>
      </table>
      <a href="javascript:history.back()"> 返回 </a>
      </body>
    </html>

![70 6][]

### （2）添加(add) ###

mapper接口：

public Student getStudentByID(int sno); //查找是否学号重复  
    public int insertStudent(Student stu);

mapper映射：

<select id="getStudentByID" parameterType="int" resultType="com.gan.model.Student">  
        select \* from student where sno=\#\{sno\}  
    </select>  
    <insert id="insertStudent" parameterType="com.gan.model.Student">  
        insert into student(sno,sname,score) values(\#\{sno\},\#\{sname\},\#\{score\})  
    </insert>

service接口：

public boolean checkID(int sno);      
    public boolean addStudent(Student stu);

service实现：

@Override
    	public boolean checkID(int sno) {
    		if(studentDao.getStudentByID(sno)!=null)
    			return true;
    		return false;
    	}
    
    	@Override
    	public boolean addStudent(Student stu) {
    		if(studentDao.insertStudent(stu)!=0)
    			return true;
    		return false;
    	}

controller方法：

/**
    	 * @ add
    	 * @return
    	 */
    	@RequestMapping(value="/add",method=RequestMethod.POST)
    	public String add(@ModelAttribute("stu")Student stu,Model model){		
    		if(service.checkID(stu.getSno())){
    			model.addAttribute("message",stu.getSno()+"学号已有，添加失败！");
    		}else{
    			service.addStudent(stu);
    			model.addAttribute("message",stu.getSno()+"添加成功！");
    		}
    		return "message";
    	}

add.jsp添加页：

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
    <%@ taglib prefix="form" uri="http://www.springframework.org/tags/form"%>
    <jsp:useBean id="command" class="com.gan.model.Student" scope="request" />
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
    <html>
      <head>    
        <title>add Student</title>
      </head>
      <body>
        <form:form action="/spring-springMVC-mybatis/add" method="post">
        	<table>
        		<tr>
        			<caption>Student ADD</caption>
        		</tr>
        		<tr>
        			<td><form:label path="sno">学号</form:label></td>
        			<td><form:input path="sno"/></td>
        		</tr>
        		<tr>
        			<td><form:label path="sname">姓名</form:label></td>
        			<td><form:input path="sname"/></td>
        		</tr>
        		<tr>
        			<td><form:label path="score">分数</form:label></td>
        			<td><form:input path="score"/></td>
        		</tr>
        		<tr>
        			<td><input type="reset" value="reset"/></td>
        			<td><input type="submit" value="submit"/></td>
        		</tr>
        	</table>
        </form:form>
        <a href="javascript:history.back()"> 返回 </a>
      </body>
    </html>

message.xml结果信息页：

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
    
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
    <html>
      <head>   
        <title>Message</title>
      </head>
      
      <body>
        <h2>${message}</h2>
        <a href="/spring-springMVC-mybatis/index"> 返回 </a>
      </body>
    </html>

![70 7][]

![70 8][]

### （3）删除(delete) ###

mapper接口：

public Student getStudentByID(int sno); //查找是否学号存在  
    public int deleteStudent(int sno);

mapper映射：

<select id="getStudentByID" parameterType="int" resultType="com.gan.model.Student">  
        select \* from student where sno=\#\{sno\}  
    </select>  
    <delete id="deleteStudent" parameterType="int">  
        delete from student where sno=\#\{sno\}  
    </delete>

service接口：

public boolean checkID(int sno);      
    public boolean deleteStudent(int sno);

service实现：

@Override
    	public boolean deleteStudent(int sno) {
    		if(studentDao.deleteStudent(sno)!=0)
    			return true;
    		return false;
    	}

controller方法：

/**
    	 * @param delete
    	 * @return
    	 */
    	@RequestMapping(value="/delete",method=RequestMethod.POST)
    	public String getOneStudent(@RequestParam("sno")int sno,Model model){
    		if(service.checkID(sno)){
    			service.deleteStudent(sno);
    			model.addAttribute("message",sno+"删除成功！");
    		}else{
    			model.addAttribute("message",sno+"没有该学号，删除失败！");
    		}
    		return "message";
    		
    	}

delete.jsp

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
    <%@taglib uri="http://www.springframework.org/tags/form" prefix="form"%>
     
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
    <html>
      <head>    
        <title>My JSP 'index.jsp' starting page</title>
      </head>
      
      <body>
        <form:form action="/spring-springMVC-mybatis/delete" method="post">
        	<label>请输入学号</label>
        	<input name="sno"/>
        	<input type="submit" value="submit"/>
        </form:form>
        <a href="javascript:history.back()"> 返回 </a>
      </body>
    </html>

![70 9][]

![70 10][]

### （4）修改(update) ###

mapper接口：

public Student getStudentByID(int sno); //显示原本信息  
    public int updateStudent(Student stu);  
    public List<Integer> selectAllSno();//用于下拉选择学号修改

mapper映射：

<update id="updateStudent" parameterType="com.gan.model.Student">  
        update student set sname=\#\{sname\},score=\#\{score\} where sno=\#\{sno\}  
    </update>  
      
    <select id="selectAllSno" resultMap="snoMap">  
        select sno from student  
    </select>  
   
    <resultMap id="snoMap" type="java.lang.Integer">  
        <id property="sno" column="sno" javaType="java.lang.Integer" />  
    </resultMap>

service接口：

public Student getOneStudent(int sno);  
    public boolean updateStudent(Student stu);  
    public List<Integer> getAllSno();

service实现：

@Override
    	public boolean updateStudent(Student stu) {
    		if(studentDao.updateStudent(stu)!=0)
    			return true;
    		return false;
    	}
    
    	@Override
    	public List<Integer> getAllSno() {
    		// TODO Auto-generated method stub
    		return studentDao.selectAllSno();
    	}
    
    	@Override
    	public Student getOneStudent(int sno) {
    		// TODO Auto-generated method stub
    		return studentDao.getStudentByID(sno);
    	}

controller方法实现：

//下拉显示学号
          @RequestMapping(value="/update",method=RequestMethod.GET)
    	public String deletePage(Model model){
    		Student student =new Student();
    		Map<Integer,String> snoList=new HashMap<Integer,String>();
    		List<Integer> list=service.getAllSno();
    		for(int i=0;i<list.size();i++){
    			snoList.put(list.get(i),list.get(i)+"");
    		}
    		model.addAttribute("stu", student);
    		model.addAttribute("snoList",snoList);
    		return "update";
    	}
    
        /**
    	 * @ update
    	 * @return
    	 */
    	@RequestMapping(value="/updateDeal",method=RequestMethod.POST)
    	public String update(@ModelAttribute("stu")Student stu,Model model){
    		System.out.println(stu);
    		if(service.updateStudent(stu))
    			model.addAttribute("message",stu.getSno()+"修改成功！");
    		else
    			model.addAttribute("message",stu.getSno()+"修改失败！");
    		return "message";
    	}
    
         //$.post()请求处理，返回学生对象
        @RequestMapping(value="/studentSelect",method=RequestMethod.POST)
    	@ResponseBody
    	public Student selectStudent(@RequestParam("sno")int sno){
    		return service.getOneStudent(sno);
    	}

update.jsp

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
    <%@ taglib prefix="form" uri="http://www.springframework.org/tags/form"%>
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
    <html>
      <head>   
        <title>add Student</title>
      </head>
      <script src="/spring-springMVC-mybatis/js/jquery-3.0.0.min.js"></script>
      <script src="/spring-springMVC-mybatis/js/bootstrap.min.js"></script>
      <script>
      	$(function(){
      	
      	    var value=$("#studentSelect").val()
      	    getValue(value)
      	    $("#studentSelect").change(function(){
      	    	var v_sno=$(this).val()
      	    	getValue(v_sno)
      		})
      	})
      	
      	function getValue(stuNo){
      		$.post("studentSelect",
      			 {
      			 	sno:stuNo
      			 },
      			 function(data){
      			 	$("#name").val(data.sname)
      			 	$("#marks").val(data.score)  			 	
      			 })
      	}
      	
      </script>
      <body>
        <form:form action="/spring-springMVC-mybatis/updateDeal" modelAttribute="stu" method="post">
        	<table>
        		<tr>
        			<caption>Student Update</caption>
        		</tr>
        		<tr>
        			<td><form:label path="sno">学号</form:label></td>
        			<td>
    					<form:select path="sno" id="studentSelect">
    						<form:options path="sno" items="${snoList}"/>
    					</form:select>
    				</td>
        		</tr>
        		<tr>
        			<td><form:label path="sname">姓名</form:label></td>
        			<td><form:input path="sname" id="name"/></td>
        		</tr>
        		<tr>
        			<td><form:label path="score">分数</form:label></td>
        			<td><form:input path="score" id="marks"/></td>
        		</tr>
        		<tr>
        			<td><input type="reset" value="reset"/></td>
        			<td><input type="submit" value="submit"/></td>
        		</tr>
        	</table>
        </form:form>
        <a href="javascript:history.back()"> 返回 </a>
      </body>
    </html>

![70 11][]

![70 12][]

![70 13][]

![70 14][]

下载   [戳这里][Link 1]

[70]: /images/20220517/88e4f9e67b1b46c6a09dd85333a4cb27.png
[70 1]: /images/20220517/d6dac4c9a8a84b12a05a687b22e72ac6.png
[70 2]: /images/20220517/a16626a38305483eba53b86eff4231a9.png
[70 3]: /images/20220517/2c8da54911704413861a9d3d8a892569.png
[70 4]: /images/20220517/c1e83c6a3ce544609805072f7c89928a.png
[70 5]: /images/20220517/7142372355ba498ebc99ac0e65c9f675.png
[70 6]: /images/20220517/b497fd2edac54af5b109a4137b260a37.png
[70 7]: /images/20220517/a5861dd26666433f8aab6872aa90c614.png
[70 8]: /images/20220517/049a592076dd4025aba425815469f8e4.png
[70 9]: /images/20220517/b718b0bae7a74f4fa63dce71bdf0398b.png
[70 10]: /images/20220517/f555dfea352746faac68f0b9ef09899f.png
[70 11]: /images/20220517/096e4bf72d16482ba1c8942b89714aea.png
[70 12]: /images/20220517/0551b60b72f0469687ab99c244bacf93.png
[70 13]: /images/20220517/5bfde06488c34234910738c4875be17e.png
[70 14]: /images/20220517/525429f5880144ae8725838b9a0e03ff.png
[Link 1]: https://download.csdn.net/download/zero_130/10596203