QuestionAsk Questions?
anusha
retrieve the values from the database which you have entered through the form and display
View Answers
April 12, 2011 at 10:31 AM
1)form.jsp:
<html> <form method="post" action="insertdata.jsp"> <table> <tr><td>Name:</td><td><input type="text" name="name"></td></tr> <tr><td>Address:</td><td><input type="text" name="address"></td></tr> <tr><td>Contact No:</td><td><input type="text" name="contact"></td></tr> <tr><td>Email:</td><td><input type="text" name="email"></td></tr> <tr><td></td><td><input type="submit" value="Submit"></td></tr> </table> </form> </html>
2)insertdata.jsp:
<%@page import="java.sql.*,java.util.*"%>
<table>
<%
String name=request.getParameter("name");
String address=request.getParameter("address");
int contact=Integer.parseInt(request.getParameter("contact"));
String email=request.getParameter("email");
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
Statement st=con.createStatement();
int i=st.executeUpdate("insert into employee(name,address,contactNo,email) values('"+name+"','"+address+"',"+contact+",'"+email+"')");
out.println("Data is successfully inserted into database.");
ResultSet rs=st.executeQuery("Select * from employee");
if(rs.last()){
%>
<tr><td>Name</td><td><input type="text" value="<%=rs.getString("name")%>"></td></tr>
<tr><td>Address</td><td><input type="text" value="<%=rs.getString("address")%>"></td></tr>
<tr><td>Contact No</td><td><input type="text" value="<%=rs.getInt("contactNo")%>"></td></tr>
<tr><td>Email</td><td><input type="text" value="<%=rs.getString("email")%>"></td></tr>
<%
}
con.close();
}
catch(Exception e){
System.out.println(e);
}
%>
</table>
Related Pages:
