201819102032李秀颖数据库与JSP的交互浅谈

最新推荐文章于 2023-09-20 11:22:09 发布

李秀颖

最新推荐文章于 2023-09-20 11:22:09 发布

阅读量120

点赞数

本文链接：https://blog.csdn.net/lixiuying1/article/details/108872419

版权

本文探讨了201819102032李秀颖在使用JSP进行数据库交互方面的经验，通过代码示例和截图展示了具体实现过程。

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

数据库与JSP的交互浅谈

代码
截图

代码

package com.media.bean;

public class UserBean {
  private String username;
  private String password;
  private String 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 String getGender() {
    return gender;
  }

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

  public int getAge() {
    return age;
  }

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

 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="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>

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>
<jsp:useBean id="user" class="com.media.bean.UserBean" scope="request"></jsp:useBean>
<%
out.print(user.getUsername());
%>
</body>
</html>

To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title></title>
</head>
<body>
<jsp:useBean id="user" class="com.media.bean.UserBean" scope="application"></jsp:useBean>
<jsp:setProperty name="user" property="*"></jsp:setProperty>
<%
//UserBean user1=new UserBean();
    //user.setUsername(request.getParameter("username"));
    //out.print(user.getUsername());

    //加载驱动程序
    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"/>

截图

在这里插入图片描述

李秀颖

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
201819102032李秀颖数据库与JSP的交互浅谈

数据库与JSP的交互浅谈代码截图代码package com.media.bean;public class UserBean { private String username; private String password; private String gender; private int age; public String getUsername() { return username; } public void setUsername(Stri
复制链接

扫一扫