Advanced Java Project – Web Based SQL Query Browser
by TechVidvan Team
Program 1
package browser;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.*;
public class SQLQueryBrowser extends HttpServlet {
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
try (PrintWriter out = response.getWriter()) {
/* TODO output your page here. You may use following sample code. */
out.println("<!DOCTYPE html>");
out.println("<html>");
out.println("<head>");
out.println("<title>Servlet SQLQueryBrowser</title>");
out.println("</head>");
out.println("<body>");
out.println("<h1>Servlet SQLQueryBrowser at " + request.getContextPath() + "</h1>");
out.println("</body>");
out.println("</html>");
}
}
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
PrintWriter out = response.getWriter();
out.println("<html>");
out.println("<head>");
out.println("<title>Servlet SQLQueryBrowser</title>");
out.println("</head>");
out.println("<body>");
out.println("<center>");
out.println("<font color=red size=7>S</font>");
out.println("<font color=black size=7>Q</font>");
out.println("<font color=green size=7>L</font>");
out.println("<font color=red size=7>B</font>");
out.println("<font color=yellow size=7>R</font>");
out.println("<font color=blue size=7>O</font>");
out.println("<font color=red size=7>W</font>");
out.println("<font color=blue size=7>S</font>");
out.println("<font color=green size=7>E</font>");
out.println("<font color=black size=7>R</font>");
out.println("<form method=post action=SQLQueryBrowser>");
out.println("<textarea rows=20 cols=100 name=txtsql></textarea>");
out.println("<br>");
out.println("<input type=submit value=Execute>");
out.println("</form>");
out.println("</center>");
out.println("</body>");
out.println("</html>");
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
PrintWriter out = response.getWriter();
try
{
out.println("<html>");
out.println("<head>");
out.println("<title>Servlet SQLQueryBrowser</title>");
out.println("</head>");
out.println("<body>");
out.println("<center>");
out.println("<font color=red size=7>S</font>");
out.println("<font color=black size=7>Q</font>");
out.println("<font color=green size=7>L</font>");
out.println("<font color=red size=7>B</font>");
out.println("<font color=yellow size=7>R</font>");
out.println("<font color=blue size=7>O</font>");
out.println("<font color=red size=7>W</font>");
out.println("<font color=blue size=7>S</font>");
out.println("<font color=green size=7>E</font>");
out.println("<font color=black size=7>R</font>");
out.println("<form method=post action=SQLQueryBrowser>");
out.println("<textarea rows=20 cols=100 name=txtsql></textarea>");
out.println("<br>");
out.println("<input type=submit value=Execute>");
out.println("</form>");
String sql;
sql=request.getParameter("txtsql");
// out.println(sql);
Connection con=null;
PreparedStatement ps=null;
ResultSet rs=null;
ResultSetMetaData rsmd=null;
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://localhost/dataflair","root","root@data");
ps=con.prepareStatement(sql);
if(sql.toUpperCase().startsWith("SELECT"))
{
rs=ps.executeQuery();
rsmd=rs.getMetaData();
//out.println(rsmd.getColumnCount());
out.println("<table border=1>");
out.println("<tr>");
for(int i=1;i<=rsmd.getColumnCount();i++)
out.println("<th>"+rsmd.getColumnName(i)+"</th>");
out.println("</tr>");
while(rs.next())
{
out.println("<tr>");
for(int i=1;i<=rsmd.getColumnCount();i++)
out.println("<td>"+rs.getString(i)+"</td>");
out.println("</tr>");
}
out.println("</table>");
}
else
{
int n=0;
n=ps.executeUpdate();
out.println("<B>record affect: </B>" +n);
}
out.println("</center>");
out.println("</body>");
out.println("</html>");
}
catch(Exception e)
{
out.println(e);
}
}
@Override
public String getServletInfo() {
return "Short description";
}// </editor-fold>
}
Tags: advanced javaadvanced java practicaladvanced java programadvanced java projectadvanced java web based sql query browseradvanced java web based sql query browser projectweb based sql query browserweb based sql query browser project
TechVidvan Team
TechVidvan Team provides high-quality content & courses on AI, ML, Data Science, Data Engineering, Data Analytics, programming, Python, DSA, Android, Flutter, full stack web dev, MERN, and many latest technology.
