Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static void insertStructureData(String dataTable, Object workingObject)
- {
- try
- {
- DataBase.mysql_cnn = DataBase.getConnectionString();
- PreparedStatement cmd = null;
- StringBuilder sql = new StringBuilder();
- StringBuilder data = new StringBuilder();
- sql.append(String.format("INSERT INTO %s (", dataTable));
- data.append("VALUES (");
- for (Field field : workingObject.getClass().getDeclaredFields())
- {
- sql.append(String.format("%s, ", field.getName()));
- data.append("?,");
- }
- cmd = DataBase.mysql_cnn.prepareStatement(sql.substring(0, sql.lastIndexOf(",")) + ") " + data.substring(0, data.lastIndexOf(",")) + ") ");
- int Ix = 0;
- for (Field field : workingObject.getClass().getDeclaredFields())
- {
- Ix++;
- cmd.setObject(Ix, field.get(workingObject).toString());
- }
- cmd.executeUpdate();
- DataBase.mysql_cnn.close();
- }
- catch (Exception e)
- {
- e.printStackTrace();
- }
- }
- public static void updateStructureData(String dataTable, Object workingObject)
- {
- try
- {
- DataBase.mysql_cnn = DataBase.getConnectionString();
- PreparedStatement cmd = null;
- StringBuilder sql = new StringBuilder();
- String where = "";
- sql.append(String.format("UPDATE %s SET ", dataTable));
- int FieldCount = 0;
- for (Field field : workingObject.getClass().getDeclaredFields())
- {
- sql.append(String.format("%s = ?, ", field.getName()));
- if (FieldCount == 0)
- where = String.format(" WHERE %s = ?", field.getName());
- FieldCount++;
- }
- cmd = DataBase.mysql_cnn.prepareStatement(sql.substring(0, sql.lastIndexOf(",")) + where);
- int Ix = 0;
- for (Field field : workingObject.getClass().getDeclaredFields())
- {
- Ix++;
- cmd.setString(Ix, field.get(workingObject).toString());
- if(Ix == 1)
- cmd.setString(FieldCount + 1, field.get(workingObject).toString());
- }
- cmd.executeUpdate();
- DataBase.mysql_cnn.close();
- }
- catch (Exception e)
- {
- e.printStackTrace();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement