QuestionAsk Questions?
View Answers
April 28, 2008 at 6:56 PM
Hi friend,
This is form code,
<html>
<head>
<title>display data in servlet</title>
</head>
<body>
<table border="1" width="50%" cellspacing="0" cellpadding="0">
<tr>
<td width="100%">
<h2 align="center"> Display Data In Servlet</h2>
<form method="GET" action="DisplaydataAction">
<table border="1" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="30%"><b>Name:</b></td>
<td width="70%"><input type="text" name="name" size="20"></td>
</tr>
<tr>
<td width="30%"><b>Position :</b></td>
<td width="70%"><input type="text" name="position" size="20"></td>
</tr>
<tr>
<td width="30%"><b>Description:</b></td>
<td width="70%"><textarea rows="7" name="description" cols="30"></textarea></td>
</tr>
</table>
<p><input type="submit" value="Submit" name="submit">
<input type="reset" value="Reset" name="B2"></p>
</form>
</td>
</tr>
</table>
</body>
</html>
-----------------------------
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class DisplaydataAction extends HttpServlet{
public void doGet(HttpServletRequest request, HttpServletResponse response)throws
ServletException, IOException{
response.setContentType("text/html");
PrintWriter out = response.getWriter();
Connection con = null;
String url = "jdbc:mysql://localhost:3306/";;
String db = "register";
String driver = "com.mysql.jdbc.Driver";
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,"root","root");
try{
Statement st = con.createStatement();
String firstname=request.getParameter("name");
String address=request.getParameter("position");
String description=request.getParameter("description");
int val = st.executeUpdate("insert dispalyInfo values(id,'"+firstname+"','"+address+"','"+description+"')");
con.close();
out.println("Successfully insert data in database");
}
catch (SQLException ex){
System.out.println("SQL statement is not executed!");
}
}
catch (Exception e){
e.printStackTrace();
}
}
}
----------------------------------
<servlet>
<servlet-name>displaydata</servlet-name>
<servlet-class>DisplaydataAction</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>displaydata</servlet-name>
<url-pattern>/DisplaydataAction</url-pattern>
</servlet-mapping>
----------------------------------------
read for more information,
http://www.roseindia.net/servlets/
This is form code,
<html>
<head>
<title>display data in servlet</title>
</head>
<body>
<table border="1" width="50%" cellspacing="0" cellpadding="0">
<tr>
<td width="100%">
<h2 align="center"> Display Data In Servlet</h2>
<form method="GET" action="DisplaydataAction">
<table border="1" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="30%"><b>Name:</b></td>
<td width="70%"><input type="text" name="name" size="20"></td>
</tr>
<tr>
<td width="30%"><b>Position :</b></td>
<td width="70%"><input type="text" name="position" size="20"></td>
</tr>
<tr>
<td width="30%"><b>Description:</b></td>
<td width="70%"><textarea rows="7" name="description" cols="30"></textarea></td>
</tr>
</table>
<p><input type="submit" value="Submit" name="submit">
<input type="reset" value="Reset" name="B2"></p>
</form>
</td>
</tr>
</table>
</body>
</html>
-----------------------------
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class DisplaydataAction extends HttpServlet{
public void doGet(HttpServletRequest request, HttpServletResponse response)throws
ServletException, IOException{
response.setContentType("text/html");
PrintWriter out = response.getWriter();
Connection con = null;
String url = "jdbc:mysql://localhost:3306/";;
String db = "register";
String driver = "com.mysql.jdbc.Driver";
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,"root","root");
try{
Statement st = con.createStatement();
String firstname=request.getParameter("name");
String address=request.getParameter("position");
String description=request.getParameter("description");
int val = st.executeUpdate("insert dispalyInfo values(id,'"+firstname+"','"+address+"','"+description+"')");
con.close();
out.println("Successfully insert data in database");
}
catch (SQLException ex){
System.out.println("SQL statement is not executed!");
}
}
catch (Exception e){
e.printStackTrace();
}
}
}
----------------------------------
<servlet>
<servlet-name>displaydata</servlet-name>
<servlet-class>DisplaydataAction</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>displaydata</servlet-name>
<url-pattern>/DisplaydataAction</url-pattern>
</servlet-mapping>
----------------------------------------
read for more information,
http://www.roseindia.net/servlets/
April 28, 2008 at 6:59 PM
Display code,
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class RetriveDataAction extends HttpServlet {
public void doGet(HttpServletRequest req, HttpServletResponse res)throws ServletException, IOException {
Connection con = null;
String url = "jdbc:mysql://localhost:3306/";;
String db = "register";
Statement stmt = null;
ResultSet rs = null;
res.setContentType("text/html");
PrintWriter out = res.getWriter();
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection(url+db,"root","root");
stmt = con.createStatement();
rs = stmt.executeQuery("SELECT name, position,discription FROM dispalyinfo");
out.println("<html><head><title>Display Data from Database</title></head>");
out.println("<body>");
out.println("<table border=1");
out.println("<tr>");
out.println("<td>");
out.println("<html><head><title>" +
"<body bgcolor=\"#FFFFFF\">\n" +
"<table border=1 align=center>\n" +
"<TR bgcolor=\"#8AEAF4\">\n" +
"<td>Name</td><td>Position</td><td>Discription</td>\n");
out.println("<tr>");
while(rs.next()) {
out.println("<h2>Display Data From Database</h2>");
out.println("<td>" + rs.getString("name"));
out.println("<td>" + rs.getString("position"));
out.println("<td>" + rs.getString("discription"));
}
out.println("</td></tr>");
out.println("");
out.println("</table>");
out.println("</td>");
out.println("</tr>");
out.println("</table>");
out.println("</body></html>");
}
catch(ClassNotFoundException e) {
out.println("Couldn't found database driver: " + e.getMessage());
}
catch(SQLException e){
out.println("SQLException caught: " + e.getMessage());
}
finally {
try {
if (con != null) con.close();
}
catch (SQLException sql) {
System.out.println(sql);
}
}
}
}
---------------------------
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class RetriveDataAction extends HttpServlet {
public void doGet(HttpServletRequest req, HttpServletResponse res)throws ServletException, IOException {
Connection con = null;
String url = "jdbc:mysql://localhost:3306/";;
String db = "register";
Statement stmt = null;
ResultSet rs = null;
res.setContentType("text/html");
PrintWriter out = res.getWriter();
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection(url+db,"root","root");
stmt = con.createStatement();
rs = stmt.executeQuery("SELECT name, position,discription FROM dispalyinfo");
out.println("<html><head><title>Display Data from Database</title></head>");
out.println("<body>");
out.println("<table border=1");
out.println("<tr>");
out.println("<td>");
out.println("<html><head><title>" +
"<body bgcolor=\"#FFFFFF\">\n" +
"<table border=1 align=center>\n" +
"<TR bgcolor=\"#8AEAF4\">\n" +
"<td>Name</td><td>Position</td><td>Discription</td>\n");
out.println("<tr>");
while(rs.next()) {
out.println("<h2>Display Data From Database</h2>");
out.println("<td>" + rs.getString("name"));
out.println("<td>" + rs.getString("position"));
out.println("<td>" + rs.getString("discription"));
}
out.println("</td></tr>");
out.println("");
out.println("</table>");
out.println("</td>");
out.println("</tr>");
out.println("</table>");
out.println("</body></html>");
}
catch(ClassNotFoundException e) {
out.println("Couldn't found database driver: " + e.getMessage());
}
catch(SQLException e){
out.println("SQLException caught: " + e.getMessage());
}
finally {
try {
if (con != null) con.close();
}
catch (SQLException sql) {
System.out.println(sql);
}
}
}
}
---------------------------
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
