The function name ‘LCASE’ is used to convert the content or strings in lower case of Column value’s.
Firstly we need to make a table named ’emp’ into a database named ‘dbase’. And after that we have to call the java Packages from java library. now to define a class named ‘JavaServletLCASE’ which is been extend ‘HttpServlet’. and we need to be load the driver for database calling.To getting request we need to define serviceMethod().for whole procedure to produce output need to define some mandatory variables like connection (for making link between frontEnd and BackEnd).Resultset which represents the output table of data resulted from a SELECT query. preparedStatement the object of this statement will use to execute the query like executeQuery() it will return the object to resultset for produced output.preparedStatement will execute written query (Select job,LCASE(job) from emp).at the last step we need to call the doGet() for getting request output on a web browser.
To present Output in Impressive look we use tabular form with the help of ‘HTML’ tags this will show output in table form.
Example :
JavaServletLCASE.java
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 JavaServletLCASE 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 job,LCASE(job) as UC from emp");
rs = ps.executeQuery();
String title = "Employee's Job in Lower 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 jb = rs.getString("UC");
disp.println("<tr><td align=\"center\">"+ jb + "</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>JavaServletLCASE </servlet-name>
<servlet-class>JavaServletLCASE </servlet-class>
</servlet>
<!-- servlet mapping -->
<servlet-mapping>
<servlet-name>JavaServletLCASE</servlet-name>
<url-pattern>/JavaServletLCASE </url-pattern>
</servlet-mapping>