JAVA精品论文JSP网络远程作业处理系统中英文翻译.docVIP

Database Access ALMOST ALL APPLICATIONS MUST deal with saving and preserving data. Although some infor-mation can be stored in property files and the system environment, using a database is a natural way to ease development and increase the scalability of an application. Even if an application isn’t primarily designed for storing and cataloging information, it can still benefit from having easy access to data storage and retrieval. Databases are the lifeblood of many systems and applications, and being able to understand them and manipulate them comfortably is important to the career of a software engineer. Data management is such a large task that a database team is an integral part of any medium- to large-sized organization, and an organization can have a number of enterprise database systems. In this chapter, we’ll discuss how to connect to a database using JDBC (Java Database Connectivity). We’ll use the MySql database for the chapter examples, and we’ll try to keep the code as portable as possible. (We’ll discuss portability and how to use complicated relational designs in Chapters 13 and 14.) Featured in this chapter: ◆ Understanding database connectivity ◆ Using Java Database Connectivity ◆ Basic connection pooling ◆ A sample application illustrating basic database interactions Database Connectivity and JDBC Before we look in depth at JDBC, let’s look at the big picture. When a database starts, it usually services requests by listening to a network port, often using TCP/IP (Transmission Control Protocol/Internet Protocol). The situation is analogous to a web server that starts, listens to port 80, and then responds to requests. However, unlike a web server, no two databases speak exactly the same language. Even a complex application that deals with raw streams of data needs a translator to facilitate the connection to the database. That translator mechanism is a database driver.