adminareainfodao.java

基于struts的网上商店源码

/*
 * 作者:刘云云
 * 时间:2007年12月22日
 * 功能:平台基础信息维护-开通城市（所在城市）地区的添加和删除修改。
 */
package com.mole.struts.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Iterator;

import com.mole.struts.bean.AdminAreaInfoBean;

public class AdminAreaInfoDAO extends AbstractDAO {
	// 获取地区信息记录集
	public AdminAreaInfoBean[] getAllAreaInfo(String sql) {
		ArrayList<Object[]> arrayList = this.executeQuery(sql);
		if (arrayList == null)
			return null;

		AdminAreaInfoBean[] records = new AdminAreaInfoBean[arrayList.size()];
		if (records.length == 0)
			return records;

		Iterator<Object[]> it = arrayList.iterator();
		int i = 0;
		while (it.hasNext()) {
			Object[] obj = it.next();
			AdminAreaInfoBean record = new AdminAreaInfoBean();
			record.setId(obj[0].toString());
			record.setName(obj[1].toString());
			records[i++] = record;
		}
		return records;
	}

	// 获取地区信息记录的最大ID
	public String getMaxAreaId(String sql) {
		Connection conn = getConn();
		PreparedStatement ps = null;
		ResultSet rs = null;
		String num = null;
		try {
			conn.setAutoCommit(true);
			ps = conn.prepareStatement(sql);
			rs = ps.executeQuery();
			while (rs.next()) {
				num = rs.getString(1);
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				rs.close();
				ps.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		return num;
	}
}