急问:输入用户的ID,点击“登录”后,显示的是用户名!

blueskypp 2006-08-03 08:48:24
如题!页面登录时,用户输入自己的ID,登录成功后,显示的是用户名!
初学的,好多不懂的地方!请大家帮忙!
我是这样想的:首先有个表,里面有userid,username两项!(比较简单)
然后,做一login.jsp页面,这个页面很简单了,
<html>
<head>
<title>login</title>
</head>
<body>
<form action="login_result.jsp" method="POST" name="form1" onsubmit="return check()">
<table cellspacing="0" cellpadding="2" width="760" align="center" border="0" id="table1">
<tbody>
<tr>
<td height="35" width="346" align="right">账  号:</td>
<td height="37" align="left"><input type="text" name="userid" size="20" /></td>
</tr>
<tr>
<td height="35" width="346" align="right"></td>
<td height="37" align="left">   <input type="submit" value="提交" name="B1" />    <input type="reset" value="重置" name="B2" /></td>
</tr>
</tbody>
</table>
</form>
</body>
</html>

再有,一login_result.jsp,这页判断的条件我就不会写了,
<%@ page contentType="text/html; charset=GB2312" %>
<%@ page import="java.sql.*" %>
<%
String username=request.getParameter("username");
String userid=request.getParameter("userid");
String driver="sun.jdbc.odbc.JdbcOdbcDriver";
String url="jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)}; DBQ=E:/userdb.mdb";
Class.forName(driver);
Connection conn=DriverManager.getConnection(url,"","");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select userid from userinfo where *******请教部分);
if(rs.next()){
conn.close(};
out.println("username",username);
}

%>

谁帮我一下呗!
...全文
318 12 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
12 条回复
切换为时间正序
请发表友善的回复…
发表回复
blueskypp 2006-08-03
  • 打赏
  • 举报
回复
那个}是打错的,应是)!
而且,应该删掉吧!后面不是还有out.print那句的“}”吗?!

而且好象与它也没啥关系!!
再求!!!中午人多,谁来再帮!
kevinliuu 2006-08-03
  • 打赏
  • 举报
回复
}不能删,大括号不匹配了
blueskypp 2006-08-03
  • 打赏
  • 举报
回复
conn.close(); }

我把这句删掉了,还是上面的那个错误提示!
还有谁能再点下呀!
ldjava 2006-08-03
  • 打赏
  • 举报
回复
en
jacky_majia_001 2006-08-03
  • 打赏
  • 举报
回复
interpb 2006-08-03
  • 打赏
  • 举报
回复
conn.close(};

怎么会有这样的语句

conn.close(); }
kevinliuu 2006-08-03
  • 打赏
  • 举报
回复
conn.close(

conn.close();
blueskypp 2006-08-03
  • 打赏
  • 举报
回复
kevinliuu,我按你的改动了一下,不过,按“提交”按钮后出现如下提示:
HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

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: 2 in the jsp file: /login_result.jsp

Generated servlet error:
[javac] Compiling 1 source file

E:\Tomcat\work\Standalone\localhost\examples\login_result_jsp.java:53: illegal start of expression
conn.close(};
^



An error occurred at line: 2 in the jsp file: /login_result.jsp

Generated servlet error:
E:\Tomcat\work\Standalone\localhost\examples\login_result_jsp.java:31: 'try' without 'catch' or 'finally'
try {
^
E:\Tomcat\work\Standalone\localhost\examples\login_result_jsp.java:59: illegal start of type
} catch (Throwable t) {
^
E:\Tomcat\work\Standalone\localhost\examples\login_result_jsp.java:66: <identifier> expected
}
^
E:\Tomcat\work\Standalone\localhost\examples\login_result_jsp.java:68: 'class' or 'interface' expected
}
^
E:\Tomcat\work\Standalone\localhost\examples\login_result_jsp.java:69: 'class' or 'interface' expected
^
E:\Tomcat\work\Standalone\localhost\examples\login_result_jsp.java:54: cannot resolve symbol
symbol : variable username
location: class org.apache.jsp.login_result_jsp
out.println("username",username);
^
7 errors


at org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:85)
at org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:248)
at org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:315)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:328)
at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:427)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:142)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:240)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:187)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:200)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:144)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:445)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2358)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:133)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:118)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:127)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:536)



--------------------------------------------------------------------------------

Apache Tomcat/4.1.31

mx1029 2006-08-03
  • 打赏
  • 举报
回复
"select username from userinfo where userid="+userid
是这个意思吗?根据取得的userid查询出username
kevinliuu 2006-08-03
  • 打赏
  • 举报
回复
String username=request.getParameter("username");

登陆页并没有要求输入username,何来此参数?

不用密码登陆的话,只输id吗

"select * from userinfo where userid='"+userid+"'";
老鱼趣多多 2006-08-03
  • 打赏
  • 举报
回复
String username=request.getParameter("username");
String userid=request.getParameter("userid");
String driver="sun.jdbc.odbc.JdbcOdbcDriver";
String url="jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)}; DBQ=E:/userdb.mdb";
try{

Class.forName(driver);
Connection conn=DriverManager.getConnection(url,"","");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select userid from userinfo where *******请教部分);
if(rs.next()){
conn.close(};
out.println("username",username);
}
}catch (SQLException ex){

out.println("DB ERROR!");

}

连接数据库及生成结果集RS部分需要捕获异常才可以,不可以丢弃的。

你查下API文档就清楚了。
凋零的老树 2006-08-03
  • 打赏
  • 举报
回复
ResultSet rs=stmt.executeQuery("select * from userinfo where userid ='"+ userid +"');
if(rs.next())
username = rs.getString("username");
out.println("username",username);
}

rs.close();
conn.close();

81,122

社区成员

发帖
与我相关
我的任务
社区描述
Java Web 开发
社区管理员
  • Web 开发社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧