login_user_deal.jsp

这是一个JSP+SQL Server论坛管理系统 基本实现了论坛的所有功能 数据库文件在上传的文件中

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="connBean" scope="page" class="beans.connDB"/>
<%
request.setCharacterEncoding("GB2312");
String username=request.getParameter("username");
String PWD=request.getParameter("PWD");
if(username!=""){%>
<%	ResultSet rs=connBean.executeQuery("select * from tb_User where UserName='"+username+"' and status='用户'");
	if (rs.next()){
		String rsPWD=rs.getString("PWD");
		if(PWD.equals(rsPWD)){%>
			<script language="javascript">
			opener.location.reload();
			window.close();
			</script>
		<%
		//String UserName=username;
		//session.setAttribute("username",UserName);
                session.setAttribute("username",username);
		}else{%>
		<script language="javascript">
		alert("您输入的密码不正确，请重新输入！");
		history.back();
		</script>
		<%}
	}else{ %>
<script language="javascript">
alert("您输入的用户名不正确，请重新输入！");
history.back();
</script>
<%}
}%>