J2EE

i want to make use of check box and radio button and i want the details to be submitted into the database server. moreso, i want you to teach me how to use request dispatcher and session object.

thanks

View Answers

February 6, 2010 at 3:51 PM

Hi Friend,

Try the following code:
1)form.jsp:

<html>
<form name="form" action="insert.jsp" method="post">
<table>
<tr><td>Enter Name</td><td><input type="text" name="name"></td></tr>
<tr><td>Enter Address</td><td><textarea rows="4" cols="8" name="address"></textarea></td></tr>
<tr><td>Gender</td><td><input type="radio" name="radio">M<input type="radio" name="radio">F</td></tr>
<tr><td>Qualification</td><td><select name="qua"><option value="BTech">BTech</option><option value="BTech">MBA</option><option value="BTech">MCA</option><option value="BTech">MTech</option></select></td></tr>
<tr><td>Languages</td><td><input type="checkbox" name="lang" value="Hindi">Hindi<input type="checkbox" name="lang" value="English">English<input type="checkbox" name="lang" value="French">French<input type="checkbox" name="lang" value="German">German</td></tr>
<tr><td><input type="submit" value="Submit" ></td><td><input type="reset"></td></tr>
</table>
</form>
</html>

2)insert.jsp:
<%@page import="java.sql.*"%>
<%
String name=request.getParameter("name");
String address=request.getParameter("address");
String g=request.getParameter("radio");
String qualif=request.getParameter("qua");
String languages[]=request.getParameterValues("lang");
String lang="";
for(int i=0;i<languages.length;i++){
lang+=languages[i]+" ";
}
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/register";, "root", "root");
Statement stmt = con.createStatement();
int j=stmt.executeUpdate("insert into person1(name,address,gender,qualification,languages) values('"+name+"','"+address+"','"+g+"','"+qualif+"','"+lang+"')");
out.println("Data is inserted sucessfully");
}
catch(Exception e){}
%>

February 6, 2010 at 3:53 PM

continue........

RequestDispatcher:

RequestDispatcher defines an object that receives requests from the client and sends them to any resource (such as a servlet, HTML file, or JSP file) on the server. The servlet container creates the RequestDispatcher object, which is used as a wrapper around a server resource located at a particular path or given by a particular name.

The include method of the RequestDispatcher interface may be called at ANY time. The target servlet of the include method has access to all aspects of the request object, but its use of the response object is more limited. It can only write information to the ServletOutputStream or Writer of the response object and commit a response by writing content past the end of the response buffer, or by explicitly calling the flushBuffer method of the ServletResponse interface. It CANNOT set headers or call any method that affects the headers of the response. Any attempt to do so must be ignored.

The forward method of the RequestDispatcher interface may be called by the calling servlet ONLY when NO output has been committed to the client. If output data exists in the response buffer that has not been committed, the content must be cleared before the target servlet's service method is called. If the response has been committed, an IllegalStateException must be thrown.

For sessions, visit the following link:

http://www.roseindia.net/jsp/jspsession/
http://www.roseindia.net/jsp/

Thanks