SQL SHOW系列（三）

1.  
2. String sql =  " INSERT INTO BO_APPROVEINFO_VER " 
3.                    + " ( BO_APPROVEINFO_VER_ID," 
4.                    + " VER_APPID," 
5.                    + " APPID," 
6.                    + " FX_APPROVERESULT," 
7.                    + " FX_ROLENAME," 
8.                    + " FX_APPROVEDATE," 
9.                    + " FX_APPROVEPERSON," 
10.                    + " FX_APPROVEIDEA," 
11.                    + " FX_ROLEAPPROVEORDER," 
12.                    + " FX_WORKNAME," 
13.                    + " FX_TRATAG," 
14.                    + " BO_APPROVEINFO_ID," 
15.                    + " CUR_TASKID," 
16.                    + " NEXT_TASKID," 
17.                    + " FX_APPROVEPERSONID," 
18.                    + " PARENT_APPID )" 
19.                    + " (SELECT SYS_GUID()," 
20.                    + " NULL VER_APPID," 
21.                    + " APPID," 
22.                    + " A.FX_APPROVERESULT," 
23.                    + " A.FX_ROLENAME," 
24.                    + " A.FX_APPROVEDATE," 
25.                    + " A.FX_APPROVEPERSON," 
26.                    + " A.FX_APPROVEIDEA," 
27.                    + " A.FX_ROLEAPPROVEORDER," 
28.                    + " A.FX_WORKNAME," 
29.                    + " A.FX_TRATAG," 
30.                    + " A.BO_APPROVEINFO_ID," 
31.                    + " A.CUR_TASKID," 
32.                    + " A.NEXT_TASKID," 
33.                    + " A.FX_APPROVEPERSONID," 
34.                    + " A.PARENT_APPID " 
35.                    + " FROM (SELECT *" 
36.                    + " FROM BO_APPROVEINFO T" 
37.                    + " WHERE " 
38.                    + " T.APPID = '" + investPlanId //取该年度投资Id的所有审批信息 
39.                    + "' ) A)"; 

     本文转自danni505 51CTO博客，原文链接：http://blog.51cto.com/danni505/404150，如需转载请自行联系原作者