python用jdbc读取oracle表和列的信息，生成java代码

这个项目的地址 传送门

第一个python3项目&＃xff0c;对python 还是学习中&＃xff0c;请大佬轻喷&＃xff0c;欢迎指点

import jaydebeapifrom .database import Databasedirver &＃61; &＃39;oracle.jdbc.OracleDriver&＃39;
jarFile &＃61; &＃39;/Users/warrior/Code/python/builder/jar/ojdbc6-11.2.0.1.0.jar&＃39;class DbOracle(Database):def get_jdbc_connection(self):import jpypeif jpype.isJVMStarted() and not jpype.isThreadAttachedToJVM():jpype.attachThreadToJVM()jpype.java.lang.Thread.currentThread().setContextClassLoader(jpype.java.lang.ClassLoader.getSystemClassLoader())connection &＃61; jaydebeapi.connect(dirver, self.url, {&＃39;user&＃39;: self.user, &＃39;password&＃39;: self.password, &＃39;tmode&＃39;: &＃39;TERA&＃39;, &＃39;charset&＃39;: &＃39;UTF8&＃39;}, jarFile)return connectiondef connect(self, url, user, password):self.url &＃61; urlself.user &＃61; userself.password &＃61; passworddef userTables(self):data &＃61; self.execute("""SELECT A.TABLE_NAME, B.COMMENTS FROM USER_TABLES A LEFT JOIN USER_TAB_COMMENTS B ON A.TABLE_NAME&＃61;B.TABLE_NAME""")result &＃61; []for table in data:result.append({&＃39;name&＃39;: table[0], &＃39;comment&＃39;: table[1]})return resultdef columns(self, table_name):data &＃61; self.execute("""SELECT A.COLUMN_NAME, A.DATA_TYPE, A.DATA_LENGTH, A.DATA_PRECISION, A.DATA_SCALE, A.NULLABLE, B.COMMENTS FROM USER_TAB_COLUMNS A LEFT JOIN USER_COL_COMMENTS B ON A.TABLE_NAME&＃61;B.TABLE_NAME AND A.COLUMN_NAME&＃61;B.COLUMN_NAME WHERE A.TABLE_NAME&＃61;&＃39;%s&＃39; ORDER BY COLUMN_ID ASC""" % table_name)result &＃61; []primary_key &＃61; self.table_primary(table_name)for column in data:result.append({&＃39;name&＃39;: column[0], &＃39;type&＃39;: column[1], &＃39;primary&＃39;: column[0] in primary_key,&＃39;length&＃39;: column[2], &＃39;precision&＃39;: column[3], &＃39;scale&＃39;: column[4], &＃39;nullable&＃39;:column[5], &＃39;comment&＃39;: column[6]})return resultdef table_primary(self, table_name):sql &＃61; """SELECT cols.column_name FROM all_constraints cons, all_cons_columns colsWHERE cols.table_name &＃61; &＃39;%s&＃39; AND cons.constraint_type &＃61; &＃39;P&＃39;AND cons.constraint_name &＃61; cols.constraint_name AND cons.owner &＃61; cols.ownerORDER BY cols.table_name""" % table_namedata &＃61; self.execute(sql)result &＃61; []for d in data:result.append(d[0])return resultdef execute(self, sql):conn &＃61; self.get_jdbc_connection()curs &＃61; conn.cursor()curs.execute(sql)result &＃61; curs.fetchall()curs.close()conn.close()return resultdef close(self):if (self.conn !&＃61; None):self.conn.close()