<select name="weatherStat" id="States">
<% 
 
 
			try {
			Connection connection = DataBaseConnectionManager.getConnection();
			String sqlQuery = "SELECT distinct state FROM ols_weather_current ORDER BY 1 asc";
			ResultSet rst2;
			PreparedStatement pstmt;
			pstmt = connection.prepareStatement(sqlQuery);
			rst2 = pstmt.executeQuery(sqlQuery);
			while (rst2.next ()) {
 
			<option value=rst2.getString("state")></option>
			}
 
			rst2.close();
            pstmt.close();
			} 
 
		catch (Exception e) {
			e.printStackTrace();
            }
 
	%>
 
 
</select>