by Dinesh Thakur Category: Servlet with MySql Database

The function 'Sort Ascending by Order' will does the sorting order by given command(column) in ascending Order.

First we make a table named 'org' into a databse named 'dbase' within the reference of mySql(php Myadmin).Now To make it happen first we need to import all required java packages from java library. Then to make a class named 'JavaServletSortASC' which is been extends the 'HttpServlet'.Now we need to declare serviceMethod() which getting the request from doGet() for Output.And after that we need to load all the drivers for mandatory Conditions.after that all the required variable must have to be declared like connection,resultset,preparedStatement. Connection variable use to establish connection between database and java code (frontEnd and BackEnd).the variable named Resultset interface provides getting methods for retrieving column values from the given rows.the variable. preparedStatement will execute the given query like executeQuery() like as 'SELECT last_name, job_id, dept_id, hire_date FROM org ORDER BY hire_date ASC'. And now we will use the doGet() method to fetch the result on a web Browser.

On the web Browser for an efficient look we use the 'HTML' coding and some of these tags to present the output in tabular form.

EXAMPLE

JavaServletSortASC
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.DriverManager;
import java.util.*;
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 JavaServletSortASC 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, job_id, dept_id, hire_date FROM org ORDER BY hire_date ASC");
              rs = ps.executeQuery();
                        String title = "Employee's Data In Ascending Order";
              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>Job Id</th><th>Department ID</th><th>Hire Date</th>\n"+   "</body></html>");
             while(rs.next())
                 {
                     String l_name = rs.getString("last_name");
                               int j_id = rs.getInt("job_id");
                               int d_id = rs.getInt("dept_id");
                                         int dt = rs.getInt("hire_date");
                     disp.println("<tr><td align=\"center\">"+ l_name +"<td align=\"center\">" + j_id +  "<td align=\"center\">" + d_id + 
                     "<td align=\"center\">" + dt + "</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>JavaServletSortASC</servlet-name>
   <servlet-class>JavaServletSortASC</servlet-class>
</servlet>
<!-- servlet mapping -->
<servlet-mapping>
   <servlet-name>JavaServletSortASC</servlet-name>
   <url-pattern>/JavaServletSortASC</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