@DescribeProcess(title = "geocoderCodLogr", description = "Geocoder em cima do Eixo de Logradouros, por código")
public class GeocoderCodLogr implements GeoServerProcess {
@DescribeResult(name = "result", description = "Ponto como String", meta = { "mimeType=application/json,text/xml",
"chosenMimeType=outputMimeType" })
public RawData execute(@DescribeParameter(name = "código", description = "Código do logradouro") String codigo,
@DescribeParameter(name = "número", description = "Número predial") Integer numero,
@DescribeParameter(name = "outputMimeType", min = 0) final String outputMimeType) {
String url = "" class="code-quote" style="color: #009100">"jdbc:postgresql:;
Connection conn = null;
try {
conn = DriverManager.getConnection(url);
PreparedStatement stmt = conn.prepareStatement("select st_astext(geocode_codlogr(?, ?))");
stmt.setInt(1, numero);
stmt.setString(2, codigo);
ResultSet rs = stmt.executeQuery();
String ponto = null;
while (rs.next()) {
ponto = rs.getString(1);
}
return new StringRawData(ponto, outputMimeType);
} catch (Exception e) {
return new StringRawData(e.getMessage(), outputMimeType);
}
}
}
