The Design And Implementation Of Stored Procedure For Information For Teacher Management System

Resources information technology has become the new trend of the development of the world, With the popularization of information technology, information management systems play an increasingly important role.University personnel resource management system has permeated to all levels of management of the College, whether it is of itself, or from the role played by, and made a significant contribution to the innovation, development, and management expenses for the various colleges. This system is based on B/S structure of the database management system (DBMS) solutions, on the windows platform using the Oracle database system, the establishment of the Teacher Management System in Jiangsu Province, as teachers of colleges and universities to establish a set of shared information database.First, the acquisition of database information items based on the actual needs of the provincial education department, comprehensive, non-redundant, and create a variety of constraints between tables. Then, the use of the SQL Developer database management tool for incremental system development model, the establishment of a database system, ASP.NET and ADO.NET technology to achieve access to the database. Constraints between the tables by the system, the system diagrams and E-R diagrams;Then,provides a comprehensive rights management control in order to ensure the security of data, divided into three access roles:the first one is the ordinary user, allowing ordinary Register only personal information to add, modify, delete query operation, the second school administrator, school information management operations;The third is the administrator of the Department of Education, with the highest authority, can modify only query, delete all schools and teachers. Then create two public class Classl University:Class classes each table as a data structure for processing; University in the class as a database connection interface, convenient database interface data transfer.Finally, in order to optimize the performance of database systems, to create a stored procedure (Stored Procedure). The storage process control flow statements precompiled collection of SQL statements and optional compiled stored in the database, to store a name and processed as a unit, to improve system speed up the search. The paper presents a combination based on Java and PL/SQL stored procedure,compared to the PL/SQL stored procedures with higher scalability.