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

        Catalogue:                  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             7th edition:http://blog.csdn.net/vipbooks/article/details/51916507            8th edition: HTtp://blog.csdn.net/vipbooks/article/details/52005477             9th Edition:http://blog.csdn.net/vipbooks/article/details/52005926             10th edition:http://blog.csdn.net/vipbooks/article/details/52226266             11th Edition: http://blog.csdn.net/vipbooks/article/details/52806475   11th version of the update shocked release, more powerful, speed over the onlookers, this version is updated as follows:              1. New Data source configuration management features, you can add multiple different data sources for each type of database.              2, added fast new data source function, quickly add data source for the currently selected database.              3, the new Open Directory feature, left-click to open the menu to select the directory to open, Right-click to quickly open the directory where the current app is located.              4. Added support for table names and field names named after the hump, for example, the table name is UserInfo, The class name of the generated bean is also userinfo; the field name is userid,                &NBSPThe generated bean field is also a userid.              5, the main interface removes the drive name pull option, and adds a quick switch data source configuration drop-down option.              6, improve the "more" in the exact match of the Select Table function, The selected table in the text box is checked when the Select Table dialog box is opened.              7, improve the clear StringBuffer tool, select the SQL type will automatically "//" Replace with "--".              8, improve the string formatting tool, there will be more types to choose, more convenient operation.              9, some other minor bug modification and code optimization adjustment.   I found that you can generate a doc document for a database directly from database information, and more powerful features will be available in future releases.   Here's the trick of setting up an entity generation strategy, preferably without field validation, because I find it a bit slow and inefficient to get fields to validate data through JDBC. And by configuring Hibernate and Mybaits's naming strategy, the entity generation policy can be set to "no column annotations on all fields", resulting in the fastest JavaBean and much easier code maintenance.          Hibernate or JPA configuration: hibernate.ejb.naming_strategy= org.hibernate.cfg.improvednamingstrategy        MySQL configuration: Mapunderscoretocamelcase=true (so configured later on mapperThere is no need to write Resultmap in XML)          everyone in the process of use if you find a bug must remember to tell me, I am in the next update version of the fix. Database driver package used by         mysql:mysql-connector-java-5.1.39.jar         Database driver package:ojdbc14.jar        SQL used by Oracle Database driver package used by Server:sqljdbc4.jar        Database driver package used by PostgreSQL:postgresql-9.4.1208.jre7.jar  has always been a headache for converting a database table into an entity or a dto, and it's a waste of time and complexity. Looking at hundreds of hundreds of of thousands of fields on dozens of watches, it's really a headache.       We've also thought of a lot of ways to solve this problem, including using MyEclipse to connect to a database to generate JavaBean, but there are some things that are going to be unsatisfactory, Comment, which includes tables and table fields, always fail to generate, and generates a lot of useless comment code that makes the code look dirty, the configuration is cumbersome, and so on.        so rage, self-clothed, in the last year himself with swing wrote a table through the database to generate JavaBean tools, support for MySQL, Oracle, Sqlservce, PostgreSQL, the perfect support for JPA annotations, you can generate both entity and DTO, you can automatically remove the table prefix, and support the removal of multiple prefixes, to support the precise designation of only the number of tables of the bean, but also support the Fuzzy Lookup to generate which tables of beans, Now not only the member variable can generate notes, but also in getter and setter can have notes!         More importantly, all configurations can be saved locally, as long as they are configured once,Second use just click to generate JavaBean, the next second will be able to get the javabean you want, fully realize the second generation. and integration of a variety of practical tools, so that the efficiency of instant bursting, the productivity of instant explosion table.

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. Due to environmental reasons, the main test is MySQL, oracle,sqlserver, PostgreSQL test is not complete, there may be a bit of bug, if you find what bug remember to tell me, in the next version of the fix.

1. Configure the Database interface:

2. Configure the conversion parameter interface:

3, the field setting interface, you can set the field conversion type according to the different requirements, and can add the annotation configuration on the date type:

4. Advanced Setup Interface:

5, integrated tool interface, integration of some practical tools, the efficiency of the instant increase several times:

6, skin-changing function, 38 skins Any choice, there is always a suitable for you:

7. New Data source configuration management function, you can add multiple different data sources for each type of database. Delete to check the data source to delete, modify and select the data source without checking, double-click to quickly select the desired data source:

8. Added fast new data source feature to quickly add data source for the currently selected database:

9, the new Open Directory function, left-click to open the menu to open the directory, right button can quickly open the current application in the directory:

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

11. After configuring the database, click the Test Database connection button to test if the database is able to connect successfully and display the database version information:

12, choose the function of the 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:

13, view all the tables in the Database dialog box, click the More button next to the exact match text box, you can pop up the dialog box to select the database table, here will list all the tables in the database, and support the fuzzy query (case-insensitive) to find the required table, check the box to select the desired table, click to confirm the selection ( Double-click to quickly select):

15. The Schema,schema to be used when generating the entity can be generated automatically: if the schema is the same as the user name of the database, select Dbusername if the schema is the same as the database's library name dbname

16. You can generate both entity and DTO, or you can choose to generate only some type of bean:

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

18. Entity Generation Strategy, you can configure different build strategies for entities based on requirements:

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

20, custom set file comments and set the function of class annotations, and can use some internal parameters:

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

22. Clear the StringBuffer tool, is the reverse tool of string concatenation tool:

23, string formatting tools, improve the efficiency of the weapon:

24. Table name to Hump name Tool:

25, the hump named to the table name tool:

26. JSON String Formatting tool:

27. XML string Formatting tool:

28. JSON to XML tool:

29. XML to JSON tool:

30, the first time the program 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 the two comments, generally the first time to go in as long as the database is configured, point generation JavaBean, By default, you can generate both entity and DTO:

31. This is an automatically generated entity and DTO:

32, this is the latest source code statistics, through a few version of the function overlay, now the code plus comments unknowingly already have tens of thousands of lines:

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

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.

Find a lot of packages to the jar package EXE file tools, can not perfectly support 64-bit system, finally found the exe4j, finally can be packaged into a 64-bit system support version, I use the 64-bit WIN10 system, if the generated 32-bit program can not run everyone said, I'll look for the virtual machine 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.

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