def jdbc_test(): """LJG: zxJDBC를 사용하면 한글처리가 에러나는데 JDBC를 직접 사용하면 한글처리가 성공한다 추후 시간을 갖고 한글관련 문제를 처리하자.오늘은 여기까지 새벽 3시다.. 정말 한글이 싫다.ㅋㅋ """ import sys import java from java.lang import Class from java.sql import DriverManager, SQLException jdbc_user = "******" jdbc_password = "******" jdbc_url = "jdbc:mysql://14.63.161.143/cdp" DriverManager.registerDriver(Class.forName("com.mysql.jdbc.Driver").newInstance()) connection = DriverManager.getConnection(jdbc_url, jdbc_user, jdbc_password) statement = connection.createStatement() sql = "select * from test_sample" rs = statement.executeQuery(sql) while rs.next(): row = rs.getString(2) print row
def simpleXmlUpdate(strArgs, caller): DriverManager.registerDriver( Class.forName(caller.jdbc_driver).newInstance()) connection = DriverManager.getConnection(caller.jdbc_url, caller.jdbc_user, caller.jdbc_pass) statement = connection.createStatement() results = statement.executeUpdate(strArgs) res = str(results) return res
def simpleXmlQuery(strArgs, caller): DriverManager.registerDriver( Class.forName(caller.jdbc_driver).newInstance()) connection = DriverManager.getConnection(caller.jdbc_url, caller.jdbc_user, caller.jdbc_pass) statement = connection.createStatement() results = statement.executeQuery(strArgs) res = '<xml>\n' + "\n".join(XmlRowGenerator(results)) + '\n</xml>' return res
def singleApduQuery(strArgs): jdbc_url = "jdbc:sqlite:/root/test.db" DriverManager.registerDriver( Class.forName("org.sqlite.JDBC").newInstance()) connection = DriverManager.getConnection(jdbc_url, "", "") statement = connection.createStatement() results = statement.executeQuery(strArgs) res = rowGenerator(results, lambda x: x.pop()) return res
def simpleQuery(strArgs): jdbc_url = "jdbc:sqlite:/root/test.db" DriverManager.registerDriver( Class.forName("org.sqlite.JDBC").newInstance()) connection = DriverManager.getConnection(jdbc_url, "", "") statement = connection.createStatement() results = statement.executeQuery(strArgs) #res= "\n".join (rowGenerator(results, '|'.join)) #res= "\n".join (rowGenerator(results, lambda x: str(len (x)))) res = "\n".join(stringRowGenerator(results, sep='\n')) return res
def change_text(event): lq1 = "SYSIBM" aq1 = "%s.SQLSCHEMAS" % lq1 aq2 = "%s.SQLTABLES" % lq1 aq3 = "%s.SQLCOLUMNS" % lq1 aq4 = "select * from qsys2/systables select * from qsys2/syscolumns select * from qsys2/sysindexes" DriverManager.registerDriver(AS400JDBCDriver()) logger.debug("Connecting...") server = "AS400XO.noceast.dws.disney.com" lq2 = "DVDSFIL" tq1 = "%s.CTCMPF" % lq2 con = DriverManager.getConnection("jdbc:as400://%s/apilib;naming=sql;errors=full;date format=iso;extended dynamic=true;package=JDBCExa;package library=apilib" % server, name, pwd) logger.debug("Established Connection with: %s" % server) query = "SELECT TABLE_NAME, TABLE_TEXT FROM %s where TABLE_SCHEM = '%s'" % (aq2, lq2) #query = "SELECT COLUMN_NAME, COLUMN_TEXT, TYPE_NAME FROM %s where TABLE_SCHEM = '%s'" % (aq3, lq2) logger.debug("Query: %s" % query) stmnt = con.prepareStatement(query) results = stmnt.executeQuery() i = 0 while results.next(): i += 1 #logger.debug("%s" % results) logger.debug("%s : %s" % (results.getString("TABLE_NAME"), results.getString("TABLE_TEXT"))) #logger.debug("%s : %s [%s]" % (results.getString("COLUMN_NAME"), results.getString("COLUMN_TEXT"), results.getString("TYPE_NAME"))) if i == 1000: exit() logger.debug("Success!")
from net.grinder.script import Test testname = System.getProperty("sql.testname") test = Test(0, testname) testConfig = "./src/test/use-cases/" sqlQueryFilename = testConfig + testname + ".sql" connectionSettingsFile=testConfig + testname jdbcConnectionSettings = Properties(); jdbcConnectionSettings.load( FileInputStream(connectionSettingsFile) ) sqlQuery = open(sqlQueryFilename,"r").readline() # Load the JDBC drivers. DriverManager.registerDriver(OracleDriver()) def getConnection(): return DriverManager.getConnection(jdbcConnectionSettings.getProperty("url"), jdbcConnectionSettings.getProperty("username"), jdbcConnectionSettings.getProperty("password")) def ensureClosed(object): try: object.close() except: pass class TestRunner: def __call__(self): connection = None sqlStatement = None try:
from net.grinder.script.Grinder import grinder from net.grinder.script import Test from java.util import Random from java.sql import DriverManager from com.mysql.jdbc import Driver DriverManager.registerDriver(Driver()) p = grinder.getProperties() p.setLong("grinder.threads", 8) p.setLong("grinder.runs", 100000000) p.setLong("grinder.duration", 120 * 1000) t = Test(1, "Query") def getConnection(): return DriverManager.getConnection( "jdbc:mysql://server/geoip", "geoip", "geoip") class TestRunner: def __init__(self): self.connection = getConnection() def __call__(self): r = Random() s = self.connection.createStatement() q = t.wrap(s)