使用iBATIS3.0完成增删改查、 使用iBATIS3.0注解完成对数据库的简单操作

于 2012-07-02 16:39:00 发布
阅读量107 收藏
点赞数
文章标签： 数据库 java 开发工具

使用iBATIS3.0完成增删改查

iBATIS3.0和以前的版本有一些改变，不过学过以前版本的再学习3.0应该不是太难，3.0要求JDK1.5支持，因为其中增加了注解和泛型，这些都是JDK1.5才有的。好了废话不多说，先来利用iBATIS3做下简单的增删改查吧。

首先到Apache(http://www.apache.org/)网站下载iBATIS3的jar 包，我下载的是ibatis-3-core-3.0.0.227.zip，解压后吧那个jar文件（ibatis-3-core-3.0.0.227.jar）添加到工程就可以了，还有一个文件（ibatis-3-core-src-3.0.0.227.zip）是源代码，可以用来查看源代码的，使用eclipse可以用它来关联源代码。

在MyEclipse新建一个Java Project，结构如下图

在jdbc.properties文件是映射文件要使用的，其内容如下：

Properties代码 收藏代码
  1. driver=com.mysql.jdbc.Driver
  2. url=jdbc\:mysql\://localhost\:3306/test
  3. username=root
  4. password=123456
driver=com.mysql.jdbc.Driver url=jdbc\:mysql\://localhost\:3306/test username=root password=123456

SqlMapper.xml是iBATIS的配置文件，其代码如下：

Xml代码 收藏代码
  1. <?xmlversion="1.0"encoding="UTF-8"?>
  2. <!DOCTYPEconfiguration
  3. PUBLIC"-//ibatis.apache.org//DTDConfig3.0//EN"
  4. "http://ibatis.apache.org/dtd/ibatis-3-config.dtd">
  5. <configuration>
  6. <propertiesresource="jdbc.properties"/>
  7. <typeAliases>
  8. <typeAliastype="cn.ibatis3.test.Person"alias="Person"/>
  9. </typeAliases>
  10. <environmentsdefault="development">
  11. <environmentid="development">
  12. <transactionManagertype="JDBC"/>
  13. <dataSourcetype="POOLED">
  14. <propertyname="driver"value="${driver}"/>
  15. <propertyname="url"value="${url}"/>
  16. <propertyname="username"value="${username}"/>
  17. <propertyname="password"value="${password}"/>
  18. </dataSource>
  19. </environment>
  20. </environments>
  21. <mappers>
  22. <mapperresource="cn/ibatis3/test/person.xml"/>
  23. </mappers>
  24. </configuration>
[xml] view plain copy print ?
  1. <?xmlversion="1.0"encoding="UTF-8"?>
  2. <!DOCTYPEconfiguration
  3. PUBLIC"-//ibatis.apache.org//DTDConfig3.0//EN"
  4. "http://ibatis.apache.org/dtd/ibatis-3-config.dtd">
  5. <configuration>
  6. <propertiesresource="jdbc.properties"/>
  7. <typeAliases>
  8. <typeAliastype="cn.ibatis3.test.Person"alias="Person"/>
  9. </typeAliases>
  10. <environmentsdefault="development">
  11. <environmentid="development">
  12. <transactionManagertype="JDBC"/>
  13. <dataSourcetype="POOLED">
  14. <propertyname="driver"value="${driver}"/>
  15. <propertyname="url"value="${url}"/>
  16. <propertyname="username"value="${username}"/>
  17. <propertyname="password"value="${password}"/>
  18. </dataSource>
  19. </environment>
  20. </environments>
  21. <mappers>
  22. <mapperresource="cn/ibatis3/test/person.xml"/>
  23. </mappers>
  24. </configuration>
<?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="jdbc.properties"/> <typeAliases> <typeAlias type="cn.ibatis3.test.Person" alias="Person"/> </typeAliases> <environments default="development"> <environment id="development"> <transactionManager type="JDBC"/> <dataSource type="POOLED"> <property name="driver" value="${driver}"/> <property name="url" value="${url}"/> <property name="username" value="${username}"/> <property name="password" value="${password}"/> </dataSource> </environment> </environments> <mappers> <mapper resource="cn/ibatis3/test/person.xml"/> </mappers> </configuration>

上面文件中的sql映射文件person.xml代码如下：

Xml代码 收藏代码
  1. <?xmlversion="1.0"encoding="UTF-8"?>
  2. <!DOCTYPEmapper
  3. PUBLIC"-//ibatis.apache.org//DTDMapper3.0//EN"
  4. "http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd">
  5. <!---->
  7. <mappernamespace="cn.ibatis3.test.PersonMapper">
  9. <selectid="selectPerson"parameterType="java.lang.Integer"
  10. resultType="Person">
  11. select*frompersonwhereid=#{id}
  12. </select>
  13. <selectid="selectAll"resultType="Person">
  14. select*fromperson
  15. </select>
  16. <selectid="selectPersonsByName"resultType="Person"parameterType="String">
  17. select*frompersonwherenamelike#{name}
  18. </select>
  19. <insertid="insertPerson"parameterType="Person">
  20. insertintoperson(name,birthday,sex)
  21. values(#{name},#{birthday},#{sex})
  22. </insert>
  23. <deleteid="deletePerson"parameterType="Person">
  24. deletefrompersonwhereid=#{id}
  25. </delete>
  26. <updateid="updatePerson"parameterType="Person">
  27. updatepersonsetname=#{name},birthday=#{birthday},sex=#{sex}
  28. whereid=#{id}
  29. </update>
  30. </mapper>
[xml] view plain copy print ?
  1. <?xmlversion="1.0"encoding="UTF-8"?>
  2. <!DOCTYPEmapper
  3. PUBLIC"-//ibatis.apache.org//DTDMapper3.0//EN"
  4. "http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd">
  5. <!---->
  7. <mappernamespace="cn.ibatis3.test.PersonMapper">
  9. <selectid="selectPerson"parameterType="java.lang.Integer"
  10. resultType="Person">
  11. select*frompersonwhereid=#{id}
  12. </select>
  13. <selectid="selectAll"resultType="Person">
  14. select*fromperson
  15. </select>
  16. <selectid="selectPersonsByName"resultType="Person"parameterType="String">
  17. select*frompersonwherenamelike#{name}
  18. </select>
  19. <insertid="insertPerson"parameterType="Person">
  20. insertintoperson(name,birthday,sex)
  21. values(#{name},#{birthday},#{sex})
  22. </insert>
  23. <deleteid="deletePerson"parameterType="Person">
  24. deletefrompersonwhereid=#{id}
  25. </delete>
  26. <updateid="updatePerson"parameterType="Person">
  27. updatepersonsetname=#{name},birthday=#{birthday},sex=#{sex}
  28. whereid=#{id}
  29. </update>
  30. </mapper>
<?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="cn.ibatis3.test.PersonMapper"> <select id="selectPerson" parameterType="java.lang.Integer" resultType="Person"> select * from person where id = #{id} </select> <select id="selectAll" resultType="Person"> select * from person </select> <select id="selectPersonsByName" resultType="Person" parameterType="String"> select * from person where name like #{name} </select> <insert id="insertPerson" parameterType="Person"> insert into person(name,birthday,sex) values(#{name},#{birthday},#{sex}) </insert> <delete id="deletePerson" parameterType="Person"> delete from person where id=#{id} </delete> <update id="updatePerson" parameterType="Person"> update person set name=#{name},birthday=#{birthday},sex=#{sex} where id=#{id} </update> </mapper>

注意：在iBATIS3中，属性parameterMap是不推荐使用的，在以后的版本可能会去掉这个属性。

Person.java的代码如下：

Java代码 收藏代码
  1. packagecn.ibatis3.test;
  3. importjava.util.Date;
  5. publicclassPerson{
  6. privateintid=0;
  7. privateStringname="";
  8. privateStringsex="male";
  9. privateDatebirthday=null;
  11. publicPerson(){
  13. }
  15. //省略getter和setter方法
  17. @Override
  18. publicStringtoString(){
  19. return"id="+id+"\t"+"name="+name+"\t"+"sex="+sex+"\t"
  20. +"birthday="+newjava.sql.Date(birthday.getTime()).toString();
  21. }
  23. }
[java] view plain copy print ?
  1. packagecn.ibatis3.test;
  3. importjava.util.Date;
  5. publicclassPerson{
  6. privateintid=0;
  7. privateStringname="";
  8. privateStringsex="male";
  9. privateDatebirthday=null;
  11. publicPerson(){
  13. }
  15. //省略getter和setter方法
  17. @Override
  18. publicStringtoString(){
  19. return"id="+id+"\t"+"name="+name+"\t"+"sex="+sex+"\t"
  20. +"birthday="+newjava.sql.Date(birthday.getTime()).toString();
  21. }
  23. }
package cn.ibatis3.test; import java.util.Date; public class Person { private int id = 0; private String name = ""; private String sex = "male"; private Date birthday = null; public Person() { } //省略getter 和 setter 方法 @Override public String toString() { return "id=" + id + "\t" + "name=" + name + "\t" + "sex=" + sex + "\t" + "birthday=" + new java.sql.Date(birthday.getTime()).toString(); } }

iBATIS官方推荐我们使用单例模式创建一个sessionFactory，我这里也提供一个sessionFactory.java，呵呵,仅供参考：

Java代码 收藏代码
  1. packagecn.ibatis3.test;
  3. importjava.io.IOException;
  4. importjava.io.Reader;
  6. importorg.apache.ibatis.io.Resources;
  7. importorg.apache.ibatis.session.SqlSessionFactory;
  8. importorg.apache.ibatis.session.SqlSessionFactoryBuilder;
  10. publicfinalclassSessionFactory{
  11. privateStringresource="cn/ibatis3/test/SqlMapper.xml";
  12. privateSqlSessionFactorysqlSessionFactory=null;
  13. privatestaticSessionFactorysessionFactory=newSessionFactory();
  15. privateSessionFactory(){
  16. try{
  17. Readerreader=Resources.getResourceAsReader(resource);
  18. sqlSessionFactory=newSqlSessionFactoryBuilder().build(reader);
  19. }catch(IOExceptione){
  20. System.out.println("#IOExceptionhappenedininitialisingtheSessionFactory:"+e.getMessage());
  21. thrownewExceptionInInitializerError(e);
  22. }
  23. }
  24. publicstaticSessionFactorygetInstance(){
  25. returnsessionFactory;
  26. }
  27. publicSqlSessionFactorygetSqlSessionFactory(){
  28. returnsqlSessionFactory;
  29. }
  31. }
[java] view plain copy print ?
  1. packagecn.ibatis3.test;
  3. importjava.io.IOException;
  4. importjava.io.Reader;
  6. importorg.apache.ibatis.io.Resources;
  7. importorg.apache.ibatis.session.SqlSessionFactory;
  8. importorg.apache.ibatis.session.SqlSessionFactoryBuilder;
  10. publicfinalclassSessionFactory{
  11. privateStringresource="cn/ibatis3/test/SqlMapper.xml";
  12. privateSqlSessionFactorysqlSessionFactory=null;
  13. privatestaticSessionFactorysessionFactory=newSessionFactory();
  15. privateSessionFactory(){
  16. try{
  17. Readerreader=Resources.getResourceAsReader(resource);
  18. sqlSessionFactory=newSqlSessionFactoryBuilder().build(reader);
  19. }catch(IOExceptione){
  20. System.out.println("#IOExceptionhappenedininitialisingtheSessionFactory:"+e.getMessage());
  21. thrownewExceptionInInitializerError(e);
  22. }
  23. }
  24. publicstaticSessionFactorygetInstance(){
  25. returnsessionFactory;
  26. }
  27. publicSqlSessionFactorygetSqlSessionFactory(){
  28. returnsqlSessionFactory;
  29. }
  31. }
package cn.ibatis3.test; import java.io.IOException; import java.io.Reader; import org.apache.ibatis.io.Resources; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.SqlSessionFactoryBuilder; public final class SessionFactory { private String resource="cn/ibatis3/test/SqlMapper.xml"; private SqlSessionFactory sqlSessionFactory=null; private static SessionFactory sessionFactory=new SessionFactory(); private SessionFactory() { try { Reader reader=Resources.getResourceAsReader(resource); sqlSessionFactory=new SqlSessionFactoryBuilder().build(reader); } catch (IOException e) { System.out.println("#IOException happened in initialising the SessionFactory:"+e.getMessage()); throw new ExceptionInInitializerError(e); } } public static SessionFactory getInstance() { return sessionFactory; } public SqlSessionFactory getSqlSessionFactory() { return sqlSessionFactory; } }

基于接口的编程（还有就是iBATIS3的注解也是在接口方法上的，关于注解以后有机会再讲，它也是iBATIS3的一个新特性），DAO层的接口PersonMapper.java代码如下：

Java代码 收藏代码
  1. packagecn.ibatis3.test;
  3. importjava.util.List;
  5. publicinterfacePersonMapper{
  6. PersonselectById(Integerid);
  7. List<Person>selectAll();
  8. List<Person>selectPersonsByName(Stringname);
  9. voidinsert(Personperson);
  10. voiddelete(Personperson);
  11. voidupdate(Personperson);
  13. }
[java] view plain copy print ?
  1. packagecn.ibatis3.test;
  3. importjava.util.List;
  5. publicinterfacePersonMapper{
  6. PersonselectById(Integerid);
  7. List<Person>selectAll();
  8. List<Person>selectPersonsByName(Stringname);
  9. voidinsert(Personperson);
  10. voiddelete(Personperson);
  11. voidupdate(Personperson);
  13. }
package cn.ibatis3.test; import java.util.List; public interface PersonMapper { Person selectById(Integer id); List<Person> selectAll(); List<Person> selectPersonsByName(String name); void insert(Person person); void delete(Person person); void update(Person person); }

接口的实现类PersonDao.java代码如下：

Java代码 收藏代码
  1. packagecn.ibatis3.test;
  3. importjava.util.ArrayList;
  4. importjava.util.List;
  6. importorg.apache.ibatis.session.SqlSession;
  7. importorg.apache.ibatis.session.SqlSessionFactory;
  9. publicclassPersonDaoimplementsPersonMapper{
  10. privateSqlSessionFactorysessionFactory=SessionFactory.getInstance()
  11. .getSqlSessionFactory();
  13. publicPersonselectById(Integerid){
  14. Personperson=newPerson();
  15. SqlSessionsession=null;
  16. try{
  17. session=sessionFactory.openSession();
  18. person=(Person)session.selectOne(
  19. "cn.ibatis3.test.PersonMapper.selectPerson",id);
  20. }finally{
  21. session.close();
  22. }
  23. returnperson;
  24. }
  26. @SuppressWarnings("unchecked")
  27. publicList<Person>selectAll(){
  28. List<Person>persons=newArrayList<Person>();
  29. SqlSessionsession=null;
  30. try{
  31. session=sessionFactory.openSession();
  32. persons=session
  33. .selectList("cn.ibatis3.test.PersonMapper.selectAll");
  34. }finally{
  35. session.close();
  36. }
  38. returnpersons;
  39. }
  41. publicvoiddelete(Personperson){
  42. SqlSessionsession=null;
  43. try{
  44. session=sessionFactory.openSession();
  45. session.delete("cn.ibatis3.test.PersonMapper.deletePerson",person);
  46. session.commit();
  47. }finally{
  48. session.close();
  49. }
  51. }
  53. publicvoidinsert(Personperson){
  54. SqlSessionsession=null;
  55. try{
  56. session=sessionFactory.openSession();
  57. session.insert("cn.ibatis3.test.PersonMapper.insertPerson",person);
  58. session.commit();
  59. }finally{
  60. session.close();
  61. }
  63. }
  65. publicvoidupdate(Personperson){
  66. SqlSessionsession=null;
  67. try{
  68. session=sessionFactory.openSession();
  69. session.insert("cn.ibatis3.test.PersonMapper.updatePerson",person);
  70. session.commit();
  71. }finally{
  72. session.close();
  73. }
  75. }
  77. @SuppressWarnings("unchecked")
  78. publicList<Person>selectPersonsByName(Stringname){
  79. List<Person>persons=newArrayList<Person>();
  80. SqlSessionsession=null;
  81. try{
  82. session=sessionFactory.openSession();
  83. System.out.println(name);
  84. persons=session.selectList(
  85. "cn.ibatis3.test.PersonMapper.selectPersonsByName","%"
  86. +name+"%");
  87. session.commit();
  88. }finally{
  89. session.close();
  90. }
  92. returnpersons;
  93. }
  95. }
[java] view plain copy print ?
  1. packagecn.ibatis3.test;
  3. importjava.util.ArrayList;
  4. importjava.util.List;
  6. importorg.apache.ibatis.session.SqlSession;
  7. importorg.apache.ibatis.session.SqlSessionFactory;
  9. publicclassPersonDaoimplementsPersonMapper{
  10. privateSqlSessionFactorysessionFactory=SessionFactory.getInstance()
  11. .getSqlSessionFactory();
  13. publicPersonselectById(Integerid){
  14. Personperson=newPerson();
  15. SqlSessionsession=null;
  16. try{
  17. session=sessionFactory.openSession();
  18. person=(Person)session.selectOne(
  19. "cn.ibatis3.test.PersonMapper.selectPerson",id);
  20. }finally{
  21. session.close();
  22. }
  23. returnperson;
  24. }
  26. @SuppressWarnings("unchecked")
  27. publicList<Person>selectAll(){
  28. List<Person>persons=newArrayList<Person>();
  29. SqlSessionsession=null;
  30. try{
  31. session=sessionFactory.openSession();
  32. persons=session
  33. .selectList("cn.ibatis3.test.PersonMapper.selectAll");
  34. }finally{
  35. session.close();
  36. }
  38. returnpersons;
  39. }
  41. publicvoiddelete(Personperson){
  42. SqlSessionsession=null;
  43. try{
  44. session=sessionFactory.openSession();
  45. session.delete("cn.ibatis3.test.PersonMapper.deletePerson",person);
  46. session.commit();
  47. }finally{
  48. session.close();
  49. }
  51. }
  53. publicvoidinsert(Personperson){
  54. SqlSessionsession=null;
  55. try{
  56. session=sessionFactory.openSession();
  57. session.insert("cn.ibatis3.test.PersonMapper.insertPerson",person);
  58. session.commit();
  59. }finally{
  60. session.close();
  61. }
  63. }
  65. publicvoidupdate(Personperson){
  66. SqlSessionsession=null;
  67. try{
  68. session=sessionFactory.openSession();
  69. session.insert("cn.ibatis3.test.PersonMapper.updatePerson",person);
  70. session.commit();
  71. }finally{
  72. session.close();
  73. }
  75. }
  77. @SuppressWarnings("unchecked")
  78. publicList<Person>selectPersonsByName(Stringname){
  79. List<Person>persons=newArrayList<Person>();
  80. SqlSessionsession=null;
  81. try{
  82. session=sessionFactory.openSession();
  83. System.out.println(name);
  84. persons=session.selectList(
  85. "cn.ibatis3.test.PersonMapper.selectPersonsByName","%"
  86. +name+"%");
  87. session.commit();
  88. }finally{
  89. session.close();
  90. }
  92. returnpersons;
  93. }
  95. }
package cn.ibatis3.test; import java.util.ArrayList; import java.util.List; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; public class PersonDao implements PersonMapper { private SqlSessionFactory sessionFactory = SessionFactory.getInstance() .getSqlSessionFactory(); public Person selectById(Integer id) { Person person = new Person(); SqlSession session = null; try { session = sessionFactory.openSession(); person = (Person) session.selectOne( "cn.ibatis3.test.PersonMapper.selectPerson", id); } finally { session.close(); } return person; } @SuppressWarnings("unchecked") public List<Person> selectAll() { List<Person> persons = new ArrayList<Person>(); SqlSession session = null; try { session = sessionFactory.openSession(); persons = session .selectList("cn.ibatis3.test.PersonMapper.selectAll"); } finally { session.close(); } return persons; } public void delete(Person person) { SqlSession session = null; try { session = sessionFactory.openSession(); session.delete("cn.ibatis3.test.PersonMapper.deletePerson", person); session.commit(); } finally { session.close(); } } public void insert(Person person) { SqlSession session = null; try { session = sessionFactory.openSession(); session.insert("cn.ibatis3.test.PersonMapper.insertPerson", person); session.commit(); } finally { session.close(); } } public void update(Person person) { SqlSession session = null; try { session = sessionFactory.openSession(); session.insert("cn.ibatis3.test.PersonMapper.updatePerson", person); session.commit(); } finally { session.close(); } } @SuppressWarnings("unchecked") public List<Person> selectPersonsByName(String name) { List<Person> persons = new ArrayList<Person>(); SqlSession session = null; try { session = sessionFactory.openSession(); System.out.println(name); persons = session.selectList( "cn.ibatis3.test.PersonMapper.selectPersonsByName", "%" + name + "%"); session.commit(); } finally { session.close(); } return persons; } }

最后是表的创建：

Sql代码 收藏代码
  1. DROPTABLEIFEXISTS`test`.`person`;
  2. CREATETABLE`test`.`person`(
  3. `id`int(10)unsignedNOTNULLauto_increment,
  4. `name`varchar(20)defaultNULL,
  5. `sex`varchar(8)defaultNULL,
  6. `birthday`datetimedefaultNULL,
  7. PRIMARYKEY(`id`)
  8. )ENGINE=InnoDBDEFAULTCHARSET=utf8;
[sql] view plain copy print ?
  1. DROPTABLEIFEXISTS`test`.`person`;
  2. CREATETABLE`test`.`person`(
  3. `id`int(10)unsignedNOTNULLauto_increment,
  4. `name`varchar(20)defaultNULL,
  5. `sex`varchar(8)defaultNULL,
  6. `birthday`datetimedefaultNULL,
  7. PRIMARYKEY(`id`)
  8. )ENGINE=InnoDBDEFAULTCHARSET=utf8;
DROP TABLE IF EXISTS `test`.`person`; CREATE TABLE `test`.`person` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(20) default NULL, `sex` varchar(8) default NULL, `birthday` datetime default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

使用iBATIS3.0注解完成对数据库的简单操作

iBATIS3.0也增加了一些简单的注解，iBATIS3的注解只能完成一些简单操作，要进行更复杂的操作，最好是在XML文件中配置。

在数据库(本人使用的mysql)中建立一个person表：

Sql代码 收藏代码
  1. DROPTABLEIFEXISTS`test`.`person`;
  2. CREATETABLE`test`.`person`(
  3. `id`int(10)unsignedNOTNULLauto_increment,
  4. `name`varchar(20)defaultNULL,
  5. `sex`varchar(8)defaultNULL,
  6. `birthday`datetimedefaultNULL,
  7. PRIMARYKEY(`id`)
  8. )ENGINE=InnoDBDEFAULTCHARSET=utf8;
[sql] view plain copy print ?
  1. DROPTABLEIFEXISTS`test`.`person`;
  2. CREATETABLE`test`.`person`(
  3. `id`int(10)unsignedNOTNULLauto_increment,
  4. `name`varchar(20)defaultNULL,
  5. `sex`varchar(8)defaultNULL,
  6. `birthday`datetimedefaultNULL,
  7. PRIMARYKEY(`id`)
  8. )ENGINE=InnoDBDEFAULTCHARSET=utf8;
DROP TABLE IF EXISTS `test`.`person`; CREATE TABLE `test`.`person` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(20) default NULL, `sex` varchar(8) default NULL, `birthday` datetime default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

在MyEclipse新建一个Java Project，结构如下图



在jdbc.properties文件是映射文件要使用的，其内容如下：

Properties代码 收藏代码
  1. driver=com.mysql.jdbc.Driver
  2. url=jdbc\:mysql\://localhost\:3306/test
  3. username=root
  4. password=123456
driver=com.mysql.jdbc.Driver url=jdbc\:mysql\://localhost\:3306/test username=root password=123456

SqlMapper.xml是iBATIS的配置文件，其代码如下：

Xml代码 收藏代码
  1. <?xmlversion="1.0"encoding="UTF-8"?>
  2. <!DOCTYPEconfiguration
  3. PUBLIC"-//ibatis.apache.org//DTDConfig3.0//EN"
  4. "http://ibatis.apache.org/dtd/ibatis-3-config.dtd">
  5. <configuration>
  6. <propertiesresource="jdbc.properties"/>
  7. <environmentsdefault="development">
  8. <environmentid="development">
  9. <transactionManagertype="JDBC"/>
  10. <dataSourcetype="POOLED">
  11. <propertyname="driver"value="${driver}"/>
  12. <propertyname="url"value="${url}"/>
  13. <propertyname="username"value="${username}"/>
  14. <propertyname="password"value="${password}"/>
  15. </dataSource>
  16. </environment>
  17. </environments>
  18. <mappers>
  19. <mapperresource="cn/ibatis3/test/annotation/person.xml"/>
  20. </mappers>
  21. </configuration>
[xml] view plain copy print ?
  1. <?xmlversion="1.0"encoding="UTF-8"?>
  2. <!DOCTYPEconfiguration
  3. PUBLIC"-//ibatis.apache.org//DTDConfig3.0//EN"
  4. "http://ibatis.apache.org/dtd/ibatis-3-config.dtd">
  5. <configuration>
  6. <propertiesresource="jdbc.properties"/>
  7. <environmentsdefault="development">
  8. <environmentid="development">
  9. <transactionManagertype="JDBC"/>
  10. <dataSourcetype="POOLED">
  11. <propertyname="driver"value="${driver}"/>
  12. <propertyname="url"value="${url}"/>
  13. <propertyname="username"value="${username}"/>
  14. <propertyname="password"value="${password}"/>
  15. </dataSource>
  16. </environment>
  17. </environments>
  18. <mappers>
  19. <mapperresource="cn/ibatis3/test/annotation/person.xml"/>
  20. </mappers>
  21. </configuration>
<?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="jdbc.properties"/> <environments default="development"> <environment id="development"> <transactionManager type="JDBC"/> <dataSource type="POOLED"> <property name="driver" value="${driver}"/> <property name="url" value="${url}"/> <property name="username" value="${username}"/> <property name="password" value="${password}"/> </dataSource> </environment> </environments> <mappers> <mapper resource="cn/ibatis3/test/annotation/person.xml"/> </mappers> </configuration>

上面文件中的sql映射文件person.xml代码如下：

Xml代码 收藏代码
  1. <?xmlversion="1.0"encoding="UTF-8"?>
  2. <!DOCTYPEmapper
  3. PUBLIC"-//ibatis.apache.org//DTDMapper3.0//EN"
  4. "http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd">
  5. <mappernamespace="cn.ibatis3.test.annotation.PersonMapper">
  7. </mapper>
[xml] view plain copy print ?
  1. <?xmlversion="1.0"encoding="UTF-8"?>
  2. <!DOCTYPEmapper
  3. PUBLIC"-//ibatis.apache.org//DTDMapper3.0//EN"
  4. "http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd">
  5. <mappernamespace="cn.ibatis3.test.annotation.PersonMapper">
  7. </mapper>
<?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="cn.ibatis3.test.annotation.PersonMapper"> </mapper>

注意：在iBATIS3中，命名空间（namespace）是必须的，如果不使用注解的话，名字可以自己定义。一旦使用了注解，这里必须是那个使用注解类或接口的全名。

Person.java的代码请参考我的《iBATIS3学习（一）》。

sessionFactory.java和我前面的《iBATIS3学习（一）》一样，只是注意将：

Java代码 收藏代码
  1. privateStringresource="cn/ibatis3/test/SqlMapper.xml";
[java] view plain copy print ?
  1. privateStringresource="cn/ibatis3/test/SqlMapper.xml";
private String resource="cn/ibatis3/test/SqlMapper.xml";
Java代码 收藏代码
  1. 改为privateStringresource="cn/ibatis3/test/annotation/SqlMapper.xml";
[java] view plain copy print ?
  1. 改为privateStringresource="cn/ibatis3/test/annotation/SqlMapper.xml";
改为private String resource="cn/ibatis3/test/annotation/SqlMapper.xml";

iBATIS3的注解可以定义在接口方法上的，也可以定义在类方法上，我这里定义在接口上，接口PersonMapper.java代码如下：

Java代码 收藏代码
  1. packagecn.ibatis3.test.annotation;
  3. importjava.util.List;
  5. importorg.apache.ibatis.annotations.CacheNamespace;
  6. importorg.apache.ibatis.annotations.Delete;
  7. importorg.apache.ibatis.annotations.Insert;
  8. importorg.apache.ibatis.annotations.Options;
  9. importorg.apache.ibatis.annotations.Select;
  10. importorg.apache.ibatis.annotations.SelectProvider;
  11. importorg.apache.ibatis.annotations.Update;
  13. @CacheNamespace(readWrite=true)
  14. publicinterfacePersonMapper{
  15. @Select("select*frompersonwhereid=#{id}")
  16. @Options(useCache=true,flushCache=false)
  17. PersonselectById(Integerid);
  19. @SelectProvider(type=SqlProvider.class,method="selectAllSql")
  20. List<Person>selectAll();
  22. @Select("select*frompersonwherenamelike#{name}")
  23. List<Person>selectPersonsByName(Stringname);
  25. @Insert({"insertintoperson(name,birthday,sex)",
  26. "values(#{name},#{birthday},#{sex})"})
  27. voidinsert(Personperson);
  29. @Delete("deletefrompersonwhereid=#{id}")
  30. voiddelete(Personperson);
  32. @Update({"updatepersonsetname=#{name},birthday=#{birthday},sex=#{sex}",
  33. "whereid=#{id}"})
  34. voidupdate(Personperson);
  36. }
[java] view plain copy print ?
  1. packagecn.ibatis3.test.annotation;
  3. importjava.util.List;
  5. importorg.apache.ibatis.annotations.CacheNamespace;
  6. importorg.apache.ibatis.annotations.Delete;
  7. importorg.apache.ibatis.annotations.Insert;
  8. importorg.apache.ibatis.annotations.Options;
  9. importorg.apache.ibatis.annotations.Select;
  10. importorg.apache.ibatis.annotations.SelectProvider;
  11. importorg.apache.ibatis.annotations.Update;
  13. @CacheNamespace(readWrite=true)
  14. publicinterfacePersonMapper{
  15. @Select("select*frompersonwhereid=#{id}")
  16. @Options(useCache=true,flushCache=false)
  17. PersonselectById(Integerid);
  19. @SelectProvider(type=SqlProvider.class,method="selectAllSql")
  20. List<Person>selectAll();
  22. @Select("select*frompersonwherenamelike#{name}")
  23. List<Person>selectPersonsByName(Stringname);
  25. @Insert({"insertintoperson(name,birthday,sex)",
  26. "values(#{name},#{birthday},#{sex})"})
  27. voidinsert(Personperson);
  29. @Delete("deletefrompersonwhereid=#{id}")
  30. voiddelete(Personperson);
  32. @Update({"updatepersonsetname=#{name},birthday=#{birthday},sex=#{sex}",
  33. "whereid=#{id}"})
  34. voidupdate(Personperson);
  36. }
package cn.ibatis3.test.annotation; import java.util.List; import org.apache.ibatis.annotations.CacheNamespace; import org.apache.ibatis.annotations.Delete; import org.apache.ibatis.annotations.Insert; import org.apache.ibatis.annotations.Options; import org.apache.ibatis.annotations.Select; import org.apache.ibatis.annotations.SelectProvider; import org.apache.ibatis.annotations.Update; @CacheNamespace(readWrite = true) public interface PersonMapper { @Select("select * from person where id = #{id}") @Options(useCache = true, flushCache = false) Person selectById(Integer id); @SelectProvider(type=SqlProvider.class ,method="selectAllSql") List<Person> selectAll(); @Select("select * from person where name like #{name}") List<Person> selectPersonsByName(String name); @Insert( { "insert into person(name,birthday,sex)", "values(#{name},#{birthday},#{sex})" }) void insert(Person person); @Delete("delete from person where id=#{id}") void delete(Person person); @Update( {"update person set name=#{name},birthday=#{birthday},sex=#{sex}", "where id=#{id}" }) void update(Person person); }

上面的注解SelectProvider使用了一个类SqlProvider.java,其代码如下：

Java代码 收藏代码
  1. packagecn.ibatis3.test.annotation;
  3. publicclassSqlProvider{
  4. //动态的SQL语句，实际上应该使用iBATIS的动态SQL产生方法，这里仅仅是为了使用注解
  5. publicStringselectAllSql(){
  6. return"SELECT*FROMpersonp";
  7. }
  8. }
[java] view plain copy print ?
  1. packagecn.ibatis3.test.annotation;
  3. publicclassSqlProvider{
  4. //动态的SQL语句，实际上应该使用iBATIS的动态SQL产生方法，这里仅仅是为了使用注解
  5. publicStringselectAllSql(){
  6. return"SELECT*FROMpersonp";
  7. }
  8. }
package cn.ibatis3.test.annotation; public class SqlProvider { // 动态的SQL语句，实际上应该使用iBATIS的动态SQL产生方法，这里仅仅是为了使用注解 public String selectAllSql() { return "SELECT * FROM person p"; } }

接口的实现类PersonDao.java代码如下：

Java代码 收藏代码
  1. packagecn.ibatis3.test.annotation;
  3. importjava.util.ArrayList;
  4. importjava.util.List;
  6. importorg.apache.ibatis.session.SqlSession;
  7. importorg.apache.ibatis.session.SqlSessionFactory;
  9. publicclassPersonDaoimplementsPersonMapper{
  10. privateSqlSessionFactorysessionFactory=SessionFactory.getInstance()
  11. .getSqlSessionFactory();
  13. publicPersonselectById(Integerid){
  14. Personperson=newPerson();
  15. SqlSessionsession=null;
  16. try{
  17. session=sessionFactory.openSession();
  18. PersonMapperpersonMapper=session.getMapper(PersonMapper.class);
  19. person=personMapper.selectById(id);
  20. }finally{
  21. session.close();
  22. }
  23. returnperson;
  24. }
  26. @SuppressWarnings("unchecked")
  27. publicList<Person>selectAll(){
  28. List<Person>persons=newArrayList<Person>();
  29. SqlSessionsession=null;
  30. try{
  31. session=sessionFactory.openSession();
  32. PersonMapperpersonMapper=session.getMapper(PersonMapper.class);
  33. persons=personMapper.selectAll();
  34. }finally{
  35. session.close();
  36. }
  38. returnpersons;
  39. }
  41. publicvoiddelete(Personperson){
  42. SqlSessionsession=null;
  43. try{
  44. session=sessionFactory.openSession();
  45. PersonMapperpersonMapper=session.getMapper(PersonMapper.class);
  46. personMapper.delete(person);
  47. session.commit();
  48. }finally{
  49. session.close();
  50. }
  52. }
  54. publicvoidinsert(Personperson){
  55. SqlSessionsession=null;
  56. try{
  57. session=sessionFactory.openSession();
  58. PersonMapperpersonMapper=session.getMapper(PersonMapper.class);
  59. personMapper.insert(person);
  60. session.commit();
  61. }finally{
  62. session.close();
  63. }
  65. }
  67. publicvoidupdate(Personperson){
  68. SqlSessionsession=null;
  69. try{
  70. session=sessionFactory.openSession();
  71. PersonMapperpersonMapper=session.getMapper(PersonMapper.class);
  72. personMapper.update(person);
  73. session.commit();
  74. }finally{
  75. session.close();
  76. }
  78. }
  80. @SuppressWarnings("unchecked")
  81. publicList<Person>selectPersonsByName(Stringname){
  82. List<Person>persons=newArrayList<Person>();
  83. SqlSessionsession=null;
  84. try{
  85. session=sessionFactory.openSession();
  86. PersonMapperpersonMapper=session.getMapper(PersonMapper.class);
  87. persons=personMapper.selectPersonsByName("%"+name+"%");
  88. }finally{
  89. session.close();
  90. }
  92. returnpersons;
  93. }
  95. }

iteye_19603
关注
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值