productinfo.java

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

package hunnu.edu.cn.product.servlet;



import hunnu.edu.cn.product.common.splitPages.PagedStatementOracleImpl;
import hunnu.edu.cn.product.common.splitPages.RowSetPage;

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

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 java.sql.*;

public class ProductInfo extends HttpServlet {

	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	
	/**
	 * Constructor of the object.
	 */
	public ProductInfo() {
		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 {

		
		HttpSession session = request.getSession(true);
		response.setContentType("text/html;charset=gbk");
     	String  pro_id = request.getParameter("pro_id");
		String page= request.getParameter("page");
		String feedPage = request.getParameter("feedPage");
		String str;
		String sql;
		String feed;
		
		if(pro_id==null){
			str=(String)session.getAttribute("fileInfoSql");
		    sql = (String)session.getAttribute("productInfoSql");
		    feed = (String)session.getAttribute("feedSql");
		}
		else{
	       str ="select file_name, file_comment,file_stg_id from tb_pro_file where pro_id="+pro_id;
	       sql = "select pro_id,pro_name,chk_ymd,in_ymd,pro_comnt, pro_inf,tb_product.in_user_id as in_user_id,user1.user_name as in_user_name,user2.user_name as chk_user_name ,type_name ,counter,pro_flg_name ,backcount from tb_product left outer join tb_user_mst user1 on tb_product.in_user_id=user1.user_id left outer join tb_user_mst user2 on tb_product.chk_user_id=user2.user_id left outer join tb_file_type  using (pro_id) left outer join tb_type_mst on tb_file_type.type_id=tb_type_mst.type_id left outer join tb_download_file using(pro_id) left outer join tb_pro_flg using(pro_flg) left outer join tb_feedback_mst using(pro_id) where pro_id="+pro_id;
	       feed ="select user_login,feedback_level ,tb_feedback.feedback_content as content,to_char(feedback_ymdhms,'yyyy-mm-dd \"  \"HH24:MI:SS PM ') as feedback_ymdhms from tb_feedback  left outer join tb_user_mst on tb_feedback.user_id=tb_user_mst.user_id where pro_id="+pro_id;
	       session.setAttribute("fileInfoSql", str);
	       session.setAttribute("productInfoSql", sql);
	       session.setAttribute("feedSql",feed);
		}
//		String user_group_id =request.getParameter("user_group_id");
    	
    
    	PagedStatementOracleImpl pso =null ;
    	PagedStatementOracleImpl feedback =null ;
   
        PagedStatementOracleImpl  productInfo=new PagedStatementOracleImpl(sql);
    	if(page!=null){
    		int pageNo=0;
    		
    		pageNo=Integer.parseInt(page);
    		System.out.println(pageNo);
    		pso = new PagedStatementOracleImpl(str,pageNo,3);
    		
    	}
    	else{
    		
    		pso = new PagedStatementOracleImpl(str,1,3);
    		
    	}
    	 if(feedPage!=null){
    		 int feedPageNo = 0;
    		 feedPageNo = Integer.parseInt(feedPage);
    		 feedback = new PagedStatementOracleImpl(feed,feedPageNo,3);
    		 
    	 }
    	 else{
    		 feedback = new PagedStatementOracleImpl(feed,1,3);
    	 }
		try{
			 
			 RowSetPage rsp  = pso.executeQuery();
			 request.setAttribute("pro_file",rsp);
			 rsp = productInfo.executeQuery();
			 request.setAttribute("productInfo",rsp);
			 rsp = feedback.executeQuery();
			 request.setAttribute("feedback",rsp);
			 
		   
		 
		}catch(SQLException e){
			
			
			System.out.println(e.getMessage());
		}  
		
		

			
	
		
			RequestDispatcher rd; 
			rd=request.getRequestDispatcher("ProductInfor.jsp"); 
			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
	}

}