![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=1739445182-bZX6vNZecjCu39kT3nd5gJHmm0LgRhOG-0-bf22f80c5d2b82da20ef90d00d9e2276)
(2)假设本地有默认安装的MySQL实例,root用户密码为123456。连接到该实例并准备样例使用的数据库db和表tb:
![](https://epubservercos.yuewen.com/4CE233/23020641509740506/epubprivate/OEBPS/Images/42291_85_5.jpg?sign=1739445182-C73oJcLpkhsSZJIQJkFQa4oxV18MzAdD-0-c6530c70046f3324c95f922eca5eb43b)
(3)在工程的src/main/java/com/sequoiadb/sample目录下添加JdbcSample.java文件:
![](https://epubservercos.yuewen.com/4CE233/23020641509740506/epubprivate/OEBPS/Images/42291_86_1.jpg?sign=1739445182-ITNyC37D1DMBxBrufdtuXM6xQvO4un3L-0-e85e575aec043dcda9d3614f16065143)
![](https://epubservercos.yuewen.com/4CE233/23020641509740506/epubprivate/OEBPS/Images/42291_87_1.jpg?sign=1739445182-eDatXWcaMYKRvrdneqS8q0ybGuklX2UQ-0-f183041f433817e8e41a9ed3b6d855ff)
(4)使用Maven编译并运行:
![](https://epubservercos.yuewen.com/4CE233/23020641509740506/epubprivate/OEBPS/Images/42291_87_2.jpg?sign=1739445182-qGy2yhWdItrPxKVirapHA3ZiMMvn0Vj8-0-de9c06e1f731261a53b6905837dc00e6)
![](https://epubservercos.yuewen.com/4CE233/23020641509740506/epubprivate/OEBPS/Images/42291_88_1.jpg?sign=1739445182-YMsES6jd2unOLFLikrHfPG0Zy0k20JZI-0-412a326bcc0db71ee35c0c2764940891)
得到如下运行结果:
![](https://epubservercos.yuewen.com/4CE233/23020641509740506/epubprivate/OEBPS/Images/42291_88_2.jpg?sign=1739445182-x2IRg6Azrap4HoufLciT4OojaaL6FOp4-0-1db68fcad09ec95b4f1abfcb60a66869)