Examples - Databases

Java

import java.sql.*;
import java.util.*;

public class JDBCExample {
  public static void main(String[] args) throws Exception {
    Class.forName("org.postgresql.Driver");
    Connection db = DriverManager.getConnection("jdbc:postgresql://localhost/racing/", "bzimmer", null);
    Statement c = db.createStatement();
    ResultSet rs = c.executeQuery("select * from bz");

    while (rs.next()) {
      List row = new ArrayList();
      ResultSetMetaData meta = rs.getMetaData();
      for(int i=0;i<meta.getColumnCount();i++) {
        int col = i+1;
        int datatype = meta.getColumnType(col);
        if (datatype == Types.INTEGER) {
          row.add(new Integer(rs.getInt(col)));
        } else if (datatype == Types.FLOAT) {
          row.add(new Float(rs.getFloat(col)));
        } else {
          row.add(rs.getString(col));
        }
      }
      System.out.println(row);
    }
    rs.close();
    c.close();
    db.close();
  }
}

JDBCExample.java

Jython

from java.sql import *
from java.lang import *

Class.forName("org.postgresql.Driver")

db = DriverManager.getConnection("jdbc:postgresql://localhost/racing/", "bzimmer", None)
c = db.createStatement()
rs = c.executeQuery("select * from bz")

_types = {Types.INTEGER:rs.getInt, Types.FLOAT:rs.getFloat}

while rs.next():
  row = []
  meta = rs.getMetaData()
  for i in range(meta.getColumnCount()):
    col = i + 1
    datatype = meta.getColumnType(col)
    v = _types.get(datatype, rs.getString)(col)
    row.append(v)
  print tuple(row)
rs.close()
c.close()
db.close()

ex_jdbc.py

zxJDBC

from com.ziclix.python.sql import zxJDBC

db = zxJDBC.connect("jdbc:postgresql://localhost/racing/", "bzimmer", None, "org.postgresql.Driver")
c = db.cursor()
c.execute("select * from bz")
for row in c:
  print row
c.close()
db.close()

ex_zxjdbc.py