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

旧城等待， 2022-06-16 09:42 152阅读 0赞

Struts2+MySQL完成登录和验证：

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

1.导入jar

2.配置struts.xml

3.配置web.xml

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

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 block
    			e.printStackTrace();
    		} catch (SQLException e) {
    			// TODO Auto-generated catch block
    			e.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;
    		}
    }
    }

配上其他的代码：.

![Center][]

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>

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

[Link 1]: http://blog.csdn.net/qq442270636
[Center]: /images/20220616/851ad0b5ae264d73908c6ef3c7eeabae.png