newpointservlet.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;

import javax.servlet.jsp.JspFactory;
import javax.servlet.jsp.PageContext;

import com.jspsmart.upload.SmartUpload;
import com.jspsmart.upload.SmartUploadException;

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

	/**
	* @see javax.servlet.http.HttpServlet#void (javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
	*/

	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 = "INSERT INTO zjTravel(ID,NAME,DES,CITY) VALUES(";

		try {
			Statement stm = conn.getConnection().createStatement();

			sqls =
				sqls
					+ "'"
					+ id
					+ "',"
					+ "'"
					+ name
					+ "',"
					+ "'"
					+ des
					+ "',"
					+ "'"
					+ location
					+ "')";
			stm.executeUpdate(sqls);

			conn.ConnectionCommit();
			conn.ConnectionClosed();
			
			SmartUpload smart = new SmartUpload();
			
			PageContext pageContext = JspFactory.getDefaultFactory().
			getPageContext(this, req, resp, null, true,
			8192, true);

			//上传初始化
			smart.initialize(pageContext);
			smart.upload();
			String filename="";
			//获取文件名
			filename=smart.getRequest().getParameter("filename");
			//获取文件扩展名
			String ext=smart.getFiles().getFile(0).getFileExt();
			//保存上传的文件
			smart.getFiles().getFile(0).saveAs("/panorama/ivp/"+filename+"."+ext);  
			
			req.getRequestDispatcher("/admin/success.jsp").forward(req, resp);

		} catch (SQLException e1) {

			e1.printStackTrace();
			req.getRequestDispatcher("/admin/error.jsp").forward(req, resp);

		} catch (ServletException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SmartUploadException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}

	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);
	}

}