struts2之用户登录校验数据库信息

最新推荐文章于 2018-11-27 15:15:03 发布

阿勒腾

最新推荐文章于 2018-11-27 15:15:03 发布

阅读量614

点赞数 2

分类专栏： java 文章标签： struts2.0

本文链接：https://blog.csdn.net/yunteng0923/article/details/75165734

版权

java 专栏收录该内容

47 篇文章 1 订阅

订阅专栏

package com.tutorialspoint.struts;

import java.sql.*;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.PreparedStatement;
import com.opensymphony.xwork2.ActionSupport;

public class LoginAction extends ActionSupport {
    private String user;
    private String name;
    private String password;

    public String execute() throws SQLException {
        String ret = ERROR;
        Connection conn = null;

        try {
            String URL = "jdbc:mysql://localhost/shop";
            Class.forName("com.mysql.jdbc.Driver");
            conn = (Connection) DriverManager.getConnection(URL, "root", "123456");
            String sql = "select name from login where";
            sql += " user = ? and password = ?";
            PreparedStatement ps = (PreparedStatement) conn.prepareStatement(sql);
            ps.setString(1, user);
            ps.setString(2, password);
            ResultSet rs = ps.executeQuery();
            while (rs.next()) {
                name = rs.getString(1);
                ret = SUCCESS;

            }

        } catch (ClassNotFoundException e) {
            ret = ERROR;
            e.printStackTrace();
        } finally {
            if (conn == null) {
                conn.close();
            }

        }
        return ret;
    }

    public String getUser() {
        return user;
    }

    public void setUser(String user) {
        this.user = user;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

}


<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@ taglib prefix="s" uri="/struts-tags"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" 
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Login - www.yiibai.com</title>
</head>
<body>
   <form action="loginaction" method="post">
      User:<br/><input type="text" name="user"/><br/>
      Password:<br/><input type="password" name="password"/><br/>
      <input type="submit" value="Login"/>      
   </form>
</body>
</html>

<%@ page contentType="text/html; charset=UTF-8" %>
<%@ taglib prefix="s" uri="/struts-tags" %>
<html>
<head>
<title>Successful Login</title>
</head>
<body>
   Hello World, <s:property value="name"/>
</body>
</html>

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts PUBLIC
   "-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"
   "http://struts.apache.org/dtds/struts-2.0.dtd">

<struts>
   <constant name="struts.devMode" value="true" />
   <package name="helloworld" extends="struts-default">

      <action name="loginaction" 
         class="com.tutorialspoint.struts.LoginAction"
         method="execute">
         <result name="success">/success.jsp</result>
         <result name="error">/error.jsp</result>
      </action>

   </package>

</struts>

<%@ page contentType="text/html; charset=UTF-8" %>
<%@ taglib prefix="s" uri="/struts-tags" %>
<html>
<head>
<title>Invalid User Name or Password</title>
</head>
<body>
   Wrong user name or password provided.
</body>
</html>

这里写图片描述

最基础的jdbc连接

阿勒腾

关注

2
点赞
踩
3

收藏

觉得还不错? 一键收藏
0
评论
struts2之用户登录校验数据库信息

package com.tutorialspoint.struts;import java.sql.*;import com.mysql.jdbc.Connection;import com.mysql.jdbc.PreparedStatement;import com.opensymphony.xwork2.ActionSupport;public class LoginAction exte
复制链接

扫一扫

专栏目录