Package org.exoplatform.services.database.annotation

Examples of org.exoplatform.services.database.annotation.Table

112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
      exoDatasource.closeConnection(conn);
   }

   public <T extends DBObject> void dropTable(Class<T> type) throws Exception
   {
      Table table = type.getAnnotation(Table.class);
      if (table == null)
      {
         throw new Exception("Can not find the annotation for class " + type.getClass().getName());
      }
      Connection conn = exoDatasource.getConnection();
      Statement s = conn.createStatement();
      s.execute("DROP TABLE " + table.name());
      s.close();
      conn.commit();
      exoDatasource.closeConnection(conn);
   }
View Full Code Here
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
      exoDatasource.closeConnection(conn);
   }

   public <T extends DBObject> boolean hasTable(Class<T> type) throws Exception
   {
      Table table = type.getAnnotation(Table.class);
      if (table == null)
      {
         throw new Exception("Can not find the annotation for class " + type.getClass().getName());
      }
      Connection connection = exoDatasource.getConnection();
      Statement statement = connection.createStatement();
      try
      {
         if (statement.execute("SELECT 1 FROM " + table.name()) == true)
            return true;
      }
      catch (SQLException ex)
      {
         return false;
View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
98
   }

   public void mapResultSet(ResultSet resultSet, T bean) throws Exception
   {
      Class<? extends DBObject> clazz = bean.getClass();
      Table table = clazz.getAnnotation(Table.class);
      TableField[] tableFields = table.field();

      ResultSetMetaData rsmd = resultSet.getMetaData();
      int numberOfColumns = rsmd.getColumnCount();
      for (int i = 1; i <= numberOfColumns; i++)
      {
View Full Code Here
109
110
111
112
113
114
115
116
117
118
119
120
   }

   public void mapUpdate(T bean, PreparedStatement statement) throws Exception
   {
      Class<? extends DBObject> clazz = bean.getClass();
      Table table = clazz.getAnnotation(Table.class);
      TableField[] tableFields = table.field();

      int i = 1;
      for (TableField tableField : tableFields)
      {
         String fieldName = tableField.field().length() == 0 ? tableField.name() : tableField.field();
View Full Code Here
166
167
168
169
170
171
172
173
174
175
176
177
      else
      {
         builder.append(" * ");
      }

      Table table = type_.getAnnotation(Table.class);
      builder.append(" FROM ").append(table.name());
      if (parameters_.size() > 0)
      {
         builder.append(" WHERE ");
         for (int i = 0; i < parameters_.size(); i++)
         {
View Full Code Here
196
197
198
199
200
201
202
203
204
205
206
207
   }

   private String consturctCountQuery(boolean useOR)
   {
      StringBuilder builder = new StringBuilder();
      Table table = type_.getAnnotation(Table.class);
      builder.append("SELECT COUNT(*) FROM  ").append(table.name());
      if (parameters_.size() > 0)
      {
         builder.append(" WHERE ");
         for (int i = 0; i < parameters_.size(); i++)
         {
View Full Code Here
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
      databaseType = dbType;
   }

   public <T extends DBObject> String createSelectQuery(Class<T> type, long id) throws Exception
   {
      Table table = type.getAnnotation(Table.class);
      TableField[] fields = table.field();

      StringBuilder query = new StringBuilder("SELECT ");
      for (int i = 0; i < fields.length; i++)
      {
         TableField field = fields[i];
         query.append(field.name());
         if (i != fields.length - 1)
            query.append(", ");
      }
      query.append(" FROM ").append(table.name());
      if (id > -1)
         query.append(" WHERE ID = ").append(id);
      return query.toString();
   }
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
73
74
75
      return query.toString();
   }

   public <T extends DBObject> String createUpdateQuery(Class<T> type) throws Exception
   {
      Table table = type.getAnnotation(Table.class);
      TableField[] fields = table.field();

      StringBuilder query = new StringBuilder("UPDATE ").append(table.name()).append(" SET ");
      for (int i = 0; i < fields.length; i++)
      {
         TableField field = fields[i];
         query.append(field.name()).append(" = '$").append(field.name()).append('\'');
         if (i != fields.length - 1)
View Full Code Here
80
81
82
83
84
85
86
87
88
89
90
91
92
93
      return query.toString();
   }

   public <T extends DBObject> String createInsertQuery(Class<T> type) throws Exception
   {
      Table table = type.getAnnotation(Table.class);
      TableField[] fields = table.field();

      StringBuilder query = new StringBuilder("INSERT INTO ").append(table.name()).append("(ID, ");
      for (int i = 0; i < fields.length; i++)
      {
         TableField field = fields[i];
         query.append(field.name());
         if (i != fields.length - 1)
View Full Code Here
107
108
109
110
111
112
113
114
115
116
117
118
119
120
      return query.toString();
   }

   public <T extends DBObject> String createUpdateQuery(Class<T> type, long id) throws Exception
   {
      Table table = type.getAnnotation(Table.class);
      TableField[] fields = table.field();

      StringBuilder query = new StringBuilder("UPDATE ").append(table.name()).append(" SET ");
      for (int i = 0; i < fields.length; i++)
      {
         TableField field = fields[i];
         query.append(field.name()).append(" = ?");
         if (i != fields.length - 1)
View Full Code Here
TOP

Related Classes of org.exoplatform.services.database.annotation.Table

  • org.exoplatform.services.database.DBObjectQuery
  • org.exoplatform.services.database.QueryBuilder
  • org.exoplatform.services.database.ReflectionMapper
  • org.exoplatform.services.database.StandardSQLTableManager
  • org.exoplatform.services.database.table.IDGenerator
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.