Advertisement
pascal25565

MySql Temp(pascal25565)

Jul 27th, 2016
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.16 KB | None | 0 0
  1. import java.sql.Connection;
  2. import java.sql.DriverManager;
  3. import java.sql.ResultSet;
  4. import java.sql.SQLException;
  5. import java.sql.Statement;
  6. import java.util.Scanner;
  7.  
  8. public class main {
  9.  
  10. static Scanner s = new Scanner(System.in);
  11.  
  12. final static String hostname = "";
  13. final static String port = "";
  14. final static String dbname = "";
  15. final static String user = "";
  16. final static String password = "";
  17. static Connection con = null;
  18. private static Statement statement = null;
  19. private static ResultSet resultSet = null;
  20.  
  21. public static void main(String[] args) {
  22. System.out.println("Möchtest du Verbinden?");
  23. String abfrage = s.nextLine();
  24. if (abfrage.equalsIgnoreCase("ja")) {
  25. Verbindung();
  26. }
  27. }
  28.  
  29. public static void Verbindung() {
  30. try {
  31. System.out.println("Datenbank: Treiber laden.");
  32. Class.forName("org.gjt.mm.mysql.Driver").newInstance();
  33. } catch (Exception e) {
  34. System.err.println("Datenbank: Fehlgeschlagen!");
  35. }
  36. try {
  37. System.out.println("Datenbank: Verbind wird hergestellt.");
  38. String url = "jdbc:mysql://" + hostname + ":" + port + "/" + dbname;
  39. con = DriverManager.getConnection(url, user, password);
  40. System.out.println("Datenbank: Verbindung erfolgreich.");
  41.  
  42. statement = con.createStatement();
  43. resultSet = statement.executeQuery("SELECT * from VaroX");
  44. writeResultSet(resultSet);
  45. } catch (SQLException sq) {
  46. System.out.println("SQLException: " + sq.getMessage());
  47. System.out.println("SQLState: " + sq.getSQLState());
  48. System.out.println("VendorError: " + sq.getErrorCode());
  49. sq.printStackTrace();
  50. close();
  51. }
  52. }
  53.  
  54. private static void writeResultSet(ResultSet resultSet) throws SQLException {
  55. while (resultSet.next()) {
  56. String name = resultSet.getString("name");
  57. String passwort = resultSet.getString("passwort");
  58. System.out.println("Name: " + name);
  59. System.out.println("Passwort: " + passwort);
  60. }
  61. }
  62.  
  63. private static void close() {
  64. try {
  65. if (resultSet != null) {
  66. resultSet.close();
  67. }
  68.  
  69. if (statement != null) {
  70. statement.close();
  71. }
  72.  
  73. if (con != null) {
  74. con.close();
  75. }
  76. } catch (Exception e) {
  77.  
  78. }
  79. }
  80.  
  81. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement