Re: jdbc windows

>From: Matteo Traina <matteo.traina@email.it>

>i don't understand about use jdbc driver with windows...how do i do for use 
>it, sorry but i need a little guide/trial because i find it only for linux.

the usage of jdbc does not depend on the underlying OS.

here is some example code - that also works in windows

package at.wiro.sql;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Postgres {
 public static void printException(String query,SQLException e) {System.out.println("query       : <" + query +
">");System.out.println("SQL-error  : " + e.getErrorCode());System.out.println("SQL-state   : " +
e.getSQLState());System.out.println("SQL-message: " + e.getMessage());e.printStackTrace();System.exit(1); }
 
 public static Connection connect(String host,String db, String user, 
String pwd) {String pg_driver = "org.postgresql.Driver";Connection conn = null;try { Class.forName(pg_driver); }
catch(Exception e) {     System.out.println("can't load postgres driver '" + pg_driver + "' 
 
...");     System.exit(1);     }   try { conn = DriverManager.getConnection("jdbc:postgresql://" + host + 
"/" + db,user,pwd); }   catch (SQLException e) {     System.out.println("can't connect to db '"+db+"' as user '" + user
+
 
"' ...");     printException("Connection Error : ",e);     System.out.println("system halted ...");     System.exit(1);
   }return conn; }
 
 public static ResultSet query(Connection conn,String query) {ResultSet rs = null;try {  Statement st = 
conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);  rs = st.executeQuery(query);
}catch(SQLException e) { printException(query,e);}return rs; }
 

....

regards sepp