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";// 改成你的数据库连接
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<Object[]> 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]);
}
}
输出效果:
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/1c950a7b02087bf410546ab7f3d3572c11dfcf37?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
追问我数据库中有五个字段分别是hang,lie,shijixuhao,col,row.用sql语句调出来之后,如何五个五个一组的存入二维数组中,并且二维数组的长度定为6.如何做啊?求大神,急急急!!!!!!!!!!!
追答虽然你很急,但是你更应该说明白你想要的效果到底是什么?
data[0][0]=hang,data[0][1]=lie,......
data[1][0]=hang2.data[1][1]=lie2,...
是这样吗?
追问好吧!我在说一遍,我想把数据库中的hang,lie,shijixuhao,col,row这几个字段调出来合成一个串儿,再把每一个串儿当做一个元素存入到二维数组中,二维数组中每一组存六个串儿。要不劳驾大神给一下扣扣吧!谢了!!!!!
追答明白了,QQ151244729