Advertisement
Guest User

Untitled

a guest
Feb 12th, 2017
110
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.81 KB | None | 0 0
  1. import java.sql.*;  
  2.  
  3. public class DBConnector
  4. {
  5.     public static void main(String args[])
  6.     {
  7.        
  8.         try
  9.         {  
  10.             Class.forName("com.mysql.jdbc.Driver");  //173.54.255.46
  11.            
  12.             String url = "jdbc:mysql://photodropp.com/admin/phpMyAdmin/index.php?token=0be56748245f0ad9aa25b2c5d1e6bc1f/dropp";
  13.             String username = "jacob";
  14.             String pass = "isgay";
  15.            
  16.             System.out.println("before");
  17.             Connection con=DriverManager.getConnection(url,username,pass);  
  18.             System.out.println("before");
  19.             Statement stmt=con.createStatement();  
  20.            
  21.            
  22.             ResultSet rs=stmt.executeQuery("select * from emp");  
  23.            
  24.             while(rs.next())
  25.             {
  26.                 System.out.println(rs.getInt(1)+"  "+rs.getString(2)+"  "+rs.getString(3));
  27.             }
  28.             con.close();  
  29.         }
  30.         catch(Exception e)
  31.         {
  32.             System.out.println(e);
  33.         }  
  34.     }  
  35. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement