Database-based automated generation tools automatically generate JavaBean, automatically generate database documents (v5.0.0), and javabeanv5.0.0

Database-based automated generation tools automatically generate JavaBean, automatically generate database documents (v5.0.0), and javabeanv5.0.0
The updated version of TableGo v5.0.0 has been released with more powerful functions and speed. The latest version is as follows:
1. The UI is greatly revised and functional modules are reorganized to meet the needs of richer functions and designs in the future.
2. added the Mapper ing configuration file for generating MyBaits in batches.
3. the SQL generation function based on database tables is added. Various SQL statements can be automatically generated according to the configuration.
4. Modify and optimize to quickly generate JavaBean Based on the field, and add the field type and default type.
5. Fixed the issue of errors in JPA annotations generated by PostgreSQL.
6. Table names and field names that are case sensitive and contain both uppercase and lowercase letters in the database.
7. Provides the Jar package version, and supports both Linux and MacBook.
8. modify other bugs and optimize the code.

Here is another setting technique, that is, it is best to select "no field verification" when setting the object generation policy, because I found that it is a little slow and inefficient to obtain field verification data through JDBC. In addition, by configuring the naming policies for Hibernate and MyBaits, you can set the object generation policy to "no Column Annotation on all fields", which is the fastest way to generate a JavaBean, and it is much easier to maintain code in the future.

Hibernate or JPA configuration: hibernate. ejb. naming_strategy = org. hibernate. cfg. ImprovedNamingStrategy
MyBaits configuration: mapUnderscoreToCamelCase = true (after this configuration, you do not need to write the field ing of resultMap in mapper. xml)

Database driver package for MySQL: mysql-connector-java-5.1.39.jar
Oracle Database driver package: ojdbc14.jar
Database driver package used by SQL Server: sqljdbc4.jar
Database driver package for PostgreSQL: postgresql-9.4.1212.jre7.jar

It has always been a headache to automatically generate JavaBean based on the database table structure, automatically generate the Mapper ing configuration file for MyBaits, and automatically generate database design documents, looking at tens of hundreds of thousands of fields in a table is really a pain.
We have also thought about a lot of ways to solve this problem, including using MyEclipse to connect to the database to generate JavaBean, but there are still some unsatisfactory aspects, including the comments of tables and table fields, which are always unable to be generated, in addition, a lot of useless comments will be generated to make the Code look not clean at all, and the configuration is very cumbersome.
As a result, I was so angry that I was able to write a database-Based Automated Generation Tool Using Swing, supporting four types of databases: MySQL, Oracle, SQLServce, and PostgreSQL, supports multiple operating systems such as Windows, Linux, and MacBook, perfectly supports JPA annotations, can generate Entity and DTO at the same time, can automatically remove table prefixes, and can generate single and batch JavaBean, now, not only can the member variables generate comments, but also the Getter and Setter annotations. More importantly, the database design document and the Mapper ing configuration file of MyBaits can be automatically generated. If multiple data sources can be generated in batches, It is very convenient to use.
All configurations are saved locally. Once configured, you can generate an, MyBaits er ing configuration files, and database design documents in seconds, it also integrates various practical tools to make work efficiency burst instantly and productivity burst instantly!
After the use and accumulation of some projects, I will share it with you. You can also put forward any good suggestions and ideas, because you are busy and have no time to perform comprehensive tests, so there will be some bugs. Due to the environment, MySQL, Oracle, SQL Server, and PostgreSQL tests are not complete and may cause bugs. If you find any bugs, please tell me, make corrections in the next version.

1. Database Configuration interface:


2. Public parameter configuration interface:


3. Bean configuration page:


4. Generate the Mapper er file configuration interface of MyBaits:


5. Generate the database design document configuration interface:


6. The integrated tool interface integrates 11 utility tools, which instantly improves productivity several times:


7. The Mapper ing configuration file function for generating MyBaits is added. er. xml is generated in batches Based on the Current Database Configuration:

8. Generate database design documents in batches to quickly generate database design documents in batches. If a multi-thread processing timeout exception occurs during document generation, you can increase the multi-thread timeout time and reduce the number of tables processed by each thread to avoid timeout exceptions (to modify multi-thread parameters, restart the program). If the generated Word file cannot be opened in MS Office, you can use WPS to open it and save it as one time. You can use MS Office to open it. If WPS is not installed, you can open it with a WordPad and save it as a docx file. We recommend that you use WPS to open or store it, in this way, the file style will not be affected, ERTU will be more clear, Word files are generated with the docx4j-3.3.1.jar:




9. Modify and optimize to quickly generate JavaBean Based on the field and add the field type and default type:

10. The SQL generation function based on the database table is added. Various SQL statements can be automatically generated based on the configuration to meet different requirements:




11. This is the automatically generated Entity and DTO:




12. This is the latest source code statistics:

13. The Jar package version is provided, which perfectly supports Linux and MacBook. You only need to enable TableGo. jar in "Security and Privacy:

14. QQ communication group (group password: TableGo ):

Windows: http://download.csdn.net/detail/vipbooks/9856309
Jar version: http://download.csdn.net/detail/vipbooks/9856315

The package contains both 32-bit and 64-bit versions.

To use this tool, you need to install JDK 7 and later versions, because the development environment and compilation environment currently used are both JDK 7, and JDK of other versions have not been tested yet, so there should be no problems with later versions, you must configure JAVA_HOME in the environment variables of the operating system. Otherwise, Java cannot be found.

I found a lot of tools to package the Jar package into an EXE file, and I couldn't fully support 64-bit systems. Finally I found exe4j, finally, we can perfectly package the supported versions into 64-bit systems. I use the 64-bit Win10 system that comes with Alienware15R2, if the generated 32-bit program cannot be run, let's just say, I will go to the Virtual Machine for testing.

I have also published this article in ITeye. Both of these blogs are my own. The software mentioned in this article was developed by myself. If you are unable to download because of lack of product, you can download in http://vipbooks.iteye.com/blog/2375473 for free, if you think this software is good, hope you can download the version I uploaded to CSDN, only 1 point points, this is also my support. Thank you!

Directory:
1st: http://blog.csdn.net/vipbooks/article/details/51912143
2nd: http://blog.csdn.net/vipbooks/article/details/51912537
3rd: http://blog.csdn.net/vipbooks/article/details/51912750
4th: http://blog.csdn.net/vipbooks/article/details/51912930
5th: http://blog.csdn.net/vipbooks/article/details/51915364
6th: http://blog.csdn.net/vipbooks/article/details/51916266
7th: http://blog.csdn.net/vipbooks/article/details/51916507
8th: http://blog.csdn.net/vipbooks/article/details/52005477
9th: http://blog.csdn.net/vipbooks/article/details/52005926
10th: http://blog.csdn.net/vipbooks/article/details/52226266
11th: http://blog.csdn.net/vipbooks/article/details/52806475
12th: http://blog.csdn.net/vipbooks/article/details/53242808
V4.1.2: http://blog.csdn.net/vipbooks/article/details/54234432
V5.0.0: http://blog.csdn.net/vipbooks/article/details/72653898