Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- import java.util.Scanner;
- public class main {
- static Scanner s = new Scanner(System.in);
- final static String hostname = "";
- final static String port = "";
- final static String dbname = "";
- final static String user = "";
- final static String password = "";
- static Connection con = null;
- private static Statement statement = null;
- private static ResultSet resultSet = null;
- public static void main(String[] args) {
- System.out.println("Möchtest du Verbinden?");
- String abfrage = s.nextLine();
- if (abfrage.equalsIgnoreCase("ja")) {
- Verbindung();
- }
- }
- public static void Verbindung() {
- try {
- System.out.println("Datenbank: Treiber laden.");
- Class.forName("org.gjt.mm.mysql.Driver").newInstance();
- } catch (Exception e) {
- System.err.println("Datenbank: Fehlgeschlagen!");
- }
- try {
- System.out.println("Datenbank: Verbind wird hergestellt.");
- String url = "jdbc:mysql://" + hostname + ":" + port + "/" + dbname;
- con = DriverManager.getConnection(url, user, password);
- System.out.println("Datenbank: Verbindung erfolgreich.");
- statement = con.createStatement();
- resultSet = statement.executeQuery("SELECT * from VaroX");
- writeResultSet(resultSet);
- } catch (SQLException sq) {
- System.out.println("SQLException: " + sq.getMessage());
- System.out.println("SQLState: " + sq.getSQLState());
- System.out.println("VendorError: " + sq.getErrorCode());
- sq.printStackTrace();
- close();
- }
- }
- private static void writeResultSet(ResultSet resultSet) throws SQLException {
- while (resultSet.next()) {
- String name = resultSet.getString("name");
- String passwort = resultSet.getString("passwort");
- System.out.println("Name: " + name);
- System.out.println("Passwort: " + passwort);
- }
- }
- private static void close() {
- try {
- if (resultSet != null) {
- resultSet.close();
- }
- if (statement != null) {
- statement.close();
- }
- if (con != null) {
- con.close();
- }
- } catch (Exception e) {
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement