Posts

Showing posts with the label jdbc

Testing Goes On: JDBC

JDBC a Go-Go Today I tested Awesome Sauce Java with JDBC.  It works well! There are opportunities to develop new tools and functions for the purpose of making the install, configuration, and use easier, but I'm always happy to find another feature works.  Not that it isn't supposed to.  It means that I can validate, test, then learn how to extend the feature. Here's the code I used to connect to the Derby database in NetBeans: (setf dbp (new Properties)) (put dbp "user" "app") (put dbp "password" "app") (setf cs (new String "jdbc:derby://localhost:1527/sample;create=true")) (setf conn (DriverManager.getConnection cs dbp)) (setf stmt (createStatement conn)) (setf rs (executeQuery stmt "SELECT * from CUSTOMER")) (while (next rs)    (println (getString rs 4))) ; print the company name. Results in the following detail printing: "New Enterprises" "Wren Computers" "Sma...