import javax.jws.WebService;

import java.sql.*;

import javax.sql.*;

@WebService(endpointInterface = "javasamples.two.Users")

public class UsersImpl implements Users {

public int getUserCount() {

int numusers = 0;

String dbUrl = "jdbc:oracle:thin:@localhost:1521:xe";

String dbClass = "oracle.jdbc.driver.OracleDriver";

String query = "Select count(*) FROM users";

String userName = "yourusername", password = "yourpassword";

try {

Class.forName(dbClass);

Connection con = DriverManager.getConnection (dbUrl, userName, password);

Statement stmt = con.createStatement();

ResultSet rs = stmt.executeQuery(query);

while (rs.next()) {

numusers = rs.getInt(1);

} //end while

con.close();

} //end try

catch(ClassNotFoundException e) {

e.printStackTrace();

}

catch(SQLException e) {

e.printStackTrace();

}

finally {

return numusers;

}

}

}