Shulou(Shulou.com)06/02 Report--

This article will explain in detail how to use JDBC to add, delete, modify and search. The content of the article is of high quality, so the editor shares it with you for reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

Add mysql,c3p0,junit dependencies:

Connect to the database:

1. Directly connect to the database

Note:

1. You don't need to use Class.forName (). For reasons, please check the source code.

2. UseSSL=false is only to block the warning message of Mysql, and can not be added.

two。 Use connection pooling

Add a c3p0-config.xml configuration file in the resources directory

Description: this is only a test, so I put it in the test/resources/ directory, non-test please put it under main/resources/.

Create user information:

The above provides two ways to write back the primary key and not to return the primary key

Query user information:

The second method is recommended, which does not modify the code because of the table field position adjustment, and can query any table and return a given object through generics and reflection.

Update user information:

Delete user information:

On how to use JDBC to achieve add, delete, change and search function is shared here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.