📄 student.jsp
字号:
<%@ page contentType="text/html; charset=GB2312"%>
<%@ page language="java" import="java.sql.*"%>
<jsp:directive.page import="news.sql_data"/>
<HTML>
<HEAD>
<TITLE>student.jsp</TITLE>
</HEAD>
<SCRIPT LANGUAGE="JavaScript">
function btnClick(type){
var fm=document.form1
if(type=='add'){
fm.c.value=1;
return true;
}else if(type=='edt'){
fm.c.value=2;
return true;
}else if(type=='del'){
fm.c.value=3;
return true;
}
}
function cjgl(){
window.location="teacher.jsp"
}
function login(){
window.location="login.jsp"
}
</SCRIPT>
<jsp:useBean id="db" scope="session" class="news.sql_data"/>
<BODY>
<%!
public String Bytes(String str)
{
try{
String str_1=str;
byte[] str_2=str_1.getBytes("ISO8859-1");
String bytes=new String(str_2);
return bytes;
}catch(Exception ex){
System.out.println("中文乱码解决问题出错"+ex.getMessage());
}
return null;
}
%>
<% try{
String parm = request.getParameter("c");
if(parm==null)
{
parm="";
}
// request.setCharacterEncoding("GBK");
String id=(String)session.getAttribute("ID");
String name=(String)session.getAttribute("name");
String password=request.getParameter("password");
String roleid=(String) session.getAttribute("roleid");
if (parm.equals("1")) {
String mysql = "insert into news values" + "(" + id+",'"
+ name + "','" + password
+ "'," + roleid + ")";
db.executeUpdate(mysql);
}else if (parm.equals("2")) {
String mysql = "update news set name='"
+ name + "',password='" + password + "',roleid="
+ roleid + " where id=" + id ;
db.executeUpdate(mysql);
} else if(parm.equals("3")){
String mysql = "delete from news where id="
+ id ;
db.executeUpdate(mysql);
}
ResultSet rs=db.executeQuery("select news.id,news.name,news.password,role.role from news,role where news.roleid=role.id and news.ID="+session.getAttribute("ID"));
%>
<%//session的设置
if(session.getAttribute("name")==null){%>
<script language="JavaScript">
window.location="login.jsp"
</script>
<%}
else
{%>
用户名：<%=session.getAttribute("name")%>
<input type="button" value="重新登录" onclick="login()">
<%}
%>
<table border="1" align="center" >
<tr><td align="center" colspan="4">个人信息</td></tr>
<tr bgcolor="d1d1ff">
<th>ID</th><th>姓 名</th><th>密 码</th><th>角 色</th>
</tr>
<%
while(rs.next()){
%>
<tr>
<td><%=rs.getString(1)%></td>
<td><%=rs.getString(2)%></td>
<td><%=rs.getString(3)%></td>
<td><%=rs.getString(4)%></td>
</tr>
<%}
rs.close();
db.closeStmt();
db.closeConn();
}catch(Exception exc1){
System.out.println("在执行数据库访问时发生了错误！");
exc1.printStackTrace();
}
%>
</table>
<center>
<form id="form1" name="form1" method="post" action="student.jsp">
请输入新密码:
<input type="password" name="password" value="" >
<br> <br>
<input type="hidden" name="c" id="c">
<input type="submit" name="edt" value="修改密码" onclick="btnClick('edt')">
<%
if(Integer.parseInt((String)session.getAttribute("roleid"))==0||Integer.parseInt((String)session.getAttribute("roleid"))==1){
%>
<input type="button" onClick="cjgl()" value="成绩管理" >
<%
} %>
<input type="button" name="ret" value="返回" onclick="alert('11');history.go(-1)">
<input type="button" onClick="window.opener = '';window.close();" value="关闭" >
</form>
</center>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -