Page 25 - Fister jr., Iztok, and Andrej Brodnik (eds.). StuCoSReC. Proceedings of the 2015 2nd Student Computer Science Research Conference. Koper: University of Primorska Press, 2015
P. 25
QL Database On-line Update Technology Based on JSP
DU Xiaocheng1 GAO Tao1, 2, * YANG Yaoquan1
1. Department of Automation, North China Electric Power University, Baoding 071003, Hebei Province, China
2. Knowledge Engineering and Discovery Research Institute, Auckland University of Technology, Auckland 1010, New
Zealand
Email: gaotao863@163.com
Abstract With the booming of the network technology, JSP (Java Server Pages) has been widely applied, and it is
playing an increasingly important role. This paper introduces the technology of JSP, and expounds the concrete process
of MySQL database connection technology by JDBC (Java Data Base Connectivity); finally it presents the methods of
operating MySQL database on-line based on JSP.
Keywords JSP, MySQL, JDBC, On-line Update
0 Introduction MySQL began as a low-end alternative to more powerful
proprietary databases, it has gradually evolved to support
Today, the development of network technology is higher-scale needs as well. It is still most commonly used
constantly changing, and it has become the main theme in small to medium scale single-server deployments.
in our lives and society. Almost every area of human
life is changed due to network. JavaServer Pages (JSP) JDBC is a Java database connectivity technology
is a technology that helps software developers create (Java Standard Edition platform) from Oracle Corporation.
dynamically generated web pages based on HTML, This technology is an API for the Java programming
XML, or other document types. JSP is similar to PHP, language that defines how a client may access a database.
but it uses the Java programming language. JSP allows It provides methods for querying and updating data in a
Java code and certain pre-defined actions to be database. JDBC is oriented towards relational databases. A
interleaved with static web markup content, such as JDBC-to-ODBC bridge enables connections to any
HTML, with the resulting page being compiled and ODBC-accessible data source in the JVM host
executed on the server to deliver a document. The environment. JDBC allows multiple implementations to
compiled pages, as well as any dependent Java exist and be used by the same application. The API
libraries, contain Java byte code rather than machine provides a mechanism for dynamically loading the correct
code. Like any other Java program, they must be Java packages and registering them with the JDBC Driver
executed within a Java virtual machine (JVM) that Manager. The Driver Manager is used as a connection
interacts with the server's host operating system to factory for creating JDBC connections.
provide an abstract, platform-neutral environment.
This paper is mainly focus on the combining
MySQL is a popular choice of database for use in technology between MySQL database and JSP by JDBC
web applications, and is a central component of the for the database data online updates, and thus to optimize
widely used LAMP open source web application the data flow in web network technology.
software stack. MySQL can be built and installed
manually from source code, but this can be tedious so 1 The JSP Technology
it is more commonly installed from a binary package
unless special customizations are required. Though The fundamental part of JSP (Java Server Pages) is a
simplified design of Servlet. It is proposed by Sun
Microsystems and also many companies involved for the
* Contact Author: Tao Gao, Email: gaotao863@163.com 25
StuCoSReC Proceedings of the 2015 2nd Student Computer Science Research Conference
Ljubljana, Slovenia, 6 October
DU Xiaocheng1 GAO Tao1, 2, * YANG Yaoquan1
1. Department of Automation, North China Electric Power University, Baoding 071003, Hebei Province, China
2. Knowledge Engineering and Discovery Research Institute, Auckland University of Technology, Auckland 1010, New
Zealand
Email: gaotao863@163.com
Abstract With the booming of the network technology, JSP (Java Server Pages) has been widely applied, and it is
playing an increasingly important role. This paper introduces the technology of JSP, and expounds the concrete process
of MySQL database connection technology by JDBC (Java Data Base Connectivity); finally it presents the methods of
operating MySQL database on-line based on JSP.
Keywords JSP, MySQL, JDBC, On-line Update
0 Introduction MySQL began as a low-end alternative to more powerful
proprietary databases, it has gradually evolved to support
Today, the development of network technology is higher-scale needs as well. It is still most commonly used
constantly changing, and it has become the main theme in small to medium scale single-server deployments.
in our lives and society. Almost every area of human
life is changed due to network. JavaServer Pages (JSP) JDBC is a Java database connectivity technology
is a technology that helps software developers create (Java Standard Edition platform) from Oracle Corporation.
dynamically generated web pages based on HTML, This technology is an API for the Java programming
XML, or other document types. JSP is similar to PHP, language that defines how a client may access a database.
but it uses the Java programming language. JSP allows It provides methods for querying and updating data in a
Java code and certain pre-defined actions to be database. JDBC is oriented towards relational databases. A
interleaved with static web markup content, such as JDBC-to-ODBC bridge enables connections to any
HTML, with the resulting page being compiled and ODBC-accessible data source in the JVM host
executed on the server to deliver a document. The environment. JDBC allows multiple implementations to
compiled pages, as well as any dependent Java exist and be used by the same application. The API
libraries, contain Java byte code rather than machine provides a mechanism for dynamically loading the correct
code. Like any other Java program, they must be Java packages and registering them with the JDBC Driver
executed within a Java virtual machine (JVM) that Manager. The Driver Manager is used as a connection
interacts with the server's host operating system to factory for creating JDBC connections.
provide an abstract, platform-neutral environment.
This paper is mainly focus on the combining
MySQL is a popular choice of database for use in technology between MySQL database and JSP by JDBC
web applications, and is a central component of the for the database data online updates, and thus to optimize
widely used LAMP open source web application the data flow in web network technology.
software stack. MySQL can be built and installed
manually from source code, but this can be tedious so 1 The JSP Technology
it is more commonly installed from a binary package
unless special customizations are required. Though The fundamental part of JSP (Java Server Pages) is a
simplified design of Servlet. It is proposed by Sun
Microsystems and also many companies involved for the
* Contact Author: Tao Gao, Email: gaotao863@163.com 25
StuCoSReC Proceedings of the 2015 2nd Student Computer Science Research Conference
Ljubljana, Slovenia, 6 October
