ordersservlet.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 java.util.ArrayList;

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.Book;
import bean.Order;
import bean.User;


public class OrderSServlet extends HttpServlet {

	@Override
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		DaoBase db=new DaoBase();
		Connection conn=db.getConn();
		HttpSession hs=request.getSession();
		User ub=(User)hs.getAttribute("user");
		ArrayList al=new ArrayList();
		String sqlc="select * from [order] where username=?";
		try {
			PreparedStatement ps=conn.prepareStatement(sqlc);
			ps.setString(1, ub.getUsername());
			ResultSet rset=ps.executeQuery();
			while(rset.next())
			{
				Order o=new Order();
				o.setId(rset.getInt(1));
				o.setBookname(rset.getString(2));
				o.setUsername(rset.getString(3));
				o.setPrice(rset.getInt(4));
				o.setHow(rset.getInt(5));
				
				al.add(o);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		request.setAttribute("al", al);
		request.getRequestDispatcher("order.jsp").forward(request, response);
	}
	@Override
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		super.doGet(request, response);
	}
}