by Dinesh Thakur Category: Servlet with MySql Database

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>




About Dinesh Thakur

Dinesh ThakurDinesh Thakur holds an B.SC (Computer Science), MCSE, MCDBA, CCNA, CCNP, A+, SCJP certifications. Dinesh authors the hugely popular blog. Where he writes how-to guides around Computer fundamental , computer software, Computer programming, and web apps. For any type of query or something that you think is missing, please feel free to Contact us.



Related Articles