20819101040杨榆作业五

最新推荐文章于 2023-11-17 23:34:20 发布

 Yang Yu_

最新推荐文章于 2023-11-17 23:34:20 发布

阅读量179

点赞数

本文链接：https://blog.csdn.net/weixin_44767830/article/details/108969173

版权

<%@ page import="java.sql.*" %>
<%@ 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");

    String sql ="select * from user where username = ? and password = ?";
    // String sql="delete from user where id=3";
    //String sql = "update user set name=? where age=?";
    //String sql="insert into user(username,password,gender,age)values(?,?,?,?)";
    PreparedStatement ps =connection.prepareStatement(sql);

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

    ResultSet rs=ps.executeQuery();

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

%>
</body>
</html>

自己的电脑出现如下问题，代码无错误。

回机房进行测试。

 Yang Yu_

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
1
评论
20819101040杨榆作业五

<%@ page import="java.sql.*" %><%@ page contentType="text/html;charset=UTF-8" language="java" %><html><head> <title>Title</title></head><body><% Class.forName("com.mysql.jdbc.Driver"); .
复制链接

扫一扫