Online Software Educational Training - IT Tutorials - Online Education Training for Computer Software

Home

JAVA JDBC

Search Engine

Here is a program to search any record from the database

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;

public class search extends HttpServlet
{
Connection con;
Statement stmt;
ResultSet rs;
String strsql;
String name;
String dsn;

public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
{
PrintWriter pw = response.getWriter();
dsn="jdbc:odbc:guest";
name = request.getParameter("txtname");
strsql = "select *from info where name='" + name +"'";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException cnfe) { System.out.println("Class Not Found"); }
try{
con = DriverManager.getConnection(dsn,"Guest","");
stmt = con.createStatement();
rs=stmt.executeQuery(strsql);
response.setContentType("text/html");
pw.println("<center>");
rs.next();
pw.println("<h2> User Detail </h2>");
pw.println("</center>");
pw.println("<form name=modi method=post action=http://localhost:8080/servlet/modi>");
pw.println("<input type=text name=txtname value=\""+rs.getString("name")+"\" size=35>");
pw.println("<br>");
pw.println("<input type=text name=txtemail value=\""+rs.getString("email")+"\" size=35>");
pw.println("<br>");
pw.println("<input type=text name=txtdate value=\""+rs.getString("date")+"\" size=35>");
pw.println("<br>");
pw.println("<textarea name=txtcomments rows=10 cols=60>" +rs.getString("comment")+"

"); pw.println("
"); pw.println("
"); pw.println(" "); pw.close(); rs.close(); stmt.close(); con.close(); }catch(SQLException sqle) { System.out.println("There is an error " + sqle); } } }


Previous		Next