Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.java.databases > #631
| Path | csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail |
|---|---|
| From | Kevin Nathan <knathan@project54.com> |
| Newsgroups | comp.lang.java.databases |
| Subject | Re: Local database library |
| Date | Sat, 5 Oct 2013 11:19:01 -0700 |
| Lines | 34 |
| Message-ID | <20131005111901.75595916@efreet.linux> (permalink) |
| References | <20131001135230.66af12f9@efreet.linux> <524b40ba$0$304$14726298@news.sunsite.dk> <20131001154157.7f37e588@efreet.linux> <524b6e8d$0$304$14726298@news.sunsite.dk> <20131002100935.0eacf609@efreet.linux> <l2htcj$j8p$1@dont-email.me> <20131004104829.4bd78e5b@efreet.linux> <l2pc3f$442$1@dont-email.me> |
| Mime-Version | 1.0 |
| Content-Type | text/plain; charset=US-ASCII |
| Content-Transfer-Encoding | 7bit |
| X-Trace | individual.net vQ43MleZzBOfL8eqWrgF7wkCtYVdg8EgrGLDAgZ2bMcyiCxA7Y |
| Cancel-Lock | sha1:8tqc9KpXLt7bj5fijVO/ES6ifOw= |
| X-Newsreader | Claws Mail 3.9.0 (GTK+ 2.24.18; i586-suse-linux-gnu) |
| X-Face | %/gp4MCQT=`#JS##?-]V9ksid6OSR@(wbF"bK6wSLO$u,%(N@X~bVhAD+\A_[gRhx*T6=fq "N_5H8.v[&;q0iw!s_wuL05B0xg#OYUkbn#@&U_]fL%o==~2sphc?*L+bicO!POJLG#p'N.]J0/p_w Z^(.kOB%Ob914-V>?GI; |
| Xref | csiph.com comp.lang.java.databases:631 |
Show key headers only | View raw
On Sat, 5 Oct 2013 15:43:43 +0000 (UTC) Martin Gregorie <martin@address-in-sig.invalid> wrote: >On Fri, 04 Oct 2013 10:48:29 -0700, Kevin Nathan wrote: > >> I hadn't thought of that. What I have started to do (and it's not yet >> working) is to create a "DBaccess" library under >> "net.companyname.connect" >> >The following summarises what I did for a small system that has non- >interactive CLI programs as well as a few GUI utilities that do >updates and run enquiries on the DB. > >I ended with a superclass containing the methods connect() and close() >to start and stop the database connection plus other methods to handle >common requirements such as reporting DB access failures. There's a >subclass for each program. The methods in these each encapsulate an >SQL transaction. Data is passed as arguments and the return value >indicates success or failure. Where a transaction fills a JTable a >reference to its Model is passed into the method, which can put all >the rows returned by the SQL query into the Model. > Sounds like just about what I need! I will look into doing it that way... -- Kevin Nathan (Arizona, USA) Linux is not a destination, it's a journey -- enjoy the trip! Linux 3.7.10-1.16-desktop 11:17am up 16 days 21:30, 14 users, load average: 0.80, 0.62, 0.61
Back to comp.lang.java.databases | Previous | Next — Previous in thread | Next in thread | Find similar
Local database library Kevin Nathan <knathan@project54.com> - 2013-10-01 13:52 -0700
Re: Local database library Arne Vajhøj <arne@vajhoej.dk> - 2013-10-01 17:38 -0400
Re: Local database library Kevin Nathan <knathan@project54.com> - 2013-10-01 15:41 -0700
Re: Local database library Arne Vajhøj <arne@vajhoej.dk> - 2013-10-01 20:53 -0400
Re: Local database library Kevin Nathan <knathan@project54.com> - 2013-10-02 10:09 -0700
Re: Local database library Martin Gregorie <martin@address-in-sig.invalid> - 2013-10-02 19:49 +0000
Re: Local database library Kevin Nathan <knathan@project54.com> - 2013-10-04 10:48 -0700
Re: Local database library Martin Gregorie <martin@address-in-sig.invalid> - 2013-10-05 15:43 +0000
Re: Local database library Kevin Nathan <knathan@project54.com> - 2013-10-05 11:19 -0700
Re: Local database library Arne Vajhøj <arne@vajhoej.dk> - 2013-10-02 22:05 -0400
Re: Local database library Kevin Nathan <knathan@project54.com> - 2013-10-04 10:57 -0700
Re: Local database library Arne Vajhøj <arne@vajhoej.dk> - 2013-10-04 22:00 -0400
Re: Local database library Kevin Nathan <knathan@project54.com> - 2013-10-05 11:28 -0700
Re: Local database library Arne Vajhøj <arne@vajhoej.dk> - 2013-10-05 15:15 -0400
Re: Local database library Kevin Nathan <knathan@project54.com> - 2013-10-05 12:49 -0700
Re: Local database library "John B. Matthews" <nospam@nospam.invalid> - 2013-10-02 15:37 -0400
Re: Local database library Kevin Nathan <knathan@project54.com> - 2013-10-04 11:02 -0700
Re: Local database library Lew <lewbloch@gmail.com> - 2013-10-04 15:56 -0700
Re: Local database library Kevin Nathan <knathan@project54.com> - 2013-10-05 12:06 -0700
Re: Local database library Lew <lewbloch@gmail.com> - 2013-10-15 16:41 -0700
Re: Local database library Kevin Nathan <knathan@project54.com> - 2013-10-26 12:08 -0700
Re: Local database library Martin Gregorie <martin@address-in-sig.invalid> - 2013-10-26 21:04 +0000
Re: Local database library Kevin Nathan <knathan@project54.com> - 2013-10-26 18:58 -0700
Re: Local database library Arne Vajhøj <arne@vajhoej.dk> - 2013-10-26 18:39 -0400
Re: Local database library Kevin Nathan <knathan@project54.com> - 2013-10-26 19:04 -0700
Re: Local database library Arne Vajhøj <arne@vajhoej.dk> - 2013-10-26 18:33 -0400
csiph-web