The Construction Of The Poplar Material Database Management System

Poplar is an important fast-growing and high-yield tree species in China.It has the advantages of wide adaptability,short growth period and fast growth rate.In addition,it has an extremely important use in paper and wood processing.In order to study the characteristics of poplar varieties and wood,this paper designed a poplar wood database management system,which will be able to make the poplar varieties and wood properties of the data to be more effective storage and management for the new varieties of poplar Discovery and research on poplar wood provides a more powerful tool.Poplar woody database management system,mainly to the existing variety of poplar as the research object to JSP as the development platform,MySQL for the background database,the use of Web popular B / S structure model,based on the use of SpringMVC and MyBatis framework,The database logical structure,data persistence layer,business logic layer and user view layer are designed,and the data tables of each module are designed in the MySQL database.The data table in the database includes the user information module table,the system feedback module table and the poplar variety information table and its material information module table.Among them,the user login module is mainly used for the verification of user identity;user feedback module for the user and the administrator to communicate and interaction between;poplar variety information table and wood property information table is used to store poplar varieties of resources Basic information and wood microanatomical structure,physical,chemical,mechanical properties of the data.At the same time,in order to analyze the relationship between the attribute fields of each table in the database,the system also makes the report module and is represented by histogram and line graph.Poplar wood database management system in the operation of the main addition,modification,query and so on.In the process of building a tree management system,it is not a simple way to use MySQL + JSP,but with Spring's own MVC framework as MVC development model,and combined with low coupling Java code and simple SQL statement MyBatis Persistence layer framework,which not only can greatly reduce the system development cycle and difficulty,but also more conducive to the system load balancing.In addition,in order to improve the effectiveness and security of system development,the system uses a transaction log processing methods to facilitate the storage of various log information and system improvements.After running the test,the system is stable,easy to operate,good interaction,and basically meet the poplar varieties and wood properties of informationquery and view the demand.