Revision 47606 trunk/org.gvsig.desktop/org.gvsig.desktop.compat.cdc/org.gvsig.fmap.dal/org.gvsig.fmap.dal.db/org.gvsig.fmap.dal.db.jdbc/src/main/java/org/gvsig/fmap/dal/store/jdbc2/spi/SRSSolverBase.java
SRSSolverBase.java | ||
---|---|---|
110 | 110 |
try { |
111 | 111 |
String[] s = applicationAbbrev.split(":"); |
112 | 112 |
sql = "select srid, auth_name, auth_srid from spatial_ref_sys where upper(auth_name) = upper('" + s[0] +"') and auth_srid = "+s[1]+" "; |
113 |
Statement st = connection.createStatement(); |
|
113 |
Statement st = connection.createStatement(sql);
|
|
114 | 114 |
ResultSet rs = JDBCUtils.executeQuery(st, sql); |
115 | 115 |
if ( rs.next() ) { |
116 | 116 |
Integer srid = rs.getInt("srid"); |
... | ... | |
126 | 126 |
protected String searchApplicationAbbrev(JDBCConnection connection, Integer databaseCode) { |
127 | 127 |
String sql = "select srid, auth_name, auth_srid from spatial_ref_sys where srid = " + databaseCode; |
128 | 128 |
try { |
129 |
Statement st = connection.createStatement(); |
|
129 |
Statement st = connection.createStatement(sql);
|
|
130 | 130 |
ResultSet rs = JDBCUtils.executeQuery(st, sql); |
131 | 131 |
if ( rs.next() ) { |
132 | 132 |
int auth_code = rs.getInt("auth_srid"); |
Also available in: Unified diff