%@ page contentType="text/html; charset=utf-8" language="java" autoFlush="true" %> <%@ page import="com.ec.common.Constants" %> <%@ page import="java.util.*" %> <%@ page import="com.content.mobile.DBMobileMgr" %> <%@ page import="com.content.mobile.MobileConstants" %> <%@ page import="com.content.news.DBNewsMgr" %> <%@ page import="com.content.news.NewsConstants" %> <% String headerFlashName = "header_lower_searchdownload.jpg"; String headerBackgroudImg = "background_download.jpg"; DBMobileMgr dbMobileMgr = DBMobileMgr.getInstance(); Vector anVector = dbMobileMgr.getPhoneBrandBySQLWhere( "SELECT * FROM " + MobileConstants.table_PhoneBrand + " ORDER BY " + MobileConstants.brandName , Constants.dbConnectionName); if(null==anVector)anVector = new Vector(); DBNewsMgr dbNewsMgr = DBNewsMgr.getInstance(); Vector newsVector = dbNewsMgr.getNewsBySQLWhere( "SELECT * FROM " + NewsConstants.newsTable + " WHERE " + NewsConstants.onlineFlag + "=1 ORDER BY " + NewsConstants.sort + " DESC , date DESC ", Constants.dbConnectionName); if(null==newsVector)newsVector = new Vector(); %>