Automatic generation of JavaBean based on table structure, the strongest and most professional javabean tool in the history of Table Structure (6th edition)



        directory:
                 1th Edition: http://blog.csdn.net/vipbooks/article/details/51912143
                 2nd edition: http://blog.csdn.net/ vipbooks/article/details/51912537
                 3rd edition: http://blog.csdn.net/vipbooks/article/details/51912750
                 4th Edition: http://blog.csdn.net/vipbooks/article/details/ 51912930
                5th edition: http ://blog.csdn.net/vipbooks/article/details/51915364
                 6th edition: http://blog.csdn.net/vipbooks/article/details/51916266

The 6th edition of the major update shock released, more powerful, more speed over the onlookers, this version updated as follows:
1, new test database connection.
2. Standard template added C # Standard template.
3. field conversion settings new annotation configurations that need to be added on a type.
4, the new entity generation strategy, can be based on the requirements of the project to configure different generation strategy for the entity.
5, the new entity primary key generation policy, you can configure the manual generation of primary keys can also be configured to automatically generate primary keys.
6. You can automatically generate a file with the corresponding extension according to the standard template you choose, or you can set the file name extension manually.
7, new settings file comments, and can use some system parameters.
8. New settings class comment, and can use some system parameters.
9, Integration tool added string string Splicing tool, realize the second spell StringBuffer, no longer afraid to spell long SQL.
10. Add XML string splicing tool for integration tool.

Everyone in the process of use if found a bug must remember to tell me, I am in the next update version of the fix.

It has been a headache to convert a database table into an entity or a DTO, which is a headache, and it's a waste of time and complexity, looking at hundreds of hundreds of of thousands of fields in dozens of tables.
We have also thought of a lot of ways to solve this problem, including using MyEclipse to connect to the database to generate JavaBean, but there will be some unsatisfactory place, including tables and table fields comment always can not be generated, but also generate a lot of useless comment code, Make the code look dirty, configuration is cumbersome, and so on.
So rage, self-clothed, last year himself with swing wrote a table through the database generated JavaBean tools, support MySQL, Oracle, Sqlservce, the perfect support JPA annotations, you can generate both entity and DTO, You can automatically remove the table prefix, and support the removal of multiple prefixes, support for specifying exactly which tables are generated by the bean, but also support the Fuzzy Lookup to generate a few tables of beans, now not only the member variable can be generated notes, but also in getter and setter can have notes!
More importantly, all the configuration can be saved to the local, as long as the configuration once, the next use as long as a point to generate JavaBean, the next second will be able to get the javabean you want, fully realize the second generation.

After several projects of the use and accumulation, I decided to share it for everyone to use, we have any good suggestions and ideas can also be proposed, because the relatively busy, has no time to modify and maintain, so there will be some bugs. Because of the environment, the main test is mysql,oracle and SQL Server testing is not complete, there may be a bug, if you find any bug remember to tell me, in the next version of the fix.

Well, let me introduce you to the tool I have written.

1. Configure the Database interface:

2, configure the conversion parameters interface, Standard template added C # Standard Template:

3. Field conversion settings interface, you can configure different field conversion types according to different project requirements, and add annotation configurations that need to be added on a type:

4, Advanced Settings interface, new entity generation strategy, primary key generation policy, set file comments, set class comments, according to the standard template to automatically generate the corresponding extension according to the selected file, the package to be imported and the package to be excluded can be set to customize the guide package keywords, such as: using System; ：

5, integrated tool interface, added string string splicing tool, XML string splicing tool:

6, select the supported database, the following driver name, IP address, library name, port, user name and password will automatically follow the corresponding changes to support different databases:

7. After the database is configured, click the Test Database connection button to test if the database can be successfully connected.

8, choose the function of the template, add C # Standard template, you can generate different language beans as needed. If you want to generate a bean for another programming language, you can send me a standard bean for that programming language, and I'll publish it as a standard template:

9. View the dialog box for all tables in the database, click the More button next to the exact match text box or double-click the exact match text box to pop up the dialog box to select the database table, which will list all the tables in the database, and support the fuzzy query (case-insensitive) to find the required tables, select the desired table in the check box Click to confirm the selection:

10. Support for beans with JPA annotations and without JPA annotations:

11. field conversion settings new annotation configurations that need to be added on a type. For the time being, adding annotations to the date type is the only feature that is used most often, and if you want to add annotations to other types, you can tell me:

12, the new entity generation strategy, can be based on the requirements of the project to configure different build policies for the entity:

13, the new entity primary key generation policy, you can configure the manual generation of primary keys can also be configured to automatically generate a primary key:

14. You can automatically generate the corresponding extension file according to the standard template you choose, or you can set the file extension manually:

15. Add the function of setting file comment and setting class comment, and can use some internal parameters:

16, add string string Splicing tool, realize the second spell StringBuffer, no longer afraid to spell long sql:

17. New XML string Splicing tool:

18, the first time the tool is opened will automatically generate two configuration files, one is the configuration database, one is the configuration parameters, if you set the file comments and class comments will also generate the configuration files of these two comments, generally the first time to go in just configure the database, point generation JavaBean, By default, you can generate both entity and DTO:

19. This is an automatically generated entity and DTO:

: http://download.csdn.net/detail/vipbooks/9576454

The compressed package contains 32-bit and 64-bit two versions.

Use this tool need to install Java1.6 and above, because the development environment is JDK1.7, the compilation environment is JDK1.6, so 1.7 and 1.6 of the JDK can run, the other version of the JDK has not been tested, the higher version should be no problem, must be in the operating system environment variables to configure the Java _home, or you will not find Java.

Looking for a lot of tools to package the jar into EXE files, some do not support 64-bit system, and finally found the exe4j, perfect support packaged into 64-bit system support version, but this software needs to find Register machine Note book. I use a 64-bit system, I do not know whether the generated 32-bit programs can not run, if you can not run everyone say, I will test again.

Note: After each download of a new version, if you overwrite the old version of the directory, it is best to first delete the existing Paramconfig.ini configuration file, open the program will automatically regenerate a match with the latest version of the configuration file, so as to avoid the problem of new features.

This article I have published in Iteye, and now in Csnd again, these two blogs are my own, the article mentioned in the software was developed by myself. If you are unable to download due to the lack of product, you can download the http://vipbooks.iteye.com/blog/2224496 free, if you think this software is good, I hope you can download the version I uploaded to Csdn, only need 1 points, but also for my support, thank you!



Automatic generation of JavaBean based on table structure, the strongest and most professional javabean tool in the history of Table Structure (6th edition)