diff options
author | tspitzer | 2013-11-28 14:04:30 +0100 |
---|---|---|
committer | tspitzer | 2013-11-28 14:04:30 +0100 |
commit | 2e0a5b912180b44338612969cca7cced89f8d637 (patch) | |
tree | 889369abe71ec129637e0688a677a71d0779967a /Dozentenmodulserver/src/sql/SQL.java | |
parent | -Anpassen der Texte (diff) | |
download | tutor-module-2e0a5b912180b44338612969cca7cced89f8d637.tar.gz tutor-module-2e0a5b912180b44338612969cca7cced89f8d637.tar.xz tutor-module-2e0a5b912180b44338612969cca7cced89f8d637.zip |
Dozentenmodulserver initales check-in
Diffstat (limited to 'Dozentenmodulserver/src/sql/SQL.java')
-rw-r--r-- | Dozentenmodulserver/src/sql/SQL.java | 49 |
1 files changed, 49 insertions, 0 deletions
diff --git a/Dozentenmodulserver/src/sql/SQL.java b/Dozentenmodulserver/src/sql/SQL.java new file mode 100644 index 00000000..c3582527 --- /dev/null +++ b/Dozentenmodulserver/src/sql/SQL.java @@ -0,0 +1,49 @@ +package sql;
+
+import java.sql.Connection;
+import java.sql.DriverManager;
+import java.sql.SQLException;
+import java.sql.Statement;
+
+
+public class SQL {
+
+ public Connection getConnection()
+ {
+ try {
+ Class.forName("com.mysql.jdbc.Driver").newInstance();
+ } catch (InstantiationException | IllegalAccessException
+ | ClassNotFoundException e) {
+ // TODO Auto-generated catch block
+ e.printStackTrace();
+ }
+ try {
+ Connection con=DriverManager.getConnection("jdbc:mysql://127.0.0.1/bwLehrpool?user=root&password=slx-ng-open");
+ con.setAutoCommit(false);
+ return con;
+ } catch (SQLException e) {
+ // TODO Auto-generated catch block
+ e.printStackTrace();
+ }
+ return null;
+ }
+
+ public int writeFTPUser(Connection con,String user, String pass)
+ {
+ Statement stm;
+ try {
+ stm=con.createStatement();
+
+ int ret=stm.executeUpdate("INSERT INTO `bwLehrpool`.`FtpUsers`(`User`,`Password`,`Dir`)VALUES('"+user+"','"+pass+"','/');");
+ con.commit();
+ return ret;
+ } catch (SQLException e) {
+ // TODO Auto-generated catch block
+ e.printStackTrace();
+ }
+ return -1;
+ }
+
+
+
+}
|