This function to use when a Minimum value of a selected Field required (columns and rows).
I make a table named ‘worker’ into a database named ‘dbase’ within the reference of mySql(php my Admin). I import all the required java packages from java library. I use to make a class named ‘MySqlMINFunction’, which extends the ‘HttpServlet’. I use here service()Method which will use to get request from the doGet()Method. Then, i loaded all the required drivers for database accessing. Then after, i declare the variables as first i declare ‘connection’ this variable will be responsible for the creating link between the database and the java code. The other variable will be ‘resultSet’ this will does the job to fetching value from the desired column and rows as required. Then other one i declare ‘preparedStatement’ that will be responsible for executing the selected query like executeQuery() as (SELECT MIN(Salary) AS maxsal FROM worker)). After declaring all the variables i use doGet()Method which will use to get output on the web Browser.
I use ‘HTML’ code and tag in to the java code for output that will present the desired output in a tabular form on the web browser.
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 MySqlMINFunction 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 MIN(Salary) AS minsal FROM worker");
rs = ps.executeQuery();
String title = "Using MIN(Minimum) Function";
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>Salary</th>\n"+ "</body> </html>");
while(rs.next())
{
String mn = rs.getString("minsal");
disp.println("<tr><td align=\"center\">" + mn +"</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>MySqlMINFunction</servlet-name>
<servlet-class>MySqlMINFunction</servlet-class>
</servlet>
<!-- servlet mapping -->
<servlet-mapping>
<servlet-name>MySqlMINFunction</servlet-name>
<url-pattern>/MySqlMINFunction</url-pattern>
</servlet-mapping>
Dinesh Thakur holds an B.C.A, MCDBA, MCSD certifications. Dinesh authors the hugely popular