MySQL and Java Developer's Guide
May 7th, 2010 by CGI & PHP.com
Product Description
* Shows Java developers everything they need to know to build Java database applications with MySQL.
* Takes a hands-on, code-intensive approach in which readers will learn how to build a sophisticated Web database management application.
* Begins with a review of the fundamentals of MySQL.
* Explains using Java's JDBC with MySQL, as well as servlet and JSP programming with MySQL.
* Provides a code-rich tutorial on how to build the sample… More >>
MySQL and Java Developer's Guide
Popularity: 25% [?]
SQL for MySQL Developers: A Comprehensive Tutorial and Reference
MySQL 5.0 Certification Study Guide
Effective Java: Programming Language Guide
Functional Programming for Java Developers: Tools for Better Concurrency, Abstraction, and Agility
Java: A Beginner's Guide, 4th Ed.
Java Pocket Guide
May 7th, 2010 at 8:47 am
I'd never done anything with databases, and SQL was an almost total mystery. So when I decided it was time to "modernize" a tracking tool I'd developed for my team using Perl and a simple flat file "database", I knew it was the opportunity I'd been waiting for to learn something useful and new: database programming. And while there are a lot of ways to develop a database application, I've always kinda wanted to learn Java.
A search for references on databases and Java didn't turn up a lot of hits that looked useful, and this book was about the only serious or substantial work focusing on my need. I bought it with some trepidation; but found it straightforward, approachable, and reasonably comprehensive. Armed with this book plus the MySQL PDF manual and Sun's online Java reference for additional details, I forged ahead and in a couple of weeks of "spare time" programming, I've designed a reasonable and usable database schema, implemented it, and populated my database with data recovered from various project archives. My tool's "not all there" yet, but I expect this book will remain relevant as I expand my humble command line tool into a servlet and GUI… it has good simple examples of all that, too.
I wouldn't lay claims to being an expert database or Java programmer, but it's pretty cool to be able to say this book helped me become competent in just a few weeks of part-time development.
Rating: 5 / 5
May 7th, 2010 at 9:09 am
This book is fantastic, it teach step by step.
I hope you can buy this book if you are a beginner in MySQL but if you have some level in java languaje.
————————————————————-
THIS ARE THE CHAPTER
1. AN OVERVIEW OF MYSQL
2. JDBC AND CONNECTOR/J
3. WORKING WITH MYSQL SQL
4. INSTALLING MYSQL, JAVA, AND CONNECTOR/J
5. USING JDBC WITH JAVA APPLICATIONS AND APPLETS
6. ACHIEVING ADVANCED CONNECTOR/J FUNCTIONALITY WITH SERVLETS
7. MYSQL TYPE MAPPING
8. TRANSACTIONS AND TABLE LOCKING WITH CONNECTOR/J
9. USING METADATA
10.CONNECTION POOLING WITH CONNECTOR/J
11.EJBS WITH MYSQL
12.BUILDING A GENERAL INTERFACE FOR MYSQL
13.DATABASE ADMINISTRATION
14.PERFORMANCE AND TUNING
APENDIX A -> MYSQL DEVELOPMENT AND TESTE ENVIRONMENTS
APENDIX B -> DATABASES AND TABLES
APENDIX C -> THE JDBC API AND CONNECTOR/J
APENDIX D -> MYSQL FUNCTIONS AND OPERATORS
APENDIX E -> CONNECTOR/J LATE-BREAKING ADDITIONS
——————————————————
EXCELLENT BOOK.
THANK YOU MARK MATTHEWS
JIM COLE
JOSEPH D. GRADECKI
Rating: 5 / 5
May 7th, 2010 at 11:44 am
If you need to interface Java with MySQL then this is the book to get. As a developer, I like examples and there are examples along with code to study. The fingerprint example shows a great combination of using both web and Java application connections to the database.
The book is up-to-date as much as it can be with the latest MySQL Connector/J beta. I would have liked to see more work arounds for featured not handled in MySQL but I guess that's really a MySQL issue and not necessarily the connection between MySQL and Java.
Rating: 5 / 5
May 7th, 2010 at 12:11 pm
Rarely have I been so irritated with a book that I felt compelled to write a review. I feel that the 5-star rating that the book had when I bought is undeserved. It's replete with errors. Even the URL for the companion website is incorrect. I tracked down the companion website with the help of Google and downloaded the samples, but of course, they wouldn't compile. The authors admit to the challenge of timing the release of book with the release of the Connector/J driver. Too difficult to allow for decent quality control it would appear. Detailed examples can be very helpful, but not when the details are wrong. That just makes for massive frustration.
Rating: 2 / 5
May 7th, 2010 at 1:47 pm
I'm currently enrolled in an Undergraduate Course in Relational Database Systems. I was getting tired of reading incomplete tutorials around the internet on how to use JDBC and MySQL effectively so I bought this book bought last week on Amazon Marketplace. It was ridiculously cheap (About $3), but after seeing how useful it is, I definitely would've paid the regular price. One of the authors, Mark Matthews, actually wrote the Connector/J driver for MySql!
-This book is a tutorial, NOT a reference.
-All of the code and examples used in the book are available online so you don't need to waste hours retyping code to get the feel of it.
-The book assumes you are somewhat competent in Java and goes into applets, beans, and EJBs, but I think someone who knows C++ and really understands OOP will be able to manage alright.
Good luck!
Rating: 5 / 5