بتاريخ: 5 أغسطس 201213 سنة comment_226677 السلام عليكم انا عملت WEB SERVICES عن طريق JDeveloper & Oracleواريد ان اقوم بربط WEB SERVICES مع صفحة JSF كيف اعملكود الويب سيرفيس package pak; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import javax.jws.Oneway; import javax.jws.WebMethod; import javax.jws.WebParam; import javax.jws.WebService; import java.sql.*; @WebService public class Service_Hopital { @WebMethod(operationName = "ajouter_pat") public String ajouter_pat(@WebParam(name = "NOM_PATIENT") String NOM_PATIENT, @WebParam(name = "PRENOM_PATIENT") String PRENOM_PATIENT, @WebParam(name = "ADRESSE") String ADRESSE, @WebParam(name = "SEXE") String SEXE, @WebParam(name = "DATE_NAISSANCE") String DATE_NAISSANCE, @WebParam(name = "LIEU_NAISSANCE") String LIEU_NAISSANCE, @WebParam(name = "TELEPHONE") String TELEPHONE, @WebParam(name = "NUM_SECURITE_SOCIAL") String NUM_SECURITE_SOCIAL, @WebParam(name = "SITUATION_FAMILIAL") String SITUATION_FAMILIAL, @WebParam(name = "PROFESSION") String PROFESSION, @WebParam(name = "ETAT") String ETAT ) { Connection connection; Statement statement; ResultSet result; try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); } catch(Exception e){} try{ connection = DriverManager.getConnection("jdbc:odbc:ORC_Library","system","123456"); statement = connection.createStatement(); if ((NOM_PATIENT == null)||(PRENOM_PATIENT==null) ||( ADRESSE== null) ||( SEXE== null) ||(DATE_NAISSANCE == null) ||(LIEU_NAISSANCE == null) ||(TELEPHONE == null) ||( NUM_SECURITE_SOCIAL== null) ||(SITUATION_FAMILIAL == null) ||( PROFESSION== null) ||( ETAT== null) ){} else{ statement.executeUpdate("INSERT INTO patient VALUES ('','"+NOM_PATIENT+"' ,'"+PRENOM_PATIENT+"' ,'"+ADRESSE+"' ,'"+SEXE+"' , '"+DATE_NAISSANCE+"' , '"+LIEU_NAISSANCE+"' , '"+TELEPHONE+"' , '"+NUM_SECURITE_SOCIAL+"' ,'"+SITUATION_FAMILIAL+"' ,'"+PROFESSION+"' ,'"+ETAT+"' )"); }} catch (SQLException e) { e.printStackTrace(); } return null; } @WebMethod(operationName = "DeletePatient") public String DeletePatient(@WebParam(name = "NOM_PATIENT") String NOM_PATIENT ) { { Connection connection; Statement statement; ResultSet result; try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); } catch(Exception e){} try{ connection = DriverManager.getConnection("jdbc:odbc:ORC_Library","system","123456"); statement = connection.createStatement(); statement.executeUpdate("delete from patient where patient.NOM_PATIENT='"+NOM_PATIENT+"'"); statement.close(); connection.close(); } catch(SQLException ex) { System.err.println("==> SQLException: "); while (ex != null) { System.out.println("Message: " + ex.getMessage ()); System.out.println("SQLState: " + ex.getSQLState ()); System.out.println("ErrorCode: " + ex.getErrorCode ()); ex = ex.getNextException(); System.out.println(""); } } return null; } }} اسم القاعدة PATIENTعناصر القاعدة ID_PATIENT مفتاح يتزايد بشكل اليNOM_PATIENT,PRENOM_PATIENT,ADRESSE,SEXE,DATE_NAISSANCE,LIEU_NAISSANCE,TELEPHONE,NUM_SECURITE_SOCIAL,SITUATION_FAMILIAL,PROFESSION,ETATوالف تحية :o شكرااااااااااااااااااااااااااااااااااااااااااااااااا تقديم بلاغ
انضم إلى المناقشة
يمكنك المشاركة الآن والتسجيل لاحقاً. إذا كان لديك حساب, سجل دخولك الآن لتقوم بالمشاركة من خلال حسابك.