Meta tags:
description= Learn how to use Apps Script Class JdbcPreparedStatement. A JDBC PreparedStatement.;
Headings (most frequently used words):
authorization, parameters, return, parameterindex, sql, execute, executeupdate, timezone, setobject, addbatch, autogeneratedkeys, columnindexes, columnnames, executebatch, executequery, getmoreresults, setdate, max, setnull, sqltype, targetsqltype, settime, settimestamp, class, jdbcpreparedstatement, stay, organized, with, collections, save, and, categorize, content, based, on, your, preferences, page, summary, detailed, documentation, methods, cancel, clearbatch, clearparameters, clearwarnings, close, getconnection, getfetchdirection, getfetchsize, getgeneratedkeys, getmaxfieldsize, getmaxrows, getmetadata, current, getparametermetadata, getquerytimeout, getresultset, getresultsetconcurrency, getresultsetholdability, getresultsettype, getupdatecount, getwarnings, isclosed, ispoolable, setarray, setbigdecimal, setblob, setboolean, setbyte, setbytes, setclob, setcursorname, name, setdouble, setescapeprocessing, enable, setfetchdirection, direction, setfetchsize, rows, setfloat, setint, setlong, setmaxfieldsize, setmaxrows, setnclob, setnstring, typename, index, scaleorlength, setpoolable, poolable, setquerytimeout, seconds, setref, setrowid, setsqlxml, setshort, setstring, seturl, google, workspace, for, developers, tools, connect, throws,
Text of the page (most frequently used words):
the (333), this (249), #method (232), sql (210), for (201), java (161), see (156), documentation (156), #authorization (155), set (127), parameter (124), statement (123), script (99), int (93), that (92), more (86), with (80), integer (80), one (79), https (78), www (78), googleapis (78), com (78), auth (78), external_request (78), scripts (78), require (78), following (78), use (77), scopes (77), preparedstatement (76), type (66), index (62), parameters (60), name (59), string (58), parameterindex (58), google (57), and (54), description (52), result (46), void (45), jdbc (44), api (43), execute (41), overview (40), return (39), first (36), value (35), second (30), services (29), boolean (28), classes (26), advanced (25), update (23), data (22), get (22), apps (21), enums (21), are (19), time (17), such (17), executeupdate (16), object (16), generated (16), calendar (15), date (13), batch (13), count (13), statements (12), true (11), resultset (11), current (11), console (10), workspace (10), which (10), max (10), either (10), array (10), keys (10), content (9), zone (9), timestamp (9), setobject (9), rows (9), column (9), byte (9), false (9), results (9), auto (9), manipulation (9), language (9), nothing (9), drive (9), thumb (8), database (8), fetch (8), row (8), indicates (8), number (8), direction (8), there (8), add (8), cloud (7), youtube (7), admin (7), support (7), addbatch (7), executequery (7), methods (7), types (7), otherwise (7), query (7), clob (7), size (7), execution (7), available (7), insert (7), sheets (7), resource (7), all (6), developer (6), samples (6), jdbcpreparedstatement (6), executebatch (6), sets (6), properties (6), used (6), short (6), ids (6), long (6), gmt (6), settimestamp (6), timezone (6), settime (6), ref (6), timeout (6), poolable (6), containing (6), setnull (6), limit (6), setdate (6), null (6), getmoreresults (6), made (6), future (6), retrieval (6), returns (6), chat (6), library (6), blog (5), down (5), close (5), cancel (5), setquerytimeout (5), class (5), setfetchdirection (5), url (5), seconds (5), from (5), jdbcresultset (5), each (5), columns (5), delete (5), commands (5), ons (5), gmail (5), client (5), color (5), interfaces (5), groups (5), español (4), products (4), service (4), developers (4), code (4), build (4), other (4), values (4), getmetadata (4), getparametermetadata (4), getresultset (4), getgeneratedkeys (4), getfetchdirection (4), getfetchsize (4), setfetchsize (4), getresultsetconcurrency (4), getresultsetholdability (4), getresultsettype (4), getmaxfieldsize (4), getmaxrows (4), getwarnings (4), isclosed (4), send (4), sqlxml (4), targetsqltype (4), user (4), sqltype (4), setmaxrows (4), connection (4), setcursorname (4), warnings (4), names (4), whose (4), else (4), ddl (4), columnnames (4), columnindexes (4), autogeneratedkeys (4), counts (4), john (4), using (4), field (4), meta (4), card (4), tasks (4), slides (4), docs (4), classroom (4), list (4), resources (4), textstyle (4), side (4), manager (4), analytics (4), twitter (3), newsletter (3), apis (3), explorer (3), dashboard (3), tools (3), release (3), notes (3), under (3), tag (3), information (3), metadata (3), page (3), license (3), seturl (3), construct (3), instance (3), turn (3), several (3), formats (3), strings (3), recognized (3), offsets (3), america (3), los_angeles (3), pacific (3), est (3), pst (3), lang (3), setstring (3), setshort (3), setsqlxml (3), setrowid (3), setref (3), new (3), setpoolable (3), decimal (3), specified (3), setnstring (3), setnclob (3), nclob (3), zero (3), setmaxfieldsize (3), setlong (3), setint (3), setfloat (3), float (3), enable (3), setescapeprocessing (3), setdouble (3), double (3), setclob (3), setbytes (3), setbyte (3), setboolean (3), blob (3), setblob (3), setbigdecimal (3), setarray (3), ispoolable (3), getupdatecount (3), getquerytimeout (3), flag (3), produced (3), getconnection (3), indices (3), element (3), command (3), var (3), into (3), clearwarnings (3), clearparameters (3), clearbatch (3), clear (3), reference (3), home (3), meet (3), forms (3), core (3), create (3), projects (3), contenttype (3), listitem (3), triggers (3), group (3), datasource (3), 한국어 (2), 日本語 (2), ภาษาไทย (2), বাংলা (2), हिंदी (2), فارسی (2), العربيّة (2), עברית (2), русский (2), türkçe (2), tiếng (2), việt (2), português (2), brasil (2), polski (2), italiano (2), indonesia (2), français (2), américa (2), latina (2), deutsch (2), english (2), terms (2), platform (2), your (2), need (2), too (2), last (2), updated (2), 2026 (2), utc (2), key (2), operations (2), setting (2), various (2), licensed (2), feedback (2), rowid (2), requests (2), pooled (2), length (2), ignored (2), scale (2), argument (2), target (2), scaleorlength (2), defined (2), typename (2), maximum (2), can (2), have (2), fetch_reverse (2), fetch_forward (2), escape (2), processing (2), cursor (2), big (2), bigdecimal (2), closed (2), type_scroll_insensitive (2), holdability (2), concurrency (2), jdbcparametermetadata (2), next (2), jdbcresultsetmetadata (2), default (2), jdbcconnection (2), indexes (2), whether (2), no_generated_keys (2), return_generated_keys (2), typically (2), contains (2), access (2), error (2), objects (2), params (2), stmt (2), smith (2), doe (2), employees (2), age (2), conn (2), example (2), submits (2), successfully (2), like (2), prepared (2), interaction (2), previews (2), updates (2), codelabs (2), how (2), started (2), training (2), builder (2), marketplace (2), extend (2), automate (2), share (2), vault (2), sites (2), keep (2), search (2), browser (2), libraries (2), file (2), run (2), manifest (2), visibility (2), verticalalignment (2), updatedraftbodytype (2), status (2), openas (2), onclose (2), horizontalalignment (2), composedemailtype (2), updatedrafttorecipientsaction (2), updatedraftsubjectaction (2), updatedraftccrecipientsaction (2), updatedraftbodyaction (2), updatedraftbccrecipientsaction (2), updatedraftactionresponsebuilder (2), updatedraftactionresponse (2), universalactionresponsebuilder (2), universalactionresponse (2), trigger (2), textinput (2), openlink (2), notification (2), navigation (2), linkpreview (2), image (2), griditem (2), editorfilescopeactionresponsebuilder (2), editorfilescopeactionresponse (2), driveitemsselectedactionresponsebuilder (2), driveitemsselectedactionresponse (2), composeactionresponsebuilder (2), composeactionresponse (2), calendareventactionresponsebuilder (2), calendareventactionresponse (2), buttonset (2), button (2), borderstyle (2), attachment (2), actionresponsebuilder (2), actionresponse (2), action (2), link (2), events (2), eventtype (2), lock (2), cache (2), mimetype (2), html (2), position (2), textstylebuilder (2), charts (2), text (2), format (2), document (2), attribute (2), utilities (2), optimization (2), bigquery (2), tables (2), shopping (2), merchant (2), reporting (2), doubleclick (2), video (2), adsense (2), vertex (2), maps (2), contacts (2), migrate (2), people (2), themecolortype (2), textdirection (2), themecolor (2), tablerow (2), tablecell (2), table (2), selection (2), paragraph (2), connected (2), range (2), namedrange (2), guides (2), manage, cookies, privacy, firebase, chrome, android, connect, watch, tutorials, videos, explore, our, copy, them, own, ask, question, stack, overflow, read, easy, understand, easytounderstand, solved, problem, solvedmyproblem, otherup, missing, missingtheinformationineed, complicated, many, steps, toocomplicatedtoomanysteps, out, outofdate, issue, samplescodeissue, otherdown, manages, interactions, actions, include, executing, via, setxxx, also, handles, control, provide, others, tell, except, noted, details, registered, trademark, oracle, its, affiliates, site, policies, apache, creative, commons, attribution, not, digits, after, reader, input, stream, numeric, may, further, qualify, fully, qualifed, isn, enabled, disabled, must, unique, within, type_forward_only, close_cursors_at_commit, hold_cursors_over_commit, concur_updatable, concur_read_only, including, what, happens, when, retrieved, close_all_results, keep_current_result, close_current_result, unavailable, storing, character, binary, indictates, ofr, never, static, select, occurs, throws, representing, preparestatement, mysql, getcloudsqlconnection, inserts, multiple, batching, where, inner, single, you, could, same, order, were, added, detailed, nstring, bytes, brief, most, scope, configured, numerous, provided, configure, specific, supporting, retrieving, managing, itself, facilitates, databases, mirroring, functionality, outlined_flag, summary, save, categorize, based, preferences, stay, organized, collections, ruby, python, php, node, net, nullvalue, localizedmessage, executionresponse, executionerror, executestreamresponse, versions, deployments, updatecontent, getmetrics, getcontent, listscriptprocesses, processes, rest, homepagetrigger, editors, addons, entrypointtype, entrypointfeature, conferenceerrortype, entrypoint, conferenceparameter, conferenceerror, conferencedatabuilder, conferencedata, conferencedataservice, conferencing, wrapstyle, workflowdatasourcetype, variablebuttonsize, textinputmode, textbuttonstyle, switchcontroltype, selectioninputtype, responsetype, loadindicator, inputtype, imagestyle, imagecroptype, imagebuttonstyle, icon, horizontalsizestyle, griditemlayout, expressiondataconditiontype, expressiondataactiontype, driveitemtype, displaystyle, commondatasource, chiplistlayout, bordertype, workflowdatasource, widget, validation, updatedwidget, updatevisibilityaction, timepicker, textparagraph, textbutton, switch, suggestionsresponsebuilder, suggestionsresponse, suggestions, selectioninput, platformdatasource, overflowmenuitem, overflowmenu, materialicon, keyvalue, imagecropstyle, imagecomponent, imagebutton, iconimage, hostappdatasource, grid, fixedfooter, expressiondatacondition, expressiondataaction, expressiondata, eventaction, drivedatasourcespec, divider, dialogaction, dialog, decoratedtext, datetimepicker, datepicker, datasourceconfig, condition, commonwidgetaction, collapsecontrol, chiplist, chip, chatspacedatasource, chatresponsebuilder, chatresponse, chatclientdatasource, chatactionresponse, carouselcard, carousel, cardwithid, cardsection, cardheader, cardbuilder, cardaction, authorizationexception, authorizationaction, actionstatus, cardservice, validationerrorseverity, sendstatus, listtype, fontweight, errorretryability, erroractionability, endnavigation, basicdatatype, addoncomposeuiactiontype, workflowvalidationerroraction, workflowtextformat, workflowaction, variabledata, valuemetadata, updatewidget, updatemessageaction, updateinlinepreviewaction, textformaticon, textformatelement, textformatchip, styledtext, saveworkflowaction, returnoutputvariablesaction, returnelementerroraction, resourcetype, resourceretrievedaction, resourcefieldsdefinitionretrievedaction, resourcefield, resourcedata, renderactionbuilder, renderaction, removewidget, removesection, modifycard, listcontainer, insertwidget, insertsection, hyperlink, hostappaction, dynamicresourcedefinition, datatype, dataactionsresponse, createmessageaction, chatmessage, chatdataactionsresponsebuilder, addoncomposeuiactionresponsebuilder, addoncomposeuiactionresponse, accessorywidget, addonsresponseservice, response, quotas, limits, allowlist, urls, macros, web, executables, event, installable, simple, automation, project, triggersource, installationsource, authorizationstatus, authmode, triggerbuilder, statetokenbuilder, spreadsheettriggerbuilder, formtriggerbuilder, documenttriggerbuilder, clocktriggerbuilder, calendartriggerbuilder, authorizationinfo, scriptapp, userproperties, scriptproperties, propertiesservice, lockservice, cacheservice, weekday, month, colortype, blobsource, rgbcolor, promptresponse, menu, session, logger, base, mailapp, mail, xframeoptionsmode, sandboxmode, htmltemplate, htmloutputmetatag, htmloutput, htmlservice, host, history, textoutput, contentservice, pointstyle, pickervalueslayout, orientation, matchtype, curvestyle, columntype, charttype, chartmergestrategy, charthiddendimensionstrategy, datatablesource, tablechartbuilder, stringfilterbuilder, scatterchartbuilder, piechartbuilder, numberrangefilterbuilder, linechartbuilder, dataviewdefinitionbuilder, dataviewdefinition, datatablebuilder, datatable, columnchartbuilder, chartoptions, chart, barchartbuilder, areachartbuilder, processinginstruction, namespace, entityref, doctype, comment, cdata, xmlservice, xml, rsaalgorithm, macalgorithm, digestalgorithm, charset, variabletype, linearoptimizationsolution, linearoptimizationengine, linearoptimizationconstraint, linearoptimizationservice, usability, httpresponse, urlfetchapp, jdbctimestamp, jdbctime, jdbcstruct, jdbcstatement, jdbcsavepoint, jdbcsqlxml, jdbcrowid, jdbcref, jdbcdate, jdbcdatabasemetadata, jdbcclob, jdbccallablestatement, jdbcblob, jdbcarray, connections, utility, fieldtype, bigqueryparametertype, authtype, aggregationtype, usererror, textarea, setcredentialsresponse, selectsingle, selectmultiple, optionbuilder, info, getschemaresponse, getdataresponse, getauthtyperesponse, fields, debugerror, config, communityconnector, checkbox, bigqueryconfig, datastudioapp, studio, dcm, dfa, trafficking, campaigns, dbm, bid, dv360, display, 360, management, ads, center, languageapp, translate, mode, markersize, avoid, staticmapenums, staticmap, geocoder, elevationsampler, directionfinderenums, directionfinder, sensitivity, priority, gender, extendedfield, urlfield, phonefield, imfield, emailfield, datefield, customfield, contactgroup, contact, companyfield, addressfield, contactsapp, identity, role, groupsapp, videosourcetype, textbaselineoffset, spacingmode, slideposition, slidelinkingmode, sheetschartembedtype, shapetype, selectiontype, predefinedlayout, placeholdertype, paragraphalignment, pagetype, pageelementtype, pagebackgroundtype, listpreset, linktype, linetype, linefilltype, linecategory, filltype, dashstyle, contentalignment, cellmergestate, autofittype, autotexttype, arrowstyle, alignmentposition, wordart, textrange, tablecolumn, tablecellrange, speakerspotlight, solidfill, slide, sheetschart, shape, presentation, point, picturefill, paragraphstyle, pagerange, pageelementrange, pageelement, pagebackground, notespage, notesmaster, master, liststyle, linefill, line, layout, fill, connectionsite, colorscheme, border, autofit, autotext, affinetransformbuilder, affinetransform, slidesapp, wrapstrategy, valuetype, texttocolumnsdelimiter, sortorder, sheettype, relativedate, recalculationinterval, protectiontype, pivotvaluedisplaytype, pivottablesummarizefunction, interpolationtype, groupcontroltoggleposition, frequencytype, dimension, developermetadatavisibility, developermetadatalocationtype, datetimegroupingruletype, datavalidationcriteria, datasourcetype, datasourcerefreshscope, datasourceparametertype, dataexecutionstate, dataexecutionerrorcode, copypastetype, booleancriteria, bandingtheme, autofillseries, textrotation, textfinder, spreadsheettheme, spreadsheet, sortspec, slicer, sheet, richtextvaluebuilder, richtextvalue, rangelist, protection, pivotvalue, pivottable, pivotgrouplimit, pivotgroup, pivotfilter, pageprotection, overgridimage, gradientcondition, filtercriteriabuilder, filtercriteria, filter, embeddedtablechartbuilder, embeddedscatterchartbuilder, embeddedpiechartbuilder, embeddedlinechartbuilder, embeddedhistogramchartbuilder, embeddedcombochartbuilder, embeddedcolumnchartbuilder, embeddedchartbuilder, embeddedchart, embeddedbarchartbuilder, embeddedareachartbuilder, drawing, developermetadatalocation, developermetadatafinder, developermetadata, datetimegroupingrule, datavalidationbuilder, datavalidation, datasourcetablefilter, datasourcetablecolumn, datasourcetable, datasourcespecbuilder, datasourcespec, datasourcesheetfilter, datasourcesheet, datasourcerefreshschedulefrequency, datasourcerefreshschedule, datasourcepivottable, datasourceparameter, datasourceformula, datasourcecolumn, datasourcechart, lookerdatasourcespecbuilder, lookerdatasourcespec, dataexecutionstatus, bigquerydatasourcespecbuilder, bigquerydatasourcespec, containerinfo, conditionalformatrulebuilder, conditionalformatrule, colorbuilder, cellimagebuilder, cellimage, booleancondition, banding, spreadsheetapp, gmailthread, gmailmessage, gmaillabel, gmaildraft, gmailattachment, gmailapp, ratingicontype, pagenavigationtype, itemtype, feedbacktype, destinationtype, alignment, item, videoitem, timeitem, textvalidationbuilder, textvalidation, textitem, sectionheaderitem, scaleitem, ratingitem, quizfeedbackbuilder, quizfeedback, paragraphtextvalidationbuilder, paragraphtextvalidation, paragraphtextitem, pagebreakitem, multiplechoiceitem, itemresponse, imageitem, gridvalidationbuilder, gridvalidation, formresponse, form, durationitem, datetimeitem, dateitem, choice, checkboxvalidationbuilder, checkboxvalidation, checkboxitem, checkboxgridvalidationbuilder, checkboxgridvalidation, checkboxgriditem, formapp, labels, activity, permission, folderiterator, folder, fileiterator, driveapp, textalignment, tabtype, positionedlayout, paragraphheading, glyphtype, fontfamily, elementtype, unsupportedelement, tableofcontents, tab, richlink, rangeelement, rangebuilder, positionedimage, person, pagebreak, inlineimage, inlinedrawing, horizontalrule, headersection, footnotesection, footnote, footersection, equationsymbol, equationfunctionargumentseparator, equationfunction, equation, documenttab, containerelement, bookmark, body, documentapp, gueststatus, eventtransparency, eventcolor, recurrencerule, eventrecurrence, eventguest, calendareventseries, calendarevent, calendarapp, reports, reseller, settings, migration, enterprise, directory, sign, skip, main,
Text of the page (random words):
hstyle filltype linecategory linefilltype linetype linktype listpreset pagebackgroundtype pageelementtype pagetype paragraphalignment placeholdertype predefinedlayout selectiontype shapetype sheetschartembedtype slidelinkingmode slideposition spacingmode textbaselineoffset textdirection themecolortype videosourcetype advanced services slides api workspace advanced services events api more classroom advanced services classroom api groups overview groupsapp classes group enums role advanced services cloud identity groups api migrate from groups service people advanced services people api migrate from contacts service contacts overview contactsapp classes addressfield companyfield contact contactgroup customfield datefield emailfield imfield phonefield urlfield enums extendedfield field gender priority sensitivity tasks advanced services tasks api other google services google analytics advanced services analytics data api analytics admin api google maps overview maps classes directionfinder directionfinderenums elevationsampler geocoder staticmap staticmapenums enums avoid color format markersize mode type google translate overview languageapp vertex ai advanced services vertex ai api youtube advanced services youtube data api youtube analytics api youtube content id api more google ads merchant center adsense advanced services adsense management api display video 360 advanced services dv360 api doubleclick bid manager advanced services dbm reporting api doubleclick campaigns advanced services dcm dfa reporting and trafficking api shopping content advanced services merchant api google content api for shopping google data studio overview datastudioapp classes bigqueryconfig checkbox communityconnector config debugerror field fields getauthtyperesponse getdataresponse getschemaresponse info optionbuilder selectmultiple selectsingle setcredentialsresponse textarea textinput usererror enums aggregationtype authtype bigqueryparametertype fieldtype google tables advanced services tables api google tag manager advanced services tag manager api utility services api database connections bigquery advanced services bigquery api jdbc overview jdbc classes jdbcarray jdbcblob jdbccallablestatement jdbcclob jdbcconnection jdbcdatabasemetadata jdbcdate jdbcparametermetadata jdbcpreparedstatement jdbcref jdbcresultset jdbcresultsetmetadata jdbcrowid jdbcsqlxml jdbcsavepoint jdbcstatement jdbcstruct jdbctime jdbctimestamp url fetch overview urlfetchapp classes httpresponse data usability optimization optimization overview linearoptimizationservice classes linearoptimizationconstraint linearoptimizationengine linearoptimizationsolution enums status variabletype utilities overview utilities enums charset digestalgorithm macalgorithm rsaalgorithm xml overview xmlservice classes attribute cdata comment doctype document element entityref format namespace processinginstruction text interfaces content enums contenttype html content charts overview charts classes areachartbuilder barchartbuilder chart chartoptions columnchartbuilder datatable datatablebuilder dataviewdefinition dataviewdefinitionbuilder linechartbuilder numberrangefilterbuilder piechartbuilder scatterchartbuilder stringfilterbuilder tablechartbuilder textstyle textstylebuilder interfaces datatablesource enums charthiddendimensionstrategy chartmergestrategy charttype columntype curvestyle matchtype orientation pickervalueslayout pointstyle position content overview contentservice classes textoutput enums mimetype html overview google script history client side google script host client side google script run client side google script url client side htmlservice classes htmloutput htmloutputmetatag htmltemplate enums sandboxmode xframeoptionsmode mail overview mailapp script execution information base overview browser logger mimetype session console classes blob menu promptresponse rgbcolor ui user interfaces blobsource enums button buttonset colortype month weekday cache overview cacheservice classes cache lock overview lockservice classes lock properties overview propertiesservice scriptproperties userproperties classes properties script overview scriptapp classes authorizationinfo calendartriggerbuilder clocktriggerbuilder documenttriggerbuilder formtriggerbuilder service spreadsheettriggerbuilder statetokenbuilder trigger triggerbuilder enums authmode authorizationstatus eventtype installationsource triggersource script project resources automation triggers and events simple triggers installable triggers event objects manifest overview libraries advanced services web apps and api executables sheets macros allowlist urls quotas limits google workspace add ons services add ons response overview addonsresponseservice classes accessorywidget action actionresponse actionresponsebuilder addoncomposeuiactionresponse addoncomposeuiactionresponsebuilder attachment calendareventactionresponse calendareventactionresponsebuilder chatdataactionsresponsebuilder chatmessage color composeactionresponse composeactionresponsebuilder createmessageaction dataactionsresponse datatype driveitemsselectedactionresponse driveitemsselectedactionresponsebuilder dynamicresourcedefinition editorfilescopeactionresponse editorfilescopeactionresponsebuilder hostappaction hyperlink insertsection insertwidget link linkpreview listcontainer listitem modifycard navigation notification openlink removesection removewidget renderaction renderactionbuilder resourcedata resourcefield resourcefieldsdefinitionretrievedaction resourceretrievedaction resourcetype returnelementerroraction returnoutputvariablesaction saveworkflowaction styledtext textformatchip textformatelement textformaticon timestamp universalactionresponse universalactionresponsebuilder updatedraftactionresponse updatedraftactionresponsebuilder updatedraftbccrecipientsaction updatedraftbodyaction updatedraftccrecipientsaction updatedraftsubjectaction updatedrafttorecipientsaction updateinlinepreviewaction updatemessageaction updatewidget valuemetadata variabledata workflowaction workflowtextformat workflowvalidationerroraction enums addoncomposeuiactiontype basicdatatype composedemailtype contenttype endnavigation erroractionability errorretryability fontweight listtype onclose openas sendstatus textstyle updatedraftbodytype validationerrorseverity card overview cardservice classes action actionresponse actionresponsebuilder actionstatus attachment authorizationaction authorizationexception borderstyle button buttonset calendareventactionresponse calendareventactionresponsebuilder card cardaction cardbuilder cardheader cardsection cardwithid carousel carouselcard chatactionresponse chatclientdatasource chatresponse chatresponsebuilder chatspacedatasource chip chiplist collapsecontrol column columns commonwidgetaction composeactionresponse composeactionresponsebuilder condition datasourceconfig datepicker datetimepicker decoratedtext dialog dialogaction divider drivedatasourcespec driveitemsselectedactionresponse driveitemsselectedactionresponsebuilder editorfilescopeactionresponse editorfilescopeactionresponsebuilder eventaction expressiondata expressiondataaction expressiondatacondition fixedfooter grid griditem hostappdatasource iconimage image imagebutton imagecomponent imagecropstyle keyvalue linkpreview materialicon navigation notification openlink overflowmenu overflowmenuitem platformdatasource selectioninput suggestions suggestionsresponse suggestionsresponsebuilder switch textbutton textinput textparagraph timepicker trigger universalactionresponse universalactionresponsebuilder updatedraftactionresponse updatedraftactionresponsebuilder updatedraftbccrecipientsaction updatedraftbodyaction updatedraftccrecipientsaction updatedraftsubjectaction updatedrafttorecipientsaction updatevisibilityaction updatedwidget validation widget workflowdatasource enums bordertype chiplistlayout commondatasource composedemailtype contenttype displaystyle driveitemtype expressiondataactiontype expressiondataconditiontype griditemlayout horizontalalignment horizontalsizestyle icon imagebuttonstyle imagecroptype imagestyle inputtype interaction loadindicator onclose openas responsetype selectioninputtype status switchcontroltype textbuttonstyle textinputmode updatedraftbodytype variablebuttonsize verticalalignment visibility workflowdatasourcetype wrapstyle conferencing data overview conferencedataservice classes conferencedata conferencedatabuilder conferenceerror conferenceparameter entrypoint enums conferenceerrortype entrypointfeature entrypointtype manifest addons resource calendar resource drive resource gmail resource editors resource meet resource homepagetrigger resource add ons api apps script api v1 overview rest resources processes overview list listscriptprocesses projects overview create get getcontent getmetrics updatecontent projects deployments overview create delete get list update projects versions overview create get list scripts overview run types executestreamresponse executionerror executionresponse file localizedmessage nullvalue client libraries browser go java core library api library net core library api library node js php python core library api library ruby google workspace apps admin console cloud search gmail google calendar google chat google classroom google docs google drive google forms google keep google meet google sheets google sites google slides google tasks google vault extend automate share add ons apps script chat apps drive apps marketplace tools admin console apps script dashboard google cloud console apis explorer card builder training support how to get started codelabs developer support updates release notes developer previews youtube newsletter x twitter blog home google workspace apps script reference send feedback class jdbcpreparedstatement stay organized with collections save and categorize content based on your preferences page summary outlined_flag the jdbcpreparedstatement class in apps script facilitates interaction with sql databases using prepared statements mirroring java jdbc api functionality key methods are available for batch operations statement execution setting parameters retrieving information and managing the statement itself numerous set methods are provided to configure parameters for the prepared statement at specific indices supporting various data types statement properties can be configured using methods like setcursorname setfetchdirection setmaxrows and setquerytimeout most methods require authorization with the https www googleapis com auth script external_request scope jdbcpreparedstatement a jdbc preparedstatement for documentation of this class see java sql preparedstatement methods method return type brief description add batch void for documentation of this method see java sql preparedstatement addbatch add batch sql void for documentation of this method see java sql statement addbatch string cancel void for documentation of this method see java sql statement cancel clear batch void for documentation of this method see java sql statement clearbatch clear parameters void for documentation of this method see java sql preparedstatement clearparameters clear warnings void for documentation of this method see java sql statement clearwarnings close void for documentation of this method see java sql statement close execute boolean for documentation of this method see java sql preparedstatement execute execute sql boolean for documentation of this method see java sql statement execute string execute sql autogeneratedkeys boolean for documentation of this method see java sql statement execute string int execute sql columnindexes boolean for documentation of this method see java sql statement execute string int execute sql columnnames boolean for documentation of this method see java sql statement execute string string execute batch integer for documentation of this method see java sql statement executebatch execute batch parameters integer submits a batch of commands to the database for execution and if all commands execute successfully returns an array of update counts execute query jdbc result set for documentation of this method see java sql preparedstatement executequery execute query sql jdbc result set for documentation of this method see java sql statement executequery string execute update integer for documentation of this method see java sql preparedstatement executeupdate execute update sql integer for documentation of this method see java sql statement executeupdate string execute update sql autogeneratedkeys integer for documentation of this method see java sql statement executeupdate string int execute update sql columnindexes integer for documentation of this method see java sql statement executeupdate string int execute update sql columnnames integer for documentation of this method see java sql statement executeupdate string string get connection jdbc connection for documentation of this method see java sql statement getconnection get fetch direction integer for documentation of this method see java sql statement getfetchdirection get fetch size integer for documentation of this method see java sql statement getfetchsize get generated keys jdbc result set for documentation of this method see java sql statement getgeneratedkeys get max field size integer for documentation of this method see java sql statement getmaxfieldsize get max rows integer for documentation of this method see java sql statement getmaxrows get meta data jdbc result set meta data for documentation of this method see java sql preparedstatement getmetadata get more results boolean for documentation of this method see java sql statement getmoreresults get more results current boolean for documentation of this method see java sql statement getmoreresults int get parameter meta data jdbc parameter meta data for documentation of this method see java sql preparedstatement getparametermetadata get query timeout integer for documentation of this method see java sql statement getquerytimeout get result set jdbc result set for documentation of this method see java sql statement getresultset get result set concurrency integer for documentation of this method see java sql statement getresultsetconcurrency get result set holdability integer for documentation of this method see java sql statement getresultsetholdability get result set type integer for documentation of this method see java sql statement getresultsettype get update count integer for documentation of this method see java sql statement getupdatecount get warnings string for documentation of this method see java sql statement getwarnings is closed boolean for documentation of this method see java sql statement isclosed is poolable boolean for documentation of this method see java sql statement ispoolable set array parameterindex x void for documentation of this method see java sql preparedstatement setarray int array set big decimal parameterindex x void...
|