java连接mysql数据库例子

在Java中连接MySQL数据库十分常见，以下是一个例子：

import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;public class Example {public static void main(String[] args) {//数据库连接信息String url = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8";String username = "root";String password = "123456";Connection conn = null;PreparedStatement pstmt = null;ResultSet rs = null;try {//加载数据库驱动程序Class.forName("com.mysql.jdbc.Driver");//获取数据库连接conn = DriverManager.getConnection(url, username, password);//定义查询语句String sql = "SELECT * FROM user WHERE age >?";//获取 PreparedStatement 对象pstmt = conn.prepareStatement(sql);//设置参数pstmt.setInt(1, 18);//执行查询操作rs = pstmt.executeQuery();//处理查询结果while (rs.next()) {System.out.println(rs.getInt("id") + " " + rs.getString("name"));}} catch (ClassNotFoundException | SQLException e) {e.printStackTrace();} finally {//关闭资源try {if (rs != null) {rs.close();}if (pstmt != null) {pstmt.close();}if (conn != null) {conn.close();}} catch (SQLException e) {e.printStackTrace();}}}}

代码解释：

如果以上代码能正常运行，那么就完成了 Java 和 MySQL 数据库之间的连接。