Guest User

Untitled

a guest
Sep 8th, 2018
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.75 KB | None | 0 0
  1. Android database conectivity problem
  2. public class ConnectionClass {
  3.  
  4.  
  5. static String user = "root";
  6.  
  7.  
  8. public static void main() {
  9. String url = "jdbc:mysql://127.0.0.1:3306/mydatabase";
  10. // String url = "jdbc:mysql://10.2.5.69:3306/test";
  11. try {
  12. Class.forName("com.mysql.jdbc.Driver");
  13.  
  14. ***Connection con = DriverManager.getConnection(url, user, "mypassword");***
  15. con.isReadOnly();
  16. System.out.println("success");
  17. Statement st = con.createStatement();
  18. ResultSet rs = st.executeQuery("select * from user");
  19. while (rs.next()) {
  20. System.out.println("id" + rs.getInt(1));
  21. System.out.println("data" + rs.getString(2));
  22. }
  23.  
  24. } catch (Exception e) {
  25. e.printStackTrace();
  26. }
  27. }
Add Comment
Please, Sign In to add comment