- 浏览: 691829 次
- 性别:
- 来自: 成都
-
文章分类
- 全部博客 (129)
- Java (13)
- Android (9)
- J2ee (3)
- Swt/jface (0)
- SSH (9)
- C/C++ (1)
- php (1)
- Algorithm (2)
- Apache/Nginx (12)
- Bea/Tomcat (2)
- Oracle/Mysql (10)
- Sql/derby (17)
- Unix/Linux (11)
- Hadoop (1)
- Hbase (15)
- Redis (2)
- Lucene/Solr (0)
- Httpclient (1)
- Groovy (2)
- SoftwareEng (2)
- HTML/JS/CSS (3)
- Flex (1)
- log4j (1)
- Protocol (3)
- windows (0)
- Tools (1)
- docker (1)
- k8s (1)
- Business (3)
- Others (3)
最新评论
1. 单独整合ibatis
ibatis和hibernate一样, 总体上没有hibernate那么强大.但是ibatis简单易用.
区别:
hibernate中每个实体类配置的注解和xml对应于数据库,ORM关系看比较紧;查询更新以实体对象为基准;
ibatis中每个实体也配置xml和实体类(entity和数据库对应的字段);配置要用的SQL语句;
A. 见证实体对象User.java
package cn.edu.zju.jjh.entity; import java.io.Serializable; /**** * * @author greatwqs * @date 2011-12-02 */ public class User implements Serializable { private static final long serialVersionUID = 1L; private String id; private String name; private String password; private String description; // getter and setter }
B. 对应实体的ibatis的xml配置信息.Users.xml
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd"> <sqlMap namespace="User"> <!-- Use type aliases to avoid typing the full classname every time. --> <typeAlias alias="User" type="cn.edu.zju.jjh.entity.User" /> <!-- Result maps describe the mapping between the columns returned from a query, and the class properties. A result map isn't necessary if the columns (or aliases) match to the properties exactly. --> <resultMap id="UserResult" class="User"> <result property="id" column="id" /> <result property="name" column="name" /> <result property="password" column="password" /> <result property="description" column="description" /> </resultMap> <!-- Select with no parameters using the result map for Account class. --> <select id="selectAllUsers" resultMap="UserResult"> select * from Users </select> <!-- A simpler select example without the result map. Note the aliases to match the properties of the target result class. --> <select id="selectUserById" parameterClass="String" resultClass="User"> select id as id, name as name, password as password, description as description from Users where id = #id# </select> <!-- Insert example, using the Account parameter class --> <insert id="insertUser" parameterClass="User"> insert into Users (id,name, password,description) values ( #id#, #name#, #password#, #description#) </insert> <!-- Update example, using the Account parameter class --> <update id="updateAccount" parameterClass="User"> update Users set name = #name#, password = #password#, description = #description# where id = #id# </update> <!-- Delete example, using an integer as the parameter class --> <delete id="deleteUserById" parameterClass="String"> delete from Users where id = #id# </delete> </sqlMap>
主要是数据库字段和实体字段的对应和常用SQL的配置.
C. ibatis总的配置文件 SqlMapConfig.xml
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE sqlMapConfig PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-config-2.dtd"> <sqlMapConfig> <!-- Configure a built-in transaction manager. If you're using an app server, you probably want to use its transaction manager and a managed datasource --> <transactionManager type="JDBC" commitRequired="false"> <dataSource type="SIMPLE"> <property name="JDBC.Driver" value="com.mysql.jdbc.Driver"/> <property name="JDBC.ConnectionURL" value="jdbc:mysql://localhost:3306/ibatistest"/> <property name="JDBC.Username" value="root"/> <property name="JDBC.Password" value="greatwqs"/> </dataSource> </transactionManager> <!-- List the SQL Map XML files. They can be loaded from the classpath, as they are here (com.domain.data...) --> <sqlMap resource="cn/edu/zju/jjh/entity/Users.xml"/> <!-- List more here... <sqlMap resource="com/mydomain/data/Order.xml"/> <sqlMap resource="com/mydomain/data/Documents.xml"/> --> </sqlMapConfig>
D: 测试IbatisTest.java
package cn.edu.zju.jjh; import java.io.IOException; import java.io.Reader; import java.sql.SQLException; import cn.edu.zju.jjh.entity.User; import com.ibatis.common.resources.Resources; import com.ibatis.sqlmap.client.SqlMapClient; import com.ibatis.sqlmap.client.SqlMapClientBuilder; public class IbatisTest { /*** * 使用纯Ibatis进行测试! */ public static void main(String[] args) { String resource = "sqlMapConfig_ibatis.xml"; Reader reader; SqlMapClient sqlMap = null; try { reader = Resources.getResourceAsReader(resource); sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader); sqlMap.startTransaction(); User user = new User(); user.setId("1099"); user.setName("EagleWang"); user.setPassword("EaglePassword"); user.setDescription("Email: greatwqs@163.com"); sqlMap.insert("insertUser", user); sqlMap.commitTransaction(); sqlMap.endTransaction(); } catch (IOException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } } }
执行测试成功:
DEBUG-Created connection 1073282. DEBUG-{conn-100000} Connection DEBUG-{conn-100000} Preparing Statement: insert into Users (id,name, password,description) values ( ?, ?, ?, ?) DEBUG-{pstm-100001} Executing Statement: insert into Users (id,name, password,description) values ( ?, ?, ?, ?) DEBUG-{pstm-100001} Parameters: [1099, EagleWang, EaglePassword, Email: greatwqs@163.com] DEBUG-{pstm-100001} Types: [java.lang.String, java.lang.String, java.lang.String, java.lang.String] DEBUG-Returned connection 1073282 to pool.
2. Spring整合Ibatis
通过上面的配置测试成功,证明ibatis能独立测试成功!
A. Spring配置如下:
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd"> <beans> <!-- 配置数据源,这里配置在Spring中,就不需要在ibatis中配置数据源了 --> <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName"> <value>com.mysql.jdbc.Driver</value> </property> <property name="url"> <value>jdbc:mysql://localhost:3306/ibatistest</value> </property> <property name="username"> <value>root</value> </property> <property name="password"> <value>greatwqs</value> </property> </bean> <!-- spring对ibatis配置文件读取的实现,指定ibatis配置文件的目录,配置文件只需放置有哪些实体的xml所在位置 --> <bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean"> <property name="configLocation"> <value>SqlMapConfig_spring.xml</value> </property> </bean> <!-- Spring配置事务,ref = 数据源 --> <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource"> <ref local="dataSource" /> </property> </bean> <!-- 与hibernate相似,如果需要建立DAO层,传入链接数据源+ibatis特有的sqlMapClient,而在DAO中要继承类SqlMapClientDaoSupport,hibernate中是HibernateDaoSupport --> <bean id="userDao" class="cn.edu.zju.jjh.dao.UserDaoImpl"> <property name="dataSource"> <ref local="dataSource" /> </property> <property name="sqlMapClient"> <ref local="sqlMapClient" /> </property> </bean> <!-- userDaoProxy为一个userDao的形式,中间加入事务的支持,在action中UserDaoInterface userDao = (UserDaoInterface) springContex.getBean("userDaoProxy"); --> <bean id="userDaoProxy" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean"> <property name="transactionManager"> <ref bean="transactionManager" /> </property> <property name="target"> <ref local="userDao" /> </property> <property name="transactionAttributes"> <props> <prop key="insert*">PROPAGATION_REQUIRED</prop> <prop key="get*">PROPAGATION_REQUIRED,readOnly</prop> </props> </property> </bean> </beans>
B. SqlMapConfig_spring.xml只需配置:(与上面1.C中的配置文件做比较)
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE sqlMapConfig PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-config-2.dtd"> <sqlMapConfig> <!-- List the SQL Map XML files. They can be loaded from the classpath, as they are here (com.domain.data...) --> <sqlMap resource="cn/edu/zju/jjh/entity/Users.xml" /> <!-- List more here... <sqlMap resource="com/mydomain/data/Order.xml"/> <sqlMap resource="com/mydomain/data/Documents.xml"/> --> </sqlMapConfig>
C. Spring+ibatis集成测试代码
package cn.edu.zju.jjh; import org.springframework.context.support.ClassPathXmlApplicationContext; import cn.edu.zju.jjh.dao.UserDaoInterface; import cn.edu.zju.jjh.entity.User; public class SpringTest { public static void main(String arg[]){ ClassPathXmlApplicationContext ac = new ClassPathXmlApplicationContext("applicationContext.xml"); UserDaoInterface userDao = (UserDaoInterface) ac.getBean("userDaoProxy"); try { User user = new User(); user.setId("20001"); user.setName("greatwqs"); user.setPassword("GreatPassword"); user.setDescription("Email: greatwqs@126.com"); userDao.insertUser(user); } catch (Exception e) { e.printStackTrace(); } } }
成功测试:
INFO-Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@10dd1f7: display name [org.springframework.context.support.ClassPathXmlApplicationContext@10dd1f7]; startup date [Fri Dec 02 18:27:03 CST 2011]; root of context hierarchy DEBUG-Class [org.apache.commons.collections.map.CaseInsensitiveMap] or one of its dependencies is not present: java.lang.ClassNotFoundException: org.apache.commons.collections.map.CaseInsensitiveMap DEBUG-Class [edu.emory.mathcs.backport.java.util.concurrent.ConcurrentHashMap] or one of its dependencies is not present: java.lang.ClassNotFoundException: edu.emory.mathcs.backport.java.util.concurrent.ConcurrentHashMap INFO-Loading XML bean definitions from class path resource [applicationContext.xml] DEBUG-Using JAXP provider [com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderFactoryImpl] DEBUG-Found beans DTD [http://www.springframework.org/dtd/spring-beans.dtd] in classpath: spring-beans.dtd DEBUG-Loading bean definitions DEBUG-Loaded 5 bean definitions from location pattern [applicationContext.xml] INFO-Bean factory for application context [org.springframework.context.support.ClassPathXmlApplicationContext@10dd1f7]: org.springframework.beans.factory.support.DefaultListableBeanFactory@ecd7e DEBUG-5 beans defined in org.springframework.context.support.ClassPathXmlApplicationContext@10dd1f7: display name [org.springframework.context.support.ClassPathXmlApplicationContext@10dd1f7]; startup date [Fri Dec 02 18:27:03 CST 2011]; root of context hierarchy DEBUG-Unable to locate MessageSource with name 'messageSource': using default [org.springframework.context.support.DelegatingMessageSource@8b819f] DEBUG-Unable to locate ApplicationEventMulticaster with name 'applicationEventMulticaster': using default [org.springframework.context.event.SimpleApplicationEventMulticaster@789144] INFO-Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@ecd7e: defining beans [dataSource,sqlMapClient,transactionManager,userDao,userDaoProxy]; root of factory hierarchy DEBUG-Creating shared instance of singleton bean 'dataSource' DEBUG-Creating instance of bean 'dataSource' DEBUG-Eagerly caching bean 'dataSource' to allow for resolving potential circular references DEBUG-Finished creating instance of bean 'dataSource' DEBUG-Creating shared instance of singleton bean 'sqlMapClient' DEBUG-Creating instance of bean 'sqlMapClient' DEBUG-Eagerly caching bean 'sqlMapClient' to allow for resolving potential circular references DEBUG-Invoking afterPropertiesSet() on bean with name 'sqlMapClient' DEBUG-Finished creating instance of bean 'sqlMapClient' DEBUG-Creating shared instance of singleton bean 'transactionManager' DEBUG-Creating instance of bean 'transactionManager' DEBUG-Eagerly caching bean 'transactionManager' to allow for resolving potential circular references DEBUG-Returning cached instance of singleton bean 'dataSource' DEBUG-Invoking afterPropertiesSet() on bean with name 'transactionManager' DEBUG-Finished creating instance of bean 'transactionManager' DEBUG-Creating shared instance of singleton bean 'userDao' DEBUG-Creating instance of bean 'userDao' DEBUG-Eagerly caching bean 'userDao' to allow for resolving potential circular references DEBUG-Returning cached instance of singleton bean 'dataSource' DEBUG-Returning cached instance of singleton bean 'sqlMapClient' DEBUG-Invoking afterPropertiesSet() on bean with name 'userDao' DEBUG-Finished creating instance of bean 'userDao' DEBUG-Creating shared instance of singleton bean 'userDaoProxy' DEBUG-Creating instance of bean 'userDaoProxy' DEBUG-Eagerly caching bean 'userDaoProxy' to allow for resolving potential circular references DEBUG-Returning cached instance of singleton bean 'transactionManager' DEBUG-Returning cached instance of singleton bean 'userDao' DEBUG-Adding transactional method [insert*] with attribute [PROPAGATION_REQUIRED,ISOLATION_DEFAULT] DEBUG-Adding transactional method [get*] with attribute [PROPAGATION_REQUIRED,ISOLATION_DEFAULT,readOnly] DEBUG-Invoking afterPropertiesSet() on bean with name 'userDaoProxy' DEBUG-Creating JDK dynamic proxy: target source is SingletonTargetSource for target object [cn.edu.zju.jjh.dao.UserDaoImpl@12cc95d] DEBUG-Finished creating instance of bean 'userDaoProxy' DEBUG-Publishing event in context [org.springframework.context.support.ClassPathXmlApplicationContext@10dd1f7]: org.springframework.context.event.ContextRefreshedEvent[source=org.springframework.context.support.ClassPathXmlApplicationContext@10dd1f7: display name [org.springframework.context.support.ClassPathXmlApplicationContext@10dd1f7]; startup date [Fri Dec 02 18:27:03 CST 2011]; root of context hierarchy] DEBUG-Returning cached instance of singleton bean 'userDaoProxy' DEBUG-Using transaction object [org.springframework.jdbc.datasource.DataSourceTransactionManager$DataSourceTransactionObject@15fadcf] DEBUG-Creating new transaction with name [cn.edu.zju.jjh.dao.UserDaoInterface.insertUser]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT DEBUG-Acquired Connection [jdbc:mysql://localhost:3306/ibatistest, UserName=root@localhost, MySQL-AB JDBC Driver] for JDBC transaction DEBUG-Switching JDBC Connection [jdbc:mysql://localhost:3306/ibatistest, UserName=root@localhost, MySQL-AB JDBC Driver] to manual commit DEBUG-Bound value [org.springframework.jdbc.datasource.ConnectionHolder@f4f44a] for key [org.apache.commons.dbcp.BasicDataSource@b23210] to thread [main] DEBUG-Initializing transaction synchronization DEBUG-Opened SqlMapSession [com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl@1ec8909] for iBATIS operation DEBUG-Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@f4f44a] for key [org.apache.commons.dbcp.BasicDataSource@b23210] bound to thread [main] DEBUG-{conn-100000} Connection DEBUG-Obtained JDBC Connection [jdbc:mysql://localhost:3306/ibatistest, UserName=root@localhost, MySQL-AB JDBC Driver] for iBATIS operation DEBUG-{conn-100000} Preparing Statement: insert into Users (id,name, password,description) values ( ?, ?, ?, ?) DEBUG-{pstm-100001} Executing Statement: insert into Users (id,name, password,description) values ( ?, ?, ?, ?) DEBUG-{pstm-100001} Parameters: [20001, greatwqs, GreatPassword, Email: greatwqs@126.com] DEBUG-{pstm-100001} Types: [java.lang.String, java.lang.String, java.lang.String, java.lang.String] DEBUG-Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@f4f44a] for key [org.apache.commons.dbcp.BasicDataSource@b23210] bound to thread [main] DEBUG-Triggering beforeCommit synchronization DEBUG-Triggering beforeCompletion synchronization DEBUG-Initiating transaction commit DEBUG-Committing JDBC transaction on Connection [jdbc:mysql://localhost:3306/ibatistest, UserName=root@localhost, MySQL-AB JDBC Driver] DEBUG-Triggering afterCommit synchronization DEBUG-Triggering afterCompletion synchronization DEBUG-Clearing transaction synchronization DEBUG-Removed value [org.springframework.jdbc.datasource.ConnectionHolder@f4f44a] for key [org.apache.commons.dbcp.BasicDataSource@b23210] from thread [main] DEBUG-Releasing JDBC Connection [jdbc:mysql://localhost:3306/ibatistest, UserName=root@localhost, MySQL-AB JDBC Driver] after transaction DEBUG-Returning JDBC Connection to DataSource
classpath:
<?xml version="1.0" encoding="UTF-8"?> <classpath> <classpathentry kind="src" path="src"/> <classpathentry kind="con" path="org.eclipse.jdt.launching.JRE_CONTAINER"/> <classpathentry kind="con" path="melibrary.com.genuitec.eclipse.springframework.MYECLIPSE_SPRING25_CORE"/> <classpathentry kind="con" path="melibrary.com.genuitec.eclipse.springframework.MYECLIPSE_SPRING25_AOP"/> <classpathentry kind="con" path="melibrary.com.genuitec.eclipse.springframework.MYECLIPSE_SPRING25_PERSISTENCE_CORE"/> <classpathentry kind="con" path="melibrary.com.genuitec.eclipse.springframework.MYECLIPSE_SPRING25_PERSISTENCE_IBATIS"/> <classpathentry kind="con" path="melibrary.com.genuitec.eclipse.springframework.MYECLIPSE_SPRING25_PERSISTENCE_JDBC"/> <classpathentry kind="con" path="melibrary.com.genuitec.eclipse.springframework.MYECLIPSE_SPRING25_PERSISTENCE_JDO"/> <classpathentry kind="lib" path="lib/ibatis-common-2.jar"/> <classpathentry kind="lib" path="lib/ibatis-dao-2.jar"/> <classpathentry kind="lib" path="lib/ibatis-sqlmap-2.jar"/> <classpathentry kind="lib" path="lib/log4j-1.2.9.jar"/> <classpathentry kind="lib" path="lib/mysql-connector-java-3.1.12-bin.jar"/> <classpathentry kind="var" path="MYECLIPSE_SPRING_DATA_HOME/1.2/lib/spring-aop.jar"/> <classpathentry kind="output" path="bin"/> </classpath>
两个测试程序在一起.
附上源码+lib+建表SQL:
- FirstIbatisDemo.zip (1.1 MB)
- 下载次数: 678
发表评论
-
基于Spring AOP 注解缓存Demo [附源码]
2016-08-27 19:20 0一. 现在的缓存: 现在APP局部或多或少都使用了缓存, ... -
纯Struts2登录实例Demo+源码
2011-12-01 17:12 22966接触到别人的新的项目, 不得不研究下Struts2了. 用st ... -
Spring3+Hibernate3+Struts1流程总结
2011-05-14 17:27 1929SSH结束之后,NOVA团队就基于SSH实现了NOVA音乐视频 ... -
Spring3整合Hibernate3
2011-05-14 17:14 70736.5 Spring整合Hibernate 时至今日,可能极 ... -
Spring整合Struts
2011-05-14 17:06 12126.4 Spring整合Struts 虽然Spring也 ... -
Spring的AOP
2011-05-14 16:50 12196.2 Spring的AOP AOP(Aspe ... -
Spring中的事务
2011-05-14 16:42 12686.3 Spring的事务 Spring的事务管理不需与任何 ... -
<<Hibernate基础教程>>总结
2011-05-14 16:34 1546一.总体概述: Hibernate 的底层也是由JDBC 实现 ... -
<<深入浅出Struts>>总结
2011-05-14 16:28 1179一.纵观本书:基本原理是实现控制器的功能和展示层的标签.for ...
相关推荐
《IbatisDemo入门源码详解》 IbatisDemo是一个典型的基于Ibatis框架的入门示例,它为我们展示了如何在Java项目中使用Ibatis进行数据库操作。Ibatis,一个优秀的持久层框架,它允许开发者将SQL语句直接写在配置文件...
这里,我们有一个名为"ibatisDemo"的压缩包,其中包含了基于Maven构建的SpringMVC+iBatis项目实例和源代码。 **SpringMVC框架** 是Spring框架的一部分,专门用于处理Web应用的请求和响应。它提供了模型-视图-控制器...
这个实例源码可能是为了演示如何将这三个框架整合在一起,实现一个简单的登录功能。通过Struts接收用户输入,Spring管理对象和事务,iBATIS执行数据库查询。学习这个实例可以帮助理解SS+I架构的工作原理,为开发更...
在压缩包文件“ibatisdemo”中,可能包含了项目结构示例,包括配置文件、Mapper XML文件、Mapper接口、实体类等,通过实际操作这些文件,你可以更直观地学习和掌握上述知识点。记得打开源码,查看注释,这对于理解和...
【标题】"zk_demo实例"揭示的是一个基于ZooKeeper、Spring和iBatis的综合应用案例。ZooKeeper是一个分布式的,开放源码的分布式应用程序协调服务,它是集群的管理者,监视着集群中各个节点的状态根据节点提交的反馈...
标题中的“自已搭ibatis”意味着我们将讨论如何自己动手搭建和使用MyBatis框架,一个流行的Java持久层框架,它允许开发者将SQL查询与Java代码无缝集成。MyBatis消除了几乎所有的JDBC代码和手动设置参数以及获取结果...
rapid-framework是一个以spring为核心的项目脚手架(或者称为胶水框架),框架将各个零散的框架(struts,strust2,springmvc,hibernate,ibatis,spring_jdbc,flex)搭建好,并内置一个代码生成器,辅助项目开发,可以生成...