Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.lang.reflect.Field;
- import java.sql.ResultSet;
- import java.sql.ResultSetMetaData;
- import java.sql.SQLException;
- import java.util.ArrayList;
- import java.util.List;
- public class Util {
- public static List bind(Class clazz, ResultSet rs) throws SQLException {
- List list = new ArrayList();
- try {
- ResultSetMetaData md = rs.getMetaData();
- while (rs.next()) {
- try {
- Object obj = clazz.newInstance();
- for (int i = 1; i <= md.getColumnCount(); ++i) {
- String column = md.getColumnLabel(i);
- Field field = clazz.getDeclaredField(column);
- field.setAccessible(true);
- field.set(obj, rs.getObject(column));
- }
- list.add(obj);
- } catch (Exception e) {
- e.printStackTrace();
- }
- }
- } catch (SQLException e) {
- throw e;
- }
- return list;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment