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