<%@ page import = "javax.servlet.http.HttpUtils" %> <%@ page import = "java.util.*" %> <%@ page import = "java.util.Date" %> <%@ page import = "java.sql.*" %> <%@ page import = "java.io.*" %> <%@include file="/urbaniza/php/connect.jsp" %>

<%PreparedStatement st=null; ResultSet rs=null; try{ String q=""; String prov="0"; if(request.getParameter("prov")!=null) prov=request.getParameter("prov"); String descripcion=""; String selectProvin="Elegir Provincia"; q="select c_provin,descripcion from ur_provin order by descripcion"; st=con.prepareStatement(q); rs=st.executeQuery(); while(rs.next()){ descripcion=rs.getString("descripcion"); if(descripcion.length()>13) descripcion=descripcion.substring(0,13)+"..."; selectProvin=selectProvin+""+descripcion+""; } rs.close(); st.close(); selectProvin=selectProvin+""; out.println(selectProvin); con.close(); }catch(Exception e){ out.println(e.toString()); }%>