先在SQL数据库添加数据
建一个bean包编写User.java
package org.chenao.bean;
public class User {
private Integer Id;
private String UserName;
private String Pwd;
private String Sex;
private Integer Age;
@Override
public String toString() {
return "User [Age=" + Age + ", Id=" + Id + ", Pwd=" + Pwd + ", Sex="
+ Sex + ", UserName=" + UserName + "]";
}
public User() {
super();
}
public User(Integer id, String userName, String pwd, String sex, Integer age) {
super();
Id = id;
UserName = userName;
Pwd = pwd;
Sex = sex;
Age = age;
}
public int getId() {
return Id;
}
public void setId(int id) {
Id = id;
}
public String getUserName() {
return UserName;
}
public void setUserName(String userName) {
UserName = userName;
}
public String getPwd() {
return Pwd;
}
public void setPwd(String pwd) {
Pwd = pwd;
}
public String getSex() {
return Sex;
}
public void setSex(String sex) {
Sex = sex;
}
public int getAge() {
return Age;
}
public void setAge(int age) {
Age = age;
}
}
编写UserManager.java用来接收测试数据库是否存在用户信息
package org.chenao.test;
import org.chenao.bean.User;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import org.chenao.util.DBUtil;
public class UserManager{
public static ArrayList<User> getUsers(String name) {
Connection conn= DBUtil.getConn();
String sql="select* from book where name=?";
PreparedStatement ps=null;
ResultSet rs= null;
ArrayList<User> users = new ArrayList<User>();
try {
ps= conn.prepareStatement(sql);
ps.setObject(1, name);
rs= ps.executeQuery();
if (rs.next()) {
User user=new User();//创建一个没有属性值的对象
user.setId(rs.getInt("id"));//给属性赋值
user.setUserName(rs.getString("user_name"));
user.setPwd(rs.getString("pwd"));
user.setSex(rs.getString("sex"));
user.setAge(rs.getInt("age"));
}
} catch (Exception e) {
}finally{
DBUtil.close(conn, ps, rs);
}
return users;
}
}
编写一个servlet下的LoginServlet.java用来响应与跳转页面
package org.chenao.test;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import org.chenao.test.Book;
import org.chenao.test.BookTest;
public class LoginServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request,response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response, Object pwd)
throws ServletException, IOException {
//1:设置中文编码
request.setCharacterEncoding("utf-8");
//2:获取参数
String userName= request.getParameter("userName");
//登录
User user = UserManager.login(userName,pwd);//参照登录页面
//3:响应
if(user!=null){
HttpSession session= request.getSession();
session.setAttribute("user", user);
response.sendRedirect("main.jsp");
}else{
response.sendRedirect("main.jsp");
}
}
}
编写main.jsp判断是否登录过,没有登录过则跳转到登录页面
如果报错可能是没加bean包,则需要在上那边加入<%@ page import="org.chenao.bean.User" %>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ page import="org.chenao.bean.User" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>My JSP 'main.jsp' starting page</title>
</head>
<body>
<%
User user =(User)sessoin.getAttribute("user");
if(user!=null){
//登录过
}else{
//未登录过
reponse.sendRedirect("login.jsp");
}
%>
这个页面只有登录过的用户才能看到,其他人无权查看!
</body>
</html>
编写login.jsp登录页面
<body>
<form action="loginServlet" method="post">
用户名:<input type="text" name="userName"/><br/>
密 码:<input type="password" name="pwd"/><br/>
<input type="submit" value="登录"/><br/>
</body>