Examples of com.youtube.util.ToJSON.toJSONArray()

com.youtube.util.ToJSON.toJSONArray()
This will convert database records into a JSON Array Simply pass in a ResultSet from a database connection and it loop return a JSON array. It important to check to make sure that all DataType that are being used is properly encoding. varchar is currently the only dataType that is being encode by ESAPI @param rs - database ResultSet @return - JSON array @throws Exception

                      "where UPPER(PC_PARTS_MAKER) = ? ");
      
      query.setString(1, brand.toUpperCase()); //protect against sql injection
      ResultSet rs = query.executeQuery();
      
      json = converter.toJSONArray(rs);
      query.close(); //close connection
    }
    catch(SQLException sqlError) {
      sqlError.printStackTrace();
      return json;

View Full Code Here

       */
      query.setString(1, brand.toUpperCase()); //first ?
      query.setInt(2, item_number); //second ?
      ResultSet rs = query.executeQuery();
      
      json = converter.toJSONArray(rs);
      query.close(); //close connection
    }
    catch(SQLException sqlError) {
      sqlError.printStackTrace();
      return json;

View Full Code Here

      query = conn.prepareStatement("select PC_PARTS_PK, PC_PARTS_TITLE, PC_PARTS_CODE, PC_PARTS_MAKER, PC_PARTS_AVAIL, PC_PARTS_DESC " +
                      "from PC_PARTS");
      
      ResultSet rs = query.executeQuery();
      
      json = converter.toJSONArray(rs);
      query.close(); //close connection
    }
    catch(SQLException sqlError) {
      sqlError.printStackTrace();
      return json;

View Full Code Here

      query = conn.prepareStatement("select to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') DATETIME " +
                      "from sys.dual");
      
      ResultSet rs = query.executeQuery();
      
      json = converter.toJSONArray(rs);
      query.close(); //close connection
    }
    catch(SQLException sqlError) {
      sqlError.printStackTrace();
      return json;

View Full Code Here

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.