Advertisement
Guest User

Ejemplo DB MySQL

a guest
Aug 16th, 2016
136
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. try
  2. {
  3. Class.forName("com.mysql.jdbc.Driver");
  4. Connection conexion = DriverManager.getConnection ("jdbc:mysql://"+db_host+"/"+db_name,db_user, db_pass);
  5.  
  6. Statement s = conexion.createStatement();
  7. ResultSet rs = s.executeQuery ("SELECT * FROM pnj_cuentas");
  8.  
  9. while(rs.next())
  10. {
  11. System.out.println (rs.getString (1) + " " + rs.getString (2));
  12. }
  13. }
  14. catch (Exception e)
  15. {
  16. System.out.println(e.getMessage());
  17. try
  18. {
  19. Class.forName("com.mysql.jdbc.Driver");
  20. Connection conexion = DriverManager.getConnection ("jdbc:mysql://"+db_host+"/"+db_name,db_user, db_pass);
  21.  
  22. Statement s = conexion.createStatement();
  23. ResultSet rs = s.executeQuery ("SELECT * FROM pnj_cuentas");
  24.  
  25. while(rs.next())
  26. {
  27. System.out.println (rs.getString (1) + " " + rs.getString (2));
  28. }
  29. }
  30. catch (Exception e)
  31. {
  32. System.out.println(e.getMessage());
  33. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement