panservlet.java

网上购书系统 采用jsp+servlet+sql2000

package servlet;

import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
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;
import javax.servlet.http.HttpSession;

import base.DaoBase;
import bean.Order;
import bean.User;

public class PanServlet extends HttpServlet {

	@Override
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		String bookname=request.getParameter("bookname");
		bookname=new String(bookname.getBytes("iso-8859-1"),"gbk");
		Order o=new Order();
		o.setBookname(bookname);
		DaoBase db=new DaoBase();
		Connection conn=db.getConn();
		HttpSession hs=request.getSession();
		User ub=(User)hs.getAttribute("user");
		String sql="select * from [order] where bookname=? and username=?";
		try {
			PreparedStatement ps=conn.prepareStatement(sql);
			ps.setString(1, o.getBookname());
			ps.setString(2, ub.getUsername());
			ResultSet rs=ps.executeQuery();
			if(rs.next())
			{
				request.setAttribute("cz", "cz");
				request.getRequestDispatcher("broswer").forward(request, response);
			}
			else
			{
				request.getRequestDispatcher("Curt").forward(request, response);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}

	@Override
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		super.doGet(request, response);
	}

}