<%@ page contentType="text/html; charset=GB2312" %>
<%@ include file="/database/database.jsp"%>
<HTML>
<HEAD>
<TITLE> 删除或改变记录状态 </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
<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");
out.print(AddresserEmailAddress);
String AddresserTelNo=request.getParameter("AddresserTelNo");
out.print(AddresserTelNo);
String AddresserAddress=request.getParameter("AddresserAddress");
out.print(AddresserAddress);
//String AddresserPostalCode=request.getParameter("AddresserPostalCode");
//out.print(AddresserPostalCode);
String AddresseeName=request.getParameter("AddresseeName");
out.print(AddresseeName);
String MailSubject=request.getParameter("MailSubject");
out.print(MailSubject);
String MailContext=request.getParameter("MailContext");
out.print(MailContext);
//提交数据(InMail表)
String inse="insert into  InMail(AddresserName,AddresserEmailAddress,AddresseeName,MailSubject,MailContext,AddresserTelNo,AddresserAddress) values('"+AddresserName+"','"+AddresserEmailAddress+"','"+AddresseeName+"','"+MailSubject+"','"+MailContext+"','"+AddresserTelNo+"','"+AddresserAddress+"')";try
{

//stm.executeUpdate(inse);
stm.executeUpdate(inse);
}
catch(Exception fe)
{
out.print(fe.getMessage());
}%>database.jsp
///////////////
<%@ page import="java.io.*"%> 
<%@ page import="java.util.*"%> 
<%@ page import="java.sql.*"%> 
<% 
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:MayorMailBox";
Connection con=DriverManager.getConnection(url,"wwwuser","wwwuser"); 
Statement stm=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
%>

解决方案 »

  1.   

    上面的如果表没问题的话应该没问题下面的database.jsp好象jdbc-odbc桥不支持jdbc2.0规范也就是说他不能建立 可以滚动和更新的记录集
    Statement stm=con.createStatement();
    试一下。可是按你说的好象不是这个错误。out.println (inse);到查询分析器里去试一下 。
      

  2.   

    改一下   inmail 这个表名试一下。。
    将输出的sql 语句放到sql里验证一下。。应该不是大问题