java连接mysql没输出
时间: 2023-07-11 16:15:40 浏览: 38
要输出MySQL的结果,你需要执行查询并遍历结果集来输出结果。以下是一个简单的Java连接MySQL并查询数据的示例代码:
```java
import java.sql.*;
public class MySQLExample {
public static void main(String[] args) {
String url = "jdbc:mysql://localhost:3306/mydatabase";
String user = "username";
String password = "password";
try {
Connection conn = DriverManager.getConnection(url, user, password);
Statement stmt = conn.createStatement();
String query = "SELECT * FROM mytable";
ResultSet rs = stmt.executeQuery(query);
while (rs.next()) {
int id = rs.getInt("id");
String name = rs.getString("name");
int age = rs.getInt("age");
System.out.println("ID: " + id + ", Name: " + name + ", Age: " + age);
}
rs.close();
stmt.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
```
请注意,这只是一个示例代码,您需要根据自己的情况进行修改。如果您仍然无法输出结果,请检查MySQL服务器是否正在运行,并确保连接字符串、用户名和密码正确。