welcome.java.svn-base

用JSP JAVA 做的 系统 只是初来扎到还望西黄！别乱来哦！

package com.chis.model.frame;

import java.util.List;

import com.stframe.dao.DaoUtil;
import com.stframe.form.ActionForm;
import com.stframe.form.DataForm;
import com.stframe.servlet.ActionInstance;
/**
 * 首页显示内容
 * @author zxh
 *
 */
public class Welcome extends ActionInstance {

	@Override
	public int execute(ActionForm af) throws Exception {

		//头几条
		int top=5;
		// -----------公告内容
		String userid = af.getHttpSession().getAttribute("USERID").toString();
		StringBuffer sbSql = new StringBuffer();

		sbSql
				.append("select top "+top+" nt.*,nu.NOTICE_ID,nu.READ_DATE,nu.STATUS from sys_notice nt left join sys_notice_user nu \n"
						+ "on nt.ID=nu.NOTICE_ID where nu.RECV_USER_ID='"
						+ userid + "'  ORDER BY ISSUE_DATE DESC");
		List list = DaoUtil.select(af.getConnection(), sbSql.toString(),
				new DataForm());
		for (int i = 0; i < list.size(); i++) {
			DataForm notice=(DataForm)list.get(i);
			String times=notice.get("ISSUE_DATE").toString().substring(0,10);
			notice.set("ISSUE_DATE", times);
			list.set(i, notice);
		}
		af.getHttpRequest().setAttribute("nt_list", list);
		
		
		//最新上报
		StringBuffer sbSql2 = new StringBuffer();

		sbSql2.append("select top "+top+" sur.ID,sur.PATH,su.NAME,sur.UPLOAD_DATE,sur.TITLE,sur.FILE_NAME,sur.STATUS "
				+ "from SYS_UPLOAD_REPORT sur left join SYS_USER su \n"
				+ "on sur.UPLOAD_USER_ID=su.ID where sur.RECV_USER_ID='"
				+ userid + "'  ORDER BY UPLOAD_DATE DESC");
		List list2 = DaoUtil.select(af.getConnection(), sbSql2.toString(),
				new DataForm());
		
		for (int i = 0; i < list2.size(); i++) {
			DataForm notice=(DataForm)list2.get(i);
			String times=notice.get("UPLOAD_DATE").toString().substring(0,10);
			notice.set("UPLOAD_DATE", times);
			list2.set(i, notice);
		}
		af.getHttpRequest().setAttribute("re_list", list2);
		
		//查询交流信息
		StringBuffer sbSql3 = new StringBuffer();

		sbSql3.append("select top "+top+" TITLE,ID,TYPE,ISSUE_DATE  FROM SYS_INFO where TYPE=0 ORDER BY ISSUE_DATE desc");
		List list3 = DaoUtil.select(af.getConnection(), sbSql3.toString(),
				new DataForm());
		for (int i = 0; i < list3.size(); i++) {
			DataForm notice=(DataForm)list3.get(i);
			String times=notice.get("ISSUE_DATE").toString().substring(0,10);
			notice.set("ISSUE_DATE", times);
			list3.set(i, notice);
		}
		af.getHttpRequest().setAttribute("info_list", list3);
		
		
		StringBuffer sbSql4 = new StringBuffer();

		sbSql4.append("select top "+top+" TITLE,ID,TYPE,ISSUE_DATE  FROM SYS_INFO where TYPE=1 ORDER BY ISSUE_DATE desc");
		List list4 = DaoUtil.select(af.getConnection(), sbSql4.toString(),
				new DataForm());
		for (int i = 0; i < list4.size(); i++) {
			DataForm notice=(DataForm)list4.get(i);
			String times=notice.get("ISSUE_DATE").toString().substring(0,10);
			notice.set("ISSUE_DATE", times);
			list4.set(i, notice);
		}
		af.getHttpRequest().setAttribute("info_list2", list4);

		return 1;
	}

}