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;