首页 技术 正文
技术 2022年11月8日
0 收藏 548 点赞 1,595 浏览 12157 个字

  存储过程是在大型数据库系统中,一组为了完成特定功能的SQL 语句集,存储在数据库中,经过第一次编译后再次调用不需要再次编译,用户通过指定存储过程的名字并给出参数(如果该存储过程带有参数)来执行它。今天,我们就开始学习java中调用oracle的存储过程。

java中调用oracle的存储过程

项目结构如下:

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAARQAAAC1CAIAAAARJZfRAAAdXUlEQVR4nO2d+VsT577A83fcH+4P97nXe+6×5/ZaBSltrdW2tL09Wnue3moX19P0YD2nPe4rFGUJuEUBF0RFAQ3IoiIxoIgouEAAQUBMWBMEspKELBMW5/4wYTI7Q0hIJn4/z/so8877vvOGZz6870zm/Y4I9R9Gs+Vsbmn6hcL0C4XZeaWjdgdx75B59PuUUj8eDgCCi8iPbUmzrg6/6jbp+o26vs72Z+lnc4l7Bwy25Ttz2eoCgODwjzw6velgSvqL6kOOruPurqPO9hT9wwNnU/fs2J+2Y3/awZR0nd4UQvLIxaJoqTrYvQCEjn/kOZiSbhusQq0PGNKka3LcOTJiZZdHLY0W4YjlfukRJyAP4A/8I8+u+AzUfIc5oSh2qcMpz9S5rJZGz8F5DfIA/oCvPNXV1RKJhG3vtv3nUf0N5vR6cvnO3Apld/LV2g1HbjLVJsgzNyc2yAP4A17yVFVVzZ8/f968eWwFftl+CX11BUuT2vw7pXm/J8p+3Zb767bcjhevbj5WLd12+dPd+U87X5XcaKbVZpRHLY0WieVysUg0daLLxcyTO2/+VCv0HEr1qR3YQfBeeH7mOjRIB+BMLw9mzurVqznk+VGcg/Zno/3ZLtX5Awdl6dfbb/RPYumWZtKEvMaKdehcP28tptVmnLZhF0K4JHIx8cSVi6d2kfM9OXgGLoS3AqkOuzzk4vQGAWA6eXBz1qxZwyHPVz9cQrtPOF+c/G1PweGS7sIXbno699D403a59pWVVpt4w4DlNKVOtKb20idg5AHG0yKlGL7JNfJwNggA3PIQzeGWJ+bbfGdr6s9brx3KV19W2ukpXaH77tfK/gEbU23StI2QyS1PtFTNIg+9sVnKA7oATHDJI5FI5hFITk5mK7nk64LvN1/be06VVWPJqrFk3SellALNR9+V9WoZzUF5yUOfthGuRqaKyaUen4hTLu/sjmgJQR5PQ2pptIhRHuYGAcBPt6ovX1P+IaZswUrFgpW3F6y8/c7K2+98pVj41e2FqxTvr6n86m8Ko9nFXpuPPCjrDQPvpI9kB7Uc8Zpf6h1M8LLRYjHzyMPWIPDG47fHc+wOt7+aAgBB4M9n2wDgjQLkAQAfAXkAwEdAHgDwEZAHAHwE5AEAHwF5AMBHQB4A8BGQBwB8JHTlOZ+4P9hdAAAugi+P06RturCl4eymhrObWvK2b1/1cezyxbHLF8d+vBj7Ie77lcHuIwAwEHx5ag6vtGoa7cMd9uEOQ/udHSuXdD1MV9ecjF2+uOtBelfNydjli4PdRwBgIODycAc/cBp7HyYtHny0b6Q1ebQ10aKM3/nVEtU9aefdY7HLF7+8d/xl1XGQBwhNAivPtMEPHh39dPjZOUt3oa23yNZbtPfbTzxzNnI6vjWWsTptrQCEHwDmjgDKwyf4wZ34hYhOTky7vv6o60G6+v4JbNqm5pi2MQQU4Ix8AAB+JVDy8Ax+cHvfAuTVNSw5+vK7K3fIk5c/OrPi0ZkV5UlL606vqDu94lbi0oZL65SXN9JqY6MK0Q5YQQ3MHQGRh3/wg5u73kb6cpC+HHPL8UenvxxSHkOGbiBDN5GhMmT4FjJ8CxkuR3Ryc+flqtSlLG1gow09KAHIAwSWgMjDP/hBybY/IV2ZJmVS9dFlpmfHkf7LSH8u0p+HaPIRTT6iuYJor5paMyvTPjH2NlErq6VSavAOjvADWIQDAPAbQb5VXfDbW8bH++9IPjTWH0TU6Yg6A1FnIl2ZSNcppOs00n3GqJTIk5YZehoZq3vvBngU4Qg/ANEHAD8TZHnyt/yxPH6xoW4H0p6ItCch7UlIRzLSkYJ0SJAXqfq6fWWHlum7mc0BgOASZHkaS1Jzt8wv3L7g2s5FRbsji/dEleyJKtkTVbzn3bJDnzzO3e0YGQpuDwGAjeA/YQAAAgXkAQAfAXkAwEdAHgDwEZAHAHwE5AEAHwF5AMBHQB4A8JGwkifpb2uD3YVZIpBHWQXSzUAjbHkepm18kLrxAfZv6sZfli8kbj4+sTnYHZwpAjkrBdLNQCNseaqSNraUxL2QJz0vjX+ctVny3fKWkgOd8qTnpfF1ZzbfS1o/h33xy7t+BXJWCqSbgSZ05eEOfoBR8fu6/vosQ+cVrTK7+dre3K3f9D89a+i8om3MVl7ZdSfhx7npKoqiIM8bSIjKM23wA4zy/T+oqqWahnNdNSfr83ak//ULz+aD9Cc5W28f+I69Kj22AeNrG+ViUbRU7lnX4Hn/NkNEBEJdWuyEmbQmF2NvfaTHZcAaYFl57gnbQHu5JFs4B/ICDa5fBeFjkl8LPv0bkcM/kkQoysMn+AHGjV1rnuTuVhbGPcnbU3Xip4PfLH2cu1tZGPc0f8/dY5tu7VnNUo8e24D2wmCR903Anh3YCcDy2lJyls+tycWkzGipmpc8ItKRvfVZwzmQu0T7VeAZ+PEobzWeXh7qnwxqg+FAyMnDM/gBiqLbvo7Z/NHCpG+XXvzH18fXxcSv+mDvyqXxqz74/eslx9d/duHvX8cuXcB8/236F9ATTxp8B9vPlCqzaY1ynvGVh/J+Y4ZFtWxdYvxVkImWqqnF8E2ukYezwbAgtOThH/wARVHD4KuLP69QlhzqqDzWdD35bvovcauWNBQfbJEffnYj+V765os/f2nSDTPU5CUP/WyejTw8W5tLeaKlaj6/CqbMmcoTNrqQCS15+Ac/wMjbvLK//ix2w0B5dXf8qiX4DYPHF7fl//Jnlnr02Aa0WY13ss55uuOTK+5pG8/WWOXxZKql0SKvGt7jkk5g5pklR5cYfhWEKZd3dkc6iPfgtL5xRZLAGwwHQkuemZLz05f4DYPHOduOr/8Mv2HwIOvXy+IvWGsyxDZgv8TnJc9Uk9PeMJipPITORovF0UzyiMW0+wUMgxTLDQP6r4IWS5JcO1oq9XaToW9ckSTC54IHFbo82Rs+f5K7u/Fa/NP8vXeObrr4j7/gm4qU9Rc2fRbsDs4BYXUJLiyELc/ZHz4+/cMneDr4f6TN8xs+DXYH5wCQJ2gIWx7EZrYbBvC0deXHxE23wxbsDs4BIE/QELY8FJjvrQFAYAgreQBgLgF5AMBHQB4A8BGQBwB8BOQBAB95Q+W5mfY/9KRIX2IzhOVDWEBAeEPlKU1d4B6boCRl4fqyY+8Ztc3B7h0BPz5VSXiSCPALb6g811LecbknKKmrOq6hYH3p0fcMrP4QHtKam8e0QJ4QJnzkqaurs9vtPAtfTVpod03gacWBq+vTSntqJep7cfUF6wtTo1nqeR/WnKNzMXyf5w8DwkeeK1euyGQyo9HIp3DuoUU25zieIrdkRW7JwjdzDy1iqUeQZ25ObJAnhAkrefR6/blz5wYGBqYtfDEhwmIfxxMmD755MSGCpR6jPAKJFkBtgdg/0jBKWSsUfksJ/EVYyYOiqNFolEqlKpWKu3B2fKRpdAxPmDz4ZnZ8JEs9xmmbQKIFEGuJCSuJqCvECWtR6cUAAuEmD4qiQ0NDCQkJZrOZo/CZuMUG6xiWenX2yC1Zy7bn4Dln4haz1CPeMGA5TUM2WgC5LG1QIY+jrMUAL+Emj8lk4jPyZOyP0lnGsFSv0kduyVoZfxXPydgfxVKPNG0jZAohWgApugFtmJmqTVm/Si8G4ISVPAaDgec1j3Tvu0Nmt6Kh78i1J5/vzYvckpV8tW7I7MaSdO+7LPV4yBNq0QLoIazklEXUhKNFi8X4B2QrBkwRVvLwv9t2ZHf0gMl9p0kTuSXr0925ey/e7xqyD5jcWDqym8etalJmCEcLoMtDKERoCqU5wlYM8BA+8szoex7Jzvc0BoQtSXa+F9CuBgeYevmb8JFnRiRuf79Pj7ClxO3vB7uD/gceMPA7b6g8v2/9gDsFu4N+xTMPhGHHz7yh8gDA7AF5AMBHQB4A8BGQBwB8BOQBAB8BeQDAR0AeAPCR0JUH0bUhurZg9yKoML/8BwgVQlGeyTGn/s6uvuz3hstjpy9NXojC9Dg+OZ/5JJTTX3Az5zA+qDbX8nQXxmQeiMksfOTZbk/LzJBxre7gy6OKAzGZB2IyD8RUtGM5WmWGJyfzQEzmgbRutqrtaYRaXsw1sYTqMZkHYmQ1Wk//M2R+6PJ0BEoenk+atektlPTSZHs9OaG5/KlR8VbfhQ8mHNM96MmwisuTTXw0kvPMozzIzP8s9e85zdHanMpDOk39I8+jCpIzmCdaZQaDEmS0yoyYzIy0imlL6mUyXL/2NGHLw/MZ57Qnnetud+Dpr4qOw09eoihqqjsyVLToVcG75oZL0xyJRR5ULuYrD+Oj0rwAefihl8kYGuEjD9+S5ppYymjpQzdnSgDl4RNR4F++iPv3b1Px9G/fSN76/jCKoohB1XPuQ335fPW5L6c5ErM8xMcgZzTy0KuTF1l6J3eEdQes8QPkYlG0VO6p5llPSl/jSTgo68JpPFYBbUkDKYYBwxoHYhmxmOlzEeGSRy+TkaZeWmVGjKxGi+0018R6SlKLoeSRB8eP8jyqOBCr1JP6zKfdWRJAeVAeEQU0wyOfXkwgps8uJfy5KOHPRQnqrC/1ZfNfnPzAruGMQsh8zUM8KcjXPFyXPOR1ZQQDxHJGB4lZrAEJvK8bFbGsYWNojZJBjlXglZ0Sw4Ax6gCtLuVzkWGXR6ssnLKoPc1ziULcmzFlFL2Y52fKhQ35mgcfNxiYTh7K8Bge8qA8IgqsKvp9t2I/JX2Uv0v3MLvnQmR/3tv9Jfu4jsQ08pCHEr5zHo9kpFXJKOEcw05/qpbe4mRoa6+530TP1E+25dbkFdUMQpP+TtBXm1I+FwnuaRvhGh3TYOpPPvGSg6EYOd/jCaMS+H0FwkgyjTy0veEhD5+IAv95atPi7L9T0n9kbByz6poPRRkV/6WMi5pwO9iqE04NyjjAsOSfB6S/2Niafqa1mrSbYMzxA+ZWHuaoA9RmWT6XB4o83msJvUx2YGqSRlCluzBGVqM118QSdjEUI4BP4fw0baMfJQzk4RNR4P6+b2V7VjGm+/tXt538ZqBg/vOjUbqnN1kaYL22oaz5n+aGAWMQDcqafrVUSrWRTVdiQAK/yUNeuz1NABD2OAe0z0WGLA/hqoYwBJlrYr1Dil4my0iryJgaKBiL6WUy76wMvz7xVR69TEYYlzB7ScXDQB4+d9sUWz5+lvK/9NR46HPFlo+HH5e0HVmsufLHxtS/0OvSrlMY/jzjFyuMXwCRizJcE1FCrTFfsHNdrM9YHlI3KaOHmP5dFNNHxmpzxDlgCiGHg8tD/cKHcIkiK0wj/LHXKjOmL0b8Toblex7iPA2lt+atS5SHLJIHocvD83ueMvGS5qTP6akh4bMy8ZKx0ZEHvy40Vf7h/t8X2gd7AtRVDsI12C3H56Je8wgRocvDk/Mr5uWteYchfbvg/Ip5KIo2S396tOudivX/3XPrwlx3LlyfieH8XLQBR2CEwxMGPLEOaTgSiqKW7ufamlJkxDDHHSPeWA4nwvVzBYVQfLYNAAQByAMAPgLyAICPgDwA4CMgDwD4CMgDAD4C8gCAj4SuPAGIYUB+bDq48Hx4IRArsSHku58IRXl4xzBgC1rAXjokvEFRlE2eOQljAPL4iSDLM7sYBmxBC5gJrQfVeMrDaxcQHAIuT3V1tUQiYds7uxgGbEELmAF5AP8SWHmqqqrmz58/b948tgKzi2HAFrQApYcTICz0JC4LJU73aPEA2GISSOlxCBhL0qeT5OWmfKdt/g1jQFkHx9BPhgYAJgIoD2bO6tWrOeSZXQwDtqAFjOEEKKv36QUo8QDYYxJ4T2avmGQRWOuSztmZy+OfMAaMvxI8F0Y43gRKHtycNWvWcMiDziqGAUvQAuZwApT3UtML0CaBDGUoZxv7O+LpddneEc/yiWgZ/gtjQP5TwPQZmYdFgEJA5CGaM608s4hhwLIKmuXihiTPtCfu9DEJOOWh150befiEMSDKw+oIMVQDwExA5JFIJPMIJCcns5WcXQwDtqAFjOEEKNM2egF6lBnumART8pBKyqVTf7yZ6pKXb/swbfNLGAPWAdsjIy1UA8BMkG9VzyaGAXvQAuZrXtLfWdarakrzlDKM8hBLUoIbkC+6iRfnUtaRhzSLCkQYA+p9FoZfFK3rAANBlifEYxgAAAcQwwAAfARiGACAj4Tis20AIAhAHgDwEZAHAHxEePJYrVaNRqN6M9BoNFarNdi/coAZgcljMpm0Wq3D4Rgfn3gTksPh0Gq1JpMp2L94gAGBydPT3e1G3G73mNvtdrvduu5bTSXLm0qWN5Usaype1lT8UVPx0qbiD5uKlpq0j93hwJgbcfd0s77rFggiApNHpVKNj48jbjeWlNfed1k7XNY2l6nOqbvt1F519J52qCX29l31+QvwYoJO4+PjKs4XHAHBQpDyuFwIlnqas2suvV996YPqnPerc96rznn33sWoexcja3IiehpP4cX4prYjUaKow220/OubRFFH2lyIy9V+OEq06foMm+V/IKYE8oQswpNnbGzM6XJhqU39Ki27tP55e1N7R+vLl89fvmzp7Hzc0pqcVdQ/aMSL8U1th6NEUWlttPzrm0RRh5+7XE5XW1qUaON13g1e3zT1lNim63wOxJTGxsZAntAk5OThfrGPSqVyu8ccDqfD4dSbrEfyaqqatM/7rJ0Dtl6dXWt09ukdnVrbrSfdZ4qfYsX8kEo3iqLSWh1Oh+N5WpRoY+lMa80qud0gT4gScvJwv1JOpVK53W673W6322/WtN2sVbX0Wtr6rT3D9uERl96CDI04e4ftbf3WXHmzsq3P7hdKNooiU1vtdru9NTVStLGET53W1EhPnVnidrtBntAkFOXR6/VsLzNVqVQI4rbZRm220Tx5o1JlaO2zvhgYHTC5TDbE5kBMNpfW6OzQWJ906ourWrCSTKlkg/fR/w1FWGZzaiT+M6mASBSZ2mwbtdlaJJGiDUXeXRuKGBqMlLTYmlMjI1MlGwg5xKMTD9ScGkltjXCUyNR2BOQJUUJRHhRFjUYj42u0VSqVy+WyWq1Wq/XwperWPmuhvHZXXFJjm9pqR37951aL3VV5/8m2PQnXqxpPF9ZZmSlaLxJFpjQTttYXWa3W5pRI7AdvFqV0c0qkyLvHW4rcoCdjqlxzSiR5J+FAzSnrp/Z4WyMdxeVygTyhSYjKg6Lo0NBQQkKC2Wwm7sXksVgsFotl27Gyll7L3oNHXmptqUfTR+zI9z+uNY8iianHOrS2nb8fPnj2joWRa+tFkSlN3u2mlEjR+mve/6kFvJt4CXJFaoPUHLYDerc8YJmk3SBPyBKi8phMJraRx+Fwmkxmk8n8c1JRS6/lQLK0Q2NLO35KZ3Gu+f5H3YgzIeVYu8a2dX/KrhO3sJLUVLBOFJGs9OY0JkVEJCnNJmVyhGhdAb2Ad7MxKUK0roBYUbSugN6g2aRMjiDkFKwTRSQ1kvZiB1ImR4imduGZ5KM4HE6QJzQJRXkMBgPHNY/dbjcajUajcf8pRWuv5czlkn/uTrh176nW6Izd8pvW4MwpuLkrTnKhsCI1p9rIjGytSBSRWO/dwjbqEyNEa2VTBbCfsNyp0vWJEZQd9PKyxMR6bCehUgQpDz8QfmhSa95+GI1Gu90O8oQmoSgP9902u91uMBgMBsPJqw9faAytfdbWXmubxqoetHcN2VWDo20aW0uvpf6lIbv0iYEV2Vrv3YC1MizvaWIE/rN3f0Ri4lpRROJTvMTatdSKnj2UTBm13NPECKwh74G81SLWriVm4q2APCFLyMkz7fc8o6OjOp1Op9PJFA09vZ3qAd3zfktrn7Wt39reb23ts7T0Wp73jShf9F9VKHUz4smhRaIfr86sjk/M5ECjo6MgT2gScvJwo1KpbDbb8PDw8PBwRV1rftn9vr6WweHe7oHhFxpDR7+pU2PoeTXU9vJFVlF12f3m4Znw5OAi0aKDT2ZUxydmdCCbzQbyhCaClGdwcGhwcKhfM3DpZt3+U7d2nbxJScdyKytqWwYGBrGS06e8H0QikUj0Qx7P8j6nmR8I5AlZBCZPT0+PxWLR6/WDbwZ6vd5isfT0QNitUERg8phMJq1GY7FYWL79DDcsFotWo4HFcKGJwORBUdRkMvV0dwd+BXRI0NPdDeaELMKTBwBCBJAHAHwE5AEAHwF5AMBHBC3P1Ct8A/G+dQCYjuDL4zRp6zPX1qatqE1bUZ+51mnS8q4K8gDBJPjy1KStdBnVky7DpMtg1TQ+zljLuyr95fEgDzB3BFye6upqiUTCttdp7H2YtHiwbt9Ia/Joa6JFGT94d0fLuW8a0r9sSP/y2cV1bjvz49UoioI8QHAJrDzYm305Xuj76Oinw8/OWboLbb1Ftt4iW881i7pwRF1g7b1u7b1u7Mitz/yavXnitI34/kB4LyAwFwRQHvyd2Bzy3IlbiOjkHOlO3EL2IzDLQ3qDKOgDBIxAyUN8mzyHPLf3LUAGrmHJ0Zuvvv3P+uyvHp5Y9vDEsofSZQ+ly+5J3q09+Xntyc9rT35Bq8028uAFYBYHBJCAyEM0h1uem7veRvpykL4cc8vxulOf65pOIEM3kKGbyNBNZLgMGb6FDJcjOrm583JV6lJabZAHCCYBkUcikcwjkJyczFayZNufkK5MkzKp+ugy07PjSP9lpP8y0p+LaPIQTT6iuYJor5paMyrTPjH2NtFqs0zbSK9JB3eAQBHkW9UFv71lfLzvjuRDY/1BRJ2OqNMRdQbSlYl0nUK6TiPdZ4zKFHnSMkNPI1NtlpFHDPcLgLkgyPLkb/ljefxiQ90OpP0Q0p6ItCchHclIRwrSIUFepOrr9t5K/FjfzWgOAASZIMvTWHo0d8v8wu0Lru1cVLQ7snhPVMmeqJI9UcV7osoTY55e2ecYGQpuDwGAjeA/YQAAAgXkAQAfAXkAwEdAHgDwEZAHAHwE5AEAHxGwPPfZuXfvXlVVVbA7CIQ5wpZnYnx8YmJ8cnJicnLi9evJ168nJybGX7+erK+vr6ysvFt1N9h9BMIZActTXV09Pj5G9+f168m6ujqn06lQKKqrq2fQonc5Nxm5eCrbT0+ash0IEBQClqeqqmpszM3oT2VlpUKhUCgUlZWVM2jR7/KwrcoDecICActz9+7dMTdS09RZ39Hb0NHX0NFX397b0NFX39H7oPnl4KtXfb29M5OHDd/k8dYCwhMBy1NZWelGXPcb2iYmJiYmJsbGxkYeXRwbG5uYmLjf0IYNQQqFwg9H8kUetTQa1AlzBCyPQqFAXM7bDxsRBHG5XIaKNH1tzkjzTQRBbj9snE4e74yKvAAIV4NYQESWh3E25s2Mlqoxd6Ricm0c4oGwleMM/ZCLGWoCIYSA5SkvL3c5ncWVtTabzWKx6MqT9ZmfGY1Gs9lcXFmLXf+Ul5czVZWLiaclHurAe06Toh8QSrPFSCA36MmYKke/wiEuQBJP7fG2Rj4KEKoIUp4vEouJSa/XZxdVXDpzNCcvT15Tn36l/FJpxeTE+OTkRFlZGUN96tXI1LmMn9OUAqzTtqlN+uUNOYftgN4t0tgDq8eFgSDl+dOmDGIaGBhQPKhPuVAiuVB6t7Yh40r56fzrExPjExPjN27cYKjPcC5HS9V+lYd8ycMqj1oaLaK3DfIIA0HKg6Loj1c3ElOhojav7D6WhoeHM3JLsFvYxcXFTLVp0zZqsF7itI16gjPFSCCWl0unRCRUiiblMVlKaA3kEQZCleftU/9HTCcvF+Ep/XJx4qlL2FdARUVFLA1Md8OAeP0vJY88jDESvHMvhlsO1IsfaqA5kUgkihaLYeQRFoKU59G2d+nJ6bC7HA6X04m4XG4EGXMjY2Pu8+fPz6DdOTtpwY6wQJDy1Ijf6jjyBTHViN9y2EfJ/rjG3IhUKuXf7Jx97w8PGIQHgpTnzup/pSf76CjdH46QcSQ8M6zAjwZzdiAg8AhSHoy9/Ah2N4GwRcDyAEBwAXkAwEdAHgDwEZAHAHzEn/IYzZazuaXpFwrTLxRm55WO2h3EvUPm0e9TSv14OAAILv8Pr7SMHbXnnewAAAAASUVORK5CYII=” alt=”” />

一、 在数据库创建存储过程的脚本,如果使用的是本地的oracle数据库,则需要开启服务:OracleOraDb11g_home1TNSListener和OracleServiceORCL。

存储过程实现:输入用户的工号,输出用户的名字、薪水和工作。

create or replace procedure queryempinfo(eno in number,
pename out varchar2,
psal out number,
pjob out varchar2)
as
begin
--得到该员工的姓名 月薪和职位
select ename, sal, job into pename, psal, pjob from emp where empno = eno;
end;

二、 在项目中引入oracle的jdbc的jar包,Procedure的代码如下:

package com.tomhu.procedure;import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;import oracle.jdbc.OracleTypes;public class Procedure { private Connection conn;
private CallableStatement stat;
private ResultSet rs; String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
String driverName = "oracle.jdbc.driver.OracleDriver";
String username = "scott";
String password = "******";
String sql = "call queryempinfo(?,?,?,?)"; // 调用存储过程
public void callProcedure() {
try {
Class.forName(driverName);
conn = DriverManager.getConnection(url, username, password);
stat = conn.prepareCall(sql); // 一个输入参数和三个输出参数
stat.setInt(1, 7566);
stat.registerOutParameter(2, OracleTypes.VARCHAR);
stat.registerOutParameter(3, OracleTypes.NUMBER);
stat.registerOutParameter(4, OracleTypes.VARCHAR);
stat.execute(); String name = stat.getString(2);
int sal = stat.getInt(3);
String job = stat.getString(4); System.out.println("name: " + name + ", sal: " + sal + ", job: " + job); } catch (Exception e) {
e.printStackTrace();
} finally {
close(conn, stat, rs);
}
} // 关闭连接
public void close(Connection conn, CallableStatement stat, ResultSet rs) {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
} finally {
rs = null;
}
}
if (stat != null) {
try {
stat.close();
} catch (SQLException e) {
e.printStackTrace();
} finally {
stat = null;
}
}
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
} finally {
conn = null;
}
}
} public static void main(String[] args) {
new Procedure().callProcedure();
}
}

三、 得到的输出结果:

name: JONES, sal: , job: MANAGER

友情链接

jdbc的jar包:  http://pan.baidu.com/s/1jHUTPRo

相关推荐
python开发_常用的python模块及安装方法
adodb:我们领导推荐的数据库连接组件bsddb3:BerkeleyDB的连接组件Cheetah-1.0:我比较喜欢这个版本的cheeta…
日期:2022-11-24 点赞:878 阅读:9,084
Educational Codeforces Round 11 C. Hard Process 二分
C. Hard Process题目连接:http://www.codeforces.com/contest/660/problem/CDes…
日期:2022-11-24 点赞:807 阅读:5,559
下载Ubuntn 17.04 内核源代码
zengkefu@server1:/usr/src$ uname -aLinux server1 4.10.0-19-generic #21…
日期:2022-11-24 点赞:569 阅读:6,408
可用Active Desktop Calendar V7.86 注册码序列号
可用Active Desktop Calendar V7.86 注册码序列号Name: www.greendown.cn Code: &nb…
日期:2022-11-24 点赞:733 阅读:6,181
Android调用系统相机、自定义相机、处理大图片
Android调用系统相机和自定义相机实例本博文主要是介绍了android上使用相机进行拍照并显示的两种方式,并且由于涉及到要把拍到的照片显…
日期:2022-11-24 点赞:512 阅读:7,818
Struts的使用
一、Struts2的获取  Struts的官方网站为:http://struts.apache.org/  下载完Struts2的jar包,…
日期:2022-11-24 点赞:671 阅读:4,901