📄 ch4-52.jsp
字号:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>修改数据</title>
</head>
<body bgcolor="#FFFFCC">
<%@page contentType="text/html;charset=gb2312" language="java" import="java.sql.*" %>
<%
String name=request.getParameter("name");
String password=request.getParameter("password");
String sex=request.getParameter("sex");
String clas=request.getParameter("clas");
String na=request.getParameter("na");
String email=request.getParameter("email");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:ch4";
Connection con=DriverManager.getConnection(url,"","");
if(sex.equals("")||clas.equals("")||na.equals("")||email.equals(""))
{ out.print("不能将信息修改为空值！");
return;}
%>
<%Statement stmt=con.createStatement();
String sql="update st set 班级='"+clas+"',学号='"+na+"',性别='"+sex+"',Email='"+email+"' where 姓名='"+name+"' and 密码='"+password+"'";
stmt.executeUpdate(sql);
Statement st=con.createStatement();
String strSql="select * from st where 姓名='"+name+"'";
ResultSet rs=st.executeQuery(strSql);
if(!rs.next())
return;
%>
<p><font color="#000000" size="5" face="隶书">信息修改成功！</font></p>修改后的信息为：<p>
<table border="1" >
<tr>
<td width="30%"> <p align="right">班级：</td>
<td width="70%"> <%out.print(rs.getString("班级"));%> </td>
</tr>
<tr>
<td width="30%"> <p align="right">学号：</td>
<td width="70%"> <%out.print(rs.getString("学号"));%> </td>
</tr>
<tr>
<td width="30%"> <p align="right"> 姓名：</td>
<td width="70%"> <%out.print(rs.getString("姓名"));%> </td>
</tr>
<tr>
<td width="30%"> <p align="right">性别：</td>
<td width="70%"> <%out.print(rs.getString("性别"));%> </td>
</tr>
<tr>
<td width="30%"> <p align="right">密码：</td>
<td width="70%"> <%out.print(rs.getString("密码"));%> </td>
</tr>
<tr>
<td width="30%"> <p align="right">E-mail：</td>
<td width="70%"> <%out.print(rs.getString("email"));%> </td>
</tr>
</table>
<p align="left"><a href="ch4-main.htm">返回主页</a> </p>
<p align="left"><a href="ch4-53.jsp">返回浏览修改</a></p>
<%
rs.close();
st.close();
stmt.close();
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -