package com.hazelcast.springHibernate;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
class InitializeDB {
static void start() {
try {
Class.forName("org.apache.derby.jdbc.EmbeddedDriver").newInstance();
} catch (Exception e) {
e.printStackTrace();
}
try {
Connection conn = DriverManager.getConnection("jdbc:derby:springHibernateDB;create=true", new Properties());
Statement st = conn.createStatement();
st.executeUpdate("CREATE TABLE CUSTOMER("
+ "ID VARCHAR(255) PRIMARY KEY NOT NULL,"
+ "NAME VARCHAR(255) NOT NULL,"
+ "SURNAME VARCHAR(255) NOT NULL"
+ ")");
st.executeUpdate("INSERT INTO CUSTOMER VALUES ('1', 'Name1', 'Surname1')");
st.executeUpdate("INSERT INTO CUSTOMER VALUES ('2', 'Name2', 'Surname2')");
st.executeUpdate("INSERT INTO CUSTOMER VALUES ('3', 'Name3', 'Surname3')");
st.executeUpdate("INSERT INTO CUSTOMER VALUES ('4', 'Name4', 'Surname4')");
} catch (SQLException s) {
s.printStackTrace();
}
}
}