by Dinesh Thakur Category: Servlet with MySql Database

This Function Will Returns the argument converted to seconds.

First i made a database named 'dbase' within the complete reference of mySql(php myAdmin).then i import all the required java package from java library as program need. Then after i made a class named 'MySqlSecondToTimeFunc' that is been extends the 'HttpServlet'. Then i use to get request from doGet()method the serviceMethod() for output on web browser. Then i loaded all the mandatory drivers for database accessing. After then the next move is to declare variables like i use 'connection' this will use to make a bridge or link between database and the actual code(java code).After then i use 'resultSet' that will be responsible for the getting value from the selected columns and rows. Then i use 'preparedStatement' this will use to executing the selected query like executeQuery as (Select SEC_TO_TIME(5200) AS axact). In the last i use doGet() method that will bring the output on the web browser.

While getting Output on the Web Browser we use 'HTML' Code or some of these tags to present Output in tabular form. 

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 MySqlSecondToTimeFunc 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 SEC_TO_TIME(5200) AS axact");
                    rs = ps.executeQuery();
                String title = "Using SEC_TO_TIME 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>Result</th>\n"+ "</body> </html>");
                    while(rs.next())
                       {
                            String curr = rs.getString(1);
                        disp.println("<tr><td align=\"center\">" + curr +"</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>MySqlSecondToTimeFunc</servlet-name>
   <servlet-class>MySqlSecondToTimeFunc</servlet-class>
</servlet>
<!-- servlet mapping -->
<servlet-mapping>
   <servlet-name>MySqlSecondToTimeFunc</servlet-name>
   <url-pattern>/MySqlSecondToTimeFunc</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