Jbuilder+weblogic realization of textbook management system

This article has studied the reasonable use of the original heterogeneous database in the campus network environment to establish the related Department management system method, introduced based on the WebLogic application server carries on the textbook Synthesis Management system design and the realization process.

keywords database; Java ee; ejb;weblogic

Introduction

With the continuous improvement of science and technology, the function of computer network has been deeply recognized, it has entered the various fields of human society and plays a more and more important role. The same kind of school campus network has been running for many years, but there are many school management system lack of unified planning, stand-alone operation of the information island is still a lot of, so it is necessary to further study in the campus network environment reasonable use of the original heterogeneous database to establish relevant departments of the management system methods.

In a university, the educational and teaching materials warehouses have their own independent database management system, but the teaching material selection and other work is carried out manually, the staff's labor, efficiency is very low. It is self-evident that the use of existing resources to establish the comprehensive management system of textbooks in the campus network environment. This paper introduces the process of designing and realizing the comprehensive management system of textbook based on WebLogic application server.

System structure

The system contains the teaching material selection, inquiry, modification, order subsystem, the system needs of the educational information and textbook inventory information from the original online database, as shown in Figure 1. Among them, the teaching and Learning Department through B/s mode can carry out the selection of textbooks, inquiries, modification and so on, teaching material management in the Teaching Materials Committee through the C/S mode of local completion, mainly textbooks ordering and system management.

Design and realization of comprehensive management system of textbook

1. Database design

The database system contains the teaching Office database (old), the warehouse database (old) and the Teaching Material Committee database (new), make full use of the original resources to achieve the purpose of sharing data, the table used is the academic office of the curriculum table, professional number of tables, warehouse inventory scale.

Professional number of the Dean's Office:

Column Name	Data type	Length	Allow null
Id	Bigint	8	Whether
Num	Int	4	Is

The curriculum of the Dean's Office:

TD style= "BORDER:0;PADDING:0;" >int TD style= "BORDER:0;PADDING:0;" >cname

	data type	length	allow null
bigint	8
cid
50
teachunit	varcha R	50
sname	varchar	50

Warehouse Inventory Scale:

	data type	length	allow null
int	4
bname	varchar	50
bnote	50
bauthor	varchar< /td>	50
bpublisher	varchar	is
bprice	float	8
bnum	4	is