java 二维数组 数据库_java中如何将数据库中多个字段的值存入二维数组的一个元素中...

展开全部

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]);

}

}

输出效果：