listsysuser.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 ListSysUser extends ActionInstance {
	public int execute(ActionForm af) throws Exception {
		DataForm userdf = new DataForm("SYS_USER", "ID");
		String sql = "SELECT u.*,ur.BM_NAME FROM SYS_USER u left join T_BM ur on ur.BMID=u.DEPARTMENT_ID";
		List userlist = DaoUtil.select(af.getConnection(), sql, userdf);
		af.getHttpRequest().setAttribute("userlist", userlist);
		return 1;
	}

}