import java.sql.*;

/**
 * Created by jv-2-3 on 22.06.2016.
 */
public class ConnectDBMySQLSingleton {
    public ConnectDBMySQLSingleton() {
        try {
            Connection con = DriverManager.getConnection("jdbc:mysql://localhost/SGjava_2", "root", "");
//            PreparedStatement preparedStatement = con.prepareStatement("INSERT INTO users(name, skill, age) VALUES (?,?,?)");
//            preparedStatement.setString(1, "Ivan");
//            preparedStatement.setString(2, "student");
//            preparedStatement.setString(3, "18");
//            preparedStatement.executeUpdate();
            Statement statement = con.createStatement();
            ResultSet resultSet =  statement.executeQuery("SELECT NAME FROM users");

            while (resultSet.next()) {
                System.out.println(resultSet.getString("name"));
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}