selectorder.java

来自「网上购书系统 采用jsp+servlet+sql2000」· Java 代码 · 共 60 行

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

public class SelectOrder extends HttpServlet {

	@Override
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		DaoBase db=new DaoBase();
		Connection con=db.getConn();
		HttpSession hs=request.getSession();
		User ub=(User)hs.getAttribute("u");
		ArrayList al=new ArrayList();
		String sqlc="select * from [order] where username=?";
		try{
			PreparedStatement ps=con.prepareStatement(sqlc);
			ps.setString(1, ub.getUsername());
			ResultSet rs=ps.executeQuery();
			while(rs.next())
			{
				Order o=new Order();
				o.setId(rs.getInt(1));
				o.setBookname(rs.getString(2));
				o.setUsername(rs.getString(3));
				o.setPrice(rs.getInt(4));
				o.setHow(rs.getInt(5));
				al.add(o);
			}
		} catch (SQLException e) {
			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);
	}

}