![SequoiaDB分布式数据库权威指南](https://wfqqreader-1252317822.image.myqcloud.com/cover/100/43738100/b_43738100.jpg)
上QQ阅读APP看本书,新人免费读10天
设备和账号都新为新人
4.1.3 MySQL开发——JDBC驱动程序
下载JDBC(Java Database Connectivity)驱动程序(简称“驱动”)并导入jar包后,即可使用JDBC提供的API。下面示范如何在Maven工程中使用JDBC进行简单的增查改删操作。
(1)在pom.xml中添加MySQL JDBC驱动程序的依赖,如mysql-connector-java-5.1.38:
![](https://epubservercos.yuewen.com/4CE233/23020641509740506/epubprivate/OEBPS/Images/42291_85_4.jpg?sign=1739289671-6RsgbiMHBPi4IWNLJP4LkmensRETt9Qg-0-823db3bc26e1bbdffb4a8c9fa1367ca5)
(2)假设本地有默认安装的MySQL实例,root用户密码为123456。连接到该实例并准备样例使用的数据库db和表tb:
![](https://epubservercos.yuewen.com/4CE233/23020641509740506/epubprivate/OEBPS/Images/42291_85_5.jpg?sign=1739289671-h1vO0pfjBC7RpxxXqrF6xEoHszDCAzNh-0-c227a15d7a8be2817f6c09f12b9ea4af)
(3)在工程的src/main/java/com/sequoiadb/sample目录下添加JdbcSample.java文件:
![](https://epubservercos.yuewen.com/4CE233/23020641509740506/epubprivate/OEBPS/Images/42291_86_1.jpg?sign=1739289671-LlZZzKXDwruXwozTRZXZrgJ2NSI8QGWR-0-efd6675335db1ddef2adce28f49bb69c)
![](https://epubservercos.yuewen.com/4CE233/23020641509740506/epubprivate/OEBPS/Images/42291_87_1.jpg?sign=1739289671-8RB77bdUUjLzoXB8EuOqpNu8Za7gV5hI-0-63e957590910d6d61d35d12be02bb4dc)
(4)使用Maven编译并运行:
![](https://epubservercos.yuewen.com/4CE233/23020641509740506/epubprivate/OEBPS/Images/42291_87_2.jpg?sign=1739289671-IViy1TccoiPDMxywwcdjVlWfTkaGdfXU-0-dfe34527074edf87d48e211a0acfc8a6)
![](https://epubservercos.yuewen.com/4CE233/23020641509740506/epubprivate/OEBPS/Images/42291_88_1.jpg?sign=1739289671-Ym5n4jLOrleQRkYc8r02NClVzzE7QgX6-0-a5b3e331c15caadf2cb5e12b45fd5a8d)
得到如下运行结果:
![](https://epubservercos.yuewen.com/4CE233/23020641509740506/epubprivate/OEBPS/Images/42291_88_2.jpg?sign=1739289671-DRGadJjNZK0lYTrmtqYkfrwJHFxB5lQh-0-fc7bff1c7f80bb51f2594efc1cce9eb7)