JDBC Exercise

Create a HTML page which accepts book id, book name and book price and a submit button. When the user clicks the submit button, all the values assigned to the previous text fields must be stored in the database.

Source Code

books.html

StoreBookDetails.java

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * Servlet implementation class OracleServ
 */
public class OracleServ extends HttpServlet {
	private static final long serialVersionUID = 1L;
	   
	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException 
	{
		String id = request.getParameter("txtbookid");
		String name = request.getParameter("txtbooktitle");
		String price = request.getParameter("txtbookprice");
		try
		{
			Class.forName("oracle.jdbc.driver.OracleDriver");
			Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "system", "123456");
			Statement st = con.createStatement();
			String query = "insert into books values(" + id + "," + name + "," + price + ")";
			int result = st.executeUpdate(query);
			if(result >= 1)
				response.getWriter().print("Book details stored successfully");
			con.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
}

Starter Tutorials

Problem Statement

Source Code

books.html

StoreBookDetails.java