I have a requirement to populate the drop down list I need to load data from a database table to drop down list in java
my database table is this
CREATE TABLE CITY_MASTER_PL(
CITYID BIGINT NOT NULL,
INVENTORY_SOURCE CHAR,
CITY_NAME VARCHAR(250),
STATE_CODE VARCHAR(250),
STATE_NAME VARCHAR(250),
COUNTRY_CODE VARCHAR (250),
COUNTRY_NAME VARCHAR (250),
HOTEL_COUNT BIGINT,
LATITUDE BIGINT,
LONGITUDE BIGINT,
PRIMARY KEY (CITYID)
);
in this table I need to load all country name state name and city name can any one help me out this thanks in advance