rkxzlinfo.java.svn-base

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

package com.chis.model.person;

import com.stframe.dao.DaoUtil;
import com.stframe.dao.PageUtil;
import com.stframe.form.ActionForm;
import com.stframe.form.DataForm;
import com.stframe.servlet.ActionInstance;

/**
 * 人口学资料修改
 * 
 * @author 翟昌强
 * 
 */ 
public class RkxzlInfo extends ActionInstance {
	public int execute(ActionForm af) throws Exception {
		//String id = af.getHttpRequest().getParameter("ID");
		String JMJKDAH = af.getHttpRequest().getParameter("JMJKDAH");
		String corp_code = af.getHttpSession().getAttribute("CORP_CODE").toString();
		StringBuffer sql = new StringBuffer();
		sql.append(" select a.*,((year(getdate())-year(convert(varchar(10),a.CSRQ, 111)))+1) as NL \n"); 
		sql.append(" from DA_RKXZL a  \n");
		sql.append(" where 1=1 \n");

		//if(!(JMJKDAH==null)&&!("".equals(JMJKDAH)))
		sql.append(" and JMJKDAH ='"+JMJKDAH+"' and CORP_CODE='"+corp_code+"'\n");
		
		//if(!(id==null)&&!("".equals(id)))
		//	sql.append(" and ID ='"+id+"'\n");		
        //sql.append("order by JMJKDAH asc");
		
		DataForm df = (DataForm)DaoUtil.select(af.getConnection(), sql.toString(), new DataForm("DA_RKXZL")).get(0);
		af.getHttpRequest().setAttribute("rkxzlinfo", df);

		return 1;
	} 
}