jakarta-taglibs

				
				
				
				
				
				  JSTL: SQL action examples
				
				
				
				SQL Update Execution
				
				
								
								  var="example"
				  driver="${sessionScope.myDbDriver}"
				  url="${sessionScope.myDbUrl}"
				  user="${sessionScope.myDbUserName}"
				  password="${sessionScope.myDbPassword}"
				/>
				
				
				
				
				
				  
				    create table mytable (
				      nameid int primary key,
				      name varchar(80)
				    )
				  
				
				Inserting three rows into table
				  
				    INSERT INTO mytable VALUES (1,'Paul Oakenfold')
				  
				  
				    INSERT INTO mytable VALUES (2,'Timo Maas')
				  
				  
				    INSERT INTO mytable VALUES (3,'Paul van Dyk')
				  
				
				DONE: Inserting three rows into table
				
				
				  
				    SELECT * FROM mytable
				  
				
				
				
				
				
				  
				  
				    
				  
				
				  
				  
				    
				    
				      
				    
				  
				  
				
				
				
				Deleting second row from table
				
				  
				    DELETE FROM mytable WHERE nameid=2
				  
				
				DONE: Deleting second row from table
				
				
				  SELECT * FROM mytable
				
				
				
				
				
				  
				    
				    
				      
				        				        
				        
				          
				        
				        
				      
				    
				    
				    
				      
				      
				    
				  
				  
				
				
				
				
				  drop table mytable