Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.*;
- public class test {
- public static void main(String[] args) {
- String dbUser = "root";
- String dbPass = "12345678";
- String url = "jdbc:mysql://localhost/YodaFitness?useSSL=false";
- Connection connection = null;
- try
- {
- Class.forName("com.mysql.jdbc.Driver");
- connection = DriverManager.getConnection(url,dbUser, dbPass);
- String query = "SELECT * FROM MEDLEM";
- Statement statement = connection.createStatement();
- ResultSet resultSet = statement.executeQuery(query);
- while (resultSet.next()) {
- String name = resultSet.getString("navn");
- System.out.println(name);
- }
- statement.close();
- }
- catch (ClassNotFoundException e)
- {
- e.printStackTrace();
- System.exit(1);
- }
- catch (SQLException e)
- {
- e.printStackTrace();
- System.exit(2);
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement