Java连接MySQL
时间: 2023-10-29 17:00:07 浏览: 64
要连接Java和MySQL,需要以下步骤:
1.下载MySQL JDBC驱动程序:从MySQL官方网站下载MySQL Connector/J JDBC驱动程序。
2.将MySQL JDBC驱动程序添加到类路径中:将下载的MySQL JDBC驱动程序添加到Java项目的类路径中。
3.创建连接:使用以下代码创建与MySQL数据库的连接:
```
String url = "jdbc:mysql://localhost:3306/mydatabase";
String username = "root";
String password = "password";
Connection connection = DriverManager.getConnection(url, username, password);
```
其中,url是MySQL数据库的URL,username和password是MySQL数据库的用户名和密码。
4.执行SQL查询:使用Java的Statement或PreparedStatement对象执行SQL查询,例如:
```
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery("SELECT * FROM mytable");
```
5.关闭连接:在使用完连接后,必须将其关闭,例如:
```
connection.close();
```
完整的Java代码示例:
```
import java.sql.*;
public class Main {
public static void main(String[] args) {
try {
// Connect to MySQL database
String url = "jdbc:mysql://localhost:3306/mydatabase";
String username = "root";
String password = "password";
Connection connection = DriverManager.getConnection(url, username, password);
// Execute SQL query
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery("SELECT * FROM mytable");
// Process query results
while (resultSet.next()) {
String id = resultSet.getString("id");
String name = resultSet.getString("name");
System.out.println(id + " " + name);
}
// Close connection
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
```