JSP查询操作

科技2024-01-17 117

表格

<%-- Created by IntelliJ IDEA. User: 和 Date: 2020/10/7 Time: 8:16 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="com.media.bean.UserBean " %> <%@ page import="java.sql.*" %> <%-- Created by IntelliJ IDEA. User: 和 Date: 2020/10/7 Time: 8:21 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(5)+"<br>" ); } /* //使用Statement对象执行sql语句 Statement stmt = connection.createStatement() ; //stmt.executeUpdate()执行增删改操作的函数 String sql = "select * from user"; ResultSet rs = stmt.executeQuery(sql);//执行查询的函数返回结果集 while (rs.next() ){ out.print(rs.getString("username")+"-"+rs.getString(5)+"<br>" ); } */ %> </body> </html>

Processed: 0.018, SQL: 8