saveuser2.jsp

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

<%@ include file="../conn.jsp"%>
<%request.setCharacterEncoding("GB2312");
String oldpin= request.getParameter("oldpin");
	String newpin= request.getParameter("newpin");
	String manager= request.getParameter("manager");
	String oldmanager= request.getParameter("oldmanager");
if ((session.getValue("admin")==null)){
	response.sendRedirect("login.jsp"); 
}else{
 String aaa= (String) session.getValue("flag"); 
	int ddd=Integer.parseInt(aaa);
	if(ddd>1){
		out.print("<br><p align=center>您没有操作的权限</p>");
	}else{
	


   String submitoption="修改";
if(submitoption.equals(request.getParameter("Submit")))
 {
//进行修改操作
 stmt.executeUpdate("update scott.user1 set username='"+manager+"',password='"+newpin+"'  where username='"+oldmanager+"'");
response.sendRedirect("adminuser1.jsp"); 
 }
submitoption="删除";
if(submitoption.equals(request.getParameter("Submit")))
 {
//进行删除操作
stmt.executeUpdate("delete from scott.user1  where username='"+oldmanager+"'");
response.sendRedirect("adminuser1.jsp"); 
 }     
	}
}

%>