有关韩顺平视频servlet网站登录数据库验证的代码，没验证成功待解决的

ZHOUSUIJIE

于 2013-04-10 15:24:33 发布

阅读量1.2k

点赞数

本文链接：https://blog.csdn.net/ZHOUSUIJIE/article/details/8783227

版权

package com.tsinghua;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;

public class Login extends HttpServlet
{
public void doGet(HttpServletRequest req, HttpServletResponse res)
{

try{
res.setContentType("text/html;charset=GBk");

PrintWriter pw = res.getWriter();

    pw.println("<html>");
    pw.println("<body>");
    pw.println("<h1>登陆界面</h1>");
    pw.println("<form action=LoginC1 method=post>");
    pw.println("用户名：<input type=text name=usrename><br>");
    pw.println("密码:<input type=password name=passwd><br>");
    pw.println("<input type=submit value=loing><br>");
    pw.println("</form>");
    pw.println("</body>");
    pw.println("</html>");
       }
catch(Exception ex)
{
  ex.printStackTrace();
  }

}
}

//Login

package com.tsinghua;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;

public class LoginC1 extends HttpServlet
{
public void doGet(HttpServletRequest req, HttpServletResponse res)
{
  Connection ct=null;
  Statement sm=null;
  ResultSet rs=null;

try{

String u = req.getParameter("usrename");
String p = req.getParameter("passwd");

Class.forName("com.microsoft.jdbc.sqlserver.SQlServerDriver");

ct=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=spdb","sa","");

sm=ct.createStatement();

rs=sm.executeQuery( "select top 1 * from users where username='" +u+" 'and passwd=' "+p+"' ");

if (rs.next()){

                     HttpSession hs=req.getSession(true);
                     hs.setMaxInactiveInterval(20);
                     hs.setAttribute("pass","ok");

res.sendRedirect("LoginC2?uname="+u+"&upass="+p);

               }else{
                    res.sendRedirect("Login");
                 }

       }
catch(Exception ex){
  ex.printStackTrace();
  }finally{

   try{
    if(rs!=null)
   rs.close();
      if(sm!=null)
      sm.close();
      if(ct!=null)
      ct.close();

    }
    catch(Exception ex){
     ex.printStackTrace();
     }

}

public void doPost(HttpServletRequest req, HttpServletResponse res)
{

this.doGet( req, res);

}
}

package com.tsinghua;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;

public class LoginC2 extends HttpServlet
{
public void doGet(HttpServletRequest req, HttpServletResponse res)
{

HttpSession hs=req.getSession(true);
String val=(String)hs.getAttribute("pass");

   if(val==null)
   {
     try{
       res.sendRedirect("Login");
        }
     catch(Exception ex)
      {
       ex.printStackTrace();
       }

}

String u=req.getParameter("uname");
String p=req.getParameter("upass");

try{

PrintWriter pw = res.getWriter();
pw.println("wellcome "+u+p);

       }
catch(Exception ex)
{
  ex.printStackTrace();
  }

}
}

//数据库代码：

create database spdb1
go

use spdb1
go

create table users (
userId int primary key identity(1,1),--用户id号
username varchar(20),--用户名
passwd varchar(20),--用户密码
email varchar(30),--电子邮件
grade int)--用户的级别
go

insert into users values
('admin','admin','admin@sohu.com',1)

insert into users values
('shunping','shunping','shunping@sohu.com', 1)

insert into users values
('tester1','tester1','tester1@sohu.com',5)

insert into users values
('tester2','tester2','tester2@sohu.com',5)

insert into users values
('tester3','tester3','tester3@sohu.com',5)

insert into users values
('tester4','tester4','tester4@sohu.com',5)

insert into users values
('tester5','tester5','tester5@sohu.com',5)

insert into users values
('tester6','tester6','tester6@sohu.com',5)

insert into users values
('tester7','tester7','tester7@sohu.com',5)

insert into users values
('tester8','tester8','tester8@sohu.com',5)

insert into users values
('tester9','tester9','tester9@sohu.com',5)

insert into users values('tester10','tester10','tester10@sohu.com',5)

insert into users values('tester11','tester11','tester11@sohu.com',5)

insert into users values('tester12','tester12','tester12@sohu.com',5)

insert into users values('tester13','tester13','tester13@sohu.com',5)

insert into users values('tester14','tester14','tester14@sohu.com',5)

--显示用户表
select * from users;

ZHOUSUIJIE

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
有关韩顺平视频servlet网站登录数据库验证的代码，没验证成功待解决的

package com.tsinghua;import javax.servlet.*;import javax.servlet.http.*;import java.io.*;public class Login extends HttpServlet{ public void doGet(HttpServletRequest req, HttpServletRespon
复制链接

扫一扫