org.nutz.dao.impl.jdbc.psql

Class PsqlArrayAdaptor

java.lang.Object

org.nutz.dao.impl.jdbc.psql.PsqlArrayAdaptor

All Implemented Interfaces:

ValueAdaptor

public class PsqlArrayAdaptor
extends Object
implements ValueAdaptor

为 PostgreSQL 数据库封装对数组类型的支持

注意，需要给 POJO 添加带一个参数的静态工厂方法或者带一个参数的构造函数，
显示的使用 java.sql.ResultSet 来创建该 POJO，不然会出现无法映射的错误。

 public class Pet {

     public static Pet getInstance(ResultSet rs) throws SQLException {
         Pet pet = new Pet();
         pet.setId(rs.getInt("id"));
         pet.setPayByQuarter((Integer[]) rs.getArray("pay_by_quarter").getArray());
         return pet;
     }

     @Column("pay_by_quarter")
     @ColDefine(customType = "integer[]", type = ColType.PSQL_ARRAY)
     private Integer[] payByQuarter;

     // ... 省略后面代码，包括字段声明以及 getter 和 setter
 }

 public class Jone {

     public Jone(ResultSet rs) throws SQLException {
         this.id = rs.getInt("id");
         this.schedule = (String[]) rs.getArray("schedule").getArray();
     }

     @ColDefine(customType = "varchar[]", type = ColType.PSQL_ARRAY)
     private String[] schedule;

     // ... 省略后面代码，包括字段声明以及 getter 和 setter
 }
 

Constructor Summary

Constructors

Constructor and Description
PsqlArrayAdaptor(String customDbType)

Method Summary

Modifier and Type	Method and Description
Object	get(ResultSet rs, String colName) 从结果集里获取一个字段的值
void	set(PreparedStatement stat, Object obj, int index) 为缓冲语句设置值

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

PsqlArrayAdaptor

public PsqlArrayAdaptor(String customDbType)

Method Detail

get

public Object get(ResultSet rs,
                  String colName)
           throws SQLException

Description copied from interface: ValueAdaptor

从结果集里获取一个字段的值

Specified by:

get in interface ValueAdaptor

Parameters:

rs - 结果集

colName - 列名

Returns:

字段值

Throws:

SQLException

set

public void set(PreparedStatement stat,
                Object obj,
                int index)
         throws SQLException

Description copied from interface: ValueAdaptor

为缓冲语句设置值

一个值可以被设置到多个占位符中

Specified by:

set in interface ValueAdaptor

Parameters:

stat - 缓冲语句

obj - 值

index - 占位符位置，从 1 开始

Throws:

SQLException