nc 如何获取表体全部/多行/一个的数据

nc 如何获取表体全部/多行/一个的数据

private IBillCardPanelEditor editor;
public void setEditor(IBillCardPanelEditor editor) {
	this.editor = editor;
}
public IBillCardPanelEditor getEditor() {
	return editor;
}

//方法下：
//选择的行数
int[] row = editor.getBillCardPanel().getBillTable().getSelectedRows();
List<String> list = new ArrayList<String>();
//遍历组件名
int rows = editor.getBillCardPanel().getBillTable().getRowCount();
//没有选择行数的时候，直接获取表体中全部的值，然后拿出组件名放到list中
if (row.length == 0 && rows > 1) {
	for (int i = 0; i < rows; i++) {
		TemplatesBVO namesa = (TemplatesBVO) this.getEditor()
				.getBillCardPanel().getBillModel()
				.getBodyValueRowVO(i, TemplatesBVO.class.getName());
		list.add(namesa.getName());
	}
} else {//选择一行或者多行的时候
	for (int i = 0; i < row.length; i++) {
		TemplatesBVO namesa = (TemplatesBVO) this
				.getEditor()
				.getBillCardPanel()
				.getBillModel()
				.getBodyValueRowVO(row[i], TemplatesBVO.class.getName());
		list.add(namesa.getName());
	}

}
//获取的list需要添加''和逗号，进行组装和删除最后一个逗号
StringBuffer sqls = new StringBuffer();
if (list != null && list.size() > 0) {
	for (String listas : list) {
		sqls.append("'" + listas + "',");
	}
	if (sqls != null && sqls.length() > 0) {
		sqls.deleteCharAt(sqls.length() - 1);
	}
	//考虑到档案（唯一性：组件名，或者编码，或者数据库名）
	String sql = "select '.'|| b.name from md_class b where b.componentid in (select a.id from md_component a where a.displayname in("
			+ sqls + ")) and nvl(dr,0)=0 ";
	List<String> pk_billtypecode = (List<String>) bs.executeQuery(sql,
			new ColumnListProcessor());
}