searchviewpointservlet.java

利用jsp

package com.ibm.j2ee.zhanjiang.servlet;

import java.io.IOException;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Statement;

import javax.servlet.Servlet;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.ibm.j2ee.zhanjiang.bean.DBConnection;

/**
 * @version 	1.0
 * @author
 */
public class SearchViewPointServlet extends HttpServlet implements Servlet {

	String user;
	String[] delete;
	/**
	* @see javax.servlet.http.HttpServlet#void (javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
	*/
	public void doGet(HttpServletRequest req, HttpServletResponse resp)
		throws ServletException, IOException {
		delete = new String[100];
		user = req.getParameter("hide");
		parse();
		if (delete() == 1) {
			req.getRequestDispatcher(
				"/admin/success.jsp").forward(
				req,
				resp);
		} else {
			req.getRequestDispatcher(
				"/admin/error.jsp").forward(
				req,
				resp);
		}
	}

	public void parse() {
		String temp;
		String name = "";
		int id = 0;
		int j = 0;
		for (int i = 0; i < user.length(); i++) {
			temp = "";
			temp = user.substring(i, i + 1);
			if (temp.charAt(0) == ' ') {
				//int j = (int)Integer.parseInt(temp);
				if (j > 0) {
					delete[id] = name;
					name = "";
					id++;
				}
				j++;
			} else {
				name += temp;
			}
		}
		delete[id] = name;
		name = "";
		id++;
	}

	public int delete() {
		DBConnection conn = new DBConnection();
		conn.DBConnect();
		PreparedStatement ps;

		for (int i = 0; i < delete.length; i++) {
			if (delete[i] != null) {
				String query =
					new String("DELETE FROM zjTravel WHERE ID = ");
				query = query + "'" + delete[i] + "'";
				try {
					Statement stmt = conn.getConnection().createStatement();
					//ps = conn.getConnection().prepareStatement("DELETE FROM zjTravel WHERE ID = "+ "'" + delete[i] + "'");
					stmt.executeUpdate(query);
					conn.ConnectionCommit();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
					return -1;
				}
			}
		}
		conn.ConnectionClosed();
		return 1;
	}
	/**
	* @see javax.servlet.http.HttpServlet#void (javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
	*/
	public void doPost(HttpServletRequest req, HttpServletResponse resp)
		throws ServletException, IOException {
		doGet(req, resp);
	}

}