举个例子
时间: 2023-08-12 08:15:15 浏览: 29
好的,以下是一个简单的示例,演示如何使用Java Swing和JDBC连接到MySQL数据库并显示数据:
1. 首先,您需要安装MySQL数据库和Java Swing库。
2. 然后,您需要创建一个MySQL数据库和一个表,例如:
```
CREATE DATABASE mydatabase;
USE mydatabase;
CREATE TABLE students (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(50) NOT NULL,
age int(11) NOT NULL,
PRIMARY KEY (id)
);
```
3. 接下来,您需要下载并导入MySQL JDBC驱动程序,例如mysql-connector-java-8.0.26.jar。
4. 然后,您可以创建一个Java类来连接到数据库并获取数据:
```java
import java.sql.*;
public class StudentDAO {
private static final String URL = "jdbc:mysql://localhost:3306/mydatabase";
private static final String USERNAME = "root";
private static final String PASSWORD = "root";
public static void main(String[] args) {
try (Connection conn = DriverManager.getConnection(URL, USERNAME, PASSWORD)) {
String query = "SELECT * FROM students";
try (PreparedStatement stmt = conn.prepareStatement(query)) {
try (ResultSet rs = stmt.executeQuery()) {
while (rs.next()) {
int id = rs.getInt("id");
String name = rs.getString("name");
int age = rs.getInt("age");
System.out.println(id + "\t" + name + "\t" + age);
}
}
}
} catch (SQLException ex) {
ex.printStackTrace();
}
}
}
```
5. 最后,您可以创建一个Swing界面来显示数据,例如:
```java
import javax.swing.*;
import java.awt.*;
import java.sql.*;
public class StudentGUI extends JFrame {
private static final String URL = "jdbc:mysql://localhost:3306/mydatabase";
private static final String USERNAME = "root";
private static final String PASSWORD = "root";
private static final String QUERY = "SELECT * FROM students";
private JTable table;
public StudentGUI() {
setTitle("Student Information");
setDefaultCloseOperation(EXIT_ON_CLOSE);
setSize(400, 300);
String[] columns = {"ID", "Name", "Age"};
try (Connection conn = DriverManager.getConnection(URL, USERNAME, PASSWORD)) {
try (PreparedStatement stmt = conn.prepareStatement(QUERY)) {
try (ResultSet rs = stmt.executeQuery()) {
Object[][] data = new Object[10][3];
int i = 0;
while (rs.next()) {
int id = rs.getInt("id");
String name = rs.getString("name");
int age = rs.getInt("age");
data[i][0] = id;
data[i][1] = name;
data[i][2] = age;
i++;
}
table = new JTable(data, columns);
JScrollPane scrollPane = new JScrollPane(table);
getContentPane().add(scrollPane, BorderLayout.CENTER);
}
}
} catch (SQLException ex) {
ex.printStackTrace();
}
}
public static void main(String[] args) {
StudentGUI gui = new StudentGUI();
gui.setVisible(true);
}
}
```
这个示例演示了如何使用Java Swing和JDBC连接到MySQL数据库,并使用JTable来显示数据。希望这可以帮助您理解如何使用Java编写具有图形化界面和数据库连接的系统。