📄 admin.jsp
字号:
<%@ page contentType="text/html; charset=GB2312"%>
<%@ page language="java" import="java.sql.*"%>
<jsp:directive.page import="news.sql_data"/>
<HTML>
<HEAD>
<TITLE>admin.jsp</TITLE>
<link rel="stylesheet" href="m_style.css" type="text/css">
</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 login(){
window.location="login.jsp"
}
function radio() {
l=document.getElementsByName("radio")
for(i=0;i<l.length;i++) {
if(l[i].checked)
document.getElementById("id").value=l[i].value
}
}
</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=request.getParameter("id");
String name=Bytes(request.getParameter("name"));
String password=request.getParameter("password");
String roleid=Bytes(request.getParameter("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 order by news.id");
%>
<%
if(session.getAttribute("name")==null){%>
<script language="JavaScript">
window.location="login.jsp"
</script>
<%}
else
{%><table>
<tr>
<td>
用户名：<%=session.getAttribute("name")%>
<input type="button" value="重新登录" onclick="login()">
</td>
</tr>
</table>
<%}
%>
<table border="1" align="center" >
<tr><td align="center" colspan="5">成员列表</td></tr>
<tr bgcolor="d1d1ff">
<th>ID</th><th>姓 名</th><th>密 码</th><th>角 色</th><th>选择</th>
</tr>
<%
while(rs.next()){
String a =rs.getString("id");
%>
<tr>
<td><%=rs.getString("id")%></td>
<td><%=rs.getString("name")%></td>
<td><%=rs.getString("password")%></td>
<td><%=rs.getString("role")%></td>
<td><input type="radio" id="radio" name="radio" onclick="radio()" value="<%=a%>"></td>
</tr>
<%}
rs.close();
db.closeStmt();
db.closeConn();
}catch(Exception exc1){
System.out.println("在执行数据库访问时发生了错误！");
exc1.printStackTrace();
}
%>
</table>
<form id="form1" name="form1" method="post" action="admin.jsp">
<table align="center">
<tr>
<td> I D: </td>
<td><input type="text" name="id" id="id" value="" > </td>
</tr>
<tr>
<td> 名 字: </td>
<td><input type="text" name="name" value="" > </td>
</tr>
<tr>
<td>密 码:</td>
<td> <input type="password" name="password" value="" > </td>
</tr>
<tr>
<td>角色ID:</td>
<td><input type="text" name="roleid" value=""> </td>
</tr>
<tr>
<td colspan="2"> <input type="hidden" name="c" id="c">
<input type="submit" name="add" value="新增" onclick="btnClick('add')" >
<input type="submit" name="edt" value="修改" onclick="btnClick('edt')">
<input type="Submit" name="del" value="删除" onclick="btnClick('del')">
<input type="button" name="ret" value="返回" onclick="history.go(-1)">
<input type="button" onClick="window.opener = '';window.close();" value="关闭" >
</td>
</tr>
</table>
</form>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -