展开全部
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.LinkedList;
import java.util.List;
public class DataToArray {
public static void main(String[] args) throws Exception {
String url = "jdbc:mysql://localhost:3306/test";// 改成你e69da5e887aa62616964757a686964616f31333332616337的数据库连接
Connection conn = DriverManager.getConnection(url, "root", "fuhaiwei");// 改成你用户名密码
String sql = "select * from user";// 改成你的查询语句
PreparedStatement prestmt = conn.prepareStatement(sql);
ResultSet rs = prestmt.executeQuery();
Object[][] data = getDataArray(rs);
printArray(data);
rs.close();
prestmt.close();
conn.close();
}
private static void printArray(Object[][] data) {
for (int i = 0; i < data.length; i++) {
for (int j = 0; j < data[i].length; j++) {
System.out.print(data[i][j] + " ");
}
System.out.println();
}
}
private static Object[][] getDataArray(ResultSet rs) throws SQLException {
List list = new LinkedList();
while (rs.next()) {
// 改成你的列名
Object[] objects = new Object[] { rs.getInt("id"), rs.getString("username"),
rs.getString("password") };
list.add(objects);
}
return list.toArray(new Object[0][0]);
}
}
输出效果: