ssm三大框架整合

客官°小女子只卖身不卖艺 2021-09-19 05:34 500阅读 0赞

**目录**

1.查询所有记录

web.xml:

applicationContext.xml:（导入约束：aop,beans，context,mvc,tx,）

db.properties:

ItemInfo.java:

ItemController.java:

ItemMapper.java:

ItemMapper.xml:

ItemService.java:

ItemServicelmpl.java:

item\_list.jsp:

MySQL数据库数据：

运行结果：

2.参数绑定-默认参数,基本类型参数

--------------------

# 1.查询所有记录 #

新建Dynamic Web Project，命名为：ssm\_project\_springmvc

导入jar包：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 1][]

## web.xml: ##

<?xml version="1.0" encoding="UTF-8"?>
    <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" id="WebApp_ID" version="3.1">
      <display-name>ssm_project_springmvc</display-name>
      <welcome-file-list>
        <welcome-file>index.html</welcome-file>
        <welcome-file>index.htm</welcome-file>
        <welcome-file>index.jsp</welcome-file>
        <welcome-file>default.html</welcome-file>
        <welcome-file>default.htm</welcome-file>
        <welcome-file>default.jsp</welcome-file>
      </welcome-file-list>
      
      <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:applicationContext.xml</param-value>
      	</init-param>
      	<load-on-startup>1</load-on-startup>
      </servlet>
      <servlet-mapping>
      	<servlet-name>springmvc</servlet-name>
      	<url-pattern>*.do</url-pattern>
      </servlet-mapping>
    </web-app>

##  applicationContext.xml:（导入约束：aop,beans，context,mvc,tx,） ##

<?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:aop="http://www.springframework.org/schema/aop"
    	xmlns:context="http://www.springframework.org/schema/context"
    	xmlns:mvc="http://www.springframework.org/schema/mvc"
    	xmlns:tx="http://www.springframework.org/schema/tx"
    	xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd
    		http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.3.xsd
    		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd
    		http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
    		http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsd">
    		
    
    		<context:property-placeholder location="classpath:db.properties"/>
    		
    
    		<bean name="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
    			<property name="driverClass" value="${jdbc.driver}"></property>
    			<property name="jdbcUrl" value="${jdbc.url}"></property>
    			<property name="user" value="${jdbc.username}"></property>
    			<property name="password" value="${jdbc.password}"></property>
    		</bean>
    		
    
    		<context:component-scan base-package="com.sikiedu"></context:component-scan>
    		
    
    		<bean name="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    			<property name="dataSource" ref="dataSource"></property>
    		</bean>
    		
    
    		<tx:annotation-driven/>
    		
    
    		<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    			<property name="prefix" value="/WEB-INF/jsp/"></property>
    			<property name="suffix" value=".jsp"></property>
    		</bean>
    		
    
    		<bean name="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    			<property name="dataSource" ref="dataSource"></property>
    			<property name="typeAliasesPackage" value="com.sikiedu.bean"></property>
    		</bean>
    		
    
    		<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    			<property name="basePackage" value="com.sikiedu.mapper"></property>
    		</bean>
    		
    </beans>

## db.properties: ##

jdbc.driver=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://localhost:3306/web01
    jdbc.username=root
    jdbc.password=root

## ItemInfo.java: ##

/**
     * 
     */
    package com.sikiedu.bean;
    
    /**
     *
     *
     * @author Lijiang
     *2019年5月3日
     */
    
    public class ItemInfo {
    
    	private String item_id;
    	private String item_name;
    	private String item_type;
    	private Double item_price;
    	public String getItem_id() {
    		return item_id;
    	}
    	public void setItem_id(String item_id) {
    		this.item_id = item_id;
    	}
    	public String getItem_name() {
    		return item_name;
    	}
    	public void setItem_name(String item_name) {
    		this.item_name = item_name;
    	}
    	public String getItem_type() {
    		return item_type;
    	}
    	public void setItem_type(String item_type) {
    		this.item_type = item_type;
    	}
    	public Double getItem_price() {
    		return item_price;
    	}
    	public void setItem_price(Double item_price) {
    		this.item_price = item_price;
    	}
    	@Override
    	public String toString() {
    		return "ItemInfo [item_id=" + item_id + ", item_name=" + item_name + ", item_type=" + item_type
    				+ ", item_price=" + item_price + "]";
    	}
    	
    
    	
    }

## ItemController.java: ##

/**
     * 
     */
    package com.sikiedu.controller;
    
    import java.util.List;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.servlet.ModelAndView;
    
    import com.sikiedu.bean.ItemInfo;
    import com.sikiedu.service.ItemService;
    
    /**
     *
     *
     * @author Lijiang
     *2019年5月3日
     */
    @Controller
    public class ItemController {
    
    	@Autowired
    	private ItemService itemService;
    	
    	@RequestMapping("allList.do")
    	public ModelAndView list(){
    		ModelAndView mav=new ModelAndView();
    		
    		List<ItemInfo> itemList = itemService.selectAll();
    		
    		mav.addObject("itemList", itemList);
    		mav.setViewName("item_list");
    
    		return mav;
    	}
    }

## ItemMapper.java: ##

/**
     * 
     */
    package com.sikiedu.mapper;
    
    import java.util.List;
    
    import com.sikiedu.bean.ItemInfo;
    
    /**
     *
     *
     * @author Lijiang
     *2019年5月3日
     */
    
    public interface ItemMapper {
    
    	public List<ItemInfo> selectAll();
    }

## ItemMapper.xml: ##

<?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.sikiedu.mapper.ItemMapper">
    
    
    	<select id="selectAll" resultType="ItemInfo">
    		select * from item_info
    	</select>
    
    </mapper>

## ItemService.java: ##

/**
     * 
     */
    package com.sikiedu.service;
    
    import java.util.List;
    
    import com.sikiedu.bean.ItemInfo;
    
    /**
     *
     *
     * @author Lijiang
     *2019年5月3日
     */
    
    public interface ItemService {
    
    	public List<ItemInfo> selectAll();
    }

## ItemServicelmpl.java: ##

/**
     * 
     */
    package com.sikiedu.service;
    
    import java.util.List;
    
    import javax.annotation.Resource;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    import com.sikiedu.bean.ItemInfo;
    import com.sikiedu.mapper.ItemMapper;
    
    /**
     *
     *
     * @author Lijiang
     *2019年5月3日
     */
    @Service
    public class ItemServicelmpl implements ItemService {
    
    	@Autowired
    	private ItemMapper itemMapper;
    	@Override
    	public List<ItemInfo> selectAll() {
    		return itemMapper.selectAll();
    	}
    
    }

## item\_list.jsp:  ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 2][]

## MySQL数据库数据： ##

![20190503214430428.png][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 3][]

## 运行结果： ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 4][]

# 2.参数绑定-默认参数,基本类型参数 #

ItemMapper.java:

public ItemInfo selectItemInfoById(String id);
    
    	public void deleteById(String id);

ItemMapper.xml

<select id="selectItemInfoById" parameterType="String" resultType="ItemInfo">
    	 	select * from item_info where item_id=#{id}
        </select>
    
    
    	<select id="deleteById" parameterType="String">
    		delete from item_info where item_id=#{id}
    	</select>

ItemService.java:

public ItemInfo selectItemInfoById(String id);
    
    	public void deleteById(String id);

ItemServicelmpl.java:

@Autowired
    	private ItemMapper itemMapper;	
    
    	@Override
    	public ItemInfo selectItemInfoById(String id) {
    		return itemMapper.selectItemInfoById(id);
    	}
    
    
    	@Override
    	public void deleteById(String id) {
    		itemMapper.deleteById(id);
    	}

ItemController.java:

//	参数绑定-默认参数
    	@RequestMapping("select.do")
    	public String select(HttpServletRequest request,HttpServletResponse response,HttpSession session ,Model model){
    		
    		String id=request.getParameter("id");
    		ItemInfo item= itemService.selectItemInfoById(id);
    		List<ItemInfo> itemList=new ArrayList<ItemInfo>();
    		itemList.add(item);
    		
    		model.addAttribute("itemList", itemList);
    
    		return "item_list";
    	}
    	
    //	参数绑定-基本类型
    	@RequestMapping("delete.do")
    	public String delete(String id){
    		
    		itemService.deleteById(id);//注意：这里的参数名“id”必须和item_list.jsp中的deleteItem(id)函数的参数名相同！！不然就不能自动映射了
    
    		//重定向到列表页
    		return "redirect:allList.do";
    	}

item\_list.jsp:  
![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 5][]

//确认删除
    			function deleteItem(id) {
    				if(confirm('确实要删除该游戏吗?')) {
    					$.post(
    						"${pageContext.request.contextPath }/item/delete.do",
    						{"id":id},
    						function(data){
    							window.location.reload();
    					});
    				}
    			}

index.jsp:

<%@ page language="java" contentType="text/html; charset=UTF-8"
        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=UTF-8">
    <title>Insert title here</title>
    </head>
    <body>
    <a href="item/allList.do">To item_list.jsp</a>
    </body>
    </html>

数据库：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 6][]

运行结果：

![20190504221024851.gif][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20190503213644331.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 1]: /images/20210725/7beb1acb08cc438a9dba9599d575f832.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 2]: /images/20210725/7c5f83ac1c7c433da4a0ecdadf59ba61.png
[20190503214430428.png]: https://img-blog.csdnimg.cn/20190503214430428.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 3]: /images/20210725/da22125c90b84d78a0304177273f0acc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 4]: /images/20210725/32d7e0ec8a3c4ab29815f0bde2ac2b3a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 5]: /images/20210725/a8410e262f5a4df899b6a2dc56816b1e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 6]: /images/20210725/d55447f8f357474aa68a648f4452287c.png
[20190504221024851.gif]: /images/20210725/177001bde5de41c9ab7d67e005a6fb3f.png