Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Archive
Java
Overwriting a Access Database using JDBC
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
[QUOTE="Alan Gutierrez, post: 600131"] Okay, Tushar. You are not updating any rows if rs is zero. You're probably running your application for the first time. No rows, no update. Have you tryed playing around with SQL in Access, or using one of the many JDBC shell utitities. SQL is really easy stuff. -- create table foo -- CREATE TABLE foo (bar integer, baz varchar(32)); -- delete all rows in foo -- DELETE FROM foo; -- Add a row to foo -- INSERT INTO foo (bar, baz) VALUES (1, "fred"); -- Update foo -- UPDATE foo set baz = "barney" WHERE bar = 1; -- get rid table foo entrely -- DROP TABLE foo; You'll generally find that you have to write update and insert statements for all the data in your database. It will feel redundant until you get used to it. As someone else noted, optional in the documentation means optional the same way that import declarations are optional in java. If you don't put them there, that's fine, but you can use any classes external to the package. Make sense? You really ought to slow down and read an SQL primer. If you are really in a hurry, just serialize your objects to a file for now. Good luck. [/QUOTE]
Verification
Post reply
Forums
Archive
Archive
Java
Overwriting a Access Database using JDBC
Top