yanz.java

网上商店用户能够查找自己的订单用户浏览所有的商品。 用户可按商品类别进行查找商品。 用户可购买自己需要的商品。 用户可对购物车进行管理。 提交订单

package com;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class yanz extends HttpServlet {

	
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {		
		this.doPost(request, response);
	}
	
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		request.setCharacterEncoding("gbk");
		response.setContentType("text/html;charset=gbk");
		System.out.print("******");
		Database data=new Database();
		String ID=request.getParameter("nam");
		String pwd=request.getParameter("pwd");
		
		
		ResultSet rs=data.query("select * from RegUser where Userid='"+ID+"'" );
		//*******************************************判断是否是会员
		 try {
			if(rs.next())
			  {
			 // rs.beforeFirst();
			 String s= rs.getString("Password");
      //	**************************************判断密码是否正确
			 if(pwd.equals(s))
			 {
				 request.getSession().setAttribute("username",ID);
				 
				 response.sendRedirect("Index.jsp");
			 }
			 // System.out.println(s);
			  }
			 else
			  {
				 PrintWriter out=response.getWriter();
				 	 
				out.println("对不起,您不是会员,请您注册!!!");
			  }
			
		} catch (SQLException e) {
			
			e.printStackTrace();
		}
	}
}