Jfinal数据库基本操作(六) DB批量操作

public void action5() {
String sql = "select count(*) from user";
long count = Db.queryLong(sql);

List<UserModel> users = new ArrayList<UserModel>();
// for (int i = 0; i < 10; i++) {
// UserModel user = new UserModel();
// user.set("name", "Hh"+i);
// user.set("password", "abcd"+i);
// users.add(user);
// }

//foreach保存

 for (UserModel userModel : users) {
 userModel.save();
 }
//批量保存
Db.batchSave(users, users.size());

//批量查询
List<Record> list= Db.find("select * from user"); 
for (Record record : list) {
System.out.println("name : "+record.getStr("name"));
}

renderText("总数是:"+count);
}