JDBC API Tutorial and Reference


Book Description

bull; A comprehensive tutorial AND useful rufescence in one volume bull; Includes multiple explanations and examples for the new features of the JDBC 3.0 specification bull; Written by the JDBC 3.0 architects, Maydene Fisher, Jon Ellis and Jonathan Bruce




Expert Oracle JDBC Programming


Book Description

* First book on the market that covers building high-performance Java applications on the Oracle database—using the latest versions of both the Oracle database (10g) and the JDBC API (3.0). * Promotes and explains an "anti black box" approach to Oracle development complete with benchmark code) that will allow developers to write highly efficient, high performance Oracle JDBC applications. * A new book from the prestigious OakTable Press, which Apress will be strongly promoting and supporting throughout 2004.




Java Programming with Oracle JDBC


Book Description

JDBC is the key Java technology for relational database access. Oracle is arguably the most widely used relational database platform in the world. In this book, Donald Bales brings these two technologies together, and shows you how to leverage the full power of Oracle's implementation of JDBC. You begin by learning the all-important mysteries of establishing database connections. This can be one of the most frustrating areas for programmers new to JDBC, and Donald covers it well with detailed information and examples showing how to make database connections from applications, applets, Servlets, and even from Java programs running within the database itself. Next comes thorough coverage of JDBC's relational SQL features. You'll learn how to issue SQL statements and get results back from the database, how to read and write data from large, streaming data types such as BLOBs, CLOBs, and BFILEs, and you'll learn how to interface with Oracle's other built-in programming language, PL/SQL. If you're taking advantage of the Oracle's relatively new ability to create object tables and column objects based on user-defined datatypes, you'll be pleased with Don's thorough treatment of this subject. Don shows you how to use JPublisher and JDBC to work seamlessly with Oracle database objects from within Java programs. You'll also learn how to access nested tables and arrays using JDBC. Donald concludes the book with a discussion of transaction management, locking, concurrency, and performance--topics that every professional JDBC programmer must be familiar with. If you write Java programs to run against an Oracle database, this book is a must-have.




JDBC


Book Description

1 -- Introduction to JDBC -- 2 -- Presenting Information to Users -- 3 -- Querying the Database -- 4 -- Updating the Database -- 5 -- Advanced JDBC Topics -- 6 -- An eCommerce Example -- 7 -- How to Stay Current with JDBC -- 8 -- Appendix.




Easy Learning JDBC + MySQL


Book Description

The complexity of life, because they do not understand to simplify the complex, to simplify the complexity, simple is the beginning of wisdom. From the essence of practice, to briefly explain the concept, and vividly cultivate programming interest, this book easy and quickly learn JDBC + MySQL.1. JDBC connect MySQL about Add Delete Update Research2. JDBC Precompiled CRUD3. JDBC Tool DBUtil4. DBUtil User CRUD5. DBUtil UserDAO CRUD6. DBUtil UserDAO Paging Query7. JDBC Reflections Any Object8. JDBC Transaction9. JDBC Save and Export Text File10. JDBC Save and Export Picture11. JDBC Call Stored Procedure Add User12. JDBC Call Stored Procedure Update User13. JDBC Call Stored Procedure Delete User14. JDBC Call Stored Procedure Query User15. JDBC Call Stored Procedure Return Parameter




Oracle Database Programming using Java and Web Services


Book Description

The traditional division of labor between the database (which only stores and manages SQL and XML data for fast, easy data search and retrieval) and the application server (which runs application or business logic, and presentation logic) is obsolete. Although the books primary focus is on programming the Oracle Database, the concepts and techniques provided apply to most RDBMS that support Java including Oracle, DB2, Sybase, MySQL, and PostgreSQL. This is the first book to cover new Java, JDBC, SQLJ, JPublisher and Web Services features in Oracle Database 10g Release 2 (the coverage starts with Oracle 9i Release 2). This book is a must-read for database developers audience (DBAs, database applications developers, data architects), Java developers (JDBC, SQLJ, J2EE, and OR Mapping frameworks), and to the emerging Web Services assemblers. - Describes pragmatic solutions, advanced database applications, as well as provision of a wealth of code samples. - Addresses programming models which run within the database as well as programming models which run in middle-tier or client-tier against the database. - Discusses languages for stored procedures: when to use proprietary languages such as PL/SQL and when to use standard languages such as Java; also running non-Java scripting languages in the database. - Describes the Java runtime in the Oracle database 10g (i.e., OracleJVM), its architecture, memory management, security management, threading, Java execution, the Native Compiler (i.e., NCOMP), how to make Java known to SQL and PL/SQL, data types mapping, how to call-out to external Web components, EJB components, ERP frameworks, and external databases. - Describes JDBC programming and the new Oracle JDBC 10g features, its advanced connection services (pooling, failover, load-balancing, and the fast database event notification mechanism) for clustered databases (RAC) in Grid environments. - Describes SQLJ programming and the latest Oracle SQLJ 10g features , contrasting it with JDBC. - Describes the latest Database Web services features, Web services concepts and Services Oriented Architecture (SOA) for DBA, the database as Web services provider and the database as Web services consumer. - Abridged coverage of JPublisher 10g, a versatile complement to JDBC, SQLJ and Database Web Services.




JDBC for Oracle - Herong's Tutorial Examples


Book Description

This JDBC tutorial book is a collection of notes and sample codes written by the author while he was learning JDBC technology himself. Topics include installing JDK and Oracle server; using Oracle JDBC driver; database connection URLs; introduction to Result Set, Meta Data, Prepared Statement, CLOB, and BLOB. Updated in 2024 (Version v3.13) with minor changes. For latest updates and free sample chapters, visit https://www.herongyang.com/JDBC-Oracle.




Oracle9i JDBC Programming


Book Description

This is the only definitive guide to JDBC programming with Oracle8i and 9i. JDBC is the de facto method for accessing an Oracle database from Java.




JDBC Metadata, MySQL, and Oracle Recipes


Book Description

First book to market on metadata specific recipes related to JDBC and its use with MySQL and Oracle, databases standard to Java. Compliant with the new Java EE 5. Provides cut and paste code templates that can be immediately customized and applied in each developer’s application development.




Database Programming with JDBC and Java


Book Description

Java and databases make a powerful combination. Getting the two sides to work together, however, takes some effort--largely because Java deals in objects while most databases do not. This book describes the standard Java interfaces that make portable object-oriented access to relational databases possible and offers a robust model for writing applications that are easy to maintain. It introduces the JDBC and RMI packages and uses them to develop three-tier applications (applications divided into a user interface, an object-oriented logic component, and an information store). The book begins with a quick overview of SQL for developers who may be asked to handle a database for the first time. It then explains how to issue database queries and updates through SQL and JDBC. It also covers the use of stored procedures and other measures to improve efficiency, where these are available. But the book's key contribution is a set of patterns that let developers isolate critical tasks like object creation, information storage and retrieval, and the committing or aborting of transactions. The second edition includes more basics of JDBC and SQL, with more examples, and a deeper discussion about the architecture of a robust, maintainable database application. The second edition also explains the relationship between JDBC and Enterprise JavaBeans.