simplyose.blogg.se - Openoffice database

Draw: A vector graphics editor analogous in features to the drawing functions in Microsoft Office.Impress: A presentation program like Microsoft PowerPoint and Apple Keynote.Calc: A spreadsheet like Microsoft Excel and Lotus 1-2-3.Writer: A word processor like Microsoft Word and WordPerfect.The major components of this software include: Well, today there are many such alternatives available, but Apache OpenOffice is the first legitimate free contender to Microsoft Office and a worth trying option.Īpache OpenOffice – Free Open-Source Office SoftwareĪpache OpenOffice is one of the leading open-source office productivity software for word processing. Having said that, trying Microsoft Office alternatives is surely the easy way out. Then there’s one feature that most of us aren’t a fan of – The Price Tag. are loaded with features but, practically getting used to all of them would take weeks of training. Logger.getLogger(()).log(Level.Microsoft Office apps like Word, PowerPoint, Excel, etc. Logger.getLogger(()).log(Level.SEVERE, null, ex) (" last name: " + rs.getString("lastname")) (" first name: " + rs.getString("firstname")) ResultSet rs = statement.executeQuery("SELECT * FROM \"User\"")

Statement statement = con.createStatement() It can contain directory names relative to theĬon = DriverManager.getConnection("jdbc:hsqldb:file:" + db_file_name_prefix, // filenames prefix db_file_name_prefix is used to open or create files that hold the state This will load the db files and start the hsqldb.jar should be in the class path or made part of the current jar Load the HSQL Database Engine JDBC driver String db_file_name_prefix = "c:\\mydbdir\\mydb" Public static void main(String args) throws ParseException */ public static void main ( String args ) throws ParseException Import import import import import import import import public class Main

The other is to use the Java JDBC API to connect to the database, topic not covered in this post. I will just show you the code that you can use as a example.

Put hsqldb.jar and into classpath project.

Extract the zip file, search and find jdbc driver files inside lib directory: hsqldb.jar.

That is the specific driver for HSQL in Java.

Download “ hsqldb_1_8_0_10.zip” (HSQLD DB ENGINE) from.

Rename all the files by putting the same prefix before the file name, thus leaving: mydb.backup, mydb.data, mydb.properties, mydb.script.

Copy the files into a separate location, i.e C:\mydb.

Rename the mydb.odb file in mydb.zip, extract “database” directory from it, so you can find these files: backup, data, properties, script.

Create three columns inside the above table (i.e ID, firtsname, lastname).Ģ.

The files extensions generates by Base are.

HSQLDB is the internal engine of OpenOffice db.