{"rsdb":{"rid":"396141","subhead":"","postdate":"0","aid":"272989","fid":"76","uid":"1","topic":"1","content":"
\n


-- call p_CreateTableDal ('UAlarmData','IndustryParkForm','\u544a\u8b66\u914d\u7f6e','Alarm')<\/p> \n

 <\/p> \n


DROP PROCEDURE IF EXISTS p_CreateTableDal;
CREATE DEFINER=`root`@`%` PROCEDURE `p_CreateTableDal`( TableName VARCHAR(50), DataBaseName VARCHAR(50), FDescribe VARCHAR(50),Controller VARCHAR(50))
BEGIN<\/p> \n

#\u7f16\u8f91\u6761\u4ef6
set @FType='';
#\u4e3b\u952e\u7c7b\u578b
set @PrimaryType='';
#\u65b9\u6cd5\u53c2\u6570
set @ParaStr='';
#\u4fee\u6539\u7684\u5217\u8868
set @UpdateColumn='';
#\u4fee\u6539\u7684\u6761\u4ef6
set @UpdateWhere ='';
#\u8ffd\u52a0\u7684\u6761\u4ef6
set @UpdateObjectKey='';
#\u4fee\u6539\u7684Object
set @UpdateObject ='';
#\u4fee\u6539\u7684\u53c2\u6570
set @UpdatePara ='';
#\u65b0\u589e\u5217
set @InserColumn ='';
#\u65b0\u589e\u7684\u53c2\u6570
set @InserObject ='';
#\u65b0\u589eFGUID
set @InserFGUID ='';
#\u65b0\u589e\u7684Value
set @InserValue ='';
#\u53c2\u6570\u7c7b\u578b1
set @DataString ='char,varchar,datetime,text';
#\u53c2\u6570\u7c7b\u578b2
set @DataInt ='int,long,bit';
#\u53c2\u6570\u7c7b\u578b3
set @DataFloat ='float';
#\u53c2\u6570\u7c7b\u578b3
set @DataTime ='datetime,date,time';

#\u5b58\u653eDal
set @SelectData='';
set @DeleteData='';
set @AddUpdate='';

#\u5b58\u653eserver
set @SelectServer='';
set @DeleteServer='';
set @AddUpdateServer='';

#\u5b58\u653eserver
set @SelectController='';
set @DeleteController='';
set @AddUpdateController='';

#\u5b58\u653ejson
set @SelectJson='';
set @DeleteJson='';
set @AddUpdateJson='';

#\u5b58\u653eController\u53c2\u6570
set @jsonObject='';

#\u5b58\u653eToken
set @FTokenID='';

SELECT FTokenID into @FTokenID from TToken ORDER BY FCreateTime desc limit 1;

#\u65b0\u589e\u4fee\u6539\u6570\u636e
BEGIN

#\u751f\u6210\u53c2\u6570 COLUMN_NAME,DATA_TYPE

SELECT GROUP_CONCAT((case
when @DataString LIKE CONCAT('%',DATA_TYPE,'%') then 'String'
when @DataInt LIKE CONCAT('%',DATA_TYPE,'%') then 'int'
when @DataFloat LIKE CONCAT('%',DATA_TYPE,'%') then 'float'
else 'String' end),' ',
COLUMN_NAME),
GROUP_CONCAT('\\n',(case
when @DataString LIKE CONCAT('%',DATA_TYPE,'%') then 'jsonObject.getString("'
when @DataInt LIKE CONCAT('%',DATA_TYPE,'%') then 'jsonObject.getIntValue("'
when @DataFloat LIKE CONCAT('%',DATA_TYPE,'%') then 'jsonObject.getFloatValue("'
else 'jsonObject.getString("' end),
COLUMN_NAME,'")'),
GROUP_CONCAT((case
when @DataTime LIKE CONCAT('%',DATA_TYPE,'%') then CONCAT('"',COLUMN_NAME,'":"',NOW(),'"')
when @DataString LIKE CONCAT('%',DATA_TYPE,'%') then CONCAT('"',COLUMN_NAME,'":"\u6d4b\u8bd5"')
when @DataInt LIKE CONCAT('%',DATA_TYPE,'%') then CONCAT('"',COLUMN_NAME,'":1')
when @DataFloat LIKE CONCAT('%',DATA_TYPE,'%') then CONCAT('"',COLUMN_NAME,'":1')
else CONCAT('"',COLUMN_NAME,'":"\u6d4b\u8bd5"') end))
<\/p> \n

into @ParaStr,
@jsonObject,
@AddUpdateJson
from INFORMATION_SCHEMA.COLUMNS where table_name = TableName and TABLE_SCHEMA=DataBaseName;

#\u4fee\u6539\u53c2\u6570\u751f\u6210
BEGIN
#\u751f\u6210\u4fee\u6539\u6761\u4ef6
SELECT
GROUP_CONCAT( kc.COLUMN_NAME,'=? ' SEPARATOR ' and '),
GROUP_CONCAT(kc.COLUMN_NAME),
GROUP_CONCAT((case
when @DataString LIKE CONCAT('%',DATA_TYPE,'%') then CONCAT('StringUtils.isEmpty(',kc.COLUMN_NAME,')')
when @DataInt LIKE CONCAT('%',DATA_TYPE,'%') then CONCAT(kc.COLUMN_NAME,'==0')
when @DataFloat LIKE CONCAT('%',DATA_TYPE,'%') then CONCAT(kc.COLUMN_NAME,'==0')
else CONCAT('StringUtils.isEmpty(',kc.COLUMN_NAME,')') end)
) ,
GROUP_CONCAT((case
when @DataString LIKE CONCAT('%',DATA_TYPE,'%') then 'String'
when @DataInt LIKE CONCAT('%',DATA_TYPE,'%') then 'int'
when @DataFloat LIKE CONCAT('%',DATA_TYPE,'%') then 'int'
else 'String' end)
)
into
@UpdateWhere,
@UpdateObjectKey,
@FType,
@PrimaryType
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE kc
LEFT JOIN INFORMATION_SCHEMA","orderid":"0","title":"mysql DBUtils \u5b58\u50a8\u8fc7\u7a0b\u4ee3\u7801\u751f\u6210(\u4e00)","smalltitle":"","mid":"0","fname":"JAVA","special_id":"0","bak_id":"0","info":"0","hits":"81","pages":"5","comments":"0","posttime":"2023-08-26 21:10:55","list":"1693055455","username":"admin","author":"","copyfrom":"","copyfromurl":"","titlecolor":"","fonttype":"0","titleicon":"0","picurl":"https:\/\/www.cppentry.com\/upload_files\/","ispic":"0","yz":"1","yzer":"","yztime":"0","levels":"0","levelstime":"0","keywords":"mysql<\/A> DBUtils<\/A> \u50a8\u8fc7\u7a0b<\/A>","jumpurl":"","iframeurl":"","style":"","template":"a:3:{s:4:\"head\";s:0:\"\";s:4:\"foot\";s:0:\"\";s:8:\"bencandy\";s:0:\"\";}","target":"0","ip":"220.152.140.35","lastfid":"0","money":"0","buyuser":"","passwd":"","allowdown":"","allowview":"","editer":"","edittime":"0","begintime":"0","endtime":"0","description":"mysql DBUtils \u5b58\u50a8\u8fc7\u7a0b\u4ee3\u7801\u751f\u6210","lastview":"1713958056","digg_num":"0","digg_time":"0","forbidcomment":"0","ifvote":"0","heart":"","htmlname":"","city_id":"0"},"page":"1"}