Mengintegrasikan Spanner dengan MyBatis dan Spring Boot (PostgreSQL)
Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
MyBatis adalah framework persistensi dengan dukungan untuk SQL kustom
dan pemetaan lanjutan. MyBatis menghilangkan sebagian besar kode JDBC
dan setelan parameter manual serta pengambilan hasil di aplikasi Anda.
Menyiapkan MyBatis untuk database dialek PostgreSQL Spanner
Anda dapat mengintegrasikan database dialek PostgreSQL Spanner dengan MyBatis
dan Spring Boot menggunakan driver JDBC Spanner.
Anda tidak perlu menggunakan PGAdapter untuk integrasi ini.
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Sulit dipahami","hardToUnderstand","thumb-down"],["Informasi atau kode contoh salah","incorrectInformationOrSampleCode","thumb-down"],["Informasi/contoh yang saya butuhkan tidak ada","missingTheInformationSamplesINeed","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],["Terakhir diperbarui pada 2025-09-05 UTC."],[],[],null,["# Integrate Spanner with MyBatis and Spring Boot (PostgreSQL)\n\n[MyBatis](https://mybatis.org/mybatis-3/) is a persistence framework with support for custom SQL\nand advanced mappings. MyBatis eliminates most of the JDBC code\nand manual setting of parameters and retrieval of results in your application.\n\nSet up MyBatis for Spanner PostgreSQL-dialect databases\n-------------------------------------------------------\n\nYou can integrate Spanner PostgreSQL-dialect databases with MyBatis\nand Spring Boot using the Spanner JDBC driver.\n\nYou don't need to use [PGAdapter](/spanner/docs/pgadapter) for this integration.\n\n### Dependencies\n\nIn your project, add Apache Maven dependencies for\n[MyBatis](https://mybatis.org/mybatis-3/), [Spring Boot](https://spring.io/projects/spring-boot), and the\n[Spanner JDBC driver](https://github.com/googleapis/java-spanner-jdbc). \n\n \u003cdependencies\u003e\n \u003c!-- MyBatis and Spring Boot --\u003e\n \u003cdependency\u003e\n \u003cgroupId\u003eorg.mybatis.spring.boot\u003c/groupId\u003e\n \u003cartifactId\u003emybatis-spring-boot-starter\u003c/artifactId\u003e\n \u003c/dependency\u003e\n \u003cdependency\u003e\n \u003cgroupId\u003eorg.mybatis.dynamic-sql\u003c/groupId\u003e\n \u003cartifactId\u003emybatis-dynamic-sql\u003c/artifactId\u003e\n \u003c/dependency\u003e\n\n \u003c!-- Spanner JDBC driver --\u003e\n \u003cdependency\u003e\n \u003cgroupId\u003ecom.google.cloud\u003c/groupId\u003e\n \u003cartifactId\u003egoogle-cloud-spanner-jdbc\u003c/artifactId\u003e\n \u003c/dependency\u003e\n \u003cdependencies\u003e\n\n### Data source configuration\n\nConfigure `application.properties` to use the Spanner JDBC driver and\nto connect to a Spanner PostgreSQL-dialect database. \n\n # This profile uses a Spanner PostgreSQL database.\n\n spanner.project=my-project\n spanner.instance=my-instance\n spanner.database=mybatis-sample\n\n spring.datasource.driver-class-name=com.google.cloud.spanner.jdbc.JdbcDriver\n spring.datasource.url=jdbc:cloudspanner:/projects/${spanner.project}/instances/${spanner.instance}/databases/${spanner.database}\n\nFull sample application\n-----------------------\n\nTo try this integration with a sample application, see\n[Spring Data MyBatis Sample Application with\nSpanner PostgreSQL](https://github.com/googleapis/java-spanner-jdbc/tree/main/samples/spring-data-mybatis/postgresql).\n\nWhat's next\n-----------\n\n- Learn more about [MyBatis](https://mybatis.org/mybatis-3/).\n- Learn more about [MyBatis and Spring Boot](https://mybatis.org/spring-boot-starter/mybatis-spring-boot-autoconfigure/index.html).\n- Learn more about [Spring Boot](https://spring.io/projects/spring-boot).\n- [File a GitHub issue](https://github.com/googleapis/java-spanner-jdbc/issues) to report a bug or ask a question about the Spanner JDBC driver."]]