Mybatis之Oracle增删查改示例--转

发布时间：2020-12-14 06:21:33 所属栏目：Java 来源：网络整理

导读：http://blog.csdn.net/bingjie1217/article/details/21088431?utm_source=tuicoolutm_medium=referral oracle表结构 ( ( ; 配置mybatis配置文件UsersMapper.xml span style="color: #008000;" span style="color: #0000ff;" span style="color: #800000;"res

http://blog.csdn.net/bingjie1217/article/details/21088431?utm_source=tuicool&utm_medium=referral

oracle表结构

(( ;

配置mybatis配置文件UsersMapper.xml

<sql id="Tabel_Name">
t_users
</sql>

<sql id="Base_Column_List" >
id,name,sex,birs,message
</sql>

<sql id="Example_Where_Clause">
where 1=1
<trim suffixOverrides=",">
<if test="id != null">
and id = #{id}
</if>
<if test="name != null and name != ''">
and name like concat(concat('%','${name}'),'%')
</if>
<if test="sex != null and sex != ''">
and sex like concat(concat('%','${sex}'),'%')
</if>
<if test="birs != null">
and birs = #{birs}
</if>
<if test="message != null">
and message = #{message}
</if>
</trim>
</sql>

<insert id="add" parameterType="Object" >
<selectKey resultType="int" order="BEFORE" keyProperty="id">
select seq_t_users_id.nextval as id from dual
</selectKey>
insert into t_users(id,message) values(#{id},#{name},#{sex},#{birs},#{message,jdbcType=CLOB})
</insert>

<update id="updateBySelective" parameterType="Object" >
update t_users set
<trim suffixOverrides="," >
<if test="name != null and name != '' ">
name=#{name},</if>
<if test="sex != null and sex != '' ">
sex=#{sex},</if>
<if test="birs != null ">
birs=#{birs},</if>
<if test="message != null and message != '' ">
message=#{message},</if>
</trim> where id=#{id}
</update>

<delete id="delete" parameterType="Object">
delete from t_users where id = #{id}
</delete>

<select id="queryById" resultMap="BaseResultMap" parameterType="Object">
select
<include refid="Base_Column_List" />
from t_users where id = #{id}
</select>

<select id="queryBySelective" resultMap="BaseResultMap" parameterType="Object">
select
<include refid="Base_Column_List" />
from t_users
<include refid="Example_Where_Clause" />
</select>

<select id="queryByCount" resultType="java.lang.Integer" parameterType="Object">
select count(1) from t_users
<include refid="Example_Where_Clause" />
</select>

<select id="queryByList" resultMap="BaseResultMap" parameterType="Object">
select
<include refid="Base_Column_List" />
from t_users
<include refid="Example_Where_Clause"/>
</select>
</mapper>

Mapper类接口

import java.util.List;

public interface UsersMapper {

public void add(T t);

public void update(T t);

public void updateBySelective(T t);

public void delete(Object id);

public T queryById(Object id);

public List queryBySelective(T t);

public int queryByCount(T t);

public List queryByList(T t);

}

类型转换工具类

import java.sql.CallableStatement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import oracle.sql.CLOB;

import org.apache.ibatis.type.JdbcType;
import org.apache.ibatis.type.TypeHandler;

public class OracleClobTypeHandler implements TypeHandler