From 695c870f18e5cecfe8da7033c8db7c9c70a42c4d Mon Sep 17 00:00:00 2001
From: tspitzer
Date: Mon, 30 Sep 2013 11:40:02 +0200
Subject: working

---
 Dozentenmodul/src/sql/sql.java | 12 ++++++------
 1 file changed, 6 insertions(+), 6 deletions(-)

(limited to 'Dozentenmodul/src/sql/sql.java')

diff --git a/Dozentenmodul/src/sql/sql.java b/Dozentenmodul/src/sql/sql.java
index 35e09615..813900cc 100644
--- a/Dozentenmodul/src/sql/sql.java
+++ b/Dozentenmodul/src/sql/sql.java
@@ -19,7 +19,7 @@ public class sql {
 			e.printStackTrace();
 		}		
 		try {
-			Connection con=DriverManager.getConnection("jdbc:mysql://132.230.4.16/bwLehrpool?user=root&password=12wil$on");
+			Connection con=DriverManager.getConnection("jdbc:mysql://132.230.4.16/bwLehrpool?user=bwlpuser&password=armag3ddon");
 			return con;
 		} catch (SQLException e) {
 			// TODO Auto-generated catch block
@@ -34,7 +34,7 @@ public class sql {
 		Statement stm;
 		try {
 			stm = con.createStatement();
-			return stm.executeQuery("SELECT distinct Produktname, Version, Architektur FROM bwlehrpool.betriebssystem order by Produktname asc;");
+			return stm.executeQuery("SELECT distinct Produktname, Version, Architektur FROM bwLehrpool.Betriebssystem order by Produktname asc;");
 		} catch (SQLException e) {
 			// TODO Auto-generated catch block
 			e.printStackTrace();
@@ -55,7 +55,7 @@ public class sql {
 			{
 				addHersteller(con, Hersteller);
 			}			
-			int ret=stm.executeUpdate("INSERT INTO `bwlehrpool`.`betriebssystem`(`Produktname`,`Version`,`Architektur`,`IstKostenlos`,`SWHersteller_pk`)VALUES('"+name+"','"+Version+"','"+Architektur+"',"+Kosten+","+pk_Hersteller+");");
+			int ret=stm.executeUpdate("INSERT INTO `bwLehrpool`.`Betriebssystem`(`Produktname`,`Version`,`Architektur`,`IstKostenlos`,`SWHersteller_pk`)VALUES('"+name+"','"+Version+"','"+Architektur+"',"+Kosten+","+pk_Hersteller+");");
 			return ret;
 		} catch (SQLException e) {
 			// TODO Auto-generated catch block
@@ -103,8 +103,8 @@ public class sql {
 		int ret=-1;
 		try {
 			stm=con.createStatement();
-			ret=stm.executeUpdate("INSERT INTO `bwlehrpool`.`swhersteller`(`Name`)VALUES('"+Name+"');");
-			con.commit();
+			ret=stm.executeUpdate("INSERT INTO `bwLehrpool`.`SWHersteller`(`Name`)VALUES('"+Name+"');");
+			//con.commit();
 		} catch (SQLException e) {
 			// TODO Auto-generated catch block
 			
@@ -166,7 +166,7 @@ public class sql {
 			{
 				addHersteller(con, Hersteller);
 			}			
-			int ret=stm.executeUpdate("INSERT INTO `bwlehrpool`.`software`(`Produktname`,`Version`,`Architektur`,`IstKostenlos`,`SWHersteller_pk`)VALUES('"+name+"','"+Version+"','"+Architektur+"',"+Kosten+","+pk_Hersteller+");");
+			int ret=stm.executeUpdate("INSERT INTO `bwLehrpool`.`Software`(`Produktname`,`Version`,`Architektur`,`IstKostenlos`,`SWHersteller_pk`)VALUES('"+name+"','"+Version+"','"+Architektur+"',"+Kosten+","+pk_Hersteller+");");
 			return ret;
 		} catch (SQLException e) {
 			// TODO Auto-generated catch block
-- 
cgit v1.2.3-55-g7522