From 2e0a5b912180b44338612969cca7cced89f8d637 Mon Sep 17 00:00:00 2001
From: tspitzer
Date: Thu, 28 Nov 2013 14:04:30 +0100
Subject: Dozentenmodulserver initales check-in

---
 Dozentenmodulserver/src/sql/SQL.java | 49 ++++++++++++++++++++++++++++++++++++
 1 file changed, 49 insertions(+)
 create mode 100644 Dozentenmodulserver/src/sql/SQL.java

(limited to 'Dozentenmodulserver/src/sql')

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;
+	}
+	
+
+
+}
-- 
cgit v1.2.3-55-g7522