第五次增删改查_baolirong-CSDN博客

本文链接：https://blog.csdn.net/weixin_50389994/article/details/109264646

idea 连接数据库实现增删改查
(实现增删改查的时候，由于使用的java bean与index.jsp是一样的，不再重复显示）
user Bean user.java

public class user {
    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;
    }
}

index.jsp
输入后会出现

$Title$ 用户名：
密码：
性别：
年龄：
注册代码为：

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

Statement实现在数据库增加用户

<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.Driver" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="javax.swing.plaf.nimbus.State" %>
<%@ page import="java.sql.Statement" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>

<jsp:useBean id="user" class="com.name.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";

    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("注册成功");
    }

%>

PreparedStatement执行

<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.Driver" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="javax.swing.plaf.nimbus.State" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="com.mysql.jdbc.PreparedStatement" %>

<%@ page contentType="text/html;charset=UTF-8" language="java" %>


<jsp:useBean id="user" class="com.name.user"></jsp:useBean>

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

<%
 lass.forName("com.mysql.jdbc.Driver");
     String url ="jdbc:mysql://127.0.0.1:3306/book";

    Connection connection = DriverManager.getConnection(url,"book","book");

    String sql = "insert into user(username,password,gender,age) values (?,?,?,?)";

    PreparedStatement temt = connection.prepareStatement(sql);
    temt.setString(1,request.getParameter("username"));
    temt.setString(2,request.getParameter("password"));
    temt.setString(3,request.getParameter("gender"));
    temt.setInt(4,request.getParameter("age"));
    ResultSet rs = temt.executeQuery();

删除操作

<html>
<head>
    <title>主页</title>
</head>
<body>
<%
 
    Class.forName("com.mysql.jdbc.Driver");

   
    String url = "jdbc:mysql://localhost:3306/book";

    Connection connection = DriverManager.getConnection(url,"root","root")
  
    String sql = "delete  from user where id = ? ";
    PreparedStatement pstm = connection.prepareStatement(sql);
    pstm.setInt(4);

查找用户

<html>
<head>
    <title>主页</title>
</head>
<body>
<%
   
    Class.forName("com.mysql.jdbc.Driver");

   
    String url = "jdbc:mysql://localhost:3306/book";

    Connection connection = DriverManager.getConnection(url,"root","root");

    
    String sql = "select * from user where username = ? and password = ? ";
    PreparedStatement temt = connection.prepareStatement(sql);

    temt.setString(1,request.getParameter("username"));

    temt.setString(2,request.getParameter("password"));

    ResultSet rs = temt.executeQuery();

  
    while (rs.next())
    {
        out.print(rs.getString("username")+"-"+rs.getString(2)+"<br>");
    }
%>
</body>
</html>

查询用户

<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.Driver" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="javax.swing.plaf.nimbus.State" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="com.mysql.jdbc.PreparedStatement" %>

<%@ page contentType="text/html;charset=UTF-8" language="java" %>


<jsp:useBean id="user" class="com.name.user"></jsp:useBean>

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

<%

    Statement stmt = connection.createStatement();
    
    String sql = "select * from user where username = '"+request.getParameter("username")+"'";

    ResultSet rs = stmt.executeQuery(sql);

    while (rs.next()){

        out.print(rs.getString("username")+"-"+rs.getString(1)+"<br>");

    }

%>