addtofavoritecontroller.java

ssd7考试exam3,绝对有用~欢迎下载

import java.util.*;
import java.io.*;
import java.net.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import library.DBWrapper;
import library.BookTitleSet;
import library.BookTitle;

/**
 * Class <b>SearchController</b> contains 
 * the servlet controller functionality for processing
 * user search requests.
 * 
 *
 * @author zxw
 * @version 1.0.0
 */
public class AddToFavoriteController extends Controller {

    /**
     * AddToFavoriteController doPost method.  This is can be called
     * by <b>Controller</b> superclass' doGet() method.
     * @param request HttpServletRequest servlet request object
     * @param response HttpServletResponse servlet response object
     * @throws ServletException
     * @throws IOException
     */
    public void doPost (HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {
	
	String TitleID = request.getParameter("TitleID");
	String CustomerID= request.getParameter("CustomerID");
	
	// Redirect the user back to the index page if no terms are selected
	if (pterms.equals("")) {
	    response.sendRedirect("/library/index.jsp");
	} else {
	    // Get the searchby parameter;
	    String searchby = request.getParameter("searchby");		
	    
	    String sql = " INSERT INTO FavoriteTitles (TitleID, CustomerID) VALUES ";
		sql += "('" +TitleID+"','" + CustomerID + "')";

	//update the data into database. 
	    int re = db.executeUpdate( sql );

	    return;
	}
    }
}