<%@ page import="Utill.JdbcConnetUtil" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.PreparedStatement" %>
<%@ page import="java.sql.SQLException" %>
<%@ page import="static java.lang.Integer.parseInt" %>
<%@ page import="java.sql.ResultSet" %><%--
Created by IntelliJ IDEA.
User: 000
Date: 2019/3/17
Time: 11:46
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<html>
<head>
<title>更新学生信息</title>
</head>
<body>
<!------
更新操作 1.获取id 2.查询数据库数据 返回来的数据 进行填充form 3.根据用户修改的信息进行再次保存回数据库
--------->
<%--这个是用%号的--%>
<%
ResultSet rs = null;
String id = request.getParameter ("id");
Connection conn = JdbcConnetUtil.conn ();
PreparedStatement ps = conn.prepareStatement ("select name,age from student where id=?");
try {
ps.setString (1, id);
rs = ps.executeQuery ();
} catch (SQLException e) {
e.printStackTrace ();
}
%>
<%if (rs.next () ==true){%>
<form action="UpdateStudentServlet" method="post">
更新：
<%try{%>
姓名:<input type="text" name="name" value="<%=rs.getString("name")%>" /><br/>
年龄:<input type="text" name="age" value="<%=rs.getString("age")%>"/><br/>
<% } catch (SQLException e) {
e.printStackTrace ();
}%>
<input type="hidden" name="status" value="isstudentUpdate">
<input type="submit" value="提交">
<input type="hidden" name="id" value="<%=id%>">
</form>
<%}else {%>
<%}%>
<%
JdbcConnetUtil.close (rs,ps,conn);
%>
<%--------------------------------------------------------------------------%>
<%--以下是用了jstl中的sql标签，从后台拿到的值--%>
<sql:setDataSource var="sdate" driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://127.0.0.1:3306/student?userUnicode=true&characterEncoding=utf8" user="root" password="123456"/>
<sql:query var="result" dataSource="${sdate}">
select name,age from student where id="${param.id}";
</sql:query>
<c:forEach var="row" items="${result.rows}">
<form action="UpdateStudentServlet" method="post">
更新：
姓名:<input type="text" name="name" value="${row.name}" /><br/>
年龄:<input type="text" name="age" value="${row.age}"/><br/>
<input type="submit" value="提交">
<input type="hidden" name="id" value="${param.id}">
</form>
<%–JdbcConnetUtil.close (rs,ps,conn);–%>
</c:forEach>
<%-----------------------------------------------------------------------------%>
<%--这个是从前台拿到的值--%>
<form action="UpdateStudentServlet" method="post">
更新：
姓名:<input type="text" name="name" value="${param.name}" /><br/>
年龄:<input type="text" name="age" value="${param.age}"/><br/>
<input type="submit" value="提交">
<input type="hidden" name="id" value="${param.id}">
</form>
</body>
</html>
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
