diff options
| author | Tobias Spitzer | 2014-08-25 09:56:04 +0200 |
|---|---|---|
| committer | Tobias Spitzer | 2014-08-25 09:56:04 +0200 |
| commit | 5559990807740a5bdd10dbacfe390e07987a7a33 (patch) | |
| tree | cdac47008e24b2516efdacbb3342624898c00dbc /Dozentenmodulserver/src/sql/SQL.java | |
| parent | Model für Rechte hinzugefügt (diff) | |
| download | tutor-module-5559990807740a5bdd10dbacfe390e07987a7a33.tar.gz tutor-module-5559990807740a5bdd10dbacfe390e07987a7a33.tar.xz tutor-module-5559990807740a5bdd10dbacfe390e07987a7a33.zip | |
CheckExist
Diffstat (limited to 'Dozentenmodulserver/src/sql/SQL.java')
| -rw-r--r-- | Dozentenmodulserver/src/sql/SQL.java | 27 |
1 files changed, 27 insertions, 0 deletions
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;
+ }
}
|