NC开发前后台数据库操作的用法

超、凢脫俗 2021-11-17 06:28 791阅读 0赞

> ## 后台数据库操作方法(private端): ##

#### 以下为后台查询方法 ####

//只能在private端使用
    BaseDAO bd = new BaseDAO();

//查询语句只能返回一行一列结果
    String sql="select vbillcode from conn_user where pk_user='pk'";
    Object result = bd.executeQuery(sql, new ColumnProcessor());

//查询语句可以返回多行多列
    String sql="select * from conn_user where dr = 0";
    List<Object[]> result = (List<Object[]>) bd.executeQuery(sql, new ArrayListProcessor());

//查询语句只返回一行结果
    String sql="select * from conn_user where pk_user='pk'";
    Map<String, Object> result = (Map<String, Object>) bd.executeQuery(sql, new MapProcessor());

//查询语句可以返回多行结果  
    String sql="select * from conn_user where dr = 0";
    List<Map<String,String>> result = (List<Map<String, String>>) bd.executeQuery(sql, new MapListProcessor());

//查询语句只返回一个VO
    String sql="select * from conn_user where pk_user='pk'";
    UserVO result =  (UserVO) bd.executeQuery(sql, new BeanProcessor(UserVO.class));

//查询语句返回多个VO
    String sql="select * from conn_user where dr = 0";
    List<UserVO> result = (List<UserVO>) bd.executeQuery(sql,new BeanListProcessor(UserVO.class));

#### 以下为新增更新删除方法(手写sql) ####

bd.executeUpdate(sql);

--------------------

> ## 前台数据库操作方法(client端): ##

前台提供两个主要接口进行CURD操作:

IVOPersistence  该接口只支持前台增删改操作  
    IUAPQueryBS   该接口主要支持前台的查询操作

//processor跟第一点的basedao用法一致
    IUAPQueryBS bs = NCLocator.getInstance().lookup(IUAPQueryBS.class);
    bs.executeQuery(sql, processor);

--------------------

> ## 常用查询操作方法: ##

//后台通过主表主键查询AggVO
     BillQuery<AggUserVO> bq = new BillQuery<>(AggUserVO.class);
     bq.query(pk);

//前台通过主表主键查询AggVO
    HYPubBO_Client.queryBillVOByPrimaryKey(AggUserVO.class, pk)

//前后台都能用
    IBillQueryService bq = NCLocator.getInstance().lookup(IBillQueryService.class);