API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 3rd, 2018
106
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.97 KB | None | 0 0
raw download clone embed print report
  1. package server;
  2. import norme_didactice.INorme_didactice;
  3. import java.rmi.server.UnicastRemoteObject;
  4. // Varianta cu apel rmiregistry direct
  5. import java.rmi.registry.Registry;
  6. import java.rmi.registry.LocateRegistry;
  7. // Varianta JNDI
  8. import javax.naming.Context;
  9. import javax.naming.InitialContext;
  10.  
  11. import java.sql.Connection;
  12. import java.sql.Date;
  13. import java.sql.DriverManager;
  14. import java.sql.ResultSet;
  15.  
  16. public class Norme_didacticeImpl implements INorme_didactice{
  17.  
  18. public String norme_didactice(int a, String inputString){
  19.  
  20. String afisare = "";
  21. String c;
  22. if (a==1){
  23. try {
  24.  
  25. String driver = "org.apache.derby.jdbc.ClientDriver";
  26. String url = "jdbc:derby://localhost:1527/Norme_didactice2 ;";
  27. Class.forName(driver).newInstance();
  28. Connection conn = DriverManager.getConnection(url);
  29.  
  30. java.sql.Statement stmt = conn.createStatement();
  31.  
  32.  
  33.  
  34.  
  35. StringBuilder sb = new StringBuilder();
  36. ArrayList<Integer> ids = new ArrayList<Integer>();
  37.  
  38. //pentru id cadru
  39. String sql="SELECT cadru_didactic.id_cadru FROM cadru_didactic WHERE nume='"+inputString+"' ";
  40. ResultSet rs=instructiune.executeQuery(sql);
  41. int rez_id_cadru=0;
  42. while( rs.next()){
  43. rez_id_cadru=rs.getInt("id_cadru");
  44. }
  45.  
  46. //pentru id materie pe baza id cadru
  47. sql="SELECT curs.idMaterie FROM curs WHERE idCadru="+rez_id_cadru+" ";
  48. rs=instructiune.executeQuery(sql);
  49. while( rs.next()){
  50. int rez_id_materie=rs.getInt("idMaterie");
  51. ids.add(rez_id_materie);
  52. }
  53. //pentru denumire ;
  54. sb.append("Cadrul didactic cu numele " + nume_cadru+", preda: ");
  55. for(Integer s:ids)
  56.  
  57. {
  58. sql="SELECT materie.denumire FROM materie WHERE id_materie="+s+" ";
  59. rs=instructiune.executeQuery(sql);
  60. while( rs.next()){
  61. String denumire=rs.getString("denumire");
  62. sb.append("\n"+denumire);
  63. }
  64.  
  65. }
  66.  
  67. }
  68. afisare=sb.toString();
  69. }
  70. else
  71. if (a==2){
  72. try {
  73.  
  74. String driver = "org.apache.derby.jdbc.ClientDriver";
  75. String url = "jdbc:derby://localhost:1527/Norme_didactice2;";
  76. Class.forName(driver).newInstance();
  77. Connection conn = DriverManager.getConnection(url);
  78.  
  79. java.sql.Statement stmt = conn.createStatement();
  80. StringBuilder sb = new StringBuilder();
  81. ArrayList<Integer> ids = new ArrayList<Integer>();
  82. // pentru intrebarea numarul 2
  83. ids = new ArrayList<Integer>();
  84. //pentru id materie
  85. String sql="SELECT materie.id_materie FROM materie WHERE denumire='"+materie+"' ";
  86. ResultSet rs=instructiune.executeQuery(sql);
  87. int rez_id_materie2=0;
  88. while( rs.next()){
  89. rez_id_materie2=rs.getInt("id_materie");
  90. }
  91.  
  92. //pentru id cadru pe baza id mateire
  93. sql="SELECT curs.idCadru FROM curs WHERE idMaterie="+rez_id_materie2+" ";
  94. rs=instructiune.executeQuery(sql);
  95. while( rs.next()){
  96. int rez_id_cadru=rs.getInt("idCadru");
  97. ids.add(rez_id_cadru);
  98. }
  99. //pentru nume ;
  100. sb.append("\nMateria " + materie+" e predata de: ");
  101. for(Integer s:ids)
  102.  
  103. {
  104. sql="SELECT cadru_didactic.nume FROM cadru_didactic WHERE id_cadru="+s+" ";
  105. rs=instructiune.executeQuery(sql);
  106. while( rs.next()){
  107. String nume=rs.getString("nume");
  108. sb.append("\n"+nume);
  109. }
  110.  
  111. }
  112. }
  113. afisare=sb.toString();
  114. }
  115.  
  116.  
  117. else
  118. return "Aceasta valoare nu exista !";
  119. if (afisare=="")
  120. {
  121. afisare="Nu exista!";
  122. }
  123. return afisare;
  124. }
  125.  
  126. public static void main(String args[]) {
  127. String host="localhost";
  128. int port=1099;
  129. if(args.length>0)
  130. host=args[0];
  131. if(args.length>1)
  132. port=Integer.parseInt(args[1]);
  133. try {
  134. Norme_didacticeImpl obj=new Norme_didacticeImpl();
  135. INorme_didactice stub=(INorme_didactice)UnicastRemoteObject.exportObject(obj,0);
  136.  
  137. // Varianta cu apel rmiregistry direct
  138.  
  139. Registry registry=LocateRegistry.getRegistry(host,port);
  140. registry.bind("Norme_didacticeServer",stub);
  141.  
  142. System.out.println("Norme_didacticeServer ready");
  143. System.out.println("Press CTRL+C to finish !");
  144. //System.in.read();
  145. }
  146. catch (Exception e) {
  147. System.out.println("Norme_didacticeImpl err: " + e.getMessage());
  148. }
  149. }
  150. }
  151.  
  152.  
  153. alta clasa e mai jos
  154.  
  155.  
  156.  
  157.  
  158.  
  159.  
  160.  
  161.  
  162.  
  163.  
  164.  
  165.  
  166.  
  167.  
  168.  
  169.  
  170.  
  171.  
  172.  
  173.  
  174.  
  175.  
  176.  
  177.  
  178.  
  179.  
  180.  
  181.  
  182.  
  183.  
  184.  
  185.  
  186.  
  187. package server;
  188. import norme_didactice.INorme_didactice;
  189. import java.rmi.server.UnicastRemoteObject;
  190. // Varianta cu apel rmiregistry direct
  191. import java.rmi.registry.Registry;
  192. import java.rmi.registry.LocateRegistry;
  193. // Varianta JNDI
  194. import javax.naming.Context;
  195. import javax.naming.InitialContext;
  196.  
  197. import java.sql.Connection;
  198. import java.sql.Date;
  199. import java.sql.DriverManager;
  200. import java.sql.ResultSet;
  201.  
  202. public class Norme_didacticeImpl implements INorme_didactice{
  203.  
  204. public String norme_didactice(int a, String inputString){
  205.  
  206. String afisare = "";
  207. String c;
  208. if (a==1){
  209. try {
  210.  
  211. String driver = "org.apache.derby.jdbc.ClientDriver";
  212. String url = "jdbc:derby://localhost:1527/Norme_didactice7 ;";
  213. Class.forName(driver).newInstance();
  214. Connection conn = DriverManager.getConnection(url);
  215.  
  216. java.sql.Statement stmt = conn.createStatement();
  217.  
  218.  
  219.  
  220.  
  221. StringBuilder sb = new StringBuilder();
  222. ArrayList<Integer> ids = new ArrayList<Integer>();
  223.  
  224. //pentru id cadru
  225. String sql="SELECT cadru_didactic.id_cadru FROM cadru_didactic WHERE nume='"+inputString+"' ";
  226. ResultSet rs=instructiune.executeQuery(sql);
  227. int rez_id_cadru=0;
  228. while( rs.next()){
  229. rez_id_cadru=rs.getInt("id_cadru");
  230. }
  231.  
  232. //pentru id materie pe baza id cadru
  233. sql="SELECT curs.idMaterie FROM curs WHERE idCadru="+rez_id_cadru+" ";
  234. rs=instructiune.executeQuery(sql);
  235. while( rs.next()){
  236. int rez_id_materie=rs.getInt("idMaterie");
  237. ids.add(rez_id_materie);
  238. }
  239. //pentru denumire ;
  240. sb.append("Cadrul didactic cu numele " + nume_cadru+", preda: ");
  241. for(Integer s:ids)
  242.  
  243. {
  244. sql="SELECT materie.denumire FROM materie WHERE id_materie="+s+" ";
  245. rs=instructiune.executeQuery(sql);
  246. while( rs.next()){
  247. String denumire=rs.getString("denumire");
  248. sb.append("\n"+denumire);
  249. }
  250.  
  251. }
  252.  
  253. }
  254. afisare=sb.toString();
  255. }
  256. else
  257. if (a==2){
  258. try {
  259.  
  260. String driver = "org.apache.derby.jdbc.ClientDriver";
  261. String url = "jdbc:derby://localhost:1527/Norme_didactice7;";
  262. Class.forName(driver).newInstance();
  263. Connection conn = DriverManager.getConnection(url);
  264.  
  265. java.sql.Statement stmt = conn.createStatement();
  266. StringBuilder sb = new StringBuilder();
  267. ArrayList<Integer> ids = new ArrayList<Integer>();
  268. // pentru intrebarea numarul 2
  269. ids = new ArrayList<Integer>();
  270. //pentru id materie
  271. String sql="SELECT materie.id_materie FROM materie WHERE denumire='"+materie+"' ";
  272. ResultSet rs=instructiune.executeQuery(sql);
  273. int rez_id_materie2=0;
  274. while( rs.next()){
  275. rez_id_materie2=rs.getInt("id_materie");
  276. }
  277.  
  278. //pentru id cadru pe baza id mateire
  279. sql="SELECT curs.idCadru FROM curs WHERE idMaterie="+rez_id_materie2+" ";
  280. rs=instructiune.executeQuery(sql);
  281. while( rs.next()){
  282. int rez_id_cadru=rs.getInt("idCadru");
  283. ids.add(rez_id_cadru);
  284. }
  285. //pentru nume ;
  286. sb.append("\nMateria " + materie+" e predata de: ");
  287. for(Integer s:ids)
  288.  
  289. {
  290. sql="SELECT cadru_didactic.nume FROM cadru_didactic WHERE id_cadru="+s+" ";
  291. rs=instructiune.executeQuery(sql);
  292. while( rs.next()){
  293. String nume=rs.getString("nume");
  294. sb.append("\n"+nume);
  295. }
  296.  
  297. }
  298. }
  299. afisare=sb.toString();
  300. }
  301.  
  302.  
  303. else
  304. return "Aceasta valoare nu exista !";
  305. if (afisare=="")
  306. {
  307. afisare="Nu exista!";
  308. }
  309. return afisare;
  310. }
  311.  
  312. public static void main(String args[]) {
  313. String host="localhost";
  314. int port=1099;
  315. if(args.length>0)
  316. host=args[0];
  317. if(args.length>1)
  318. port=Integer.parseInt(args[1]);
  319. try {
  320. Norme_didacticeImpl obj=new Norme_didacticeImpl();
  321. INorme_didactice stub=(INorme_didactice)UnicastRemoteObject.exportObject(obj,0);
  322.  
  323. // Varianta cu apel rmiregistry direct
  324.  
  325. Registry registry=LocateRegistry.getRegistry(host,port);
  326. registry.bind("Norme_didacticeServer",stub);
  327.  
  328. System.out.println("Norme_didacticeServer ready");
  329. System.out.println("Press CTRL+C to finish !");
  330. //System.in.read();
  331. }
  332. catch (Exception e) {
  333. System.out.println("Norme_didacticeImpl err: " + e.getMessage());
  334. }
  335. }
  336. }
  337.  
  338.  
  339. asta la RMI
  340.  
  341.  
  342.  
  343.  
  344.  
  345. import norme_didactice.INorme_didactice;
  346. import java.rmi.server.UnicastRemoteObject;
  347. // Varianta cu apel rmiregistry direct
  348. import java.rmi.registry.Registry;
  349. import java.rmi.registry.LocateRegistry;
  350. // Varianta JNDI
  351. import javax.naming.Context;
  352. import javax.naming.InitialContext;
  353.  
  354. import java.sql.Connection;
  355. import java.sql.Date;
  356. import java.sql.DriverManager;
  357. import java.sql.ResultSet;
  358.  
  359. public class Norme_didacticeImpl implements INorme_didactice{
  360.  
  361. public String norme_didactice(int a, String inputString){
  362.  
  363. String afisare = "";
  364. String c;
  365. if (a==1){
  366. try {
  367.  
  368. String driver = "org.apache.derby.jdbc.ClientDriver";
  369. String url = "jdbc:derby://localhost:1527/Norme_didactice7 ;";
  370. Class.forName(driver).newInstance();
  371. Connection conn = DriverManager.getConnection(url);
  372.  
  373. java.sql.Statement stmt = conn.createStatement();
  374.  
  375.  
  376.  
  377.  
  378. StringBuilder sb = new StringBuilder();
  379. ArrayList<Integer> ids = new ArrayList<Integer>();
  380.  
  381. //pentru id cadru
  382. String sql="SELECT cadru_didactic.id_cadru FROM cadru_didactic WHERE nume='"+inputString+"' ";
  383. ResultSet rs=instructiune.executeQuery(sql);
  384. int rez_id_cadru=0;
  385. while( rs.next()){
  386. rez_id_cadru=rs.getInt("id_cadru");
  387. }
  388.  
  389. //pentru id materie pe baza id cadru
  390. sql="SELECT curs.idMaterie FROM curs WHERE idCadru="+rez_id_cadru+" ";
  391. rs=instructiune.executeQuery(sql);
  392. while( rs.next()){
  393. int rez_id_materie=rs.getInt("idMaterie");
  394. ids.add(rez_id_materie);
  395. }
  396. //pentru denumire ;
  397. sb.append("Cadrul didactic cu numele " + nume_cadru+", preda: ");
  398. for(Integer s:ids)
  399.  
  400. {
  401. sql="SELECT materie.denumire FROM materie WHERE id_materie="+s+" ";
  402. rs=instructiune.executeQuery(sql);
  403. while( rs.next()){
  404. String denumire=rs.getString("denumire");
  405. sb.append("\n"+denumire);
  406. }
  407.  
  408. }
  409.  
  410. }
  411. catch (Exception e) {
  412. System.out.println("Norme_didacticeImpl err: " + e.getMessage());
  413. }
  414. afisare=sb.toString();
  415. }
  416. else
  417. if (a==2){
  418. try {
  419.  
  420. String driver = "org.apache.derby.jdbc.ClientDriver";
  421. String url = "jdbc:derby://localhost:1527/Norme_didactice7;";
  422. Class.forName(driver).newInstance();
  423. Connection conn = DriverManager.getConnection(url);
  424.  
  425. java.sql.Statement stmt = conn.createStatement();
  426. StringBuilder sb = new StringBuilder();
  427. ArrayList<Integer> ids = new ArrayList<Integer>();
  428. // pentru intrebarea numarul 2
  429. ids = new ArrayList<Integer>();
  430. //pentru id materie
  431. String sql="SELECT materie.id_materie FROM materie WHERE denumire='"+materie+"' ";
  432. ResultSet rs=instructiune.executeQuery(sql);
  433. int rez_id_materie2=0;
  434. while( rs.next()){
  435. rez_id_materie2=rs.getInt("id_materie");
  436. }
  437.  
  438. //pentru id cadru pe baza id mateire
  439. sql="SELECT curs.idCadru FROM curs WHERE idMaterie="+rez_id_materie2+" ";
  440. rs=instructiune.executeQuery(sql);
  441. while( rs.next()){
  442. int rez_id_cadru=rs.getInt("idCadru");
  443. ids.add(rez_id_cadru);
  444. }
  445. //pentru nume ;
  446. sb.append("\nMateria " + materie+" e predata de: ");
  447. for(Integer s:ids)
  448.  
  449. {
  450. sql="SELECT cadru_didactic.nume FROM cadru_didactic WHERE id_cadru="+s+" ";
  451. rs=instructiune.executeQuery(sql);
  452. while( rs.next()){
  453. String nume=rs.getString("nume");
  454. sb.append("\n"+nume);
  455. }
  456.  
  457. }
  458. }
  459. catch (Exception e) {
  460. System.out.println("Norme_didacticeImpl err: " + e.getMessage());
  461. }
  462. afisare=sb.toString();
  463. }
  464.  
  465.  
  466. else
  467. return "Aceasta valoare nu exista !";
  468. if (afisare=="")
  469. {
  470. afisare="Nu exista!";
  471. }
  472. return afisare;
  473. }
  474.  
  475. public static void main(String args[]) {
  476. String host="localhost";
  477. int port=1099;
  478. if(args.length>0)
  479. host=args[0];
  480. if(args.length>1)
  481. port=Integer.parseInt(args[1]);
  482. try {
  483. Norme_didacticeImpl obj=new Norme_didacticeImpl();
  484. INorme_didactice stub=(INorme_didactice)UnicastRemoteObject.exportObject(obj,0);
  485.  
  486. // Varianta cu apel rmiregistry direct
  487.  
  488. Registry registry=LocateRegistry.getRegistry(host,port);
  489. registry.bind("Norme_didacticeServer",stub);
  490.  
  491. System.out.println("Norme_didacticeServer ready");
  492. System.out.println("Press CTRL+C to finish !");
  493. //System.in.read();
  494. }
  495. catch (Exception e) {
  496. System.out.println("Norme_didacticeImpl err: " + e.getMessage());
  497. }
  498. }
  499. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!