汗!代码比较多!但是真的不知道为什么会错,请教高手,十分感谢!!!
<%@ page language="java" contentType="text/html;charset=gb2312"
import="java.util.*,java.sql.*" pageEncoding="GB2312"%><link rel="stylesheet" href="css/code43.css" type="text/css">
<HTML><HEAD>
<title> 查询数据并求和</title>
<script language="javascript">
function buy()
{document.form1.submit();
}
function check(){
var uname = document.all("regname").value;
var name = document.all("hid").value;
var datetype1=/^[0-9]{4}\/[0-9]{1,2}\/[0-9]{1,2}$/;
if(uname!=name)
{
alert("输入的用户不正确");return false;
}
else if(!(datetype1.exec(document.form.xfdate.value))) {
alert("输入的日期格式不正确,请仔细检查!");
document.form.xfdate.focus();
return false;
}
else if(document.form.cqmoney.value=="")
{
alert("金额不能为空");
document.form.cqmoney.focus();
return false;
}
else
{
form.action="cqaction";
form.target="_parent";
form.submit();
}}
</script><META http-equiv=Content-Type content="text/html; charset=gb2312"></HEAD>
<BODY style=scrollbar-arrow-color:#227776;scrollbar-base-color:#C6DCDE text=#000000 bgColor=#ffffff leftMargin=0 topMargin=0 background="img/bg.gif" marginwidth="0" marginheight="0" ><form name="form" method="post">
<div align="center">
<table width="959" height="585" border="0">
<input type="hidden" id="hid" name="hid" value="<%=(String)session.getAttribute("user")%>" />
<tr>
<td height="33" colspan="5" align="right">用户名</td>
<td width="508" height="33" align="right"><label>
<div align="left">
<input type="text" name="regname">
</div>
</label></td>
<td width="82" rowspan="5"> </td>
</tr>
<tr>
<td height="33" colspan="5" align="right">存钱时间</td>
<td height="33" align="right"><label>
<div align="left">
<input type="text" name="cqdate">
</div>
</label></td>
</tr>
<tr>
<td height="33" colspan="5" align="right">存钱银行</td>
<td height="33" align="right"><div align="left">
<select name="cqbank" id="cqbank" >//以下代码报错
<%
request.setCharacterEncoding("gb2312");
String strError = null;
String userid=(String)session.getAttribute("user");
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:goodschaginfo");
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql="select cqselect from selectform where regname like '%"+userid+"%'"; ResultSet rs = stmt.executeQuery(sql);
while(rs.next())
{
%>
<option value="<%=rs.getString("cqselect")%>"> <%=rs.getString("cqselect")%></option>
<%
}
rs.close();
stmt.close();
con.close();
}
catch(ClassNotFoundException e){
strError = e.toString();
}
catch(SQLException e){
strError = e.toString();
}
%>
</select>
</div></td>
</tr>
<tr>
<td height="33" colspan="5" align="right">存多少钱</td>
<td height="33" align="right"><label>
<div align="left">
<input type="text" name="cqmoney">
</div>
</label></td>
</tr>
<tr>
<td height="33" colspan="5" align="right">备注</td>
<td height="33" align="right"><label>
<div align="left">
<input type="text" name="cqbeizhu">
</div>
</label></td>
</tr>
<tr>
<td height="51" colspan="3" align="center"><label>
<input type="submit" name="Submit" value="提交">
</label></td> <td height="51" colspan="3" align="center"><input type="button" name="Submit2" value="返回" onClick="window.history.go(-1);"></td>
</tr>
</table>
</div>
</form>
</TD>
</td>
</tr>
</table></BODY></HTML>
<%@ page language="java" contentType="text/html;charset=gb2312"
import="java.util.*,java.sql.*" pageEncoding="GB2312"%><link rel="stylesheet" href="css/code43.css" type="text/css">
<HTML><HEAD>
<title> 查询数据并求和</title>
<script language="javascript">
function buy()
{document.form1.submit();
}
function check(){
var uname = document.all("regname").value;
var name = document.all("hid").value;
var datetype1=/^[0-9]{4}\/[0-9]{1,2}\/[0-9]{1,2}$/;
if(uname!=name)
{
alert("输入的用户不正确");return false;
}
else if(!(datetype1.exec(document.form.xfdate.value))) {
alert("输入的日期格式不正确,请仔细检查!");
document.form.xfdate.focus();
return false;
}
else if(document.form.cqmoney.value=="")
{
alert("金额不能为空");
document.form.cqmoney.focus();
return false;
}
else
{
form.action="cqaction";
form.target="_parent";
form.submit();
}}
</script><META http-equiv=Content-Type content="text/html; charset=gb2312"></HEAD>
<BODY style=scrollbar-arrow-color:#227776;scrollbar-base-color:#C6DCDE text=#000000 bgColor=#ffffff leftMargin=0 topMargin=0 background="img/bg.gif" marginwidth="0" marginheight="0" ><form name="form" method="post">
<div align="center">
<table width="959" height="585" border="0">
<input type="hidden" id="hid" name="hid" value="<%=(String)session.getAttribute("user")%>" />
<tr>
<td height="33" colspan="5" align="right">用户名</td>
<td width="508" height="33" align="right"><label>
<div align="left">
<input type="text" name="regname">
</div>
</label></td>
<td width="82" rowspan="5"> </td>
</tr>
<tr>
<td height="33" colspan="5" align="right">存钱时间</td>
<td height="33" align="right"><label>
<div align="left">
<input type="text" name="cqdate">
</div>
</label></td>
</tr>
<tr>
<td height="33" colspan="5" align="right">存钱银行</td>
<td height="33" align="right"><div align="left">
<select name="cqbank" id="cqbank" >//以下代码报错
<%
request.setCharacterEncoding("gb2312");
String strError = null;
String userid=(String)session.getAttribute("user");
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:goodschaginfo");
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql="select cqselect from selectform where regname like '%"+userid+"%'"; ResultSet rs = stmt.executeQuery(sql);
while(rs.next())
{
%>
<option value="<%=rs.getString("cqselect")%>"> <%=rs.getString("cqselect")%></option>
<%
}
rs.close();
stmt.close();
con.close();
}
catch(ClassNotFoundException e){
strError = e.toString();
}
catch(SQLException e){
strError = e.toString();
}
%>
</select>
</div></td>
</tr>
<tr>
<td height="33" colspan="5" align="right">存多少钱</td>
<td height="33" align="right"><label>
<div align="left">
<input type="text" name="cqmoney">
</div>
</label></td>
</tr>
<tr>
<td height="33" colspan="5" align="right">备注</td>
<td height="33" align="right"><label>
<div align="left">
<input type="text" name="cqbeizhu">
</div>
</label></td>
</tr>
<tr>
<td height="51" colspan="3" align="center"><label>
<input type="submit" name="Submit" value="提交">
</label></td> <td height="51" colspan="3" align="center"><input type="button" name="Submit2" value="返回" onClick="window.history.go(-1);"></td>
</tr>
</table>
</div>
</form>
</TD>
</td>
</tr>
</table></BODY></HTML>
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: Unable to compile class for JSP: An error occurred at line: 89 in the jsp file: /cunqian.jsp
Duplicate local variable userid
86: <%
87: request.setCharacterEncoding("gb2312");
88: String strError = null;
89: String userid=(String)session.getAttribute("user");
90:
91:
92:
Stacktrace:
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:92)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:423)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:317)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:295)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:282)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:586)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:317)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.18 logs.
你存在session中的是user对象吧!
如果说你存在session中的是user对象,那用String接受,肯定会报错的!
你存在session中的是user对象吧!
如果说你存在session中的是user对象,那用String接受,肯定会报错的!
你存在session中的是user对象吧!
如果说你存在session中的是user对象,那用String接受,肯定会报错的!
Duplicate local variable userid
86: <%
87: request.setCharacterEncoding("gb2312");
88: String strError = null;
89: String userid=(String)session.getAttribute("user");
90:
91:
92: 错误提示说的清清楚楚的
Duplicate local variable userid
重复的本地变量 userid