📄 addadmin.jsp
字号:
<%@ page language="java" import="java.sql.*"%>
<%@ include file="author.jsp" %>
<%@ include file="change.jsp" %>
<%//request.setCharacterEncoding("gb2312");%>
<jsp:useBean id="linejdbc" scope="page" class="examinline.DBConnectionBean" />
<%linejdbc.setdrivername();%>
<html>
<head>
<title>创建管理员</title>
<link href="../img/cssexamin.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.unnamed1 {
font-size: 12px;
font-weight: lighter;
color: #FF0000;
text-decoration: none;
}
-->
</style>
</head>
<%
Connection conn = linejdbc.getopenConnection();
PreparedStatement ps=null;
String username="";
String Password="";
String sqlstr;
int id=0;
if (request.getParameter("username")!=null) username=request.getParameter("username");
if (request.getParameter("password")!=null) Password=request.getParameter("password");
if (request.getParameter("id")!=null) id=Integer.parseInt(request.getParameter("id"));
if (username.compareTo("")!=0)
{
sqlstr="insert into admin (name,password) values (?,?)";
ps=conn.prepareStatement(sqlstr);
ps.setString(1,username);
ps.setString(2,Password);
int rs=ps.executeUpdate();
if (rs==1)
{
%>
<script language="JavaScript">alert("添加成功！")</script>
<%
}
else
{
%>
<script language="JavaScript">alert("添加失败，请重新添加！")</script>
<%
}
}
sqlstr="select * from admin";
ps=conn.prepareStatement(sqlstr);
ResultSet result=ps.executeQuery();
%>
<body>
<form action="" method="post" name="formaddobject" >
<p align="center" class="banquan">------------------添加管理员------------------</p>
<table width="56%" border="0" align="center">
<tr>
<td width="20%" align="center" valign="middle" class="table">用户名: </td>
<td width="80%" class="table"><input name="username" type="text" class="textborder" id="username" style="color: #333300; border: 1px solid #99FF66; padding: 0; background-color: #FFFFFF" size="30">
<span class="unnamed1">*</span></td>
</tr>
<tr>
<td align="center" valign="middle" class="table">密码:</td>
<td class="table"><input name="password" type="text" class="textborder" id="password2" style="color: #333300; border: 1px solid #99FF66; padding: 0; background-color: #FFFFFF" size="30">
<span class="unnamed1">*</span></td>
</tr>
<tr align="center" valign="top">
<td colspan="2" class="table"> <input name="okbtn" type="button" id="okbtn" value="提交" onclick="okbtnclick()">
<font color="#FF0000">*</font>:为必填<font color="#333333">项</font></td>
</tr>
</table>
<hr width="500" class="table">
<table width="75%" border="0" align="center" class="table">
<tr align="center" class="table">
<td width="13%" class="table">用户名</td>
<td width="7%" class="table">密码</td>
<td width="6%" class="table">操作</td>
</tr>
<%
while (result.next())
{
%>
<tr align="center" class="table">
<td class="table"><%= result.getString("name") %> </td>
<td class="table"><%= result.getString("password") %> </td>
<td class="table"><a href="javascript:othersubmit('<%=result.getString("id")%>')">删除</a></td>
<%
}
%>
</tr>
</table>
<p><br>
</p>
<p class="banquan"><font color="#333333"></font></p>
<p> </p>
</form>
</body>
</html>
<script language="JavaScript">
function StringTrim(str) {
return str.replace(/(^\s*)|(\s*$)/g, "");
}
function okbtnclick() {
str = StringTrim(window.document.all.username.value);
if (str == "") {
alert("用户名不能为空！");
window.document.all.username.focus();
return false;
}
str = StringTrim(window.document.all.password.value);
if (str == "") {
alert("密码不能为空！");
window.document.all.password.focus();
return false;
}
if (confirm("您确认所填内容正确吗？") == 1) {
window.document.all.formaddobject.action="addadmin.jsp";
window.document.all.formaddobject.submit();
}
}
</script>
<script language="javascript">
function othersubmit(op)
{
var ss;
ss=op;
if (window.confirm("确认要删除吗?")==true)
{
window.location="deleteadmin.jsp?id="+ss;
}
}
</script>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -