哎 !! 是啊 才学的 ! 经大家提醒错误全部查出来了 就是{, }等 拼写错误! 我会把编程风格做好啊!多谢大家!不过做后又出了个问题:请看下面 就这个问题了500 Servlet Exception java.sql.SQLException: Column not found at sun.jdbc.odbc.JdbcOdbcResultSet.findColumn(JdbcOdbcResultSet.java:1852) at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:413) at _jsp._index__jsp._jspService(/index.jsp:128) at com.caucho.jsp.JavaPage.service(JavaPage.java:75) at com.caucho.jsp.Page.pageservice(Page.java:571) at com.caucho.server.dispatch.PageFilterChain.doFilter(PageFilterChain.java:155) at com.caucho.server.cache.CacheFilterChain.doFilter(CacheFilterChain.java:177) at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:177) at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:221) at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:263) at com.caucho.server.port.TcpConnection.run(TcpConnection.java:331) at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:464) at com.caucho.util.ThreadPool.run(ThreadPool.java:408) at java.lang.Thread.run(Thread.java:534) -------------------------------------------------------------------------------- Resin-3.0.8 (built Tue, 08 Jun 2004 02:25:40 PDT)
<jsp:useBean id="beenetConnection" scope="page" class="beenet.beenetguestbook.beenetConnection"/>
<%
Boolean a=(Boolean)session.getAttribute("a");
Connection con=beenetConnection.getConnectionToAccess(application.getRealPath("/data/beenetguestbook.mdb"));
Statement stm=con.creatStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,Resultset.CONCUR_READ_ONLY);
%><html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>BEENET留言本-显示留言</title>
<style type="text/css">
<!--
body {
border: 1px 1 #CCCCCC;
}
.bian {
border-top-width: 1px;
border-top-style: solid;
border-top-color: #969696;
border-bottom-width: 1px;
border-bottom-style: solid;
border-bottom-color: #999999;
}
.f12 {
font-family: "宋体";
font-size: 12px;
color: #000000;
text-decoration: none;
line-height: 23px;
height: auto;
}
.bian1 {
border-right-width: 1px;
border-left-width: 1px;
border-right-style: solid;
border-left-style: solid;
border-right-color: #969696;
border-left-color: #969696;
}
a:link {
font-family: "宋体";
font-size: 12px;
color: #333333;
text-decoration: none;
}
a:visited {
font-family: "宋体";
font-size: 12px;
color: #333333;
text-decoration: none;
}
a:hover {
font-family: "宋体";
font-size: 12px;
color: #333333;
text-decoration: underline;
}
a:active {
font-family: "宋体";
font-size: 12px;
color: #333333;
text-decoration: none;
}
input {
font-size: 12px;
}
button {
margin: 1px;
padding: 1px;
border: 1px solid #CCCCCC;
background-color: #CCCCCC;
}
-->
</style>
<script language="javascript">
function checks(){
if(post1.password.value== "")
{
alert("密码不能为空");
return false;
}
if(post1.password.value.length>20)
{
alert("密码不能超过20个字符");
return flase;
}
return true;
}
</script>
<SCRIPT language=JavaScript>
<!--
function go(src,q)
{
var ret;
ret = confirm(q);
if(ret!=false)window.location=src;
}function openwin(url, width, height)
{
var Win = window.open(url,"openScript",'width=' + width + ',height=' + height + ',resizable=0,scrollbars=1,menubar=0,status=1');
}function openreply()
{
document.viewreply.replycodes.value=document.replyform.replycode.value;
var popupWin = window.open('Viewreply.asp', 'viewreply_page', 'scrollbars=yes,width=700,height=450');
document.viewreply.submit()
}
-->
</script>
</head>
<body>
<table width="82%" height="38" align="center" cellpadding="0" cellspacing="0" bordercolor="0">
<form action="loginpost.jsp" name="post1" method="post" id="post1" onSubmit="return checks();">
<td height="6"><table width="90%" height="25" border="0" cellpadding="0" cellspacing="0">
<tr>
<%
String sql1="select * from admin where id=1";
ResultSet rs1=stm.executeQuery(sql1);
while(rs1.next())
{
%>
<td height="25"><p><strong>|</strong><a href="<%=rs1.getString("url")%>" ><font size="3"><%=rs1.getString("size")%><font size="2">欢迎光临<%=rs1.getString("site")%></font></font></a><font size="3"><strong>|</strong><font size="2">你的IP是<%=request.getRemoteAddr()%><strong>|</strong>
<%
if(a==null||a.booleanValue()==false)
{
%>
管理员: <a href="mailto:<%=getString("email")%>"> <%=rs1.getString("admin")%></a>
密码:
<input type="password" name="password" class="f12" id="adminpass22" size="13">
<input type="submit" name="Submit" value="管理登陆">
<% }else{%>
<strong>|</strong>管理留言 </font><strong> |</strong><a href="admin.jsp">
设置留言本</a> <strong>|</strong> <a href="logout.jsp">退出登陆</a></font>
<strong>|
<% //管理员信息结束
}
%>
</strong></p>
</td>
</tr>
</form>
</table><br><br>
<table width="82%" height="398" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="13%" height="307"><table width="103%" height="107" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><div align="right"><a href="index.jsp">查看留言</a></div></td>
</tr>
<tr>
<td><div align="right"><a href="add.jsp">写留言</a>?/div></td>
</tr>
<tr>
<td><div align="right"><a href="search.jsp">搜索留言</a></div></td>
</tr>
<tr>
<td height="35"><div align="right"><a href="help.jsp">帮助</a></div></td>
</tr>
</table></td>
<td width="87%">
<1>
Statement stm=con.creatStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,Resultset.CONCUR_READ_ONLY);
[con.createStatement][ResultSet]
~~~~~~~~~~~~~~~~~~~~~~
<2>
管理员: <a href="mailto:<%=getString("email")%>"> <%=rs1.getString("admin")%></a>
[<%=rs1.getString("email")%>"]楼主还是自己慢慢找咯.
java.sql.SQLException: Column not found
at sun.jdbc.odbc.JdbcOdbcResultSet.findColumn(JdbcOdbcResultSet.java:1852)
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:413)
at _jsp._index__jsp._jspService(/index.jsp:128)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.pageservice(Page.java:571)
at com.caucho.server.dispatch.PageFilterChain.doFilter(PageFilterChain.java:155)
at com.caucho.server.cache.CacheFilterChain.doFilter(CacheFilterChain.java:177)
at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:177)
at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:221)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:263)
at com.caucho.server.port.TcpConnection.run(TcpConnection.java:331)
at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:464)
at com.caucho.util.ThreadPool.run(ThreadPool.java:408)
at java.lang.Thread.run(Thread.java:534)
--------------------------------------------------------------------------------
Resin-3.0.8 (built Tue, 08 Jun 2004 02:25:40 PDT)