Lib.rs

› JDBC › Install

Adding `jdbc` library as a dependency

Run this command in a terminal, in your project's directory:

cargo add jdbc

To add it manually, edit your project's Cargo.toml file and add to the [dependencies] section:

jdbc = "0.1.0"

The jdbc library will be automatically available globally. Read the jdbc library documentation.

Back to the crate overview.

Readme

jdbc-rs

中文 | English

Rust bindings to the Java Jdbc.

Many databases today do not have official support for Rust, so many databases cannot be connected using Rust. However, most databases officially provide Java version of JDBC drivers, and these drivers are very stable.

Using this library, you can use Java's JDBC to connect to any type of database.

Rust does not have an official database-driven abstraction, and the most widely used unofficial crate is Sqlx. The ultimate purpose of this library is to provide the implementation of sqlx to temporarily support databases not supported by Sqlx.

English documentation uses Google Translate.

Getting Started

Introduce Rust dependencies

Cargo.toml

[dependencies]
jdbc = "0.1.0"

Download java dependencies

1、Download the jar file from the web.

You can download the jar file from MVN Repository or other ways, and put it in the libs directory of the project.

2、use maven

Create a new pom.xml in the project root directory, you can copy this file from the project root directory.

Execute the mvn command to copy dependencies to the target directory. Or copy build.rs from this project, please modify the target directory by yourself.

mvn dependency:copy-dependencies -DoutputDirectory=./libs

Example

    let datasource = jdbc::Builder::new()
        .jdbc_url("jdbc:sqlite::memory:")
        .build()
        .expect("Failed to initialize data source.");

    let conn = datasource.get_connection()?;

    let statement = conn
        .prepare_statement("select username,age from user where id=?")?
        .set_int(1, 1000)?;

    let result = statement.execute_query()?;

    while result.next()? {
        let username = result.get_string(1)?;
        let age = result.get_int(1)?;
        println!("user:{:?} age:{:?}", username, age);
    }

Support type

char
byte
short
int
long
float
double
boolean
String
Date
Object
Blob
Clob
byte[]
BigDecimal
AsciiStream
BinaryStream
CharacterStream

Adding jdbc library as a dependency

Adding `jdbc` library as a dependency