增删改查作业

最新推荐文章于 2022-12-14 16:26:40 发布

王姓小黄

最新推荐文章于 2022-12-14 16:26:40 发布

阅读量86

点赞数

本文链接：https://blog.csdn.net/w_y_h_/article/details/108997838

版权

<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.ResultSet" %>
<%--  Created by IntelliJ IDEA.  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<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");    
    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(3)+"<br>");    }
    %>
    </body>
    </html>

在这里插入图片描述

<%--  
Created by IntelliJ IDEA.  
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="home.jsp">    
      用户名:<input type="text" name="username"><br>    
      密码: <input type="text" name="password"><br>   
       <button type="submit">注册</button> 
        </form>  
        </body>
        </html>

在这里插入图片描述

<%@ page import="java.sql.*" %><%--  
Created by IntelliJ IDEA.  
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<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 ps = connection.prepareStatement(sql);    
    ps.setString(1,request.getParameter("username"));    
    ps.setString(2,request.getParameter("password"));    
    Statement stmt = connection.createStatement();    
    ResultSet rs = ps.executeQuery();    
    while (rs.next()){        
    out.print(rs.getString("username")+"-"+rs.getString(3)+"<br>");    
    }%>
    </body>
    </html>