Load and save data to Derby database
import java.io.File;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class MainClass {
public static void createDatabase() {
String data = "jdbc:derby:presidents;create=true";
try {
Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
Connection conn = DriverManager.getConnection(data);
Statement st = conn.createStatement();
int result = st.executeUpdate("CREATE TABLE contacts (dex INTEGER NOT NULL PRIMARY KEY "
+ "GENERATED ALWAYS AS identity (START WITH 1, INCREMENT BY 1), "
+ "name VARCHAR(40), address1 VARCHAR(40), address2 VARCHAR(40))");
result = st.executeUpdate("INSERT INTO contacts (name, address1, address2"
+ ") VALUES('J','Center', 1 , 'GA')");
st.close();
} catch (Exception e) {
System.out.println("Error - " + e.toString());
}
}
public static void readDatabase() {
String data = "jdbc:derby:presidents";
try {
Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
Connection conn = DriverManager.getConnection(data, "", "");
Statement st = conn.createStatement();
ResultSet rec = st.executeQuery("SELECT * FROM contacts ORDER BY name");
while (rec.next()) {
System.out.println(rec.getString("name") + "\n" + rec.getString("address1") + "\n"
+ rec.getString("address2") + "\n" + rec.getString("phone") + "\n"
+ rec.getString("email") + "\n");
}
st.close();
} catch (Exception e) {
System.out.println("Error - " + e.toString());
}
}
public static void main(String[] arguments) {
String home, system;
home = System.getProperty("user.home", ".");
system = home + File.separatorChar + ".database";
System.setProperty("derby.system.home", system);
createDatabase();
readDatabase();
}
}
Related examples in the same category