@Repository public class PgSqlTableModifyDao extends Object
| 构造器和说明 |
|---|
PgSqlTableModifyDao() |
| 限定符和类型 | 方法和说明 |
|---|---|
void |
createTable(String createTableSql)
新建表
|
void |
dropTableByName(String tableName)
根据表名删除表
|
boolean |
existsByTableName(String tableName)
查据表名询表信息
|
List<PgSqlTableColumn> |
findColumnByTableName(String tableName)
根据表名查询库中该表的字段结构等信息
|
List<PgSqlTableIndex> |
findIndexByTableName(String tableName)
查询当前表存在的索引(除了主键索引primary)
|
List<PgSqlTableIndex> |
findPrimaryIndexByTableName(String tableName)
查询当前表存在的主键索引
|
PgSqlTableInfo |
findTableByTableName(String tableName)
查据表名询表信息
|
void |
modifyTable(String modifyTableSql)
更新表
|
@Transactional(rollbackFor=java.lang.Exception.class) public void createTable(String createTableSql)
@Transactional(rollbackFor=java.lang.Exception.class) public void modifyTable(String modifyTableSql)
public boolean existsByTableName(String tableName)
tableName - 表结构的mappublic PgSqlTableInfo findTableByTableName(String tableName)
tableName - 表结构的mappublic List<PgSqlTableColumn> findColumnByTableName(String tableName)
tableName - 表结构的mappublic List<PgSqlTableIndex> findIndexByTableName(String tableName)
tableName - 表名public List<PgSqlTableIndex> findPrimaryIndexByTableName(String tableName)
tableName - 表名public void dropTableByName(String tableName)
tableName - 表名Copyright © 2023. All rights reserved.