代码拉取完成,页面将自动刷新
同步操作将从 MyBatis-Flex/MyBatis-Flex 强制同步,此操作会覆盖自 Fork 仓库以来所做的任何修改,且无法恢复!!!
确定后同步将在后台操作,完成时将刷新页面,请耐心等待。
/*
* Copyright (c) 2022-2023, Mybatis-Flex (fuhai999@gmail.com).
* <p>
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
* <p>
* http://www.apache.org/licenses/LICENSE-2.0
* <p>
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package com.mybatisflex.test;
import com.mybatisflex.core.MybatisFlexBootstrap;
import com.mybatisflex.core.row.*;
import org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseBuilder;
import org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseType;
import javax.sql.DataSource;
import java.util.Date;
import java.util.List;
public class DbTestStarter {
public static void main(String[] args) {
DataSource dataSource = new EmbeddedDatabaseBuilder()
.setType(EmbeddedDatabaseType.H2)
.addScript("schema.sql").setScriptEncoding("UTF-8")
// .addScript("data.sql")
.build();
MybatisFlexBootstrap.getInstance()
.setDataSource(dataSource)
.start();
Row row1 = Db.selectOneById(null, "tb_account", "id", 1);
RowUtil.printPretty(row1);
//查询全部
List<Row> rows = Db.selectAll(null, "tb_account");
RowUtil.printPretty(rows);
//插入 1 条数据
Row row = Row.ofKey(RowKey.AUTO);
// Row row = new Row();
// row.set("id", 3);
row.set("user_name", "michael yang");
row.set("age", 18);
row.set("birthday", new Date());
Db.insert(null, "tb_account", row);
//查看刚刚插入数据的主键 id
System.out.println(">>>>>>>>>id: " + row.get("id"));
//INSERT INTO tb_account
//VALUES (1, '张三', 18, 0,'2020-01-11', null,0),
Db.updateBatch("insert into tb_account(user_name,age,birthday) values (?,?,?)", new BatchArgsSetter() {
@Override
public int getBatchSize() {
return 10;
}
@Override
public Object[] getSqlArgs(int index) {
Object[] args = new Object[3];
args[0] = "michael yang";
args[1] = 18 + index;
args[2] = new Date();
return args;
}
});
//再次查询全部数据
rows = Db.selectAll(null, "tb_account");
RowUtil.printPretty(rows);
// for (Row row2 : rows) {
//// for (String s : row2.keySet()) {
//// if (!s.equalsIgnoreCase("id")) {
//// row2.set(s, row2.get(s));
//// }
//// }
// rows.remove("id");
// }
// rows.forEach(row2 -> row2.setPrimaryKeys(RowKey.AUTO));
// rows.forEach(r -> {
// r.prepareAttrsByKeySet();
// r.setPrimaryKeys(RowKey.AUTO);
// });
// Db.insertBatch(null,"tb_account", rows, 100);
//再次查询全部数据
rows = Db.selectAll(null, "tb_account");
RowUtil.printPretty(rows);
}
}
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。