ibatis 数据字段为blob如写配置文件

iBatis对BLOB数据读写,
map.xml的配置
<resultMap id="pojo-product" class="product">
<result property="id" column="id"/>
<result property="name" column="proName"/>
<result property="typleName" column="typleNum"/>
<result property="typle" column="typle"/>
<result property="proMaker" column="maker"/>
<result property="date" column="proDate"/>
<result property="pic" column="pic" jdbcType="BLOB" javaType="[B"/>
</resultMap>
<parameterMap id="into-pro" class="product">
<!-- <parameter property="id" jdbcType="VARCHAR" javaType ="java.lang.String"/> -->
<parameter property="name" jdbcType="VARCHAR" javaType ="java.lang.String"/>
<parameter property="typleName" jdbcType="VARCHAR" javaType ="java.lang.String"/>
<parameter property="typle" jdbcType="VARCHAR" javaType ="java.lang.String"/>
<parameter property="proMaker" jdbcType="VARCHAR" javaType ="java.lang.String"/>
<parameter property="date" jdbcType="DATE" javaType="java.util.Date"/>
<parameter property="pic" jdbcType="BLOB" javaType="[B"/>
</parameterMap>
<insert id="insertProduct" parameterClass="product" parameterMap="into-pro">
insert into product(id,proName,typleNum,typle,maker,proDate,pic)
values(PRO_ID_SEQ.nextval,?,?,?,?,?,?)
</insert>
<update id="updateProduct" parameterClass="product">
update product set pic=#pic# , proName=#name#,typleNum=#typleName#,
typle=#typle#,maker=#proMaker#,proDate=#date# where id=#id#
</update>

DAO处理
sqlMap.startTransaction();
sqlMap.update("updateProduct", pro);//pro是传进去的Product类的对象
sqlMap.commitTransaction();
Product类
public class Product implements Serializable {

private int id;
private String name;
private String typleName;
private String typle;
private String proMaker;
private Date date;
private byte[] pic;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getTypleName(){
return typleName;
}
public void setTypleName(String typleName){
this.typleName = typleName;
}
public String getTyple(){
return typle;
}
public void setTyple(String typle){
this.typle = typle;
}
public String getProMaker(){
return proMaker;
}
public void setProMaker(String proMaker){
this.proMaker = proMaker;
}
public Date getDate() {
return date;
}
public void setDate(Date date) {
this.date = date;
}
public byte[] getPic() {
return pic;
}
public void setPic(byte[] pic) {
this.pic = pic;
}

}
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值