C # Game planning and configuration tools,

C # Game planning and configuration tools,

This tool provides planning and configuration of excel Data, exporting data to the mysql database, and generating xml files, and corresponding xml parsing entity classes.

Implemented the program

 

Excel column name ID
= P indicates that the ID column is a unique field.
= S = 300 indicates that the column type is String type and the length is 300
= D indicates that the column type is double with the decimal point)
= FF_ddddd indicates that the associated excel file ddddd does not need to be suffixed. XML is used everywhere.
= L indicates that this column type is a long integer (long)
= B indicates that the column type is true or false (Boolean)
= I indicates that the column type is an integer (int) and no default type is specified.
= HL indicates ignore this column and do not read
= CL Id field ownership ALL (optional) = client and server common AC = indicates that the client uses AS = indicates that the service is used

Example: aa.xls File
ID = P
Name = S = 300
Sex = I

The database connection string is configured in the dbconfig. xml file.

<DBConfig>
Connection address
<DBPath> 192.168.1.198 </DBPath>
Connection Port
<DBPart> 3306 </DBPart>
Connection username
<DBUser> root </DBUser>
Connect to database
<DBBase> local_gamesr_data </DBBase>
Password
<DBPwd> fuckdaohaode1314 </DBPwd>
</DBConfig>

Source code

 

Program