Updating and retrieving data from java servlet to sql database
My SQL is a popular open source database management system commonly used in web applications due to its speed, flexibility and reliability.
My SQL employs SQL, or , for accessing and processing data contained in databases.
After preparing the data source and connection pool for the server, you then need to instruct the application to use the data source.
This is typically done by creating an entry in the application's , then populates them with sample data.
In this tutorial, we use Web Logic 7.0 for the servlet container and Oracle 8.1.7 for the database, although you can use other databases and JSP-compliant web servers.In each of these pages you use HTML and CSS to implement a simple interface, and apply JSTL technology to perform the logic that directly queries the database and inserts the retrieved data into the two pages.The two database tables, database table, and inserts it into to the page before it is sent to the browser.If you have not already done this, or if you need help with this task, see Connecting to a My SQL Database before proceeding further.Also, your database needs to be password-protected to create a data source and work with the Glass Fish server in this tutorial.
Essentially, it is the My SQL Connector/J JDBC Driver that enables communication between the Java code understood by the application server (the Glass Fish server), and any content in SQL, the language understood by the database server (My SQL).