第四次作业

最新推荐文章于 2024-04-21 21:05:25 发布

xiao_feiy

最新推荐文章于 2024-04-21 21:05:25 发布

阅读量77

点赞数

本文链接：https://blog.csdn.net/xiao_feiy/article/details/108890696

版权

userbean
public class userbean {
    private String username;
    private String password;
    private int gender;
    private int age;
    private int status;

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

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

    public int getAge() {
        return age;
    }

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

    public int getStatus() {
        return status;
    }

    public void setStatus(int status) {
        this.status = status;
    }
}

<body>
<form action="register.jsp" method="post">
    用户名：<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>

<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.Statement" %><%--
  Created by IntelliJ IDEA.
  User: 李亚飞
  Date: 2020/9/30
  Time: 19:08
  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.bean.userbean"></jsp:useBean>
<jsp:setProperty name="user" property="*"></jsp:setProperty>

<%
    Class.forName("com.mysql.jdbc.Driver");
    String url = "jdbc:mysql://localhost:3306/book";
    Connection connection = DriverManager.getConnection(url,"root","root");
    Statement stmt = connection.createStatement();
    String sql = "inser into user(username,password,gender,age) valuse("+user.getUsername()+","+user.getPassword()+",1,20)";
    int count = stmt.executeUpdate(sql);
    if(count >0){
        out.print("注册成功");
    }else{
        out.print("注册失败");
    }
%>

在这里插入图片描述

xiao_feiy

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
第四次作业

userbeanpublic class userbean { private String username; private String password; private int gender; private int age; private int status; public String getUsername() { return username; } public void setUsername(S
复制链接

扫一扫