设为首页 加入收藏

TOP

实现通用的PreparedStatement插入记录的方法(五)
2014-11-24 12:02:21 来源: 作者: 【 】 浏览:131
Tags:实现 通用 PreparedStatement 插入 记录 方法
= new GregorianCalendar(2013, 3 - 1, 13);
Object value = new Object();
int index = 1;
int int_sqlType = java.sql.Types.INTEGER;//4
int int_scaleOrLength = 4;
int bytes_size = 256;
int int_length = 10;
long long_length = 10l;
String str_sqlTypeName = "LONG";
pstmt.setArray(index, (java.sql.Array) value);
pstmt.setAsciiStream(index, (java.io.InputStream) value);
pstmt.setAsciiStream(index, (java.io.InputStream) value, int_length);
pstmt.setAsciiStream(index, (java.io.InputStream) value, long_length);
pstmt.setBigDecimal(index, (java.math.BigDecimal) value);
pstmt.setBinaryStream(index, (java.io.InputStream) value);
pstmt.setBinaryStream(index, (java.io.InputStream) value, int_length);
pstmt.setBinaryStream(index, (java.io.InputStream) value, long_length);
pstmt.setBlob(index, (java.sql.Blob) value);
pstmt.setBlob(index, (java.io.InputStream) value);
pstmt.setBlob(index, (java.io.InputStream) value, long_length);
pstmt.setBoolean(index, (Boolean) value);
pstmt.setByte(index, (byte) 30);
pstmt.setBytes(index, (byte[]) value);
pstmt.setCharacterStream(index, (java.io.Reader) value);
pstmt.setCharacterStream(index, (java.io.Reader) value, int_length);
pstmt.setCharacterStream(index, (java.io.Reader) value, long_length);
pstmt.setClob(index, (java.sql.Clob) value);
pstmt.setClob(index, (java.io.Reader) value);
pstmt.setClob(index, (java.io.Reader) value, long_length);
pstmt.setDate(index, (java.sql.Date) value);
pstmt.setDate(index, (java.sql.Date) value, calendar);
pstmt.setDouble(index, (java.lang.Double) value);
pstmt.setFloat(index, (java.lang.Float) value);
pstmt.setInt(index, (java.lang.Integer) value);
pstmt.setLong(index, (java.lang.Long) value);
pstmt.setNCharacterStream(index, (java.io.Reader) value);
pstmt.setNCharacterStream(index, (java.io.Reader) value, 123l);
pstmt.setNClob(index, (java.sql.NClob) value);
pstmt.setNClob(index, (java.io.Reader) value);
pstmt.setNClob(index, (java.io.Reader) value, 123l);
pstmt.setNString(index, (String) value);
pstmt.setNull(index, int_sqlType);
pstmt.setNull(index, int_sqlType, str_sqlTypeName);
pstmt.setObject(index, value); www.2cto.com
pstmt.setObject(index, value, int_sqlType);
pstmt.setObject(index, value, int_sqlType, int_scaleOrLength);
pstmt.setRef(index, (java.sql.Ref) value);
pstmt.setRowId(index, (java.sql.RowId) value);
pstmt.setSQLXML(index, (java.sql.SQLXML) value);
pstmt.setShort(index, (java.lang.Short) value);
pstmt.setString(index, (java.lang.String) value);
pstmt.setTime(index, (java.sql.Time) value);
pstmt.setTimestamp(index, (java.sql.Timestamp) value);
pstmt.setTimestamp(index, (java.sql.Timestamp) value, calendar);
pstmt.setURL(index, (java.net.URL) value);
pstmt.setUnicodeStream(index, (java.io.InputStream) value, int_length);
今后的建议:
对于未实现的赋值方法,在需要的时候,可以既有的代码的条件部分加以实现;
对于未来未知的数据库供应商定义的 Java类,如:com.sybase.jdbc2.tds.SybTimestamp,可以参照核心代码的相应部分实现
首页 上一页 2 3 4 5 下一页 尾页 5/5/5
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇java synchronized 下一篇设计模式详解之抽象工厂模式

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容: