tj_lists.java

1.员工添加 2.人事调动 3.在职人员管理 4.部门（分厂）管理

package pmsys.wyj;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.DynaActionForm;
import org.apache.struts.actions.DispatchAction;

import javax.servlet.http.HttpSession;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.PreparedStatement;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import pmsys.*;

public class TJ_Lists {
	/**
	 * 生成下拉列表集合
	 */
	public ArrayList lists(DataSource ds,String sql) {
		ArrayList dlist = new ArrayList();
		Connection conn = null;
		try{

			//链接池连接数据库
			//DataSource ds = (DataSource)this.getDataSource(request,"oracledb");
			
			conn = ds.getConnection();
			
			//查处所有交费类型
			Statement stmt = conn.createStatement();
			String sql1 = sql;
			ResultSet rs = stmt.executeQuery(sql1);
			//将数据库表字段值存入UserForm的相应属性中
			while(rs.next()) {
				UserForm account = new UserForm();
				account.setDeptno(rs.getInt(1) + "");
				account.setDname(rs.getString(2));
				dlist.add(account);
			}
		} catch(Exception e) {
			e.printStackTrace();
		} finally {
			if (conn != null) {
				try {
					conn.close();
				} catch (Exception e) {
					e.printStackTrace();
				}
			}
		}
		//设置属性，用来向页面提供数据
		return dlist;
		
	}
}