itemsoption.java

老牌java开发的物流管理系统 详细的我也没有怎么看 好像是恒基的

/**
 * @author joypen
 * 输入表名和列名，得到列的list
 */
package com.wl.util;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

import com.wl.dbconnection.DBManager;
import com.wl.entity.ItemOption;

public class ItemsOption {

	public ItemsOption() {
	}

	public static List<ItemOption> listItems(String tableName, String rowName) {
		String sql = "select id, "+rowName+" from "+tableName;
		List<ItemOption> list = new ArrayList<ItemOption>();
		DBManager db = new DBManager();
		db.openDB();
		try {
			db.ps = db.conn.prepareStatement(sql);
			db.rs = db.ps.executeQuery();
			while(db.rs.next()){
				ItemOption item = new ItemOption();
				item.setId(db.rs.getInt("id"));
				item.setOption(db.rs.getString(rowName));
				list.add(item);
			}
		} catch (SQLException e) {
			e.printStackTrace();
			return null;
		}finally{
			db.closeDB();
		}
		return list;
	}
	
	public static void main(String[] args){
		List<ItemOption> list = new ArrayList<ItemOption>();
		list = ItemsOption.listItems("commcatetable", "CommodityName");
		Iterator<ItemOption> it = list.listIterator();
		while(it.hasNext()){
			ItemOption item = (ItemOption)it.next();
			System.out.println(item.getId()+" "+item.getOption());
		}
	}
}