signin.jsp

一个用MYECLIPSE开发的网上购物系统。 基本功能都已经实现

<%@ page language="java" import="java.util.*"  import="java.sql.*"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<jsp:useBean id = "connBean" scope="session" class="db.DbAccess"/>
<% String userId = (String)request.getParameter("userId");
	String password1 = (String)request.getParameter("password");
	String password2 = null;
	if(userId == null || userId.equals("")){
		response.sendRedirect("../default.jsp?error=1");
	}
	try{
			Connection conn = connBean.getConnection();
			if(conn != null){
				java.sql.Statement dstmt = conn.createStatement(); 
   			 	ResultSet rs = dstmt.executeQuery("select password from signon where username = '"+ userId +"'");
    			while(rs.next()){
        			password2 = rs.getString("password");
     			}
    			 rs.close();
        	}
        }
       catch(Exception e){
        }
	
    
    if(password1.equals(password2)){
    	session.setAttribute("username",userId);
    	response.sendRedirect("../product/viewCatalog.jsp");
     }
     else{
     	response.sendRedirect("../default.jsp?error=2");	
     }
%>