Auf Thema antworten

Nachricht

[Java]Connection myCon;
Statement myStmt;

try {

Class.forName("com.mysql.jdbc.Driver").newInstance();

myCon = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/pizzaservice", "root",
"");

myStmt = myCon.createStatement();

myStmt.executeUpdate("INSERT INTO pizzaservice "
+ "VALUES ( ' " + nachname.getText() + " ' , ' "
+ ort.getText() + " ' , ' " + straße.getText()
+ " ' , ' " + telefonnummer.getText()
+ " ' , ' " + KundennummerTemp + "'");

ResultSet result = myStmt
.executeQuery("SELECT * FROM pizzaservice");
result.next();
KundennummerTemp = result.getInt( "Kundennummer:" ); // hier wird die Kundennummer ausgelesen
KundennummerTemp = KundennummerTemp + 1;

while (result.next()) {

System.out.println(result.getString("Nachname:"));

}
myCon.close();

} catch (Exception sqlEx) {
System.err.println(sqlEx);
System.out.println("SQL Fehler");

} [/code]

<blockquote data-quote="TryToProg" data-source="post: 983500" data-attributes="member: 38820">[Java]Connection myCon;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Statement myStmt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; try {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Class.forName(&quot;com.mysql.jdbc.Driver&quot;).newInstance();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; myCon = DriverManager.getConnection(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;jdbc:mysql://localhost:3306/pizzaservice&quot;, &quot;root&quot;,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; myStmt = myCon.createStatement();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; myStmt.executeUpdate(&quot;INSERT INTO pizzaservice &quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; + &quot;VALUES ( ' &quot; + nachname.getText() + &quot; ' , ' &quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; + ort.getText() + &quot; ' , ' &quot; + straße.getText()&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; + &quot; ' , ' &quot; + telefonnummer.getText()&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; + &quot; ' , ' &quot; + KundennummerTemp + &quot;'&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ResultSet result = myStmt&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .executeQuery(&quot;SELECT * FROM pizzaservice&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; result.next();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; KundennummerTemp = result.getInt( &quot;Kundennummer:&quot; );&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // hier wird die Kundennummer ausgelesen&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; KundennummerTemp = KundennummerTemp + 1;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while (result.next()) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; System.out.println(result.getString(&quot;Nachname:&quot;));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; myCon.close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } catch (Exception sqlEx) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; System.err.println(sqlEx);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; System.out.println(&quot;SQL Fehler&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } [/code]</blockquote>

[QUOTE="TryToProg, post: 983500, member: 38820"] [Java]Connection myCon; Statement myStmt; try { Class.forName("com.mysql.jdbc.Driver").newInstance(); myCon = DriverManager.getConnection( "jdbc:mysql://localhost:3306/pizzaservice", "root", ""); myStmt = myCon.createStatement(); myStmt.executeUpdate("INSERT INTO pizzaservice " + "VALUES ( ' " + nachname.getText() + " ' , ' " + ort.getText() + " ' , ' " + straße.getText() + " ' , ' " + telefonnummer.getText() + " ' , ' " + KundennummerTemp + "'"); ResultSet result = myStmt .executeQuery("SELECT * FROM pizzaservice"); result.next(); KundennummerTemp = result.getInt( "Kundennummer:" ); // hier wird die Kundennummer ausgelesen KundennummerTemp = KundennummerTemp + 1; while (result.next()) { System.out.println(result.getString("Nachname:")); } myCon.close(); } catch (Exception sqlEx) { System.err.println(sqlEx); System.out.println("SQL Fehler"); } [/code] [/QUOTE]

Verifizierung