201819102018刘宇超

AIyinSion

于 2020-09-29 17:15:30 发布

阅读量225

点赞数

本文链接：https://blog.csdn.net/AIyinSion/article/details/108871123

版权

注册页面

package com.media;

public class UserBean {
    private String username;
    private String password;
    private String gender;
    private int age;

    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 getGender() {
        return gender;
    }

    public void setGender(String gender) {
        this.gender = gender;
    }

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }
}

<%--
  Created by IntelliJ IDEA.
  User: 空间
  Date: 2020/9/25
  Time: 7:58
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
  <head>
    <title>注册</title>
  </head>
  <body>
  <form mathod="post" action="register.jsp">
    用户名：<input type="text" name="username"><br>
    密码：<input type="text" name="password"><br>
    性别：<input type="text" name="gender"><br>
    年龄：<input type="text" name="age"><br>
    <button type="submit">注册</button>
  </form>
  </body>
</html>

<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.Statement" %><%--
  Created by IntelliJ IDEA.
  User: 空间
  Date: 2020/9/29
  Time: 14:18
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<jsp:useBean id="user" class="com.media.UserBean"></jsp:useBean>
<jsp:setProperty name="user" property="*"></jsp:setProperty>
<%
    Class.forName("com.mysql.jdbc.Driver");
    String url="jdbc:mysql://127.0.0.1:3306/book?user=root&password=root";
    Connection connection= DriverManager.getConnection(url);
    String sql="insert into user(username,password,gender,age,)values('"+user.getUsername()+"','"+user.getPassword()+"',1,23)";
    Statement stmt=connection.createStatement();
    int count=stmt.executeUpdate(sql);
    if(count==0){
        out.print("注册失败");
    }
    else{
        out.print("注册成功");
    }
%>
```![在这里插入图片描述](https://img-blog.csdnimg.cn/20200929171353491.png#pic_center)
![在这里插入图片描述](https://img-blog.csdnimg.cn/20200929171448544.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0FJeWluU2lvbg==,size_16,color_FFFFFF,t_70#pic_center)

AIyinSion

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
201819102018刘宇超

注册页面package com.media;public class UserBean { private String username; private String password; private String gender; private int age; public String getUsername() { return username; } public void setUsername(String
复制链接

扫一扫