>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