office_mail_inboxreadaction.java

这个程序是花了好几十万请人开发的

/*
 * 
 * @author 郑文金
 *
 * 这个action用于在"网上办公室"中读取收件箱中的信息
 *
 */
package struts.action;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import javabean.*;
import java.sql.*;
public class Office_Mail_inboxreadAction extends Action {
	
	private ConnectionPool pool;
	private Connection con;
	public Office_Mail_inboxreadAction() throws SQLException
	{
		pool=ConnectionPool.getInstance();               //初始化连接池
	
	}
	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response)
		throws Exception 
	{
		CodeString codestring=new CodeString();
		con=pool.getConnection();  //从池中获得一个连接	
		String id=request.getParameter("code");
		
		Mail_inboxdao inboxdao=new Mail_inboxdao(con);
		String readflag="false";
		String s1="select * from mail_inbox where ID= "+"'"+id+"'";//用于查询出该ID的邮件的所有信息
		Mail_inbox inbox=inboxdao.showdetials(s1);
		String s2="update mail_inbox set readflag= "+"'"+readflag+"'"+" where ID= "+"'"+id+"'";
		inboxdao.update(s2);//修改邮件是否以读的标志;
		request.setAttribute("inbox",inbox);
		con.commit();
		if(con!=null)
		{
			con.close();
		}
		return mapping.findForward("office_mail_inboxread");		
	}

}