Home
Answers
Viewqa
JSP-Servlet
Sending form data from HTML page to SQLserver 2005 database by calling servlet code
QuestionAsk Questions?
phyo ei
Sending form data from HTML page to SQLserver 2005 database by calling servlet code
3 Answer(s) 2 years and 7 months ago
Posted in : JSP-Servlet
3 Answer(s) 2 years and 7 months ago
Posted in : JSP-Servlet
Hi sir,
I would like to know how to send the form data from html page to database by calling servlet code from html page .
View Answers
October 26, 2010 at 10:52 AM
Hello Friend,
Try the following code:
1)callServlet.html:
<html>
<center><h3>Registration Form</h3></center>
<form method="post" action="http://localhost:8080/examples/Registration">
<center>
<table>
<tr><td>ID:</td><td><input type="text" name="userId" size="20"></td></tr>
<tr><td>First Name:</td><td><input type="text" name="firstname" size="20"></td></tr>
<tr><td>Last Name:</td><td><input type="text" name="lastname" size="20"></td></tr>
<tr><td>Email: </td><td><input type="text" name="email" size="20"></td></tr>
<tr><td>City: </td><td><input type="text" name="city" size="20"></td></tr>
<tr><td>State: </td><td><input type="text" name="state" size="20"></td></tr>
<tr><td>Country: </td><td> <input type="text" name="country" size="20"></td></tr>
<tr><td><input type="submit" value="Submit" name="B1"></td><td><input type="reset" value="Reset" name="B2"></td></tr>
</table>
</center>
</form>
</html>
2)Registration.java:
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class Registration extends HttpServlet{
public void init(ServletConfig config) throws ServletException{
super.init(config);
}
public void doPost(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException{
String connectionURL = "jdbc:mysql://localhost:3306/test";
Connection connection=null;
ResultSet rs;
res.setContentType("text/html");
PrintWriter out = res.getWriter();
String uId = req.getParameter("userId");
String fname = req.getParameter("firstname");
String lname = req.getParameter("lastname");
String email = req.getParameter("email");
String state = req.getParameter("state");
String city = req.getParameter("city");
String country = req.getParameter("country");
try{
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection(connectionURL, "root", "root");
String sql = "insert into employee(empid,firstname,lastname,email,state,city,country) values (?,?,?,?,?,?,?)";
PreparedStatement pst = connection.prepareStatement(sql);
pst.setString(1, uId);
pst.setString(2, fname);
pst.setString(3, lname);
pst.setString(4, email);
pst.setString(5, state);
pst.setString(6, city);
pst.setString(7, country);
int numRowsChanged = pst.executeUpdate();
out.println("Hello:");
out.println("'"+fname+"'");
pst.close();
}
catch(Exception e){
out.println(e);
}
}
}
3)Do the servlet mapping in web.xml:
<servlet>
<servlet-name>Registration</servlet-name>
<servlet-class>Registration</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>Registration</servlet-name>
<url-pattern>/Registration</url-pattern>
</servlet-mapping>
Thanks
November 1, 2010 at 10:54 AM
thanks for your answer
April 6, 2012 at 10:51 PM
what is i want to separate many names by semicolon how should i do it in html?
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
