checkservlet.java

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

package servlet;

import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
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 CheckServlet extends HttpServlet {

	@Override
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		HttpSession s=request.getSession();
		User ub=(User)s.getAttribute("user");
		String username=ub.getUsername();
		String name=request.getParameter("name");
		name=new String(name.getBytes("iso-8859-1"),"gbk");
		String y_id=request.getParameter("y_id");
		String y_pwd=request.getParameter("y_pwd");
		Order o=(Order)s.getAttribute("sum");
		int sum=o.getSum();
		DaoBase db=new DaoBase();
		Connection conn=db.getConn();
		String sqli="insert into book_user values(?,?,?,?,?)";
		String sqld="delete [order] where username=?";
		try {
			PreparedStatement ps=conn.prepareStatement(sqli);
			ps.setString(1, username);
			ps.setString(2, name);
			ps.setString(3, y_id);
			ps.setString(4, y_pwd);
			ps.setInt(5, sum);

			ps.executeUpdate();
			PreparedStatement ps1=conn.prepareStatement(sqld);
			ps1.setString(1, username);
			ps1.executeUpdate();
			
			ps.close();
			ps1.close();
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		db.closeConn();
		request.getRequestDispatcher("jie.jsp").forward(request, response);
	}
	

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

}