关于JSTL的标签信息可以查看《》

直接上代码：

<%@ page language="java" contentType="text/html; charset=UTF-8"    pageEncoding="UTF-8"%><%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%><%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%><%   pageContext.setAttribute("testId", "123");%>
     
         
查询数据
    
     
          select id,name from table1    
         
                 
     
     
              
       
                    
ID
                    
Name
               
               
                        
         
                        
         
                   
                  
     
    
     
    
插入数据
    
     
         insert into table1(id,name) values(?, 'testName')   
          
         
影像记录条数：${result}
    
     
         select id,name from table1   
         
                 
     
     
              
       
                    
ID
                    
Name
               
               
                        
         
                        
         
                   
                  
     
    
     
    
修改数据
    
     
         update table1 set name = 'Name' where id = ?   
          
         
影像记录条数：${result}
    
     
         select id,name from table1   
         
                 
     
     
              
       
                    
ID
                    
Name
               
               
                        
         
                        
         
                   
                  
     
    
     
    
删除数据
    
     
         delete from table1 where id = ?   
          
         
影像记录条数：${result}
    
     
         select id,name from table1   
         
                 
     
     
              
       
                    
ID
                    
Name
               
               
                        
         
                        
         
                   
                  
     

运行结果