diff options
| author | unknown | 2014-04-04 09:30:30 +0200 |
|---|---|---|
| committer | unknown | 2014-04-04 09:30:30 +0200 |
| commit | 7b8534417cc4cf7d2e6d6dcb0988ad688fc7999c (patch) | |
| tree | a99584b0a8b42c59d1121f51d187e33ecba6b370 /Dozentenmodulserver/src/sql | |
| parent | Bearbeiten von Images funktioniert nun vollständig (diff) | |
| download | tutor-module-7b8534417cc4cf7d2e6d6dcb0988ad688fc7999c.tar.gz tutor-module-7b8534417cc4cf7d2e6d6dcb0988ad688fc7999c.tar.xz tutor-module-7b8534417cc4cf7d2e6d6dcb0988ad688fc7999c.zip | |
neue Version
Diffstat (limited to 'Dozentenmodulserver/src/sql')
| -rw-r--r-- | Dozentenmodulserver/src/sql/SQL.java | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/Dozentenmodulserver/src/sql/SQL.java b/Dozentenmodulserver/src/sql/SQL.java index a93f35b0..f28fdd67 100644 --- a/Dozentenmodulserver/src/sql/SQL.java +++ b/Dozentenmodulserver/src/sql/SQL.java @@ -205,6 +205,20 @@ public class SQL { return null;
}
+ public ResultSet getLectureList(Connection con){
+ try {
+ Statement stm=con.createStatement();
+
+ return stm.executeQuery("SELECT l.lectureID, l.name, l.isActive,l.startTime,l.endTime,l.lastUsed,l.description, i.image_name, concat(u.Nachname,' ',u.Vorname) as user FROM bwLehrpool.m_VLData_lecture l, bwLehrpool.m_VLData_imageInfo i, bwLehrpool.m_user u where i.GUID_imageID=l.imageID and l.admin_owner=u.userID;");
+
+
+ } catch (SQLException e) {
+ // TODO Auto-generated catch block
+ e.printStackTrace();
+ }
+ return null;
+ }
+
public ResultSet getAllOS(Connection con)
{
|