Database Programming with JDBC and Java

Database Programming with JDBC and Java
Author: George Reese
Publisher: "O'Reilly Media, Inc."
Total Pages: 356
Release: 2000
Genre: Computers
ISBN: 9781565926165

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.

Practical Database Programming with Java

Practical Database Programming with Java
Author: Ying Bai
Publisher: John Wiley & Sons
Total Pages: 1079
Release: 2011-09-09
Genre: Computers
ISBN: 1118104692

Covers fundamental and advanced Java database programming techniques for beginning and experienced readers This book covers the practical considerations and applications in database programming using Java NetBeans IDE, JavaServer Pages, JavaServer Faces, and Java Beans, and comes complete with authentic examples and detailed explanations. Two data-action methods are developed and presented in this important resource. With Java Persistence API and plug-in Tools, readers are directed step by step through the entire database programming development process and will be able to design and build professional data-action projects with a few lines of code in mere minutes. The second method, runtime object, allows readers to design and build more sophisticated and practical Java database applications. Advanced and updated Java database programming techniques such as Java Enterprise Edition development kits, Enterprise Java Beans, JavaServer Pages, JavaServer Faces, Java RowSet Object, and Java Updatable ResultSet are also discussed and implemented with numerous example projects. Ideal for classroom and professional training use, this text also features: A detailed introduction to NetBeans Integrated Development Environment Java web-based database programming techniques (web applications and web services) More than thirty detailed, real-life sample projects analyzed via line-by-line illustrations Problems and solutions for each chapter A wealth of supplemental material available for download from the book's ftp site, including PowerPoint slides, solution manual, JSP pages, sample image files, and sample databases Coverage of two popular database systems: SQL Server 2008 and Oracle This book provides undergraduate and graduate students as well as database programmers and software engineers with the necessary tools to handle the database programming issues in the Java NetBeans environment. To obtain instructor materials please send an email to: [email protected]

The Complete Guide to Java Database Programming

The Complete Guide to Java Database Programming
Author: Matthew D. Siple
Publisher: McGraw-Hill Companies
Total Pages: 356
Release: 1998
Genre: Computers
ISBN:

Presenting the complete, in-depth guide to JDBC (Java Database Connectivity)--the key to creating a new generation of data-rich Java applications, and the new standard that database vendors from Oracle to Sybase are lining up to support. North explains the how-to's of JDBC and covers its relationship with ODBC. The CD contains sample code written to the JDBC and ODBC APIs.

Java Database Programming

Java Database Programming
Author: Brian Jepson
Publisher: Wiley
Total Pages: 500
Release: 1996-11-22
Genre: Computers
ISBN: 9780471165187

A complete guide to mastering the next generation of database programming technologies Java Database Programming teaches you the critical new Java database technologies and tools, including Sun Microsystems' Java Database Connectivity (JDBC) standard. You'll learn practical, step-by-step techniques with which you can harness the Java programming language. You will also learn how to create dynamic database applications and applets in both Internet and Intranet environments. Java Database Programming explains: How Java programs access online databases Integrating Java with networked database technologies Programming with JDBC How to develop JDBC drivers Java database tools and code libraries Java Database Programming is the innovative and hands-on book that will enable you to apply Java to real-world Internet and Intranet development. On the Java Database Programming supporting Web site, you'll find: tinySQL, a generic and extendable SQL engine written in Java The tinySQL JDBC driver Customizable Java database code Visit our Web site at: http://www.wiley.com/compbooks/

Java Database Programming

Java Database Programming
Author: Alan R. Williamson
Publisher: Prentice Hall PTR
Total Pages: 0
Release: 1997
Genre: Database design
ISBN: 9780137379170

Aimed at the database developer who needs to learn how to optimize their skills for the Web, this text and CD covers JDBC, servlets, database front-end design, security, multi-threading and client server.

Java Database Programming with JDBC

Java Database Programming with JDBC
Author: Pratik Patel
Publisher:
Total Pages: 500
Release: 1996
Genre: Computers
ISBN: 9781576100561

This text presents the JDBC standard, Java's database connectivity environment, and provides information for using Java with JDBC for accessing databases. The manual is designed for users who are learning database programming for the Internet or company In

Java Database Best Practices

Java Database Best Practices
Author: George Reese
Publisher: "O'Reilly Media, Inc."
Total Pages: 305
Release: 2003-05-14
Genre: Computers
ISBN: 1449365620

When creating complex Java enterprise applications, do you spend a lot of time thumbing through a myriad of books and other resources searching for what you hope will be the API that's right for the project at hand?Java Database Best Practices rescues you from having to wade through books on each of the various APIs before figuring out which method to use! This comprehensive guide introduces each of the dominant APIs (Enterprise JavaBeans, Java Data Objects, the Java Database Connectivity API (JDBC) as well as other, lesser-known options), explores the methodology and design components that use those APIs, and then offers practices most appropriate for different types and makes of databases, as well as different types of applications.Java Database Practices also examines database design, from table and database architecture to normalization, and offers a number of best practices for handling these tasks as well. Learn how to move through the various forms of normalization, understand when to denormalize, and even get detailed instructions on optimizing your SQL queries to make the best use of your database structure. Through it all, this book focuses on practical application of these techniques, giving you information that can immediately be applied to your own enterprise projects.Enterprise applications in today's world are about data-- whether it be information about a product to buy, a user's credit card information, or the color that a customer prefers for their auto purchases. And just as data has grown in importance, the task of accessing that data has grown in complexity. Until now, you have been left on your own to determine which model best suits your application, and how best to use your chosen API. Java Database Practices is the one stop reference book to help you determine what's appropriate for your specific project at hand. Whether it's choosing between an alphabet soup of APIs and technologies--EJB, JDO, JDBC, SQL, RDBMS, OODBMS, and more on the horizon, this book is an indispensable resource you can't do without.

Java Programming with Oracle JDBC

Java Programming with Oracle JDBC
Author: Donald Bales
Publisher: "O'Reilly Media, Inc."
Total Pages: 500
Release: 2002
Genre: Business & Economics
ISBN: 9780596000882

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.

MySQL in a Nutshell

MySQL in a Nutshell
Author: Russell J.T. Dyer
Publisher: "O'Reilly Media, Inc."
Total Pages: 568
Release: 2008-04-15
Genre: Computers
ISBN: 1449379370

When you need to find the right SQL keyword or MySQL client command-line option right away, turn to this convenient reference, known for the same speed and flexibility as the system it covers so thoroughly. MySQL is packed with so many capabilities that the odds of remembering a particular function or statement at the right moment are pretty slim. With MySQL in a Nutshell, you get the details you need, day in and day out, in one concise and extremely well organized book. The new edition contains all the commands and programming information for version 5.1, including new features and language interfaces. It's ideal for anyone using MySQL, from novices who need to get up to speed to advanced users who want a handy reference. Like all O'Reilly Nutshell references, it's easy to use and highly authoritative, written by the editor of the MySQL Knowledge Base at MySQL AB, the creator and owner of MySQL. Inside, you'll find: A thorough reference to MySQL statements, functions, and administrative utilities Several tutorial chapters to help newcomers get started Programming language APIs for PHP, Perl, and C Brief tutorials at the beginning of each API chapter to help anyone, regardless of experience level, understand and master unfamiliar territory New chapters on replication, triggers, and stored procedures Plenty of new examples of how MySQL is used in practice Useful tips to help you get through the most difficult subjects Whether you employ MySQL in a mission-critical, heavy-use environment or for applications that are more modest, this book puts a wealth of easy-to-find information at your fingertips, saving you hundreds of hours of trial and error and tedious online searching. If you're ready to take advantage of everything MySQL has to offer, MySQL in a Nutshell has precisely what it takes.