Servlet校验密码之Mariadb篇
Servlet校验密码之Mariadb篇
先放图~~
数据库:
效果图:
整体来说与上一篇差距不大,这次主要是采用数据库来进行校验,我使用的是Mariadb,安装与配置不用我说
主要有一点,导入连接器jar包时,不仅要在项目中导入,还要在Tomcat/lib中导入,不然会报ClassNotFoundException
1.第一步:简单的连接器实现
package pers.eddy.login; import java.sql.*; public class MySqlOperator { private static final String driver = "org.mariadb.jdbc.Driver"; private static final String url = "jdbc:mariadb://localhost:3306/hello"; private static final String user = "root"; private static final String pswd = "admin"; private static Connection conn; static { try { Class.forName(driver); } catch (ClassNotFoundException e) { e.printStackTrace(); } } public static boolean check(String usr, String psd) { try { conn = DriverManager.getConnection(url, user, pswd); Statement stat = conn.createStatement(); ResultSet rs = stat.executeQuery("select * from users where usr=\""+usr+"\" and psd=\""+psd+"\";"); conn.close(); return rs.next() ? true:false; } catch (Exception e) { e.printStackTrace(); } return false; } }
2.修改doGet()
@Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { String usr = req.getParameter("usr"); String psd = req.getParameter("psd"); if (MySqlOperator.check(usr, psd)) { req.setAttribute("usr", usr); req.setAttribute("psd", psd); req.getRequestDispatcher("/welcome.jsp").forward(req, resp); } else { resp.sendRedirect("/web_war_exploded/"); } }
源码链接: https://pan.baidu.com/s/1DXCUybmk3tg4i2tlYkNyVQ 提取码: uwdv