📄 changereader.jsp
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%
if(session.getAttribute("adlogin")!=null){
String adlogin = (String)session.getAttribute("adlogin");
if(!adlogin.endsWith("yes")){
response.sendRedirect("../admin/login.jsp?errMsg=weidenglu" );
}
}else{
response.sendRedirect("../admin/login.jsp?errMsg=weidenglu" );
}
%>
<html>
<body>
<%
String id = request.getParameter("id");
String name = "";
String stuno = "";
String xueyuan = "";
String zhuanye = "";
String age = "";
String sex = "";
String data = "";
String beizhu = "";
String maxno="";
String yijieshu ="";
String kind = "";
String passwd = "";
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://localhost/library?user=root&password=linux&useUnicode=true&characterEncoding=GB2312" ;
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement();
String query="select * from reader where readerid = '"+id+"'";
ResultSet rs=stmt.executeQuery(query);
while(rs.next())
{
name=rs.getString("name");
stuno=rs.getString("StuNo");
xueyuan = rs.getString("xueyuan");
zhuanye = rs.getString("zhuanye");
age = rs.getString("age");
sex = rs.getString("sex");
data = rs.getString("usedata");
beizhu=rs.getString("beizhu");
maxno=rs.getString("maxreadno");
yijieshu =rs.getString("yijieshu");
kind = rs.getString("readerkind");
passwd = rs.getString("password");
//out.print(name+"<br>");
}
%>
<%String ErrMeg = request.getParameter("jieguo");
if(ErrMeg==null){
ErrMeg = " ";
}else if(ErrMeg.equals("failed1")){
ErrMeg = "没有输入信息";
}
%>
<h1><blockquote>输入您要修改的信息</blockquote></h1>
<h3><blockquote><font color= red><%=ErrMeg %></font></blockquote></h3>
<form name = search action="../servlet/changeReaderController" method="post">
<input type="hidden" name="id" value = <%=id %> >
<table width = 700 height = 500 Align = "left">
<tr><td>姓名（原来）</td><td><%=name %></td><td>改为</td><td><input type="text" name="name" maxlength="100" size="30"></td></tr>
<tr><td>学号（原来）</td><td><%=stuno %></td><td>改为</td><td><input type="text" name="stuno" maxlength="100" size="30"></td></tr>
<tr><td>密码（原来）</td><td><%=passwd %></td><td>改为</td><td><input type="text" name="passwd" maxlength="100" size="30"></td></tr>
<tr><td>学院（原来）</td><td><%=xueyuan %></td><td>改为</td><td><input type="text" name="xueyuan" maxlength="100" size="30"></td></tr>
<tr><td>专业（原来）</td><td><%=zhuanye %></td><td>改为</td><td><input type="text" name="zhuanye" maxlength="100" size="30"></td></tr>
<tr><td>年龄（原来）</td><td><%=age %></td><td>改为</td><td><input type="text" name="age" maxlength="100" size="30"></td></tr>
<tr><td>性别（原来）</td><td><%=sex %></td><td>改为</td><td><input type="text" name="sex" maxlength="100" size="30"></td></tr>
<tr><td>最大可借阅数（原来）</td><td><%=maxno %></td><td>改为</td><td><input type="text" name="maxno" maxlength="100" size="30"></td></tr>
<tr><td>阅览证到期时间（原来）</td><td><%=data %></td><td>改为</td><td><input type="text" name="data" maxlength="100" size="30"></td></tr>
<tr><td>类别（原来）</td><td><%=kind %></td><td>改为</td><td><input type="text" name="kind" maxlength="100" size="30"></td></tr>
<tr><td>备注信息（原来）</td><td><%=beizhu %></td><td>改为</td><td><input type="text" name="beizhu" maxlength="100" size="30"></td></tr>
<tr><td><input type="submit" value=" 更改 " name="search"> </td><td><input type="reset" value=" 清 除 "></td></tr>
<tr><td><a href = ./welcome.jsp>返回</a></td></tr>
</table>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -