实现用户的注册功能

悠悠 2024-02-18 00:10 15阅读 0赞

实现功能：

![Center][]

数据库中信息：

![Center 1][]

登录界面：

<%@ 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">
 	
 </head>
 
 <body>
 <s:form action = "login" method= "post">
 <s:textfield name = "username" label = "用户名"></s:textfield> 
 <s:password name = "password" label = "密码"></s:password> 
 <s:radio list="#{1:'男',0:'女'}" label = "性别" name = "sex"></s:radio> 
 <s:textfield name = "tel" label = "电话"></s:textfield> 
 <s:textfield name = "email" label = "邮箱"></s:textfield> 
 <s:textfield name = "address" label = "地址"></s:textfield> 
 <s:textarea name = "remark" label = "个人简介" rows="10" cols="40"></s:textarea> 
 <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;
    }
      
      
      
    }

注册成功界面：

[Center]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/c62470805bb149cf9a5bdf02fe61f2d4.png
[Center 1]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/fc2acf539df54d5b84ce4d31ae6ca199.png