How to access SQL databases using the JDBC driver library

My sample codes may help you.
This is using zxJDBC to access SQLite3 Database.
When you want to access SQL Server, you have to change such as JDBC driver.

[sample codes:]
load("C:\jdbcdriver\sqlite-jdbc-3.8.6.jar")
from com.ziclix.python.sql import zxJDBC

url = "jdbc:sqlite:c:/sqlitedb/sample.db3"
dbuser = ""
dbpassword = ""
driver = "org.sqlite.JDBC"

dbconn = zxJDBC.connect(url, dbuser, dbpassword, driver)
dbcur = dbconn.cursor()

try:
    dbcur.execute("select id, name from member")
    rs = dbcur.fetchall()
    for elm in rs:
        print elm[0], elm[1]

except Exception, e:
    print e.args[0]

finally:
    dbcur.close()
    dbconn.close()

Hello Masuo,

Thank you for the code, but i still have errors:

[error] zxJDBC.DatabaseError ( driver [org.sqlite.JDBC] not found )

I have downloaded zxJDBC and sqljdbc4.jar but it doesn't work.

Thanks,
haj

I need help

In case of SQLServer, driver is com.microsoft.sqlserver.jdbc.SQLServerDriver.
Sorry, I have no idea any more.
I run my sample codes by Sikuli-IDE.
sikulix.jar include zxJDBC package, so I have not downloaded zxJDBC.

To get masuo's results, you need SikuliX version 1.1.1.

Thank you @masou and @RaiMan