2020-09-29

<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" value="注册">注册</button>
    </form>

<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.Statement" %><%--
  Created by IntelliJ IDEA.
  User: cc
  Date: 2020/9/29
  Time: 14:34
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<jsp:useBean id="user" class="zmj.mid" ></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  ("注册成功");
    }
%>
<jsp:getProperty name="user" property="username"></jsp:getProperty>