empreferlist.java.svn-base

来自「用JSP JAVA 做的 系统 只是初来扎到还望西黄！别乱来哦！」· SVN-BASE 代码 · 共 23 行

/** 
 * 
 */
  
package com.chis.model.user;
  
import java.util.List;

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

public class EmpReferList extends ActionInstance{
	public int execute(ActionForm af) throws Exception {
		StringBuffer sbsql = new StringBuffer();
		sbsql.append(" select e.id,e.emp_name,d.code from employee e,DEPT d where e.dept_id=d.id and e.STATUS='1' ");
		List list = DaoUtil.select(af.getConnection(),sbsql.toString(),new DataForm(""));
		af.getHttpRequest().setAttribute("emprefer", list);
		return 1;
	}
}