hai, iam confused with issue of using declaration and scriptlet tag.
in my code i need to initialze Statement,Resultset..... if i do that as below <%! Statement st=null; ResultSet rs=null,rs1=null; ArrayList al=null,custal=null; int pid=0,si=0; PreparedStatement ps=null; String enqT=null,poT=null,serviceT=null; %>at the end iam closing stmt & rs in finlly block
will there be any problem if i do this.coz code in declrtion tag will execute only once & not for every request.
i think thr is no need to initialize in this block.
one more thing wat is the default initial value of String var? null/space
It would probably be bad to declare a database resource, such as Statement and result within the <%! scriptlet tag, since this becomes an instance variable in the generated servlet. when the JSP page is turned into a servlet by the jsp compiler, where as the contents of <% tags declarations end up inside the service() method of the resulting servlet.
Having a PreparedStatement and a ResultSet variable declared in the <%! as class scoped variables would make your JSP page not thread safe. More than one concurrent request to the page at a given time would cause compete for the class scoped defined variables, the last one to access it would squash it.
So if you must declare JDBC variables on a JSP page, then they should be in the <% tags, not <%! tags.
Error: Keyboard not attached. Press F1 to continue.