public static User getUser(String userCode) {
String sql = "CALL getUser('" + userCode + "')";
ResultSet rs = execute(sql);
User u = null;
if (rs != null) {
try {
while (rs.next()) {
u = new User();
u.setUserCode(rs.getString(1));
u.setPassWord(rs.getString(2));
u.setUserDescription(rs.getString(3));
u.setUserEmail(rs.getString(4));
u.setActive(rs.getInt(5));
u.setRole(getRole(rs.getInt(6)));
setUserRessources(u);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();