数据库---接口 IVOPersistence

男娘i 2022-08-24 04:16 138阅读 0赞

1.接口 IVOPersistenceinsertVO 是指增加，删除，更新的操作的接口

1.1 增加操作

java.lang.String **insertVO**(nc.vo.pub.SuperVO vo)                          throws nc.vo.pub.BusinessException

java.lang.String\[\] **insertVOList**(java.util.List vos) throws nc.vo.pub.BusinessException

java.lang.String\[\] **insertVOArray**(nc.vo.pub.SuperVO\[\] vo)             throws nc.vo.pub.BusinessException

java.lang.String\[\] **insertObject**(java.lang.Object\[\] vo,                               [IMappingMeta][] meta)                                throws nc.vo.pub.BusinessException

java.lang.String **insertObject**(java.lang.Object vo,                             [IMappingMeta][] meta)                              throws nc.vo.pub.BusinessException

1.2 更新操作

int **updateVO**(nc.vo.pub.SuperVO vo)             throws nc.vo.pub.BusinessException

void **updateVOList**(java.util.List vos)                  throws nc.vo.pub.BusinessException

int **updateVOArray**(nc.vo.pub.SuperVO\[\] vo)                  throws nc.vo.pub.BusinessException

int **updateObject**(java.lang.Object\[\] vos,                [IMappingMeta][] meta)                 throws nc.vo.pub.BusinessException

int **updateObject**(java.lang.Object vo,                 [ IMappingMeta][IMappingMeta] meta)                 throws nc.vo.pub.BusinessException

1.3 删除操作

void **deleteVO**(nc.vo.pub.SuperVO vo)              throws nc.vo.pub.BusinessException

void **deleteVOArray**(nc.vo.pub.SuperVO\[\] vo)            throws nc.vo.pub.BusinessException

void **deleteVOList**(java.util.List vos)                  throws nc.vo.pub.BusinessException

void **deleteByPK**(java.lang.Class className,                java.lang.String pk)                throws nc.vo.pub.BusinessException

void **deleteByPKs**(java.lang.Class className,                 java.lang.String\[\] pks)                 throws nc.vo.pub.BusinessException

void **deleteByClause**(java.lang.Class className,                    java.lang.String wherestr)                    throws nc.vo.pub.BusinessException

void **deleteObject**(java.lang.Object\[\] vos,                 [IMappingMeta][] meta)                  throws nc.vo.pub.BusinessException

void **deleteObject**(java.lang.Object vo,                  [ IMappingMeta][IMappingMeta] meta)                  throws nc.vo.pub.BusinessException

2.接口 IUAPQueryBS是查询接口，与查询有关的操作

java.lang.Object **executeQuery**(java.lang.String sql,     [ ResultSetProcessor][ResultSetProcessor] processor)    执行一个无参数的sql语句

java.lang.Object **executeQuery**(java.lang.String sql,     [ SQLParameter][SQLParameter] parameter, [ResultSetProcessor][] processor)执行一个有参数的SQL语句

java.util.Collection **retrieve**(java.lang.Object vo,    [ IMappingMeta][IMappingMeta] meta)   根据对象的属性值作为查询条件进行查询

java.util.Collection **retrieveAll**(java.lang.Class className,   [IMappingMeta][] meta)   根据数据映射信息来查询所有的数据

java.util.Collection **retrieveByClause**(java.lang.Class className,   [ IMappingMeta][IMappingMeta] meta, java.lang.String condition,   java.lang.String\[\] fields)

java.util.Collection **retrieveByClause**(java.lang.Class className,   [ IMappingMeta][IMappingMeta] meta,  java.lang.String condition,   java.lang.String\[\] fields,                                        [ SQLParameter][SQLParameter] param)

java.util.Collection **retrieveByClause**(java.lang.Class className, [IMappingMeta][] meta,  java.lang.String condition)

java.util.Collection **retrieveByClause**(java.lang.Class className,                                      java.lang.String condition)根据条件查询vo对应数据

java.util.Collection **retrieveAll**(java.lang.Class className) 查询vo对应的所有的数据

java.util.Collection **retrieve**(nc.vo.pub.SuperVO vo,                              boolean isAnd)

java.util.Collection **retrieve**(nc.vo.pub.SuperVO vo,                              boolean isAnd,                              java.lang.String\[\] fields)

java.util.Collection **retrieveByClause**(java.lang.Class className, java.lang.String condition,  java.lang.String\[\] fields,     [SQLParameter][] param)

java.util.Collection **retrieveByClause**(java.lang.Class className,   java.lang.String condition,    java.lang.String\[\] fields)

java.lang.Object **retrieveByPK**(java.lang.Class className,                              java.lang.String pk)

java.lang.Object **retrieveByPK**(java.lang.Class className,                              java.lang.String pk,                              java.lang.String\[\] selectedFields)

java.util.Collection **retrieveByCorp**(java.lang.Class c,                                    java.lang.String pkCorp)

java.util.Collection **retrieveByCorp**(java.lang.Class c,                                    java.lang.String pkCorp,                                    java.lang.String\[\] selectedFields)

[IMappingMeta]: http://127.0.0.1:49619/help/topic/com.yonyou.help.javadoc.base/persist/nc/jdbc/framework/mapping/IMappingMeta.html
[ResultSetProcessor]: http://127.0.0.1:49619/help/topic/com.yonyou.help.javadoc.base/persist/nc/jdbc/framework/processor/ResultSetProcessor.html
[SQLParameter]: http://127.0.0.1:49619/help/topic/com.yonyou.help.javadoc.base/persist/nc/jdbc/framework/SQLParameter.html