1201623799703.sql

基于J2EE的办公自动化系统。实现流程定义流程办理等。运用了hibernate+struts+spring框架综合运用的系统。

---事务发起信息
select a.rgrade,a.rtitle,a.rdetail,a.rnexttime,b.utruename,a.rmemo
 from transreq a ,tuser bs where a.uno = b.uno

---事务的各个环节信息
select * from transstep


---事务处理
select a.rgrade as "等级" ,a.tno as "类别编号",a.rdetail as "事务详情",a.rtitle as "事务标题",
b.tname as "事务名称" ,b.tstep as "总步骤数" ,c.sprestep as "当前步骤序号" 
from transreq a inner join transtype b on a.tno = b.rtid 
 inner join transstep c on a.rqid = c.rqid where c.sstatus = '0'

select a.rgrade ,a.tno ,a.rdetail ,a.rtitle ,b.tname,b.tstep ,c.sprestep,a.rlasttime  
from transreq a inner join transtype b on a.tno = b.rtid 
 inner join transstep c on a.rqid = c.rqid where c.sstatus = '0'
 and a.rqid = 



select a.tstep,c.sprestep,a.tname,b.rtitle,b.rdetail,b.rnexttime,
d.utruename ,b.rmemo, c.sname,c.spath  
from 


transtype a inner join transreq b on a.rtid=b.tno 
transstep c ,tuser d
where  and b.rqid = c.rqid   
and  c.uno = d.uno and  b.rqid = 1 and 







select a.tstep,a.tname,b.rgrade,b.tno ,
b. from transtype a 
,transreq b 




select a.rqid,a.rtitle,a.rgrade ,a.rdetail,a.rnexttime,a.uno,a.rmemo, 
b.scurrentid ,b.uno,b.sname,b.spath
from transreq a ,transstep b  where a.rqid = b.rqid