Java operation access database usage method, case and required jar package [source code and jar package are downloaded at the end]

• Java

catalogue

Write in front

Database editing software MDB plus exe

Differences in SQL query statements

String to number

String to date

Example: open the SQL edit window as shown in the figure below

Source code and jar package download address

Write in front

Database editing software MDB plus exe

Download address: https://download.csdn.net/download/weixin_42350212/13976918

Differences in SQL query statements

String to number

select val(serial_number) from table_a

String to date

select cdate('2020-07-08 14:12:00') from table_a

The syntax of left join connection and not in are consistent

Example: open the SQL edit window as shown in the following figure

Source code and jar package download address

Download address

The content of this article comes from the network collection of netizens. It is used as a learning reference. The copyright belongs to the original author.
THE END
分享
二维码
< <上一篇
下一篇>>