Recent project with Struts+spring+ibatis
I am a novice, the first time with Ibatis
So check the data online, download demo, run ...
The beginning is more smooth, nothing more than some select/update/delete
Later encountered a stored procedure call, no way, online check, a step by step
The stored procedure is not specific, it's a DBA thing.
Pass in one or several integers or strings
It's oraclecursor.
Ibatis configuration file Ibatis.xml:
XML code <resultmap id= "Result-map" class= "com.xxx.xxx.Table" > <result property= "Rsid" column= "id" /> <!--conversion between Java objects and Oracle columns --> </resultMap> <parametermap id= " Parameter-map " class=" Java.util.HashMap " > <parameter property= "param1" jdbctype= "VARCHAR" javatype= "java.lang.String" mode= "in"/> <parameter property= "param2" jdbctype= "Integer" javatype = "Java.lang.Integer" mode= "in"/> <parameter property= "Result" jdbctype= "Oraclecursor" javatype= "Java.sql.ResultSet" mode= "Out" /> </parameterMap> <procedure id= "testcur" resultmap= "Result-map" Parametermap= "ParametEr-map "> {call testprocedures (?, ?, ?)} </procedure>
Then look at the Java inside Call:
Java code MAP Parammap = new HashMap (); String str = request.getparameter (...); int n = request.getparameter (...); Parammap.put ("param1", str); Parammap.put ("param2", N); List detaillist = null; try{detaillist = Getsqlmapclienttemplate (). queryForList ("Testcur", Parammap); You can use Getsqlmapclienttemplate (). queryForObject ("Testcur", Parammap); The return value is object. }catch (Exception ex) {ex.printstacktrace (); return detaillist;
Detaillist is the desired result set.
