Database Principles online teaching platform (1)

        Paper Keywords: online teaching platform, database, SQL Server 2000 jsp struts
        Abstract: With the computer network Technology widely used in all walks of life, the traditional face to face teaching methods can no longer meet current educational requirements. The use of online teaching platform, students can upload through the network to download e-teachers, lesson plans, teaching videos and other documents to make up for lack of classroom teaching. Teachers can also be a convenient platform through this medium of instruction and student exchanges, receive timely feedback on student learning.
        'Principles of online teaching platform, database,' the Development of targeted 'Database Principles' courses in teaching activities. The system includes a user login module, the user registration module, a message module, video management module, electronic teaching plan management module, online Q & A module.
        The system uses MyEclipse as a Development platform. JAVA as the core language will be JSP as a Development tool, based on Struts framework, the use of SUN operating environment provided by the Tomcat build, combined with SQL Server 2000 for database Development.
        Chapter 1 Introduction
        1.1 Background issues
        With the computer and network Technology, rapid Development, Internet / Intranet Applications in the growing popularity worldwide in many Web services, Web gives refreshing feeling, the growing popularity of various web sites, many people through the network to carry out a variety of Information exchange activities. 'Principles of online teaching platform, database' targeted 'database theory' curriculum activities, the use of online teaching site has many advantages, for example, a 24-hour service at any time, you can make up for lack of students do not understand, changing the traditional job correcting methods a waste of manpower and material resources, teachers can keep abreast of student learning, as well as teachers and students interact more Information. JSP Technology is currently very popular because it can perform complex database operations, highly interactive and user-friendly control and management. The system was developed using JSP.
        1.2 content and significance of the Research
        The twenty-first century is the Information society, Information as the most important resources of the community will become strategic resources attracted widespread attention. In modern life, learning, online learning is also an important way to improve their Technology, one, online teaching platform, came into being. With the rising standard of living, almost every household has a computer. Under the new situation, more and more online teaching platform, have been developed. Online teaching platform, so that students do not understand in class after-school review of the curriculum so that students learn better grasp the point. Is also available online teaching platform, and teachers, to chat, to question some of my teachers do not understand the question. Yourself to fully understand the science curriculum. This will help self-improvement. To learn on their own, but do not understand where we have to ask someone else. With the online teaching platform, can be easily taught himself. Online teaching platform, each class has a few hundred posts, a great amount of Information, the same minutes, there may be many people to speak at the same time, there is support for the proposal, some critics have refuted, very vivid, some more shy students who normally can be published at length. Having been issued beforehand to discuss the content of the teacher, then teachers and students to discuss, interact, trigger inspiration. As some students to leave school to go home, but they have come online during school hours classroom, and students at school they are able to discuss is the network of credit. Such a record can be taught the true and complete preserved for various reasons could not come to class provides the convenience of remedial students in the future. Easy to produce results, the students were also reflected in the oral discussion prior to superficial, now writing to express its views, deeper, more logical, finishing a little after the end of the discussion will be able to form a small paper or dialogues, and we encourage students to discuss the proceeds sorted out in time to consolidate down in order to deepen their impression of
        1.3 In this paper, the content of
        (1) the purpose and significance of systems development.
        (2) System Overview and Application tools description, consisting mainly of JSP, Java Bean, SQL Server 2000 and the B / S model introduction.
        (3) the feasibility of the system analysis and demand analysis in order to meet customer requirements.
        (4) The detailed design of the system, the system database design and process description.
        (5) systems, Conclusions and future prospects.
        Chapter 2 describes key technologies and development tools, and hardware environment
        2.1 Key Technology
        2.1.1 JSP language and its characteristics
        In a traditional web page HTML files (*. htm, *. html) to add Java program fragment (Scriptlet), and JSP tags (tag), constitutes a JSP Web page (*. jsp). JSP page looks like standard HTML and XML pages, along with with the JSP engine can handle and extract additional components.
        Web server in the event of a request to access JSP pages, the first implementation of the program in which fragments, and then implementation of the results to HTML format, back to the user.
        Program fragments can operate the database, re-directed web pages and send E-mail and so on, which is needed to create a dynamic web site functionality.
        All programs on the server side implementation, the network upload the client is only given to the results obtained on the minimum requirements of the client browser. It is based on the powerful Java language, has good scalability, the network database Application development areas in a unique advantage.
        JSP technology in many ways to accelerate the development of dynamic Web pages:
        a. content generation and display separation
        The use of JSP technology, Web page developers can use the HTML or XML logo design and formatting the final page. Or feet have been identified using the JSP generates dynamic content on the page (the content is based on a request to change, for example, account information or to request a specific bottle of wine prices). Generates the logic is encapsulated in the logo and JavaBeans components and tied in a small script, all scripts run on the server side. If the core logic is encapsulated in the logo and Beans, then others, such as Web managers and page designers, can edit and use the JSP page without affecting the content generation.
        On the server side, JSP engine identification and a small script to explain JSP to generate the requested content (for example, by accessing JavaBeans components, the use of JDBCTM technology to access the database, or include file), and the results to HTML (or XML) page in the form of sent back to the browser. This will help authors to protect their code, but to ensure that any HTML-based Web browser, full availability.
        b. stressed the reusable components
        The vast majority of JSP pages rely on reusable, cross-platform components (JavaBeans or Enterprise JavaBeansTM components) to perform the Application required by more complex processing. Developers can share and exchange components to perform common operations, or the making of these components for more users or customer groups to use. Component-based approach to accelerate the overall development process, and make a variety of organizations in optimizing their existing skills and the results of development efforts in equilibrium.
        c. use of identity to simplify page development
        Web page developers do not all programmers are familiar with scripting languages. JavaServer Page technology package, a number of features that are easy to use, with XML-related identity in the JSP for dynamic content generation needs. The standard JSP logo to access and instantiate JavaBeans components, set or retrieve the component attributes, download the Applet, and implementation of other means more difficult to code and time-consuming functions.
        Identity through the development of customized database, JSP technology is extensible. In the future, third-party developers and other personnel functions for commonly used libraries to create their own identity. This allows Web page developers can use familiar tools and the same as the identity of the components to perform specific functions to work.
        Servlets can provide all the functionality d.JSP
        Servlets, compared with, JSP provides all the Servlets functionality than to write and modify the HTML to use Println more convenient. Clearer division of labor, Web page design to write HTML, simply leave space for Servlets programmers can insert a dynamic part. JSP technology can support the highly complex Web-based Applications.
        e. robust storage management and security
        Because JSP pages built-in scripting language is based on the Java programming language, and all of the JSP pages are compiled into a Java Servlet, JSP pages will have all the benefits of Java technology, including robust storage management and security.
        f. Write once, run everywhere
        As part of the Java platform, JSP has a Java programming language 'Write once, run everywhere' characteristics. As more and more suppliers will be added to the JSP support for their products, you can use your own choice of servers and tools, change tools, or the server does not affect the current application.
        2.1.2 Java and Java Servlets Overview
        JSP technology is used JAVA language as a scripting language to talk about JSP technology, and ultimately would like to JAVA technology for some of the basic introduction.
        Recently more than a year, in the Internet appeared on the special event is attractive and the use of Java language written in Java browser, HotJava.
        In 1991, SUN MicroSystem the company's Jame Gosling, Bill Joe and others, as on TV, control boxes and other home baked bread and consumer electronics products interact with and developed a software called Oak (ie, the name of a kind of oak ), but did not attract any attention until the second half of 1994, Internet's rapid development of World Wide Web WWW rapid growth, to promote the progress of the development of the Java language, making it gradually became popular on the Internet Development and Programming language, some well-known computer companies have purchased the right to use the Java language.
        Such as the Mi-croSoft, IBM, Netscape, Novell, Apple, DEC, SGI, etc. Therefore, Java language was a well-known U.S. magazine PC Magazine named the 1995 top ten outstanding scientific and technological products, (computer class this connection, a selection), followed a large number of there written using Java software products by the industrial sector of the attention and praise that "Java is the computer industry since the eighties a major event."
        Microsoft CEO Bill Gates quietly observed for some time, not without emotion, said: "Java is a long time the most prominent programming language", and to identify strategies for Microsoft's entire software development from the PC era towards stand-alone web - centric computing age transfer, while the purchase of Java is his implementation of the deployment of major strategic decisions. Thus, Java the birth of the computer industry as a whole is bound to have far-reaching influence on the traditional computing model presented new challenges.
        SUN MicroSystem the company's CEO Scott McNealy that the Java-Internet and the WWW has opened up a new era.
        World Wide Web WWW founder of Berners-Lee said: "The computer business is the development of the next wave of Java, and will soon happen." It appears that the use of Java has become the trend of the times!
        MicroSoft and IBM are two companies plan to sell Internet software written using Java. Apple, HP, IBM, MicroSoft, Novell, SGI, SCO, Tandem and other companies have plans to develop Java into their operating system, which is responsible for developing and promoting Java technology, SunSoft, Inc. (which is a subsidiary of a subsidiary of SUN), licensing approach to be adopted to allow each company to Java virtual machine and Java class libraries for Applets embedded operating system they have developed, so that various types of developers will be able to more easily choose a variety of platforms to use Java programming language, different The user also can be run from the Web browser, Java application, which undoubtedly was very much welcomed by our customers, but also for the application of Java language to develop a very broad prospect. (Of course, the compatibility between the various types of JavaOS to be taken seriously, Fortunately, JavaSoft has promised to monitor the compatibility).
        In addition, introduced by JavaSoft written entirely in Java on a new Internet browser, HotJava, more practical than the last alpha version, not only to the preparation of dynamic applications, but also to the preparation of a complete suite of desktop applications, in the future will be to provide more be able to assist in the preparation of the Dynamic Application software modules, obviously, this is for the Java application provides a powerful example.
        Introduction 2.1.3 Java Bean
        JavaBean is a Java-based software components, Java Bean, and Active Control, as encapsulated business logic through the establishment of a set of reusable object library. JSP For Web applications, integrating JavaBean component provides a sound support, which can not only shorten the development time (which can directly use have been tested and trusted components), to avoid duplication of development efforts, but also for JSP based application more scalability. JavaBean components can be used to perform complex computing tasks, or is responsible for the interaction with the database and data extraction.
        As the Java language in these areas has the features and advantages, making the software based on its oft-JavaBean component technology concern. Its mission is to: write once, may at any local implementation can be reused in any place. JavaBean components can be reused in any place that can be included in the application, other components, documents, Web sites and application builder tool for a variety of programs, re-use.
        In order to create and use Java software components, JavaBean is implemented as a platform-independent and structure of the application programming interface, its implementation can ignore the internal structure and details of the problem, just the definition of its external features and external features on the line. Among them, properties, methods, and events outside of three interfaces can be developed independently.
        Introduction 2.1.4 tomcat
        Tomcat server is a free open source Web application server, the latest version is 6.0.18 (as of 2008-08-27).
        Tomcat is the Apache Software Foundation (Apache Software Foundation) of the Jakarta project, a core project, from Apache, sun and other companies and individuals formed to jointly develop. Thanks to the participation and support of Sun, the latest servlet and JSP specifications can always be reflected in the Tomcat in, Tomcat 5 supports the latest Servlet 2.4 and JSP 2.0 specifications. Because Tomcat advanced technology, stable performance, and free, so deeply Java fan favorite and has been part of the software developers the recognition become the more popular Web application servers.
        Tomcat popular with the general programmer's like, because it is run-time system resources occupied by small, good scalability, support for load balancing and message service application systems commonly used functions; and it is constantly improved and perfected, no one interested in programmers can change it or where to add new functionality.
        Tomcat is a small, lightweight application server, in the small and medium systems, and concurrent access to the user is not a lot of occasions, has been widely used, is to develop and debug jsp program of choice. For a beginner, this may be so that when a single machine configured apache server can use it to respond to request for a visit to the html page. Tomcat is the Apache server, in fact part of an extension, but it is run independently, so when you run the tomcat, it in fact as a separate process with Apache running on a separate.
        The trick here is that, when configured correctly, Apache for the HTML page services, while Tomcat actually running JSP pages and Servlet. In addition, Tomcat and IIS, Apache and other Web servers, the ability to handle HTML pages of features, but it is a Servlet and JSP container, independent of the Servlet container is Tomcat's default mode. However, Tomcat the ability to deal with the static HTML server than Apache.
        2.2 Development Tools
        Principles of online teaching platform, the database is based on J2EE in order to JDK1.6.0_10 and MyEclipse 6.5 as a development tool, with Macromedia Dreamweaver MX 2004 and Adobe Photoshop design, landscaping the page, using SQL Server2000 as the back-end database, Tomcat 6.0.16 as the Web test server for development design.
        2.2.1 MyEclipse
        MyEclipse Enterprise Workbench (MyEclipse Enterprise Workbench, referred to as MyEclipse) is an extension of Eclipse IDE, we can use it in the database and J2EE development, release, and application server integration greatly improve work efficiency. It is a feature-rich J2EE integrated development environment, including the complete coding, debugging, testing, and publishing capabilities, full support for HTML, Struts, JSF, CSS, Javascript, SQL, Hibernate.
        In MyEclipse 6.5 of this integrated development environment, users can design a program code, run the program, debug and other procedural errors, visual development method reduces the application development more difficult.
        2.2.2 Dreamweaver and Photoshop
        Macromedia Dreamweaver MX 2004 is a visual web design and site management tools, support for the latest Web technology, aesthetics, user interface, multiple user configuration, enhanced source code editing features, extended file format support, enhanced server mode expansion, The database links to improve operations, enhance its collaboration with external applications. Adobe Photoshop 7.0.1 software as a professional image-editing standard, helps produce the best quality for Web graphics.
        2.2.3 SQL Server 2000
          SQL Server 2000 is based on client / server model of a new generation of large-scale database management systems (DBMS). It is in e-commerce, data warehousing and database solutions, such as applications, plays an important role and can provide effective enterprise database management, and adopt effective measures to implement the data integrity and data security. Therefore, SQL Server 2000 database management system is being more and more users, and has become an enterprise-class database management system, the mainstream products.
        2.2.4 Tomcat server
        Tomcat 6.0.16 is the Sun's JSWDK (Java Server Web Development Kit) in the free open-source Serlvet container, which is the Apache Foundation's Jakarta project, a core project, from Apache, Sun and other companies and individuals to develop formed. Thanks to the participation and support of Sun, the latest Servlet and Jsp specification can always be reflected in the Tomcat. That is, when configured correctly, Tomcat actually run the *. jsp pages and servlet.
        2.2.5 B / S Mode
        B / S (Browser / Server, Browser / Server) mode, also known as the B / S structure. It is with the rise of Internet technology on the C / S model application expansion. In this structure, the user interface, work through the IE browser to achieve. B / S mode of operation and maintenance of the biggest advantage is that relatively simple and can achieve a different staff, from different locations, different access methods (such as LAN, WAN, Internet / Intranet, etc.) to access and manipulate a common data; the largest The disadvantage is that the enterprise network environment, dependence on outside too, due to various causes outside the enterprise network can cause system disruption paralyzed.
        B / S mode is defined as TCP / IP support, with HTTP as the transport protocol, the client through the Browser to access Web servers and back-end database connected to the technology and architecture. It consists of the browser, Web servers, application servers and database servers. The client's browser through the URL to access Web server, Web server requests the database server, and the results obtained in HTML format returned to the client browser.
        2.3 Hardware Environment
        Operating System: Microsoft Windows XP or later.
        CPU requirements: CE1.0G above.
        RAM: 1G or more.
        Disk free space: 2G or more.
        Chapter 3 Feasibility Analysis
        3.1 Technical feasibility
        'Principles of online teaching platform, database' against the 'Database Principles' courses of study to develop. Mainly includes a user login module, the user registration module, a message module, video management module, electronic teaching plan management module, online Q & A module.
        The above analysis of the function entirely can be done with HTML language design front page, using Java to write applications, combined with the relevant JSP Servlet technology development and design to be achieved; using Struts technology can greatly reduce the system pre-development work, as well as the later maintenance.
        HTML (Hyper Text Markup Language, Hyper Text Markup Language) for Web page creation and other available in a web browser to see the information in the design of a markup language.
        Java is a cross-platform application software can write object-oriented programming language, it has easy to use and develop the characteristics of high efficiency, but also provides a visual integrated development environment, the environment, the application designer provides a series of flexible and sophisticated tools, can be widely used in a variety of application design.
        JSP (Java Server Pages) technology is used JAVA language as a scripting language, JSP pages for the entire server-side Java library module provides an interface to serve Http applications. By Jsp container (eg Tomcat) first translated into Servlet, then call the Javac to compile Servlet file for the Class, the server is the Class files of final interpretation.
        Servlet is running on Web server or application server on a Java program is a special Java class. Servlet class usually inherited from the HttpServlet class, at least in this class to achieve the doGet or doPost function, in these two functions to deal with requests from clients, and then the results returned. Servlet and Jsp is Sun's J2EE architecture important part, as based on the Java language, so its easy to call the powerful Java API (eg JDBC).
        Struts development technology is to use MVC pattern processing system presentation layer, enabling system development division of labor is more obvious, easy maintenance of the system in the future.
        To sum up, making the process of developing this system there is no technical barriers, with technical feasibility.
        3.2 Economic Feasibility
        Because this system is a personal practice in order to pass, so that what they have learned theoretical knowledge and practical combination of the actual development to improve their ability to do so. And one can own the system used to develop the computer, the software are all free of charge, and now the Internet is rich in resources, school library collections are 10000 is entirely possible to find the information they need; School give us nearly six months time to do graduate design, so from the resources and time is also relatively sufficient.
        Therefore, a low investment in this system Economically feasible.
        3.3 Operation Feasibility
        Use of the system staff, provided with the Windows platform, some basic computer knowledge can be used, does not need any special technical skills. Moreover, taking into account the level of the user's computer practice as much as possible so that the system interface simple, practical and beautiful. In addition, knowledge about computer operations, use of the system-related operators are in place, and if there is any problem during use, as long as after short-term training can be applied freely. Therefore, the system in operation is feasible.
        Chapter 4 System Requirements Analysis
        4.1 Current Business
        4.1.1 Goals
        'Principles of online teaching platform, database' goal is to realize that students can download the e-lesson plans, download videos, upload operations, on-line Q & A, message, registration. Teachers can upload electronic lesson plans, upload videos, download operation, changed back after the operation, on-line Q & A, reply message, release announcements.
        4.2 Current Business
        Based on the above analysis, then according to user requirements, to be function of the system are as follows:
        (1) registration module, students need to register in order to login, register for free.
        (2) login module, the user selects identity of students or teachers entering the appropriate user name and password.
        (3) electronic teaching modules, teaching Principles of electronic lesson plans database on the web site where students can download the electronic teaching plans down. Teachers can also delete the electronic teaching. Reposted elsewhere in the Research Papers Download http://www.hi138.com
        (4) video module, teachers will lecture video database principles on the web site where students can download the video down. Teachers can also delete video.
        (5) operating module, students will be uploaded to the site database, operating principles, the teachers, the students work can be downloaded at all. And then, after correcting the operation of upload, students can then download the changed post-operation.
        (6) Online Q & A module, students can ask questions to teachers online issues, interact with teachers online.
        (7), a message module, students can be their own idea of a message to the teacher tell the teacher. Student teachers can restore message.
        (8) Notice the module, teachers can be notified through the module to the students something.
        (9) Link module, teachers can introduce some good learning sites to students.
        4.3 System flow chart
        System flow chart depicting a general physical system is the traditional tool to express the data flow between the components in the system situation. System, the flow of information in accordance with the operational activities of the process, to clarify all aspects of the business, dealing with the content, processing sequence and processing time requirements, clarify each part of the required information content, information source, destination, handling methods and provision of information processing morphology of the time and information.
        a. Teacher module flowchart, as shown in Figure 4-1:

Figure 4-1 Flowchart of teachers Module
        b. student module flowchart, as shown in Figure 4-2:

Figure 4-2 Student Module Flowchart

        Chapter 5 System Design
        5.1 system function block diagram
        System, users are divided into students and teachers, respectively, have different functions. Student features include: electronic teaching management, video management, job management, message management, and online Q & A. Teachers with electronic teaching management, video management, job management, message management, bulletin Management, Link management, student management, on-line Q & A. For each management module features, students and teachers have different operations. Students and teachers function block diagram is as follows:
        a. Students functional block diagram, as shown in Figure 5-1:
  SHAPE \ * MERGEFORMAT

Figure 5-1 Functional Block Diagram of students
        b. Teachers functional block diagram, as shown in Figure 5-2:
SHAPE \ * MERGEFORMAT

Figure 5-2 Functional Block Diagram of teachers
        5.2 Database structure design
        Database is an essential part of the site, the database determines a complete success of the site, for the basic dynamic website user registration information, and other dynamic parts of the preservation and call is a teaching site is essential. Taking into account the familiarity with the database as well as the Windows operating system, so I bought mall used for small and medium enterprises to use a small database, SQL Server2000 database, the database name is mywork. The system-defined database contains the following eight tables: tb_user (user information table), tb_message (message list), tb_kejian (Electronic Teaching Information Form), tb_note (Notice Information Form), tb_video (video information table), tb_test (job Information Sheet), tb_link (Links list), tb_chat (chat information table). The following describes each of these tables structure:
        tb_user (user information table) stores the student's user name, password, real name, Email, specific attributes shown in Table 5-1:
Table 5-1 User Information Form





































































        tb_message (Message Information Table) stores the message's user name, message subject, message content, message time, message objects, the specific as shown in Table 5-2:
Table 5-2 Message Information Table
















































































        tb_kejian (Electronic Teaching Information Table) stores the name of the electronic lesson plans, upload time. Specific as shown in Table 5-3:
Table 5-3 Electronic Teaching Information Table














































        tb_note (Notice Information Form) storage announcement title, content, release time, a specific Table 5-4 below:
Table 5-4 Notice Information Form

























































        tb_video (Video Information Table) stores the name of the video, upload time, the specific as shown in Table 5-5:
Table 5-5 Video Information Form














































        tb_test (Job Information Table) stores the job name, upload time, upload work student's name, specifically as shown in Table 5-6:
Table 5-6 Operating Information Table



























































        tb_link (Link Table) stores linked sites and Web sites the names of the specific as shown in Table 5-7:
Table 5-7 Link Table














































        tb_chat (chat message table) stores the name of questions the students received the problem person's name, question content and question time, specific as shown in Table 5-8:
Table 5-8 Chat Information Table


































































Reposted elsewhere in the Research Papers Download http://www.hi138.com