saveuser1.jsp

JSP+ORACLE网站开发实例（下）.rar

<%@ include file="conn.jsp"%>
<%if ((session.getValue("admin")==null)||(session.getValue("admin")=="")){
 response.sendRedirect("admin.jsp");
}
	String sql;
String username=request.getParameter("username");
String newpin=request.getParameter("newpin");
String right_class=request.getParameter("right_class");
if((right_class!=null)&&(username!=null)){

sql="select username from scott.admin where username='"+username+"'"; 
ResultSet rs_lar=stmt.executeQuery(sql); 
    if(rs_lar.next()){
out.print("<script>alert('该用户名已经存在');history.go(-1);</script>");
	}else{
 stmt1.executeUpdate("INSERT INTO scott.admin(username,password,flag) VALUES('"+username+"','"+newpin+"','"+right_class+"')");
response.sendRedirect("adminuser.jsp");
   }
}
%>