集成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封装
<?xml version="1.0" encoding="UTF-8"?>
<!-- 引入context和beans 约束 -->
<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>
<!-- 扫描mapper文件 : 扫描dao.sql包下的xml文件-->
<property name="mapperLocations" value="classpath:dao/sql/*.xml"></property>
</bean>
<!-- 配置扫描DAO接口的扫描器 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="dao"></property>
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
</bean>
<?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();
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);
}
}
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 事务包
<?xml version="1.0" encoding="UTF-8"?>
<!-- 引入context和beans 约束 -->
<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>
<!-- 扫描mapper文件 : 扫描dao.sql包下的xml文件-->
<property name="mapperLocations" value="classpath:dao/sql/*.xml"></property>
</bean>
<!-- 配置扫描DAO接口的扫描器 -->
<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();
}
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);
}
}