SSM框架整合

た入场券 2022-06-08 08:54 361阅读 0赞

SSM框架整合

![Image 1][]

![Center][]

UserController.java

package ssm;
    
    import java.util.Map;
    
    import javax.servlet.http.HttpServletRequest;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.context.support.ClassPathXmlApplicationContext;
    import org.springframework.stereotype.Controller;
    import org.springframework.stereotype.Service;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.servlet.ModelAndView;
    
    @Controller
    public class UserController {
    	//不用注解就要在spring中获取bean创建的对象去调用
    	ClassPathXmlApplicationContext ctx = new ClassPathXmlApplicationContext("ssm_xml/ApplicationContest.xml");
        private UserImpl ui =(UserImpl) ctx.getBean("user");
        	
        @RequestMapping(value="/hello2.do")
        public ModelAndView find(HttpServletRequest request){
        	String id = request.getParameter("id");	
        	Map map=ui.findById(id);
            System.out.println(map);
            ModelAndView mv = new ModelAndView();
            //这里使用ModelAndView对象可以向前台传值，
            mv.addObject("map",map);
            //设置键值对json
            mv.setViewName("hello");
            //向hello页面返回一个mv对象的值
            return mv;
        }
    }

UserImpl.java

package ssm;
    
    import java.util.Map;
    
    import org.mybatis.spring.SqlSessionTemplate;
    
    public class UserImpl {
    	
    	 //注入以后就可以直接使用sqlsession  
        private SqlSessionTemplate sqlsession;  
        public void setSqlsession(SqlSessionTemplate sqlsession) {  
            this.sqlsession = sqlsession; 
        }
        
    	public Map findById(String id){  
    		Map map = sqlsession.selectOne("UserMapper.findById", id);  
    		System.out.println(map);//获取到数据map集合
    		return map;  
    	}
    	
    }

UserMapper.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="UserMapper">
    
        <select id="findById" parameterType="String" resultType="java.util.Map">
            select * from d_user WHERE id=#{id} 
        </select>
    </mapper>

ApplicationContest.xml

<?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:tx="http://www.springframework.org/schema/tx"
        xsi:schemaLocation="
            http://www.springframework.org/schema/beans
            http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
            http://www.springframework.org/schema/context
            http://www.springframework.org/schema/context/spring-context-4.0.xsd
            http://www.springframework.org/schema/tx
            http://www.springframework.org/schema/tx/spring-tx-4.0.xsd">
    
        
        <bean id="dataSource"
            class="org.springframework.jdbc.datasource.DriverManagerDataSource">
            <property name="driverClassName" value="com.mysql.jdbc.Driver" />
            <property name="url" value="jdbc:mysql://localhost:3306/zdy" />
            <property name="username" value="root" />
            <property name="password" value="1111" />
        </bean>
        
              
        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">  
            <property name="dataSource" ref="dataSource"></property>  
            <property name="configLocation" value="classpath:ssm_xml/mybatis-config.xml"></property>  
        </bean>  
          
              
         <bean id="sqlsessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">  
            <constructor-arg index="0" ref="sqlSessionFactory" />  
        </bean>  
              
              
        <bean id="user" class="ssm.UserImpl">  
        <property name="sqlsession" ref="sqlsessionTemplate">  
        </property>  
        </bean>  
    
    </beans>

mybatis-config.xml

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD SQL Map Config 3.0//EN"  
    	"http://mybatis.org/dtd/mybatis-3-config.dtd">
    <configuration>
    	<mappers>
    		<mapper resource="ssm/UserMapper.xml" />
    			
    	</mappers>
    </configuration>

spring-mvc.xml

hello.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>
    <form action="hello2.do" method="post">
        hello:<input type="text" name="id"/>
        <input type="submit" value="提交" /> 
    </form>
    
    ${map}
    </body>
    </html>

web.xml

<?xml version="1.0" encoding="UTF-8"?>
    <web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://java.sun.com/xml/ns/javaee 
        http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
     <welcome-file-list>
        <welcome-file>hello.jsp</welcome-file>
      </welcome-file-list>
        
        <listener>
            <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
        </listener> 
    
        
        <context-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath*:ssm_xml/applicationContext.xml</param-value>
        </context-param>
    
        
        <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*:ssm_xml/spring-mvc.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>
    
        
         <listener>
            <listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class>
        </listener> 
        
        
        <filter>
            <filter-name>encodingFilter</filter-name>
            <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
            <init-param>
                <param-name>encoding</param-name>
                <param-value>UTF-8</param-value>
            </init-param>
            <init-param>
                <param-name>forceEncoding</param-name>
                <param-value>true</param-value>
            </init-param>
        </filter>
    
        <filter-mapping>
            <filter-name>encodingFilter</filter-name>
            <url-pattern>/*</url-pattern>
        </filter-mapping>
    </web-app>

数据库内容

![Image 1][]

![Center 1][]

查询结果

![Image 1][]

![Center 2][]

[Image 1]: 
[Center]: /images/20220608/9aac51d8233a4405b97942e8d7319db8.png
[Center 1]: /images/20220608/ddd0f9f783d9442b876034a49952073f.png
[Center 2]: /images/20220608/a00c59dce963419fb236b93e3d33c609.png