快速集成MyBeatis框架

最新推荐文章于 2024-05-22 16:28:54 发布

java_resolver

最新推荐文章于 2024-05-22 16:28:54 发布

阅读量599

点赞数

分类专栏： java web 学习

本文链接：https://blog.csdn.net/java_resolver/article/details/76269213

版权

java web 学习专栏收录该内容

8 篇文章

订阅专栏

集成MyBeatis框架
   1.在springmvc的基础上导入jar包：
       mybatis-3.3.0.jar   --mybatis 驱动包
       mybatis-spring-1.2.2.jar --mybatis 和spring集成包
       ojdbc6.jar               --oracle驱动包
       spring-jdbc-4.2.4.RELEASE.jar --spring对jdbc封装

spring-tx-4.2.4.RELEASE.jar --spring 事务包

2.在config源目录下创建applicationContext-dao.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:context="http://www.springframework.org/schema/context"
               xsi:schemaLocation="
               http://www.springframework.org/schema/beans
               http://www.springframework.org/schema/beans/spring-beans.xsd
               http://www.springframework.org/schema/context
               http://www.springframework.org/schema/context/spring-context.xsd"
       >
       
       <bean id="dataSource" class="org.apache.tomcat.dbcp.dbcp.BasicDataSource" destroy-method="close">
           
           <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"></property>
           
           <property name="url" value="jdbc:oracle:thin:@服务器名:端口号:Oracle实例"></property>

           <property name="username" value="用户名"></property>
           <property name="password" value="密码"></property>
           <property name="maxActive" value="10"></property>
           <property name="maxIdle" value="5"></property>

       </bean>
       
       <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
           
           <property name="dataSource" ref="dataSource"></property>
           
           <property name="mapperLocations" value="classpath:dao/sql/*.xml"></property>
       </bean>
       
       <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
           <property name="basePackage" value="dao"></property>
           <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
       </bean>

</beans>

3.在src下创建dao.sql 包

       先在sql包下编写xml文件配置sql：
           <?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="dao.TestDao">
               <select id="test" resultType="string">
                   select djl_name from djl_test where rownum = 1
               </select>
           </mapper>
       再在dao包下编写Dao接口
           public interface TestDao {
               public String test();

}

   4.编写一个main方法测试下：
       public class MybatisTest {
           public static void main(String[] args) {
               //获取容器
               ApplicationContext ap = new    ClassPathXmlApplicationContext("classpath:applicationContext-dao.xml");
               //得到bean
               TestDao dao = (TestDao) ap.getBean("testDao");
               //调用方法查询信息
               String str = dao.test();
               System.out.println(str);
           }
       }