Groups > comp.lang.java.databases > #630

Re: Local database library

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From	Martin Gregorie <martin@address-in-sig.invalid>
Newsgroups	comp.lang.java.databases
Subject	Re: Local database library
Date	Sat, 5 Oct 2013 15:43:43 +0000 (UTC)
Organization	A noiseless patient Spider
Lines	32
Message-ID	<l2pc3f$442$1@dont-email.me> (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>
Mime-Version	1.0
Content-Type	text/plain; charset=UTF-8
Content-Transfer-Encoding	8bit
Injection-Date	Sat, 5 Oct 2013 15:43:43 +0000 (UTC)
Injection-Info	mx05.eternal-september.org; posting-host="e5160e2be48f1ea550cf61512446f525"; logging-data="4226"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/kDERTH6r/OYxKQqEU1LOBonafW1NRfnA="
User-Agent	Pan/0.139 (Sexual Chocolate; GIT bf56508 git://git.gnome.org/pan2)
Cancel-Lock	sha1:wjfIXJ/ATYLKhuyLxC0So29XMQk=
Xref	csiph.com comp.lang.java.databases:630

Show key headers only | View raw

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" and right now I have a "connect.java" file in
> that makes the connection to the database and a "transaction.java" that
> works with the transaction table. My source file in a different project
> is not seeing these, but I think it might be improper setup in NetBeans
> since I'm learning *that* too! :-)
>
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.

This is not a particularly OO design choice, but it does a good job of 
encapsulating the JDBC elements of a program and gives reasonable 
separation between the logic implementing each transaction type.

-- 
martin@   | Martin Gregorie
gregorie. | Essex, UK
org       |

Back to comp.lang.java.databases | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

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