ResultSet rs = st.executeQuery(sql10+"'"+cgformhead_id.trim()+"'");
List cgfield = new ArrayList();
int i=1;
while(rs.next())
{
CgFormFieldEntity filed = new CgFormFieldEntity();
filed.setFieldName(rs.getString("field_name"));
filed.setLength(rs.getInt("length"));
filed.setType(rs.getString("type"));
filed.setPointLength(rs.getInt("point_length"));
filed.setIsNull(rs.getString("is_null"));
filed.setIsKey(rs.getString("is_key"));
filed.setIsQuery(rs.getString("is_query"));
filed.setIsShow(rs.getString("is_show"));
filed.setShowType(rs.getString("show_type"));
filed.setOrderNum(rs.getInt("order_num"));
filed.setFieldHref(rs.getString("field_href"));
filed.setFieldLength(rs.getInt("field_length"));
filed.setFieldValidType(rs.getString("field_valid_type"));
filed.setQueryMode(rs.getString("query_mode"));
filed.setContent(rs.getString("content"));
filed.setDictTable(rs.getString("dict_table"));
filed.setDictField(rs.getString("dict_field"));
filed.setMainField(rs.getString("main_field"));
filed.setMainTable(rs.getString("main_table"));
cgfield.add(filed);
i++;
}
return cgfield;
}