📄 order_8_3.jsp
字号:
<%@ page contentType="text/html; charset=GB2312" %>
<%@ page import="com.hzs.order.*" %>
<jsp:useBean id="dbHandle" class="com.hzs.order.DBHandle" scope="session" />
<%
if (session.getAttribute("grade")==null||!(session.getAttribute("grade").equals("1")||session.getAttribute("grade").equals("6")))
{
%>
<jsp:forward page="con_error.jsp">
<jsp:param name="error_nm" value="非 法 操 作" />
<jsp:param name="error_all" value="非法操作,您并不是管理员!" />
</jsp:forward>
<%
}
%>
<html>
<head>
<title>用户添加结果</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="css/global.css" type="text/css">
<script language="javascript">
function go_page()
{
window.location.replace('order_8_2.jsp');
}
</script>
</head>
<%
String tx_nm=DBHandle.toChinese(request.getParameter("tx_nm"));
try{
dbHandle.connect();
String strSelect="SELECT count(*) FROM user_info where user_nm='"+tx_nm+"'";
Vector vecUser=dbHandle.select(strSelect);
if(!(vecUser.elementAt(0).toString().equals("0"))){
dbHandle.close();
%>
<jsp:forward page="con_error.jsp">
<jsp:param name="error_nm" value="注 册 错 误" />
<jsp:param name="error_all" value="用户名已经存在！"/>
</jsp:forward>
<%
}else{
String tx_pass= DBHandle.toChinese(request.getParameter("tx_pass"));
String sel_group=DBHandle.toChinese(request.getParameter("sel_group"));
String strSQL="INSERT INTO user_info (USER_NM,USER_PS,USER_GROUP) values('"+tx_nm+"','"+tx_pass+"','"+sel_group+"')";
int intResult;
dbHandle.transaction();
intResult=dbHandle.update(strSQL);
if(intResult==1){
%>
<BODY background="images/menu.gif">
<CENTER>
<H2>---用户添加成功---</H2>
<input type="button" name="bt_1" value="继续添加" onclick="go_page();">
<INPUT type="button" name="bt1" value="关 闭" onclick="self.close();">
</CENTER>
</BODY>
<%
dbHandle.commit();
}
else
{
dbHandle.rollback();
}
}
}catch( DBException e){
%>
<jsp:forward page="con_error.jsp">
<jsp:param name="error_nm" value="数 据 库 错 误" />
<jsp:param name="error_all" value="<%=e.getMessage()%>"/>
</jsp:forward>
<%
}finally{
dbHandle.close();
}
%>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -