mybatis逆向工程配置文件怎么再偷懒（懒出天际）

使用mybatis逆向工程时，需要在逆向工程配置文件那里指定要对那些表进行逆向工程，如果数据表很多的话，一个一个地写有点麻烦，为什么不自动生成这些XML字段呢

（我的需求是，将数据表首字母大写，然后下划线去掉，再把下划线的后一个字母大写，如evaluation_data对应的PO为EvaluationData）

首先连接数据库

//获取数据库连接
public class JdbcConnection {
    private static String DRIVER = "com.mysql.jdbc.Driver";
    private static String URL = "jdbc:mysql://localhost:3306/mates_db";
    private static String USERNAME = "root";
    private static String PASSWORD = "123456";

    public static Connection getConnection(){
        try {
            Class.forName(DRIVER);
            return DriverManager.getConnection(URL,USERNAME,PASSWORD);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return null;
    }
}

//数据库操作工具类
public class SqlHelper {
    private Connection con = null;

    private PreparedStatement pstmt = null;

    public SqlHelper() {
    }

    public SqlHelper(Connection con) {
        this.con = con;
    }

    public int executeUpdate(String sql, String... attributes) throws SQLException {
        System.out.println("sql executeUpdate...");
        pstmt = this.con.prepareStatement(sql);
        if (attributes!=null){
            for (int i = 0;i<attributes.length;i++){
                pstmt.setString(i+1,attributes[i]);
            }
        }
        int res = pstmt.executeUpdate();
        return res;
    }

    public ResultSet executeQuery(String sql,String... attributes) throws SQLException {
        System.out.println("sql executeQuery...");
        pstmt = this.con.prepareStatement(sql);
        if (attributes!=null){
            for (int i = 0;i<attributes.length;i++){
                pstmt.setString(i+1,attributes[i]);
            }
        }
        ResultSet resultSet = pstmt.executeQuery();
        return  resultSet;
    }

    public void close() throws SQLException {
        if (pstmt!=null){
            pstmt.close();
        }
        if (con!=null){
            this.con.close();
        }
    }
}

//XML配置文件的那个父标签
public class XMLFather {
    private String tableName;

    private String domainObjectName;

    public String getTableName() {
        return tableName;
    }

    public void setTableName(String tableName) {
        this.tableName = tableName;
    }

    public String getDomainObjectName() {
        return domainObjectName;
    }

    public void setDomainObjectName(String domainObjectName) {
        this.domainObjectName = domainObjectName;
    }
}

//XML配置文件的子标签，设置逆向工程属性之类的
public class XMLProperties {
    private String useActualColumnNames;

    public String getUseActualColumnNames() {
        return useActualColumnNames;
    }

    public void setUseActualColumnNames(String useActualColumnNames) {
        this.useActualColumnNames = useActualColumnNames;
    }
}

//主角来啦
public class MybatisGeneratorHelper {
    //主方法，获取指定数据库的所有数据表
    @Test
    public void main() throws SQLException, ClassNotFoundException {
        SqlHelper sqlHelper = new SqlHelper(JdbcConnection.getConnection());
        String sql = "SHOW TABLES";
        ResultSet resultSet =  sqlHelper.executeQuery(sql,null);
        List<String> tables = new ArrayList<String>();
        while (resultSet.next()){
            tables.add(resultSet.getString(1));
        }
        sqlHelper.close();
        generator(tables);
    }
    //对各张表进行操作
    public void generator(List<String> tables){
        for (String table : tables){
            XMLFather xmlFather = new XMLFather();
            xmlFather.setTableName(table);
            xmlFather.setDomainObjectName(tableNameTranslate(table));
            XMLProperties xmlProperties = new XMLProperties();
            xmlProperties.setUseActualColumnNames("true");
            System.out.println(XMLGenerator(xmlFather,xmlProperties));
        }
    }
    //将数据库的首字母大写，并去掉下划线，改为驼峰风格
    public String tableNameTranslate(String tableName){
        char[] newWords = new char[tableName.length()];
        char[] words =  tableName.toCharArray();
        newWords[0] = (char) (words[0]-32);
        for (int i = 1,len = words.length,k=1;i<len;i++){
            if (words[i]=='_'){
                newWords[k] = (char)(words[i+1]-32);
                i++;
                k++;
            }else {
                newWords[k] = words[i];
                k++;
            }
        }
        return new String(newWords);
    }
    //XML拼接方法
    public String XMLGenerator(XMLFather xmlFather,XMLProperties xmlProperties){
        StringBuilder stringBuilder = new StringBuilder();
        stringBuilder.append("<table tableName=\""+xmlFather.getTableName()+"\" domainObjectName=\""+xmlFather.getDomainObjectName()+"\">");
        if (xmlProperties.getUseActualColumnNames()!=null){
            stringBuilder.append("<property name=\"useActualColumnNames\" value=\""+xmlProperties.getUseActualColumnNames()+"\"/>");
        }
        stringBuilder.append("</table>");
        return stringBuilder.toString();
    }
}

将控制台打印出来的东西copy到逆向工程配置文件里面即可