package com.MyTest; import javax.jws.WebMethod; import javax.jws.WebParam; import javax.jws.WebService; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; //import java.sql.*; /** * * @author welhezi */ @WebService() public class WSTestsql { /** * Web service operation */ @WebMethod(operationName = "mod_pw") public String mod_pw(@WebParam(name = "ident") String ident, @WebParam(name = "anciennepw") String anciennepw, @WebParam(name = "nouvpw1") String nouvpw1, @WebParam(name = "nouvpw2") String nouvpw2) { //TODO write your implementation code here: String rq, res="erreur "; Connection con =null; Statement stmt=null; ResultSet rs=null; String url, pilote ; int mod= 0; try{ pilote ="com.mysql.jdbc.Driver"; Class.forName(pilote); } catch(ClassNotFoundException e) { } try{ url="jdbc:mysql://localhost:3306/test"; con=DriverManager.getConnection(url,"adminh","admint"); }catch(Exception e) {} if(nouvpw2.equals(nouvpw1)) { rq="update utilisateurs set mot_pass='"+nouvpw1 +"' where identifiant='"+ident+"' and mot_pass='"+ anciennepw+"'"; try{ stmt=con.createStatement(); mod = stmt.executeUpdate(rq); if(mod>0) res="félicitation , vous avez changer votre mot de passe"; else res="Le changement de mot de passe a échoué. "; }catch(SQLException e) { } } try{ stmt.close(); System.out.println("close stmt"); con.close(); System.out.println("close con"); }catch (SQLException e) {} return res; } }
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question