bap.plugins.tableStructure.controller

Class TableStructureRESTController

java.lang.Object

bap.core.controller.BaseController

bap.plugins.tableStructure.controller.TableStructureRESTController

@Controller
 @RequestMapping(value="rest/tableStructure")
public class TableStructureRESTController
extends bap.core.controller.BaseController

保存、导出数据库表的RESTful API

Constructor Summary

Constructors

Constructor and Description
TableStructureRESTController()

Method Summary

Modifier and Type	Method and Description
java.util.List<java.util.Map<java.lang.String,java.lang.Object>>	chGData(java.lang.String[] ck_ids) 重新整理需要导出的表
void	export_word(javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, java.lang.String[] ck_ids) 功能描述:将选中的表导出为word文档
java.util.List	freemarkData(java.util.List<java.util.Map<java.lang.String,java.lang.Object>> list) 通过给定的表信息，获取到freemarker模板所需的填充数据
org.springframework.http.ResponseEntity<java.lang.String>	get(bap.core.formbean.Page page) 分页取得多条数据
java.util.Map<java.lang.String,java.util.Map<java.lang.String,java.util.Map<java.lang.String,java.lang.String>>>	getPfk(java.lang.String schemaFlag, java.lang.String tableName, java.sql.DatabaseMetaData metaData) 功能描述:获取指定表的主外键索引相关联的表和列

Methods inherited from class bap.core.controller.BaseController

getBaseDao, initBinder, setBaseDao

Methods inherited from class java.lang.Object

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

Constructor Detail

TableStructureRESTController

public TableStructureRESTController()

Method Detail

get

@GetMapping
public org.springframework.http.ResponseEntity<java.lang.String> get(bap.core.formbean.Page page)

分页取得多条数据

Parameters:

page - 分页属性封装对象

Returns:

export_word

@PostMapping(value="export_word")
public void export_word(javax.servlet.http.HttpServletRequest request,
                                                           javax.servlet.http.HttpServletResponse response,
                                                           @RequestParam(value="ck_ids",required=false)
                                                           java.lang.String[] ck_ids)

功能描述:将选中的表导出为word文档

Parameters:

requset -

response -

ck_ids -

chGData

public java.util.List<java.util.Map<java.lang.String,java.lang.Object>> chGData(java.lang.String[] ck_ids)

重新整理需要导出的表

Parameters:

ck_ids - 用户选择的表

Returns:

freemarkData

public java.util.List freemarkData(java.util.List<java.util.Map<java.lang.String,java.lang.Object>> list)

通过给定的表信息，获取到freemarker模板所需的填充数据

Parameters:

list - 表信息list

Returns:

getPfk

public java.util.Map<java.lang.String,java.util.Map<java.lang.String,java.util.Map<java.lang.String,java.lang.String>>> getPfk(java.lang.String schemaFlag,
                                                                                                                               java.lang.String tableName,
                                                                                                                               java.sql.DatabaseMetaData metaData)
                                                                                                                        throws java.lang.Exception

功能描述:获取指定表的主外键索引相关联的表和列

Parameters:

schemaFlag -

tableName - 表名

metaData -

Returns:

Throws:

java.lang.Exception