登录练习步骤
浏览器向服务器发出请求(打开网页),服务器收到请求后,调用servlet进行响应(登陆页面)。点击登陆,浏览器发起请求给服务器,服务器调用servlet进行处理.
数据的流转: 浏览器——servlet——service——dao——操作数据库
如果在数据库中查到了则:数据库——dao——service——servlet——浏览器
- 创建登录页面
创建Servlet进行登录页面请求处理
package com.youdian.servlet;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class PageServlet extends HttpServlet {
protected void service(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
//设置响应编码格式
resp.setContentType("text/html;charset=utf-8");
//获取请求信息
//处理请求
//响应处理结果
resp.getWriter().write("<html>");
resp.getWriter().write("<head>");
resp.getWriter().write("</head>");
resp.getWriter().write("<body>");
resp.getWriter().write("<form action='login' method='get'>");
resp.getWriter().write("用户名:<input type='text' name='uname' value='' /><br/>");
resp.getWriter().write("密码:<input type='password' name='pwd' value='' /><br/>");
resp.getWriter().write("<input type='submit' value='登陆' /><br/>");
resp.getWriter().write("</form>");
resp.getWriter().write("</body>");
resp.getWriter().write("</html>");
}
}
- 点击登录完成登录操作
浏览器发送请求到服务器(用户信息+其他数据)
package com.youdian.servlet;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.Cookie;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class LoginServlet extends HttpServlet {
protected void service(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
//设置请求编码格式:
req.setCharacterEncoding("utf-8");
//设置响应编码格式
resp.setContentType("text/html;charset=utf-8");
//获取请求信息
String uname=req.getParameter("uname");
//uname=new String(uname.getBytes("iso8859-1"),"utf-8");//使用String进行数据重新编码
String pwd=req.getParameter("pwd");
System.out.println(uname+":"+pwd);
//处理请求信息——操作数据库
//响应处理结果
}
}
注:
服务器调用对应的servlet进行处理
设置响应编码格式
获取请求信息
处理请求信息
响应处理结果
- 在servlet中完成用户登录校验
需要连接数据库(在mySql中创建用户表)
##创建用户表
create table t_user(
uid int(10) not null auto_increment,
uname varchar(100) not null,
pwd varchar(100) not null,
primary key(uid)
)
##添加测试数据
insert into t_user values(default,'zhangsan','123');
insert into t_user values(default,'lisi','456');
使用MVC思想完成
创建service接口:
创建一个类,servlet把用户名密码传给它,它返回是否有此人
package com.youdian.service;
import com.youdian.pojo.User;
public interface LoginService {
User checkLoginService(String uname,String pwd);
}
建立用户数据的实体类:
属性和数据库中的字段名一致,get,set方法,toString,hashCode,构造方法(无参,有参)
package com.youdian.pojo;
public class User {
private int uid;
private String uname;
private String pwd;
public int getUid() {
return uid;
}
public void setUid(int uid) {
this.uid = uid;
}
public String getUname() {
return uname;
}
public void setUname(String uname) {
this.uname = uname;
}
public String getPwd() {
return pwd;
}
public void setPwd(String pwd) {
this.pwd = pwd;
}
public int hashCode() {
final int prime = 31;
int result = 1;
result = prime * result + ((pwd == null) ? 0 : pwd.hashCode());
result = prime * result + uid;
result = prime * result + ((uname == null) ? 0 : uname.hashCode());
return result;
}
public boolean equals(Object obj) {
if (this == obj)
return true;
if (obj == null)
return false;
if (getClass() != obj.getClass())
return false;
User other = (User) obj;
if (pwd == null) {
if (other.pwd != null)
return false;
} else if (!pwd.equals(other.pwd))
return false;
if (uid != other.uid)
return false;
if (uname == null) {
if (other.uname != null)
return false;
} else if (!uname.equals(other.uname))
return false;
return true;
}
public String toString() {
return "User [uid=" + uid + ", uname=" + uname + ", pwd=" + pwd + "]";
}
public User(int uid, String uname, String pwd) {
super();
this.uid = uid;
this.uname = uname;
this.pwd = pwd;
}
public User() {
super();
}
}
创建service实现类:
package com.youdian.service.impl;
import com.youdian.dao.LoginDao;
import com.youdian.dao.impl.LoginDaoImpl;
import com.youdian.pojo.User;
import com.youdian.service.LoginService;
public class LoginServiceImpl implements LoginService{
//创建Dao层对象
LoginDao ld=(LoginDao) new LoginDaoImpl();
//校验用户登录信息
public User checkLoginService(String uname, String pwd) {
return ld.checkLoginDao(uname, pwd);
}
}
完善 点击登录完成登录操作 代码:
//处理请求信息
//获取业务层对象
LoginService ls=new LoginServiceImpl();
User u=ls.checkLoginService(uname, pwd);
//检验 用户名密码是否在数据库存在
System.out.println(u);
建立dao(数据库层接口):
如果用户名密码在数据库中查到了,把数据封装成User对象,返回给service层(业务层),在返回给servlet层,做出响应处理
package com.youdian.dao;
import com.youdian.pojo.User;
public interface LoginDao {
User checkLoginDao(String uname,String pwd);
}
dao层实现类(使用原生态的JDBC):
package com.youdian.dao.impl;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.youdian.dao.LoginDao;
import com.youdian.pojo.User;
public class LoginDaoImpl implements LoginDao{
public User checkLoginDao(String uname, String pwd) {
//声明Jdbc对象
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
//声明数据存储对象
User u=null;
try {
//加载驱动
Class.forName("com.mysql.jdbc.Driver");
//获取连接对象
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/servlet","root","root");
//创建Sql命令
String sql="select * from t_user where uname=? and pwd=?";
//创建Sql命令对象
ps=conn.prepareStatement(sql);
//给占位符赋值
ps.setString(1, uname);
ps.setString(2, pwd);
//执行
rs=ps.executeQuery();
//遍历执行结果
while(rs.next()){
u=new User();
u.setUid(rs.getInt("uid"));
u.setUname(rs.getString("uname"));
u.setPwd(rs.getString("pwd"));
}
//关闭资源
} catch (Exception e) {
e.printStackTrace();
}finally{
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
//返回
return u;
}
//根据UID获取用户信息
public User checkUidDao(String uid) {
//声明Jdbc对象
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
//声明数据存储对象
User u=null;
try {
//加载驱动
Class.forName("com.mysql.jdbc.Driver");
//获取连接对象
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/servlet","root","root");
//创建Sql命令
String sql="select * from t_user where uid=?";
//创建Sql命令对象
ps=conn.prepareStatement(sql);
//给占位符赋值
ps.setString(1, uid);
//执行
rs=ps.executeQuery();
//遍历执行结果
while(rs.next()){
u=new User();
u.setUid(rs.getInt("uid"));
u.setUname(rs.getString("uname"));
u.setPwd(rs.getString("pwd"));
}
//关闭资源
} catch (Exception e) {
e.printStackTrace();
}finally{
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
ps.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
//返回
return u;
}
}
完善 点击登录完成登录操作 代码:
//响应处理结果
if(u!=null){
resp.getWriter().write("登陆成功");
}else
resp.getWriter().write("登陆失败");
}
注:对于中文用户名的乱码再下一篇解释