MyBatis+Spring整合示例
MyBatis+Spring整合示例
说明:
1、由于目前Spring官方还没有出整合Mybatis的特性,所以这里在Spring框架和MyBatis框架上再添加用于整合的框架“mybatis-spring-1.0.0.jar”(该框架时MyBatis官方自己出的)。
2、这里同样以持久化一个User bean为示例,这里不在详述每个文件的意义,可参考上一篇日志:
Java实战应用:Mybatis实现单表的增删改
[Java][Mybatis]物理分页实现
Mybatis快速入门教程
Mybatis的关于批量数据操作的测试
Mybatis中对List<Object> 对象List的批处理插入操作
建表代码如下:
- createtable pda2_user(
- id varchar2(50) primarykey,
- name varchar2(100) notnull,
- psw varchar2(100) notnull
- );
- ######################################
- createsequence pda2_user_sequence
- minvalue 1
- maxvalue 999999999999999999999999999
- start with 1
- increment by 1
- cache 20;
- #####################################
- createtrigger"id_auto_increment_triger"
- before inserton pda2_user
- for each row
- when (new.id isnull)
- begin
- select pda2_user_sequence.nextval into :new.id from dual;
- end;
- ###################################################
- insertinto pad2_user (name,psw) values('chenjun','123')
- ####说明######
- 我使用的是Oracle数据库,为了使用主键自增长的方式,特此建立一个使用sequence的触发器
User bean代码如下:
- package com.deppon.pda.v2.model.basic.User;
- publicclass User {
- private String ID;
- private String name;
- private String psw;
- public User() {
- super();
- }
- public User(String name, String psw) {
- super();
- this.name = name;
- this.psw = psw;
- }
- public String getID() {
- return ID;
- }
- publicvoid setID(String iD) {
- ID = iD;
- }
- public String getName() {
- return name;
- }
- publicvoid setName(String name) {
- this.name = name;
- }
- public String getPsw() {
- return psw;
- }
- publicvoid setPsw(String psw) {
- this.psw = psw;
- }
- }
User实体对应的映射器UserMapper代码如下:
- package com.deppon.pda.v2.mapper.User;
- import com.deppon.pda.v2.model.basic.User.User;
- publicinterface UserMapper {
- publicvoid insertUser(User user);
- public User getUser(String name);
- }
映射器配置文件UserMapper.xml代码如下:
- ?xml version="1.0"encoding="UTF-8"?>
- <!DOCTYPE mapper
- PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
- "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
- <mappernamespace="com.deppon.pda.v2.mapper.User.UserMapper">
- <insertid="insertUser"parameterType="com.deppon.pda.v2.model.basic.User.User">
- insert into pda2_user(name,age) values(#{name},#{age})
- </insert>
- <selectid="getUser"resultType="com.deppon.pda.v2.model.basic.User.User"parameterType="java.lang.String">
- select * from pda2_user where name=#{name}
- </select>
- <!-- 当使用该Mybatis与Spring整合的时候,该文件必须和相应的Mapper接口文件同名,并在同一路径下 -->
- </mapper>
更多详情见请继续阅读下一页的精彩内容:
|
评论暂时关闭