（复习）Struts2+MySQL完成登录和验证（一）

来源：互联网发布：ffmeg-java 编辑：程序博客网时间：2024/05/17 11:04

Struts2+MySQL完成登录和验证：

前面写过无数据的登录，这次需要从数据库获取数据来判断登录用户是否合法：

1.导入jar

2.配置struts.xml

3.配置web.xml

这里不再写前面的基本配置，有需要的可以在这里看配置点击打开链接

4.写连接数据库的工具类

package com.cl.util;import java.sql.*;public class JDBCUtil {private static Connection conn=null;static{String URL="jdbc:mysql://localhost:3306/test";        String user="root";        String pass="123456";        String driver="com.mysql.jdbc.Driver";        try {Class.forName(driver);conn=DriverManager.getConnection(URL,user,pass);System.out.println("连接成功");} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}       }public static boolean selectStu(String name,String pass) throws SQLException{boolean flag=false;        PreparedStatement ps=null;        ResultSet rs=null;        ps=conn.prepareStatement("select * from student where name=? and pass=?");        ps.setString(1, name);       ps.setString(2, pass);        rs=ps.executeQuery();        if(rs.next())        {          flag=true;          }         return flag;}public static void main(String[] args) throws SQLException {selectStu("cc","123");//测试一下是否成功}}

6.Action类

public class LoginAction extends ActionSupport {private String name;private String pass;public String getName() {return name;}public void setName(String name) {this.name = name;}public String getPass() {return pass;}public void setPass(String pass) {this.pass = pass;}public String Login() throws SQLException{if(JDBCUtil.selectStu(getName(), getPass())){System.out.println("1");return SUCCESS;}else{System.out.println("2");return ERROR;}}}

配上其他的代码：.

struts.xml

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE struts PUBLIC"-//Apache Software Foundation//DTD Struts Configuration 2.3//EN""http://struts.apache.org/dtds/struts-2.3.dtd"><struts>    <constant name="struts.enable.DynamicMethodInvocation" value="false" />    <constant name="struts.devMode" value="true" />    <package name="default" namespace="/" extends="struts-default"><action name="login_*" class="com.cl.action.LoginAction" method="{1}"><result name="success">/WEB-INF/jsp/sucess.jsp</result><result name="error">/WEB-INF/jsp/error.jsp</result></action>   </package></struts>

   <form action="login_Login" method="post">    name:<input type="text" name="name">    pass:<input type="password" name="pass">    <input type="submit" value="提交">    </form>

这里struts+MySQL完成登录就实现了。

1 0