| <HTML> |
| <BODY BGCOLOR="white"> |
| <PRE> |
| <FONT color="green">001</FONT> /*<a name="line.1"></a> |
| <FONT color="green">002</FONT> * Licensed to the Apache Software Foundation (ASF) under one<a name="line.2"></a> |
| <FONT color="green">003</FONT> * or more contributor license agreements. See the NOTICE file<a name="line.3"></a> |
| <FONT color="green">004</FONT> * distributed with this work for additional information<a name="line.4"></a> |
| <FONT color="green">005</FONT> * regarding copyright ownership. The ASF licenses this file<a name="line.5"></a> |
| <FONT color="green">006</FONT> * to you under the Apache License, Version 2.0 (the "License");<a name="line.6"></a> |
| <FONT color="green">007</FONT> * you may not use this file except in compliance with the License.<a name="line.7"></a> |
| <FONT color="green">008</FONT> * You may obtain a copy of the License at<a name="line.8"></a> |
| <FONT color="green">009</FONT> *<a name="line.9"></a> |
| <FONT color="green">010</FONT> * http://www.apache.org/licenses/LICENSE-2.0<a name="line.10"></a> |
| <FONT color="green">011</FONT> *<a name="line.11"></a> |
| <FONT color="green">012</FONT> * Unless required by applicable law or agreed to in writing, software<a name="line.12"></a> |
| <FONT color="green">013</FONT> * distributed under the License is distributed on an "AS IS" BASIS,<a name="line.13"></a> |
| <FONT color="green">014</FONT> * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.<a name="line.14"></a> |
| <FONT color="green">015</FONT> * See the License for the specific language governing permissions and<a name="line.15"></a> |
| <FONT color="green">016</FONT> * limitations under the License.<a name="line.16"></a> |
| <FONT color="green">017</FONT> */<a name="line.17"></a> |
| <FONT color="green">018</FONT> /*<a name="line.18"></a> |
| <FONT color="green">019</FONT> * $Id: SQLQueryParser.java 468638 2006-10-28 06:52:06Z minchau $<a name="line.19"></a> |
| <FONT color="green">020</FONT> */<a name="line.20"></a> |
| <FONT color="green">021</FONT> <a name="line.21"></a> |
| <FONT color="green">022</FONT> /**<a name="line.22"></a> |
| <FONT color="green">023</FONT> * This is used by the SQLDocumentHandler for processing JDBC queries.<a name="line.23"></a> |
| <FONT color="green">024</FONT> * This prepares JDBC PreparedStatement or CallableStatements and the<a name="line.24"></a> |
| <FONT color="green">025</FONT> * input/output of parameters from/to variables.<a name="line.25"></a> |
| <FONT color="green">026</FONT> *<a name="line.26"></a> |
| <FONT color="green">027</FONT> */<a name="line.27"></a> |
| <FONT color="green">028</FONT> <a name="line.28"></a> |
| <FONT color="green">029</FONT> package org.apache.xalan.lib.sql;<a name="line.29"></a> |
| <FONT color="green">030</FONT> <a name="line.30"></a> |
| <FONT color="green">031</FONT> import java.util.*;<a name="line.31"></a> |
| <FONT color="green">032</FONT> import java.sql.*;<a name="line.32"></a> |
| <FONT color="green">033</FONT> import org.apache.xpath.objects.*;<a name="line.33"></a> |
| <FONT color="green">034</FONT> import org.apache.xalan.extensions.ExpressionContext;<a name="line.34"></a> |
| <FONT color="green">035</FONT> import org.apache.xml.utils.QName;<a name="line.35"></a> |
| <FONT color="green">036</FONT> import javax.xml.transform.TransformerException;<a name="line.36"></a> |
| <FONT color="green">037</FONT> <a name="line.37"></a> |
| <FONT color="green">038</FONT> <a name="line.38"></a> |
| <FONT color="green">039</FONT> <a name="line.39"></a> |
| <FONT color="green">040</FONT> public class SQLQueryParser<a name="line.40"></a> |
| <FONT color="green">041</FONT> {<a name="line.41"></a> |
| <FONT color="green">042</FONT> /**<a name="line.42"></a> |
| <FONT color="green">043</FONT> * If the parser used inline parser to pull out variables then<a name="line.43"></a> |
| <FONT color="green">044</FONT> * this will be true. The default is not to use the Inline Parser.<a name="line.44"></a> |
| <FONT color="green">045</FONT> */<a name="line.45"></a> |
| <FONT color="green">046</FONT> private boolean m_InlineVariables = false;<a name="line.46"></a> |
| <FONT color="green">047</FONT> <a name="line.47"></a> |
| <FONT color="green">048</FONT> /**<a name="line.48"></a> |
| <FONT color="green">049</FONT> *<a name="line.49"></a> |
| <FONT color="green">050</FONT> */<a name="line.50"></a> |
| <FONT color="green">051</FONT> private boolean m_IsCallable = false;<a name="line.51"></a> |
| <FONT color="green">052</FONT> <a name="line.52"></a> |
| <FONT color="green">053</FONT> /**<a name="line.53"></a> |
| <FONT color="green">054</FONT> *<a name="line.54"></a> |
| <FONT color="green">055</FONT> */<a name="line.55"></a> |
| <FONT color="green">056</FONT> private String m_OrigQuery = null;<a name="line.56"></a> |
| <FONT color="green">057</FONT> <a name="line.57"></a> |
| <FONT color="green">058</FONT> /**<a name="line.58"></a> |
| <FONT color="green">059</FONT> *<a name="line.59"></a> |
| <FONT color="green">060</FONT> */<a name="line.60"></a> |
| <FONT color="green">061</FONT> private StringBuffer m_ParsedQuery = null;<a name="line.61"></a> |
| <FONT color="green">062</FONT> <a name="line.62"></a> |
| <FONT color="green">063</FONT> /**<a name="line.63"></a> |
| <FONT color="green">064</FONT> *<a name="line.64"></a> |
| <FONT color="green">065</FONT> */<a name="line.65"></a> |
| <FONT color="green">066</FONT> private Vector m_Parameters = null;<a name="line.66"></a> |
| <FONT color="green">067</FONT> <a name="line.67"></a> |
| <FONT color="green">068</FONT> /**<a name="line.68"></a> |
| <FONT color="green">069</FONT> *<a name="line.69"></a> |
| <FONT color="green">070</FONT> */<a name="line.70"></a> |
| <FONT color="green">071</FONT> private boolean m_hasOutput = false;<a name="line.71"></a> |
| <FONT color="green">072</FONT> <a name="line.72"></a> |
| <FONT color="green">073</FONT> /**<a name="line.73"></a> |
| <FONT color="green">074</FONT> *<a name="line.74"></a> |
| <FONT color="green">075</FONT> */<a name="line.75"></a> |
| <FONT color="green">076</FONT> private boolean m_HasParameters;<a name="line.76"></a> |
| <FONT color="green">077</FONT> <a name="line.77"></a> |
| <FONT color="green">078</FONT> public static final int NO_OVERRIDE = 0;<a name="line.78"></a> |
| <FONT color="green">079</FONT> public static final int NO_INLINE_PARSER = 1;<a name="line.79"></a> |
| <FONT color="green">080</FONT> public static final int INLINE_PARSER = 2;<a name="line.80"></a> |
| <FONT color="green">081</FONT> <a name="line.81"></a> |
| <FONT color="green">082</FONT> /**<a name="line.82"></a> |
| <FONT color="green">083</FONT> * The SQLStatement Parser will be created as a psuedo SINGLETON per<a name="line.83"></a> |
| <FONT color="green">084</FONT> * XConnection. Since we are only caching the Query and its parsed results<a name="line.84"></a> |
| <FONT color="green">085</FONT> * we may be able to use this as a real SINGLETON. It all depends on how<a name="line.85"></a> |
| <FONT color="green">086</FONT> * Statement Caching will play out.<a name="line.86"></a> |
| <FONT color="green">087</FONT> */<a name="line.87"></a> |
| <FONT color="green">088</FONT> public SQLQueryParser()<a name="line.88"></a> |
| <FONT color="green">089</FONT> {<a name="line.89"></a> |
| <FONT color="green">090</FONT> init();<a name="line.90"></a> |
| <FONT color="green">091</FONT> }<a name="line.91"></a> |
| <FONT color="green">092</FONT> <a name="line.92"></a> |
| <FONT color="green">093</FONT> /**<a name="line.93"></a> |
| <FONT color="green">094</FONT> * Constructor, used to create a new parser entry<a name="line.94"></a> |
| <FONT color="green">095</FONT> */<a name="line.95"></a> |
| <FONT color="green">096</FONT> private SQLQueryParser(String query)<a name="line.96"></a> |
| <FONT color="green">097</FONT> {<a name="line.97"></a> |
| <FONT color="green">098</FONT> m_OrigQuery = query;<a name="line.98"></a> |
| <FONT color="green">099</FONT> }<a name="line.99"></a> |
| <FONT color="green">100</FONT> <a name="line.100"></a> |
| <FONT color="green">101</FONT> /**<a name="line.101"></a> |
| <FONT color="green">102</FONT> * On a per Xconnection basis, we will create a SQLStatemenetParser, from<a name="line.102"></a> |
| <FONT color="green">103</FONT> * this parser, individual parsers will be created. The Init method is defined<a name="line.103"></a> |
| <FONT color="green">104</FONT> * to initialize all the internal structures that maintains the pool of parsers.<a name="line.104"></a> |
| <FONT color="green">105</FONT> */<a name="line.105"></a> |
| <FONT color="green">106</FONT> private void init()<a name="line.106"></a> |
| <FONT color="green">107</FONT> {<a name="line.107"></a> |
| <FONT color="green">108</FONT> // Do nothing for now.<a name="line.108"></a> |
| <FONT color="green">109</FONT> }<a name="line.109"></a> |
| <FONT color="green">110</FONT> <a name="line.110"></a> |
| <FONT color="green">111</FONT> /**<a name="line.111"></a> |
| <FONT color="green">112</FONT> * Produce an SQL Statement Parser based on the incomming query.<a name="line.112"></a> |
| <FONT color="green">113</FONT> *<a name="line.113"></a> |
| <FONT color="green">114</FONT> * For now we will just create a new object, in the future we may have this<a name="line.114"></a> |
| <FONT color="green">115</FONT> * interface cache the queries so that we can take advantage of a preparsed<a name="line.115"></a> |
| <FONT color="green">116</FONT> * String.<a name="line.116"></a> |
| <FONT color="green">117</FONT> *<a name="line.117"></a> |
| <FONT color="green">118</FONT> * If the Inline Parser is not enabled in the Options, no action will be<a name="line.118"></a> |
| <FONT color="green">119</FONT> * taken on the parser. This option can be set by the Stylesheet. If the<a name="line.119"></a> |
| <FONT color="green">120</FONT> * option is not set or cleared, a default value will be set determined<a name="line.120"></a> |
| <FONT color="green">121</FONT> * by the way variables were passed into the system.<a name="line.121"></a> |
| <FONT color="green">122</FONT> */<a name="line.122"></a> |
| <FONT color="green">123</FONT> public SQLQueryParser parse(XConnection xconn, String query, int override)<a name="line.123"></a> |
| <FONT color="green">124</FONT> {<a name="line.124"></a> |
| <FONT color="green">125</FONT> SQLQueryParser parser = new SQLQueryParser(query);<a name="line.125"></a> |
| <FONT color="green">126</FONT> <a name="line.126"></a> |
| <FONT color="green">127</FONT> // Try to implement caching here, if we found a parser in the cache<a name="line.127"></a> |
| <FONT color="green">128</FONT> // then just return the instance otherwise<a name="line.128"></a> |
| <FONT color="green">129</FONT> parser.parse(xconn, override);<a name="line.129"></a> |
| <FONT color="green">130</FONT> <a name="line.130"></a> |
| <FONT color="green">131</FONT> return parser;<a name="line.131"></a> |
| <FONT color="green">132</FONT> }<a name="line.132"></a> |
| <FONT color="green">133</FONT> <a name="line.133"></a> |
| <FONT color="green">134</FONT> <a name="line.134"></a> |
| <FONT color="green">135</FONT> <a name="line.135"></a> |
| <FONT color="green">136</FONT> /**<a name="line.136"></a> |
| <FONT color="green">137</FONT> * Produce an SQL Statement Parser based on the incomming query.<a name="line.137"></a> |
| <FONT color="green">138</FONT> *<a name="line.138"></a> |
| <FONT color="green">139</FONT> * For now we will just create a new object, in the future we may have this<a name="line.139"></a> |
| <FONT color="green">140</FONT> * interface cache the queries so that we can take advantage of a preparsed<a name="line.140"></a> |
| <FONT color="green">141</FONT> * String.<a name="line.141"></a> |
| <FONT color="green">142</FONT> *<a name="line.142"></a> |
| <FONT color="green">143</FONT> * If the Inline Parser is not enabled in the Options, no action will be<a name="line.143"></a> |
| <FONT color="green">144</FONT> * taken on the parser. This option can be set by the Stylesheet. If the<a name="line.144"></a> |
| <FONT color="green">145</FONT> * option is not set or cleared, a default value will be set determined<a name="line.145"></a> |
| <FONT color="green">146</FONT> * by the way variables were passed into the system.<a name="line.146"></a> |
| <FONT color="green">147</FONT> */<a name="line.147"></a> |
| <FONT color="green">148</FONT> private void parse(XConnection xconn, int override)<a name="line.148"></a> |
| <FONT color="green">149</FONT> {<a name="line.149"></a> |
| <FONT color="green">150</FONT> // Grab the Feature here. We could maintain it from the Parent Parser<a name="line.150"></a> |
| <FONT color="green">151</FONT> // but that may cause problems if a single XConnection wants to maintain<a name="line.151"></a> |
| <FONT color="green">152</FONT> // both Inline Variable Statemens along with NON inline variable statements.<a name="line.152"></a> |
| <FONT color="green">153</FONT> <a name="line.153"></a> |
| <FONT color="green">154</FONT> m_InlineVariables = "true".equals(xconn.getFeature("inline-variables"));<a name="line.154"></a> |
| <FONT color="green">155</FONT> if (override == NO_INLINE_PARSER) m_InlineVariables = false;<a name="line.155"></a> |
| <FONT color="green">156</FONT> else if (override == INLINE_PARSER) m_InlineVariables = true;<a name="line.156"></a> |
| <FONT color="green">157</FONT> <a name="line.157"></a> |
| <FONT color="green">158</FONT> if (m_InlineVariables) inlineParser();<a name="line.158"></a> |
| <FONT color="green">159</FONT> <a name="line.159"></a> |
| <FONT color="green">160</FONT> }<a name="line.160"></a> |
| <FONT color="green">161</FONT> <a name="line.161"></a> |
| <FONT color="green">162</FONT> /**<a name="line.162"></a> |
| <FONT color="green">163</FONT> * If a SQL Statement does not have any parameters, then it can be executed<a name="line.163"></a> |
| <FONT color="green">164</FONT> * directly. Most SQL Servers use this as a performance advantage since no<a name="line.164"></a> |
| <FONT color="green">165</FONT> * parameters need to be parsed then bound.<a name="line.165"></a> |
| <FONT color="green">166</FONT> */<a name="line.166"></a> |
| <FONT color="green">167</FONT> public boolean hasParameters()<a name="line.167"></a> |
| <FONT color="green">168</FONT> {<a name="line.168"></a> |
| <FONT color="green">169</FONT> return m_HasParameters;<a name="line.169"></a> |
| <FONT color="green">170</FONT> }<a name="line.170"></a> |
| <FONT color="green">171</FONT> <a name="line.171"></a> |
| <FONT color="green">172</FONT> /**<a name="line.172"></a> |
| <FONT color="green">173</FONT> * If the Inline Parser is used, the parser will note if this stastement is<a name="line.173"></a> |
| <FONT color="green">174</FONT> * a plain SQL Statement or a Called Procedure. Called Procudures generally<a name="line.174"></a> |
| <FONT color="green">175</FONT> * have output parameters and require special handling.<a name="line.175"></a> |
| <FONT color="green">176</FONT> *<a name="line.176"></a> |
| <FONT color="green">177</FONT> * Called Procudures that are not processed with the Inline Parser will<a name="line.177"></a> |
| <FONT color="green">178</FONT> * still be executed but under the context of a PreparedStatement and<a name="line.178"></a> |
| <FONT color="green">179</FONT> * not a CallableStatement. Called Procudures that have output parameters<a name="line.179"></a> |
| <FONT color="green">180</FONT> * MUST be handled with the Inline Parser.<a name="line.180"></a> |
| <FONT color="green">181</FONT> */<a name="line.181"></a> |
| <FONT color="green">182</FONT> public boolean isCallable()<a name="line.182"></a> |
| <FONT color="green">183</FONT> {<a name="line.183"></a> |
| <FONT color="green">184</FONT> return m_IsCallable;<a name="line.184"></a> |
| <FONT color="green">185</FONT> }<a name="line.185"></a> |
| <FONT color="green">186</FONT> <a name="line.186"></a> |
| <FONT color="green">187</FONT> <a name="line.187"></a> |
| <FONT color="green">188</FONT> /**<a name="line.188"></a> |
| <FONT color="green">189</FONT> *<a name="line.189"></a> |
| <FONT color="green">190</FONT> */<a name="line.190"></a> |
| <FONT color="green">191</FONT> public Vector getParameters()<a name="line.191"></a> |
| <FONT color="green">192</FONT> {<a name="line.192"></a> |
| <FONT color="green">193</FONT> return m_Parameters;<a name="line.193"></a> |
| <FONT color="green">194</FONT> }<a name="line.194"></a> |
| <FONT color="green">195</FONT> <a name="line.195"></a> |
| <FONT color="green">196</FONT> /**<a name="line.196"></a> |
| <FONT color="green">197</FONT> * The XConnection will use this method to store the Parameters<a name="line.197"></a> |
| <FONT color="green">198</FONT> * that were supplied by the style sheet in the case where the<a name="line.198"></a> |
| <FONT color="green">199</FONT> * inline parser was not used<a name="line.199"></a> |
| <FONT color="green">200</FONT> */<a name="line.200"></a> |
| <FONT color="green">201</FONT> public void setParameters(Vector p)<a name="line.201"></a> |
| <FONT color="green">202</FONT> {<a name="line.202"></a> |
| <FONT color="green">203</FONT> m_HasParameters = true;<a name="line.203"></a> |
| <FONT color="green">204</FONT> m_Parameters = p;<a name="line.204"></a> |
| <FONT color="green">205</FONT> }<a name="line.205"></a> |
| <FONT color="green">206</FONT> <a name="line.206"></a> |
| <FONT color="green">207</FONT> /**<a name="line.207"></a> |
| <FONT color="green">208</FONT> * Return a copy of the parsed SQL query that will be set to the<a name="line.208"></a> |
| <FONT color="green">209</FONT> * Database system to execute. If the inline parser was not used,<a name="line.209"></a> |
| <FONT color="green">210</FONT> * then the original query will be returned.<a name="line.210"></a> |
| <FONT color="green">211</FONT> */<a name="line.211"></a> |
| <FONT color="green">212</FONT> public String getSQLQuery()<a name="line.212"></a> |
| <FONT color="green">213</FONT> {<a name="line.213"></a> |
| <FONT color="green">214</FONT> if (m_InlineVariables) return m_ParsedQuery.toString();<a name="line.214"></a> |
| <FONT color="green">215</FONT> else return m_OrigQuery;<a name="line.215"></a> |
| <FONT color="green">216</FONT> }<a name="line.216"></a> |
| <FONT color="green">217</FONT> <a name="line.217"></a> |
| <FONT color="green">218</FONT> <a name="line.218"></a> |
| <FONT color="green">219</FONT> /**<a name="line.219"></a> |
| <FONT color="green">220</FONT> * The SQL Statement Parser, when an Inline Parser is used, tracks the XSL<a name="line.220"></a> |
| <FONT color="green">221</FONT> * variables used to populate a statement. The data use to popoulate a<a name="line.221"></a> |
| <FONT color="green">222</FONT> * can also be provided. If the data is provided, it will overide the<a name="line.222"></a> |
| <FONT color="green">223</FONT> * populastion using XSL variables. When the Inline PArser is not used, then<a name="line.223"></a> |
| <FONT color="green">224</FONT> * the Data will always be provided.<a name="line.224"></a> |
| <FONT color="green">225</FONT> *<a name="line.225"></a> |
| <FONT color="green">226</FONT> */<a name="line.226"></a> |
| <FONT color="green">227</FONT> public void populateStatement(PreparedStatement stmt, ExpressionContext ctx)<a name="line.227"></a> |
| <FONT color="green">228</FONT> {<a name="line.228"></a> |
| <FONT color="green">229</FONT> // Set input parameters from variables.<a name="line.229"></a> |
| <FONT color="green">230</FONT> // for ( int indx = returnParm ? 1 : 0 ; indx < m_Parameters.size() ; indx++ )<a name="line.230"></a> |
| <FONT color="green">231</FONT> <a name="line.231"></a> |
| <FONT color="green">232</FONT> for ( int indx = 0 ; indx < m_Parameters.size() ; indx++ )<a name="line.232"></a> |
| <FONT color="green">233</FONT> {<a name="line.233"></a> |
| <FONT color="green">234</FONT> QueryParameter parm = (QueryParameter) m_Parameters.elementAt(indx);<a name="line.234"></a> |
| <FONT color="green">235</FONT> <a name="line.235"></a> |
| <FONT color="green">236</FONT> try<a name="line.236"></a> |
| <FONT color="green">237</FONT> {<a name="line.237"></a> |
| <FONT color="green">238</FONT> <a name="line.238"></a> |
| <FONT color="green">239</FONT> if (m_InlineVariables)<a name="line.239"></a> |
| <FONT color="green">240</FONT> {<a name="line.240"></a> |
| <FONT color="green">241</FONT> XObject value = (XObject)ctx.getVariableOrParam(new QName(parm.getName()));<a name="line.241"></a> |
| <FONT color="green">242</FONT> <a name="line.242"></a> |
| <FONT color="green">243</FONT> if (value != null)<a name="line.243"></a> |
| <FONT color="green">244</FONT> {<a name="line.244"></a> |
| <FONT color="green">245</FONT> stmt.setObject(<a name="line.245"></a> |
| <FONT color="green">246</FONT> indx + 1,<a name="line.246"></a> |
| <FONT color="green">247</FONT> value.object(),<a name="line.247"></a> |
| <FONT color="green">248</FONT> parm.getType(), 4); // Currently defaulting scale to 4 - should read this!<a name="line.248"></a> |
| <FONT color="green">249</FONT> }<a name="line.249"></a> |
| <FONT color="green">250</FONT> else<a name="line.250"></a> |
| <FONT color="green">251</FONT> {<a name="line.251"></a> |
| <FONT color="green">252</FONT> stmt.setNull(indx + 1, parm.getType());<a name="line.252"></a> |
| <FONT color="green">253</FONT> }<a name="line.253"></a> |
| <FONT color="green">254</FONT> }<a name="line.254"></a> |
| <FONT color="green">255</FONT> else<a name="line.255"></a> |
| <FONT color="green">256</FONT> {<a name="line.256"></a> |
| <FONT color="green">257</FONT> String value = parm.getValue();<a name="line.257"></a> |
| <FONT color="green">258</FONT> <a name="line.258"></a> |
| <FONT color="green">259</FONT> if (value != null)<a name="line.259"></a> |
| <FONT color="green">260</FONT> {<a name="line.260"></a> |
| <FONT color="green">261</FONT> stmt.setObject(<a name="line.261"></a> |
| <FONT color="green">262</FONT> indx + 1,<a name="line.262"></a> |
| <FONT color="green">263</FONT> value,<a name="line.263"></a> |
| <FONT color="green">264</FONT> parm.getType(), 4); // Currently defaulting scale to 4 - should read this!<a name="line.264"></a> |
| <FONT color="green">265</FONT> }<a name="line.265"></a> |
| <FONT color="green">266</FONT> else<a name="line.266"></a> |
| <FONT color="green">267</FONT> {<a name="line.267"></a> |
| <FONT color="green">268</FONT> stmt.setNull(indx + 1, parm.getType());<a name="line.268"></a> |
| <FONT color="green">269</FONT> }<a name="line.269"></a> |
| <FONT color="green">270</FONT> }<a name="line.270"></a> |
| <FONT color="green">271</FONT> }<a name="line.271"></a> |
| <FONT color="green">272</FONT> catch (Exception tx)<a name="line.272"></a> |
| <FONT color="green">273</FONT> {<a name="line.273"></a> |
| <FONT color="green">274</FONT> // if ( ! parm.isOutput() ) throw new SQLException(tx.toString());<a name="line.274"></a> |
| <FONT color="green">275</FONT> }<a name="line.275"></a> |
| <FONT color="green">276</FONT> }<a name="line.276"></a> |
| <FONT color="green">277</FONT> <a name="line.277"></a> |
| <FONT color="green">278</FONT> }<a name="line.278"></a> |
| <FONT color="green">279</FONT> <a name="line.279"></a> |
| <FONT color="green">280</FONT> public void registerOutputParameters(CallableStatement cstmt) throws SQLException<a name="line.280"></a> |
| <FONT color="green">281</FONT> {<a name="line.281"></a> |
| <FONT color="green">282</FONT> // Register output parameters if call.<a name="line.282"></a> |
| <FONT color="green">283</FONT> if ( m_IsCallable && m_hasOutput )<a name="line.283"></a> |
| <FONT color="green">284</FONT> {<a name="line.284"></a> |
| <FONT color="green">285</FONT> for ( int indx = 0 ; indx < m_Parameters.size() ; indx++ )<a name="line.285"></a> |
| <FONT color="green">286</FONT> {<a name="line.286"></a> |
| <FONT color="green">287</FONT> QueryParameter parm = (QueryParameter) m_Parameters.elementAt(indx);<a name="line.287"></a> |
| <FONT color="green">288</FONT> if ( parm.isOutput() )<a name="line.288"></a> |
| <FONT color="green">289</FONT> {<a name="line.289"></a> |
| <FONT color="green">290</FONT> //System.out.println("chrysalisSQLStatement() Registering output parameter for parm " + indx);<a name="line.290"></a> |
| <FONT color="green">291</FONT> cstmt.registerOutParameter(indx + 1, parm.getType());<a name="line.291"></a> |
| <FONT color="green">292</FONT> }<a name="line.292"></a> |
| <FONT color="green">293</FONT> }<a name="line.293"></a> |
| <FONT color="green">294</FONT> }<a name="line.294"></a> |
| <FONT color="green">295</FONT> }<a name="line.295"></a> |
| <FONT color="green">296</FONT> <a name="line.296"></a> |
| <FONT color="green">297</FONT> /**<a name="line.297"></a> |
| <FONT color="green">298</FONT> *<a name="line.298"></a> |
| <FONT color="green">299</FONT> */<a name="line.299"></a> |
| <FONT color="green">300</FONT> protected void inlineParser()<a name="line.300"></a> |
| <FONT color="green">301</FONT> {<a name="line.301"></a> |
| <FONT color="green">302</FONT> QueryParameter curParm = null;<a name="line.302"></a> |
| <FONT color="green">303</FONT> int state = 0;<a name="line.303"></a> |
| <FONT color="green">304</FONT> StringBuffer tok = new StringBuffer();<a name="line.304"></a> |
| <FONT color="green">305</FONT> boolean firstword = true;<a name="line.305"></a> |
| <FONT color="green">306</FONT> <a name="line.306"></a> |
| <FONT color="green">307</FONT> if (m_Parameters == null) m_Parameters = new Vector();<a name="line.307"></a> |
| <FONT color="green">308</FONT> <a name="line.308"></a> |
| <FONT color="green">309</FONT> if (m_ParsedQuery == null) m_ParsedQuery = new StringBuffer();<a name="line.309"></a> |
| <FONT color="green">310</FONT> <a name="line.310"></a> |
| <FONT color="green">311</FONT> for ( int idx = 0 ; idx < m_OrigQuery.length() ; idx++ )<a name="line.311"></a> |
| <FONT color="green">312</FONT> {<a name="line.312"></a> |
| <FONT color="green">313</FONT> char ch = m_OrigQuery.charAt(idx);<a name="line.313"></a> |
| <FONT color="green">314</FONT> switch ( state )<a name="line.314"></a> |
| <FONT color="green">315</FONT> {<a name="line.315"></a> |
| <FONT color="green">316</FONT> <a name="line.316"></a> |
| <FONT color="green">317</FONT> case 0: // Normal<a name="line.317"></a> |
| <FONT color="green">318</FONT> if ( ch == '\'' ) state = 1;<a name="line.318"></a> |
| <FONT color="green">319</FONT> else if ( ch == '?' ) state = 4;<a name="line.319"></a> |
| <FONT color="green">320</FONT> else if ( firstword && (Character.isLetterOrDigit(ch) || ch == '#') )<a name="line.320"></a> |
| <FONT color="green">321</FONT> {<a name="line.321"></a> |
| <FONT color="green">322</FONT> tok.append(ch);<a name="line.322"></a> |
| <FONT color="green">323</FONT> state = 3;<a name="line.323"></a> |
| <FONT color="green">324</FONT> }<a name="line.324"></a> |
| <FONT color="green">325</FONT> m_ParsedQuery.append(ch);<a name="line.325"></a> |
| <FONT color="green">326</FONT> break;<a name="line.326"></a> |
| <FONT color="green">327</FONT> <a name="line.327"></a> |
| <FONT color="green">328</FONT> case 1: // In String<a name="line.328"></a> |
| <FONT color="green">329</FONT> if ( ch == '\'' ) state = 0;<a name="line.329"></a> |
| <FONT color="green">330</FONT> else if ( ch == '\\' ) state = 2;<a name="line.330"></a> |
| <FONT color="green">331</FONT> m_ParsedQuery.append(ch);<a name="line.331"></a> |
| <FONT color="green">332</FONT> break;<a name="line.332"></a> |
| <FONT color="green">333</FONT> <a name="line.333"></a> |
| <FONT color="green">334</FONT> case 2: // In escape<a name="line.334"></a> |
| <FONT color="green">335</FONT> state = 1;<a name="line.335"></a> |
| <FONT color="green">336</FONT> m_ParsedQuery.append(ch);<a name="line.336"></a> |
| <FONT color="green">337</FONT> break;<a name="line.337"></a> |
| <FONT color="green">338</FONT> <a name="line.338"></a> |
| <FONT color="green">339</FONT> case 3: // First word<a name="line.339"></a> |
| <FONT color="green">340</FONT> if ( Character.isLetterOrDigit(ch) || ch == '#' || ch == '_' ) tok.append(ch);<a name="line.340"></a> |
| <FONT color="green">341</FONT> else<a name="line.341"></a> |
| <FONT color="green">342</FONT> {<a name="line.342"></a> |
| <FONT color="green">343</FONT> if ( tok.toString().equalsIgnoreCase("call") )<a name="line.343"></a> |
| <FONT color="green">344</FONT> {<a name="line.344"></a> |
| <FONT color="green">345</FONT> m_IsCallable = true;<a name="line.345"></a> |
| <FONT color="green">346</FONT> if ( curParm != null )<a name="line.346"></a> |
| <FONT color="green">347</FONT> {<a name="line.347"></a> |
| <FONT color="green">348</FONT> // returnParm = true;<a name="line.348"></a> |
| <FONT color="green">349</FONT> curParm.setIsOutput(true);<a name="line.349"></a> |
| <FONT color="green">350</FONT> // hasOutput = true;<a name="line.350"></a> |
| <FONT color="green">351</FONT> }<a name="line.351"></a> |
| <FONT color="green">352</FONT> }<a name="line.352"></a> |
| <FONT color="green">353</FONT> firstword = false;<a name="line.353"></a> |
| <FONT color="green">354</FONT> tok = new StringBuffer();<a name="line.354"></a> |
| <FONT color="green">355</FONT> if ( ch == '\'' ) state = 1;<a name="line.355"></a> |
| <FONT color="green">356</FONT> else if ( ch == '?' ) state = 4;<a name="line.356"></a> |
| <FONT color="green">357</FONT> else state = 0;<a name="line.357"></a> |
| <FONT color="green">358</FONT> }<a name="line.358"></a> |
| <FONT color="green">359</FONT> <a name="line.359"></a> |
| <FONT color="green">360</FONT> m_ParsedQuery.append(ch);<a name="line.360"></a> |
| <FONT color="green">361</FONT> break;<a name="line.361"></a> |
| <FONT color="green">362</FONT> <a name="line.362"></a> |
| <FONT color="green">363</FONT> case 4: // Get variable definition<a name="line.363"></a> |
| <FONT color="green">364</FONT> if ( ch == '[' ) state = 5;<a name="line.364"></a> |
| <FONT color="green">365</FONT> break;<a name="line.365"></a> |
| <FONT color="green">366</FONT> <a name="line.366"></a> |
| <FONT color="green">367</FONT> case 5: // Read variable type.<a name="line.367"></a> |
| <FONT color="green">368</FONT> if ( !Character.isWhitespace(ch) && ch != '=' )<a name="line.368"></a> |
| <FONT color="green">369</FONT> {<a name="line.369"></a> |
| <FONT color="green">370</FONT> tok.append(Character.toUpperCase(ch));<a name="line.370"></a> |
| <FONT color="green">371</FONT> }<a name="line.371"></a> |
| <FONT color="green">372</FONT> else if ( tok.length() > 0 )<a name="line.372"></a> |
| <FONT color="green">373</FONT> {<a name="line.373"></a> |
| <FONT color="green">374</FONT> // OK we have at least one parameter.<a name="line.374"></a> |
| <FONT color="green">375</FONT> m_HasParameters = true;<a name="line.375"></a> |
| <FONT color="green">376</FONT> <a name="line.376"></a> |
| <FONT color="green">377</FONT> curParm = new QueryParameter();<a name="line.377"></a> |
| <FONT color="green">378</FONT> <a name="line.378"></a> |
| <FONT color="green">379</FONT> curParm.setTypeName(tok.toString());<a name="line.379"></a> |
| <FONT color="green">380</FONT> // curParm.type = map_type(curParm.typeName);<a name="line.380"></a> |
| <FONT color="green">381</FONT> m_Parameters.addElement(curParm);<a name="line.381"></a> |
| <FONT color="green">382</FONT> tok = new StringBuffer();<a name="line.382"></a> |
| <FONT color="green">383</FONT> if ( ch == '=' ) state = 7;<a name="line.383"></a> |
| <FONT color="green">384</FONT> else state = 6;<a name="line.384"></a> |
| <FONT color="green">385</FONT> }<a name="line.385"></a> |
| <FONT color="green">386</FONT> break;<a name="line.386"></a> |
| <FONT color="green">387</FONT> <a name="line.387"></a> |
| <FONT color="green">388</FONT> case 6: // Look for '='<a name="line.388"></a> |
| <FONT color="green">389</FONT> if ( ch == '=' ) state = 7;<a name="line.389"></a> |
| <FONT color="green">390</FONT> break;<a name="line.390"></a> |
| <FONT color="green">391</FONT> <a name="line.391"></a> |
| <FONT color="green">392</FONT> case 7: // Read variable name.<a name="line.392"></a> |
| <FONT color="green">393</FONT> if ( !Character.isWhitespace(ch) && ch != ']' ) tok.append(ch);<a name="line.393"></a> |
| <FONT color="green">394</FONT> else if ( tok.length() > 0 )<a name="line.394"></a> |
| <FONT color="green">395</FONT> {<a name="line.395"></a> |
| <FONT color="green">396</FONT> curParm.setName(tok.toString());<a name="line.396"></a> |
| <FONT color="green">397</FONT> tok = new StringBuffer();<a name="line.397"></a> |
| <FONT color="green">398</FONT> if ( ch == ']' )<a name="line.398"></a> |
| <FONT color="green">399</FONT> {<a name="line.399"></a> |
| <FONT color="green">400</FONT> //param_output.addElement(new Boolean(false));<a name="line.400"></a> |
| <FONT color="green">401</FONT> state = 0;<a name="line.401"></a> |
| <FONT color="green">402</FONT> }<a name="line.402"></a> |
| <FONT color="green">403</FONT> else state = 8;<a name="line.403"></a> |
| <FONT color="green">404</FONT> }<a name="line.404"></a> |
| <FONT color="green">405</FONT> break;<a name="line.405"></a> |
| <FONT color="green">406</FONT> <a name="line.406"></a> |
| <FONT color="green">407</FONT> case 8: // Look for "OUTput.<a name="line.407"></a> |
| <FONT color="green">408</FONT> if ( !Character.isWhitespace(ch) && ch != ']' )<a name="line.408"></a> |
| <FONT color="green">409</FONT> {<a name="line.409"></a> |
| <FONT color="green">410</FONT> tok.append(ch);<a name="line.410"></a> |
| <FONT color="green">411</FONT> }<a name="line.411"></a> |
| <FONT color="green">412</FONT> else if ( tok.length() > 0 )<a name="line.412"></a> |
| <FONT color="green">413</FONT> {<a name="line.413"></a> |
| <FONT color="green">414</FONT> tok.setLength(3);<a name="line.414"></a> |
| <FONT color="green">415</FONT> if ( tok.toString().equalsIgnoreCase("OUT") )<a name="line.415"></a> |
| <FONT color="green">416</FONT> {<a name="line.416"></a> |
| <FONT color="green">417</FONT> curParm.setIsOutput(true);<a name="line.417"></a> |
| <FONT color="green">418</FONT> m_hasOutput = true;<a name="line.418"></a> |
| <FONT color="green">419</FONT> }<a name="line.419"></a> |
| <FONT color="green">420</FONT> <a name="line.420"></a> |
| <FONT color="green">421</FONT> tok = new StringBuffer();<a name="line.421"></a> |
| <FONT color="green">422</FONT> if ( ch == ']' )<a name="line.422"></a> |
| <FONT color="green">423</FONT> {<a name="line.423"></a> |
| <FONT color="green">424</FONT> state = 0;<a name="line.424"></a> |
| <FONT color="green">425</FONT> }<a name="line.425"></a> |
| <FONT color="green">426</FONT> }<a name="line.426"></a> |
| <FONT color="green">427</FONT> break;<a name="line.427"></a> |
| <FONT color="green">428</FONT> }<a name="line.428"></a> |
| <FONT color="green">429</FONT> }<a name="line.429"></a> |
| <FONT color="green">430</FONT> <a name="line.430"></a> |
| <FONT color="green">431</FONT> <a name="line.431"></a> |
| <FONT color="green">432</FONT> // Prepare statement or call.<a name="line.432"></a> |
| <FONT color="green">433</FONT> if ( m_IsCallable )<a name="line.433"></a> |
| <FONT color="green">434</FONT> {<a name="line.434"></a> |
| <FONT color="green">435</FONT> m_ParsedQuery.insert(0, '{');<a name="line.435"></a> |
| <FONT color="green">436</FONT> m_ParsedQuery.append('}');<a name="line.436"></a> |
| <FONT color="green">437</FONT> }<a name="line.437"></a> |
| <FONT color="green">438</FONT> <a name="line.438"></a> |
| <FONT color="green">439</FONT> }<a name="line.439"></a> |
| <FONT color="green">440</FONT> <a name="line.440"></a> |
| <FONT color="green">441</FONT> }<a name="line.441"></a> |
| <FONT color="green">442</FONT> <a name="line.442"></a> |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| </PRE> |
| </BODY> |
| </HTML> |
