Muutke küpsiste eelistusi

Java Database Programming with Jdbc 2nd ed. [CD-ROM]

  • Formaat: CD-ROM, 491 pages, kõrgus x laius: 241x190 mm, kaal: 930 g, illustrations ; 24 cm. +
  • Ilmumisaeg: 01-Aug-1997
  • Kirjastus: Coriolis Group,U.S.
  • ISBN-10: 1576101592
  • ISBN-13: 9781576101599
Teised raamatud teemal:
  • Formaat: CD-ROM, 491 pages, kõrgus x laius: 241x190 mm, kaal: 930 g, illustrations ; 24 cm. +
  • Ilmumisaeg: 01-Aug-1997
  • Kirjastus: Coriolis Group,U.S.
  • ISBN-10: 1576101592
  • ISBN-13: 9781576101599
Teised raamatud teemal:
INTRODUCTION XV
PART 1 GETTING STARTED WITH JDBC 1(54)
CHAPTER 1 JDBC DATABASES THE JAVA WAY
3(6)
What Is The JDBC?
4(1)
The JDBC Structure
5(2)
ODBC's Part In The JDBC
7(1)
Summary
8(1)
CHAPTER 2 SQL 101: AN INTRODUCTION TO SQL
9(16)
The Relational Model And SQL
10(4)
Understanding The Basics
10(1)
Putting It Into Perspective: Schema And Catalog
11(1)
Introducing Keys
12(2)
Using Multiple Tables And Foreign Keys
14(1)
Data Definition Language
14(4)
Declaring Domains
15(1)
Performing Checks
16(1)
Creating Tables
16(2)
Manipulating Tables
18(1)
Data Maintenance Language
18(2)
Data Query Language
20(3)
Coming Up Next
23(2)
CHAPTER 3 USING JDBC DRIVERS
25(12)
Quick Start Guide
26(2)
Installing java.sql.*
28(2)
Registering And Calling JDBC Drivers
30(2)
The sql.drivers Property
31(1)
There's Always A Class For A Name
31(1)
Just Do It
32(1)
JDBC URL And The Connection
32(1)
Using ODBC Drivers
33(3)
Installing The JDBC-ODBC Bridge
33(1)
Setting Up ODBC Drivers
34(1)
Coming Up Next
36(1)
CHAPTER 4 THE INTERACTIVE SQL QUERY APPLET
37(18)
Your First JDBC Applet
37(6)
The Blueprint
38(5)
Getting a Handle on the JDBC Essentials: The Complete Applet Source Code
43(9)
The Look Of The Applet
43(4)
Handling Events
47(1)
Opening The Connection
48(1)
No Guts, No Glory: Executing Queries And Processing Results
49(2)
Wrapping It Up
51(1)
The HTML File That Calls The Applet
52(1)
The Final Product
52(2)
Coming Up Next
54(1)
PART 2 JDBC DRIVERS 55(118)
CHAPTER 5 MIDDLEWARE
57(18)
Connectivity Issues Involved With Database Access
58(2)
Advantages Of Middleware
59(1)
Disadvantages Of Middleware
60(1)
The Application Server: A Complete Example With Code
60(8)
The Client: A Complete Example With Code
68(5)
Coming Up Next
73(2)
CHAPTER 6 CHOOSING THE RIGHT JDBC DRIVER
75(8)
Driver Categories
75(2)
Type 1
75(1)
Type 2
76(1)
Type 3
76(1)
Type 4
76(1)
Assessing Differences Between Types
77(3)
100 Percent Java Means Portability
77(1)
Middleware Means Flexibility
78(1)
Direct Connection Means Speed
79(1)
Type 1: What Is It Good For?
80(1)
Moving On
80(1)
Coming Up Next
81(2)
CHAPTER 7 WRITING DATABASE DRIVERS
83(66)
The JDBC Driver Project: SimpleText
83(3)
Simple Text SQL Grammar
84(1)
Simple Text File Format
85(1)
The DriverManager
86(1)
JDBC Exception Types
86(5)
JDBC Data Types
91(3)
Character Data: CHAR, VARCHAR, And LONGVARCHAR
92(1)
Exact Numeric Data: NUMERIC And DECIMAL
92(1)
Binary Data: BINARY, VARBINARY, And LONGVARBINARY
92(1)
Boolean Data: BIT
92(1)
Integer Data: TINYINT, SMALLINT, INTEGER, And BIGINT
93(1)
Floating-Point Data: REAL, FLOAT, And DOUBLE
93(1)
Time Data: DATE, TIME, And TIMESTAMP
93(1)
New Data Classes
94(3)
BigDecimal
94(1)
Date
94(1)
Time
95(1)
Timestamp
96(1)
Native Drivers: You're Not From Around Here, Are Ya?
97(6)
Implementing Interfaces
103(2)
Tracing
105(4)
Turning On Tracing
106(1)
Writing Tracing Information
107(1)
Checking For Tracing
107(2)
Data Coercion
109(5)
Escape Clauses
114(3)
Date, Time, And Timestamp
115(1)
Scalar Functions
115(1)
LIKE Predicate Escape Characters
116(1)
Outer Joins
117(1)
Procedures
117(1)
The JDBC Interfaces
117(31)
Driver
118(8)
Connection
126(4)
DatabaseMetaData
130(7)
Statement
137(3)
PreparedStatement
140(4)
ResultSet
144(2)
ResultSetMetaData
148(1)
Coming Up Next
148(1)
CHAPTER 8 ACCESSING ODBC SERVICES
149(24)
Bridge Requirements
149(1)
The Bridge Is Great, But
150(2)
Using The Bridge From An Applet
152(1)
The ODBC URL
153(1)
JDBC To ODBC Calls: A Roadmap
154(17)
Coming Up Next
171(2)
PART 3 MISCELLANEOUS 173(22)
CHAPTER 9 SQL DATA TYPES IN JAVA
175(8)
Mapping SQL Data To Java
175(3)
ResultSetMetaData
178(1)
Understanding The Object Relation Model
179(1)
Mapping A Table Into A Java Object
179(1)
Object Databases And The JDBC
180(1)
Coming Up Next
181(2)
CHAPTER 10 JAVA AND DATABASE SECURITY
183(6)
Database Server Security
183(4)
Packets On The Network
183(1)
Web Server CGI And Servlet holes
184(1)
Finding A Solution
185(1)
Applet Security: Can I Trust You?
185(1)
The Applet Security Manager
186(1)
I'm A Certified Applet
186(1)
Coming Up Next
187(2)
CHAPTER 11 DEPLOYING DATA-AWARE APPLETS
189(6)
Internet Issues
189(2)
Middleware--A Basic Solution
190(1)
Proxy
191(1)
Speed
191(1)
Intranet Issues
191(2)
Connect To The Database Directly?
191(1)
"Pushing" Applets And JDBC Drivers
192(1)
Coming Up Next
193(2)
PART 4 PROJECTS WITH COMPLETE CODE 195(108)
CHAPTER 12 THE MULTIMEDIA JDBC APPLICATION: ICONSTORE
197(26)
IconStore Requirements
197(2)
Building the Database
199(4)
Application Essentials
203(17)
Writing The main Method
203(2)
Establishing The Database Connection
205(1)
Creating the Menu
206(2)
Creating The Lists
208(5)
Handling Events
213(6)
Saving The Image
219(1)
Coming Up Next
220(3)
CHAPTER 13 WORKING WITH QUERY RESULTS
223(14)
A Basic Java Object For Storing Results
224(3)
Showing The Results
226(1)
Charting Your Data
227(9)
Coming Up Next
236(1)
CHAPTER 14 SERVER-SIDE DATABASES: SERVLETS AND JDBC
237(26)
Servlet Architecture
237(4)
The Java Web Server
238(1)
Extensible Servlets
238(2)
Thread-Based Forking
240(1)
Calling Your Own Servlets
240(1)
Exploring The Servlet API
241(3)
JDBC And Servlets
244(17)
The News Wire Project
244(1)
Database Tables
245(2)
Getting From Data From A Servlet
247(4)
Creating A Connection
251(1)
Reading From The Database
252(1)
Posting To The Database
253(1)
TODO
254(7)
Coming Up Next
261(2)
CHAPTER 15 BUILDING DATA-AWARE COMPONENTS USING JAVA BEANS
263(40)
Java Beans: What's All The Hot Air About?
263(1)
The Beans Development Kit (BDK)
264(1)
The BeanBox: A Test Drive
265(1)
Juggling Beans
265(5)
Writing Your First JavaBean: The TrafficSignal
270(5)
Building The TrafficSignal JAR File
273(2)
The Java Beans Project: POSDatabase
275(25)
Building The Database
278(7)
Writing The POSDatabase Bean
285(4)
Putting It All Together
289(7)
Adding More: Price Inquiry
296(2)
Adding Even More: Images
298(2)
Coming Up Next
300(3)
PART 5 REFERENCE 303(42)
CHAPTER 16 THE JDBC API
305(40)
Classes
305(6)
public class Date
305(1)
Public class DriverManager
306(2)
public class DriverPropertyInfo
308(1)
public class Time
308(1)
public class TimeStamp
309(1)
public class Types
310(1)
Interfaces
311(31)
public interface CallableStatement
311(2)
public interface Connection
313(2)
public interface DatabaseMetaData
315(16)
public interface Driver
331(1)
public interface PreparedStatement
332(2)
public interface ResultSet
334(4)
public interface ResultSetMetaData
338(2)
public interface Statement
340(2)
Exceptions
342(3)
public class Data Truncation
342(1)
public class SQLException
342(1)
public class SQLWarning
343(2)
APPENDIX A JAVA LANGUAGE FUNDAMENTALS 345(34)
APPENDIX B SIMPLETEXT JDBC DRIVER SOURCE CODE 379(106)
INDEX 485