The Query ‘LIMIT’ will fetch the limited coloumns as required.
In the starting of Program we need to import all the Required Packages from the java library.then to declare a class named ‘JavaServletLIMITQuery’ which is been extends ‘HttpServlet’. after then we have to use serviceMethod() which is responsible for the Getting request for Output. then load drivers and create an Object of resultSet which will useful to show the table result as an Output.Connection variable also to be declared for interact between database and actual code as like in between frontEnd and backEnd.now on other hand preparedStatement will be use for executing query like executeQuery() like this (SELECT last_name, salary FROM inq LIMIT 2). and to fetch the result on web browser doGet() method will be initialize.
Now to getting Output in designer Look we need to use ‘HTML’ tags to put all the Output in Tabular form on a web Browser.
EXAMPLE
JavaServletLIMITQuery.java
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class JavaServletLIMITQuery extends HttpServlet
{
public void service(HttpServletRequest rq, HttpServletResponse rp)throws IOException, ServletException
{
rp.setContentType("text/html");
PrintWriter disp = rp.getWriter();
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost/dbase";
String uid = "root";
String psw = "root";
Connection con=null;
PreparedStatement ps = null;
ResultSet rs;
try
{
Class.forName(driver);
con = DriverManager.getConnection(url,uid,psw);
ps=con.prepareStatement("SELECT last_name, salary FROM inq LIMIT 2");
rs = ps.executeQuery();
String title = "Employee's Info With The Refrence Of In Beetween Query ";
String docType ="<!doctype html public \"-//w3c//dtd html 4.0 " + "transitional//en\">\n";
disp.println(docType + "<html>\n" + "<head><title>" + title + "</title></head>\n" +
"<body bgcolor=\"#f4efef\">\n" + "<h1 align=\"center\">" + title + "</h1>\n" + "<ul>\n" +
"<table width=\"50%\" border=\"1\" align=\"center\">\n" + "<th>Last Name</th><th>Salary</th>\n"+ "</body> </html>");
while(rs.next())
{
String l_name = rs.getString("last_name");
int sal = rs.getInt("salary");
disp.println("<tr><td align=\"center\">" + l_name + "<td align=\"center\">" + sal +"</td></tr>" );
}
}
catch(Exception e)
{
e.printStackTrace();
}
disp.close();
}
public void doPost(HttpServletRequest rq,HttpServletResponse rp)throws IOException,ServletException
{
doGet(rq,rp);
}
}
web.XML
<servlet>
<servlet-name>JavaServletLIMITQuery</servlet-name>
<servlet-class>JavaServletLIMITQuery</servlet-class>
</servlet>
<!-- servlet mapping -->
<servlet-mapping>
<servlet-name>JavaServletLIMITQuery</servlet-name>
<url-pattern>/JavaServletLIMITQuery </url-pattern>
</servlet-mapping>
Dinesh Thakur holds an B.C.A, MCDBA, MCSD certifications. Dinesh authors the hugely popular