public String norme_didactice(int a, String inputString){

	String afisare = "";
		String c;
		if (a==1){
			try {

			String driver = "org.apache.derby.jdbc.ClientDriver";
			String url = "jdbc:derby://localhost:1527/Norme_didactice2 ;";
			Class.forName(driver).newInstance();
			Connection conn = DriverManager.getConnection(url);

			java.sql.Statement stmt = conn.createStatement();




			StringBuilder sb = new StringBuilder();
			ArrayList<Integer> ids = new ArrayList<Integer>();

			//pentru id cadru
			String sql="SELECT cadru_didactic.id_cadru FROM cadru_didactic WHERE nume='"+inputString+"' ";
			ResultSet rs=instructiune.executeQuery(sql);
			int rez_id_cadru=0;
			while( rs.next()){
				rez_id_cadru=rs.getInt("id_cadru");
			}

			//pentru id materie pe baza id cadru
			sql="SELECT curs.idMaterie FROM curs WHERE idCadru="+rez_id_cadru+" ";
			rs=instructiune.executeQuery(sql);
			while( rs.next()){
				int rez_id_materie=rs.getInt("idMaterie");
				ids.add(rez_id_materie);
			}
			//pentru denumire ;
			sb.append("Cadrul didactic cu numele " + nume_cadru+", preda: ");
			for(Integer s:ids)

				{
			sql="SELECT materie.denumire FROM materie WHERE id_materie="+s+" ";
			rs=instructiune.executeQuery(sql);
			while( rs.next()){
				String denumire=rs.getString("denumire");
				sb.append("\n"+denumire);
			}

				}

			}
			afisare=sb.toString();
		}
		else
		if (a==2){
			try {

			String driver = "org.apache.derby.jdbc.ClientDriver";
			String url = "jdbc:derby://localhost:1527/Norme_didactice2;";
			Class.forName(driver).newInstance();
			Connection conn = DriverManager.getConnection(url);

			java.sql.Statement stmt = conn.createStatement();
				  StringBuilder sb = new StringBuilder();
		  		ArrayList<Integer> ids = new ArrayList<Integer>();
// pentru intrebarea numarul 2
		ids = new ArrayList<Integer>();
		//pentru id materie
			String sql="SELECT materie.id_materie FROM materie WHERE denumire='"+materie+"' ";
		ResultSet	 rs=instructiune.executeQuery(sql);
			int  rez_id_materie2=0;
		while( rs.next()){
				rez_id_materie2=rs.getInt("id_materie");
			}

		//pentru id cadru pe baza id mateire
		sql="SELECT curs.idCadru FROM curs WHERE idMaterie="+rez_id_materie2+" ";
		rs=instructiune.executeQuery(sql);
			while( rs.next()){
				int rez_id_cadru=rs.getInt("idCadru");
				ids.add(rez_id_cadru);
			}
//pentru nume ;
		sb.append("\nMateria " + materie+" e predata de: ");
			for(Integer s:ids)

				{
sql="SELECT cadru_didactic.nume FROM cadru_didactic WHERE id_cadru="+s+" ";
		rs=instructiune.executeQuery(sql);
			while( rs.next()){
				String nume=rs.getString("nume");
				sb.append("\n"+nume);
			}

				}
		    }
			afisare=sb.toString();
		}


		else
			return "Aceasta valoare nu exista !";
		if (afisare=="")
		{
			afisare="Nu exista!";
		}
		return afisare;
    }