Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.*;
- import java.sql.Connection;
- import java.sql.Statement;
- public class DatabaseConnectionClass {
- public static void main (String[] args) {
- new DatabaseConnectionClass(args);
- }
- public DatabaseConnectionClass(String[] args) {
- try {
- Class.forName("com.mysql.jdbc.Driver").newInstance();
- String url = "jdbc:mysql://132.199.139.24 :3306/mmdb17_robertbosek?user=r.bosek&password=mmdb";
- Connection Verbindung = DriverManager.getConnection(url);
- Statement SQLStatement = Verbindung.createStatement();
- if (args.length == 3) {
- String SQLString = new String("INSERT INTO Fahrer VALUES " + "(" + args[0] + ",'" + args[1] + "'," + args[2] + ");");
- SQLStatement.executeUpdate(SQLString);
- }
- String SQLString = new String("SELECT * FROM Fahrer");
- ResultSet Ergebnis = SQLStatement.executeQuery(SQLString);
- while(Ergebnis.next()) {
- System.out.println(Ergebnis.getString("Name") + " " + Ergebnis.getString("PersNr"));
- }
- Verbindung.close();
- }
- catch (ClassNotFoundException e) {
- System.err.print("Klasse nicht gefunden.");
- }
- catch (SQLException e) {
- System.err.print("SQL-Ausnahme: ");
- System.err.println(e.getMessage());
- }
- catch (Exception e) {
- System.err.print("Ein-/Ausgabefehler");
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement