public class PsqlJsonAdaptor extends Object implements ValueAdaptor
public class Pet { public static Pet getInstance(ResultSet rs) throws SQLException { // 需要把所有字段从 ResultSet 取出,不然该属性无法映射 Pet pet = new Pet(); pet.setId(rs.getInt("id")); pet.setData(NutMap.WRAP(rs.getString("data"))); return pet; } @Id private int id; @ColDefine(customType = "json", type = ColType.PSQL_JSON) private NutMap data; // ... 省略后面代码,包括字段声明以及 getter 和 setter } public class Jone { public Jone(ResultSet rs) throws SQLException { // 需要把所有字段从 ResultSet 取出,不然该属性无法映射 this.id = rs.getInt("id"); this.info = Json.fromJson(Information.class, rs.getString("info")); } @Id private int id; @ColDefine(customType = "json", type = ColType.PSQL_JSON) private Information info; // ... 省略后面代码,包括字段声明以及 getter 和 setter }
Constructor and Description |
---|
PsqlJsonAdaptor() |
Modifier and Type | Method and Description |
---|---|
Object |
get(ResultSet rs,
String colName)
从结果集里获取一个字段的值
|
void |
set(PreparedStatement stat,
Object obj,
int index)
为缓冲语句设置值
|
public Object get(ResultSet rs, String colName) throws SQLException
ValueAdaptor
get
in interface ValueAdaptor
rs
- 结果集colName
- 列名SQLException
public void set(PreparedStatement stat, Object obj, int index) throws SQLException
ValueAdaptor
一个值可以被设置到多个占位符中
set
in interface ValueAdaptor
stat
- 缓冲语句obj
- 值index
- 占位符位置,从 1 开始SQLException
Copyright © 2017. All rights reserved.