Python Cookbook

Accessing a JDBC Database from a Jython Servlet

Credit: Brian Zhou

Problem

You’re writing a servlet in Jython, and you need to connect to a database server (e.g., Oracle, Sybase, MS SQL Server, MySQL) via JDBC.

Solution

The technique is basically the same for any kind of database, give or take a couple of statements. Here’s the code for when your database is Oracle:

import java, javax
class emp(javax.servlet.http.HttpServlet):
  def doGet(self, request, response):
    response.setContentType("text/plain")
    out = response.getOutputStream(  )
    self.dbQuery(out)
    out.close(  )
  def dbQuery(self, out):
    driver = "oracle.jdbc.driver.OracleDriver"
    java.lang.Class.forName(driver).newInstance(  )
    server, db = "server", "ORCL"
    url = "jdbc:oracle:thin:@" + server + ":" + db
    usr, passwd = "scott", "tiger"
    conn = java.sql.DriverManager.getConnection(url, usr, passwd)
    query = "SELECT EMPNO, ENAME, JOB FROM EMP"
    stmt = conn.createStatement(  )
    if stmt.execute(query):
        rs = stmt.getResultSet(  )
        while rs and rs.next(  ):
            out.println(rs.getString("EMPNO"))
            out.println(rs.getString("ENAME"))
            out.println(rs.getString("JOB"))
            out.println(  )
    stmt.close(  )
    conn.close(  )

When your database is Sybase or Microsoft SQL Server, use the following:

import java, javax
class titles(javax.servlet.http.HttpServlet):
  def doGet(self, request, response):
    response.setContentType("text/plain")
    out = response.getOutputStream(  )
    self.dbQuery(out)
    out.close(  )
  def dbQuery(self, out):
    driver = "sun.jdbc.odbc.JdbcOdbcDriver"
 java.lang.Class.forName(driver).newInstance( ...