依赖
<!-- https://mvnrepository.com/artifact/commons-beanutils/commons-beanutils -->
<dependency>
<groupId>commons-beanutils</groupId>
<artifactId>commons-beanutils</artifactId>
<version>1.9.4</version>
</dependency>
使用
数据库查询行记录,赋值给JavaBean对象,不必手动赋值。
import domain.User;
import org.apache.commons.beanutils.BeanUtils;
import org.springframework.jdbc.core.JdbcTemplate;
import utils.JdbcUtils;
import javax.sql.DataSource;
import java.lang.reflect.InvocationTargetException;
import java.util.List;
import java.util.Map;
public class BeanUtilsTest {
public static void main(String[] args) throws InvocationTargetException, IllegalAccessException {
DataSource datasource = JdbcUtils.getDataSource();
JdbcTemplate jdbcTemplate = new JdbcTemplate(datasource);
String sql = "select * from user";
List<Map<String, Object>> maps = jdbcTemplate.queryForList(sql);
User user = new User();
for (Map<String, Object> map : maps) {
BeanUtils.populate(user, map);
System.out.println(user);
// System.out.println(map.keySet().toString());
}
}
}
效果