美文网首页
Spring整合MyBatis

Spring整合MyBatis

作者: kanaSki | 来源:发表于2019-08-11 16:13 被阅读0次

    依赖jar:


    Spring整合MyBatis依赖jar

    结构:


    项目结构

    applicationContext.xml:

    <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">
        <!--数据源封装类,数据源:获取数据库连接,spring-jdbc.jar中-->
        <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
            <property name="url" value="jdbc:oracle:thin:@192.168.72.3:1521:orcl"></property>
            <property name="username" value="scott"></property>
            <property name="password" value="tiger"></property>
            <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"></property>
        </bean>
        <!--配置sqlSession工厂类-->
        <bean id="factory" class="org.mybatis.spring.SqlSessionFactoryBean">
            <property name="dataSource" ref="dataSource"/>
        </bean>
        <!--扫描器,相当于MyBatis.xml中mapper下的package标签,扫描后会给对应接口创建对象-->
        <bean id="mapper" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            <property name="basePackage" value="com"/>
            <!--与factory关联org.mybatis.spring.mapper.MapperScannerConfigurer-->
            <property name="sqlSessionFactoryBeanName" value="factory"/>
        </bean>
    
        <bean id="empService" class="com.Service.Impl.EmpServiceImpl">
            <property name="empMapper" ref="empMapper"></property>
        </bean>
    </beans>
    

    EmpMapper:

    package com.Mapper;
    
    import com.pojo.Emp;
    import org.apache.ibatis.annotations.Select;
    
    import java.util.List;
    
    public interface EmpMapper {
        @Select("select * from emp")
        public List<Emp> selAll();
    }
    

    EmpServiceImpl:

    package com.Service.Impl;
    
    import com.Mapper.EmpMapper;
    import com.Service.EmpService;
    import com.pojo.Emp;
    
    import java.util.List;
    
    public class EmpServiceImpl implements EmpService {
        private EmpMapper empMapper;
    
        public EmpMapper getEmpMapper() {
            return empMapper;
        }
    
        public void setEmpMapper(EmpMapper empMapper) {
            this.empMapper = empMapper;
        }
    
        @Override
        public List<Emp> selAll() {
            return empMapper.selAll();
        }
    }
    
    

    EmpService:

    package com.Service;
    
    import com.pojo.Emp;
    
    import java.util.List;
    
    public interface EmpService {
        List<Emp> selAll();
    }
    
    

    Test:

    package com;
    
    import com.Service.EmpService;
    import com.pojo.Emp;
    import org.springframework.context.ApplicationContext;
    import org.springframework.context.support.ClassPathXmlApplicationContext;
    
    import java.util.List;
    
    public class Test {
        public static void main(String[] args) {
    //      ClassPathXmlApplicationContext默认去classes文件夹根目录下寻找文件
            ApplicationContext ac = new ClassPathXmlApplicationContext("applicationContext.xml");
            EmpService empService = ac.getBean("empService", EmpService.class);
            List<Emp> emps = empService.selAll();
            for (Emp emp : emps) {
                System.out.println(emp);
            }
        }
    }
    
    

    相关文章

      网友评论

          本文标题:Spring整合MyBatis

          本文链接:https://www.haomeiwen.com/subject/mcarjctx.html