1 19 22 package org.openbravo.erpCommon.utility; 23 24 import java.sql.*; 25 import java.util.*; 26 27 import javax.servlet.ServletException ; 28 29 import org.openbravo.data.FieldProvider; 30 import org.openbravo.database.ConnectionProvider; 31 import org.openbravo.exception.*; 32 import org.openbravo.data.UtilSql; 33 34 public class SequenceIdData implements FieldProvider { 35 public String dummy; 36 37 public String getField(String fieldName) { 38 if (fieldName.equalsIgnoreCase("dummy")) 39 return dummy; 40 else { 41 System.out.println("Field does not exist: " + fieldName); 42 return null; 43 } 44 } 45 46 48 public static SequenceIdData[] select(ConnectionProvider connectionProvider) 49 throws ServletException { 50 String strSql = ""; 51 strSql = strSql + ""; 52 strSql = strSql + " SELECT Dummy FROM DUAL"; 53 strSql = strSql + " "; 54 55 PreparedStatement st = null; 56 ResultSet result; 57 Vector<Object > vector = new Vector<Object >(0); 58 59 int iParameter = 0; 60 try { 61 st = connectionProvider.getPreparedStatement(strSql); 62 63 result = st.executeQuery(); 64 long countRecord = 0; 65 while(result.next()) { 66 countRecord++; 67 SequenceIdData objectSequenceIdData = new SequenceIdData(); 68 objectSequenceIdData.dummy = UtilSql.getValue(result, "DUMMY"); 69 vector.addElement(objectSequenceIdData); 70 } 71 result.close(); 72 } catch (NoConnectionAvailableException ex) { 73 throw new ServletException ("@CODE=NoConnectionAvailable"); 74 } catch (SQLException ex2) { 75 System.out.println("SQL error in query: " + strSql + "Exception:"+ ex2); 76 throw new ServletException ("@CODE=" + Integer.toString(ex2.getErrorCode()) + "@" + ex2.getMessage()); 77 } catch (Exception ex3) { 78 throw new ServletException ("@CODE=@" + ex3.getMessage()); 79 } finally { 80 try { 81 connectionProvider.releasePreparedStatement(st); 82 } catch (Exception ignored) {} 83 } 84 SequenceIdData objectSequenceIdData[] = new SequenceIdData[vector.size()]; 85 vector.copyInto(objectSequenceIdData); 86 return(objectSequenceIdData); 87 } 88 155 156 158 public static String getSequence(ConnectionProvider conn, String table, String client) 159 throws ServletException { 160 169 String object; 170 CSResponse response = SequenceData.getSequence(conn, table, client); 171 object = response.razon; 172 186 return(object); 187 } 188 } 189
| Popular Tags
|