通过下拉列表显示数据库姓名信息,并修改数据库中的年龄信息
- 数据库信息
- 新建一个asd.jsp,可以通过下拉列表显示数据库的姓名
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
// String user="tom";
try {
Class.forName("com.mysql.cj.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
Connection con=DriverManager.getConnection
("jdbc:mysql://localhost:3306/adc?useSSL=false&serverTimezone=UTC","root","123456");
String sql ="select * from age1 ";
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(sql);
String n1="";
%>
<form action="xiu.jsp" method="post">
姓名:
<select name="name" >
<%
while(rs.next()) {
n1=rs.getString("name");
out.print("<option value="+n1+">"+n1+"</option>");
}
%>
</select>
年龄:
<input type="text" name="age">
<input type="submit" value="修改">
</form>
<%
rs.close();
stmt.close();
con.close();
%>
</body>
</html>
效果:
- 新建一个xiu.jsp用来修改数据库的内容
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%
String n1=new String(request.getParameter("name").getBytes("ISO-8859-1"),"UTF-8");
String n2=new String(request.getParameter("age").getBytes("ISO-8859-1"),"UTF-8");
// String user="tom";
try {
Class.forName("com.mysql.cj.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
Connection con=DriverManager.getConnection
("jdbc:mysql://localhost:3306/adc?useSSL=false&serverTimezone=UTC","root","123456");
String sql ="select * from age1 where name='"+n1+"'";
PreparedStatement ps =con.prepareStatement("update age1 set age=? where name=?");
ps.setString(1,n2);
ps.setString(2,n1);
int ir=ps.executeUpdate();
out.println("修改成功");
ps.close();
con.close();
response.setHeader("refresh","2;URL=asd.jsp" );
%>
运行结果: