listsysdept.java

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

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;

/**
 * 获取部门列表
 * 
 * @author zxh
 * 
 */
public class ListSysDept extends ActionInstance {
	public int execute(ActionForm af) throws Exception {
		String shbdwbh = af.getHttpSession().getAttribute("HBDWBH").toString();

		DataForm deptdf = new DataForm("T_BM", "ID");
		StringBuffer sbsql = new StringBuffer();
		sbsql.append("SELECT * FROM T_BM where HBDWBH='"+shbdwbh+"'");
		List list = DaoUtil
				.select(af.getConnection(), sbsql.toString(), deptdf);

		af.getHttpRequest().setAttribute("deptlist", list);
		return 1;
	}

}