diff options
| author | tspitzer | 2013-09-30 11:40:02 +0200 |
|---|---|---|
| committer | tspitzer | 2013-09-30 11:40:02 +0200 |
| commit | 695c870f18e5cecfe8da7033c8db7c9c70a42c4d (patch) | |
| tree | bb861dd3e22b81a4d2a65dffa8fcc20a34ba94c5 /Dozentenmodul/src/sql | |
| parent | db (diff) | |
| download | tutor-module-695c870f18e5cecfe8da7033c8db7c9c70a42c4d.tar.gz tutor-module-695c870f18e5cecfe8da7033c8db7c9c70a42c4d.tar.xz tutor-module-695c870f18e5cecfe8da7033c8db7c9c70a42c4d.zip | |
working
Diffstat (limited to 'Dozentenmodul/src/sql')
| -rw-r--r-- | Dozentenmodul/src/sql/sql.java | 12 |
1 files changed, 6 insertions, 6 deletions
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
|