java.sql.SQLException: Exhausted Resultset error -

-

मुझे इस अपवाद java.sql.SQLException: थका हुआ परिणाम वाला में समस्या का सामना करना पड़ रहा है कोड। मुझे यकीन है कि मेरी क्वेरी केवल एक मान देता है यहां तक ​​कि अगर मैं rsnext (); का उपयोग नहीं करता हूं तो यह त्रुटि java.sql.SQLException: ResultSet.next को नहीं बुलाया गया था । क्या आप कृपया मदद कर सकते हैं?

एफवाईआई, मैं एक अन्य परिणाम का उपयोग मुख्य में सेट कर रहा हूं जहां दूसरे वर्ग से यह menthod कहा जाता है। यह प्रभावित करेगा?

धन्यवाद 

  सार्वजनिक स्टेटिक स्ट्रिंग getdispname (कनेक्शन conn, String resname) SQLException, अपवाद {// स्ट्रिंग resname = ""; स्ट्रिंग रिटर्न वैल्यू = ""; स्ट्रिंग क्वेरीस्ट्रिंग = ""; // resid querystring से displayname का चयन करने के लिए क्वेरी + = "अलग display_name चुनें"; क्विकस्ट्रिंग + = "से cust_rally_team_member"; Querystring + = "जहां display_name '%" + resid + "%'" जैसे; // चुनें कथन स्टेटमेंट स्टेटमेंट stmt = conn.createStatement (); Try {// Execute statement ResultSet rs = stmt.executeQuery (querystring); यदि (आरएस! = नल) {जबकि (rsnext ()) {returnValue = rs.getString ("display_name"); } पकड़ (SQLException पूर्व) {नए SQLException (पूर्व); } पकड़ (अपवाद पूर्व) {नया अपवाद (पूर्व); } // बंद कथन अंत में {stmt.close (); } वापसी वापसी वेल्यू;    
 
 
 के रूप में प्रयास करें  
  if (rs! = शून्य) {जबकि (rs.next ()) {returnValue = rs.getString ("display_name"); } ......

Comments

Post a Comment

Popular posts from this blog

c++ - Cmake produces file extensions in static library archives -

-
I have recently switched to autotools to cement, since the limiter cross platform is better for development and what I saw When I build a stable library of my C ++ code, all the files inside .cpp.o is a suffix ar income tax PA8 / libgenericTZR.a genericTZR.cpp.o I have seen other libraries made by other tools and they do not do it, I'm not sure this is the realm And there is a bad thing, but how can I create static libraries without cpp file extension? This is my CMake file add_executable (PA8 ISP_Charges.cpp genericTZR.cpp genericTZR.h) set (LIBSRC genericTZR.c genericTZR.h) add_library (genericTZR shared $ {LIBSRC}) add_library (genericTZR shared $$ TARGET_OBJECTS: myObjects & gt;) install add_library (Generic TZR-static static $ {LIBSRC}) set_target_properties (Generic TZR-Static Properties OUTPUT_NAME $ install (TARGETS PA8 DESTINATION BIN) TARGETS GENICTZR GENERICTZR-STATIC DESTINATION lib) Installed (files "$ {PROJECT_BINARY_DIR} /PA8/genericTZR.h...
Read more

c# - Roxy file manager in MVC doesn't accept session path -

-
Hi friends I've downloaded a file manager for my MVC project. So I added to my project and everything works fine but everyone can use this product I mean everyone can type urls and upload files to my host !!!! This filemanager has a Jason config file, as you can see here: {"FILES_ROOT": "Fileman / Upload "," "File_type_kenny": "file", "THUMBS_VIEW_WIDTH": "140", "THUMBS_VIEW_HEIGHT": "120", "PREVIEW_THUMB_WIDTH": "300", "PREVIEW_THUMB_HEIGHT": "200", "MAX_IMAGE_WIDTH": "0" "ASP_net / Main.Shex? A = Created", " Dealederer ":" ASP_net / MAN.assx "ADELEDED IR "," MOVEDIR ":" ASP_net / Main.Shex? A = MoVEDIR "," Copdier ":" ASP_net / Main.Shex? A = Copdier "," Richie Dar ":" ASP_net / Main ASP_net / main.hex? A = Upload "," Downlo...
Read more

c# - Check if a NumericUpDown has no value -

-
How can I check that the user left a NumericUpDown control blank? I have looked at another question to examine the 'text' property but there is no text property to check against it. You can check against the text property, though it is a designer and Is hidden from Intelligence. Just try this sample it works: if (string.IsNullOrEmpty (control.Text)) {// a value}
Read more