free.jsp

该网上论坛除了包含数据库之外,还有能够成功地进行信息上传及返回

 <%
  ResultSet rs = connBean.executeQuery("SELECT * FROM LoginInformation WHERE UserName='"+UserName+"'");
  if(rs.next()){
  String rsUserName = rs.getString("UserName");
  if(UserName.equals("rsUserName")){
  %>
 <%@ page import="java.sql.*" errorPage="" %>
 <jsp:useBean id="connBean" scope="page" class="JavaBean.connDB"/>
 <% 
 request.setCharacterEncoding("GB2312");
 String UserName = request.getParameter("username");
 String Password = request.getParameter("password");
 
 if(UserName == ""){%>
 <script language="javascript">
 alert("your username is empty");
 history.back();
 </script>
 <%} %>
 <%if(Password==""){%>
  <script language="javascript">
 	alert("your password is empty");
 	history.back();
 </script>
 <%}%>
 <%
  ResultSet rs = connBean.executeQuery("SELECT * FROM LoginInformation WHERE UserName='"+userName+"'");
  if(rs.next()){
     String rsPassword=rs.getString("Password");
	 if(password.equals(rsPassword)){
  %>
  <script language="javascript">
   window.location.href="HomePage.jsp";
  </script>
<%}else{%>
  <script language="javascript">
  alert("your password is wrong!please input it again!");
  history.back();
  </script>
<%}}else{ %>
 <script language="javascript">
  alert("your userName is wrong!please input it again!");
 history.back();
  </script>
<%} %>