DER FUHRER08 de Noviembre del 2005
Preguntaa ver... el codigo es muy simple, no tiene errores o al menos no los veo... qien me puede decir què hacer porq me sale este error al intentar recuperar el primer campo y no corre el procedimiento!!!!
public void loadData (int userID,Connection cn) {
String sql ="select VSMusers.userID, userName,userEmail,userAddress, userTelephone, userPassword from VSMusers where userID =" + String.valueOf(userID) ;
System.out.println(sql);
try{
Statement stmt = cn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
rs.next();
mvarUserName= rs.getString(0);
mvarUserEmail=rs.getString(1);
this.UserAddress(rs.getString(2));
this.UserTelephone(rs.getString(3));
this.UserPassword(rs.getString(4));
}
catch(SQLException e){
System.out.println(e.getMessage());
}
}
public void loadData (int userID,Connection cn) {
String sql ="select VSMusers.userID, userName,userEmail,userAddress, userTelephone, userPassword from VSMusers where userID =" + String.valueOf(userID) ;
System.out.println(sql);
try{
Statement stmt = cn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
rs.next();
mvarUserName= rs.getString(0);
mvarUserEmail=rs.getString(1);
this.UserAddress(rs.getString(2));
this.UserTelephone(rs.getString(3));
this.UserPassword(rs.getString(4));
}
catch(SQLException e){
System.out.println(e.getMessage());
}
}
