Python2、Python3 调用 H2 数据库

蔚落 2022-12-10 01:28 377阅读 0赞

### 1、安装 python ###

官方下载：[https://www.python.org/downloads/][https_www.python.org_downloads]

说明：python2.7.9以下的版本没有pip，安装依赖需要手动下载依赖包

python2的建议使用2.7.9以上版本，python3自带pip工具，可直接用pip安装

### 2、安装setuptools模块 ###

方法一：pip管理工具安装

pip install setuptools

wetuptools官网：[https://pypi.python.org/pypi/setuptools][https_pypi.python.org_pypi_setuptools]

setuptools历史版本：[https://pypi.org/project/setuptools/\#history][https_pypi.org_project_setuptools_history]

方法二：Linux下使用wget下载，Windows下浏览器访问下载

wget https://bootstrap.pypa.io/ez_setup.py 
    python ez_setup.py

安装成功之后可以使用 python setup.py install 安装其他模块

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70][]

方法三：Linux下用tar命令解压，Windows使用解压工具解压

wget https://soft.laozuo.org/tools/setuptools-0.6c11.tar.gz
    tar -zxvf setuptools*.tar.gz
    cd setuptools-0.6c11

python setup.py build
    python setup.py install

### 3、安装JayDeBeApi模块 ###

JayDeBeApi官网：[https://pypi.org/project/JayDeBeApi/][https_pypi.org_project_JayDeBeApi]

JayDeBeApi历史版本：[https://pypi.org/project/JayDeBeApi/\#history][https_pypi.org_project_JayDeBeApi_history]

方法一：pip包管理工具安装

pip install JayDeBeApi

方法二： 绿色版安装

github项目地址：[https://github.com/baztian/jaydebeapi][https_github.com_baztian_jaydebeapi]

jaydebeapi-master.zip：[https://codeload.github.com/baztian/jaydebeapi/zip/master][https_codeload.github.com_baztian_jaydebeapi_zip_master]

解压 jaydebeapi-master.zip ，执行

cd jaydebeapi-master
    python setup.py install

### 4、调用h2数据库 ###

注意：python和java的版本需要一致，比如32位版本的python必须使用32位的jdk版本

#-*- encoding: utf-8 -*-
    
    import jaydebeapi
    
    dirver = 'org.h2.Driver'
    url = 'jdbc:h2:tcp://localhost/~/sea'
    username = 'sa'
    password = 'sa'
    jar = 'D:/Hadoop/H2/h2-2017-06-10/h2/bin/h2-1.4.196.jar'
    # jar = 'D:/Hadoop/H2/h2gis-standalone/h2gis-dist-1.5.0.jar'
    conn = jaydebeapi.connect(dirver,url,[username,password],jar)
    curs = conn.cursor()
    
    sql = "SELECT * FROM TEST_TABLE"
    curs.execute(sql)
    result = curs.fetchall()
    print(result)

[https_www.python.org_downloads]: https://www.python.org/downloads/
[https_pypi.python.org_pypi_setuptools]: https://pypi.python.org/pypi/setuptools
[https_pypi.org_project_setuptools_history]: https://pypi.org/project/setuptools/#history
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMjYyNTkzNDIx_size_16_color_FFFFFF_t_70]: /images/20221123/7fd1db0c5894499db1efdf76b60fa6a2.png
[https_pypi.org_project_JayDeBeApi]: https://pypi.org/project/JayDeBeApi/
[https_pypi.org_project_JayDeBeApi_history]: https://pypi.org/project/JayDeBeApi/#history
[https_github.com_baztian_jaydebeapi]: https://github.com/baztian/jaydebeapi
[https_codeload.github.com_baztian_jaydebeapi_zip_master]: https://codeload.github.com/baztian/jaydebeapi/zip/master