使用idea maven实现Spring+mybati的整合
来源:互联网 发布:vsftpd 源码编译安装 编辑:程序博客网 时间:2024/05/19 22:56
Spring和mybatis的整合步骤:
加入Spring和mybatis的有关jar包
建立开发目录结构,创建实体类
创建数据访问接口(BookDao)
创建数据访问接口的实现类(BookDaoImpl)
配置SQL映射文件(BookDao.xml)
配置mybatis应用配置文件(Mybatis-config.xml)
配置Spring应用配置文件(applicationContext.xml)
有关jar包:
<dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>3.8.1</version> <scope>test</scope> </dependency> <!-- mybatis核心包 --> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.4.4</version> </dependency> <!-- mysql驱动包 --> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.29</version> </dependency> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>RELEASE</version> </dependency> <!-- 日志文件管理包 --> <dependency> <groupId>log4j</groupId> <artifactId>log4j</artifactId> <version>1.2.17</version> </dependency> <!-- Spring --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context</artifactId> <version>4.2.1.RELEASE</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-beans</artifactId> <version>4.2.3.RELEASE</version> </dependency> <!--织入的依赖--> <dependency> <groupId> org.aspectj</groupId > <artifactId> aspectjweaver</artifactId > <version> 1.8.6</version > </dependency> <!--spring-mybatis--> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>1.3.1</version> </dependency> <dependency> <groupId>commons-dbcp</groupId> <artifactId>commons-dbcp</artifactId> <version>1.4</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>4.2.5.RELEASE</version> </dependency>BookDao:
package cn.jjz.dao;import cn.jjz.entity.Book;import java.util.List;/** * Created by lenovo on 2017/7/1. */public interface BookDao { //加载所有图书信息 public List<Book> bookList();}BookDaoimpl:
package cn.jjz.dao;import cn.jjz.entity.Book;import org.mybatis.spring.SqlSessionTemplate;import java.util.List;/** * Created by lenovo on 2017/8/1. */public class BookDaoImpl implements BookDao { private SqlSessionTemplate st; public BookDaoImpl() { } public BookDaoImpl(SqlSessionTemplate st) { this.st = st; } public SqlSessionTemplate getSt() { return st; } public void setSt(SqlSessionTemplate st) { this.st = st; } public List<Book> bookList() { return (List<Book>) st.getMapper(BookDao.class).bookList(); }}
BookDao.xml:
<?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="cn.jjz.dao.BookDao"> <!-- 查询所有图书--> <select id="bookList" resultType="Book"> select * from book </select></mapper>applicationContext.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"> <!--配置数据源 用的dbcp--> <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"> <property name="driverClassName" value="com.mysql.jdbc.Driver"></property> <property name="url" value="jdbc:mysql://localhost:3306/bookdb?ampcharacterEncoding=utf-8" /> <property name="username" value="root" /> <property name="password" value=""/> </bean> <!--配置sqlsessionFactoryBean--> <bean id="sessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource"></property> <!--使用mybtis中的配置--> <property name="configLocation" value="classpath:Mybatis-config.xml"></property> <property name="mapperLocations"> <list> <value>classpath:cn/jjz/dao/*.xml</value> </list> </property> </bean> <!--配置sqlsessionTemplate--> <bean id="sessionTemplate" class="org.mybatis.spring.SqlSessionTemplate"> <constructor-arg name="sqlSessionFactory" ref="sessionFactory"></constructor-arg> </bean> <!--配置Dao--> <bean id="book" class="cn.jjz.dao.BookDaoImpl"> <property name="st" ref="sessionTemplate"></property> </bean></beans>
Mybatis-config.xml:
<?xml version="1.0" encoding="utf-8"?><!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"><configuration> <!--log4j--> <settings> <setting name="logImpl" value="STDOUT_LOGGING"/> </settings> <!--类型别名--> <typeAliases> <package name="cn.jjz.entity"></package> </typeAliases></configuration>
BookTest测试类:
import cn.jjz.dao.BookDao;import cn.jjz.entity.Book;import org.junit.Test;import org.springframework.context.ApplicationContext;import org.springframework.context.support.ClassPathXmlApplicationContext;import java.util.List;/** * Created by lenovo on 2017/8/1. */public class BookTest { @Test public void a() throws Exception { ApplicationContext a=new ClassPathXmlApplicationContext("applicationContext.xml"); BookDao d=(BookDao) a.getBean("book"); List<Book> dd= d.bookList(); for (Book b:dd ) { System.out.println(b.getBookname()); } }}
阅读全文
1 0
- 使用idea maven实现Spring+mybati的整合
- 使用idea maven实现Spring+mybati的整合
- SpringMVC+Spring+Mybati+Maven+Mysql整合
- spring+SpringMVC+mybati整合JBPM
- 使用Idea创建ssm项目,SpringMVC+Spring+MyBatis+Maven整合
- IDEA中使用maven整合mybatis与spring
- 使用Idea创建ssm项目,SpringMVC+Spring+MyBatis+Maven整合
- 使用Idea创建ssm项目,SpringMVC+Spring+MyBatis+Maven整合
- Intellij idea下使用Maven管理的Spring+SpringMVC+Mybatis的整合
- SSH之IDEA使用maven整合实现简易用户登录
- Idea SpringMVC+Spring+MyBatis+Maven整合
- IDEA+Maven+Spring+SpringMVC+SpringJDBC整合Demo
- Idea SpringMVC+Spring+MyBatis+Maven整合
- Idea SpringMVC+Spring+MyBatis+Maven整合
- IDEA+Maven整合Spring与MyBatis框架
- Idea中Maven整合Spring+mybatis+tomcat
- spring和mybatis的整合使用,未使用整合包的情况下maven用5可实现
- idea 基于maven 的 spring + spring mvc + mybatis ssm高级整合记录
- Cordova+X5(tencent webview)
- HDFS——数据备份与放置策略(转)
- 排序问题
- camtasia studio导出1080p高清视频的设置
- 机器人操作系统(ROS) 简介
- 使用idea maven实现Spring+mybati的整合
- 微信小程序 转发
- React-Redux的基本用法
- Android Studio 使用教程(二十六)之Android Studio生成jar包
- 如何程序不用等待即可自动执行word打印
- 生成某个范围内N个不重复随机数与生成固定长度数组
- 运用基尔霍夫矩阵树定理计算图的生成树个数
- python3.5+selenium3.4自动化测试6_selenium的Webdriver-API整理(上)
- Android-透明状态栏