GEORGE REESE

Assuming a familiarity with SQL and at least one Java enterprise API, this book describes the different approaches Java provides for database programming, assesses what approaches fit which problems, and recommends best practices for each model. The author discusses data architecture, transaction management, EJB container-managed persistence, EJB bean-managed persistence, and Java data objects persistence.

Covering version 4.0, offers information about the database management software's statements, functions, tools, and syntax.If you use MySQL, you know why it's the world's most popular open source database: small, fast, and powerful, and so rich in features that no administrator or programmer can stay familiar with all of them. There are always some little-known commands and clauses that could help you become more efficient in your work if you could just keep them in mind. The problem is, you don't always have time to stop and thumb through an exhaustive reference when you're hard at work. If you need a quick reminder, the MySQL Pocket Reference can lead you straight to the answer you need to know to get the job done. Easy to take and use anywhere, this little book provides instant reminders on how to use important MySQL functions in conjunction with key parts of the LAMP open source infrastructure. A complete reference to the MySQL version of SQL, this pocket guide also serves as a convenient companion to our large, in-depth volume, Managing and Using MySQL. The book covers installation of MySQL and includes a description of SQL commands, data types, operators, and functions. In this small book, you get a handy reference to the enormous feature set of MySQL, the dominant database in the open source world. O'Reilly's Pocket References have become a favorite among programmers everywhere. By providing important details in a succinct, well-organized format, these pocket-sized books deliver just what you need to complete the task at hand. When you've reached a sticking point in your work and need to get to a solution quickly, the new MySQL Pocket Reference is the book you'll want to have.

El acceso a las bases de datos es uno de los principales retos de la mayoría de las empresas y organizaciones, pero para conseguirlo es necesario diseñar la aplicaciones corporativas específicas para ese fin.El objeto basico de este libro es conseguir que el lector pueda escribir aplicaciones que accedan a bases de datos relacionales sin tener en cuenta la base de datos particular que vaya a usar. Si ya ha programado alguna vez con mas de una API de bases de datos, apreciara este aspecto de Java.Esta obra se divide en tres partes muy diferentes:La primera se centra en la API JDBC, mostrandole la programacion corporativa y una introduccion a las bases de datos relacionales y SQL.La segunda parte se centra en la practica, aplicando todo lo aprendido en la parte anterior al mundo real de la programacion con bases de datos, describiendo aspectos que muy probablemente va a encontrar al construir sus propias aplicaciones para bases de datos.Por ultimo, la parte final es una referencia de JDBC y los paquetes opcionales de API.El libro se va desarrollando con numerosos ejemplos y comentarios realizados con javadoc. de forma que pueda generar paginas Web automaticamente, ofreciendo de esta manera una buena practica de programacion y una mayor legibilidad de los ejemplos del libro.