曾删改“查”

最新推荐文章于 2024-10-23 16:48:43 发布

weixin_47165972

最新推荐文章于 2024-10-23 16:48:43 发布

阅读量94

点赞数

文章标签： JavaWeb 数据库连接 PreparedStatement SQL查询用户登录

本文链接：https://blog.csdn.net/weixin_47165972/article/details/108947908

版权

<%--
  Created by IntelliJ IDEA.
  User: 给
  Date: 2020/10/7
  Time: 9:02
  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 action="郝永华home.jsp" method="post">
    <input type="text" name="username">
    <input type="text" name="password">
    <button type="submit">提交</button>

</form>
</body>
</html>

在这里插入图片描述

<%@ page import="java.sql.*" %><%--
  Created by IntelliJ IDEA.
  User: 给
  Date: 2020/10/7
  Time: 8:02
  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>
<%
    //加载数据库驱动
    Class.forName("com.mysql.jdbc.Driver");

            //建立数据库连接
    String url="jdbc:mysql://localhost:3306/book";//数据库连接地址
    Connection connection= DriverManager.getConnection(url,"root","root");//第一个root为数据库的用户名 第二个root 为数据库的密码

    String sql="select * from user where username=? and password=?";//在  PreparedStatement中使用问号代替实际参数
    PreparedStatement ps=connection.prepareStatement(sql);

    ps.setString(1,request.getParameter("username"));
    ps.setString(2,request.getParameter("password"));

    //"insert into user(username,password,gender)values(?,?,?)";
    ResultSet rs=ps.executeQuery();

    while(rs.next()){
        out.print(rs.getString("username")+"-"+rs.getString(3)+"<br>");
    }



/*
    //使用Statement对象执行sql语句
    Statement stmt=connection.createStatement();

    //stme.execteUpdate()执行增改删操作的函数
    String sql="select * from user where user ";
    ResultSet rs=stmt.executeQuery(sql);//执行查询的函数 返回结果集
    while(rs.next()){
        out.print(rs.getString("username")+"-"+rs.getString(3)+"<br>");

    }
*/
    %>

</body>
</html>