import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.*;
class j2_app {
public static void main (String[] args) {
int menueingabe, sid, uid;
char t_input;
String tabelle, sname, ip, er, user, pass;
menueingabe = 0;
t_input = ' ';
while (menueingabe != 5) {
do {
System.out.println ("1 Datensatz anlegen\n2 Datensatz bearbeiten\n3 Datensatz loeschen\n4 Tabelle anzeigen\n5 Programm beenden\n");
try {
menueingabe = eingabe.readInt("Ihre Wahl:");
}
catch (NumberFormatException e) {
System.out.println("NumberFormatException in main");
}
} while ((menueingabe != 1) && (menueingabe != 2) && (menueingabe != 3) && (menueingabe != 4) && (menueingabe != 5));
if (menueingabe != 5) {
do {
System.out.println ("Tabelle:\ns server\nu user\n");
t_input = eingabe.readChar ("Ihre Wahl:");
} while ((t_input != ('s')) && (t_input != ('u')));
switch (t_input){
case 's' : tabelle = "server"; break;
case 'u' : tabelle = "user"; break;
default: tabelle = "not_defined";
System.out.println ("caught");
}
switch (menueingabe) {
case 1: System.out.println("eins");
System.out.println (tabelle);
if (t_input=='s') { //Datensatz anlegen *server*
System.out.println ("Datensatz anlegen in Tabelle \'server\'");
er = eingabe.readString("");
System.out.println();
sname = eingabe.readString ("url:");
System.out.println ("url:" + sname);
ip = eingabe.readString ("ip:");
System.out.println ("ip:" + ip);
try {
// The newInstance() call is a work around for some
// broken Java implementations
Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (Exception ex) {
// handle the error
System.out.println ("driverconnection failed...");
}
Connection conn = null;
Statement stmt = null;
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jtest?" + "user=root");
// Do something with the Connection
try {
stmt = conn.createStatement();
try {
stmt.executeUpdate("INSERT INTO server (url, ip) VALUES ('" + sname + "', '" + ip + "')" );
} finally {
try { stmt.close(); } catch (Throwable ignore) { System.out.println ("stmt.close() failed"); } /* Propagate the original exception instead of this one that you may want just logged */
}
} finally {
//It's important to close the connection when you are done with it
try { conn.close(); } catch (Throwable ignore) { System.out.println ("conn.close() failed"); } /* Propagate the original exception instead of this one that you may want just logged */
}
} catch (SQLException ex) {
// handle any errors
System.out.println("SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("VendorError: " + ex.getErrorCode());
}
System.out.println ("written to database");
}
else { //Datensatz anlegen *user*
System.out.println("Datensatz anlegen in Tabelle \'user\'");
try {
// The newInstance() call is a work around for some
// broken Java implementations
Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (Exception ex) {
// handle the error
System.out.println ("driverconnection failed...");
}
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jtest?" + "user=root");
// Do something with the Connection
try {
stmt = conn.createStatement();
try {
rs = stmt.executeQuery( "SELECT sid, url FROM server" );
int j = 1;
try {
while ( rs.next() ) {
int numColumns = rs.getMetaData().getColumnCount();
System.out.println (j);
for ( int i = 1 ; i <= numColumns ; i++ ) {
String columnName = rs.getMetaData().getColumnName(i);
// Column numbers start at 1.
// Also there are many methods on the result set to return
// the column as a particular type. Refer to the Sun documentation
// for the list of valid conversions.
System.out.println( "COLUMN " + i + " " + columnName + "\t" + " = " + rs.getObject(i) );
}
j++;
}
} finally {
try { rs.close(); } catch (Throwable ignore) { System.out.println ("rs.close() failed"); } /* Propagate the original exception instead of this one that you may want just logged */
}
} finally {
try { stmt.close(); } catch (Throwable ignore) { System.out.println ("stmt.close() failed"); } /* Propagate the original exception instead of this one that you may want just logged */
}
} finally { //It's important to close the connection when you are done with it
try { conn.close(); } catch (Throwable ignore) { System.out.println ("conn.close() failed"); } /* Propagate the original exception
instead of this one that you may want just logged */
}
} catch (SQLException ex) {
// handle any errors
System.out.println("SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("VendorError: " + ex.getErrorCode());
}
er = eingabe.readString("");
System.out.println();
sid = eingabe.readInt ("serverzuordnung(sid):");
System.out.println("sid:" + sid);
user = eingabe.readString ("user:");
System.out.println("user:" + user);
pass = eingabe.readString ("password:");
System.out.println("password:" + pass);
try {
// The newInstance() call is a work around for some
// broken Java implementations
Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (Exception ex) {
// handle the error
System.out.println ("driverconnection failed...");
}
conn = null;
stmt = null;
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jtest?" + "user=root");
// Do something with the Connection
try {
stmt = conn.createStatement();
try {
stmt.executeUpdate("INSERT INTO user (sid, user, password) VALUES (" + sid + ", '" + user + "', '" + pass + "')" );
} finally {
try { stmt.close(); } catch (Throwable ignore) { System.out.println ("stmt.close() failed"); } /* Propagate the original exception instead of this one that you may want just logged */
}
} finally {
//It's important to close the connection when you are done with it
try { conn.close(); } catch (Throwable ignore) { System.out.println ("conn.close() failed"); } /* Propagate the original exception instead of this one that you may want just logged */
}
} catch (SQLException ex) {
// handle any errors
System.out.println("SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("VendorError: " + ex.getErrorCode());
}
System.out.println ("written to database");
}
break;
case 2: System.out.println ("zwei");
System.out.println (tabelle);
if (t_input=='s') { //Datensatz bearbeiten *server*
System.out.println("Datensatz bearbeiten \'server\'");
try {
// The newInstance() call is a work around for some
// broken Java implementations
Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (Exception ex) {
// handle the error
System.out.println ("driverconnection failed...");
}
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jtest?" + "user=root");
// Do something with the Connection
try {
stmt = conn.createStatement();
try {
rs = stmt.executeQuery( "SELECT sid, url, ip FROM server" );
int j = 1;
try {
while ( rs.next() ) {
int numColumns = rs.getMetaData().getColumnCount();
System.out.println (j);
for ( int i = 1 ; i <= numColumns ; i++ ) {
String columnName = rs.getMetaData().getColumnName(i);
// Column numbers start at 1.
// Also there are many methods on the result set to return
// the column as a particular type. Refer to the Sun documentation
// for the list of valid conversions.
System.out.println( "COLUMN " + i + " " + columnName + "\t" + " = " + rs.getObject(i) );
}
j++;
}
} finally {
try { rs.close(); } catch (Throwable ignore) { System.out.println ("rs.close() failed"); } /* Propagate the original exception instead of this one that you may want just logged */
}
} finally {
try { stmt.close(); } catch (Throwable ignore) { System.out.println ("stmt.close() failed"); } /* Propagate the original exception instead of this one that you may want just logged */
}
} finally { //It's important to close the connection when you are done with it
try { conn.close(); } catch (Throwable ignore) { System.out.println ("conn.close() failed"); } /* Propagate the original exception
instead of this one that you may want just logged */
}
} catch (SQLException ex) {
// handle any errors
System.out.println("SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("VendorError: " + ex.getErrorCode());
}
er = eingabe.readString("");
System.out.println();
sid = eingabe.readInt("Bearbeite sid:");
System.out.println("sid:" + sid);
sname = eingabe.readString("neues Feld url:");
System.out.println("url:" + sname);
ip = eingabe.readString("neues Feld ip:");
System.out.println("ip:" + ip);
try {
// The newInstance() call is a work around for some
// broken Java implementations
Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (Exception ex) {
// handle the error
System.out.println ("driverconnection failed...");
}
conn = null;
stmt = null;
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jtest?" + "user=root");
// Do something with the Connection
try {
stmt = conn.createStatement();
try {
stmt.executeUpdate("UPDATE server SET url = '" + sname + "', ip = '" + ip + "' WHERE sid = '" + sid + "'");
} finally {
try { stmt.close(); } catch (Throwable ignore) { System.out.println ("stmt.close() failed"); } /* Propagate the original exception instead of this one that you may want just logged */
}
} finally {
//It's important to close the connection when you are done with it
try { conn.close(); } catch (Throwable ignore) { System.out.println ("conn.close() failed"); } /* Propagate the original exception instead of this one that you may want just logged */
}
} catch (SQLException ex) {
// handle any errors
System.out.println("SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("VendorError: " + ex.getErrorCode());
}
System.out.println ("written to database");
}
else { //Datensatz bearbeiten *user*
System.out.println("Datensatz bearbeiten \'user\'");
try {
// The newInstance() call is a work around for some
// broken Java implementations
Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (Exception ex) {
// handle the error
System.out.println ("driverconnection failed...");
}
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jtest?" + "user=root");
// Do something with the Connection
try {
stmt = conn.createStatement();
try {
rs = stmt.executeQuery( "SELECT uid, user FROM user" );
int j = 1;
try {
while ( rs.next() ) {
int numColumns = rs.getMetaData().getColumnCount();
System.out.println (j);
for ( int i = 1 ; i <= numColumns ; i++ ) {
String columnName = rs.getMetaData().getColumnName(i);
// Column numbers start at 1.
// Also there are many methods on the result set to return
// the column as a particular type. Refer to the Sun documentation
// for the list of valid conversions.
System.out.println( "COLUMN " + i + " " + columnName + "\t" + " = " + rs.getObject(i) );
}
j++;
}
} finally {
try { rs.close(); } catch (Throwable ignore) { System.out.println ("rs.close() failed"); } /* Propagate the original exception instead of this one that you may want just logged */
}
} finally {
try { stmt.close(); } catch (Throwable ignore) { System.out.println ("stmt.close() failed"); } /* Propagate the original exception instead of this one that you may want just logged */
}
} finally { //It's important to close the connection when you are done with it
try { conn.close(); } catch (Throwable ignore) { System.out.println ("conn.close() failed"); } /* Propagate the original exception
instead of this one that you may want just logged */
}
} catch (SQLException ex) {
// handle any errors
System.out.println("SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("VendorError: " + ex.getErrorCode());
}
er = eingabe.readString("");
System.out.println();
uid = eingabe.readInt("Bearbeite uid:");
System.out.println("uid:" + uid);
try {
// The newInstance() call is a work around for some
// broken Java implementations
Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (Exception ex) {
// handle the error
System.out.println ("driverconnection failed...");
}
conn = null;
stmt = null;
rs = null;
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jtest?" + "user=root");
// Do something with the Connection
try {
stmt = conn.createStatement();
try {
rs = stmt.executeQuery( "SELECT sid, url FROM server" );
int j = 1;
try {
while ( rs.next() ) {
int numColumns = rs.getMetaData().getColumnCount();
System.out.println (j);
for ( int i = 1 ; i <= numColumns ; i++ ) {
String columnName = rs.getMetaData().getColumnName(i);
// Column numbers start at 1.
// Also there are many methods on the result set to return
// the column as a particular type. Refer to the Sun documentation
// for the list of valid conversions.
System.out.println( "COLUMN " + i + " " + columnName + "\t" + " = " + rs.getObject(i) );
}
j++;
}
} finally {
try { rs.close(); } catch (Throwable ignore) { System.out.println ("rs.close() failed"); } /* Propagate the original exception instead of this one that you may want just logged */
}
} finally {
try { stmt.close(); } catch (Throwable ignore) { System.out.println ("stmt.close() failed"); } /* Propagate the original exception instead of this one that you may want just logged */
}
} finally { //It's important to close the connection when you are done with it
try { conn.close(); } catch (Throwable ignore) { System.out.println ("conn.close() failed"); } /* Propagate the original exception
instead of this one that you may want just logged */
}
} catch (SQLException ex) {
// handle any errors
System.out.println("SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("VendorError: " + ex.getErrorCode());
}
sid = eingabe.readInt("neues Feld sid:");
System.out.println("sid:" + sid);
user = eingabe.readString("neues Feld user:");
System.out.println("user:" + user);
pass = eingabe.readString("neues Feld password:");
System.out.println("password:" + pass);
try {
// The newInstance() call is a work around for some
// broken Java implementations
Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (Exception ex) {
// handle the error
System.out.println ("driverconnection failed...");
}
conn = null;
stmt = null;
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jtest?" + "user=root");
// Do something with the Connection
try {
stmt = conn.createStatement();
try {
stmt.executeUpdate("UPDATE user SET sid = '" + sid + "', user = '" + user + "', password = '" + pass + "' WHERE uid = '" + uid + "'");
} finally {
try { stmt.close(); } catch (Throwable ignore) { System.out.println ("stmt.close() failed"); } /* Propagate the original exception instead of this one that you may want just logged */
}
} finally {
//It's important to close the connection when you are done with it
try { conn.close(); } catch (Throwable ignore) { System.out.println ("conn.close() failed"); } /* Propagate the original exception instead of this one that you may want just logged */
}
} catch (SQLException ex) {
// handle any errors
System.out.println("SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("VendorError: " + ex.getErrorCode());
}
System.out.println ("written to database");
}
break;
case 3: System.out.println ("drei");
System.out.println (tabelle);
if (t_input=='s') { //Datensatz loeschen *server*
try {
// The newInstance() call is a work around for some
// broken Java implementations
Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (Exception ex) {
// handle the error
System.out.println ("driverconnection failed...");
}
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jtest?" + "user=root");
// Do something with the Connection
try {
stmt = conn.createStatement();
try {
rs = stmt.executeQuery( "SELECT sid, url, ip FROM server" );
int j = 1;
try {
while ( rs.next() ) {
int numColumns = rs.getMetaData().getColumnCount();
System.out.println (j);
for ( int i = 1 ; i <= numColumns ; i++ ) {
String columnName = rs.getMetaData().getColumnName(i);
// Column numbers start at 1.
// Also there are many methods on the result set to return
// the column as a particular type. Refer to the Sun documentation
// for the list of valid conversions.
System.out.println( "COLUMN " + i + " " + columnName + "\t" + " = " + rs.getObject(i) );
}
j++;
}
} finally {
try { rs.close(); } catch (Throwable ignore) { System.out.println ("rs.close() failed"); } /* Propagate the original exception instead of this one that you may want just logged */
}
} finally {
try { stmt.close(); } catch (Throwable ignore) { System.out.println ("stmt.close() failed"); } /* Propagate the original exception instead of this one that you may want just logged */
}
} finally { //It's important to close the connection when you are done with it
try { conn.close(); } catch (Throwable ignore) { System.out.println ("conn.close() failed"); } /* Propagate the original exception
instead of this one that you may want just logged */
}
} catch (SQLException ex) {
// handle any errors
System.out.println("SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("VendorError: " + ex.getErrorCode());
}
er = eingabe.readString("");
System.out.println();
sid = eingabe.readInt("loeschen(sid):");
System.out.println("sid:" + sid);
try {
// The newInstance() call is a work around for some
// broken Java implementations
Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (Exception ex) {
// handle the error
System.out.println ("driverconnection failed...");
}
conn = null;
stmt = null;
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jtest?" + "user=root");
// Do something with the Connection
try {
stmt = conn.createStatement();
try {
stmt.executeUpdate("DELETE FROM server WHERE sid = '" + sid + "'");
} finally {
try { stmt.close(); } catch (Throwable ignore) { System.out.println ("stmt.close() failed"); } /* Propagate the original exception instead of this one that you may want just logged */
}
} finally {
//It's important to close the connection when you are done with it
try { conn.close(); } catch (Throwable ignore) { System.out.println ("conn.close() failed"); } /* Propagate the original exception instead of this one that you may want just logged */
}
} catch (SQLException ex) {
// handle any errors
System.out.println("SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("VendorError: " + ex.getErrorCode());
}
System.out.println ("deleted from database");
}
else { //Datensatz loeschen *user*
try {
// The newInstance() call is a work around for some
// broken Java implementations
Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (Exception ex) {
// handle the error
System.out.println ("driverconnection failed...");
}
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jtest?" + "user=root");
// Do something with the Connection
try {
stmt = conn.createStatement();
try {
rs = stmt.executeQuery( "SELECT uid, sid, user, password FROM user" );
int j = 1;
try {
while ( rs.next() ) {
int numColumns = rs.getMetaData().getColumnCount();
System.out.println (j);
for ( int i = 1 ; i <= numColumns ; i++ ) {
String columnName = rs.getMetaData().getColumnName(i);
// Column numbers start at 1.
// Also there are many methods on the result set to return
// the column as a particular type. Refer to the Sun documentation
// for the list of valid conversions.
System.out.println( "COLUMN " + i + " " + columnName + "\t" + " = " + rs.getObject(i) );
}
j++;
}
} finally {
try { rs.close(); } catch (Throwable ignore) { System.out.println ("rs.close() failed"); } /* Propagate the original exception instead of this one that you may want just logged */
}
} finally {
try { stmt.close(); } catch (Throwable ignore) { System.out.println ("stmt.close() failed"); } /* Propagate the original exception instead of this one that you may want just logged */
}
} finally { //It's important to close the connection when you are done with it
try { conn.close(); } catch (Throwable ignore) { System.out.println ("conn.close() failed"); } /* Propagate the original exception
instead of this one that you may want just logged */
}
} catch (SQLException ex) {
// handle any errors
System.out.println("SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("VendorError: " + ex.getErrorCode());
}
er = eingabe.readString("");
System.out.println();
uid = eingabe.readInt("loeschen(uid):");
System.out.println("uid:" + uid);
try {
// The newInstance() call is a work around for some
// broken Java implementations
Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (Exception ex) {
// handle the error
System.out.println ("driverconnection failed...");
}
conn = null;
stmt = null;
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jtest?" + "user=root");
// Do something with the Connection
try {
stmt = conn.createStatement();
try {
stmt.executeUpdate("DELETE FROM user WHERE uid = '" + uid + "'");
} finally {
try { stmt.close(); } catch (Throwable ignore) { System.out.println ("stmt.close() failed"); } /* Propagate the original exception instead of this one that you may want just logged */
}
} finally {
//It's important to close the connection when you are done with it
try { conn.close(); } catch (Throwable ignore) { System.out.println ("conn.close() failed"); } /* Propagate the original exception instead of this one that you may want just logged */
}
} catch (SQLException ex) {
// handle any errors
System.out.println("SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("VendorError: " + ex.getErrorCode());
}
System.out.println ("deleted from database");
}
break;
case 4: System.out.println ("vier");
System.out.println (tabelle);
if (t_input=='s') { //Tabelle anzeigen *server*
try {
// The newInstance() call is a work around for some
// broken Java implementations
Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (Exception ex) {
// handle the error
System.out.println ("driverconnection failed...");
}
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jtest?" + "user=root");
// Do something with the Connection
try {
stmt = conn.createStatement();
try {
rs = stmt.executeQuery( "SELECT sid, url, ip FROM server" );
int j = 1;
try {
while ( rs.next() ) {
int numColumns = rs.getMetaData().getColumnCount();
System.out.println (j);
for ( int i = 1 ; i <= numColumns ; i++ ) {
String columnName = rs.getMetaData().getColumnName(i);
// Column numbers start at 1.
// Also there are many methods on the result set to return
// the column as a particular type. Refer to the Sun documentation
// for the list of valid conversions.
System.out.println( "COLUMN " + i + " " + columnName + "\t" + " = " + rs.getObject(i) );
}
j++;
}
} finally {
try { rs.close(); } catch (Throwable ignore) { System.out.println ("rs.close() failed"); } /* Propagate the original exception instead of this one that you may want just logged */
}
} finally {
try { stmt.close(); } catch (Throwable ignore) { System.out.println ("stmt.close() failed"); } /* Propagate the original exception instead of this one that you may want just logged */
}
} finally { //It's important to close the connection when you are done with it
try { conn.close(); } catch (Throwable ignore) { System.out.println ("conn.close() failed"); } /* Propagate the original exception
instead of this one that you may want just logged */
}
} catch (SQLException ex) {
// handle any errors
System.out.println("SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("VendorError: " + ex.getErrorCode());
}
}
else { //Tabelle anzeigen *user*
try {
// The newInstance() call is a work around for some
// broken Java implementations
Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (Exception ex) {
// handle the error
System.out.println ("driverconnection failed...");
}
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jtest?" + "user=root");
// Do something with the Connection
try {
stmt = conn.createStatement();
try {
rs = stmt.executeQuery( "SELECT uid, sid, user, password FROM user" );
int j = 1;
try {
while ( rs.next() ) {
int numColumns = rs.getMetaData().getColumnCount();
System.out.println (j);
for ( int i = 1 ; i <= numColumns ; i++ ) {
String columnName = rs.getMetaData().getColumnName(i);
// Column numbers start at 1.
// Also there are many methods on the result set to return
// the column as a particular type. Refer to the Sun documentation
// for the list of valid conversions.
System.out.println( "COLUMN " + i + " " + columnName + "\t" + " = " + rs.getObject(i) );
}
j++;
}
} finally {
try { rs.close(); } catch (Throwable ignore) { System.out.println ("rs.close() failed"); } /* Propagate the original exception instead of this one that you may want just logged */
}
} finally {
try { stmt.close(); } catch (Throwable ignore) { System.out.println ("stmt.close() failed"); } /* Propagate the original exception instead of this one that you may want just logged */
}
} finally { //It's important to close the connection when you are done with it
try { conn.close(); } catch (Throwable ignore) { System.out.println ("conn.close() failed"); } /* Propagate the original exception
instead of this one that you may want just logged */
}
} catch (SQLException ex) {
// handle any errors
System.out.println("SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("VendorError: " + ex.getErrorCode());
}
}
break;
default: System.out.println("caught");
}
}
if (menueingabe != 5) { er = eingabe.readString (""); }
System.out.println();
}
System.out.println ("Programm wird beendet");
}
}
Solid Experiments 