基于xml文件Spring整合Mybatis

    junit
    junit
    4.11



    org.mybatis
    mybatis-spring
    2.0.3



    org.mybatis
    mybatis
    3.5.1



    com.alibaba
    druid
    1.1.22


    org.springframework
    spring-context
    5.0.5.RELEASE


    org.springframework
    spring-beans
    5.0.5.RELEASE



    org.springframework
    spring-jdbc
    5.3.5




    org.aspectj
    aspectjweaver
    1.9.6
    runtime


    mysql
    mysql-connector-java
    5.1.46




    
        
            src/main/java
            
                ***.xml
            
            false
        
    

• public class Student {
      private Integer Sid;
      private String Sname;
      private String Sage;
      private String Ssex;
  	
      getter和setter方法
  }
  

• 创建StudentDao

  • public interface StudentDao {
        List getAllStudent();
    }
    

• 编写StudentDao.xml配置文件

  • 
    
    
        
            select * from student
        
    
    

• 创建StudentService

  • public interface StudentService {
    List getAllStudent();
    }
    

• 创建StudentServiceImpl实现StudentService

  • public class StudentServiceImpl implements StudentService {
        public StudentDao getStudentDao() {
            return studentDao;
        }
    
        public void setStudentDao(StudentDao studentDao) {
            this.studentDao = studentDao;
        }
    
        private StudentDao studentDao;
        public List getAllStudent() {
            return studentDao.getAllStudent();
        }
    }
    

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/practice?userUnicode=True&characterEncoding=UTF-8
jdbc.username=root
jdbc.password=123456

public class StudentServiceImplTest {
    @Test
    public void getAllStudent() {
        ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
        StudentService studentService = (StudentService) context.getBean("studentService");
        List allStudent = studentService.getAllStudent();
        for (Student student : allStudent) {
            System.out.println(student.getSname());
        }
    }
}