Revision 10958
| branches/F2/libraries/libJCRS/src/org/gvsig/crs/EpsgConnection.java | ||
|---|---|---|
| 102 | 102 |
} |
| 103 | 103 |
} |
| 104 | 104 |
|
| 105 |
/** |
|
| 106 |
* Establece la conexi?n con la base de datos de USR |
|
| 107 |
* |
|
| 108 |
*/ |
|
| 109 |
public void setConnectionUsr() {
|
|
| 110 |
try {
|
|
| 111 |
connect = DriverManager.getConnection("jdbc:hsqldb:file:gvSIG/extensiones/org.gvsig.crs/db_usr", "sa", "");
|
|
| 112 |
} catch (SQLException e1) {
|
|
| 113 |
e1.printStackTrace(); |
|
| 114 |
} |
|
| 115 |
} |
|
| 116 |
|
|
| 105 | 117 |
public Connection getConnection(){
|
| 106 | 118 |
return connect; |
| 107 | 119 |
} |
| branches/F2/libraries/libJCRS/src/org/gvsig/crs/repository/UsrRepository.java | ||
|---|---|---|
| 1 |
package org.gvsig.crs.repository; |
|
| 2 |
|
|
| 3 |
import java.sql.ResultSet; |
|
| 4 |
import java.sql.SQLException; |
|
| 5 |
|
|
| 6 |
import org.gvsig.crs.Crs; |
|
| 7 |
import org.gvsig.crs.CrsException; |
|
| 8 |
import org.gvsig.crs.EpsgConnection; |
|
| 9 |
import org.gvsig.crs.ICrs; |
|
| 10 |
import org.gvsig.crs.Query; |
|
| 11 |
|
|
| 12 |
public class UsrRepository implements ICrsRepository {
|
|
| 13 |
|
|
| 14 |
EpsgConnection connection; |
|
| 15 |
|
|
| 16 |
public UsrRepository() {
|
|
| 17 |
super(); |
|
| 18 |
connection = new EpsgConnection(); |
|
| 19 |
} |
|
| 20 |
|
|
| 21 |
public ICrs getCrs(String code) {
|
|
| 22 |
// TODO Auto-generated method stub |
|
| 23 |
String cadWKT = ""; |
|
| 24 |
Crs crs = null; |
|
| 25 |
|
|
| 26 |
String sentence = "SELECT usr_code, usr_wkt, usr_proj, usr_geog, usr_datum " + |
|
| 27 |
"FROM USR " + |
|
| 28 |
"WHERE usr_code = " + code; |
|
| 29 |
|
|
| 30 |
connection.setConnectionUsr(); |
|
| 31 |
ResultSet result = Query.select(sentence,connection.getConnection()); |
|
| 32 |
try {
|
|
| 33 |
connection.shutdown(); |
|
| 34 |
} catch (SQLException e) {
|
|
| 35 |
// TODO Auto-generated catch block |
|
| 36 |
e.printStackTrace(); |
|
| 37 |
} |
|
| 38 |
try {
|
|
| 39 |
result.next(); |
|
| 40 |
cadWKT = result.getString("usr_wkt");
|
|
| 41 |
} catch (SQLException e1) {
|
|
| 42 |
e1.printStackTrace(); |
|
| 43 |
} |
|
| 44 |
cadWKT = cadWKT.substring(0, cadWKT.length()-1) + ", AUTHORITY[\"USR\","+ Integer.parseInt(code)+"]]"; |
|
| 45 |
|
|
| 46 |
try {
|
|
| 47 |
crs = new Crs(Integer.parseInt(code),cadWKT); |
|
| 48 |
} catch (CrsException e) {
|
|
| 49 |
// TODO Auto-generated catch block |
|
| 50 |
e.printStackTrace(); |
|
| 51 |
} |
|
| 52 |
|
|
| 53 |
return crs; |
|
| 54 |
} |
|
| 55 |
|
|
| 56 |
} |
|
| 0 | 57 | |
| branches/F2/extensions/extJCRS/config/db_esri.properties | ||
|---|---|---|
| 1 |
#HSQL database |
|
| 2 |
#Wed Nov 29 14:18:46 CET 2006 |
|
| 3 |
hsqldb.cache_file_scale=1 |
|
| 4 |
runtime.gc_interval=0 |
|
| 5 |
hsqldb.first_identity=0 |
|
| 6 |
version=1.7.3 |
|
| 7 |
modified=no |
|
| 8 |
hsqldb.script_format=0 |
|
| 9 |
sql.enforce_size=false |
|
| 10 |
hsqldb.cache_size_scale=10 |
|
| 11 |
hsqldb.cache_scale=14 |
|
| 12 |
hsqldb.version=1.7.3 |
|
| 13 |
hsqldb.log_size=200 |
|
| 14 |
sql.enforce_strict_size=false |
|
| 15 |
readonly=true |
|
| 16 |
hsqldb.compatible_version=1.7.2 |
|
| 17 |
hsqldb.original_version=1.7.3 |
|
| 18 |
sql.compare_in_locale=false |
|
| 19 |
hsqldb.nio_data_file=true |
|
| 20 |
hsqldb.cache_version=1.7.0 |
|
| 0 | 21 | |
Also available in: Unified diff