jsp新代码第39课-CSDN博客

本文链接：https://blog.csdn.net/modern358/article/details/123157107

new39.jsp

<%@page import="java.sql.ResultSet"%>
<%@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 driverName = "com.mysql.jdbc.Driver";
	String userName = "root";
	String userPwd = "mysql123";
	String dbName = "test";
	String url = "jdbc:mysql://localhost:3306/" + dbName + "?useUnicode=true&characterEncoding=utf8";
	Class.forName(driverName);
	Connection conn = DriverManager.getConnection(url,userName,userPwd);
	
	request.setCharacterEncoding("utf-8");
	String sex = request.getParameter("sex");
	String name = request.getParameter("name");
	session.setAttribute("sex", sex);
	session.setAttribute("name", name);
	String sql = "select *from stu_info where sex=? and name=?";
	PreparedStatement pstmt = conn.prepareStatement(sql);
	pstmt.setString(1, sex);
	pstmt.setString(2, name);
	ResultSet rs = pstmt.executeQuery();
	if(rs.next())
	{
		int id2 = rs.getInt("id");
		String name2 = rs.getString("name");
		String sex2 = rs.getString("sex");
		int age2 = rs.getInt("age");
		float weight2 = rs.getFloat("weight");
		float height2 = rs.getFloat("height");
		
		if(rs != null)
		{
			rs.close();
		}
		if(pstmt != null)
		{
			pstmt.close();
		}
		if(conn != null)
		{
			conn.close();
		}
	
	
%>
<form action="new40.jsp" method="post">
	<table border="0" width="400">
		<tr>
			<td>学号</td>
			<td><input type="text" name="id3" value="<%=id2%>" readonly="readonly"></td>
		</tr>
		<tr>
			<td>姓名</td>
			<td><input type="text" name="name3" value="<%=name2%>"></td>
		</tr>
		<tr>
			<td>性别</td>
			<td><input type="text" name="sex3" value="<%=sex2%>"></td>
		</tr>
		<tr>
			<td>年龄</td>
			<td><input type="text" name="age3" value="<%=age2%>"></td>
		</tr>
		<tr>
			<td>体重</td>
			<td><input type="text" name="weight3" value="<%=weight2%>"></td>
		</tr>
		<tr>
			<td>身高</td>
			<td><input type="text" name="height3" value="<%=height2%>"></td>
		</tr>
		<tr>
			<td><input type="submit" name="submit" value="修改"></td>
			<td></td>
		</tr>
	</table>
</form>
<%
	}
	else
	{
		if(rs != null)
		{
			rs.close();
		}
		if(pstmt != null)
		{
			pstmt.close();
		}
		if(conn != null)
		{
			conn.close();
		}
	
	}
%>
</body>
</html>