Advertisement
Guest User

Untitled

a guest
Mar 13th, 2019
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.87 KB | None | 0 0
  1. import java.sql.*;
  2.  
  3.  
  4. public class BaseDAT {
  5.  
  6. public static void main(String[] args) throws ClassNotFoundException, SQLException {
  7. Class.forName("com.mysql.jdbc.Driver");
  8. Connection conn = null;
  9. conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mdbtest?useSSL=false","root", "root");
  10. Statement statement = conn.createStatement();
  11. //statement.executeUpdate("drop table bans");
  12. ResultSet resultSet = statement.executeQuery("select * from users");
  13. while (resultSet.next()){
  14. System.out.println(resultSet.getInt(1));
  15. System.out.println(resultSet.getString(2));
  16. System.out.println(resultSet.getInt(3));
  17. System.out.println(resultSet.getString(4));
  18. System.out.println("-----------------");
  19.  
  20. }
  21.  
  22. resultSet.close();
  23. conn.close();
  24.  
  25. }
  26. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement