📄 modifyuser.jsp~12~
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body>
<form name="form1" method="post" action="">
<table width="80%" border="0" align="center" cellpadding="4" cellspacing="1" id="table1">
<tr>
<td align="right">ID:</td>
<td><input name="modifyuserid" type="text" id="modifyuserid" size="15" maxlength="12"></td>
</tr>
<tr>
<td width="45%" align="right">Course:</td>
<td><input name="modifyusercourse" type="text" id="modifyusercourse" size="10" maxlength="8"></td>
</tr>
<tr>
<td align="right">Number:</td>
<td><input name="modifyusernumber" type="text" id="modifyusernumber" size="10" maxlength="8"></td>
</tr>
<tr>
<td align="right">Code:</td>
<td><input name="modifyusercode" type="text" id="modifyusercode" size="15" maxlength="12"></td>
</tr>
<tr>
<td align="right">Phone:</td>
<td><input name="modifyuserphone" type="text" id="modifyuserphone" size="15" maxlength="11"></td>
</tr>
<tr>
<td align="right">Email:</td>
<td><input name="modifyuseremail" type="text" id="modifyuseremail" size="35" maxlength="30"></td>
</tr>
<tr>
<td align="right">Oicq:</td>
<td><input name="modifyuserqq" type="text" id="modifyuserqq" size="15" maxlength="11"></td>
</tr>
<tr>
<td align="right">Maxbook:</td>
<td><input name="modifyusermax" type="text" id="modifyusermax" size="5" maxlength="3"></td>
</tr>
<tr align="center">
<td colspan="2"><input name="modifyuserenter" type="submit" id="modifyuserenter" value="enter">
<input name="modifyuserreset" type="reset" id="modifyuserreset" value="reset"></td>
</tr>
</table>
</form>
<jsp:useBean id="Library" scope="page" class="login.Library">
</jsp:useBean>
<center>
<%
String id = request.getParameter("modifyuserid");
String course = request.getParameter("modifyusercourse");
String studentnumber = request.getParameter("modifyusernumber");
String code = request.getParameter("modifyusercode");
String phone = request.getParameter("modifyuserphone");
String email = request.getParameter("modifyuseremail");
String oicq = request.getParameter("modifyuserqq");
String maxbook = request.getParameter("modifyusermax");
try{
if(request.getParameter("modifyuserenter")!=null){
Connection conn=Library.getConn();
Statement stmt=conn.createStatement();
String updatecourse = "update user set course ='" + course +"' where id ='" + id + "'";
stmt.execute(updatecourse);
String updatenumber = "update user set studentnumber ='" + studentnumber +"' where id ='" + id + "'";
stmt.execute(updatenumber);
String updatecode = "update user set code ='" + code +"' where id ='" + id + "'";
stmt.execute(updatecode);
String updatephone = "update user set phone ='" + phone +"' where id ='" + id + "'";
stmt.execute(updatephone);
String updateemail = "update user set email ='" + email +"' where id ='" + id + "'";
stmt.execute(updateemail);
String updateoicq = "update user set oicq ='" + oicq +"' where id ='" + id + "'";
stmt.execute(updateoicq);
String updatemax = "update user set maxbook ='" + maxbook +"' where id ='" + id + "'";
stmt.execute(updatemax);
response.sendRedirect("success.jsp");
}
}catch (Exception ex) {
response.sendRedirect("fail.jsp");
ex.printStackTrace();}
%>
</center>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -