67,513
社区成员
发帖
与我相关
我的任务
分享
package foobar;
import org.flywaydb.core.Flyway;
public class App {
private static String url = "jdbc:mysql://localhost:3306/miaomiao";
private static String user = "root";
private static String password = "root";
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
Flyway flyway = new Flyway();
flyway.setEncoding("UTF-8"); // 设置sql脚本文件的编码
flyway.setDataSource(url, user, password);
flyway.migrate();
}
}
CREATE TABLE `hehe` (
`id` BIGINT(20) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(50) NOT NULL,
PRIMARY KEY (`id`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1
;
INSERT INTO `hehe` (`name`) VALUES ('aa');
INSERT INTO `hehe` (`name`) VALUES ('bb');
INSERT INTO `hehe` (`name`) VALUES ('阿才');
INSERT INTO `hehe` (`name`) VALUES ('大飞');