sqlMapConfig.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//ibatis.apache.org//DTD Config 3.0//EN"
"http://ibatis.apache.org/dtd/ibatis-3-config.dtd">
<configuration>
<properties resource="com/ibatis3/conf/jdbc.properties" />
<settings>
<setting name="cacheEnabled" value="true"/>
<setting name="lazyLoadingEnabled" value="true"/>
<setting name="multipleResultSetsEnabled" value="true"/>
<setting name="useColumnLabel" value="true"/>
<setting name="useGeneratedKeys" value="false"/>
<!-- <setting name="enhancementEnabled" value="false"/> -->
<setting name="defaultExecutorType" value="SIMPLE"/>
<setting name="defaultStatementTimeout" value="25000"/>
</settings>
<typeAliases>
<typeAlias type="com.ibatis3.bean.BookBean" alias="bookBean"/>
</typeAliases>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="UNPOOLED">
<property name="driver" value="${oracle.driver}"/>
<property name="url" value="${oracle.url}"/>
<property name="username" value="${oracle.username}"/>
<property name="password" value="${oracle.password}"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="com/ibatis3/dao/sql/bookSqlMapper.xml"/>
</mappers>
</configuration>
bookSqlMapper.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//ibatis.apache.org//DTD Mapper 3.0//EN"
"http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd">
<mapper namespace="book">
<select id="selectBook" resultType="bookBean">
select
BOOKID AS book_id,
BOOKNAME AS book_name,
BOOKAUTHER AS book_author
from BOOKS
</select>
</mapper>
BookBean.java
package com.ibatis3.bean;
import java.io.Serializable;
public class BookBean implements Serializable{
/**
*
*/
private static final long serialVersionUID = 1L;
private String book_id;
private String book_name;
private String book_author;
public String getBook_id() {
return book_id;
}
public void setBook_id(String book_id) {
this.book_id = book_id;
}
public String getBook_name() {
return book_name;
}
public void setBook_name(String book_name) {
this.book_name = book_name;
}
public String getBook_author() {
return book_author;
}
public void setBook_author(String book_author) {
this.book_author = book_author;
}
}
BookDao.java
package com.ibatis3.dao;
import java.util.List;
import com.ibatis3.bean.BookBean;
public interface BookDao {
public BookBean selectBook(String id);
public List<BookBean> queryBook();
}
BookDaoImpl.java
package com.ibatis3.dao.impl;
import java.util.List;
import com.ibatis3.bean.BookBean;
import com.ibatis3.dao.BookDao;
import com.ibatis3.utils.IbatisSessionFactory;
public class BookDaoImpl extends IbatisSessionFactory implements BookDao{
@Override
public List<BookBean> queryBook() {
return this.getSession().selectList("book.selectBook");
}
@Override
public BookBean selectBook(String id) {
// TODO Auto-generated method stub
return null;
}
}
IbatisSessionFactory.java
package com.ibatis3.utils;
import java.io.Reader;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
public class IbatisSessionFactory {
public SqlSessionFactory buildSqlSessionFactory() {
try {
String resource = "com/ibatis3/conf/sqlMapConfig.xml";
Reader reader = Resources.getResourceAsReader(resource);
return new SqlSessionFactoryBuilder().build(reader);
} catch (Exception e) {
logger.warn("failed to build SqlSessionFactory: ", e);
e.printStackTrace();
return null;
}
}
public SqlSession getSession(){
return buildSqlSessionFactory().openSession();
}
private static Logger logger = LoggerFactory.getLogger(IbatisSessionFactory.class);
}
IbatisTest.java
package com.ibatis3.test;
import java.util.Iterator;
import java.util.List;
import com.ibatis3.bean.BookBean;
import com.ibatis3.dao.BookDao;
import com.ibatis3.dao.impl.BookDaoImpl;
public class IbatisTest {
/**
* @param args
*/
public static void main(String[] args) {
BookDao bookDao = new BookDaoImpl();
List<BookBean> list = bookDao.queryBook();
for(Iterator<BookBean> it = list.iterator();it.hasNext();){
BookBean bean = it.next();
System.out.print(bean.getBook_id()+" , ");
System.out.print(bean.getBook_name()+" , ");
System.out.println(bean.getBook_author()+" , ");
}
}
}
分享到:
相关推荐
Ibatis3,手册,Ibatis3手册,Ibatis3使用手册,Ibatis3参考手册
IBatis3.0学习IBatis3.0学习IBatis3.0学习IBatis3.0学习IBatis3.0学习IBatis3.0学习IBatis3.0学习
ibatis 学习笔记 ibatis 学习笔记 ibatis 学习笔记 ibatis 学习笔记 ibatis 学习笔记 ibatis 学习笔记 ibatis 学习笔记 ibatis 学习笔记
iBATIS入门学习
ibatis学习 ibatis总结 ibatis ibatis ibatis
3.iBatis2学习笔记:单表映射 .doc 4.iBatis2学习笔记:SqlMap的配置总结(18条).doc 5.iBatis2学习笔记:入参和返回值的问题.doc 6.iBatis2学习笔记:一对多映射(双向).doc 7.iBatis2学习笔记:多对多映射(双向)...
ibatis3资料-介绍,新功能介绍及如何使用
ibatis开发指南 ibatis资料文档 ibatis2.x_jar包 ibatis源码 ibatis实践项目
Ibatis.net学习和实例Ibatis.net学习和实例Ibatis.net学习和实例Ibatis.net学习和实例
IBATIS3代码生成器 ibatis,Ibator,Abator
J2EE学习 Ibatis开发资料共享 Ibatis开发资料 Ibatis学习框架 Ibatis开发概要
ibatis学习总结,oracle 学习总结,大数据量处理
J2EE学习 Ibatis开发资料共享 Ibatis开发资料 Ibatis学习框架 Ibatis开发概要
ibatis.rar 学习手册学习手册学习手册各种讲解
ibatis3开发指南ibatis3开发指南ibatis3开发指南ibatis3开发指南ibatis3开发指南ibatis3开发指南ibatis3开发指南ibatis3开发指南ibatis3开发指南ibatis3开发指南ibatis3开发指南
ibatis学习资料ibatis学习资料ibatis学习资料ibatis学习资料ibatis学习资料ibatis学习资料ibatis学习资料ibatis学习资料ibatis学习资料ibatis学习资料ibatis学习资料ibatis学习资料
ibatis资料ibatis资料ibatis资料ibatis资料ibatis资料ibatis资料ibatis资料ibatis资料ibatis资料
相对于Hibernate和Apache OJB等“一站式”ORM解决方案而言,IBatis是一种“半...它需要学习的东西很少,在连接表或复杂查询时也不需要复杂的scheme(怎么翻complex scheme?),使用SQL Maps, 你可以自由的使用SQL语句。
在做一个mis系统的时候,公司用到了iBATIS来作为持久化的框架,并结合spring2.5的mvc来完成,项目现在已经完成,把iBATIS做了一下总结。
java 技术分享:ibatis_3_学习笔记