201819101040杨榆连接数据库作业

最新推荐文章于 2024-06-28 14:49:22 发布

 Yang Yu_

最新推荐文章于 2024-06-28 14:49:22 发布

阅读量92

点赞数

本文链接：https://blog.csdn.net/weixin_44767830/article/details/108880220

版权

package com;

public class user {
private String username;
private String name;
private int age;
private int password;
public String getUsername() { return username;}
public void setUsername(String username){
    this.username=username;
}
public String getName() {return name;}
public void setName(String name){this.name=name;}
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;}
}

<%--
  Created by IntelliJ IDEA.
  User: 给
  Date: 2020/9/23
  Time: 9:29
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
  <head>
    <title>$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="gender"><br>
  年龄：<input type="text" name="age"><br>
  <button type="submit">注册</button>
</form>
   </body>
</html>

<%@ page import="com.user"%>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.Statement" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<jsp:useBean id="username" class="com.user" scope="application"></jsp:useBean>
<jsp:setProperty name="username" 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="insert into username(username,password,gender,age) values("+username.getUsername()+","+username.getPassword()+",2,11)";
    int count=stmt.executeUpdate(sql);

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

 Yang Yu_

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
201819101040杨榆连接数据库作业

package com;public class user {private String username;private String name;private int age;private int password;public String getUsername() { return username;}public void setUsername(String username){ this.username=username;}public String ...
复制链接

扫一扫