Spring Mybatis整合小例子

港控/mmm° 2022-05-17 09:11 204阅读 0赞

1、新建JavaProject工程 spring-mybatis、部署spring、新建包、添加properties属性文件。目录如下：

![70][]

2、applicationConetxt.xml文件已经把mybatis-config.xml中的dataSource、mappers等配置整合成bean或peroperty

<?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"/>
     
     
     <context:property-placeholder location="classpath:*.properties" />
     
     
     <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
      <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="mapperLocations" value="com/mapper/*.xml"/>
      
      <property name="dataSource" ref="dataSource"/>
     </bean>
     
     
     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
     	<property name="basePackage" value="com.mapper" />
     	<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" /> 	
     </bean>
     
     
       
        <bean id="transactionManager"  
            class="org.springframework.jdbc.datasource.DataSourceTransactionManager">  
            <property name="dataSource" ref="dataSource" />  
        </bean> 
     
     
    </beans>

3、mapper文件

![70 1][]

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

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

4、实体类Student

package com.model;
    
    public class Student {
    	private int sno;
    	private String sname;
    	private double score;
    	
    	public int getSno() {
    		return sno;
    	}
    	public void setSno(int sno) {
    		this.sno = sno;
    	}
    	public String getSname() {
    		return sname;
    	}
    	public void setSname(String sname) {
    		this.sname = sname;
    	}
    	public double getScore() {
    		return score;
    	}
    	public void setScore(double score) {
    		this.score = score;
    	}
    	public Student(int sno, String sname, double score) {
    		super();
    		this.sno = sno;
    		this.sname = sname;
    		this.score = score;
    	}
    	public Student() {
    		super();
    	}
    	@Override
    	public String toString() {
    		return "Student [sno=" + sno + ", sname=" + sname + ", score=" + score + "]";
    	}
    	
    	
    }

5、从配置文件中获得ApplicationContext上下文的工具类

![70 2][]

package com.tool;
    
    import org.springframework.context.ApplicationContext;
    import org.springframework.context.support.ClassPathXmlApplicationContext;
    
    public class AppContext {
    
    	private static ApplicationContext appContext;
    	
    	static{
    		appContext=new ClassPathXmlApplicationContext("applicationContext.xml");
    	}
    	
    	public static <T>T getBean(Class<T> t){
    		return appContext.getBean(t);
    	}
    }

6、service业务包

![70 3][]

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

package com.service;
    
    import java.util.List;
    
    import javax.annotation.Resource;
    
    import org.springframework.stereotype.Service;
    
    import com.mapper.StudentMapper;
    import com.model.Student;
    import com.tool.AppContext;
    
    @Service
    public class StudentServiceImpl implements InterStudentService {
    
    	@Resource
    	private StudentMapper studentMapper;	
    
    	@Override
    	public List<Student> showStudentList() {
    		
    		//ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
    		
    		studentMapper=AppContext.getBean(StudentMapper.class);
    		
    		return studentMapper.getAllStudent();
    	}
    
    }

7、测试类Test

package com.test;
    
    import com.service.InterStudentService;
    import com.service.StudentServiceImpl;
    import com.tool.AppContext;
    
    public class Test {
    
    	public static void main(String[] args) {
    		
    		//InterStudentService stuService=new StudentServiceImpl();
    		
    		InterStudentService stuService=AppContext.getBean(StudentServiceImpl.class);
    		
    		System.out.println(stuService.showStudentList());
    		
    	}
    	
    }

8、结果

![70 4][]

[70]: /images/20220517/b7492d6f186e4a10aa3a9062a747d76c.png
[70 1]: /images/20220517/f39e1d1aed6e434abeac71dce05223ba.png
[70 2]: /images/20220517/3fd285217d81483ea834abc1c80767a6.png
[70 3]: /images/20220517/4e83ecaa6a2c48f2aaf27dd3acbc423c.png
[70 4]: /images/20220517/237a35146f2b4625b857ca33a3283c32.png