📄 blobtype.java
字号:
/**
*
*/
package com.easyjf.dbo;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Types;
import java.sql.SQLException;
import java.sql.Blob;
import java.io.Serializable;
import org.apache.log4j.Logger;
/**
* @author wangliang138840
*
*/
public class BlobType implements Serializable{
private transient Logger logger = Logger.getLogger(BlobType.class);
public BlobType(){
}
public void set(PreparedStatement st, Object obj, int index)
throws Exception
{
if(obj == null){
st.setNull(index, Types.BLOB);
}else{
if(obj instanceof Blob){
//st.setBlob(index, (Blob)obj);
//st.setBinaryStream(2, ((BlobImpl)obj).getBinaryStream(),
// ((BlobImpl)obj).getBinaryStream().available());
Blob blob = (Blob)obj;
st.setBinaryStream(index, blob.getBinaryStream(), (int)blob.length());
}
else{
logger.debug("It is not Blob type.");
}
}
}
public Blob get(ResultSet rs, String name)
throws SQLException
{
return rs.getBlob(name);
}
public Blob get(ResultSet rs, int index)
throws SQLException
{
return rs.getBlob(index);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -