jsp菜鸟的问题!想做一个简单的用户登陆页面出现如下错误!

Question

刚学jsp老是出错!请各位路过的大侠帮我看下,感激不尽啊!
文件源码:
<%@page import="java.lang.*, java.io.*, java.sql.*, java.util.*" contentType="text/html;charset=gb2312"%><%
    String loginname=request.getParameter("loginname");
    String password=request.getParameter("password");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    Connection conn2=DriverManager.getConnection("jdbc:odbc:hulng"); //取得一个数据库连接
    Statement stmt=conn2.createStatement();
String sql="select * from dx_user where loginname='"+loginname+"' and password='"+password+"'" ;
ResultSet rs=stmt.executeQuery(sql);
    try
    {
     
      if (rs.next())        {
session.setAttribute("viewright2",loginname);
out.println("<script>alert('登陆成功!');</script>");
            out.println("<script>window.location='index.jsp';</script>");
        }
        else
        {
            out.print("<script>alert('用户名或密码不正确!');history.go(-1);</script>");
        }
}
    catch (Exception e)
    {
        e.printStackTrace();  //To change body of catch statement use File | Settings | File Templates.
    }
    finally
    {
rs.close();
stmt.close();
conn2.close();
}
%>
----------------下面是错误提示------------org.apache.jasper.JasperException: Exception in JSP: /jsp/web/public/zyfz/loginAction.jsp:9 6: --> 7: 8: 9: <% 10: String loginname=request.getParameter("loginname"); 11: String password=request.getParameter("password"); 12: Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Stacktrace: at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:504) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at pandy.com.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:40) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Unknown Source) 

Answer 1

org.apache.jasper.JasperException: Exception in JSP: /jsp/web/public/zyfz/loginAction.jsp:9 6: --> 7: 8: 9: <% 10: String loginname=request.getParameter("loginname"); 11: String password=request.getParameter("password"); 12: Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Stacktrace: at 自己看。

Answer 2

把行标出来了,我刚开始接触jsp真的看不懂,请明示啊!!7 <%@page import="java.lang.*, java.io.*, java.sql.*, java.util.*" contentType="text/html;charset=gb2312"%> 
8
9  <% 
10    String loginname=request.getParameter("loginname"); 
11    String password=request.getParameter("password"); 
12     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
13    Connection conn2=DriverManager.getConnection("jdbc:odbc:hulng"); //取得一个数据库连接 
14   Statement stmt=conn2.createStatement(); 
15  String sql="select * from dx_user where loginname='"+loginname+"' and password='"+password+"'" ; 
16 ResultSet rs=stmt.executeQuery(sql); 

Answer 3

换了连接后提示下面错误!!org.apache.jasper.JasperException: Unable to compile class for JSP An error occurred at line: 3 in the jsp file: /jsp/web/public/zyfz/loginAction.jsp Generated servlet error: Duplicate local variable password at 

Answer 4

连接改成了这个
      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=hulng";
String user="sa";
String password="";
    Connection conn2=DriverManager.getConnection("url,user,password");