Return to Snippet

Revision: 30135
at August 8, 2010 12:46 by LarryStreeter


Initial Code
import de.rochade.srap.Connection;
import de.rochade.srap.ResultSet;
import de.rochade.srap.ResultSetFactory;
import de.rochade.srap.Rochade;
import de.rochade.srap.SrapException;
import de.rochade.srap.Startup;
import de.rochade.srap.UserAdmin;

public class AddUser {

  public static void main(String[] args){

    Connection connection = null;
    try {

       // Connect to the Rochade Server
       Rochade rochade = Startup.getInstance(null, null, null, null, null, null);
       connection = rochade.getConnection("localhost", 8888, "ROADM", "", null);

       // Request the User Administration object for the selected database
       UserAdmin userAdmin = connection.getUserAdmin("AP-DATA");

       // Get the authentication settings from an existing template
       // using the select method.

      // Setup the select statement parameters
      String what = "authentication, operPriv, userPriv";
      ResultSet from = ResultSetFactory.getResultSet("type, name", null, null);
      ResultSet where = null;

      from.add();
      from.updateString("type", "template"); // Identify the type as template
      from.updateString("name", "ROCHUSER"); // The name of the template to get

      // Request the template using a select call
      ResultSet rs = userAdmin.select(what, from, where);

      // move to the first row and get the authentication values and operator
      // and user privileges
      rs.first();
      ResultSet authentication = rs.getResultSet("authentication");
      String operPriv = rs.getString("operPriv");
      String userPriv = rs.getString("userPriv");

      // Create a new user in the selected database with the create method.

      ResultSet rsUser = ResultSetFactory.getResultSet(
           "type, userID, shortDesc, authentication, operPriv, userPriv",
           null, null);
       rsUser.add();
       rsUser.updateString("type", "user"); // Identify the type as user
       rsUser.updateString("userID", "JOEUSER"); // User ID
       rsUser.updateString("shortDesc",
           "Joe is a Rochade user, not a plumber"); // User description

       // Add an additional column to the authentication parameters
       // for the users initial password.
       authentication.appendColumn("pwd", "String");
       authentication.first();
       authentication.updateString("pwd", "password");

       // set the authentication settings and the user and operator
       // privileges for the new user.
       rsUser.updateResultSet("authentication", authentication);
       rsUser.updateString("operPriv", operPriv);
       rsUser.updateString("userPriv", userPriv);

       // Create the user using the create method.
       rs = userAdmin.create(rsUser);

       // Check the results for success.
       rs.first();
       if (!rs.getBoolean("success")){
          System.out.println(rs.getString("message"));
          System.out.println(rs.getString("exception"));
     }
  }
  catch (SrapException e) {
    e.printStackTrace();
  }
  finally {
    if (connection != null) {
      connection.dispose();
    }
   }
}

Initial URL


Initial Description


Initial Title
Add new Rochade User

Initial Tags


Initial Language
Java