svn-gvsig-desktop / tmp / trunk / servidor / WorkSpace_Servidor / Callejero / unittest / es / logex / callejero / core / CallejeroTest.java @ 26486
History | View | Annotate | Download (1.87 KB)
1 |
package es.logex.callejero.core; |
---|---|
2 |
|
3 |
import java.util.List; |
4 |
import java.sql.DriverManager; |
5 |
import java.sql.Connection; |
6 |
|
7 |
import junit.framework.TestCase; |
8 |
|
9 |
public class CallejeroTest extends TestCase { |
10 |
|
11 |
public void testgetMunicipios() { |
12 |
Connection conn = null; |
13 |
try{
|
14 |
Class.forName("org.postgresql.Driver"); |
15 |
//conn = DriverManager.getConnection("org:postgresql://logexvirt1/db_callejero", "callejero","xcvb");
|
16 |
conn = DriverManager.getConnection("jdbc:postgresql://logexvirt1/db_callejero", "callejero","xcvb"); |
17 |
Callejero callejero = new Callejero(conn);
|
18 |
List<String> lista = callejero.getMunicipios(); |
19 |
} catch (Exception e) {e.printStackTrace();} |
20 |
finally{try{ |
21 |
conn.close(); |
22 |
}catch(Exception e){} |
23 |
} |
24 |
} |
25 |
|
26 |
/*
|
27 |
* Ejemplo de uso de la funciĆ³n getMunicipiosLV()
|
28 |
*/
|
29 |
public void testgetMunicipioLV(){ |
30 |
Long startTimeTotal = System.currentTimeMillis(); |
31 |
String elapse;
|
32 |
|
33 |
Connection conn = null; |
34 |
try{
|
35 |
|
36 |
Class.forName("org.postgresql.Driver"); |
37 |
conn = DriverManager.getConnection("org:postgresql://logexvirt1/db_callejero", "callejero","xcvb"); |
38 |
Callejero callejero = new Callejero(conn);
|
39 |
List<String> lista = callejero.getMunicipiosLV("oliv"); |
40 |
|
41 |
for (String s: lista) { |
42 |
System.out.println(s);
|
43 |
} |
44 |
|
45 |
} catch (Exception e) {e.printStackTrace();} |
46 |
finally{try{ |
47 |
conn.close(); |
48 |
}catch(Exception e){} |
49 |
} |
50 |
} |
51 |
|
52 |
public void testgetMaxExtent() { |
53 |
Connection conn = null; |
54 |
try{
|
55 |
Class.forName("org.postgresql.Driver"); |
56 |
//conn = DriverManager.getConnection("org:postgresql://logexvirt1/db_callejero", "callejero","xcvb");
|
57 |
conn = DriverManager.getConnection("jdbc:postgresql://logexvirt1/db_callejero", "callejero","xcvb"); |
58 |
Callejero callejero = new Callejero(conn);
|
59 |
|
60 |
callejero.getMaxExtent(); |
61 |
|
62 |
} catch (Exception e) {e.printStackTrace();} |
63 |
finally{try{ |
64 |
conn.close(); |
65 |
}catch(Exception e){} |
66 |
} |
67 |
} |
68 |
} |