《MyBatis+Spring整合示例》.docVIP

MyBatis+Spring整合示例 说明： 1，:?/409430/515132。 由于目前Spring官方还没有出整合Mybatis的特性，所以这里在Spring框架和MyBatis框架上再添加用于整合的框架“mybatis-spring-1.0.0.jar”(该框架时MyBatis官方自己出的)。 这里同样以持久化一个User bean为示例，这里不在详述每个文件的意义。 建表代码如下： create?table?pda2_user(? ???????id?varchar2(50)?primary?key,? ???????name?varchar2(100)?not?null,? ???????psw??varchar2(100)?not?null? );? ######################################? create?sequence?pda2_user_sequence? minvalue?1? maxvalue?999999999999999999999999999? start?with?1? increment?by?1? cache?20;? #####################################? create?trigger?id_auto_increment_triger? ??before?insert?on?pda2_user? ??for?each?row? ??when?(new.id?is?null)? begin? ??select?pda2_user_sequence.nextval?into?:new.id?from?dual;? end;? ? ###################################################? ? insert?into?pad2_user?(name,psw)?values(chenjun,123)? ? ####说明######? ? 我使用的是Oracle数据库，为了使用主键自增长的方式，特此建立一个使用sequence的触发器? ? User bean代码如下： package?com.deppon.pda.v2.model.basic.User;? ?? public?class?User?{? ????private?String?ID;? ????private?String?name;? ????private?String?psw;? ???? ????public?User()?{? ???????super();? ????}? ?? ????public?User(String?name,?String?psw)?{? ???????super();? ????????=?name;? ???????this.psw?=?psw;? ????}? ?? ????public?String?getID()?{? ???????return?ID;? ????}? ?? ????public?void?setID(String?iD)?{? ???????ID?=?iD;? ????}? ?? ????public?String?getName()?{? ???????return?name;? ????}? ?? ????public?void?setName(String?name)?{? ????????=?name;? ????}? ?? ????public?String?getPsw()?{? ???????return?psw;? ????}? ?? ????public?void?setPsw(String?psw)?{? ???????this.psw?=?psw;? ????}? }? User实体对应的映射器UserMapper代码如下： package?com.deppon.pda.v2.mapper.User;? ?? import?com.deppon.pda.v2.model.basic.User.User;? ?? public?interface?UserMapper?{? ????public?void?insertUser(User?user);? ????public?User?getUser(String?name);? }? 映射器配置文件UserMapper.xml代码如下： ?xml?version=1.0?encoding=UTF-8??? !DOCTYPE?mapper? ????PUBLIC?-////DTD?Mapper?3.0//EN? ????/dtd/mybatis-3-mapper.dtd? ?