📄 addmanagerstep2.jsp
字号:
<%@page contentType="text/html;charset=gb2312"%>
<%@ include file="../incoming/Common.jsp"%>
<%@ include file="../incoming/ConnectDB.jsp"%>
<%@ include file="../incoming/Check.jsp"%>
<html>
<head>
<title><%=title%>管理</title>
<link href="../incoming/style.css" rel="stylesheet" type="text/css">
<script Language="JavaScript">
function ToManagerMain()
{
top.location="ManagerMain.jsp"
}
</script>
</head>
<body>
<%
String msg="";
try
{
String userid = new String(request.getParameter("userid").getBytes("ISO8859_1"),"GBK");
String password = new String(request.getParameter("password").getBytes("ISO8859_1"),"GBK");
String username = new String(request.getParameter("username").getBytes("ISO8859_1"),"GBK");
String categoryid = new String(request.getParameter("categoryid").getBytes("ISO8859_1"),"GBK");
java.util.Date cur_time = new java.util.Date();
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String adddate = formatter.format(cur_time);
sql1 = "INSERT INTO manager(ManagerID,Password,ManagerName,AddDate,CategoryID) VALUES(?,?,?,?,?)";
PreparedStatement prepstmt = null;
prepstmt=con.prepareStatement(sql1);
prepstmt.setBytes(1,userid.getBytes("GB2312"));
prepstmt.setBytes(2,password.getBytes("GB2312"));
prepstmt.setBytes(3,username.getBytes("GB2312"));
prepstmt.setBytes(4,adddate.getBytes("GB2312"));
prepstmt.setInt(5,Integer.parseInt(categoryid));
prepstmt.executeUpdate();
}
catch(Exception e)
{
msg = e.getMessage();
}
%>
<table border="1" width=700 align=center cellpadding=0 cellspacing=0>
<tr align="center" bgcolor="#CCCCCC" height=25>
<td height="42"><a class="title">添加管理员</a></TD>
</tr>
<tr>
<td height="56" align="center" ><div align="right"></div><span class="text">
<%
if(msg.equals(""))
out.println("添加管理员成功！");
else
out.println("添加管理员失败！错误原因："+msg);
%>
</span></td>
</tr>
<tr>
<td height="36" align=center ><FONT color=#000000>
<input name=Submit type=button value="返回管理员管理" onClick="ToManagerMain()">
</font></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -