201819101024姜岩作业4

乱世佳人丶炎

于 2020-10-09 08:35:20 发布

阅读量60

点赞数

分类专栏：作业

本文链接：https://blog.csdn.net/qq_50396193/article/details/108972085

版权

作业专栏收录该内容

5 篇文章 0 订阅

订阅专栏

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

在这里插入图片描述

乱世佳人丶炎

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
201819101024姜岩作业4

<%@ 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 Fi
复制链接

扫一扫