How to auto refresh table inside JSP....
here is the code:-
Code:
<%@ page import="java.sql.*" %>
<%
try{
String driver="sun.jdbc.odbc.JdbcOdbcDriver";
Class.forName(driver);
String url="jdbc:odbc:trial";
Connection con=DriverManager.getConnection(url);
Statement st=con.createStatement();
String sql=("SELECT * FROM signup");
ResultSet rs=st.executeQuery(sql);
%>
<html>
<head>
<title>admin page</title>
</head>
<center>
<div STYLE="background:gray; font: 26pt/30pt courier; font-variant: small-caps; border: thick dashed blue 3px; border-radius:10px; margin-left:300px;margin-right:300px;">
<h2>you'r most welcome to admin page</h2>
</div>
</br>
<h3><b>User Information</b></h3>
<table border="1" height=50 width=350 style="border-radius:10px;">
<tr><td style="border-radius:10px;"><center>FIRSTNAME</center></td>
<td style="border-radius:10px;"><center>LASTNAME<center></td>
<td style="border-radius:10px;"><center>EMAIL<center></td>
<td style="border-radius:10px;"><center>PASSWORDF<center></td>
<td style="border-radius:10px;"><center>SECRETWORD<center></td></tr>
<%
while(rs.next()){
%>
<tr><td><%=rs.getString("FIRSTNAME")%></td>
<td><%=rs.getString("LASTNAME")%></td>
<td><%=rs.getString("EMAIL")%></td>
<td><%=rs.getString("PASSWORD")%></td>
<td><%=rs.getString("SECRETWORD")%></td></tr>
<%
}
%>
<%
}catch(Exception ex){}
%>
</table>
</center>
</html>
