Hi friend,


package javacode;

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

public class RetriveValue extends HttpServlet{
public void doGet(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException{
response.setContentType("text/html");
PrintWriter pw = response.getWriter();
Connection con = null;
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "amar";
String driver = "com.mysql.jdbc.Driver";
String userName ="amar";
String password="amar123";
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,userName,password);
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("Select userid, name, dept_name, date from userSearch WHERE userid='102'");
while(rs.next()){
pw.println("userid" + " " + "name" + " "+"dept_name"+" " + "date" +"<br>");
pw.println(rs.getInt(1) + " " + rs.getString(2) +" "+ rs.getString(3) +" "+rs.getString(4) +"<br>");

}
}
catch (Exception e){
pw.println(e);
}
}
}

-------------------------------------------------------

Read for more information,

http://www.roseindia.net/servlets/

Thanks.