QuestionAsk Questions?
sateeshvaddada
Good Evening sir/madam,
I want to add data dynamically for that which methods i have to use to retrieve the dynamic data .
I want to add data dynamically for that which methods i have to use to retrieve the dynamic data .
View Answers
February 8, 2010 at 5:03 PM
Hi Friend,
Try the following code:
1)get.jsp:
<html>
<form method="post" action="../InsertAndRetrieveData">
<table>
<tr><td>Enter Name:</td><td><input type="text" name="name"></td></tr>
<tr><td>Enter Address:</td><td><input type="text" name="address"></td></tr>
<tr><td><input type="submit" value="Submit"></td></tr>
</table>
</form>
</html>
2)InsertAndRetrieveData.java:
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
public class InsertAndRetrieveData extends HttpServlet{
public void doPost(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException{
res.setContentType("text/html");
PrintWriter out=res.getWriter();
String name=req.getParameter("name");
String address=req.getParameter("address");
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/register","root","root";);
Statement st=con.createStatement();
int i=st.executeUpdate("insert into data(name,address) values('"+name+"','"+address+"')");
st.close();
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("Select * from data");
while(rs.next()){
out.println(rs.getString("name")+" "+rs.getString("address")+"<br>");
}
st.close();
}
catch(Exception e){}
}
public void doGet(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException
{doPost(req,res);}
}
Thanks
Try the following code:
1)get.jsp:
<html>
<form method="post" action="../InsertAndRetrieveData">
<table>
<tr><td>Enter Name:</td><td><input type="text" name="name"></td></tr>
<tr><td>Enter Address:</td><td><input type="text" name="address"></td></tr>
<tr><td><input type="submit" value="Submit"></td></tr>
</table>
</form>
</html>
2)InsertAndRetrieveData.java:
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
public class InsertAndRetrieveData extends HttpServlet{
public void doPost(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException{
res.setContentType("text/html");
PrintWriter out=res.getWriter();
String name=req.getParameter("name");
String address=req.getParameter("address");
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/register","root","root";);
Statement st=con.createStatement();
int i=st.executeUpdate("insert into data(name,address) values('"+name+"','"+address+"')");
st.close();
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("Select * from data");
while(rs.next()){
out.println(rs.getString("name")+" "+rs.getString("address")+"<br>");
}
st.close();
}
catch(Exception e){}
}
public void doGet(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException
{doPost(req,res);}
}
Thanks
February 8, 2010 at 5:04 PM
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
