ngrinder---从h2数据库迁移到mysql数据库

最新推荐文章于 2024-11-19 21:34:04 发布

原创最新推荐文章于 2024-11-19 21:34:04 发布

· 3.2k 阅读

4 ·

版权

ngrinder 专栏收录该内容

7 篇文章

订阅专栏

1、pom添加mysql驱动

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

2、在controller项目中找到Database枚举类
添加mysql项

/**
     * mysql
     */
    mysql(com.mysql.jdbc.Driver.class, org.hibernate.dialect.MySQL5Dialect.class, "jdbc:mysql://%s?%s") {
        @Override
        protected void setupVariants(BasicDataSource dataSource, PropertiesWrapper databaseProperties) {
            dataSource.setUrl(String.format(getUrlTemplate(),
                databaseProperties.getProperty(DatabaseConfig.PROP_DATABASE_URL),
                StringUtils.trimToEmpty(databaseProperties.getProperty(DatabaseConfig.PROP_DATABASE_URL_OPTION))));
            dataSource.setUsername(databaseProperties.getProperty(DatabaseConfig.PROP_DATABASE_USERNAME));
            dataSource.setPassword(databaseProperties.getProperty(DatabaseConfig.PROP_DATABASE_PASSWORD));
        }
    };

3、根据xml的sql语句初始化数据库

4、找到ngrinder的配置文件database.conf，配置数据库连接

database.type=mysql
database.url=localhost:3306/pftest
database.url_option=useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC&nullNamePatternMatchesAll=true&nullCatalogMeansCurrent=true
database.username=root
database.password=*****