diff options
author | unknown | 2013-11-29 13:27:16 +0100 |
---|---|---|
committer | unknown | 2013-11-29 13:27:16 +0100 |
commit | 4c58fa14232b53d214b2bfa8e81756c21072dd4b (patch) | |
tree | bfa4992b9587ec5bd01fae7ecee40a63a868b954 /Dozentenmodulserver/src | |
parent | Upload mit dynamischen User möglich, welcher nach dem Upload bzw. beenden wie... (diff) | |
download | tutor-module-4c58fa14232b53d214b2bfa8e81756c21072dd4b.tar.gz tutor-module-4c58fa14232b53d214b2bfa8e81756c21072dd4b.tar.xz tutor-module-4c58fa14232b53d214b2bfa8e81756c21072dd4b.zip |
Upload mit dynamischen User, welcher nach dem Upload wieder gelöscht wird
Diffstat (limited to 'Dozentenmodulserver/src')
-rw-r--r-- | Dozentenmodulserver/src/Models/User.java | 7 | ||||
-rw-r--r-- | Dozentenmodulserver/src/server/ServerInterface.java | 1 | ||||
-rw-r--r-- | Dozentenmodulserver/src/server/ServerMethod.java | 11 | ||||
-rw-r--r-- | Dozentenmodulserver/src/sql/SQL.java | 17 |
4 files changed, 35 insertions, 1 deletions
diff --git a/Dozentenmodulserver/src/Models/User.java b/Dozentenmodulserver/src/Models/User.java index c946cd70..c533d6fa 100644 --- a/Dozentenmodulserver/src/Models/User.java +++ b/Dozentenmodulserver/src/Models/User.java @@ -7,6 +7,13 @@ public class User implements Serializable { private String username;
private String pass;
+ private String path;
+ public String getPath() {
+ return path;
+ }
+ public void setPath(String path) {
+ this.path = path;
+ }
public String getUsername() {
return username;
}
diff --git a/Dozentenmodulserver/src/server/ServerInterface.java b/Dozentenmodulserver/src/server/ServerInterface.java index 783321be..6ae6e529 100644 --- a/Dozentenmodulserver/src/server/ServerInterface.java +++ b/Dozentenmodulserver/src/server/ServerInterface.java @@ -6,6 +6,7 @@ import Models.User; public interface ServerInterface extends Remote
{
public User getFtpUser() throws RemoteException;
+ public int DeleteFtpUser(String user) throws RemoteException;
}
diff --git a/Dozentenmodulserver/src/server/ServerMethod.java b/Dozentenmodulserver/src/server/ServerMethod.java index 73ce26b3..a3a2db65 100644 --- a/Dozentenmodulserver/src/server/ServerMethod.java +++ b/Dozentenmodulserver/src/server/ServerMethod.java @@ -45,6 +45,7 @@ public class ServerMethod extends UnicastRemoteObject implements ServerInterface User user=new User();
user.setUsername(UUID.randomUUID().toString().substring(0, 8));
user.setPass(UUID.randomUUID().toString().substring(0, 8));
+ user.setPath("/srv/openslx/nfs/temp");
SQL sql=new SQL();
Connection con=sql.getConnection();
sql.writeFTPUser(con, user.getUsername(), user.getPass());
@@ -53,5 +54,15 @@ public class ServerMethod extends UnicastRemoteObject implements ServerInterface + @Override
+ public int DeleteFtpUser(String user) throws RemoteException {
+ SQL sql=new SQL();
+ Connection con=sql.getConnection();
+ int ret = sql.DeleteUser(con, user);
+ return ret;
+ }
+
+
+
}
\ No newline at end of file diff --git a/Dozentenmodulserver/src/sql/SQL.java b/Dozentenmodulserver/src/sql/SQL.java index c3582527..84e8cd11 100644 --- a/Dozentenmodulserver/src/sql/SQL.java +++ b/Dozentenmodulserver/src/sql/SQL.java @@ -34,7 +34,7 @@ public class SQL { try {
stm=con.createStatement();
- int ret=stm.executeUpdate("INSERT INTO `bwLehrpool`.`FtpUsers`(`User`,`Password`,`Dir`)VALUES('"+user+"','"+pass+"','/');");
+ int ret=stm.executeUpdate("INSERT INTO `bwLehrpool`.`FtpUsers`(`User`,`Password`,`Uid`,`Gid`,`Dir`)VALUES('"+user+"','"+pass+"','10001','12345','/srv/openslx/nfs/temp');");
con.commit();
return ret;
} catch (SQLException e) {
@@ -44,6 +44,21 @@ public class SQL { return -1;
}
+ public int DeleteUser(Connection con, String user)
+ {
+ Statement stm;
+ try {
+ stm=con.createStatement();
+
+ int ret=stm.executeUpdate("DELETE FROM `bwLehrpool`.`FtpUsers` where User like '"+user+"';");
+ con.commit();
+ return ret;
+ } catch (SQLException e) {
+ // TODO Auto-generated catch block
+ e.printStackTrace();
+ }
+ return -1;
+ }
}
|