# springBoot-mybatis

**Repository Path**: zero-wsh/springBoot-mybatis

## Basic Information

- **Project Name**: springBoot-mybatis
- **Description**: springBoot+mybatis
- **Primary Language**: JavaScript
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2020-01-17
- **Last Updated**: 2022-05-27

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

CREATE OR REPLACE PROCEDURE ADD_COLUMN (
  calalog IN VARCHAR2, -- 数据库
	tableName IN VARCHAR2, --表名
	columnName IN VARCHAR2, --列名
	type IN VARCHAR2, -- 字段类型(长度)  VARCHAR2(255)
	empty IN VARCHAR2, -- 是否为空 NOT NULL
	def IN VARCHAR2,  --默认值 NULL
	remarks IN VARCHAR2, -- 注释
	pk IN NUMBER, -- 是否主键(0否 1是)
	pkStr IN VARCHAR2 -- 主键字符串(当是主键时必填,实例:[id],[name])
) AS
--添加字段sql
add_column_sql varchar2(3000);
-- 添加注释sql
remarks_sql varchar2(3000);
-- 删除主键sql
del_pk_sql varchar2(3000);
-- 添加主键sql
add_pk_sql varchar2(3000);
-- 主键数量
pk_count NUMBER;
BEGIN
	pk_count:=SELECT count(1) from user_cons_columns t where t.table_name  = tableName and t.position is not null;
	-- 添加字段
	add_column_sql:='ALTER TABLE '||calalog||'."'||tableName||'" ADD ( "'||columnName||'" '||type||' DEFAULT '||def||' '||empty||'  )';
	-- 添加注释
	remarks_sql:='COMMENT ON COLUMN '||calalog||'."'||tableName||'"."'||columnName||'" IS '''||remarks||'''';

	execute immediate add_column_sql;
	execute immediate remarks_sql;
	if pk=1 then
		if pk_count >0 then 
			-- 删除主键
			del_pk_sql:='ALTER TABLE '||calalog||'."'||tableName||'" DROP PRIMARY KEY';
		end if;
		-- 添加主键
		add_pk_sql:='ALTER TABLE '||calalog||'."'||tableName||'" ADD CONSTRAINT "pk_zero" PRIMARY KEY ('||pkStr||')';
		execute immediate del_pk_sql;
		execute immediate add_pk_sql;
	end if;END;