\nCREATE OR REPLACE PROCEDURE procedurein?<\/span>(<\/span>p_param IN NUMBER<\/span>)?<\/span>IS<\/span>
\nBEGIN<\/span>
\n? ?<\/span>DBMS_OUTPUT.put_line?<\/span>(<\/span>p_param<\/span>)<\/span>;<\/span>
\n? ?<\/span>INSERT INTO tablein VALUES?<\/span>(<\/span>p_param<\/span>)<\/span>;<\/span>
\n? ?<\/span>commit;<\/span>
\nEND;<\/span>
\n\/<\/span><\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n\ud14c\uc774\ube14 \uc0dd\uc131<\/h4>\n\n \n\n\ncreate table tablein<\/span>(<\/span>val number<\/span>)<\/span>;<\/span><\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\nsqlMap\ud30c\uc77c<\/h4>\n <\/p>\n \n \n\n\n<?xml version=<\/span>\"1.0\"?<\/span>encoding=<\/span>\"UTF-8\"?<\/span>?><\/span><\/code><\/code><!DOCTYPE sqlMap ? ? ?<\/span>
\n? ??<\/span>PUBLIC?<\/span>“-\/\/ibatis.apache.org\/\/DTD SQL Map 2.0\/\/EN” ? ? ?<\/span>
\n? ??<\/span>“http:\/\/ibatis.apache.org\/dtd\/sql-map-2.dtd”<\/span>><\/span><\/p>\n<sqlMap namespace=<\/span>“Account”<\/span>><\/span>
\n??<\/span><procedure id=<\/span>“inProcedure”?<\/span>parameterClass=<\/span>“java.lang.Integer”<\/span>><\/span>
\n? ??<\/span>{?<\/span>call procedurein<\/span>(<\/span>#val#<\/span>) }<\/span>
\n??<\/span><\/procedure><\/span>
\n<\/sqlMap><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n\uc2e4\ud589\ucf54\ub4dc<\/h4>\n <\/p>\n \n \n\n\npackage?<\/strong><\/span>com.mydomain.data;<\/span><\/code><\/code>…………………..<\/span><\/p>\npublic class?<\/strong><\/span>SimpleExample?<\/span>{<\/span><\/p>\n??<\/span>private static?<\/strong><\/span>SqlMapClient sqlMapper;<\/span>
\n??<\/span>static?<\/strong><\/span>{<\/span>
\n? ??<\/span>try?<\/strong><\/span>{<\/span>
\n? ? ??<\/span>Reader reader = Resources.getResourceAsReader<\/span>(<\/span>“com\/mydomain\/data\/SqlMapConfig.xml”<\/span>)<\/span>;<\/span>
\n? ? ??<\/span>sqlMapper = SqlMapClientBuilder.buildSqlMapClient<\/span>(<\/span>reader<\/span>)<\/span>;<\/span>
\n? ? ??<\/span>reader.close<\/span>()<\/span>;<\/span>
\n? ??<\/span>}?<\/span>catch?<\/strong><\/span>(<\/span>IOException e<\/span>) {<\/span>
\n? ? ??<\/span>throw new?<\/strong><\/span>RuntimeException<\/span>(<\/span>“Something bad happened while building the SqlMapClient instance.”?<\/span>+ e, e<\/span>)<\/span>;<\/span>
\n? ??<\/span>}<\/span>
\n??<\/span>}<\/span>
\n??<\/span>
\n??<\/span>public static?<\/strong><\/span>void?<\/strong><\/span>callInTypeProcedure<\/span>(<\/span>int?<\/strong><\/span>val<\/span>)?<\/span>throws?<\/strong><\/span>SQLException<\/span>{<\/span>
\n? ??<\/span>sqlMapper.queryForObject<\/span>(<\/span>“inProcedure”<\/span>,?<\/span>new?<\/strong><\/span>Integer<\/span>(<\/span>val<\/span>))<\/span>;<\/span>
\n??<\/span>}<\/span><\/p>\n??<\/span>public static?<\/strong><\/span>void?<\/strong><\/span>main<\/span>(<\/span>String<\/span>[]?<\/span>args<\/span>)?<\/span>throws?<\/strong><\/span>SQLException?<\/span>{<\/span>
\n? ??<\/span>
\n? ??<\/span>try?<\/strong><\/span>{<\/span>
\n? ? ??<\/span>callInTypeProcedure<\/span>(<\/span>123<\/span>)<\/span>;<\/span>
\n? ??<\/span>}?<\/span>catch?<\/strong><\/span>(<\/span>Exception e<\/span>) {<\/span>
\n? ? ??<\/span>e.printStackTrace<\/span>()<\/span>;<\/span>
\n? ??<\/span>}<\/span>
\n??<\/span>}<\/span>
\n}<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n\uacb0\uacfc<\/h4>\n <\/p>\n \n \n\n\nSQL> select * from tableIN;<\/span><\/code><\/code>? ? ? ?<\/span>VAL<\/span>
\n———-<\/span>
\n? ? ? ?<\/span>123<\/span><\/p>\nSQL><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n\uc5ec\uae30\uc11c \ubcf4\uba74 \uc778\uc790\ub85c 123\uc774\ub77c\ub294 \uc22b\uc790\uac12\uc744 \ub118\uacbc\uc73c\uba70 \ud504\ub85c\uc2dc\uc800\uc5d0 \uc815\uc758\ub41c \ub0b4\uc6a9\ub300\ub85c tableIN\uc774\ub77c\ub294 \ud14c\uc774\ube14\uc5d0 \uac12\uc774 \uc815\uc0c1\uc801\uc73c\ub85c \uc785\ub825\uc774 \ub41c\uac83\uc744 \ubcfc\uc218 \uc788\ub2e4.<\/p>\n | | | | |