实现用户的注册功能

最新推荐文章于 2024-09-12 08:31:15 发布

柏油

最新推荐文章于 2024-09-12 08:31:15 发布

阅读量771

点赞数 1

分类专栏： # Struts2

本文链接：https://blog.csdn.net/ldw201510803006/article/details/76566208

版权

Struts2 专栏收录该内容

35 篇文章 0 订阅

订阅专栏

实现功能：

数据库中信息：

登录界面：

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ taglib prefix = "s" uri = "/struts-tags" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'index.jsp' starting page</title>
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->
  </head>
  
  <body>
    <s:form action = "login" method= "post">
      <s:textfield name = "username" label = "用户名"></s:textfield><br><br>
      <s:password name = "password" label = "密码"></s:password><br><br>
      <s:radio list="#{1:'男',0:'女'}" label = "性别" name = "sex"></s:radio><br><br>
      <s:textfield name = "tel" label = "电话"></s:textfield><br><br>
      <s:textfield name = "email" label = "邮箱"></s:textfield><br><br>
      <s:textfield name = "address" label = "地址"></s:textfield><br><br>
      <s:textarea name = "remark" label = "个人简介" rows="10" cols="40"></s:textarea><br>
      <s:submit value = "注册"></s:submit>
      <s:reset value = "重置"></s:reset>
    </s:form>
  </body>
</html>

Action:

package com.action;

import com.bean.User;
import com.dao.Tools;
import com.opensymphony.xwork2.ActionSupport;
import com.opensymphony.xwork2.ModelDriven;

public class LoginAction extends ActionSupport implements ModelDriven<User>{
  private User user = new User();

  public String execute() {
	 Tools tools = new Tools();
	 tools.getConnection();
	 String sql = "insert into info values(?,?,?,?,?,?,?)";
	 int num = tools.add(user,sql);
	 if(num == 0) return LOGIN;
	return SUCCESS;
}
  
public User getUser() {
	return user;
}

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

@Override
public User getModel() {
	return this.user;
}
 
}

连接数据库的类：Tool.java

package com.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import org.hibernate.validator.xml.GetterType;

import com.bean.User;

public class Tools {
	private Connection con = null;
	private PreparedStatement ps = null;
	
	public void getConnection() {
		String url = "jdbc:mysql://localhost:3306/user";
		String user = "root";
		String password = "root" ;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			con = DriverManager.getConnection(url,user,password);
		} catch (Exception e) {
			System.out.println("数据库连接失败");
		}
	}
	
    public int add(User user,String sql) {
    	int num = 0;
		try {
			if(con == null) return 0;
			ps = con.prepareStatement(sql);
			ps.setString(1, user.getUsername());
			ps.setString(2, user.getPassword());
			ps.setString(3, user.getSex());
			ps.setString(4, user.getTel());
			ps.setString(5, user.getEmail());
			ps.setString(6, user.getAddress());
			ps.setString(7, user.getRemark());
			num = ps.executeUpdate();
		} catch (SQLException e) {
			System.out.println("添加失败");
		}
		return num ;
	}
	
	public void release() {
		try{
			if(con != null)
				con.close();
				if(ps != null)
				ps.close();	
		}catch(Exception e){
			System.out.println("释放失败");
		}
	}
  
}

struts.xml配置：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts PUBLIC
    "-//Apache Software Foundation//DTD Struts Configuration 2.1.7//EN"
    "http://struts.apache.org/dtds/struts-2.1.7.dtd">
<struts>
  <package name="default" namespace = "/" extends = "struts-default">
    <action name="login" class = "com.action.LoginAction">
      <result name = "success">/ok.jsp</result>
      <result name = "login">/index.jsp</result>
    </action>
  </package>
</struts>

javaBean:User

package com.bean;

public class User {
  private String username;
  private String password;
  private String sex;
  private String tel;
  private String email;
  private String address;
  private String remark;
public String getUsername() {
	return username;
}
public void setUsername(String username) {
	this.username = username;
}
public String getPassword() {
	return password;
}
public void setPassword(String password) {
	this.password = password;
}
public String getSex() {
	return sex;
}
public void setSex(String sex) {
	this.sex = sex;
}
public String getTel() {
	return tel;
}
public void setTel(String tel) {
	this.tel = tel;
}
public String getEmail() {
	return email;
}
public void setEmail(String email) {
	this.email = email;
}
public String getAddress() {
	return address;
}
public void setAddress(String address) {
	this.address = address;
}
public String getRemark() {
	return remark;
}
public void setRemark(String remark) {
	this.remark = remark;
}
  
  
  
}

注册成功界面：

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ taglib prefix = "s" uri = "/struts-tags" %>

<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'ok.jsp' starting page</title>
    
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->

  </head>
  
  <body>
    欢迎<s:property value = "username"/>注册！
  </body>
</html>