Beginning Java Databases
What does this book cover?
- Using the JDBC API to build database-driven Java applications
- Introduction to new JDBC 3.0 features
- SQL and relational database design
- Object-relational mapping frameworks and techniques
- Debugging your application and logging its activities
- Applying Java and JDBC skills in a J2EE environment
- Integrating XML into you Java database applications
Book overview
Java has evolved into a robust, high performance programming language that is well suited to a range of different environments, be it on a middle tier Application Server or a client browser. Regardless of the architecture of your application you are using, it will almost certainly need to make use of data that is stored in some form of database. Relational databases are the data store of choice in the vast majority of businesses, and have also evolved enormously over the recent years, into powerful and feature-rich data management systems.
This book aims to teach you how to use these two powerful technologies to build successful Java database applications. You will find out how relational databases work and how you can use them in your Java programs, through the JDBC interface. You will see how to apply your new skills in an enterprise environment and by the end will be building sophisticated web-enabled Java database applications that incorporate other technologies, such as XML.
Who is this book for?
This book is ideal for the programmer who has a reasonable grasp of the fundamentals of the Java language, and is now looking to apply and improve these skills in building database-driven Java applications. If you are relatively new to Java, then the explanations in the text should allow you to grasp all of the fundamental issues discussed, especially if you are migrating from another language such as C or C++.
Summary of Contents
| Introduction | | 1 |
| Setting Up | Your Java Environment | 9 |
| Chapter 1: | Relational Databases and Java | 15 |
| Chapter 2: | Basic JDBC Techniques | 35 |
| Chapter 3: | SQL Queries and Data Manipulation | 73 |
| Chapter 4: | Creating Tables and Modifying Data with SQL | 131 |
| Chapter 5: | Relational Database Design Concepts | 149 |
| Chapter 6: | Case Study: Designing the Music Store Database | 187 |
| Chapter 7: | Overview of JDBC Application Development | 223 |
| Chapter 8: | Connecting to a Database | 259 |
| Chapter 9: | Using Statements and ResultSets | 295 |
| Chapter 10: | Using Meta Data | 333 |
| Chapter 11: | Using Rowsets | 353 |
| Chapter 12: | Prepared Statements | 377 |
| Chapter 13: | Callable Statements and Stored Procedures | 419 |
| Chapter 14: | Transactions | 449 |
| Chapter 15: | Object-Relational Mapping Concepts | 489 |
| Chapter 16: | Using an Object-Relational Mapping Framework | 517 |
| Chapter 17: | Debugging and Logging | 591 |
| Chapter 18: | JDBC DataSources | 631 |
| Chapter 19: | J2EE and Java Database Applications | 665 |
| Chapter 20: | Exporting Relational Data to XML | 719 |
| Chapter 21: | Using XSLT | 759 |
| Chapter 22: | The Model-View-Controller Framework | 801 |
| Appendix A: | Connecting to the Music Store Database | 875 |
| Appendix B: | Installing the JBoss Application Server and Tomcat Web Container | 897 |
| Appendix C: | XML Primer | 913 |
| Appendix D: | Support, Errata, and p2p.wrox.com | 957 |
| Index | | 963 |
New on the Java Boutique:
New Review:
Time Management Made Easy with the Quartz Enterprise Job Scheduler
Why not just use the Java timer API? This open source scheduling
API boasts simplicity, ease-of-integration, a well-rounded feature
set, and it's free!
New Applet:
Reverse Complement
Reverse Complement is a simple applet that converts DNA or RNA
sequences into three useful formats.
Elsewhere on internet.com:
WebDeveloper Java
Lots of Java information on webdeveloper.com
WDVL Java
Thorough Java resource at the Web Developer's Virtual Library.
ScriptSearch Java
Hundreds of free Java code files to download.
jGuru: Your View of the Java Universe
Customizable portal with online training, FAQs, regular news updates, and tutorials.
| 
