# Sample properties file for DBJC

# JDBC driver to use
jdbc.driver=org.postgresql.Driver


#JDBC URL
jdbc.url=jdbc:postgresql://192.168.0.10/elections

#JDBC user
jdbc.user=postgres

#JDBC password
# if you don't specify a password, DBJC will prompt for it 
# for security, we recommend to not store password in this file
jdbc.password=


#Queries
# only select are allowed, you can put insert / update
# but be aware that query are excuted in a transaction context
# wich is rollback at end.


# a query is a sql statement, but you can specify a user friendly name, 
# and parameters
# Define a simple query
query1.sql=select * from premiertour where ville_id=75000

# Define a simple query with a user friendly name
query2.name=Number of towns
query2.sql=select count(ville_id) from premiertour


# Looking number of towns in a state
query3.name=Select town name
query3.sql=select name from ville where id=?
# specify that this query need a string to be run
# only strings and numbers are allowed, no limitation in number
# of parameters, you can put how much you want
query3.param1=string