by Dinesh Thakur Category: Servlet with MySql Database

The function 'ACOS' returns the cosine of numeric expression.

First we make a table in database named 'dbase' with required fields with in the reference of mySql(php myAdmin).Next step will be to import the required packages from the java library. After then we make a class named 'MySqlACOSFunction' which is extends the 'HttpServlet'.And then we use serviceMethod() which will access the granting for getting request from doGet()Method. Then load all the required Drivers.After that we declare some mandatory variable to access control on the program like Connection (The Connection variable will be used to create a link between the database and the actual code(backend and the frontend).the other variable is resultSet this variable is responsible for the fetching value from required columns and rows. and the last variable known as preparedStatement is used to execute the query like executeQuery() as (Select ACOS('1')).and to present the output we use doGet()Method which provide the output on the Web Browser.

To make output efficient we use 'HTML' Code or some of it's tag which will bring the output in tabular form or in a manner way on the web Browser.

 
EXAMPLE
 
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 MySqlACOSFunction 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 ACOS('1')");
          rs = ps.executeQuery();
              String title = "Using ACOS 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>Value</th>\n"+ "</body> </html>");
          while(rs.next())
             {
               String val = rs.getString(1);
                   disp.println("<tr><td align=\"center\">" + val +"</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>MySqlACOSFunction</servlet-name>
   <servlet-class>MySqlACOSFunction</servlet-class>
</servlet>
<!-- servlet mapping -->
<servlet-mapping>
   <servlet-name>MySqlACOSFunction</servlet-name>
   <url-pattern>/MySqlACOSFunction</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