ResultSet resultSet = preparedStatement.executeQuery()；

SunTecTec

于 2024-08-15 11:55:20 发布

阅读量169

点赞数 1

文章标签：数据库

本文链接：https://blog.csdn.net/m0_63628018/article/details/141218778

版权

String sql = "select code, id where code in (?);";
PreparedStatement preparedStatement = connection.prepareStatement(sql);
preparedStatement.setString(1, account_code);

ResultSet resultSet = preparedStatement.executeQuery();
ResultSetMetaData resultSetMetaData = resultSet.getMetaData();
int columnsNumber = resultSetMetaData.getColumnCount();

while (resultSet.next()) {
    for (int i = 1; i <= columnsNumber; i++) {
        if (i > 1) System.out.print(",  ");
        String columnName = resultSetMetaData.getColumnName(i);
        String columnValue = resultSet.getString(i);
        System.out.print(columnName + " " + columnValue);
    }
    System.out.println("");
}