Hi Friend,
Try the following code:
1)index.jsp:
<html>
<title>Enquiries</title>
<link rel="stylesheet" type="text/css" href="stylesheet.css" media="screen,projection" />
<link rel="stylesheet" style type ="text/css" href ="style.css">
<div style="width:680px; margin:0 auto; height:320px; padding:10px 0; border:solid; position:relative;">
<form id="frmData" name="frmData" action="../ProcessEnquiry" method="post" >
<h2><strong>Enquiry Form</strong></h2>
<table>
<tr><td>Name:</td><td><input type="text" name="name" id="name" /></td></tr>
<tr><td>E-mail:</td><td><input type="text" name="email" id="email" /></td></tr>
<tr><td>Contact No:</td><td><input type="text" name="contact" id="contact" /></td></tr>
<tr><td>Your Enquiry:</td><td><textarea name="enquiry" rows="8" cols="65"></textarea></td></tr>
<tr><td></td><td><input type="submit" value="Submit" /></td></tr>
</table>
</form>
</div>
</html>
2)ProcessEnquiry.java:
import java.io.*;
import java.sql.*;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
public class ProcessEnquiry extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
String strName = request.getParameter("name");
String strEmail =request.getParameter("email");
String strContact = request.getParameter("contact");
String strEnquiry = request.getParameter("enquiry");
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:
mysql://localhost/mysql";, "root", "root");
PreparedStatement pst=con.prepareStatement("insert into enquiry(name,email,contact,enquiry)values(?,?,?,?)");
pst.setString(1,strName);
pst.setString(2,strEmail);
pst.setString(3,strContact);
pst.setString(4,strEnquiry);
pst.executeUpdate();
out.println("Your mail is sent");
out.println("<a href=\"index.jsp\">Click here to return to Home Page");
} catch (Exception e) {
System.out.println(e);
}
}
}
Thanks