addnj.jsp

来自「本系统应用JSP、flashMX2004软件结合flash communicat」· JSP 代码 · 共 37 行

<%@ page contentType="text/html;charset=gb2312"%>
<%@ include file="top.jsp"%>
<%
String njmanager=(String)session.getAttribute("njmanager");
if(njmanager==null){
	response.sendRedirect("check.htm");
	return;
}
%>
<%@ include file="class.jsp"%>
<%
String njname=new String(request.getParameter("njname").getBytes("iso-8859-1"));
String njpass=new String(request.getParameter("njpass").getBytes("iso-8859-1"));
int type=Integer.parseInt(request.getParameter("type"));
String sqlstr="insert into nj (username,password,管理员) values ('"+njname+"','"+njpass+"',"+type+")";
int exit=0;
ResultSet rs=stmt.executeQuery("select*from nj");
while(rs.next()){
	String username=rs.getString("username");
	if(username.equals(njname)){
		exit=1;
	}
}
rs.close();
if(exit==0){
stmt.executeUpdate(sqlstr);
%>
<script>
alert("添加NJ成功，请返回！");
window.history.back();
</script>
<%}else{%>
<script>
alert("该用户已经存在，请返回！");
window.history.back();
</script>
<%}%>