如何在jsp中实时的显示数据库中记录,比如删除了一个记录以后,关闭掉数据库以后,再次连接调用显示数据库记录时,刚刚删除的记录还是被显示出来了,但是在数据库中确实已经没有了该记录了,有没有什么方法可以实现,比如刷新记录(refresh)什么的拉,请高手指教.50分相送~````````
如下面的程序就是这个问题:
<%@page contentType="text/html;charset=GB2312"%>
<%@page import="java.sql.*"%>
<%!String strSQL="";%>
<html>
<head>
</head>
<body>
<jsp:include page="header.html"/>
<!--运用javabean处理购物车操作处理事件-->
<jsp:useBean id="ResultSetShow" scope="session"
class="UseBean.Database"/>
<%
String BookNo=request.getParameter("DelCarNo");
String name=(String)session.getAttribute("username");//获取会话中已登录用户名
String url="";
url="jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ="+application.getRealPath("BuyData.mdb");
out.println("编号:"+BookNo);
if(BookNo!=null){
out.println("wo lai le");
strSQL="delete from BuyRecord where UserName='"+name+"' and BookNo='"+BookNo+"'";
if(ResultSetShow.UpdateSQL(strSQL,url))
out.println(BookNo+"被删除!"+strSQL);
else
out.println(BookNo+"没有被删除!");
ResultSetShow.CloseDatabase();
}
strSQL="select BookInfor.* from BookInfor,BuyRecord where BookInfor.BookNo=BuyRecord.BookNo and UserName='"+name+"'";
if(ResultSetShow.ExecuteSQL(strSQL,url)){
%>
<!-- 显示购物车里面的书目 -->
<p><font color=red>你的购物车里面的书目:</span></p>
<form action="BuyBook.jsp" method=post>
<table border="1" bordercolor=RoyalBlue align="center" width="60%">
<tr><td><img src="Image/bookno1.jpg"></td>
<td width="10"><img src="Image/bookname1.jpg"></td>
<td><img src="Image/bookauthor1.jpg"></td>
<td><img src="Image/bookpublish1.jpg"></td>
<td><img src="Image/publishdate1.jpg"></td>
<td><img src="Image/bookprice1.jpg"></td>
<td><img src="Image/deleteBook.jpg"></td></tr>
<%
//(ResultSetShow.rs).last();
//(ResultSetShow.rs).beforeFirst();
while((ResultSetShow.rs).next()){
String temptBookNo=(ResultSetShow.rs).getString("BookNo");
%>
<tr><td><%=temptBookNo%></td>
<td><%=(ResultSetShow.rs).getString("BookName")%></td>
<td><%=(ResultSetShow.rs).getString("BookAuthor")%></td>
<td><%=(ResultSetShow.rs).getString("PublishCompany")%></td>
<td><%=(ResultSetShow.rs).getString("PublishDate")%></td>
<td><%=(ResultSetShow.rs).getString("Price")%></td>
<td align="center" valign="middle">
<form action=WatchCar.jsp method=post>
<input type=hidden name=DelCarNo>
<a href=WatchCar.jsp?DelCarNo=<%=temptBookNo%>>删除</a>
</form></td>
</tr>
<%
}
%>
</table>
<%
}
ResultSetShow.CloseDatabase();
%>
<p></p>
<center><input type="submit" value="立即购买"></center>
</form>
<jsp:include page="tail.html"/>
</body>
</html>
如下面的程序就是这个问题:
<%@page contentType="text/html;charset=GB2312"%>
<%@page import="java.sql.*"%>
<%!String strSQL="";%>
<html>
<head>
</head>
<body>
<jsp:include page="header.html"/>
<!--运用javabean处理购物车操作处理事件-->
<jsp:useBean id="ResultSetShow" scope="session"
class="UseBean.Database"/>
<%
String BookNo=request.getParameter("DelCarNo");
String name=(String)session.getAttribute("username");//获取会话中已登录用户名
String url="";
url="jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ="+application.getRealPath("BuyData.mdb");
out.println("编号:"+BookNo);
if(BookNo!=null){
out.println("wo lai le");
strSQL="delete from BuyRecord where UserName='"+name+"' and BookNo='"+BookNo+"'";
if(ResultSetShow.UpdateSQL(strSQL,url))
out.println(BookNo+"被删除!"+strSQL);
else
out.println(BookNo+"没有被删除!");
ResultSetShow.CloseDatabase();
}
strSQL="select BookInfor.* from BookInfor,BuyRecord where BookInfor.BookNo=BuyRecord.BookNo and UserName='"+name+"'";
if(ResultSetShow.ExecuteSQL(strSQL,url)){
%>
<!-- 显示购物车里面的书目 -->
<p><font color=red>你的购物车里面的书目:</span></p>
<form action="BuyBook.jsp" method=post>
<table border="1" bordercolor=RoyalBlue align="center" width="60%">
<tr><td><img src="Image/bookno1.jpg"></td>
<td width="10"><img src="Image/bookname1.jpg"></td>
<td><img src="Image/bookauthor1.jpg"></td>
<td><img src="Image/bookpublish1.jpg"></td>
<td><img src="Image/publishdate1.jpg"></td>
<td><img src="Image/bookprice1.jpg"></td>
<td><img src="Image/deleteBook.jpg"></td></tr>
<%
//(ResultSetShow.rs).last();
//(ResultSetShow.rs).beforeFirst();
while((ResultSetShow.rs).next()){
String temptBookNo=(ResultSetShow.rs).getString("BookNo");
%>
<tr><td><%=temptBookNo%></td>
<td><%=(ResultSetShow.rs).getString("BookName")%></td>
<td><%=(ResultSetShow.rs).getString("BookAuthor")%></td>
<td><%=(ResultSetShow.rs).getString("PublishCompany")%></td>
<td><%=(ResultSetShow.rs).getString("PublishDate")%></td>
<td><%=(ResultSetShow.rs).getString("Price")%></td>
<td align="center" valign="middle">
<form action=WatchCar.jsp method=post>
<input type=hidden name=DelCarNo>
<a href=WatchCar.jsp?DelCarNo=<%=temptBookNo%>>删除</a>
</form></td>
</tr>
<%
}
%>
</table>
<%
}
ResultSetShow.CloseDatabase();
%>
<p></p>
<center><input type="submit" value="立即购买"></center>
</form>
<jsp:include page="tail.html"/>
</body>
</html>
<%
response.setHeader("Pragma","No-cache");
response.setHeader("Cache-Control","no-cache");
response.setDateHeader("Expires", 0);
%>
这样应该就可以了