package lab9;

//import javax.swing.JMenu;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.mysql.jdbc.Statement;

class MainApp{
	public static void main(String []args)
			throws SQLException, InstantiationException, IllegalAccessException, ClassNotFoundException{
		String url = "jdbc:mysql://localhost:3306/test";
		Statement sql;
		ResultSet rs;
		Class.forName("com.mysql.jdbc.Driver").newInstance ();
		Connection con = DriverManager.getConnection(url, "root", "root");
		sql =  (Statement) con.createStatement();
		rs = sql.executeQuery("select * from Persoane");
		while(rs.next())
			System.out.println("ID="+rs.getInt("ID")+", Nume= "+ rs.getString("Nume")+ ",  Varsta="+rs.getInt(3));
		 MyFrm frm=new MyFrm(sql);
		 frm.setVisible(true);
		con.close();
		rs.close();
	}
}