1 files changed, 36 insertions, 0 deletions
diff --git a/src/main/java/org/openslx/imagemaster/db/DbFtpUser.java b/src/main/java/org/openslx/imagemaster/db/DbFtpUser.java
new file mode 100644
index 0000000..ea8a79f
--- /dev/null
+++ b/src/main/java/org/openslx/imagemaster/db/DbFtpUser.java
@@ -0,0 +1,36 @@
+package org.openslx.imagemaster.db;
+
+import java.util.List;
+
+
+public class DbFtpUser
+{
+	public final String username;
+	public final String password;
+	public final String mode;
+	public final String filename;
+	
+	public DbFtpUser(String username, String password, String mode, String filename)
+	{
+		this.username = username;
+		this.password = password;
+		this.mode = mode;
+		this.filename = filename;
+	}
+	
+	public static List<DbFtpUser> getAllUsers()
+	{
+		return MySQL.findAll( DbFtpUser.class, "SELECT username, password, mode, filename from ftpUser" );
+	}
+	
+	public static void addUser(DbFtpUser user)
+	{
+		MySQL.update( "INSERT INTO ftpUser username, password, mode, filename VALUES (? , ?, ?, ?)",
+				user.username, user.password, user.mode, user.filename); 
+	}
+	
+	public static DbFtpUser getUserByName(String username)
+	{
+		return MySQL.findUniqueOrNull( DbFtpUser.class, "SELECT username, password, mode, filename FROM ftpUser WHERE username=?", username );
+	}
+}