WAB30MRec wab30m = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try{
String query = "Select dwg_no, cut_bay_no, cut_mch_code, cut_pln_date, cut_adjt_dur, cary_due_date, wv_uom, mtl_mat_grd, stl_thck_1, " +
"stl_thck_2, stl_bdth_1, stl_bdth_2, stl_lnth, stl_cgrt, stl_qty, cut_req_qty, btch_cnt, cut_lnth, " +
"mark_lnth, cut_rap_lnth, mark_rap_lnth, pln_week_no, pln_cnfm_indc, std_mh, rgsr_emp_no, rgsr_date, rgsr_time, " +
"mnt_emp_no, mnt_date, mnt_time " +
" from HP.WAB30M " +
" where dwg_no = ? ";
pstmt = connection.prepareStatement(query);
pstmt.setString(1,dwg_no);
rs = pstmt.executeQuery();
if(rs.next()){
wab30m = new WAB30MRec(); // WAB30MRec Constructor
wab30m.setDwg_no(rs.getString("dwg_no"));
.........
} else {
throw new DataNotFoundException();
} // end if
} finally {
try{rs.close();}catch(Exception e){}
try{pstmt.close();}catch(Exception e){}
} // try-finally
return wab30m;
}
==============================
数据库中dwg_no值 : 4449DS626CNH02 4449DS626CNH04 这两个值都存在
当调用这个函数时,参数为4449DS626CNH02 时. 执行到if(rs.next())时可以继续往下执行,当参数值为4449DS626CNH04 时, 执行到if(rs.next())时就会直接跳到else语句上. 这是什么原因??,好奇怪..
