![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=1738840029-LMk565CXjvSWoU7SejrarfOyI0ClAseu-0-8ca2396755222e06a0a4a598f4527ddf)
(2)假设本地有默认安装的MySQL实例,root用户密码为123456。连接到该实例并准备样例使用的数据库db和表tb:
![](https://epubservercos.yuewen.com/4CE233/23020641509740506/epubprivate/OEBPS/Images/42291_85_5.jpg?sign=1738840029-iezHhZTXcPmvryp0b8D08w8m8xkgovWg-0-cf6aafd9e341b95ec5592416f9da60d7)
(3)在工程的src/main/java/com/sequoiadb/sample目录下添加JdbcSample.java文件:
![](https://epubservercos.yuewen.com/4CE233/23020641509740506/epubprivate/OEBPS/Images/42291_86_1.jpg?sign=1738840029-IIvksQC0HQkEoveXbPMzKn9ptHSecLzv-0-653b86225f02575d6251a383bf35c3b9)
![](https://epubservercos.yuewen.com/4CE233/23020641509740506/epubprivate/OEBPS/Images/42291_87_1.jpg?sign=1738840029-Wxbtc4WpP7mPTuMNQNhsuSc4GMdxTSi5-0-428b44c765d09527685a3f474c0a9bbe)
(4)使用Maven编译并运行:
![](https://epubservercos.yuewen.com/4CE233/23020641509740506/epubprivate/OEBPS/Images/42291_87_2.jpg?sign=1738840029-iaKoQ2BmDUpPI5LqcLIB6gE6ADGFoxDu-0-8d0f89363b07147a4e8e164b763c54de)
![](https://epubservercos.yuewen.com/4CE233/23020641509740506/epubprivate/OEBPS/Images/42291_88_1.jpg?sign=1738840029-WjkKp5qFU3LeqMsCWQ8Nu0XUyWifaGiu-0-5fe3101a38ca6744dc74205a9aaaa3e5)
得到如下运行结果:
![](https://epubservercos.yuewen.com/4CE233/23020641509740506/epubprivate/OEBPS/Images/42291_88_2.jpg?sign=1738840029-qc07lUhsu1rpRx1zWOO5xYtOAwpOdAQY-0-e105e289be642503d826e7ae4ec03d0e)