{"id":4176,"date":"2021-08-02T08:11:35","date_gmt":"2021-08-02T08:11:35","guid":{"rendered":"https:\/\/www.bearloga.space\/?page_id=4176"},"modified":"2021-08-02T08:11:35","modified_gmt":"2021-08-02T08:11:35","slug":"jython-jdbc","status":"publish","type":"page","link":"https:\/\/www.bearloga.space\/uk\/jython-jdbc\/","title":{"rendered":"Jython \u2014 JDBC"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Jython \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442&nbsp;<strong>\u043f\u0430\u043a\u0435\u0442 zxJDBC,<\/strong>&nbsp;\u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u0442 \u043f\u0440\u043e\u0441\u0442\u0443\u044e \u0432 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0438 \u043e\u0431\u043e\u043b\u043e\u0447\u043a\u0443 Python \u0434\u043b\u044f JDBC.&nbsp;zxJDBC \u0441\u043e\u0435\u0434\u0438\u043d\u044f\u0435\u0442 \u0434\u0432\u0430 \u0441\u0442\u0430\u043d\u0434\u0430\u0440\u0442\u0430:&nbsp;<strong>JDBC<\/strong>&nbsp;\u2014 \u044d\u0442\u043e \u0441\u0442\u0430\u043d\u0434\u0430\u0440\u0442\u043d\u0430\u044f \u043f\u043b\u0430\u0442\u0444\u043e\u0440\u043c\u0430 \u0434\u043b\u044f \u0434\u043e\u0441\u0442\u0443\u043f\u0430 \u043a \u0431\u0430\u0437\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 Java, \u0430&nbsp;<strong>DBI<\/strong>&nbsp;\u2014 \u044d\u0442\u043e \u0441\u0442\u0430\u043d\u0434\u0430\u0440\u0442\u043d\u044b\u0439 API-\u0438\u043d\u0442\u0435\u0440\u0444\u0435\u0439\u0441 \u0434\u043b\u044f \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0439 Python.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">ZxJDBC \u043f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u0442 \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u0438\u043c\u044b\u0439 \u0441\u043e \u0441\u0442\u0430\u043d\u0434\u0430\u0440\u0442\u043e\u043c DBI 2.0 \u0438\u043d\u0442\u0435\u0440\u0444\u0435\u0439\u0441 \u0434\u043b\u044f JDBC.&nbsp;\u0414\u043b\u044f JDBC \u0434\u043e\u0441\u0442\u0443\u043f\u043d\u043e \u0431\u043e\u043b\u0435\u0435 200 \u0434\u0440\u0430\u0439\u0432\u0435\u0440\u043e\u0432, \u0438 \u0432\u0441\u0435 \u043e\u043d\u0438 \u0440\u0430\u0431\u043e\u0442\u0430\u044e\u0442 \u0441 zxJDBC.&nbsp;\u0412\u044b\u0441\u043e\u043a\u043e\u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0435 \u0434\u0440\u0430\u0439\u0432\u0435\u0440\u044b \u0434\u043e\u0441\u0442\u0443\u043f\u043d\u044b \u0434\u043b\u044f \u0432\u0441\u0435\u0445 \u043e\u0441\u043d\u043e\u0432\u043d\u044b\u0445 \u0440\u0435\u043b\u044f\u0446\u0438\u043e\u043d\u043d\u044b\u0445 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445, \u0432\u043a\u043b\u044e\u0447\u0430\u044f:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>DB2<\/li><li>\u0434\u0435\u0440\u0431\u0438<\/li><li>MySQL<\/li><li>\u043e\u0440\u0430\u043a\u0443\u043b<\/li><li>PostgreSQL<\/li><li>SQLite<\/li><li>SQL Server \u0438<\/li><li>Sybase.<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\u041f\u0430\u043a\u0435\u0442 ZxJDBC \u043c\u043e\u0436\u043d\u043e \u0441\u043a\u0430\u0447\u0430\u0442\u044c \u0441&nbsp;<a rel=\"noreferrer noopener\" target=\"_blank\" href=\"https:\/\/translate.googleusercontent.com\/translate_c?depth=1&amp;rurl=translate.google.ru&amp;sl=en&amp;sp=nmt4&amp;tl=ru&amp;u=https:\/\/sourceforge.net\/projects\/zxjdbc\/&amp;xid=17259,15700022,15700186,15700190,15700256,15700259,15700262&amp;usg=ALkJrhhNs9EsQBUWio06F5V8qVqj8wMghw\">https:\/\/sourceforge.net\/projects\/zxjdbc\/<\/a>&nbsp;\u0438\u043b\u0438&nbsp;<a rel=\"noreferrer noopener\" target=\"_blank\" href=\"https:\/\/translate.googleusercontent.com\/translate_c?depth=1&amp;rurl=translate.google.ru&amp;sl=en&amp;sp=nmt4&amp;tl=ru&amp;u=http:\/\/www.ziclix.com\/zxjdbc\/&amp;xid=17259,15700022,15700186,15700190,15700256,15700259,15700262&amp;usg=ALkJrhjq3_jaUB8bLXPW9a0BrGJYCBzHhQ\">http:\/\/www.ziclix.com\/zxjdbc\/<\/a>&nbsp;.&nbsp;\u0417\u0430\u0433\u0440\u0443\u0436\u0435\u043d\u043d\u044b\u0439 \u0430\u0440\u0445\u0438\u0432 \u0441\u043e\u0434\u0435\u0440\u0436\u0438\u0442 \u0444\u0430\u0439\u043b ZxJDBC.jar, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0441\u043b\u0435\u0434\u0443\u0435\u0442 \u0434\u043e\u0431\u0430\u0432\u0438\u0442\u044c \u0432 \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u0443\u044e \u0441\u0440\u0435\u0434\u044b CLASSPATH.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u041c\u044b \u043d\u0430\u043c\u0435\u0440\u0435\u043d\u044b \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u044c \u0441\u0432\u044f\u0437\u044c \u0441 \u0431\u0430\u0437\u043e\u0439 \u0434\u0430\u043d\u043d\u044b\u0445 MySQL.\u00a0\u0414\u043b\u044f \u044d\u0442\u043e\u0433\u043e \u0442\u0440\u0435\u0431\u0443\u0435\u0442\u0441\u044f \u0434\u0440\u0430\u0439\u0432\u0435\u0440 JDBC \u0434\u043b\u044f MySQL.\u00a0\u0417\u0430\u0433\u0440\u0443\u0437\u0438\u0442\u0435\u00a0<strong>\u0441\u043e\u0435\u0434\u0438\u043d\u0438\u0442\u0435\u043b\u044c MySQL J<\/strong>\u00a0\u043f\u043e \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0435\u0439 \u0441\u0441\u044b\u043b\u043a\u0435 \u2014\u00a0<a rel=\"noreferrer noopener\" target=\"_blank\" href=\"https:\/\/translate.googleusercontent.com\/translate_c?depth=1&amp;rurl=translate.google.ru&amp;sl=en&amp;sp=nmt4&amp;tl=ru&amp;u=https:\/\/dev.mysql.com\/downloads\/connector\/j\/&amp;xid=17259,15700022,15700186,15700190,15700256,15700259,15700262&amp;usg=ALkJrhgWB4hEXQuCbBcEFymgSMdgesa4xw\">https:\/\/dev.mysql.com\/downloads\/connector\/j\/<\/a>\u00a0\u0438 \u0432\u043a\u043b\u044e\u0447\u0438\u0442\u0435 \u0441\u043e\u0435\u0434\u0438\u043d\u0438\u0442\u0435\u043b\u044c mysql java-5.1.42-bin.jar \u0432 CLASSPATH.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0412\u043e\u0439\u0434\u0438\u0442\u0435 \u043d\u0430 \u0441\u0435\u0440\u0432\u0435\u0440 MySQL \u0438 \u0441\u043e\u0437\u0434\u0430\u0439\u0442\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u0443 \u0443\u0447\u0435\u043d\u0438\u043a\u043e\u0432 \u0432 \u0442\u0435\u0441\u0442\u043e\u0432\u043e\u0439 \u0431\u0430\u0437\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0441\u043e \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0435\u0439 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u043e\u0439:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><th>\u043f\u043e\u043b\u0435<\/th><th>\u0422\u0438\u043f<\/th><th>\u0448\u0438\u0440\u0438\u043d\u0430<\/th><\/tr><tr><td>\u043d\u0430\u0437\u0432\u0430\u043d\u0438\u0435<\/td><td>Varchar<\/td><td>10<\/td><\/tr><tr><td>\u0412\u043e\u0437\u0440\u0430\u0441\u0442<\/td><td>Int<\/td><td>3<\/td><\/tr><tr><td>\u041c\u0435\u0442\u043a\u0438<\/td><td>Int<\/td><td>3<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u0414\u043e\u0431\u0430\u0432\u044c\u0442\u0435 \u0432 \u043d\u0435\u0433\u043e \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0437\u0430\u043f\u0438\u0441\u0435\u0439.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><th>\u043d\u0430\u0437\u0432\u0430\u043d\u0438\u0435<\/th><th>\u0412\u043e\u0437\u0440\u0430\u0441\u0442<\/th><th>\u041c\u0435\u0442\u043a\u0438<\/th><\/tr><tr><td>Ravi<\/td><td>21<\/td><td>78<\/td><\/tr><tr><td>Ashok<\/td><td>20<\/td><td>65<\/td><\/tr><tr><td>\u0438\u043d\u0434\u0438\u0433\u043e<\/td><td>22<\/td><td>71<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u0421\u043e\u0437\u0434\u0430\u0439\u0442\u0435 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0439 \u0441\u043a\u0440\u0438\u043f\u0442 Jython \u043a\u0430\u043a&nbsp;<strong>dbconnect.py<\/strong>&nbsp;.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">url = \"jdbc:mysql:\/\/localhost\/test\"\nuser = \"root\"\npassword = \"password\"\ndriver = \"com.mysql.jdbc.Driver\"\nmysqlConn = zxJDBC.connect(url, user, password, driver)\nmysqlConn = con.cursor()\nmysqlConn.execute(\u201cselect * from student)\nfor a in mysql.fetchall():\n   print a<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0412\u044b\u043f\u043e\u043b\u043d\u0438\u0442\u0435 \u043f\u0440\u0438\u0432\u0435\u0434\u0435\u043d\u043d\u044b\u0439 \u0432\u044b\u0448\u0435 \u0441\u043a\u0440\u0438\u043f\u0442 \u0438\u0437 \u043f\u0440\u0438\u0433\u043b\u0430\u0448\u0435\u043d\u0438\u044f Jython.&nbsp;\u0417\u0430\u043f\u0438\u0441\u0438 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 \u0443\u0447\u0435\u043d\u0438\u043a\u043e\u0432 \u0431\u0443\u0434\u0443\u0442 \u043f\u0435\u0440\u0435\u0447\u0438\u0441\u043b\u0435\u043d\u044b, \u043a\u0430\u043a \u043f\u043e\u043a\u0430\u0437\u0430\u043d\u043e \u043d\u0438\u0436\u0435 \u2014<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">(\u201cRavi\u201d, 21, 78)\n(\u201cAshok\u201d, 20, 65)\n(\u201cAnil\u201d,22,71)\n<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u042d\u0442\u043e \u043e\u0431\u044a\u044f\u0441\u043d\u044f\u0435\u0442 \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u0443 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f JDBC \u0432 Jython.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Jython \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442&nbsp;\u043f\u0430\u043a\u0435\u0442 zxJDBC,&nbsp;\u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u0442 \u043f\u0440\u043e\u0441\u0442\u0443\u044e \u0432 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0438 \u043e\u0431\u043e\u043b\u043e\u0447\u043a\u0443 Python \u0434\u043b\u044f JDBC.&nbsp;zxJDBC \u0441\u043e\u0435\u0434\u0438\u043d\u044f\u0435\u0442 \u0434\u0432\u0430 \u0441\u0442\u0430\u043d\u0434\u0430\u0440\u0442\u0430:&nbsp;JDBC&nbsp;\u2014 \u044d\u0442\u043e \u0441\u0442\u0430\u043d\u0434\u0430\u0440\u0442\u043d\u0430\u044f \u043f\u043b\u0430\u0442\u0444\u043e\u0440\u043c\u0430 \u0434\u043b\u044f \u0434\u043e\u0441\u0442\u0443\u043f\u0430 \u043a [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[129],"tags":[],"class_list":["post-4176","page","type-page","status-publish","hentry","category-jython"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/pages\/4176","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/comments?post=4176"}],"version-history":[{"count":0,"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/pages\/4176\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/media?parent=4176"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/categories?post=4176"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/tags?post=4176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}