附上显示所有留言的jsp,想在下面的代码中加入可以实现对每条留言的删除和修改功能,不知道怎么加,求高手帮我完善代码,修改和删除的执行jsp页面不用,我自己写<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*,lyb.*"%>
<html>
<body>
<%
Connection conn = null ;
PreparedStatement pstm = null ;
ResultSet rs= null ;
%>
<%
try
{
conn = ConnectionManager.getConnection() ;
Statement statement=conn.createStatement();
rs=statement.executeQuery("select * from liuyan");%>
<table border="1" width="100%" cellspacing="0" cellpadding="0" align="center">
<tr bgcolor="#FFFFFF">
<td width="18%" height="25" align="center"><i>留言者</i></td>
<td width="20%" height="25" align="center"><i>主题</i></td>
<td width="40%" height="25" align="center"><i>留言内容</i></td><%
while(rs.next())
{
out.println("<TR><td align=center><font size=2>"+rs.getString("name")+"</TD>");
out.println("<TD><font size=2>"+rs.getString("zhuti")+"</font></TD>");
out.println("<TD><font size=2>"+rs.getString("news")+"</font></TD>");
}
rs.close();
conn.close();
}
catch(Exception e)
{
out.println(e.getMessage());
}
%>
</table>
</body>
</html>
<%@ page import="java.sql.*,lyb.*"%>
<html>
<body>
<%
Connection conn = null ;
PreparedStatement pstm = null ;
ResultSet rs= null ;
%>
<%
try
{
conn = ConnectionManager.getConnection() ;
Statement statement=conn.createStatement();
rs=statement.executeQuery("select * from liuyan");%>
<table border="1" width="100%" cellspacing="0" cellpadding="0" align="center">
<tr bgcolor="#FFFFFF">
<td width="18%" height="25" align="center"><i>留言者</i></td>
<td width="20%" height="25" align="center"><i>主题</i></td>
<td width="40%" height="25" align="center"><i>留言内容</i></td><%
while(rs.next())
{
out.println("<TR><td align=center><font size=2>"+rs.getString("name")+"</TD>");
out.println("<TD><font size=2>"+rs.getString("zhuti")+"</font></TD>");
out.println("<TD><font size=2>"+rs.getString("news")+"</font></TD>");
}
rs.close();
conn.close();
}
catch(Exception e)
{
out.println(e.getMessage());
}
%>
</table>
</body>
</html>
{
out.println("<TD><font size=2>"+rs.getString("zhuti")+"</font></TD>");
out.println("<TD><font size=2>"+rs.getString("news")+"</font></TD>");
out.println("<TD><a href="这里写你执行删除的方法,然后带上一个ID传过去,它就删除这个ID的所属数据">删除</a></TD>");
}
JSP上面写SQL语句比较恶心,