From 5559990807740a5bdd10dbacfe390e07987a7a33 Mon Sep 17 00:00:00 2001
From: Tobias Spitzer
Date: Mon, 25 Aug 2014 09:56:04 +0200
Subject: CheckExist

---
 Dozentenmodulserver/src/sql/SQL.java | 27 +++++++++++++++++++++++++++
 1 file changed, 27 insertions(+)

(limited to 'Dozentenmodulserver/src/sql')

diff --git a/Dozentenmodulserver/src/sql/SQL.java b/Dozentenmodulserver/src/sql/SQL.java
index a60cef59..3ba59923 100644
--- a/Dozentenmodulserver/src/sql/SQL.java
+++ b/Dozentenmodulserver/src/sql/SQL.java
@@ -867,4 +867,31 @@ public class SQL {
 		}
 		return null;
 	}
+	
+	public boolean checkUser(String username) {
+		Statement stm;
+		boolean ret=false;
+		try {
+			Connection con=getConnection();
+			stm = con.createStatement();
+			ResultSet rs=stm.executeQuery("Select * from m_user where loginName like '"+username+"'");
+			if(rs.next())
+			{
+				ret=true;
+				log.info(new Date() + " - User " + rs.getString("loginName") + " exist.");
+			}
+			else{
+				ret=false;
+				log.info(new Date() + " - User " + rs.getString("loginName") + " not exist.");
+			}
+			con.close();
+			
+			
+		} catch (SQLException e) {
+			// TODO Auto-generated catch block
+			
+			e.printStackTrace();
+		}
+		return ret;
+	}
 }
-- 
cgit v1.2.3-55-g7522