changepointservlet.java

利用jsp

package com.ibm.j2ee.zhanjiang.servlet;

import java.io.IOException;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
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;
import com.ibm.j2ee.zhanjiang.bean.Decode;

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

	public void processRequest(
			HttpServletRequest req,
			HttpServletResponse resp)
		throws ServletException, IOException {
			DBConnection conn = new DBConnection();
			String id = Decode.deCode((String)req.getParameter("id"));
			String name = Decode.deCode((String)req.getParameter("name"));
			String location = Decode.deCode((String)req.getParameter("location"));
			String des = Decode.deCode((String)req.getParameter("des"));
			conn.DBConnect();
		
			String sqls = new String("UPDATE zjTravel SET CITY = '"+location+"',NAME='"+name+"'"+",DES='"+des+"' WHERE ID = '"+id+"'");	
		
			try {
				Statement stm =
					conn.getConnection().createStatement();
				
				stm.executeUpdate(sqls);
			
				conn.ConnectionCommit();
				conn.ConnectionClosed();
				req.getRequestDispatcher(
					"/admin/success.jsp").forward(
					req,
					resp);

			} catch (SQLException e1) {

				e1.printStackTrace();
				req.getRequestDispatcher(
					"/admin/error.jsp").forward(
					req,
					resp);
			}
		
		}
	/**
	* @see javax.servlet.http.HttpServlet#void (javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
	*/
	public void doGet(HttpServletRequest req, HttpServletResponse resp)
		throws ServletException, IOException {
			processRequest(req, resp);
	}

	/**
	* @see javax.servlet.http.HttpServlet#void (javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
	*/
	public void doPost(HttpServletRequest req, HttpServletResponse resp)
		throws ServletException, IOException {
			processRequest(req, resp);
	}

}