From 98cfa2231cb0931fd1d3f6d6582becfd359881f9 Mon Sep 17 00:00:00 2001 From: Nils Schwabe Date: Thu, 5 Jun 2014 12:34:12 +0200 Subject: Started to implement download of images --- .../java/org/openslx/imagemaster/db/DbFtpUser.java | 36 ++++++++++++++++++++++ 1 file changed, 36 insertions(+) create mode 100644 src/main/java/org/openslx/imagemaster/db/DbFtpUser.java (limited to 'src/main/java/org/openslx/imagemaster/db/DbFtpUser.java') 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 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 ); + } +} -- cgit v1.2.3-55-g7522