＋设为首页 ＋添加到收藏夹
改一下输入验证，把“发信人姓名”和“标题”相同，而收信人不同的信屏蔽掉，即只提交第一输入，其它雷同的输入不提交，但要对网民透明，不要报任何错误，也要显示结果页。
发信人姓名：AddresserName和标题：MailSubject
收信人：AddresseeName
<%@ page contentType="text/html; charset=gb2312" %>
<%@ include file="database/database.jsp"%>
<HTML>
<HEAD>
<TITLE> 删除或改变记录状态 </TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</HEAD>
<BODY>
<%
//取得入口参数
String AddresserName=request.getParameter("AddresserName");
//out.print(AddresserName);
String AddresserEmailAddress=request.getParameter("AddresserEmailAddress");
String AddresserTelNo=request.getParameter("AddresserTelNo");
String AddresserAddress=request.getParameter("AddresserAddress");
String AddresseeName=request.getParameter("AddresseeName");
String MailSubject=request.getParameter("MailSubject");
String MailContext=request.getParameter("MailContext");
//提交数据
String inse="insert into InMail(AddresserName,AddresserEmailAddress,AddresseeName,MailSubject,MailContext,AddresserTelNo,AddresserAddress) values("+AddresserName+","+AddresserEmailAddress+","+AddresseeName+","+MailSubject+","+MailContext+","+AddresserTelNo+","+AddresserAddress+")";
try
{
stm.executeUpdate(inse);
}
catch(Exception fe)
{
out.print(fe.getMessage());
}
finally{
con.close();
}
//取得中的mailID
response.sendRedirect("listdutyinfo.jsp");
%>
哦~~~明白了，
sorry，应该是
ResultSet rs = stm.executeQuery(查询用的sql)
只有在update时：
int intResult = stm.executeUpdate(更新用的sql);
可以用MSN和我联系：denis@hexa.com.hk
