Download Shareware and Freeware Software for Windows, Linux, Macintosh, PDA

line Home  |  About Us  |  Link To Us  |  FAQ  |  Contact

Serving Software Downloads in 976 Categories, Downloaded 29.886.931 Times

JCDatabase 1.0

Company: DigitalScores
Date Added: August 17, 2013  |  Visits: 242

JCDatabase

Report Broken Link
Printer Friendly Version


Product Homepage
Download (16 downloads)



JCDatabase is a simplified version of JDBC (Java Database Connectivity) that lets developers use Java's write once, run everywhere capabilities for cross-platform applications that need data access. JCDatabase has the following advantages over JDBC:<br /><br /> 1. JCDatabase does not require you to run a database server or configure your system to provide access to a local database and;<br /> 2. JCDatabase can be deployed either on a server for access by many users or as part of a traditional client-side application using direct file access. <br /><br />JCDatabase was originally written to allow games to have fast access to a local file system for saving and retrieving the player's data using a relational database. It was also used in the 3DMatrix product to save and retrieve data conveniently and has been used succesfully in many other commercial products.<br /><br />It is much nicer to arrange data in tables and perform queries rather than using an ad-hoc approach to creating data files and dealing with stored data in general. If you want to be storing data from your Java application and you prefer to use a relational database approach, then JCDatabase might be an ideal set of Java classes for your needs. JCDatabase also works beautifully for Servlets, allowing multiple people could access the same database.<br /><br />2. Strengths<br /><br /> 1. JCDatabase is extremely simple to use.<br /> 2. JCDatabase is flexible. The database can function with your Java code whether it is deployed as an Applet accessing a local database on the client, a Java Servlet accessing a database on the server or a Java Application running either on the client or on the server.<br /> 3. If deploying your application on the server you do not need to buy a commercial database server or ask your system administration to assist with the setup - you just have to put the JCDatabase data files in the default directory.<br /> 4. If deploying your application in the traditional way on the client (such as with a CD-ROM distribution with your installation or simply providing a ZIP file with the entire application and database) then you do not require your customers to configure their system in any way. <br /><br />3. Weaknesses<br /><br /> 1. You cannot import/export data between a JCDatabase and other databases. This means JCDatabase is not suitable if you want to link to an existing large database.<br /> 2. The SQL model used in JCDatabase is greatly simplified such that you only have a collection of bare essentials. For me this works however if you want a complete SQL language then JCDatabase is not going to cut it.<br /> 3. The software costs US$25. The good news however is that you can have it for free provided you are not dealing with too much data. <br /><br />4. Coding example<br /><br />Let us say that we want to create a database table that stores the names of people and their year of birth. To create a table you firstly have to make a text file containing the definition of the table columns. This file must have the same name as the table and with a .def extension. In our particular case the table definition text file could be:<br /><br />string FIRST_NAME 15<br />string LAST_NAME 15<br />integer ID autonumber<br />integer YEAR_OF_BIRTH<br /><br />We need to save this text file as people.def and then we can add the following code to our Java Application, Applet or Servlet to establish a reference to the table. Make sure that you have the file jcdatabase.jar in one of the directories within your CLASSPATH.<br /><br />import com.digitalscores.jcdatabase.JCRow;<br />import com.digitalscores.jcdatabase.JCTable;<br /><br />..<br /><br />JCTable people = new JCTable("PEOPLE");<br /><br />So far there has only been one line of code and we already have a reference to our table. To create a row of data for our table, you can use:<br /><br />JCRow newRow = new JCRow(people);<br />newRow.setString("FIRST_NAME", "Julian");<br />newRow.setString("LAST_NAME", "Cochran");<br />newRow.setInt("YEAR_OF_BIRTH", 1974);<br />people.insert(newRow);<br /><br />You could use the alternative syntax to acheive the same thing with one line of code:<br /><br />people.insert("FIRST_NAME=Julian LAST_NAME=Cochran YEAR_OF_BIRTH=1974");<br /><br />If you then wanted to delete all the rows in which the person's last name was 'Cochran', you would add the following code:<br /><br />people.delete("LAST_NAME", "=", "Cochran");<br /><br />To change the first name of anyone called "Julian" to "Jules", you use the update method in the following way:<br /><br />people.update("FIRST_NAME", "Jules", "FIRST_NAME", "=", "Julian");<br /><br />And if you wanted to select all the rows in which the year of birth is less than 1980 you would add:<br /><br />JCRow[] result = people.select("YEAR_OF_BIRTH", "<", 1980);<br /><br />And to print the results of that query, the following code works fine:<br /><br />for (int i = 0; i < result.length; i++) {<br /> System.out.println(result[i].getString("FIRST_NAME"));<br />}<br /><br />Within this section we have covered all of the essential concepts that allow you to do anything with your database -- inserting, updating, deleting and querying rows. The complete JCDatabase API can be viewed here.<br /><br />To do the same things with JDBC you need to write a lot more code, install and configure software if accessing a local database, or be charged by your ISP if you wish to access your own ODBC or JDBC database on their server. JCDatabase bypasses these requirements by using Java's standard IO classes and a simple direct file access design.<br /><br />5. Deployment<br /><br />JCDatabase can be deployed with (1) Java Applets accessing the customer's local database, (2) Java Applications running on the client accessing the customer's local database, (3) Java Servlets or Applications running on a server accessing a server database.<br /><br />In the case of deploying JCDatabase with a traditional client-side application, you can simply deploy your product by making a ZIP file available to the customer containing the following files:<br /><br /> 1. All the .class files of your Java program.<br /> 2. The JCDatabase .class files.<br /> 3. Your table definition files (.def) - these define the columns for each table.<br /> 4. Optionally, any database files (.dat) - these contain the actual rows of data for each table. <br /><br />If you are using JCDatabase with Java Servlets to allow everyone to access the database, the only difference with deployment is that you place the .class, .dat and .def files into one directory on the server rather than within the ZIP file.<br /><br />6. How to obtain JCDatabase<br /><br />You can download JCDatabase jcdatabase.zip here. This version includes a running example of a simple database and requires that your tables do not exceed 100 rows. I express many thanks to anyone willing to purchase JCDatabase. I have spent a lot of time putting these classes together and I am sure you understand that it is reasonable to ask for a small fee. To obtain the unrestricted version you may order JCDatabase by credit card here. You will then receive the latest version of JCDatabase via email.

Requirements: No special requirements
Platforms: Mac, Mac OSX
Keyword: Access Accessing Application Client Create Database Definition Files Jcdatabase Local Running Server System Table Traditional Version
Users rating: 0/10

License: Demo Size: 30.72 KB
USER REVIEWS
More Reviews or Write Review


JCDATABASE RELATED
Database Tools  -  Create Database Application 5.6
Longtion Application Builder is a tool for creating database applications and Web applications without writing any code. And you don't have to be a software programmer to do it. With its intuitive integrated development environment (IDE) and...
5.23 MB  
Libraries  -  Advanced Data Import 2.4
Advanced Data Import Component Suite for Borland Delphi and C++ Builder will allow you to import your data to the database from files in the most popular data formats. You can import data from MS Excel, MS Access, DBF, XML, TXT and CSV. There will...
4.93 MB  
Multimedia & Graphics  -  KDVDCreator 0.3.2
Easy to use application to create video DVDs and CDs (VCD, sVCD or CVD), suitables for home players, from any number of video files, in any of the formats supported by Mplayer. Dependencies: * mplayer/mencoder * dvdauthor * ImageMagick >= 6.3.2 (...
696.32 KB  
Network & Internet  -  OpenCollection 0.52
OpenCollection is a full-featured collections management and access Web application for museums, photo, etc. OpenCollection is the product of a collaboration between the Museum of the Moving Image and Whirl-i-Gig to produce a full-featured...
1.9 MB  
Networking  -  PHP Upload To My FTP for Scripts 1.4
PHP Upload To My FTP is an upload form script written in php in order to upload files to your ftp server via your web browser.A Multiuser Authentification system can restrict access to the application. You can specify the types of files which you...
40.96 KB  
Utilities  -  xsd2db 0.1.0
xsd2db package is contributed with LayManSys and is used for converting XML Schema Definition files into DocBook XML code. The transformer can also be used to generate DocBook XML from plain XML files. xsd2db marks up tag names, attribute names,...
7.17 KB  
File Management  -  Easy file parsing 1.2
This scriptis useful for making easy and human to write definition files for whatever use.For example, lets say you are writing a simulator and you need an easy, human way to define parts about a given world like light sources, obstacles, and...
 
Printer Tools  -  PDF Document Writer 7.2
The Rogosoft PDF Document Writer is a print-to-file driver that enables any Windows 8/7/2012/2008/2003/XP/Vista 32-bit and 64-bit application to create Adobe PDF files by printing. Unlike other PDF creation programs, Rogosoft PDF Document...
1.38 MB  
Puzzles  -  Online Cardgame System 0.9.0
Online Cardgame System project is a client-server system for playing card games over the net. OCS is a client-server cardgame system, similar to those found at Yahoo! Games and elsewhere. The server is portable and has been tested under Linux,...
 
Development Editors  -  Web Chart Creator 2.0
Web Chart Creator is your tool for fast creation of dynamic 3D charts for the Internet/Intranet projects using databases of any type. The charts are created with a simple visual editor. It has a friendly and intuitive interface designed for both...
1.06 MB  
NEW DOWNLOADS IN MACINTOSH SOFTWARE, PROGRAMMING
Macintosh Software  -  Cisdem Data Recovery for Mac 4.1.0
Using advanced scanning technology and directory restructuring algorithm, Cisdem Data Recovery for Mac can help you to recover lost valuable data, documents, emails, videos, music, photos, and lost partitions from any Mac...
6.6 MB  
Macintosh Software  -  iDoctor 2.0
iDoctor equips Mac users with 15 cleaning and optimization tools to make their working on Mac easy and simply. With iDoctor’s help you can also manage, encrypt, backup, recover or shred files with just a couple of mouse clicks. Thus,...
98 KB  
Macintosh Software  -  AnyMP4 Free iPhone Data Recovery for Mac 7.3.18
AnyMP4 Free iPhone Data Recovery for Mac can allow you to recover deleted files from iPhone/iPad/iPod like Camera Roll, Notes, Reminders, Voice Memos, and Safari Bookmark on Mac. You can directly recover deleted data from iOS Device like...
24.4 MB  
Macintosh Software  -  AnyMP4 DVD Ripper for Mac 6.3.16
AnyMP4 DVD Ripper for Mac not only help you rip DVD movies to any video formats like MP4, MOV, M4V, AVI, WMV, FLV, MKV, MPEG and more for Mac, but also rip DVD to other audio formats such as MP3, FLAC, WAV, WMA, AAC, ALAC, AC3 and more for Mac....
43.8 MB  
Macintosh Software  -  AnyMP4 Blu-ray Ripper for Mac 6.1.86
AnyMP4 Blu-ray Ripper for Mac aims to help you handily rip Blu-ray movie to any popular video or audio format for your portable device and even 3D player device. It can work as Blu-ray copy software to back up your Blu-ray disc/file to Mac. It...
44.6 MB  
Programming  -  MacX Free iMovie Video Converter 4.1.8
MacX Free iMovie Video Converter is a professional free iMovie video converter for Mac that can convert any SD and HD videos such as M2TS, MKV, AVI, WMV, FLV, VOB, 3GP and more to iMovie accepted video formats MOV & MP4 for importing to iMovie...
22.92 MB  
Programming  -  TclAppleScript 2.0 Beta
The AppleScript command dates back to the days of the Classic MacOS, and was originally designed as a stopgap command to fill the place of "exec" on the old Classic MacOS. Much of its original code and commands are now obsolete, and its public API...
276.48 KB  
Programming  -  SwapList 0.1 Alpha
Java list implementation that swaps list items to a disk file in order to avoid out-of-memory error.
10.24 KB  
Programming  -  Custom Console 2.5
Write Your own Language or Batch Based Executable Programs in Java Runtime Environment. Use Custom JAR files as Command Line commands with this custom command line console program. Simply write your JAR files to accept Main String Arguments and...
286.72 KB  
Programming  -  Mano 1.05 Beta
Mano is a makeFile navigator containing a tree grouping the targets.
20.48 KB