MyBatis3.0单独例子。
??? 近来打算开发一个技术框架,并应用此框架开发出一个论坛,开始打算用sturts2+spring+hibernate+jquery为基础,然后再进行封装,最后形成技术框架,但通过此网站获知mybatis比hibernate更灵活,实用。因此开始逐步接触mybatis。
???? 以下是mybatis3.0的开发实例,使用的java环境jdk5.0,ide为eclipse3.7,数据库是oracle11g。
1.数据环境配置
2.数据库表映射(DM_MYDWT)XML文件
?3.数据库表(DM_MYDWT)java
?7.控制台信息输出
2012-02-08 11:43:01 Logging initialized using 'org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl' adapter.2012-02-08 11:43:01 PooledDataSource forcefully closed/removed all connections.2012-02-08 11:43:01 PooledDataSource forcefully closed/removed all connections.2012-02-08 11:43:01 PooledDataSource forcefully closed/removed all connections.2012-02-08 11:43:01 PooledDataSource forcefully closed/removed all connections.2012-02-08 11:43:02 Created connection 17671659.2012-02-08 11:43:02 ooo Connection Opened2012-02-08 11:43:02 ==> Executing: select MYDWT_DM, MYDWT_MC, YXBZ, XYBZ from EASSEN.DM_MYDWT where MYDWT_DM = ? 2012-02-08 11:43:02 ==> Parameters: 1001(String)2012-02-08 11:43:02 <== Columns: MYDWT_DM, MYDWT_MC, YXBZ, XYBZ2012-02-08 11:43:02 <== Row: 1001, 您经常访问的网站包括:, Y, Ymybatis查询测试:=================================MYDWT_DM:1001MYDWT_MC:您经常访问的网站包括:mybatis保存测试:=================================2012-02-08 11:43:02 ==> Executing: insert into EASSEN.DM_MYDWT (MYDWT_DM, MYDWT_MC, YXBZ, XYBZ) values (?, ?, ?, ?) 2012-02-08 11:43:02 ==> Parameters: aaaa(String), mybatis保存(String), Y(String), Y(String)mybatis更新测试:=================================2012-02-08 11:43:02 ==> Executing: update EASSEN.DM_MYDWT set MYDWT_MC = ?, YXBZ = ?, XYBZ = ? where MYDWT_DM = ? 2012-02-08 11:43:02 ==> Parameters: mybatis保存(String), Y(String), Y(String), aaaa(String)mybatis删除测试:=================================2012-02-08 11:43:02 ==> Executing: delete from EASSEN.DM_MYDWT where MYDWT_DM = ? 2012-02-08 11:43:02 ==> Parameters: 1001(String)2012-02-08 11:43:02 xxx Connection Closed2012-02-08 11:43:02 Returned connection 17671659 to pool.