Spring整合Mybatis

太过爱你忘了你带给我的痛 2022-05-09 07:50 20阅读 0赞

1.  导入jar包（mybatis所有jar包，Spring基本jar包，spring-jdbc，spring-tx,spring-aop,spring整合mybatis的包）；
2.  编写spring配置文件applicationContext.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"
        xsi:schemaLocation="http://www.springframework.org/schema/beans
            http://www.springframework.org/schema/beans/spring-beans.xsd" >
            
          <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
          	<property name="driverClassName" value="com.mysql.jdbc.Driver"></property>      
         	<property name="url" value="jdbc:mysql://localhost:3306/ssm"></property>
         	<property name="username" value="root"></property>
         	<property name="password" value="123456"/>
          </bean>
            
          <bean id="factory" class="org.mybatis.spring.SqlSessionFactoryBean">
          	
          	<property name="dataSource" ref="dataSource"></property>
          </bean>
          
          <bean id="configurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
          	
          	<property name="basePackage" value="com.lee.mapper"></property>
          	
          	<property name="sqlSessionFactory" ref="factory"/>
          </bean>
          
          <bean id="airportService" class="com.lee.service.impl.AirportServiceImpl">
          	<property name="airportMapper" ref="airportMapper"></property>
          </bean>
          
    </beans>

1.  编写代码  
    3.1 正常编写pojo  
    3.2 编写mapper接口绑定方案或者注解  
    3.3 正常编写Service接口与Service实现类  
    3.3.1 需要在Service实现类中声明mapper接口对象，并生成get/set方法  
    3.4 spring无法管理Servlet

web.xml

<?xml version="1.0" encoding="UTF-8"?>
    <web-app version="4.0" xmlns="http://xmlns.jcp.org/xml/ns/javaee" 
    	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
    	xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee                       
    	http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd">
    	
    	<context-param>
    		<param-name>contextConfigLocation</param-name>
    		<param-value>classpath:applicationContext.xml</param-value>
    	</context-param>
    	
    	<listener>
    		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    	</listener>
    	
    </web-app>

servlet

@WebServlet("/airport")
    public class AirportServlet extends HttpServlet{
    	private AirportService airportService;	
    	
    	
    	@Override
    	public void init(ServletConfig config) throws ServletException {
    		//对service实例化
    		//ApplicationContext ac = new ClassPathXmlApplicationContext("applicationContext.xml");
    		//spring和web整合后所有的信息都存放在webApplicationContext
    		ServletContext servletContext = config.getServletContext();
    		System.out.println(servletContext);
    		ApplicationContext ac = WebApplicationContextUtils.getRequiredWebApplicationContext(servletContext);
    		airportService = (AirportService) ac.getBean("airportService",AirportServiceImpl.class);
    		
    	}
    	@Override
    	protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
    		req.setAttribute("list", airportService.show());
    		req.getRequestDispatcher("index.jsp").forward(req, resp);
    	}
    }