admincheck1.jsp

用jsp和Oracle数据库写的一个论坛系统

<%@ include file="conn.jsp"%>
<%request.setCharacterEncoding("GB2312");
String adminname=request.getParameter("adminname");
String adminpwd=request.getParameter("adminpwd");
if(adminname==null){
 out.print("<SCRIPT language=JavaScript>alert('请输入管理员名！');");
   out.print("history.go(-1);</SCRIPT>"); 
}
if(adminpwd==null){
 out.print("<SCRIPT language=JavaScript>alert('请输入密码！');");
   out.print("history.go(-1);</SCRIPT>"); 
}
String sql="select * from scott.bbsadmin where adminname='" + adminname + "'and adminpwd = '" + adminpwd + "'"; 
ResultSet rs=stmt.executeQuery(sql); 
   if(rs.next()){
	   session.putValue("admin","admin"); 
	   response.sendRedirect("adminsport.jsp"); 
   }else{
 out.print("<SCRIPT language=JavaScript>alert('密码错误！');");
   out.print("history.go(-1);</SCRIPT>"); 
   }

%>