package net.wellho;
import java.sql.*;

/* Compiling and testing this class

Test it stand alone, even if the ultimate use is within a JSP or servlet
(something about walking before running ...)

[root@iford classes]# javac net/wellho/Book.java
[root@iford classes]# java net.wellho.Book
java.sql.SQLException: Unable to connect to any hosts due to exception: java.net.ConnectException: Connection refused

--> MySQL server was not running ;-)

[root@iford classes]# java net.wellho.Book
David Flanagan
[root@iford classes]#

*/

public class Book {

        String Isbn;

        public Book () {
                Isbn = null;
                }

        public void setIsbn(String val) {
                Isbn = val;
                }

        public String getAuthor() {
                String Wanted = "author(s) not entered in our database";
                if (Isbn == null) return "Not set";

                try { // Can we connect to database and get a record back?
                        Class.forName("org.gjt.mm.mysql.Driver").newInstance();

                        // Use a "pseudoURL ... use oci10 for Oracle, etc
                        // Put in host (port optional), database, user and password

                        Connection books = DriverManager.getConnection
                        ("jdbc:mysql://192.168.200.199/wellho?user=trainee&password=abc123");

                        // Run the query
                        Statement s = books.createStatement();
                        ResultSet r = s.executeQuery
                        ("Select authorfull from books where isbn = \""+Isbn+"\"");

                        // Step through the result set rather like reading a file line by line
                        while (r.next()) {
                                Wanted = r.getString("authorfull");
                        }

                } catch (Exception e) { // Had ISBN but DB failed - return excuse
                        return e.toString();
                }
                return Wanted;
        }

public static void main (String [] args) {
        Book Desk = new Book();
        Desk.setIsbn("0-596-00283-1");
        String By = Desk.getAuthor();
        System.out.println(By);
        }

}