注册 登录
编程论坛 J2EE论坛

jsp求解 从login.jsp进入loginCl.jsp,但是loginCl.jsp没有处理,而且数据库连接不上!!!???

狼IT 发布于 2015-05-22 11:24, 2516 次点击
这是登录界面 login.jsp
 <body bgcolor=pink>
  <center>
    用户登录 <br>
    <hr>
    <form action="loginCl.jsp" method="post">
    用户名:<input type="text" name="username"/><br>
    密&nbsp;&nbsp;码:<input type="password" name="passwd"/><br>
    <input type="submit" value="登录"/>
    <input type="reset" value="重置"/>
    </form>
    </center>
  </body>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
这是loginCl.jsp
<body>
  <%
           //接受用户名和密码
           String u=request.getParameter("username");
           String p=request.getParameter("passwd");
           //验证,
           try{
           //1.加载驱动
           Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
         
           //2.得到链接
           Connection ct=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=users","sa","sa");
           //3.创建Statement
           Statement sm=ct.createStatement();
           //4.查询
           ResultSet rs=sm.executeQuery("select passwd from users1 where username='"+u+"'");
           //根据结果判断
         
           if(rs.next())
           {
               //说明用户名存在
               if(rs.getString(1).equals(p))
               {
                   //一定合法
                   response.sendRedirect("wel.jsp?user="+u);
                                 
               }else{
                   //密码错误
                   response.sendRedirect("login.jsp?errNo=1");
               }
           }else{
             //说明用户不存在
             response.sendRedirect("login.jsp?errNo=2");
                        
           }
           }catch(Exception e){
                e.printStackTrace();
           }
           
           
          /* if(u.equals("luo")&&p.equals("123")){
           //合法,跳转
           //如何将loginCl得到得数据传到下一个页面
           //1.cookie,2session,3.response.sendRedirect
                 
           response.sendRedirect("wel.jsp?user="+u);
           }else{
           //不合法
           response.sendRedirect("loginCl.jsp");
           }*/
           
  
  %>
   
   
  </body>
1 回复
#2
hhwz2015-05-22 15:44
检查有没有启动sqlserver的服务
有没有加载驱动包
1