dkim18
asked on
select statements in the methods
Anybody see anything wrong for the following two method(select statements)? It doesn’t seem to work…
+++++++++++++++
public void getStairManagement(String StairManagementId, StairManagement sm){
//String sql="SELECT stair_management_id" +
String sql="SELECT stair_management_id" +
",visit_id" +
",total_steps" +
",flights" +
",steps_per_flight" +
",assistance" +
",gait_pattern" +
",handrail" +
",comments" +
" FROM stair_management" +
" WHERE stair_management_id =" + StairManagementId;
ResultSet rs = null;
Statement stmt = null;
try {
stmt=conn.createStatement( );
rs=stmt.executeQuery(sql);
if(rs.next()){
sm.setStairManagementId("s tair_manag ement_id") ;
sm.setVisitId(rs.getString ("visit_id "));
sm.setStepsTotal(rs.getStr ing("total _steps"));
sm.setFlights(rs.getString ("flights" ));
sm.setStepsPerFlight(rs.ge tString("s teps_per_f light"));
sm.setAssistance(rs.getStr ing("assis tance"));
sm.setGaitPattern(rs.getSt ring("gait _pattern") );
sm.setHandrail(rs.getStrin g("handrai l"));
sm.setComments(rs.getStrin g("comment s"));
}
rs.close();
} catch (SQLException e) {
log.error(sql + "\n"+e);
}finally{
if(stmt!=null){
try {
stmt.close();
} catch (SQLException e1) {
log.error(e1);
}
}
}//end try/catch
System.out.println("rs : "+ rs);
}//end get
public StairManagement[] getStairManagements(String visitId){
String sql="SELECT stair_management_id" +
",total_steps" +
",flights" +
",steps_per_flight" +
",assistance" +
",gait_pattern" +
",handrail" +
",comments" +
" FROM stair_management" +
" WHERE visit_id =" + visitId;
ResultSet rs = null;
Statement stmt = null;
StairManagement[] sms=null;
try {
stmt=conn.createStatement( );
rs=stmt.executeQuery(sql);
if(!rs.isBeforeFirst()){
stmt.close();
return null;
}
ArrayList al =new ArrayList();
while(rs.next()){
StairManagement sm = new StairManagement();
sm.setStairManagementId(rs .getString ("stair_ma nagement_i d"));
sm.setStepsTotal(rs.getStr ing("total _steps"));
sm.setFlights(rs.getString ("flights" ));
sm.setStepsPerFlight(rs.ge tString("s teps_per_f light"));
sm.setAssistance(rs.getStr ing("assis tance"));
sm.setGaitPattern(rs.getSt ring("gait _pattern") );
sm.setHandrail(rs.getStrin g("handrai l"));
sm.setComments(rs.getStrin g("comment s"));
al.add(sm);
}//end loop
rs.close();
sms=(StairManagement[])al. toArray(ne w StairManagement[al.size()] );
} catch (SQLException e) {
log.error(sql + "\n"+e);
}finally{
if(stmt!=null){
try {
stmt.close();
} catch (SQLException e1) {
log.error(e1);
}
}
}//end try/catch
return sms;
}//end get
+++++++++++++++
public void getStairManagement(String StairManagementId, StairManagement sm){
//String sql="SELECT stair_management_id" +
String sql="SELECT stair_management_id" +
",visit_id" +
",total_steps" +
",flights" +
",steps_per_flight" +
",assistance" +
",gait_pattern" +
",handrail" +
",comments" +
" FROM stair_management" +
" WHERE stair_management_id =" + StairManagementId;
ResultSet rs = null;
Statement stmt = null;
try {
stmt=conn.createStatement(
rs=stmt.executeQuery(sql);
if(rs.next()){
sm.setStairManagementId("s
sm.setVisitId(rs.getString
sm.setStepsTotal(rs.getStr
sm.setFlights(rs.getString
sm.setStepsPerFlight(rs.ge
sm.setAssistance(rs.getStr
sm.setGaitPattern(rs.getSt
sm.setHandrail(rs.getStrin
sm.setComments(rs.getStrin
}
rs.close();
} catch (SQLException e) {
log.error(sql + "\n"+e);
}finally{
if(stmt!=null){
try {
stmt.close();
} catch (SQLException e1) {
log.error(e1);
}
}
}//end try/catch
System.out.println("rs : "+ rs);
}//end get
public StairManagement[] getStairManagements(String
String sql="SELECT stair_management_id" +
",total_steps" +
",flights" +
",steps_per_flight" +
",assistance" +
",gait_pattern" +
",handrail" +
",comments" +
" FROM stair_management" +
" WHERE visit_id =" + visitId;
ResultSet rs = null;
Statement stmt = null;
StairManagement[] sms=null;
try {
stmt=conn.createStatement(
rs=stmt.executeQuery(sql);
if(!rs.isBeforeFirst()){
stmt.close();
return null;
}
ArrayList al =new ArrayList();
while(rs.next()){
StairManagement sm = new StairManagement();
sm.setStairManagementId(rs
sm.setStepsTotal(rs.getStr
sm.setFlights(rs.getString
sm.setStepsPerFlight(rs.ge
sm.setAssistance(rs.getStr
sm.setGaitPattern(rs.getSt
sm.setHandrail(rs.getStrin
sm.setComments(rs.getStrin
al.add(sm);
}//end loop
rs.close();
sms=(StairManagement[])al.
} catch (SQLException e) {
log.error(sql + "\n"+e);
}finally{
if(stmt!=null){
try {
stmt.close();
} catch (SQLException e1) {
log.error(e1);
}
}
}//end try/catch
return sms;
}//end get
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
That 2nd one closes the result set in the finally block too....just to be sure ;-)
What errors do you get?
What errors do you get?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Well spotted! :-D
ASKER
Still nothing working...
no errors or exceptions...
no errors or exceptions...
Is the code running?
Try putting System.out.println( "XX" ) ; messages at relevant points
Does the SQL give you results if you type it straight into the db tool for your database?
Try putting System.out.println( "XX" ) ; messages at relevant points
Does the SQL give you results if you type it straight into the db tool for your database?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
TimYates,
I fixed the bug. It was from other files...
Since you all put some effort, I will give 80% of point for you if you can explain the change you made in those methods and what are the differences.
I will give give rest of points to others.
thanks,
I fixed the bug. It was from other files...
Since you all put some effort, I will give 80% of point for you if you can explain the change you made in those methods and what are the differences.
I will give give rest of points to others.
thanks,
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
--------------------------
public void getStairManagement(String StairManagementId, StairManagement sm){
//String sql="SELECT stair_management_id" +
String sql="SELECT stair_management_id" +
",visit_id" +
",total_steps" +
",flights" +
",steps_per_flight" +
",assistance" +
",gait_pattern" +
",handrail" +
",comments" +
" FROM stair_management" +
" WHERE stair_management_id = ?";
ResultSet rs = null;
PreparedStatement stmt = null;
try {
stmt=conn.prepareStatement
stmt.setString( 1, StairManagementId ) ;
rs=stmt.executeQuery();
if(rs.next()){
sm.setStairManagementId("s
sm.setVisitId(rs.getString
sm.setStepsTotal(rs.getStr
sm.setFlights(rs.getString
sm.setStepsPerFlight(rs.ge
sm.setAssistance(rs.getStr
sm.setGaitPattern(rs.getSt
sm.setHandrail(rs.getStrin
sm.setComments(rs.getStrin
}
rs.close();
} catch (SQLException e) {
log.error(sql + "\n"+e);
}finally{
if(stmt!=null){
try {
stmt.close();
} catch (SQLException e1) {
log.error(e1);
}
}
}//end try/catch
System.out.println("rs : "+ rs);
}//end get
public StairManagement[] getStairManagements(String
String sql="SELECT stair_management_id" +
",total_steps" +
",flights" +
",steps_per_flight" +
",assistance" +
",gait_pattern" +
",handrail" +
",comments" +
" FROM stair_management" +
" WHERE visit_id = ?" ;
ResultSet rs = null;
PreparedStatement stmt = null;
StairManagement[] sms=null;
try {
stmt=conn.prepareStatement
stmt.setString( 1, visitId ) ;
rs=stmt.executeQuery();
ArrayList al =new ArrayList();
while(rs.next()){
StairManagement sm = new StairManagement();
sm.setStairManagementId(rs
sm.setStepsTotal(rs.getStr
sm.setFlights(rs.getString
sm.setStepsPerFlight(rs.ge
sm.setAssistance(rs.getStr
sm.setGaitPattern(rs.getSt
sm.setHandrail(rs.getStrin
sm.setComments(rs.getStrin
al.add(sm);
}//end loop
rs.close();
sms=(StairManagement[])al.
} catch (SQLException e) {
log.error(sql + "\n"+e);
}finally{
if(stmt!=null){
try {
stmt.close();
} catch (SQLException e1) {
log.error(e1);
}
}
}//end try/catch
return sms;
}//end get