diff options
| author | Julien Sere <jsere> | 2011-01-22 17:22:13 +0000 |
|---|---|---|
| committer | Julien Sere <jsere> | 2011-01-22 17:22:13 +0000 |
| commit | d26dbab8f789d787d5c39f8700b4ac19701f286f (patch) | |
| tree | 4525a459c2c6582e6015fd82714f7c09b791efb9 /app/v2_java/src/org/usi2011/Database.java | |
| parent | a1051d374d9d7e0892dda3bf19bd4224ff0fa06b (diff) | |
| download | 2011-usi-d26dbab8f789d787d5c39f8700b4ac19701f286f.tar.gz 2011-usi-d26dbab8f789d787d5c39f8700b4ac19701f286f.tar.bz2 2011-usi-d26dbab8f789d787d5c39f8700b4ac19701f286f.zip | |
initial check out java
git-svn-id: file:///var/svn/2011-usi/trunk@13 db941bf7-0cb3-4dda-9634-87faf64f93a7
Diffstat (limited to 'app/v2_java/src/org/usi2011/Database.java')
| -rw-r--r-- | app/v2_java/src/org/usi2011/Database.java | 73 |
1 files changed, 73 insertions, 0 deletions
diff --git a/app/v2_java/src/org/usi2011/Database.java b/app/v2_java/src/org/usi2011/Database.java new file mode 100644 index 0000000..6ebb63a --- /dev/null +++ b/app/v2_java/src/org/usi2011/Database.java @@ -0,0 +1,73 @@ +package org.usi2011;
+
+import java.sql.Connection;
+import java.sql.DriverManager;
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.sql.Statement;
+
+/**
+ * @author XKHM6852
+ *
+ */
+public final class Database {
+
+ private static Connection connection;
+
+ /** */
+ public static Connection getConnection() {
+ if (connection == null) {
+ createDatabase();
+ }
+ return connection;
+ }
+
+ private static void createDatabase() {
+ try {
+ connection = DriverManager.getConnection("jdbc:hsqldb:mem:aname",
+ "sa", "");
+ String query = "DROP TABLE game; CREATE TABLE game ( "
+ + " id INT NOT NULL PRIMARY KEY, "
+ + " longpollingduration INT NOT NULL, "
+ + " nbusersthreshold INT NOT NULL,"
+ + " questiontimeframe INT NOT NULL,"
+ + " nbquestions INT NOT NULL" + ");";
+
+ Statement statement = connection.createStatement();
+ ResultSet resultset = statement.executeQuery(query);
+ connection.commit();
+ createUser();
+
+ } catch (SQLException e) {
+
+ System.out.println("SQL Exception " + e.getMessage());
+ }
+ }
+
+ private static void createUser() {
+ /*
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `firstname` varchar(255) COLLATE utf8_bin NOT NULL,
+ `lastname` varchar(255) COLLATE utf8_bin NOT NULL,
+ `mail` varchar(255) COLLATE utf8_bin NOT NULL,
+ `password` varchar(255) COLLATE utf8_bin NOT NULL,
+ */
+ try {
+ String query = "DROP TABLE user; CREATE TABLE user ( "
+ + " id INT GENERATED BY DEFAULT AS IDENTITY, "
+ + " firstname VARCHAR NOT NULL, "
+ + " lastname VARCHAR NOT NULL,"
+ + " mail VARCHAR NOT NULL,"
+ + " password VARCHAR NOT NULL" + ");";
+
+ Statement statement = connection.createStatement();
+ ResultSet resultset = statement.executeQuery(query);
+ connection.commit();
+
+ } catch (SQLException e) {
+
+ System.out.println("SQL Exception " + e.getMessage());
+ }
+ }
+
+}
|