Thread: write object to sql db

Yes there is. For my Project we used DatabaseDerby that comes with the NetBeans IDE. First you must connect to the database manually before running the program, then its really easy, its just some repetitive code followed by the statement of what you want to do, like insert, delete etc. Here is a part of my project that did some database executions.

 
if(addMoneyToAcc == true)               //if user pressed "Add Money to Account" button
            {
                // This line of code creates an instance of the driver for the database
                Class.forName("org.apache.derby.jdbc.ClientDriver").newInstance();
                // Connects to the database
                myConnection =
                DriverManager.getConnection("jdbc:derby://localhost:1527/BillsDatabase",
                        "root","root");
                stmt = myConnection.createStatement();
 
                testQuery="select account_balance from transmitters where transmitter_id=" +
                        transmitterIDNum;
                //above statement creates an SQL string to be executed
 
                results=stmt.executeQuery(testQuery);   //executes the query
 
                stmt.close();
                results.close();
                myConnection.close();  // it is important to do all the closing, otherwise u will get an error
}

So basically you repeat all the code except the part that is the query, that is what actually alters the database, everything else can be copied and pasted. You have to know how to work with database statements.

You should be able to do this by just serializing the object. But if you want a proper object database I'd recommend you use something like db4o :: Java & .NET Object Database ? Open Source Object Database, Open Source Persistence, Oodb

// Json