包含declaremodule的词条

mysql 存储过程

你应该在做统计吧,估计你不会的就是mysql存储过程的语法 我之前也写过 很是郁闷 我给你一段代码 是我用mysql写过的一个存储过程 你看看 主要是了解里面的语法 看懂了 你所说的需求并不难

有看不懂的地方一起讨论 :

begin

declare tikk datetime ;

declare done int default 0;

declare userid int default 0;

declare moduleid int default 0;

declare couid int default 0;

declare mduname varchar(255) ;

declare opsid int default 0;

declare c1 cursor for Select I_userID,I_operationID from space_operation_record where status0 group by I_userID,I_operationID order by createtime desc;

declare continue handler for sqlstate '02000' set done =1;

set tikk = now();

open c1;

repeat

fetch c1 into userid, opsid;

if not done then

select I_moduleID from space_operation where status0 and ID=opsid into moduleid;

if moduleid '' then

select Nvc_identification from space_operation where status0 and ID=opsid into @identiftion;

if moduleid 0 then

Select Nvc_ename from space_module where status0 and ID=moduleid into mduname;

else

set mduname = 'space';

end if;

create temporary table if not exists sp_tab1(id bigint(20),Nvc_content MEDIUMTEXT,I_obyuID bigint(20),I_tID bigint(20),createtime datetime);

INSERT INTO sp_tab1 Select ID,Nvc_content,I_objectID,I_tmID,createtime from space_operation_record where status0 and I_operationID=opsid and I_userID=userid ;

select count(*) from sp_tab1 into couid;

set @ihod = 0;

set @listp = '';

set @listpp = '';

set @content0p = '';

set @content0 = '';

while couid 0 do

select ID,Nvc_content,I_obyuID,createtime,I_tID into @iok,@conuiy,@objiplk,@crtimhr,@tmids from sp_tab1 where ID @ihod order by ID asc limit 0,1;

if @iok '' then

if mduname = 'blog' then

INSERT INTO space_operation_stat(I_operationID,I_userID,Nvc_content,D_stattime,createtime) VALUES (@iok,userid,@conuiy,@crtimhr,tikk);

elseif mduname = 'team' then

if(@identiftion = 'addblog' || @identiftion = 'mdyblog') then

INSERT INTO space_operation_stat(I_operationID,I_userID,Nvc_content,D_stattime,I_tmID,createtime) VALUES (@iok,userid,@conuiy,@crtimhr,@tmids,tikk);

else

set @listpp = CONCAT(@listpp,CONCAT(@objiplk,','));

set @operarry1p = substring_index(@conuiy,'|',1);

set @operarry2p = substring_index(@conuiy,'|',-1);

set @content0p = CONCAT(@content0p,CONCAT(@operarry2p,SPACE(1)));

set @objlistp = substring(@listpp,1,length(@listpp)-1);

end if;

elseif mduname = 'space' then

if(@identiftion = 'headphoto' || @identiftion = 'status') then

INSERT INTO space_operation_stat(I_operationID,I_userID,Nvc_content,D_stattime,I_tmID,createtime) VALUES (@iok,userid,@conuiy,@crtimhr,@tmids,tikk);

else

set @listppr = CONCAT(@listppr,CONCAT(@objiplk,','));

set @operarry1pr = substring_index(@conuiy,'|',1);

set @operarry2pr = substring_index(@conuiy,'|',-1);

set @content0pr = CONCAT(@content0pr,CONCAT(@operarry2pr,SPACE(1)));

set @objlistpr = substring(@listppr,1,length(@listppr)-1);

end if;

else

set @listp = CONCAT(@listp,CONCAT(@objiplk,','));

set @operarry1 = substring_index(@conuiy,'|',1);

set @operarry2 = substring_index(@conuiy,'|',-1);

set @content0 = CONCAT(@content0,CONCAT(@operarry2,SPACE(1)));

set @objlist = substring(@listp,1,length(@listp)-1);

end if;

set @ihod = @iok;

end if;

set couid = couid -1;

end while;

if @content0 '' then

set @contentp = CONCAT(@operarry1,concat('|',@content0));

Select createtime,ID into @uitimej,@IDjok from space_operation_record where status0 and I_operationID=opsid order by createtime desc limit 0,1;

if @uitimej '' then

INSERT INTO space_operation_stat(I_operationID,I_userID,Nvc_content,D_stattime,createtime,Nvc_objlist) VALUES(@iok,userid,@contentp,@crtimhr,tikk,@objlist);

end if;

end if;

if @content0p '' then

if @identiftion = 'addphoto' then

set @contentp = CONCAT(@operarry1p,CONCAT('|',@content0p));

else

set @contentp = CONCAT(@operarry1p,CONCAT(@content0p,'|'));

end if;

Select createtime,ID into @uitimej,@IDjok from space_operation_record where status0 and I_operationID=opsid order by createtime desc limit 0,1;

if @uitimej '' then

INSERT INTO space_operation_stat(I_operationID,I_userID,Nvc_content,D_stattime,createtime,Nvc_objlist,I_tmID) VALUES(@iok,userid,@contentp,@crtimhr,tikk,@objlistp,@tmids);

end if;

end if;

if @content0pr '' then

set @contentp = CONCAT(@operarry1p,concat('|',@content0pr));

Select createtime,ID into @uitimej,@IDjok from space_operation_record where status0 and I_operationID=opsid order by createtime desc limit 0,1;

if @uitimej '' then

INSERT INTO space_operation_stat(I_operationID,I_userID,Nvc_content,D_stattime,createtime,Nvc_objlist,I_tmID) VALUES(@iok,userid,@contentp,@crtimhr,tikk,@objlistp,@tmids);

end if;

end if;

delete from sp_tab1;

end if;

end if;

until done end repeat;

close c1;

drop temporary table if exists sp_tab1 ;

UPDATE space_operation_play SET status=0;

UPDATE space_operation_display SET status=0;

Select createtime into @ptimes from space_operation_stat where status0 order by createtime desc limit 0,1;

if @ptimes '' then

create temporary table if not exists sp_tab2(id bigint(20),Nvc_content MEDIUMTEXT,I_userID bigint(20),I_lyuID bigint(20),D_stattime datetime);

INSERT INTO sp_tab2 Select ID,Nvc_content,I_userID,I_tmID,D_stattime from space_operation_stat where status0 and createtime=@ptimes order by D_stattime desc limit 0,30;

select count(*) from sp_tab2 into @cou1id;

set @uoj = 0;

while @cou1id 0 do

select ID,Nvc_content,I_userID,D_stattime,I_lyuID into @io1k,@conui1y,@objipl1k,@crtimh1r,@unlpa from sp_tab2 where ID @uoj order by ID asc limit 0,1;

if @io1k '' then

INSERT INTO space_operation_play(I_statID,Nvc_content,D_stattime,I_userID,Createtime,I_tmID) VALUES (@io1k,@conui1y,@crtimh1r,@objipl1k,now(),@unlpa);

set @uoj = @io1k;

end if;

set @cou1id = @cou1id -1;

end while;

drop temporary table if exists sp_tab2 ;

end if;

end

TS模块化

ts模块化新增：

1.新增export = 变量，用于实现类似commonjs的module.exports=变量，不用default实现默认导出，导入时有两种方法

2.import A =require()，也只有这样才会在ts中出现require语法

3.import A from ' '并开启tsconfig中的esModuleInterop选项，让ts帮忙转换为第一种

4.ts引入外部非ts模块module时，要求模块有类型声明，可以@types/module安装，或自定义：declare module

5.模块解析策略：假设A引用B模块

配置moduleResolution为clissic时：顺序是B.ts、B.d.ts

相对路径：指定目录查找B

非相对：A同级查找B、A上个目录...

配置moduleResolution为node时：ts实现了与node类似规则，顺序是.ts、.jsx、.d.ts

相对路径：指定目录查找B、指定目录的B目录查找pkg的types入口、指定目录的B目录下的index

非相对：先在A同级node_modules下查找B、A同级node_modules下B目录pkg的types入口、A同级node_modules下B目录的index.js，如果以上三步找不到，则从A的上级目录的node_modules重复以上三步

Oracle的触发器，如果包含两个select应该怎么写？

直接写就可以

create or replace trigger checkmodulecount

before insert on registration

for each row

declare

moduleCount number;

ex exception;

begin

select count(moduleid) into moduleCount

from registration r,student s

where r.studentid=:new.studentid

and r.studentid=s.studentid

and (r.semester='2' or r.semester='1');

select lastname into tname from students where studentid=:new.studentid;

if moduleCount 4 then

dbms_output.put_line('Module registered successful');

else

raise ex;

end if;

exception

when ex then

raise_application_error(-20000, 'Student '|| s.lastname|| ' ID '||studentid || ' has register 4 modules already, the number of module for a particular semester should not exceed 4');

end;

问两个关于C语法的超难问题：

这算不上超难把

第一个是一个类型定义，将modeventhand_t这个标识符定义为一个[指向(返回整形值的函数)的指针],这个被指向的函数应该有三个参数，第一个参数类型为module_t,第二个参数类型为int,第三个参数类型为空指针；如果你对指向函数的指针的使用不太熟悉，建议补习下。

第二个是个定义语句，其中\表示换行，也就是表示下一行应该是紧接在这一行后面的，只是为了便于阅读分成多行来写

第二句整个意思就是使用MODULE_METADATA(_md_##name, MDT_MODULE, data, #name); SYSINIT(name##module, sub, order, module_register_init, data) struct __hack

这么一大串东西来替换

DECLARE_MODULE(name, data, sub, order)

其中还有些符号比如##表示连接两个字符串,例如

你写

DECLARE_MODULE(aaaa,bbbb,cccc,dddd);

将会被替换为

MODULE_METADATA(_md_aaaa,MDT_MODULE,bbbb,"aaaa");

SYSINIT(aaaamodule,cccc,dddd,module_register_init,bbbb) struct __hack;

你如果能看一下深入浅出MFC这本书里面关于DECLARE_DYNAMIC这些宏定义的讲解再来看这些就不难了