saveuser.jsp

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

<%@ include file="conn.jsp"%>
<%if ((session.getValue("admin")==null)||(session.getValue("admin")=="")){
 response.sendRedirect("admin.jsp");
}
  
	String sql;
String newpin=request.getParameter("newpin");
String manager=request.getParameter("manager");
String Submit1=request.getParameter("Submit");
String oldmanager=request.getParameter("oldmanager");

if(Submit1.equals("修改")){
  out.print("update scott.admin set username='"+manager+"', password='"+newpin+"' where username='"+oldmanager+"'");
  stmt.executeUpdate("update scott.admin set username='"+manager+"', password='"+newpin+"' where username='"+oldmanager+"'");
   }
 if(Submit1.equals("删除")){
  stmt.executeUpdate("delete from scott.admin  where username='"+oldmanager+"'");
   }      
   
  
response.sendRedirect("adminuser.jsp");
   
%>