Advertisement
Guest User

Untitled

a guest
Feb 18th, 2019
134
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.59 KB | None | 0 0
  1. import java.sql.*;  
  2.  
  3. public class app {
  4.  
  5.     public static void main(String[] args) {
  6.         try {  
  7.             Class.forName("com.mysql.jdbc.Driver");  
  8.             Connection con= DriverManager.getConnection(  
  9.             "jdbc:mysql://csmysql.cs.cf.ac.uk","c1883100","auzAc5h4R3r3jKJ");  
  10.            
  11.             Statement stmt = con.createStatement();  
  12.             ResultSet rs = stmt.executeQuery("select * from c1883100.Users");  
  13.             while(rs.next()) {
  14.                 System.out.println(rs.getInt(1)+"  "+rs.getString(2)+"  "+rs.getString(3));  
  15.             }
  16.             con.close();
  17.         }
  18.         catch (Exception e) {
  19.             System.out.println(e);
  20.         }  
  21.     }  
  22. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement