by Dinesh Thakur Category: Servlet with MySql Database

The function 'UCASE' (Upper case) will convert the string or content (Column value's) into Upper Case from Lower case.

For this we make a table named 'worker' into a database named 'dbase' and required columns are filled with values within the reference of mysql(Php myAdmin).after then we import all the required java packages from java Library. After we make a class named 'JavaServletUCASE' which is been extends the "HttpServlet'. then we use serviceMethod() bring request from doGet() method. After that we need to load all the required drivers simultaneously. The variables which are required to make Program Complete have to be declared like Connection variable this will establish the link between database and actual code also known as frontEnd and backEnd concept. The other one is resultSet this variable is responsible for the getting the values from required destination (Columns and rows). The next one is preparedStatement that will responsible for execute the given query like executeQuery() as (Select name,UCASE(name) as UC from worker). And in the last Instance we need to use doGet() method which will bring the output on a web browser.

On the web browser for making Output a manner able look we will use 'HTML' code and tags to bring the Output in tabular form as required.  

EXMPLE

 
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 JavaServletUCASE 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 name,UCASE(name) as UC from worker");
        rs = ps.executeQuery();
                  String title = "Employee's Name in Upper Case";
        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" + "<h3 align=\"center\">" + title + "</h3>\n" + "<ul>\n" +
                            "<table width=\"20%\" border=\"1\" align=\"center\">\n" + "</body> </html>");
        while(rs.next())
            {
             String nm = rs.getString("UC");
                       disp.println("<tr><td align=\"center\">"+ nm +          "</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>JavaServletUCASE </servlet-name>
   <servlet-class>JavaServletUCASE </servlet-class>
</servlet>
<!-- servlet mapping -->
<servlet-mapping>
   <servlet-name>JavaServletUCASE</servlet-name>
   <url-pattern>/JavaServletUCASE </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