import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.mysql.jdbc.ResultSetMetaData;
import com.mysql.jdbc.Statement;

public class Connection {

	public static void main(String[] args) {

		String driver="com.mysql.jdbc.Driver";

			try {
				Class.forName(driver);

				java.sql.Connection con=null;
				String url="jdbc:mysql://localhost:3306/emp1";
				String user="root";
				String pwd="";
				java.sql.Statement st=null;
				ResultSet rs=null;
				con=DriverManager.getConnection(url,user,pwd);
				st=con.createStatement();
				String querry="select * from emp1";
				rs=st.executeQuery(querry);
			//	java.sql.ResultSetMetaData rsm=rs.getMetaData();
				//int col=rsm.getColumnCount();

				System.out.println(rs);


				while(rs.next())
				{
//					for(int i=0;i<col;i++)
//					{
						System.out.println(rs.getInt(1)+" "+rs.getString(2)+" "+rs.getInt(3));
					//}

				}

			} catch (ClassNotFoundException | SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}








		}

}