注册

最新推荐文章于 2022-07-13 21:04:23 发布

李尚璇

最新推荐文章于 2022-07-13 21:04:23 发布

阅读量120

点赞数

文章标签： Java Web JSP MySQL 数据库交互用户注册

本文链接：https://blog.csdn.net/FDDFKJJHJ/article/details/108870177

版权

index

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
  <head>
    <title>注册</title>
  </head>
  <body>
  <form method="post" action="register.jsp">
    用户名：<input type="text" name="username"><br>
    密码：<input type="text" name="password"><br>
    性别：<input type="text" name="gander"><br>
    年龄：<input type="text" name="age"><br>
    <button type="submit">注册</button>
  </form>
  </body>
</html>

<%@ page import="com.user" %>
<%@ page import="javax.print.DocFlavor" %>
<%@ page import="com.mysql.jdbc.Connection" %>
<%@ page import="com.mysql.jdbc.Driver" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.Statement" %>
<%--
  Created by IntelliJ IDEA.
  User: 和
  Date: 2020/9/29
  Time: 14:12
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<jsp:useBean id="user" class="com.user" ></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";


   java.sql.Connection connection = DriverManager.getConnection(url);

   String sql = "insert into user  (username,password,gender,age)  values('"+user.getUsername()+"','"+user.getPassword()+"',1,23)";

    Statement stat = connection.createStatement();

    int count= stat.executeUpdate(sql);

    if(count ==0)
    {
        out.print("注册失败");
    }
    else
    {
        out.print("注册成功");
    }


%>

<jsp:getProperty name="user" property="username"/>
<jsp:getProperty name="user" property="password"/>
<jsp:getProperty name="user" property="gender"/>
<jsp:getProperty name="user" property="age"/>

user

package com;

public class user {

    private String username;
    private String password;
    private int 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 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;
    }



}

在这里插入图片描述

李尚璇

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
注册

index<%@ page contentType="text/html;charset=UTF-8" language="java" %><html> <head> <title>注册</title> </head> <body> <form method="post" action="register.jsp"> 用户名：<input type="text" name
复制链接

扫一扫