package Controller;
import pojo.User;
import service.Impl.UserServiceImpl;
import service.UserService;
import sun.misc.ObjectInputFilter;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
@WebServlet("/reigstService")
public class ReigstService extends HttpServlet {
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
//接收页面参数
String uname= req.getParameter("uname");
String upass= req.getParameter("upass");
String usex= req.getParameter("usex");
String tel= req.getParameter("tel");
UserService userService=new UserServiceImpl();
User user=new User();
user.setUname(uname);
user.setUpass(upass);
user.setUsex(usex);
user.setTel(tel);
userService.getInsert(user);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doGet(req,resp);
}
@Override
//Dao层实现,执行sql语句
public int insert(User user) {
QueryRunner qr=new QueryRunner(MyUtils.getDataSource());
String sql="insert into user (uid,uname,upass,usex,tel) values (null,?,?,?,?)";
try {
int update = qr.update(sql,user.getUname(), user.getUpass(), user.getUsex(), user.getTel());
return update;
} catch (SQLException e) {
e.printStackTrace();
}
return 0;
}
package Dao;
//Dao层接口
import pojo.User;
import java.util.List;
public interface UserDao {
User seleceByNname(String name);
int insert(User user);
}
public interface UserService {
boolean getUserName(String name,String pass);
int getInsert(User user);
}
@Override
//service层执行逻辑代码
public int getInsert(User user) {
UserDao userDao =new UserDaoImpl();
int insert = userDao.insert(user);
if (insert!=0){
return insert;
}
return 0;
}
package Controller;
//登录
import service.Impl.UserServiceImpl;
import service.UserService;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
@WebServlet("/user")
public class UserController extends HttpServlet {
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setContentType("text/html:charset=utf-8");
String username = request.getParameter("uname");
String userpass = request.getParameter("upass");
UserService userService=new UserServiceImpl();
boolean flag= userService.getUserName(username,userpass);
if (flag){
request.getRequestDispatcher("/Goods").forward(request,response);
}else {
request.setAttribute("err","输入用户信息有误");
request.getRequestDispatcher("/login.jsp").forward(request,response);
}
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request,response);
}
}
package Dao.Impl;
import Dao.UserDao;
//登录Dao
import Utils.MyUtils;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import pojo.User;
import java.sql.SQLException;
public class UserDaoImpl implements UserDao {
@Override
public User seleceByNname(String name) {
QueryRunner qr=new QueryRunner(MyUtils.getDataSource());
String sql="select * from user where uname=? ";
try {
User query = qr.query(sql, new BeanHandler<User>(User.class),name);
return query;
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
package service.Impl;
//登录service判断name存不存在
import Dao.Impl.UserDaoImpl;
import Dao.UserDao;
import pojo.User;
import service.UserService;
public class UserServiceImpl implements UserService {
@Override
public boolean getUserName(String name,String pass) {
UserDao userDao=new UserDaoImpl();
User user= userDao.seleceByNname(name);
if (user.getUname()!=null){
String pwd= user.getUpass();
if (pass.equals(pwd)){
return true;
}
}
return false;
}