//自动生成代码工具类
public class GenCode {
    // 表名
    static ArrayList<String>  tablenames = new ArrayList<String>();
    public static final String URL = "jdbc:mysql://localhost:3306/information_schema?useUnicode=true&characterEncoding=UTF-8";
    
    //-------------自动生成代码如下参数要修改-----------------------
    public static final String NAME = "root";
    public static final String PASS = "";
    public static final String DRIVER = "com.mysql.jdbc.Driver";
    public static final String DATABASE = "balakit";
    public static final String pojobackage = "com.balakitbbs.entity";
    public static final String daobackage = "com.balakitbbs.dao";
    public static final String servicebackage = "com.balakitbbs.service";
    public static final String controllerbackage = "com.balakitbbs.controller";
    //-------------------------------------------------------------
    
    
    
    public static void main(String[] args) {
        // 创建连接
        Connection con = null;
        // 查要生成实体类的表
        String sql = "select table_name,table_comment from TABLES where TABLE_SCHEMA = '" + GenCode.DATABASE + "'";
        PreparedStatement pStemt = null;
        try {
            try {
                Class.forName(GenCode.DRIVER);
            } catch (ClassNotFoundException e1) {
                e1.printStackTrace();
            }
            con = DriverManager.getConnection(GenCode.URL, GenCode.NAME, GenCode.PASS);
            pStemt = con.prepareStatement(sql);

            ResultSet executeQuery = pStemt.executeQuery();
            while (executeQuery.next()) {
                String tablename = executeQuery.getString(1);
                String tablecomment = executeQuery.getString(2);
                tablenames.add(tablename + "," + tablecomment);
                System.out.println(tablename + "\t" + tablecomment);
            }// 显示数据
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                con.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }

        for (int i = 0; i < tablenames.size(); i++) {
            String tablename = tablenames.get(i).trim();
            new GenEntity(tablename);    //生成实体
            new GenDao(tablename);       //生成dao
            new GenXmlMapper(tablename); //生成xmlMapper文件
            new GenService(tablename);   //生成service
            new GenController(tablename);//生成controller
            new GenJsp(tablename);       //生成jsp
        }
        new GenIndexJsp(tablenames);//生成目录


    }
}