Java SE Database connection operation: accessing the database

For the project development, the database is occupying a very important link.

This section revolves around a program about database operations, including adding, modifying, deleting, and querying (CRUD) operations

Here is the topic of the program: CRUD operations on news headlines.

One. Since it is a news headline, the database table is built into several properties as shown in the following illustration:

The name of the table is named: Firstleveltitle

I'm here using Mysql,mysql to create tables and other uses to see http://zhaoyuqiang.blog.51cto.com/6328846/1127226

Second, create a Java project

Create a Java Project Project news in Eclipse or MyEclipse

Copy the MYSQLJDBC driver package for the application to the project's Lib folder.

Note: MYSQLJDBC is a jar package, can not be uncompressed, the package directly dragged into or copied into the Lib folder will be able to, this package has a database connection to use the things. This package is imported from the outside into eclipse or myeclipse and can be downloaded to the package online. Of course, different databases have different packages, and if it is SQL Server 2005, you should lead the SQLJDBC data jar package.

As shown in the following illustration: