Servlet to add the data into database
In this program we are going to insert the
data in the database table from a html form.
This servlet program works
with HTML form in which there are two fields one is for name and the other one is for entering
password.
In HTML form there is a submit button, clicking on which the values will be passed to the server.
The data entered from the HTML form will be retrieved by the server side program
i.e. servlet.
For servlet program we first need to make a class named as DataInsertionIntoDatabase
that extends the abstract HttpServlet class,
By the name of the class other person can understand what the program is going to
perform.
The servlet code written inside the doGet() method takes two arguments, first is HttpServletRequest and the second one is the HttpServletResponse, this method can throw ServletException.
This method calls the getWriter() method of PrintWriter class.
The data can be inserted
in the database that reacquired connection between database and java program.
Database connection between database and the java program
need the method forName() that is static in nature, this takes one argument which
informs about the database driver that is to be used. Now work of static method getConnection()
that is from DriverManager class. This method returns the connection object.
The method preparedStatement() obtained from the Connection object, returns the PreparedStatement object.
It procces the SQL query. HTML form passes the input to be set in the database with help of
setString() method.
In the case if data is inserted successfully in the table then the output
looks like this
"Data has been inserted" otherwise "failed to insert the data".
The code of the program is given below:
<html>
<head>
<title>New Page 1</title>
</head>
<body bgcolor="#999966">
<form method="POST" action="/userregister/DataInsertionIntoDatabase">
<!--webbot bot="SaveResults" U-File="fpweb:///_private/form_results.txt"
S-Format="TEXT/CSV" S-Label-Fields="TRUE" -->
<% int count= 0;%>
<input type="hidden" name="id" value="count">
<p>Enter Name: <input type="text"
name="uname" size="20"></p>
<p>Enter Password: <input type="text" name="password" size="20"></p>
<p>
<input type="submit" value="Submit" name="B1"></p>
</form>
</body>
</html> |
DataInsertionIntoDatabase .java
package myservlets;
import java.io.*;
import java.lang.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class DataInsertionIntoDatabase extends HttpServlet{
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException{
response.setContentType("text/html");
PrintWriter pw = response.getWriter();
String connectionURL = "jdbc:mysql://localhost/jsp";
Connection connection;
try{
String id = request.getParameter("id");
String uname = request.getParameter("uname");
String password = request.getParameter("password");
pw.println(uname);
pw.println(password);
Class.forName("org.gjt.mm.mysql.Driver");
connection = DriverManager.getConnection(connectionURL, "root", "root");
PreparedStatement pst = connection.prepareStatement("insert into login values(?,?,?)");
pst.setString(1,id);
pst.setString(2,uname);
pst.setString(3,password);
int i = pst.executeUpdate();
if(i!=0){
pw.println("<br>Date has been inserted in to Datebase");
}
else{
pw.println("failed to insert the data");
}
}
catch (Exception e){
pw.println(e);
}
}
} |
web.xml file for this program:
<?xml version="1.0" encoding="ISO-8859-1"?>
<web-app xmlns="http://java.sun.com/xml/ns/j2ee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_5.xsd"
version="2.5">
<description>
Servlet to add the data into database
</description>
<display-name>Servlet to add the data into database</display-name>
<context-param>
<param-name>User</param-name>
<param-value>RoseIndia</param-value>
</context-param>
<servlet-name>DataInsertionIntoDatabase</servlet-name>
<servlet-class>myservlets.DataInsertionIntoDatabase</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>DataInsertionIntoDatabase</servlet-name>
<url-pattern>/DataInsertionIntoDatabase</url-pattern>
</servlet-mapping>
</web-app> |
The output of the program is given below:
This is the output of the above input.
Download Source Code
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
