Student.xml ：
     
     
      
      
      
      
      
       select * fromtbl_student
       
       
       
        select * from tbl_student where id=#id#
        
        
         select name,birth,score from tbl_student where name like'%$name$%'
         
          insert intotbl_student(name,birth,score) values(#name#,#birth#,#score#)
          
           select @@identity as inserted
           
           
           
           
           
           
            
            delete from tbl_student where id=#id#
            
             update tbl_student setname=#name#,birth=#birth#,score=#score# where id=#id#
            
           
          
         
        
       
      
     

　　

     
         
          
              
               
               
               
               
               
               
               
               
               
           
          
                  
          
              
                   
        
                    
        
                    
        
                    
        
                    
        
                
           
          
          
      
               insert into user_lottery_info(gmt_create,gmt_modified,user_id,activity_id,ump_activity_id,win,message,lottery_time,order_id)        values(now(),now(),#userId#,#activityId#,#umpActivityId#,#win#,#message#,now(),#orderId#)        
       
                    select LAST_INSERT_ID()        
           
          
          
      
               update user_lottery_info set win = #win#,message = #message#,gmt_modified=now() where order_id=#orderId#    
          
              select id,activity_id,win,ump_activity_id,user_id,order_id,gmt_create,gmt_modified,lottery_time,message        from user_lottery_info WHERE order_id=#orderId#        
                              
          
          
     

　　这里面有sql语句有关键词select，insert等，类型比较多