# balakitbbs

**Repository Path**: olddrivertan/balakitbbs

## Basic Information

- **Project Name**: balakitbbs
- **Description**: 手机社区服务端
- **Primary Language**: Java
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 6
- **Created**: 2017-09-01
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

## balakitbbs
### balakitbbs根据mysql数据库自动生成mvc三层数据jsp页的极速开发web项目。
* 现只支持单表；
* 表和字段必须有注释，页面显示是读到数据库的注释
* 生成springmvc mybatis框架代码。
```
//自动生成代码工具类
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);//生成目录


    }
}
```