This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
... Statement stat = conn.createStatement(); String query = "CREATE TABLE Table1(Member ID No INTEGER NOT NULL PRIMARY KEY, Surname VARCHAR(30), Other Names VARCHAR(30), Date of Entry DATE)"; int result = stat.executeUpdate(query);
query = "INSERT INTO Table1 (Member ID No, Surname, Other Names, Date of Entry) VALUES (001, 'Ojambati', 'Oluwafemi Stephen', '2008-10-15')"; result = stat.executeUpdate(query);
When I tried to run it An exception was caught, this message was displayed