package conm.java.pojo;
public class Lmp {
private int id;
private String name;
private String pwd;
@Override
public String toString() {
return "Lmp{" +
"id=" + id +
", name='" + name + ''' +
", pwd='" + pwd + ''' +
'}';
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPwd() {
return pwd;
}
public void setPwd(String pwd) {
this.pwd = pwd;
}
public Lmp() {
}
public Lmp(int id, String name, String pwd) {
this.id = id;
this.name = name;
this.pwd = pwd;
}
}
package conm.java.ul;
import com.mchange.v2.c3p0.ComboPooledDataSource;
import javax.sql.DataSource;
public class Db {
public static DataSource getDatll(){
ComboPooledDataSource cs = new ComboPooledDataSource();
return cs;
}
}
package conm.java.dao;
import conm.java.pojo.Lmp;
public interface DaoLmp {
Lmp getLmpNmae(String name);
}
package conm.java.dao.imp;
import conm.java.dao.DaoLmp;
import conm.java.pojo.Lmp;
import conm.java.ul.Db;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import java.sql.SQLException;
import java.util.List;
public class DaoLmpimp implements DaoLmp {
private QueryRunner qr=new QueryRunner(Db.getDatll());
@Override
public Lmp getLmpNmae(String name) {
Lmp lmp=null;
String sql="select * from cc where name=?";
try {
lmp = qr.query(sql, new BeanHandler<>(Lmp.class), name);
} catch (SQLException throwables) {
throwables.printStackTrace();
}
return lmp;
}
}
package conm.java.serlet;
import conm.java.pojo.Lmp;
public interface SerletLmp {
boolean longin(String name, String pwd);
}
package conm.java.serlet.imp;
import conm.java.dao.DaoLmp;
import conm.java.dao.imp.DaoLmpimp;
import conm.java.pojo.Lmp;
import conm.java.serlet.SerletLmp;
public class SerletLmpimp implements SerletLmp {
private DaoLmp daoLmp=new DaoLmpimp();
@Override
public boolean longin(String name, String pwd) {
Lmp lmpNmae = daoLmp.getLmpNmae(name);
if (lmpNmae!=null&&lmpNmae.getPwd().equals(pwd)){
return true;
}
return false;
}
}
package conm.java.test;
import conm.java.serlet.SerletLmp;
import conm.java.serlet.imp.SerletLmpimp;
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 javax.servlet.http.HttpSession;
import java.io.IOException;
@WebServlet("/login")
public class Servlet extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
response.setContentType("text/html;charset=utf-8");
String name = request.getParameter("name");
String pwd = request.getParameter("pwd");
SerletLmp serletLmp =new SerletLmpimp();
HttpSession session = request.getSession();
session.setAttribute("name",name);
boolean lo = serletLmp.longin(name,pwd);
if(lo){
response.sendRedirect(request.getContextPath()+"/kk.jsp");
}else {
response.getWriter().print("你重写,写错了");
}
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request, response);
}
}
package conm.java.test;
import conm.java.serlet.SerletLmp;
import conm.java.serlet.imp.SerletLmpimp;
import org.junit.Test;
public class LemTest {
private SerletLmp serletLmp =new SerletLmpimp();
@Test
public void test(){
boolean longin = serletLmp.longin("admin","123");
if (longin){
System.out.println("登录成功");
}else {
System.out.println("用户名或密码错误");
}
}
}
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
用户登录
用户登录2021
快速登录
*推荐使用ie8或以上版本ie浏览器或Chrome内核浏览器访问本站