Java使用JDBC连接MySQL数据库的方法

创建日期:2025-04-23
更新日期:2025-04-23

使用JDBC访问MySQL

添加依赖

<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.29</version>
</dependency>

参考代码

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

public class Application {

    public static void main(String[] args) {

        try {

            Class.forName("com.mysql.cj.jdbc.Driver");

        } catch (Exception e) {

            e.printStackTrace();

        }

        try {

            Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test", "root", "root");

            PreparedStatement statement = conn.prepareStatement("select * from user where name like ?");

            statement.setString(1, "%To%");

            ResultSet result = statement.executeQuery();

            while (result.next()) {

                int id = result.getInt("id");

                String name = result.getString("name");

                int age = result.getInt("age");

                String email = result.getString("email");

                System.out.printf("id = %d, name = %s, age = %d, email = %s\n", id, name, age, email);

            }

            result.close();

        } catch (Exception e) {

            e.printStackTrace();

        }

    }

}

转载请注明转自www.hylab.cn,原文地址:Java使用JDBC连接MySQL数据库的方法

网站简介

一个来自三线小城市的程序员开发经验总结。