sysxlatitemdao.java

j2ee源码

/*
 * Created on 2005年11月16日
 *
 * To change the template for this generated file go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
package com.leeman.common.dao;

import java.sql.ResultSet;
import java.util.ArrayList;

import com.leeman.common.data.Dao;
import com.leeman.common.data.ResultSetReader;

import com.leeman.common.entity.SysXlatItemVO;

/**
 * @author kenneth
 *
 * To change the template for this generated type comment go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
public class SysXlatItemDao extends Dao{
	
	public String getListQuery()
	{
		StringBuffer sql = new StringBuffer();
		sql.append("select");
		sql.append(" *");
		sql.append(" from sys_xlat_item");
		//sql.append(" order by field_name, order_seq");
		sql.append(" order by lang_id, field_name, order_seq");
		return sql.toString();
	}
	public ArrayList getList() throws Exception
	{
		initDbConn();
		ResultSet rs = dbConn.executeQuery(getListQuery());
		ArrayList list = new ArrayList();

		while (rs.next())
		{
			SysXlatItemVO vo = new SysXlatItemVO();
			vo.setField_name(rs.getString("field_name"));
			vo.setField_value(rs.getString("field_value"));
			vo.setLang_id(rs.getString("lang_id"));
			vo.setLong_desc(rs.getString("long_desc"));
			vo.setShort_desc(rs.getString("short_desc"));
			vo.setOrder_seq(rs.getLong("order_seq"));
			list.add(vo);
		}
		rs.close();
		rs = null;
		return list;
	}
}