import java.sql.*;

public class TestHome {
	public static void main(String[] a) {
		try {
			//Class.forName("com.mysql.jdbc.Driver").newInstance();
			Connection c = DriverManager.getConnection("jdbc:mysql://localhost:3306","root","SQLRoot");
			Statement s = c.createStatement();
			//*
			s.execute("USE socialnetwork");
			String q = "select * from userinformation";
			s.execute(q);
			ResultSet r = s.getResultSet();
			while (r.next()) {
				System.out.print(r.getString(1));
				System.out.print(r.getString(2));
				System.out.println(r.getString(3));
			}
			//*/
			/*
			String Name;
			String NSID;
			String EMail;
			
			String q1 = "drop table developers;";
			String q2 = "create table developers (nsid = char(6), name = varchar(24), email = varchar(48), primary key(nsid), unique(nsid));";
			String q3 = "insert into developers (nsid, name, email) values (" + NSID + ", " + Name + ", " + EMail + ");";
			*/
		}
		catch(Exception e) {
			System.out.println(e);
		}
		
	}
}