Advanced Java Project – Web Based SQL Browser
by TechVidvan Team
Program 1
<!DOCTYPE html>
<!--
To change this license header, choose License Headers in Project Properties.
To change this template file, choose Tools | Templates
and open the template in the editor.
-->
<html>
<head>
<title>TODO supply a title</title>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
</head>
<body>
<div>TODO write content</div>
</body>
</html>Program 2
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<center>
<font color="red" size="5">S</font>
<font color="green" size="5">Q</font>
<font color="blue" size="5">L</font>
<font color="black" size="5">B</font>
<font color="red" size="5">R</font>
<font color="blue" size="5">O</font>
<font color="green" size="5">W</font>
<font color="red" size="5">S</font>
<font color="yellow" size="5">E</font>
<font color="blue" size="5">R</font>
<br>
<form method="post" action="testsql.jsp">
<textarea rows="10" cols="100" name="txtsql"></textarea>
<br>
<input type="submit" value="Execute">
</form>
<%
try
{
String sql=null;
sql=request.getParameter("txtsql");
if(sql!=null)
{
Connection con=null;
PreparedStatement ps=null;
ResultSet rs=null;
ResultSetMetaData rsmd=null;
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql:/dataflair", "root", "root@data");
ps=con.prepareStatement(sql);
if(sql.toUpperCase().startsWith("SELECT"))
{
rs=ps.executeQuery();
rsmd=rs.getMetaData();
out.println("<table border=1>");
int i;
for(i=1;i<=rsmd.getColumnCount();i++)
{
out.println("<th>"+rsmd.getColumnName(i)+"</th>");
}
out.println("</tr>");
while(rs.next())
{
out.println("<tr>");
for(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("record affected: " + n);
}
}
}
catch(Exception e)
{
out.println(e);
}
%>
</center>
</body>
</html>
Tags: advanced javaadvanced java practicaladvanced java programadvanced java web based sql browseradvanced java web based sql browser projectweb based sql browser
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.
