feedbackservlet.java

一个完整的代码管理系统的源代码

package hunnu.edu.cn.product.servlet;


import hunnu.edu.cn.product.common.db.DBProcess;
import hunnu.edu.cn.product.common.db.DBWrapper;

import hunnu.edu.cn.product.common.util.ParameterUtils;

import java.io.IOException;
import java.io.PrintWriter;

import java.sql.Connection;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Timestamp;


import javax.servlet.RequestDispatcher;
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 oracle.jdbc.OraclePreparedStatement;
import oracle.jdbc.driver.OracleConnection;
import oracle.sql.CLOB;


public class FeedBackServlet extends HttpServlet {

	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;

	/**
	 * Constructor of the object.
	 */
	public FeedBackServlet() {
		super();
	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	/**
	 * The doGet method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to get.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		response.setContentType("text/html;charset=gbk");
		HttpSession session = request.getSession(true);
		String content_level= request.getParameter("content_level");
		System.out.println(content_level);
		String content= ParameterUtils.getString(request, "content");
		System.out.println(content);
		String pro_id = (String)session.getAttribute("pro_id");
		System.out.println(pro_id);
		String user_id=(String)session.getAttribute("user_id");
	
	
		DBProcess dbwrapper = new DBWrapper();
		Connection conn =null;
		
		int feedback_id =0;
		try{
			conn=dbwrapper.getConnection();
			Statement stmt = conn.createStatement();
			
			 
			String str ="select max(feedback_id) from tb_feedback  ";
			ResultSet rs = stmt.executeQuery(str);
			while(rs.next())
				feedback_id = rs.getInt(1)+1;
		    System.out.println(feedback_id);
			 System.out.println("succellful");
			
			 
		}
		catch(Exception e){
			System.out.println(e.getMessage());
		}finally{
			
			try
			{
				if(conn!=null)
				   dbwrapper.closeConnection(conn);
			}catch (SQLException e)
			{
				e.printStackTrace();
			}
		
		}
		if(user_id!=null){
		
		
			String sql ="insert into tb_feedback(pro_id,feedback_id,user_id,feedback_level,feedback_content,feedback_ymdhms) values(?,?,?,?,?,?)";
				
		  
			  
		try{
			  conn=dbwrapper.getConnection();
			  conn.setAutoCommit(false);  //conn为Connection对象

			//创建并实例化一个CLOB对象

			   CLOB clob = new CLOB((OracleConnection)conn);
			  
				Timestamp time=new java.sql.Timestamp(System.currentTimeMillis());
			   clob = oracle.sql.CLOB.createTemporary((OracleConnection)conn,true,1);

			//对CLOB对象赋值

			    clob.setString(1,content); 

			    OracleConnection OCon = (OracleConnection)conn;

			    OraclePreparedStatement pstmt = (OraclePreparedStatement)OCon.prepareCall(sql);
			    System.out.println(feedback_id);
				
				 pstmt.setInt(1,Integer.parseInt(pro_id));
				 pstmt.setInt(2,feedback_id);
				 pstmt.setInt(3,Integer.parseInt(user_id));
				 pstmt.setInt(4,Integer.parseInt(content_level));
				 pstmt.setCLOB(5,clob);
				 
				 pstmt.setTimestamp(6,time);
			     pstmt.executeUpdate();

			     pstmt.close();

			     OCon.commit();

			     conn =OCon;

     

		
			
		}catch(Exception e){
			System.out.println(e.getMessage());
			
			
		}finally{
			try
			{
				if(conn!=null)
				   dbwrapper.closeConnection(conn);
			}catch (SQLException e)
			{
				e.printStackTrace();
			}
			
		}
		  }
	
		
		RequestDispatcher rd; 
		rd=request.getRequestDispatcher("/ProductInfo?pro_id="+pro_id); 
		rd.forward(request,response); 
	}

	/**
	 * The doPost method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to post.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		response.setContentType("text/html");
		PrintWriter out = response.getWriter();
		out
				.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
		out.println("<HTML>");
		out.println("  <HEAD><TITLE>A Servlet</TITLE></HEAD>");
		out.println("  <BODY>");
		out.print("    This is ");
		out.print(this.getClass());
		out.println(", using the POST method");
		out.println("  </BODY>");
		out.println("</HTML>");
		out.flush();
		out.close();
	}

	/**
	 * Initialization of the servlet. <br>
	 *
	 * @throws ServletException if an error occurs
	 */
	public void init() throws ServletException {
		// Put your code here
	}

}