- 1、下载文档前请自行甄别文档内容的完整性,平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益,请联系客服反馈,我们会尽快为您处理(人工客服工作时间:9:00-18:30)。
1
Objectives
To
Байду номын сангаас
understand the concept of database and database management systems (§37.2). To understand the relational data model: relational data structures, constraints, and languages (§37.2). To use SQL to create and drop tables, and to retrieve and modify data (§37.3). To learn how to load a driver, connect to a database, execute statements, and process result sets using JDBC (§37.4). To use prepared statements to execute precompiled SQL statements (§37.5). To use callable statements to execute stored SQL procedures and functions (§37.6). To explore database metadata using the DatabaseMetaData and ResultSetMetaData interfaces (§37.7).
Liang, Introduction to Java Programming, Eighth Edition, (c) 2011 Pearson Education, Inc. All rights reserved. 0132130807
5
Relational Structure
A relational database consists of a set of relations. A relation has two things in one: a schema and an instance of the schema. The schema defines the relation and an instance is the content of the relation at a given time. An instance of a relation is nothing more than a table with rows and named columns. For convenience with no confusion, we refer instances of relations as just relations or tables.
3
Database Application Systems
Application Users
Application Programs
Database Management System
…
Database Management System
…
…
database
Liang, Introduction to Java Programming, Eighth Edition, (c) 2011 Pearson Education, Inc. All rights reserved. 0132130807
4
Rational Database and Relational Data Model
Most of today’s database systems are relational database systems, based on the relational data model. A relational data model has three key A relational data model has three key components: structure, integrity and languages.
Liang, Introduction to Java Programming, Eighth Edition, (c) 2011 Pearson Education, Inc. All rights reserved. 0132130807
7
Student Table
Student Table ssn 444111110 444111111 444111112 444111113 444111114 444111115 444111116 444111117 444111118 444111119 444111120 firstName Jacob John George Frank Jean Josh Josh Joy Toni Patrick Rick mi lastName R K K E K R R P R R R Smith Stevenson Smith Jones Smith Woo Smith Kennedy Peterson Stoneman Carter phone 9129219434 9129219434 9129213454 9125919434 9129219434 7075989434 9129219434 9129229434 9129229434 9129229434 9125919434 birthDate street zipCode deptID BIOL BIOL CS BIOL CHEM CHEM BIOL CS MATH MATH BIOL 1985-04-09 99 Kingston Street 31435 null 100 Main Street 31411 31419 31411 31411 31411 31411 31412 31412 31411 1974-10-10 1200 Abercorn St. 1970-09-09 100 Main Street 1970-02-09 100 Main Street 1970-02-09 555 Franklin St. 1973-02-09 100 Main Street 1974-03-19 103 Bay Street 1964-04-29 103 Bay Street 1986-04-09 19 West Ford St.
Liang, Introduction to Java Programming, Eighth Edition, (c) 2011 Pearson Education, Inc. All rights reserved. 0132130807
Liang, Introduction to Java Programming, Eighth Edition, (c) 2011 Pearson Education, Inc. All rights reserved. 0132130807
2
What is a Database System?
Application Users
1969-04-29 101 Washington St. 31435
Liang, Introduction to Java Programming, Eighth Edition, (c) 2011 Pearson Education, Inc. All rights reserved. 0132130807
Course Table Tuples/ Rows
courseId 11111 11112 11113 11114 11115 11116 11117 11118
subjectId CSCI CSCI CSCI CSCI MATH MATH EDUC ITEC
courseNumber 1301 1302 3720 4750 2750 3750 1111 1344
Liang, Introduction to Java Programming, Eighth Edition, (c) 2011 Pearson Education, Inc. All rights reserved. 0132130807
6
Course Table
Relation/Table Name Columns/Attributes
Chapter 37 Java Database Programming
Liang, Introduction to Java Programming, Eighth Edition, (c) 2011 Pearson Education, Inc. All rights reserved. 0132130807
Application Programs System Users Database Management System (DBMS)
e.g., Access, MySQL, Oracle, and MS SQL Server
database
Liang, Introduction to Java Programming, Eighth Edition, (c) 2011 Pearson Education, Inc. All rights reserved. 0132130807
9
Liang, Introduction to Java Programming, Eighth Edition, (c) 2011 Pearson Education, Inc. All rights reserved. 0132130807
Table vs. File
NOTE: A table or a relation is not same as a file. Most of the relational database systems store multiple tables in a file.