public static void main(String[] args) throws Exception{
PrintStream ps = new PrintStream("C:\\Users\\Administrator\\Desktop\\新建文本文档.txt");//文件路径
System.setOut(ps);//把创建的打印输出流赋给系统。即系统下次向 ps输出
for (int i = 1; i <=12; i++) {
System.out.println("alter table mcntenant_"+i+".ugc_article add column UID varchar(255) comment '邮件稿去重字段';\r\n" +
"\n" +
"CREATE TABLE mcntenant_"+i+".`mcn_email_config` (\r\n" +
" `id` int(11) NOT NULL,\r\n" +
" `classicids` varchar(2000) DEFAULT NULL,\r\n" +
" `pop_server` varchar(255) DEFAULT NULL,\r\n" +
" `server_name` varchar(255) DEFAULT NULL,\r\n" +
" `server_pass` varchar(255) DEFAULT NULL,\r\n" +
" `server_port` varchar(255) DEFAULT NULL,\r\n" +
" PRIMARY KEY (`id`)\r\n" +
") ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n" +
"\n" +
"alter table mcntenant_"+i+".mcn_channel add column CLIENT_CODE varchar(255) comment '渠道通用标识';\r\n");
}
java将输出的内容写进文件中
最新推荐文章于 2021-02-23 20:56:08 发布