The tool is provided to plan the configuration of Excel data, export to MySQL database, and generate XML files, and corresponding XML parsing entity classes
Implement the program
Excel Column name ID
=p represents ID This column is the only field
=S=300 indicates that this column type is a string type, length control 300
=d indicates that the column type is a decimal (double)
=FF_DDDDD represents an associated Excel file ddddd This file does not need a suffix, XML is used everywhere
=l indicates that this column type is a long integer
=b indicates that the column type is TRUE or False (Boolean)
=i indicates that this column type is integer (int) does not fill in any type of default type
=HL indicates that this column is ignored and not read
=CL identity field attribution all (can not be filled out) = client and server generic ac= indicates that the client uses as= to represent the service usage
such as: Aa.xls file
Id=p
name=s=300
Sex=i
Database connection string is configured in the Dbconfig.xml file
<DBConfig>
Connection Address
<DBPath>192.168.1.198</DBPath>
Connection port
<DBPart>3306</DBPart>
Connect User Name
<DBUser>root</DBUser>
Connecting to a database
<DBBase>local_gamesr_data</DBBase>
Password
<DBPwd>fuckdaohaode1314</DBPwd>
</DBConfig>
Source
Program
C # Game Planner Configuration Tool