201819102019薛颖

阡陌颖

于 2020-09-29 17:55:41 发布

阅读量101

点赞数

本文链接：https://blog.csdn.net/XY1215/article/details/108873040

版权

这是一个使用JSP进行用户注册的示例。页面包含一个表单，用户输入用户名、密码和年龄，然后提交到名为'regiester.jsp'的页面进行处理。在处理页面中，通过JDBC连接到MySQL数据库，将用户信息插入到'user1'表中。

摘要由CSDN通过智能技术生成

<%--
  Created by IntelliJ IDEA.
  User: 113
  Date: 2020/9/11
  Time: 8:04
  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 method="post" action="regiester.jsp">
    用户名：<input type="text" name="username"><br>
    密码：<input type="text" name="password"><br>
    年龄：<input type="text" name="age"><br>
    <button type="submit">注册</button>

  </form>
  </body>
</html>

package com;

public class user {
    private int age;
    private int password;
    private  int username;

    public int getAge() {
        return age;
    }

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

    public int getPassword() {
        return password;
    }

    public void setPassword(int password) {
        this.password = password;
    }

    public int getUsername() {
        return username;
    }

    public void setUsername(int username) {
        this.username = username;
    }
}

<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.Statement" %><%--
  Created by IntelliJ IDEA.
  User: 113
  Date: 2020/9/29
  Time: 16:48
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
    <jsp:useBean id="user" class="com.user"></jsp:useBean>

    <jsp:setProperty name="user" property="*"></jsp:setProperty>

    <%

        //User user =new User();
//userBean.setUsername(request.getParameter("username"));





        //加载驱动程序
        Class.forName("com.mysql.jdbc.Driver");

        //book为数据库名，建立数据库连接   10.3.22.1   ←教师端
        String url ="jdbc:mysql://localhost/xy?user=root&password=root";

        Connection connection= DriverManager.getConnection(url);

        //获得链接对象 //alt+回车 自动导入类

        //创建Statement对象，执行aql语句
        String sql ="insert into user1 (username,password,age)values('"+user.getUsername()+"','"+user.getPassword()+"',23)";

        Statement stmt = connection.createStatement();

        int count =stmt.executeUpdate(sql);


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

        }else{
            out.print("注册成功");

        }

    %>

    <jsp:getProperty name="user" property="username"/>
</head>
<body>

</body>
</html>