Source code: org/vrspace/server/db/MySQLDB.java
1 package org.vrspace.server.db;
2
3 import java.util.ArrayList;
4 import org.vrspace.util.*;
5
6
7 public class MySQLDB extends SQLDB {
8
9 public String create( String name ) {
10 throw new RuntimeException( "Not Implemented" );
11 }
12
13 protected boolean loadDriver() {
14 boolean ret = false;
15 try {
16 Class.forName( "org.gjt.mm.mysql.Driver" );
17 ret = true;
18 } catch (Throwable e) {
19 Logger.logError(e);
20 return ret;
21 }
22
23 BYTE_TYPE = "TINYINT";
24 SHORT_TYPE = "SMALLINT";
25 INT_TYPE = "INT";
26 LONG_TYPE = "BIGINT";
27 FLOAT_TYPE = "FLOAT";
28 DOUBLE_TYPE = "DOUBLE";
29 CHAR_TYPE = "VARCHAR(1)";
30 STRING_TYPE = "VARCHAR(255)";
31 DATE_TYPE = "DATE";
32
33 SQL_SHOW_TABLES = " SHOW TABLES ";
34 SQL_CREATE_OBJECTS_TABLE = " CREATE TABLE objects ( objectID BIGINT NOT NULL PRIMARY KEY, " +
35 " classID BIGINT NOT NULL ) ";
36 SQL_CREATE_CLASSES_TABLE = " CREATE TABLE classes ( classID BIGINT NOT NULL PRIMARY KEY, " +
37 " superClassID BIGINT NOT NULL, " +
38 " packageID BIGINT NOT NULL, " +
39 " className VARCHAR(255) NOT NULL, " +
40 " insertStmt VARCHAR(255) NOT NULL, " +
41 " classFields VARCHAR(255) NOT NULL ) ";
42 SQL_CREATE_PACKAGES_TABLE = " CREATE TABLE packages ( packageID BIGINT NOT NULL PRIMARY KEY, " +
43 " packageName VARCHAR(255) NOT NULL ) ";
44 SQL_COUNT_OBJECTS = " SELECT max(objectID) FROM objects ";
45 SQL_COUNT_CLASSES = " SELECT max(classID) FROM classes ";
46 SQL_COUNT_PACKAGES = " SELECT max(packageID) FROM packages ";
47 SQL_GET_CLASSES = " SELECT * FROM classes ";
48 SQL_CHECK_CLASS = " SELECT classID FROM classes WHERE className = ? ";
49 SQL_CHECK_PACKAGE = " SELECT packageID FROM packages WHERE packageName = ? ";
50 SQL_INSERT_CLASS = " INSERT INTO classes VALUES ( ?, ?, ?, ?, ?, ? ) ";
51 SQL_INSERT_PACKAGE = " INSERT INTO packages VALUES ( ?, ? ) ";
52 SQL_INSERT_OBJECT = " INSERT INTO objects VALUES ( ?, ? ) ";
53 SQL_DELETE_OBJECT = " DELETE FROM objects WHERE objectID = ? ";
54 SQL_DEL_OBJECT = " DELETE FROM ? WHERE db_id = ? ";
55 SQL_GET_OBJECT_1 = " SELECT * FROM ";
56 SQL_GET_OBJECT_2 = " WHERE db_id = ";
57 SQL_GET_OBJECT_3 = " AND cnt_id = ";
58 SQL_GET_OBJECT_4 = " AND arr_id = ";
59
60 SQL_CREATE_OBJ_TABLE_1 = " CREATE TABLE ";
61 SQL_CREATE_OBJ_TABLE_2 = " ( db_id BIGINT NOT NULL, " +
62 " cnt_id BIGINT NOT NULL, " +
63 " arr_id BIGINT NOT NULL, " +
64 " PRIMARY KEY ( db_id, cnt_id, arr_id ), " +
65 " isNull TINYINT NOT NULL ";
66
67 SQL_CREATE_PRIM_TABLE_1 = " CREATE TABLE ";
68 SQL_CREATE_PRIM_TABLE_2 = " ( db_id BIGINT NOT NULL, " +
69 " cnt_id BIGINT NOT NULL, " +
70 " arr_id BIGINT NOT NULL, " +
71 " value ";
72 SQL_CREATE_PRIM_TABLE_3 = " , PRIMARY KEY (db_id, cnt_id, arr_id) ) ";
73
74 SQL_INSERT_PRIM_1 = " INSERT INTO ";
75 SQL_INSERT_PRIM_2 = " VALUES ( ?, ?, ?, ? ) ";
76
77 SQL_GET_ARR_1 = " SELECT COUNT(*) FROM ";
78 SQL_GET_ARR_2 = " WHERE db_id = ";
79 SQL_GET_ARR_3 = " AND cnt_id = ";
80 SQL_GET_ARR_4 = " GROUP BY db_id ";
81
82 SQL_GET_PRIM_ARR_1 = " SELECT value FROM ";
83 SQL_GET_PRIM_ARR_2 = " WHERE db_id = ";
84 SQL_GET_PRIM_ARR_3 = " AND cnt_id = ";
85
86 SQL_GET_RANGE_1 = "SELECT db_id FROM ";
87 SQL_GET_RANGE_2 = " WHERE ";
88 SQL_GET_RANGE_3 = " AND cnd_id = 0 AND arr_id = 0 ";
89 SQL_GET_ALL = "SELECT db_id FROM ";
90 return ret;
91 }
92
93
94 public static void main( String[] args ) throws Exception {
95 org.vrspace.server.Transform t = new org.vrspace.server.Transform();
96 /*
97 t.name = "name";
98 t.x = 1.0f;
99 t.y = 2.0f;
100 t.z = 5.0f;
101 t.rotx = 1.5f;
102 t.roty = 2.5f;
103 t.rotz = 5.5f;
104 t.angle = 6.66f;
105 t.bBoxCenter = new Float[3];
106 t.bBoxSize = new Float[5];
107 t.members = new ID[1];
108
109 t.bBoxCenter[0] = new Float(1.1f);
110 t.bBoxCenter[1] = new Float(2.1f);
111 t.bBoxCenter[2] = new Float(3.1f);
112
113 t.bBoxSize[0] = new Float(2.2f);
114 t.bBoxSize[1] = new Float(2.2f);
115 t.bBoxSize[2] = new Float(2.2f);
116
117 t.members[0] = new ID("id_name", 1);
118 */
119 MySQLDB db = new MySQLDB();
120 db.connect("jdbc:mysql://localhost/vr");
121 //db.put( t );
122 /* t = (org.vrspace.server.Transform)db.get( "org.vrspace.server.Transform", 1 );
123 System.out.println("name="+t.name);
124 System.out.println("angle="+t.angle);
125 System.out.println("bBoxCenter:"+t.bBoxCenter.length);
126 for ( int i=0; i<t.bBoxCenter.length; i++ ) {
127 System.out.println("bBoxCenter["+i+"]="+t.bBoxCenter[i]);
128 }
129 System.out.println("bBoxSize:"+t.bBoxSize.length);
130 for ( int i=0; i<t.bBoxSize.length; i++ ) {
131 System.out.println("bBoxSize["+i+"]="+t.bBoxSize[i]);
132 }
133 System.out.println("members:"+t.members.length);
134 for ( int i=0; i<t.members.length; i++ ) {
135 System.out.println("members["+i+"]="+t.members[i].toString());
136 }
137 */
138 Object[] tt = db.getAll( "org.vrspace.server.Transform" );
139 System.out.println("tt="+tt.length);
140
141 System.exit(0);
142 }
143
144 }