RT
马上下班五一了, @zz210891470 你这样@ 我不好23333 我写在这里吧,如果还有其他人问的话, 很简单的。
public class Db_CREATE {
public static void main(String[] args) {
DruidPlugin druidPlugin = new DruidPlugin(
"jdbc:mysql://127.0.0.1:3306/information_schema?characterEncoding=UTF-8&autoReconnect=true&failOverReadOnly=false&zeroDateTimeBehavior=convertToNull",
"root", "").set(1, 1, 100);
ActiveRecordPlugin arp = new ActiveRecordPlugin(druidPlugin);
// 启动管理库
druidPlugin.start();
arp.start();
String name = "test_1";
// 建库
Db.update("CREATE DATABASE " + name);
// 启动业务库
DruidPlugin druidPluginTest = new DruidPlugin("jdbc:mysql://127.0.0.1:3306/" + name
+ "?characterEncoding=UTF-8&autoReconnect=true&failOverReadOnly=false&zeroDateTimeBehavior=convertToNull",
"root", "").set(1, 1, 100);
ActiveRecordPlugin arpTest = new ActiveRecordPlugin(name, druidPluginTest);
druidPluginTest.start();
arpTest.start();
// 建表
DbPro testDb = Db.use(name);
testDb.update(
"CREATE TABLE `a` ( `id` int NOT NULL AUTO_INCREMENT , `xx` varchar(255) NULL , PRIMARY KEY (`id`) ) ");
// 写入数据
testDb.update("INSERT INTO `a` (`xx`) VALUES ('xxxxx')");
// 查询
List<Record> list = testDb.find("SELECT * FROM `a` LIMIT 100");
System.out.println(list.toString());
arpTest.stop();
druidPluginTest.stop();
arp.stop();
druidPlugin.stop();
}
}注意要使用 有权限的账户 才能建库, 比如 root 账户。 有用就点个赞