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

This article shows you Java basic MAC system IDEA connection MYSQL database JDBC process is how, the content is concise and easy to understand, absolutely can make your eyes bright, through the detailed introduction of this article hope you can get something.

Create tables in JDBC database connection MySQL

In the terminal, use the command mysql-u root-p to open the database, create the database, create tables and so on in the database operating environment.

Set up database statement

Create dababase database name

Construction table sentence

Create table bookinfo (- > book_id int primary key auto_increment,-> book_name varchar (20) not null,-> price float (6) not null,-> public_date date not null,-> store int not null->)

Establishing JavaWeb Project in IDEA

1. Open IDEA- > Create New Project- > Java Enterprice- > click next- > name the project, and select the path you want to store-> click finish to complete the creation.

two。 Click Database- >'+'- > 'MySQL' on the far right of the project

Fill in the database created by yourself at 3.Database. If there are no special circumstances, fill in the 'root', password', which is the password you need to enter when entering the database. It depends on your personal situation. Click Test Connection under URL after filling it out.

4. Note: if there is a situation where the Test Connection button cannot be clicked, the word download appears at the bottom left of the interface. The reader directly clicks to download mysql-connector-java-5.1.48-bin.jar, and then the JDBC database connection jar package can be downloaded. After downloading, you can click Test Connection. If the interface shown in the following figure appears, the database connection is successful.

5. After the database connection is successful, the following interface appears on the right side of IDEA to display the tables in the database, and we can do some operations on the database.

6. Create a database connection class named "com.jdbc.test" Package under the src directory and "DBConnection" under the package

The code in the DBConnect class that accesses the bookinfo table in the book database and displays all the data in the table

Package com.jdbc.test;import java.math.BigDecimal;import java.sql.*;public class DBConnection {/ / Database url,username,password static final String DB_url = "jdbc:mysql://localhost:3306/book"; static final String username = "root"; static final String password = "123456"; public static void main (String [] args) {try {/ / 1. Register the JDBC driver Class.forName ("com.mysql.jdbc.Driver"); / / 2. Get the database connection Connection connection = DriverManager.getConnection (DB_url,username,password); / / 3. Operate the database Statement statement = connection.createStatement (); / / get the object String sql = "select * from bookinfo"; / / define the database statement ResultSet resultSet = statement.executeQuery (sql); / / execute the database statement to get the result set while (resultSet.next ()) {int bookid = resultSet.getInt ("book_id") String bookname = resultSet.getNString ("booK_name"); BigDecimal price = resultSet.getBigDecimal ("price"); Date publicdate = resultSet.getDate ("public_date"); String store = resultSet.getNString ("store"); System.out.println ("Book number" + bookid); System.out.println ("Book title" + bookname) } / / 4. Close result set, database operation object, database connection resultSet.close (); statement.close (); connection.close ();} catch (ClassNotFoundException e) {e.printStackTrace ();} catch (SQLException e) {e.printStackTrace ();}

At this point, the database connection is done, and finally, the format of the next url to connect to the database is

You can define the corresponding url according to your own situation, or you can copy it directly in the interface of database.

The above is the process of IDEA connecting to MYSQL database JDBC under Java basic MAC system. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

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.