登录
创建web项目,部署到tomcat服务器中
创建一个login.isp作为登录页面,书写form表单指定提交地址和提交方式
创建一个zhuye.jsp,负责跳转成功
4.创建一个error.jsp,负责跳转失败
创建一个bean包,负责写Goods和User的getset方法和tostring方法
使用jdbc完成登录代码
package com.yun.servlet;
import com.yun.bean.User;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class login extends HttpServlet{
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request, response);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//1.设置请求和行营的编码
request.setCharacterEncoding("utf-8");//设置请求的编码
response.setCharacterEncoding("utf-8");//设置响应的编码
response.setContentType("text/html;charset=utf-8");//设置响应的文本格式和编码
//2.获取请求参数
String username=request.getParameter("username");
String password=request.getParameter("password");
System.out.println(username);
System.out.println(password);
//3.执行业务处理
Connection connection=null;
PreparedStatement pstm=null;
ResultSet rs=null;//结果集对象
User login=null;
try{
//1.加载驱动包
Class.forName("com.mysql.cj.jdbc.Driver");
//2.获取数据库链接
connection= DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb?useSSL=false&serverTimezone=UTC","root","root");
//3.定义登录的sql语句
String sql="select*from t_user where username=? and password=?";
//4.获取预处理对象
pstm=connection.prepareStatement(sql);
//5.传参
pstm.setObject(1,username);
pstm.setObject(2,password);
//6.执行查询
rs=pstm.executeQuery();
//7.解析结果集
if (rs.next()){
login=new User();
//从结果集中获取数据,封装到实体类对象中
int uid=rs.getInt("uid");
login.setUid(uid);
login.setUsername(rs.getString("username"));
login.setPassword(rs.getString("password"));
login.setPhone(rs.getString("phone"));
login.setAddress(rs.getString("address"));
}
}catch (Exception e){
e.printStackTrace();
} finally {
//8.关闭资源
try {
if (rs!=null){
rs.close();
}
if (pstm!=null){
pstm.close();
}
if (connection!=null){
connection.close();
}
}catch(Exception e){
e.printStackTrace();
}
}
//判断登录的用户信息是否为空
if (login!=null){
//登录成功,跳转到主页
response.sendRedirect("zhuye.jsp");
}else{
//登录失败,跳转到错误页
response.sendRedirect("error.jsp");
}
System.out.println(login);
}
}
注册
1.创建一个login.isp作为登录页面,书写form表单指定提交地址和提交方式