<%@ 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);
%>
<%@ 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);
%>
解决方案 »
- java能用自带的api实现几张图片生成一张动态的gif吗?
- HTML页面中画线
- SQL通用防注入程序(jsp版)--利用filter
- 错误:java.lang.NegativeArraySizeException
- 关于轨迹查询的问题
- 急救啊!!!在线等!!遇到个函数转换的问题!!!!
- access不注册odbc数据源,放tomcat服务器什么位置呀
- 请问如何得到前10个字?
- 有关javamail的问题
- 请问jsp如何与servlet结合使用
- rar文件下载问题
- if(request.getParameter("ForInsuS").trim().compareTo("ON")==0){sql += "and ForInsu='"+request.getParameter("ForInsuS")+"'";}
Statement stm=con.createStatement();
试一下。可是按你说的好象不是这个错误。out.println (inse);到查询分析器里去试一下 。
将输出的sql 语句放到sql里验证一下。。应该不是大问题