Java+xml to import data into SQL Server

When we started learning XML and database programming, we all had a lot of documentation and information to start with. The author in the work, just want to use these, a program at hand to organize, its function is very simple, in the Java language from the Access database, some data into the SQL database.

Original Access database table structure:

Table: Production

Product model	String type	Product number
Part drawing number	String type	Part number
Picture number	String type	Tool number

data table structure in SQL Server:

Project Product Table

Id	Int	Identity
Number	Varchar64	Number

Product Parts Table

Id	Int	Identity
Pid	Int	Product identification number (associated with the ID in the project table)
Number	Varchar64	Number

ComponentType and parts corresponding to the production tools table

Id	Int	Identity
Aid	Int	Part identification (associated with an ID in the product table)
Number	Varchar64	Number