Home Whiteboard Practice Code Graphing Calculator Online Compilers Articles Tools
Tutorials Courses Jobs

Which library can be used to interact with database in JSP?

JSP Java Object Oriented Programming Programming

The JSTL SQL tag library provides tags for interacting with relational databases (RDBMSs) such as Oracle, MySQL, or Microsoft SQL Server.

Following is the syntax to include JSTL SQL library in your JSP −



Following table lists out the SQL JSTL Tags −





S.No.
Tag & Description





1
Creates a simple DataSource suitable only for prototyping





2
Executes the SQL query defined in its body or through the sql attribute.





3
Executes the SQL update defined in its body or through the sql attribute.





4





5
Sets a parameter in an SQL statement to the specified java.util.Date value.





6
Provides nested database action elements with a shared Connection, set up to execute all statements as one transaction.





        

        


        
        

            
            

            

                
Updated on: 2019-07-30T22:30:25+05:30

                

                    

                        
                    

                    

                        
 249 Views

                    

                

            

        


    
        

        

            
            
Learn More in Our Tutorials

        

        
    

    
    
    

        

            
Kickstart Your Career

            
Get certified by completing the course

            Get Started
        

        
    


    
    

        
        
    


    
    

        

            
Advertisements