sql.tld 8.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289
  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <taglib xmlns="http://java.sun.com/xml/ns/j2ee"
  3. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4. xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-jsptaglibrary_2_0.xsd"
  5. version="2.0">
  6. <description>JSTL 1.1 sql library</description>
  7. <display-name>JSTL sql</display-name>
  8. <tlib-version>1.1</tlib-version>
  9. <short-name>sql</short-name>
  10. <uri>http://java.sun.com/jsp/jstl/sql</uri>
  11. <validator>
  12. <description>
  13. Provides core validation features for JSTL tags.
  14. </description>
  15. <validator-class>
  16. org.apache.taglibs.standard.tlv.JstlSqlTLV
  17. </validator-class>
  18. </validator>
  19. <tag>
  20. <description>
  21. Provides nested database action elements with a shared Connection,
  22. set up to execute all statements as one transaction.
  23. </description>
  24. <name>transaction</name>
  25. <tag-class>org.apache.taglibs.standard.tag.rt.sql.TransactionTag</tag-class>
  26. <body-content>JSP</body-content>
  27. <attribute>
  28. <description>
  29. DataSource associated with the database to access. A
  30. String value represents a relative path to a JNDI
  31. resource or the parameters for the JDBC
  32. DriverManager facility.
  33. </description>
  34. <name>dataSource</name>
  35. <required>false</required>
  36. <rtexprvalue>true</rtexprvalue>
  37. </attribute>
  38. <attribute>
  39. <description>
  40. Transaction isolation level. If not specified, it is the
  41. isolation level the DataSource has been configured
  42. with.
  43. </description>
  44. <name>isolation</name>
  45. <required>false</required>
  46. <rtexprvalue>true</rtexprvalue>
  47. </attribute>
  48. </tag>
  49. <tag>
  50. <description>
  51. Executes the SQL query defined in its body or through the
  52. sql attribute.
  53. </description>
  54. <name>query</name>
  55. <tag-class>org.apache.taglibs.standard.tag.rt.sql.QueryTag</tag-class>
  56. <body-content>JSP</body-content>
  57. <attribute>
  58. <description>
  59. Name of the exported scoped variable for the
  60. query result. The type of the scoped variable is
  61. javax.servlet.jsp.jstl.sql.
  62. Result (see Chapter 16 "Java APIs").
  63. </description>
  64. <name>var</name>
  65. <required>true</required>
  66. <rtexprvalue>false</rtexprvalue>
  67. </attribute>
  68. <attribute>
  69. <description>
  70. Scope of var.
  71. </description>
  72. <name>scope</name>
  73. <required>false</required>
  74. <rtexprvalue>false</rtexprvalue>
  75. </attribute>
  76. <attribute>
  77. <description>
  78. SQL query statement.
  79. </description>
  80. <name>sql</name>
  81. <required>false</required>
  82. <rtexprvalue>true</rtexprvalue>
  83. </attribute>
  84. <attribute>
  85. <description>
  86. Data source associated with the database to
  87. query. A String value represents a relative path
  88. to a JNDI resource or the parameters for the
  89. DriverManager class.
  90. </description>
  91. <name>dataSource</name>
  92. <required>false</required>
  93. <rtexprvalue>true</rtexprvalue>
  94. </attribute>
  95. <attribute>
  96. <description>
  97. The returned Result object includes the rows
  98. starting at the specified index. The first row of
  99. the original query result set is at index 0. If not
  100. specified, rows are included starting from the
  101. first row at index 0.
  102. </description>
  103. <name>startRow</name>
  104. <required>false</required>
  105. <rtexprvalue>true</rtexprvalue>
  106. </attribute>
  107. <attribute>
  108. <description>
  109. The maximum number of rows to be included in
  110. the query result. If not specified, or set to -1, no
  111. limit on the maximum number of rows is
  112. enforced.
  113. </description>
  114. <name>maxRows</name>
  115. <required>false</required>
  116. <rtexprvalue>true</rtexprvalue>
  117. </attribute>
  118. </tag>
  119. <tag>
  120. <description>
  121. Executes the SQL update defined in its body or through the
  122. sql attribute.
  123. </description>
  124. <name>update</name>
  125. <tag-class>org.apache.taglibs.standard.tag.rt.sql.UpdateTag</tag-class>
  126. <body-content>JSP</body-content>
  127. <attribute>
  128. <description>
  129. Name of the exported scoped variable for the result
  130. of the database update. The type of the scoped
  131. variable is java.lang.Integer.
  132. </description>
  133. <name>var</name>
  134. <required>false</required>
  135. <rtexprvalue>false</rtexprvalue>
  136. </attribute>
  137. <attribute>
  138. <description>
  139. Scope of var.
  140. </description>
  141. <name>scope</name>
  142. <required>false</required>
  143. <rtexprvalue>false</rtexprvalue>
  144. </attribute>
  145. <attribute>
  146. <description>
  147. SQL update statement.
  148. </description>
  149. <name>sql</name>
  150. <required>false</required>
  151. <rtexprvalue>true</rtexprvalue>
  152. </attribute>
  153. <attribute>
  154. <description>
  155. Data source associated with the database to update.
  156. A String value represents a relative path to a JNDI
  157. resource or the parameters for the JDBC
  158. DriverManager class.
  159. </description>
  160. <name>dataSource</name>
  161. <required>false</required>
  162. <rtexprvalue>true</rtexprvalue>
  163. </attribute>
  164. </tag>
  165. <tag>
  166. <description>
  167. Sets a parameter in an SQL statement to the specified value.
  168. </description>
  169. <name>param</name>
  170. <tag-class>org.apache.taglibs.standard.tag.rt.sql.ParamTag</tag-class>
  171. <body-content>JSP</body-content>
  172. <attribute>
  173. <description>
  174. Parameter value.
  175. </description>
  176. <name>value</name>
  177. <required>false</required>
  178. <rtexprvalue>true</rtexprvalue>
  179. </attribute>
  180. </tag>
  181. <tag>
  182. <description>
  183. Sets a parameter in an SQL statement to the specified java.util.Date value.
  184. </description>
  185. <name>dateParam</name>
  186. <tag-class>org.apache.taglibs.standard.tag.rt.sql.DateParamTag</tag-class>
  187. <body-content>empty</body-content>
  188. <attribute>
  189. <description>
  190. Parameter value for DATE, TIME, or
  191. TIMESTAMP column in a database table.
  192. </description>
  193. <name>value</name>
  194. <required>true</required>
  195. <rtexprvalue>true</rtexprvalue>
  196. </attribute>
  197. <attribute>
  198. <description>
  199. One of "date", "time" or "timestamp".
  200. </description>
  201. <name>type</name>
  202. <required>false</required>
  203. <rtexprvalue>true</rtexprvalue>
  204. </attribute>
  205. </tag>
  206. <tag>
  207. <description>
  208. Creates a simple DataSource suitable only for prototyping.
  209. </description>
  210. <name>setDataSource</name>
  211. <tag-class>org.apache.taglibs.standard.tag.rt.sql.SetDataSourceTag</tag-class>
  212. <body-content>empty</body-content>
  213. <attribute>
  214. <description>
  215. Name of the exported scoped variable
  216. for the data source specified. Type can
  217. be String or DataSource.
  218. </description>
  219. <name>var</name>
  220. <required>false</required>
  221. <rtexprvalue>false</rtexprvalue>
  222. </attribute>
  223. <attribute>
  224. <description>
  225. If var is specified, scope of the
  226. exported variable. Otherwise, scope of
  227. the data source configuration variable.
  228. </description>
  229. <name>scope</name>
  230. <required>false</required>
  231. <rtexprvalue>false</rtexprvalue>
  232. </attribute>
  233. <attribute>
  234. <description>
  235. Data source. If specified as a string, it
  236. can either be a relative path to a JNDI
  237. resource, or a JDBC parameters string
  238. as defined in Section 10.1.1.
  239. </description>
  240. <name>dataSource</name>
  241. <required>false</required>
  242. <rtexprvalue>true</rtexprvalue>
  243. </attribute>
  244. <attribute>
  245. <description>
  246. JDBC parameter: driver class name.
  247. </description>
  248. <name>driver</name>
  249. <required>false</required>
  250. <rtexprvalue>true</rtexprvalue>
  251. </attribute>
  252. <attribute>
  253. <description>
  254. JDBC parameter: URL associated with
  255. the database.
  256. </description>
  257. <name>url</name>
  258. <required>false</required>
  259. <rtexprvalue>true</rtexprvalue>
  260. </attribute>
  261. <attribute>
  262. <description>
  263. JDBC parameter: database user on
  264. whose behalf the connection to the
  265. database is being made.
  266. </description>
  267. <name>user</name>
  268. <required>false</required>
  269. <rtexprvalue>true</rtexprvalue>
  270. </attribute>
  271. <attribute>
  272. <description>
  273. JDBC parameter: user password
  274. </description>
  275. <name>password</name>
  276. <required>false</required>
  277. <rtexprvalue>true</rtexprvalue>
  278. </attribute>
  279. </tag>
  280. </taglib>