| 123456789101112131415161718192021222324252627282930313233 |
- from py4j.java_gateway import JavaGateway
- gateway = JavaGateway()
- jdbc_driver = 'com.mysql.jdb.Driver'
- db_url = 'jdbc:mysql://localhost/hue'
- username = 'root'
- password = 'root'
- conn = gateway.jvm.java.sql.DriverManager.getConnection(db_url, username, password)
- try:
- stmt = conn.createStatement()
- try:
- rs = stmt.executeQuery('select username,email from auth_user')
- try:
- md = rs.getMetaData()
- for i in xrange(md.getColumnCount()):
- print md.getColumnTypeName(i + 1)
- while rs.next():
- username = rs.getString("username")
- email = rs.getString("email")
- print username, email
- finally:
- rs.close()
- finally:
- stmt.close()
- finally:
- conn.close()
|