JNDI学习总结——Tomcat下使用C3P0配置JNDI数据源

时间:2023-09-20 23:21:05
JNDI学习总结——Tomcat下使用C3P0配置JNDI数据源

  C3P0下载地址:http://sourceforge.net/projects/c3p0/files/?source=navbar

  aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAArgAAAF6CAIAAAB9arxaAAAgAElEQVR4nO2dTVMcR7rv+UzwWeoraKdZcESwvGMs9eaeiLOyZ9rEPWPZGvc9RNizYI4sI8Z24FCY00hwmWnBwAwjCRoYM4hXgUB+6buot8yszKqsN7q6+vcLLbqrsjKfzHwyn39lZqORHgAAAICBkX4bAAAAANUFoQAAAABGEAoAAABgBKEAAAAARhAKAAAAYAShAAAAAEYQCkPL/vTkUqffRgBkojjvPVxoOI2Fw16vt9FyWhuF5AlQLyouFE7n/uMPc6+FC5sLI//ROSivwPPN+fnN8/D7/vTkzIj/b3qrvIIzmjTePo95cq4ZY3NpQkE1WMfWkoX98cnO55rzc0c9c4MY++6gPe9db27KvlRU2wpFTLpG3jhHm+PNzQOpRn2yRM/5XNOyqbVYe6/qjRstJ0TWBQgFAD0IBYn9pZmlfenCdDC9Hm2O9+MVXGdSYMb5XHNmZHZf85h/9+aFQsRgXdGuzfFNGt4VeiFEFAraBtH3XWdW0AdHm9NSiCqobbeWIhLkpunMuuYJNaqAVQJB9/VcfZZShdt6b8QbN1re+kEUhAKAnkEWCq8747eaI7eaI7ea05vBlYW5J38YudUcubXQ6e1Muwk+3wkfd69o1YbmVVgINltLI0J4m56dGXGnqqPNcfm11Z+jtY+HL1JeGv+lWT+J600Sp8ggYgnvjnJBI7P7kbt+PuorezRZfoOlbKV3R++tV2/MQXs+iNOd2Znx9nnvaHM8VAxaoaA0iL7vzAGmoLbVhuSIn8jG+EUr3hVtOrX9Ix0Ubdho7RIzKctasW1D8ef1r7Zc/cWgLrrqh4VEvTEqFAJ9IAiFYN3BS3u40NAuQgAMBdUXCp4UCP+5Mf51Z/yWryGCz68747ea409Oe71e53NXK/R6vZ3p4K6vDw6e/MFNJrK/NBOJcbqV26PNcWn2FK/Pzx0JYWlrabw5H4S98fZ5eKvnP+JPoF4CK5OkUBd5MAiQ2rfe4O7+tCQalJR+smIMVs3wVubD4KExRsxfFA0+JqEQPKjpO10+iqmFtG2vMyurIq2fGEOvGA7lUqLtr3RQzytdUH5eEWHdEzMpz9oQZUUhKEJbbuRiYICu+gE6b7QQCocLDT+J95G1Bhhuqi8UDCsKmwvhOkGv1/m8Ob3prSh40+KTP/gJTuf+ozm92TvwVhr8f8LjvV7PsGSuLF9HZkx5nvLWEvwEndn5uaP96ebmQTAtuu9Gwuw5Egaz6EK3ySQpmAlRQXm7UoKZclfKx5hJfoNjVryj875gjCIUIqLEKBT8umj6Lq1QyNq24kVNPFP8RCpa8S656TTtL3dQpBaatZzkTMqzNkQ6oxAuVkXL1V6UlYrBwbTDRzyjoJxh9D6EqwfBGoJ7ybRlAVB3hkwoqOIgxHACT9wd92NDolDwYpggEbbCVyvvKf+lOSZumU1Slsf9V3/1ZVcIZpq7OqGgSZbb4Nitcc1WuiAU1K0HuTTz1kNwPdJ3Cfv0RbWtVMHoK3uu0Kttf7+DeqqoCmoUtkZyJmVb2+spWw+hAWmFQqT6YQH64ZO8onC40NCvH2y02HqA4WRghYJx68EoFKRHNjtStsYTeEkrCvp10d5Be17cdJieXfK3bPeDdWB1031rU543Y0zSHLiTFpYjb726u8JCcfSFO0hWjMHh6vRc+7y3tRTZuNEYk3CYUbprc5gxjOVh4LE7zJi6bYMKSuJSu34uBO9o6I02XbT9lQ5StY5yLiEoIjaT8qwN0QmFLFsPSvXDihu80W7rIUizsbBw2OttbLjyQNiUABgiBlYo9ISTiZJiMAuFnrD7IC8tnG/OG07q635ipxyIC45ricHMICCEDIWdY90yvqVJml8DNpemxRimHLgL7+5Pe8fQlDNi0WQ5DRYPowk/PYicTYsYE5YlawjPJNVmU4NETroFpVv/PDJt2wpFBK2k85OgguPtTc07uq7pIu0vdVDkJV5dqnGrHJ9JmdYG6ISCoVzdRXGlRLbczd3ojVaHGSNnF4MNCxYUYBipuFC4GXRnnvpMBU2KJ6fB/PWnQtD+jnQIGbjhA1BpEApQBRAKAAAVBaEAVQChAABQURAKAAAAYAShAAAAAEYQCgAAAGAEoQAAAABGEAoAAABgBKEAAAAARhAKAAAAYAShAAAAAEYQCgAAAGAEoQAAAABGEAoAAAA1I/w/UPP/x6d1FwrBfw9bWIulQumqwgpXqqXmqSlWh40pdlllqJS2ZxzHcdT/BbgYC2vx/wMb26wOlRscZI/z3dXOD1M6N1QAq56tYMciFCxI7tySJ1dzICzAq4oRCjYtkSYrq1oVPuoKrGxliXWmDG0GOZA7I/CnVH44kF44rKTp2Sp1LELBgv6qQIuJPVfZxQqFODdKm1WsN9rEO8dxShUKyVbmYaOV0nrLLAtuM8iO1B9Coxc6UqBCpOzZygxEhIIFlp1bRqfa+lWOsksQCppsMmVlqlWqjMoWCk6x87TSHQU6VYrKVWZ+qjX6bYfonZt2QSiPwubAGwahYIHXSEqXRd/OCu/TiFeFJURKz9x1KYVCpBzTW2q0NeKz0g0hXYsahpq2/hutfEIhR2WzUppQ0Jgeydyvf0Vmp3ojO5vkagl+qBsCKIWBIP0cWI2eRShYcLiwoG2XSLcW3KXpnCrr5J5XKGhTZcwqWf6UO0cWWNmslCUUUijLw4UWQqF0DMcTer2ejR9GfbAS8QQSyDAHVqJnEQp5UFqv4PewpNztoloihQgFTcKoyRmmv8RXqWLbvMDKZqUkoVC2qIWUmI4n9Ho9Kz+kQweSLD1bhfW94RYK+lVs+0ZICuWmGKyKRm2JySok1umEMuIrVJRQ0NRLMTq9UFBSJOSfnwIra8jRti91WC2vGNqkuDfQFIXq0utSxrqg/nnharqTLKm61MrBDNtRse1rPp6gNT2PULixSuEYFtjMMGppuSYWSztSdpa9s2mSD5JQiD/+bTmHJnq6xs+NBVurDHOSbCcYChQKCWI4Mau0OqHwl6gCK5v4A4N4EaUjtCZl5qZHUs52yb+ZsDjCWkQ8kNPb1TXeyPgnDO2U0GfW025qwayzWFPajVUKx7CmAKGQrbVzPp4kFNK4zaAIhZwN7WK1PqT6+UKK1rTZ1jClSbVCX6RQiH/Pic8qcea7gcXWAiub8s8VFCwUnGj72UtUHdl/jVp4PFiIdZT0ozvbr5+TnzK3a9zxBG3myfNy3yqFY+T6k24p14py/ii8sM6yOINpzm8ghIJV56eXlvqIYt0vmmxs9qqNXtevFYX4XZUUPw3q06ZsgZX178WvigR3swkFy8ytioipa8rfdNmsENvbnVh42r8/EK9Pw7uxhifsHh4uNMwhJPZ4grYe8SYni8KyKoVjGAw3kudAd67WLrazTLvcuoIjbjMAQsHmzPxGK5VQSLe1JbtV3Ii32HmITdSPMwqaKqX/dbj1zmL1hILct4aHE5adrQ4zFpS5ZeMnBKaE9atS4kGYi/ATjQyjO8H5ja/+SWvcMSRtOxjrbCTe6hIrhWPo78YQP8PEGpqvtYvtLHNTWbhN9YVCnk3u2DnWkI/FeTdjrMkrFLJWrO9CwVSQ1RGfnBRYWcunkpZy09Yy8W019eqyjUCLS1N8PDC0SYbRnTjHmQJC9oFnoxNSjJTE0wvlVQrHSJGh2eh4zMsJ6Vq74M5KoamiVF4oJCyRpHvY3KXGZ1KtMtZEKGTcetA0WPlHGQutrN0TiXoojVBIztxUz5jn1KR2k7F51Td/PLBU5RbukfwuJBcec1rY1huTtx20dY5it7FRYqVwDIvOSHgugZi9k5StXXRnxQiF5BauulBIGQVS5qbLMU+wt3m2kBpV5TCjtknjthn7LhQsLEp/giqFUMh9KtecgTF6WMandDu6qeKB5Uu4hXfkEa6mpksIGXY6wdoym9fCsiqFY1hUPnvW8T91SNvaRXdW7BmFpFKqLhRyLupaZBnfu+lUXIbViGw1KlQoxDaITVYpjvKUsPdQYmVNZBIKOQJJcjXkR20XrYx2F364Xd/rGUZ3stBSsO9gm26L6Rz7U8qJO3SlVQrHSJep1mgd2pbM2dpFd5aSQbqxMIRCIaEH8giFDFE10yt22tf82ELihZNVVuZFshtQCkVVNsUrSXqhkCNz67qUN8XUKh6kmyCtdUKsHyZswd1YpXCMdJlqjbYeodUWCrqamRsIoZBFdNu+PCRHjGwVSsokhWcnRfJMQsF82CremEwUVNn4XdH4eJHY7Xkyt695qpUtzfOlrTCXFw9yTAiGyBITwuMLi/fDWKlwY5XCMbJQkFBI29pFd1aM2cljoepCwfJARzrSCAWbQ+jmF+ikEF6IToh6gLVnRxVlpsWJuEUJjWgtVioUU9mEhST5dlqhkCvzGEztbtkk1segNBnEp7B08wyju9hDS700ETzBugTL4kTqjVUKx8hC1qxztnbRnZXh2Hb4SNWFgkUo0z4U81/pJRxnS1gl1KSIC4sZj7fEknwi2M7F4s8hpsgqw8JqbCem+58QC6lswphKuJ3QI5kz32jFeoj92ZB0ctfiyGdCl9vq4Qyju/iAYDQ23UpPavke84JRWqVwjAxkzjlnaxfcWTZmG/un8kJBv42imYnFS/4zVlt5Sl4JYc28MWxKYFSIsa+W4pyvq1ps/yd6tn6pycYRk1YcbNPoy/PtSqOgiqls7Ft9kjQz9qz3n51nzTy4pWkPTa2EJ5PWcaL344+mxO7SRCtlvXCWYXRnXmQ0/cUr03yacqHHIpzYzw2lVQrHSE92CZKztYt9XF4qS+c2AyAUzHHG3IJ2T0QbvtdLfygm+cXBgOrHBi2ekJ12NKSof3xGWbLSZpSyVfMIhWz5myeD+IicVL3WRo7MU7VawuGSVA/nHQYpdtjSj+5kse4n0q5s2R7CSbPtEJtRbGVNx5tKqpTWhjiGwTGSyLNWkbO1cz0eKxQsHhikMwoeFt6ZZSxYnMVpNOKy0ju6TfEWLuEmic3M4LKpY6fZ9dNmlfIdIXUupVU2vp1bCW+XRge1UHvmzFNMyhauHGOBVUyTnyjizJq9nUkb/jZP2TSH4RXfxh+zboHFvewXXKk0DxnrUD/HSCLnpkau1s7zeLJQiGWgfvUQkuQCqYWC3dmQ1oYxs+xyWFt06hWFYqJ7yiNasaRens1oVEmVNYyexoL6f+FaHdRQkmbJ3HKOiKlVcuPE9Jmp+MbCYTGH2+3ttFnHT3oq8QHjMrZVZLANJ+b9h7IrlabBh8kxksh/+iFXa2d+PI9QUDMcHKHgom+ydO+I8f2s9/NspxCtlsL06WNXp5OKzyOUsmSVejswYak+FQVWNmqZ/5zdfnXSAZJsmZsrmGInO2ub2K3M544HcTWNtdPkSfmmhCy/Q7EOJ0k7z2VVSgeOkaeqacne2pkejz/MmM5tBk0olE+snwNA7Ul7PAGg5iAUVBAKAMNM+uMJADUHoaCCUAAYYjIcTwCoOQgFFYQCAABAAEJBBaEAAAAQgFBQQSgAAAAEIBRUEAoAAAABCIWAjZbmr99UUCio/7HFjbM/PbnUiV7eWhppbh7cvDkAAFAmVRcKN/iLZk8oVB6EAgAA3BwDIBSC6J3+f/PIXFSAKSr3MVojFAAA4OYYJKFQcoREKFiCUAAAGCIGSCiIAdL9vNEK9yPEPQo5VfRzmLixsNAScmgsLLSEPIQ8JQkRva4rPeRwoSFksNHKZLOUm/h/tAX/kbFahHwt4KA9PzI5MzI5MzK51On1OrMz4+3zXq/X6+1PT85Mb/V6PSHqH22Oe4n9W5JQ2J/2745MzvhCYX96cn5uy3tweqvX21pyE/gFmbKdn2tHUgIAQF8ZAKGgO6Pg/vU0KfBLYTKMntGgK+5gHC405GAf/o+N4X/ynLSiYChdqYafYqPl3k5ls1q0/B8K+fkpRWiFwtHmuLwecNCeH5nd7/V6va2l8ea8G6F99XA+N+svEmwtjXgPBkJBEBa9XmdWFAr+Z1ciuPmHRZuyFVPOzx1Fmx0AAG6aARAKuhgsh1B108C/qw26SuINeUUh3OWwFgqm0vX1EHSCvc2movUV84vQ464BCGHYj9+d2fm5o/3p5uZB73yuGSZQViBCoaDsNYRf96fD/E2ftdkGdyUDAACgjwyUUAi/JQqFxsJhH4WCZsHfvSqta9jbbCpa/qoWEcf5XDOQC25UFiTC1ua4sO/g7QKE6wG5hYIxW4QCAEDlGCihYFpRiC7jh1Heu3y40HDCEG3aesgkFEylR59otFqhhkhls1q0XAHhi1iEYethztssOJ9rehsHB+358aa3AeF+9qK4IAUO2vOxWw/nc80ZW6FgzBahAABQOQZAKOj++lE0fuuPEwb/E1yj1ZLf1A2HGVWh4KeNBFz5evxhRsFE06HIRJvlklutlrY4qQjDYcbOrH/20D0Q0PNe8b2QL50PcBceZkYmZ8Znl9QVhV54SnHEPYdou/VgyhahAABQOaouFErnBv/M0g0UNSh/NAoAAAaFIRQKhwsNw88lyi627D9/0Pe/sAAAALVjCIWCuPVwQyrB3WMoNYbfQBEAADCEDKVQAAAAADsQCgAAAGAEoQAAAABGEAoAAABgBKEAAAAARhAKAAAAYAShAAAAAEYQCgAAAGAEoQAAAABGEAoAAABgBKEAAAAARhAKAAAAYKTqQuHi4uKvf/3rysrKUwAAALhxKi0ULi4uVldX9/b2rq6ufgEAAIAbp7pC4aeffvrb3/62t7fX7yYCAAAYXqorFN6+fbuysnJ9fd3vJgIAABheqisU3rx58/Tp058BAACgf1RXKJydnSEUAAAA+kvVhcJPAAAA0D8QCgAAAGAEoQAAAABGqi4UfgQAAID+gVAAAAAAI1UXCu+Gid3d3X6bEFIpY/JTs+q4VKpSlTKmmgxPEw1PTYcEhEKFqNToqpQx+alZdVwqValKGVNNhqeJhqemQwJCoUJUanRVypj81Kw6LpWqVKWMqSbD00TDU9MhoepC4XqY2N3d7bcJIZUyJj81q45LpSpVKWOqyfA00fDUdEiog1BYnR4dGxsbGxsbHZ1eLbvBysRmdK38V3PkVvjvN2vX1//8f7+69cXDf15fX7/4jffhZozZezThtfzY2NjoxKO9tGXsPZrI8lgWLGeuwfKlxEqtTo9KDbz3aEKu2Or06Oj0qtARe48mIjW36yabFnabV9Oye48mRmPLCG1YnXY/FOQ8XgvoyyqYpCaSBlTohwn26Lqs32R2Bk13QAWoulC4SmD30cTo6PSK/3VlOvw8eOzu7iamWf6v5q++/Zd0aX/lV7c+/+/9q6urf/zG+3Azxuw+mgjaXukIyzIeTYxOPEqudAFYVqcKvmTfKsmVWpmWemVlemxsTLjgFxUWKfZpOoNsvHdlenRiIlqAdz2ujNCGlWn3Q0HOo7SQXFasIemxaSLfKKGMhCJ1XRaT9EYGnKUzjI2NjcoGaboDKsCgCwV5RA04GYVCSB+FQtW7wqI6ValAkUJBFj9enA4y15SUIuqkNsZr4kdqO+8+mhidnrZt/YK7KW1k6oNQsLBoQIXCxPT0xKgkFRAK1aQGQkHrV/L18Js7qFamR10xO73iC9uxsTHx5TgpjTcFmx4cHZ2YkN+wbYZooSsK//hNsD3x3E/5/Btvz+K//pFYUD6h4LVe0DhKP3mtITVK3CNiwrDUlWlvedZiZrETCql8yf2kmm2+7tkeLCmvCBd9t5menhZ2c5LqZdlHUss9Ei4EXaZdUViZHhsbk9cbchrjFaiEwd1HE+rF6OCKW1FwbfbaVn5DDUbxxKNH+u5NWFGQfWwl2jsFO6HYTjp7rq52H03ILqTrMqHu4oDKYHxQnLu9aFkBe2dw85dmAXmwlTcngD1VFwpvk+h+OTE2Njb60Yp8eeWjUeFa+K375cSo+HlsbEy4YZ/m7cqXX3bjMldMkO0xsLu7m1jf5f8rnlH4/I97b9/urfzK/fB260Pvw8Ef/735q28P3r4V7obJ3r7trHgfchnT/XJCqu2E1yTdLyf8z8FHbWuECQ2PhJcmJia8L95l4QmhM/JUJ60vrXw0qnS3a4/puug+Jn9Tmq+YSgnlf7Qi9JrsuVIiyVg7g2yMEfpOdIaJL7tCb2sHV2iDn1C2OfA+wRFVn9QOQc3IDHLW+ZjUGCU4odgmqj2eb4U+9KXfNGqXaQdURuNXPvLFlpVTWtc0qOTKR3L3Rd2unDkB7Bl4ofD27dvQlXXTufxNmqIMw8YmjYA22illyQPfhKVQ8BRAQFQodL4ZufXNsnfbFw17K7+61fywk1iCvTGeilInEantpUlXbQ29jIjMCt0vJz5a6X458dHKWzlOJGuvNNUJrbfzJSXEBBU0XFcjkiYGKvUvplJBOSsfyfYJPaI6vxhiSxAKusGmHyKamK3PQ7ZW1w8GrZ4kFIw3/S8lOaFOKOg7Qtdl+gGV0XhPQKfQCemEgigVDMOrlDkB7Km6ULhMwXJzdHT0zsMd/3NzWbzjftt5eCe8HvniPmybRjiZrHlQ/L7c9O2KZXd3NzHNs1bz9jc/yI8t3771+R93Ly8v//7hrc//uHu5883n4i8jRm75j3S+lr7mNSas73IzaPnLnYd3xmSU1glbw29PwyP+E8vNOw93Lpebo83ly52Hd4KmXG6K+eeujoiNL8nXQ+fQXw99R02vcxubKtlWyrMnbHb3k1hsxLElA+wMsjFGtUF2IcGDIoMrtMFPaBiwwTfVaqVbYi6LT0Z8LJptCU4oTxgmzxJuK10WNwazGG9oOzPpnMG35M7DnaCkG5gTwJ46CQVlNilTKIjZmyas4NayetlEUULhsvP1yL8vGwfK7vLtW80PO/mNEesrSAWTLPKSKxHBb0/dI+4T7pzgzg2attx5eMdiFkspFGx8SZk9g6+G6+pkK06JpQoFt3UfCk0cuaD6sNymZQgFt/pN6btGmElqKp1QMPZPxKQ4oRBeEWaQaGMU7IQGoWAuW+2ymAGVyfjlh+kCb2qh4GvzO3eE4VXynAD2DLhQELVkZDj7nrLz8M5oeUJBePeMCIXLy+Xm6NjYmKXPFiYULv/+obBs8Kz19bPLy8vO1744+OGP/164UBClgri+cLnclNuy2dS1ueGRnYd37tzxu9j9Era7GEwKmKNT+5K46iAmir0elZdR+63f32wDz3JzVGg5r/A7QnU1zi9YW4pQ8F4ZZfGiCoWwKTMIBcmplpujo6mFgtbHxAcKd8LQKJ1QcL1JaMGHktAUHcwwoHIYn4oMQsE1TpgtS58TwJ6qC4WLRLYf3hkNdsqbzyLXR0fvPHzY9G9tP7wTJop8ufNwO0Uat9DmQ/2DHs+ao97dZHZ3dxPTPG01b3/9g/zY8u1bn8/uXlxc/P0D74N70dt3+ODPbrofZv+3vxnR+nsRxij13XZnMb8l/PYRG+RZU7oStqfpke2Hd8Jelb4IXRBp9GzVSetLz5qjo82Hwa0gvem6d8vLP3SKqNs882fMhHpZVcq3X6mQoSMEY9yn7jzcFrspnzHPmmJGz5qCTcIt3eAKbfATGgas9G1b6IVnzVFdgz5rSn/jSK6v1sfE3inBCaPtJLd/YLB/TddlF6YBld34VKR3BsF+aYiXOCeAPYMvFKqN3RzrYT2P3ASVMiY/JVTHEHmM14unUn1UKWOipBqJJVHxJiqQ4anpkFB1ofBmsHn629HR31pXYnd3t0xj0lEpY/JTQnVMnZuu0/NQqT6qlDFv3rx58+bpb//tj6+Cz6Oj4bc+Ub0mKovhqemQgFAoi6e/HR0bG0s1N1VqdFXKmPwgFMqmUsZ4vPrjv/lr131XCW+q2UTlMDw1HRIQChWiUqOrUsbkp2bVcalUpSplTDUZniYanpoOCVUXCucAAADQPxAKAAAAYKTqQuEMAAAA+gdCAQAAAIwgFAAAAMBI1YXCKQAAAPQPhAIAAAAYqbRQePbs2eHh4QkAAAD0ieoKhfPz87/+9a8vXrzodxMBAAAML9UVCm/fvu12uysrKy9evHj9+nW/GwoAAGAYqa5Q+Omnn46Pj7e3tzc3N1dWVp4CAADAjVNdofDLL7+8e/fu+Ph4Z2fnb3/72wYAAADcONUVCr1e75dffrm+vj4+Pv7nP/+5t7e3CwAAADdLpYUCAAAA9BeEAgAAABhBKAAAAIARhAIAAAAYQSgAAACAEYQCAAAAGEEoAAAAgBGEAgAAABhBKAAAAIARhAIAAAAYQSgAAACAEYQCAAAAGEEoAAAAgBGEAgAAABhBKAAAAIARhAIAAAAYQSgAAACAEYQCAAAAGEEoAAAAgBGEAgAAABhBKAAAAIARhALUgpER/vGPf5X+BwMLnQe1gGkIoMowQgcZOg9qAdMQQJVhhA4ydB7UAqYhgCrDCB1k6DyoBUxDAFWGETrI0HlQC5iGAKoMI3SQofOgFjANAVQZRuggQ+dBLWAaAqgyjNBBhs6DWsA0BFBlGKGDDJ0HtYBpCKDKMEIHGToPagHTEECVYYQOMlXvvI2W47Q28uVxuNCI5HG40HAaC4f5Mg5ycpz8VgaZZcpoo1VQdW6aHB3ht7zjtDYi09D5XHNmZFL8Nz93VITBRvanCyzlaHN8cmZkcqmTLv3MyOTMSHPzwO6hzmzQOAkFWaQUGnx2X5vioD0v9Yi1nVlJNMntMm2NYm7ZkzkT13LXl9xMEn1YSKZp2PDu9JZwOXAb75HoqFnqBMly9hdCYZCpeudVXSjkzkfOoCyhkM3M4tRUCWVstPzHNlqOYyEUZkYmZ8bb5wXYrKefQiFDDBZif8IjFikjra0LzDcrFGxMqqhQOGjP+45kiNwKokxMEgpiO4Q9YhQK/q2tpbzDB6EwyFS988oSCkWR275hFwoFcLjQMAmFIGwHM2B56wr9FQqbnVQPesnEd1aD5TYpt5aEYGPMTYh/5WNlUiFqoGjcBvfC+flcMzDP2AgNZmYAACAASURBVLCekjMs5IjPjjfF+gqyQBYK3qqD24Z++s5svrZCKAwyVe88QyAOV53l29rrQvTdaDmO01g4FGKgezd4UAyMGy3Hv7igsUMszL8ZY4Cbm5RJUIB/RzFGTB2m1SkJQSgIJrgpI6UYcguutTYMT+k7RdAT0WwjdZdLkcVITOtpOygsPkkoBFfCtyLpRVmKKP5sqAk2S51gGTZ4jfMmaHUe1+UfuS7NvMFr3/zcVly8F3OQVpIDmyWTljrRlWcpmZehmpUmQ31K98VUadhobtZCwWx20K1bYjQVG8TL386kmIIETzD2uNoCkRdx0Z1iytJkpbsVdWnB1OZmx7dB96xX+rTYDkeb45Mz47NLwraCJBS8SgWVzbmogFAYZKreeTqhcLjQkAOREHNM1/0oLAb0UCg4YqCLfvTSGAK0HNKMhhlWCqIrCjoLhFT61/xQKGws+DcF26KlqLmJKfwsjCsKUq2DL1oj5bpHS1FSGltP0ytSumSh4EWL8fa5YWNiqSNHFD/8zM8dCe95XtiYFxZ7o2/bxvw1tyQhkrjOrD4uBzZFlIjvkZK1ShxVvopYpdQoKpNQiKlagNHsoFu9W7P7xsMoVibFFBQVCtEeN1UtRihoy4r2r65xpBpFrkdbQFPTpY4g+zzdtrUZFQrBP6mjpaWO9CAUBpmqd55GKKiX/O+m68JLrS5WGtb+ldxMWwzi9VgDTEv4xhBuNEabm27rwaQutLlJYTquJNkyoWS9kRohJJUS3LdsPWlzRngmlVDw5tbgrhBIwpl0f3pyZrw5Lz4yvaVdincjkCAUYvKXEAKJvMyrfg1Qrh9tzkWFQji/K+V6X8fb5wULBZ3KSRIKMWcUjGZHl4WUBhHMszEppqCIUND0uAa/jhG1EVdWxKRoy8TsKGk2CEwdFKxnLHXclgyWSRLPKMTYZglCYZCpeudFA3QkenkXTNfDBW31TVTcehCv+6sP6i5EglCIN8B08iDujIK0FCJhFgpKWo1QMObmbwpIOwEGgSNqGG3Bfj6RuiuliELFpvVUoeA/Y731ML0VWVOVplfx3Wt+7mh/enJmZHa/MzsjLS3406WwAhEKhdj8I2cDJ5c60WVeQ2CI5hxBXNhQ9+ADM5R8IrUwGmbcpBCW5cO2SmGkuMxgNFvTrZr3aT9MJpsUU5Bu6yG+BYIoq67oJFYqYpISjE2qUbzrPxKr5IQ1s/bmuJtMJxQUNSN9RSgMJVXvvOJWFOSX2SShUPiKQh6hYPHjRz+FaEPMikJMbsqif9xKSGtDzEufraHuQSl2KwoGodDr9Q4PrYRC8Kqke32XJ0Q3qEzPzo80Nw/EtW53irQQCnH5Sxu94fTtv4lKb8bWKwr706F00MRgcU9aXheRVsVjDzNapBQt1P4yYlbdEzHkYzbbJBTio5cxTUxBKYWC/viCeUVBKktuJXnrIaU0VCK9zpJQWkWFL0IB9FS983QBeqOl3/U2XZeCfyQGmuKQuFWhOYeosy/RgMQa2hjT22hFM9MIheDgptZONbcwU+XsZ5zCabVaymHIiJFyjaKlhM1k13rpth6Uf+pegHaJNVwhD7dyI++p8ULBnL9mM1ta39bdklBzjiwDiHWJOfdg9YNGfUu6KSUBYTg5EZvGXGKi2aLCMNXdxqSYgiyEQpiVacVeIxSS+rcnLX6Yzh/IC04Wv1/VWaIRvjFnazjMONRUvfOks/fRVXJ1FV57XYgtwcG4ZKEgLqa7JxwShYKFATFVDH/1EG9M/K8eBKMX1IMJ4cOa3LQFyE/pDI8cONBkK6SJpIicnkhovcxCQZ095QRi0FLe9qQtakuhEJN/eH28vSktR4dawf9thX61WczZK87wCwv5lxpqhtFfx5nQphRjj8akSBrZyORXZK3Z2pP/clNrYp7JpJiCbFYU5P1+K6Fg6gsBMR4bDyrqNzLM2Wo6Qid84/5sg8WOUiwIhUGGzrMibhEeqgDTkIZK/p2AZAbU7HhSVCrvXywog5w/eegxQgcbOs9E+Jf/oj/Kg8rBNKRhQCPugJodT6pKVa0FirCHETrI0HlmhGVyVELVYRrSULV4Y8mAmh1PLSuVBkboIEPnQS1gGgKoMozQQYbOg1rANARQZRihgwydB7WAaQigyjBCBxk6D2oB0xBAlWGEDjJ0HtQCpiGAKsMIHWToPKgFTEMAVYYROsjQeVALmIYAqgwjdJCh86AWMA0BVBlG6CBD50EtYBoCqDKM0EGGzoNawDQEUGUYoYMMnQe1gGkIoMowQgcZOg9qAdMQQJVhhA4ydB7UAqYhgCrDCB1k6DyoBUxDAFWGETrI0HlQC5iGAKoMI3SQofOgFjANAVQZRuggQ+dBLRgZ4R//+FfpfzCw0HkAAABgBKEAAAAARhAKAAAAYAShAAAAAEYQCgAAAGAEoQAAAABGEAoAAABgBKEAAAAwCBxtjk/OjEzOjEwudW6w2IoLhcOFhtNYOFQvtTb6ZRAAAEB/CIWC92966yaKRSgAAAAMAhGhMDI5MzK7X3axCAUAAIDBYn9a1ArNzYMyCxt0oXC40HB8gqtuko2WcF364hFcQ3gAAEDl8VcUxtvnvV5PkgtlrisMgFDQ4AX2w4VGGOSFL+5T4mfxS/jRkyAaNQIAAFAxpK2H+bmjXq/X68yWfl5hAISCcUVhoyWvBQTfpUUHKYvgi/QsSgEAACqPekbB1Qrnc81yfwoxwEIhci+4EBEKEUkQXalAKAAAwCAQKINAHHh7EP6WRMEMsFBIsaIQXTvYaCENAABgUNlaGhHEwUF7vrxTjYMsFNzTiOIZBeHQQYJQ6G20hFWEjRbHGQEAoOq4JxLc4wieOJAWFbyDC8Uy0EKhJ/5yQUhnIxSkg5LIBAAAqDz+zxy8lQPvq6sbRA1RLBUXCgAAAOCiCAVPHIi7D2UcU0AoAAAADAbKsoEoDhAKAAAA0AcQCgAAAGCk0kJhCwAAADJRVCyuulBwP/wCAAAAdogBND8DIBR+BgAAgDQMkVD4+eeffwIAAIA0DJFQ+BEAAABSMkRC4R0AAACkZIiEwjUAAACkBKEAAAAARoZIKFwBAABASoZIKLwFAACAlAyRULjU0J1/33Ecx/lkVbi4+knkEkD1cB014qy+Uzvvz3dT5ec96GamjoIg109W0w8QKeeyCSwV24ZB7aI0TgYvSYvb8gWVksWRVj+JlO+NnDAbfyipVzI4TD09bYiEwoWG3a/vecPl/mpwsfN7x3Gc33d0DwBUBtdRHcdxnAeh+3bn73oX7329myo/bzS4ni+PgtX7QVG/76QfIFLOpSIYGth7ccGg9glnPJGpx93SSnRbPq0vGkjvSN3Hdx3Haa2/eytc3P+24RrlVbvrt0pwZfWB4zhOa+06tYn19LQhEgpvNHSFYfPxinfxLw8cx3Ee/EX3AEBlcB210Wg4jvOp773bgU5w7n3dTZWfNxpcz7/6sdfr9X68cjP9013HcRoLh71e78cr6Vb6nMtk5VPHcRynteEP/I2WpjpDjNsTbk/2er3DhYbrK+/PbZdUouulaX3RQGpHcodD67nc8ZeeUniwKiRyHMdx7s5vv3kTOPw3e+lNrGf4GCKhcK7BGzatVsNxHOfj5fPz8/PzP7s9/efz8/Pz8+WPReXtpfAvf7wc3P94WUwcpJNzeO+rbZ0VAFlwHfWzzz5zHMf51HW57cd3A4e+93XXTyq5seSGwZ33vlr1ZuE/h9c/XlaHwHtfbYe3IpmLWZtyLr9JHOd93463P/74Vq7O9lfvOQq+1UMwVN0ZL/CMi+ufPa1w97FXYZ2ryD3uflNuuc363lfbQftK02noiyZXNMy053GOJDwjPiA8et9xnMbCD2+V6xedzxzH8UbN9uO7TjBoHqyen5+frz5wHKfx7f5FpBz94BGui+FDig4DzRAJhTMN2+6w+eaHfy14UuHs7MxddXqwenZ2dvYq1JqePzx6dRakufu+MOe89544AX28fHZ2dvbqkTopec8D5MZz1OfPW47jOJ8sn52dvZq76ziNb59/44aD7bMznRMG/ilPzh6u54ejYPWBePfe19vSADF4eEzOZXL540ZLO9pCm7eji+/3vt4elqHqzXiuZ5ydnZ2dvXFj5r2vt82ucim42Nmyt59/d+6VP0G2nl96Gd+dCh98/9GrM7/l3RJjXNE005odSc5M61vLnziO0/h2/03kjleju/Ovzs5WXFXww/PP/Eq6Vfys80Zrs2uZ6XroaZ7prY3ej5cFd+ONM0RC4VTD9p/uOY5z70/b51eeVPjds1O/p09PT0/Pr34O8nCnoE+XT09PvTTOZ+vhDefet4e9YDHv7vzL09Nngaf0gjvvf/VSZwlAWnxHvey40/iz05dfve84jW/3ur5fnwZOGKw2e976ybPT02efiP7p33E9PxwFl+88120sHPZ6P1+dCwPE5OFxOZfL5bugOJffPZOrEwxpf9m9sfCvq/NhGarbgmd4eJH8T9sxrhK62OmzT/ztrve/enm6/KnjOK3OpZexNwl6D366LGUf54qmmTbGkZY/Fe+8u4zU9eWj9x3Haa1fnWsawqvRp8tuEY1v987dS3fnX7501U/n8jTGw00O43vas995ddVYNngMkVA40fDKGzavTk7OAqlw3+vpk5OTk5Onv3Nk3OveWZfOxcnJyUn364bramcnJydnf3EF+p9e+alk7v3plc4SgLT4U9LJhTvp3f/ykasTzgS/fvH4ruNOl2fuU17iu49f+LdcL/b9WPJwbxQI+cm3DB4em3P5XLzr9XpBVLn/VK3OycmLL38dxKyfr86GZ6jKPXlyEjjIZ385i3GVwMWePr3vOI1v/7Xechzn0+Wn9x3HaXzd9TP2JkEvteAi9/70Ks4VTwwzbZwjeU87juM4v/7yRaSqTz92HKex8M8LfUu4Wd19/OV9r/r+pfcfPfrUr5XZMYwOI90I6zrgDJFQONbwav6e4zj35l8dHx8fn739wT/a4zjOg5Xj4+Ol/3RCAezOOw9Wjo+Pj1cehJ/lXLxb9+Zf+R8DAd3r9Xq9n96e6SwBSEvohG/CObPx7e6Z6JFnf3Z/G/HxkvfUkvsq9Ps/n7mpglv/ePS+k8LDH6wcGz08NucyWfrPXz/8h/9l24sqoaEPVo6Pj//x8NfeLL4RjsZhGapyTwpt0XkT5yq+i939+OO7TuPb3TO3baem7noel+Qi9+ZfxeZvmGljHenNu56weiR0fJi5a5uWs91vw9m+1XmjXPKfNDmG0WHcG60Nb8FKNWtAGSKhcKThpefdL92vp4JUeLBydLQ1p+ybedePjvyBoMnFHxgvj46E+TvwZq0dAOkRnDDwtMa3u6eyR0ad0HGcxsL+m6NTcapM7eFyubKHx+ZcfpNItDpvRJu3Hka3yX/9cGtYhurLec3PIxsLh9dvjuJc5ejoyJNdjuP8/s+nQg+7Hmd2kdj50M/fNNPGOdLS/5GuBbP40dHR0dHWwynHcVprb0+NTSHk7frIUbRW5jnc6DB+1YNg8l4dHGmIhMJrDS88737hXzi59KXCg2Xxm+M0FhZa/vXXr5cfhJ+VXJa9gfHi9evX59fhD5AcRy4KIB+iE56781bj2+7Ja8UjI07Y2uj9dHny+vXrk8ufwjvBO5Clh3vl6j08LucyOVem79ZG7/pcsvmFJlLem38xLEM1Uv3GwqHnDa/jXOX165OuF0RbnXPhq+dxZheJnQ/9/I0zbYwjLUtr/BtBJV6/fv3671++H1hq5GTV+0Mkja+31Uu/X/VzMzmG6XpY9bBS/+u//5675/rLEAmFQw3Hlz/1er2fLo/VS73e9Zn4rdf76fLyOrx+JnxWcnFvBXmGOfTUogDyIDmh5HaqX8tO6D2h3Lk+8z5beniQi8HDjTmXimtbtKqBzbK1ks3DMFQj1Vermewqkk8EzxtdJHY+DPM3zbRmR5K6Wnat/3E3MvYT/M3PQWgD/5KUn8kxtNfF0eEnGHxfGnKhAAAA9eLsuleH6Fwhhkgo/AsAAABSMkRC4QAAAABSMkRC4QcAAABIyRAJhX8CAABASoZLKOwDAABAGoZIKBwdHe0BAABAGoZIKPz444/7+/u7AAAAYMdwrSgAAABABoqKxZUWCr1e7wIAAADSU1QgRigAAADUkKICMUIBAACghhQViBEKAAAANaSoQIxQAAAAqCFFBWKEAgAA1ISTk5P19fV2u/0kE+12e21t7fj4uN/1KIaiAjFCAQAA6sDJyUm73e52u1dXV9kiztXVVbfbbbfbp6en/a5NARQViBEKAABQB9bX17vdbv64s7Ozs76+3u/aFED+pnBBKAAAQB1YXFy8vr7OH3eur68XFxf7XZsCyN8ULggFAACoA0+ePCkq9Dx58qTftSmAoloDoQAAAHUAoaBQVGsgFAAAoA4gFBSKag2Egsxe5/bkzIj778POtt1DT7/wH5n8/mm59kEN6D6ecjymHneFG6v39de9R9SL4lOGe0k5mEvUlhJNKdTFub8abwJAySAUFIpqjYEUCuGclTw/pmP7u7mRQCjYaQVBJaSTFzCUdB9PhU67ej90YeFz9/FUGHbjY3n38ZQzNTUVOxBMOZhK1Odgsk38XPBwBEgHQkGhqNYYOKEgiIRYsr3dbH/X8ZYEvKWFpBUCL9nc7N7FxcXLD8LPABaEkXb1vhhmu4+nFBeW70vJuo/jhYIhh6QSk1PKz4iqAaAfIBQUimqNoRYK4mLAB8/le8+/H5mcGfni5cXFha8Avn/qfRDSS8m8DNWslDzDxw9mP5wZmZybfd65HclEbxXUjCAEq1E2EnU1QsFfnMgmFBJLtEhpvyYBcAMgFBSKao2hFQpukI6G5FAKCJsI3lLBbemRudk9b6vi9ncHbjrlq4R4+kEWCl62X7w0WwW1RIjwmtf9BKEQXsgsFOJLtEsZHFJg2wGKQJjhQ3e0PQqDUFAoqjWGVSh4L/ffBxsNs8/dT4JQCEO+d1ERE7e/O0ghFOS1h4uLi0AWhOmNVkENkTb11WAc2QmICfPFCAXz3kNMSv8gpTuRoxUgH/qDLvZHYRAKCkW1xpAKBe/QohS2FcQDB8HWg4e7OxAIBd3Wgyg43AejaxX+1oN/psHCKqgJ6nynWd43LSBcyC9Yis+LAyT2lIOxxEgOsSnltz6kAmTHsKiV4igMQkGhqNYYUqFgeHd/+UEYpKNCwV9R8DcRPniunHm0OMwYHFP4sLMdEQqsKAwJmrciJcpaHmbUPhtTqpgqscTElOojnGaEPBhd3P4oDEJBoajWGFahIG8x6JYBxFf/yPUwnKunCozrAcJJRqNQ0FsFtcIUToXrushfuFBILDE5pSR4OM0IuXB1Z9Lf64h3dISCQlGtMbRC4UKO8V60lv4ognqY8fun4YFE8WeTQj4xf0RBEgqiyFBWIDRWQX3Q+G/0XKDkvpEnIq6dJBTMOehL1GFIKe2BoBIgB64v+U4U/VsiNkdhEAoKRbXGMAsFe9QzCgAAUCSq3g2WsVIchVlcXHz37l3+uMP/HqkwcEKhLyAUAABKxXDaNs1RmLW1tW63mz/u7OzsrK2tlVzfmyB/U7ggFGxAKAAAlIu4WCBsPaQ4CnN8fNxut7vdbuZ1hXfv3nW73Xa7fXR0dBN1LpmiAjFCAQAAKoH2zy2lOgpzcnKyvr6+uLj4JBOLi4tra2vHx8dl1/RmKCoQIxQAAABqSFGBGKEAAABQQ4oKxAgFAACAGlJUIEYoAAAA1JCiAjFCAQAAoIYUFYgRCgAAADWkqECMUAAAAKghRQVihAIAAEANKSoQV10obAEMMrsAAH2iqEBcdaHQb0EGAAAwkBQViBEKAAAANaSoQIxQAAAAqCFFBWKEAgAAQA0pKhAjFAAAAGpIUYEYoQAAADXB/W+m2+12tv9mut1u899MR0EoAABAHTg5OWm3291u9+rqKlvEubq66na77Xb79PS037UpgKICMUIBAADqwPr6erfbzR93dnZ21tfX+12bAsjfFC4IBQAAqAOLi4vX19f548719fXi4mK/a1MA+ZvCBaEAAAB14MmTJ0WFnidPnvS7NgVQVGsgFAAAoA4gFBSKag2EAgAA1AGEgkJRrYFQAACAOoBQUCiqNQZSKKzed3ymHncLbde9zu3JmRH334edbbuHnn7hPzL5/VNjqpcfGBPE3IL60X08pfff0LFVv+4+njI6++p9m4Ggz8FcoraUaEqhLs791XgTAEoGoaBQVGsMnFAQREIs2Sat7e/mRgKhYKcVBJUQ/whCAS4uLrqPp8JIu3o/jLvC5+7jqdCD42N59/GUMzU1FRvnTTmYStTnYLJN/Fy0bgdIBUJBoajWQChIbH/X8aK1t7SQFLy9ZHOzexd+vHc/R0ENQIQw0q7eF8Ns9/GU4sLyfSlZ93G8UDDkkFRickr5GVE1APQDhIJCUa0x1EJBXAz44Ll87/n3I5MzI1+8vLi4EGK8+0FILyXzMlSz8jBnImoIV3l82NkONkH8zKGGBCFYjbKRqKsRCv7iRDahkFiiRUr7NQmAAHG/SrvOZZrEE3fZEAoKRbXG0AqFg9kPpS0DOWYrmwjeUsFt6ZG52T1vq+L2dwduOuWrjDETnVCYu62mgfohRHjN636CUAgvZBYK8SXapQwmfbYdwBKzw8btX9nssiEUFIpqjWEVCu5KQLARsNeZfe5+EoRCGPK9i4qYuP3dQXqhoMlEIxQkAWFaooDBRpoU1WAc2QmICfPFCAXz3kNMSv8Vz5ULaAWwweSwcZtXdrtsCAWFolpjSIWCd2gxblVfPHCgHi9wtxgCoaDbehAFh/ugMRP91oOaIdQK9dVJs7xvWkC4iKzdij4vDpDYUw7GEiM5xKYMb1jqFRh6DJ6iPYYTPGG1y4ZQUCiqNYZUKBhWFF5+EEqHqFDwA7Z/euCD58qZR5vDjLpMEApDhmaBVZkBLQ8zap+NKVVMlVhiYkr1EU4zghWSzpU2se6v6n6iY7/LhlBQKKo1hlUoyFsMumUA8ZhC5HooDtSzDuZViphMEApDhCmcCtd102HhQiGxxOSUkuDhNCOkZ/V+MFm78sH3oNCd0uyyIRQUimqNoRUKF3KM95YBpD+KoB5m/P5p+OeYxF85CvnE/d2FmEwQCkODxn+j5wIl9408EXHtpNnTnIO+RB2GlPp3QwBrAhGqurF7I2aXTcPi4uK7d+/yxx3+90iFgRMKfYE/gQAAUALhgkHCIZqLi2RNvLa21u1288ednZ2dtbW1cip8o+RvCheEgg0IBQCAQug+ngoEQGT3yv+i38lKEgrHx8ftdrvb7WZeV3j37l23222320dHR8VX/cYpKhAjFGxAKAAAFITxfzuJ/XNLF1bHcU5OTtbX1xcXF59kYnFxcW1t7fj4uNga94uiAjFCAQAAoIYUFYgRCgAAADWkqECMUAAAAKghRQVihAIAAEANKSoQIxQAAABqSFGBGKEAAABQQ4oKxAgFAACAGlJUIEYoAAAA1JCiAjFCAQAAoIYUFYirLhS2AAaZXQCAPlFUIK66UOi3IAMAABhIigrECAUAAIAaUlQgRigAAADUkKICMUIBAACghhQViBEKAAAANaSoQIxQAACAmnBycrK+vt5ut59kot1ur62tHR8f97sexVBUIEYoAABAHTg5OWm3291u9+rqKlvEubq66na77Xb79PS037UpgKICMUIBAADqwPr6erfbzR93dnZ21tfX+12bAsjfFC4IBQAAqAOLi4vX19f548719fXi4mK/a1MA+ZvCBaEAAAB14MmTJ0WFnidPnvS7NgVQVGsgFAAAoA4gFBSKag2EAgAA1AGEgkJRrTG0QuHlB5MzIx92trXXJ79/WlKJWXJ2H5yb3SveJugH3cdTjsfU465wY/V+uuvCXd2NaKGaVKbr2lKiNhjrAnDzIBQUimqNgRQK4ZyVfXLKKBS2v5sbmZz54HnWEhEKw0738VTotKv3QxcWPncfTznO/dVIGul6kJ0zNTUVOxCy6Q81B40NxroA9AWEgkJRrTFwQkEQCbHI02kUk1BI4OkXM1mFQmYQCvVl9b7vqqv3xTDbfTyVcF342n0cLxTCsrSpTNdNKRQbNHUB6A8IBYWiWmPohcLz70cmZ0YmZ25/dxBeD977/bsjkzMfPD+Y/XAm+BqkcaWD9y9UHm7iudnnnduTMyNfvIyuKIgPuspDyipMiVCoL0EIVqOs/910/eIifKEvWyjE2ZAmH4CSQSgoFNUaQy4U5m6rgVkI53sd4a5WKChXxHw8oXDbTaAKBfXBD55rLvqyA6FQV4QIr0ZZQShor4t3bkAoGGzQ1wWgeKwO0yAUFIpqjeEWCl70jX7+/umFv5zwxUvxMWnrwVtvCEK4+6wU9f2FCl3OwZrBXmf2udY8UbsgFOqGtKmvBmN/fd/m+k0LBc3eAwcUoDzsD9MgFBSKao3hFgr+TsHTL3RCwQ/8I2pKTyi4BxtFJeHevf3dQbj1sCeXOPn9U92D4uORxQmEQg1RI6tmeX/qcdd0Xfitgerz4gCRB4GtUIjkYLLNVBeAMrDY20IoKBTVGgiFiwujULi4uBCOKXzY2davKCiHCcQVBb1Q0K8oPP/ecFQCoVA3NJFVWRUIXtpN12OejSk124pCrA2oBLghEArpKao1EAoXFyahIJxkVISCH+aFJQd17SFWKEQe/OC5v8zAikLdMf04QLguRWbT9ZDSf/VgYxtAySAU0lNUayAULi6shEL49n9buiKfQAx3E+KFgvKgmyy8cvu7DisK9UTjv4GrChsKkvuarov37f6OgpyL6boOnQ1xdQEoGoRCeopqjaEVCgAAMDhYCIXFxcV3797ljzv875EKAycUAABg+LAQCmtra91uN3/c2dnZWVtbu6F6lUn+pnBBKAAAQOWxEArHx8ftdrvb7WZeV3j37l23222320dHRzdUrzIpKhAjk5N2KQAAApBJREFUFAAAoLqkOUxzcXJysr6+vri4+CQTi4uLa2trx8fHN1e9MikqECMUAAAAakhRgRihAAAAUEOKCsQIBQAAgBpSVCBGKAAAANSQogIxQgEAAKCGFBWIEQoAAAA1pKhAjFAAAACoIUUFYoQCAABADSkqEFddKGwBDDK7AAB9oqhAXHWhAAAAAH0EoQAAAABGEAoAAABgBKEAAAAARhAKAAAAYAShAAAAAEYQCgAAAGAEoQAAAABGEAoAAABgBKEAAAAARgZLKBwuNBwNjYXDvDlvtLJlJFqkeVq4XYCRAAAAN039hYL7TGsjPueMQkE1SM1AFQp2xgAAAFSFwRIKAW5ctwq4dkkzC4WFDf9TQ1+OVH4KuwEAACpAfYSCe0l+s1de+FsbSrIwB1koCIlaGzEiIN4i5YbGGLmoQKYEj/g3WxtiyrAQxU4AAICiqYdQ0G5JaGNzJKUXnQWhICcRYrQ2FusCvd5UC2O8LDxjGsJd6YtricZOAACAgqmFUPCCtfJG7t02B3nxjiAU0m0P6BYyzKZqvvjf3LgvWCBZ5mXtiYMMdgIAAGShDkIhujMgbiQo8VTeetAJheRFghiTog8kCoXokoKmdvKmSB47AQAAUlAHoaC8msetKGy0IkE3KhTEPOJj8EZLPS+QXiho8rcUCvZ2AgAAZKQWQsH8bi7fay1ozjIYth7EfBJ+0aAp1Ef9eaR8+tD0uJ1QiNpZUmMDAMAQUw+h0Is72hfekc4PNhYW4s4oaGSE8ScN5lAd+YNLkjERs7MLBY4qAABAKQyoUAAAAICbAKEAAAAARhAKAAAAYAShAAAAAEYQCgAAAGAEoQAAAABGEAoAAABgBKEAAAAARhAKAAAAYOT/A65o7OFP/QbpAAAAAElFTkSuQmCC" alt="" />

  下载完成之后得到一个压缩包aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAKEAAAATCAIAAAB3MfqfAAACeUlEQVRogWP4jgTevH39/PlzHV9+CHr27LmQSjYEPXzwMF7cGoK+j4IhBRgG2gGjgOYAGsc6vvw6PhJv33+5duN5RkOjkEr2m4+f7t9/f+D4/Xhx61fPXr35+OnA8fuNyqED69xRQAZAieOl25Z/ev9/4doNdjGRo9E8bABKHGv68i/fvvz1m+9TVyy0iAgdjebhARBx3L81V9FaTNWNzzpVMqLTomFFuJBKNqNCo5jzxNieA/Hi1i1qEc2q4VuSe0bjeGgBRBxHdFr0b83V8hT/tNn3y7VMSBxD2JA4vljLA+Hij2MGGBgMahhQAR6jyABE2o5VnFoOIEoZhEoz5NTxkYjotNDyFKckHyPbissFA6WGuoAY22nqAOIB1AUBCkxphpzm9rwUxjGK0aNxPKjiWMeXHxLNDi4CpMYxZpGFzMUsKjFDB7NEpWIcY9qOaRdWNWgewfQXQdsJBg5W20nyCDHmoLSrAxSYGt1FZ5foTqs2PT878sHBfgg6PzsSGSHHMVY/45Kibvzh9xh+M4lxKpp6XGrw205MmsAThvi9QKQ5KHGsps9abCewMEZtcYLezATdBwf7ZyVod3kJbyzWXpylBUdY45gY71E9jqmlBpdT0dTgzCh0iWOC9hIVx4rWYlqe4nGJCsVlenUlVpMyDBeWui4qtoFkX2LiGKtPaJqPaWQOMRFJTNwM0jimsD7GTOzEiGD1EqYuqqghaBee/ErQp8S4EJchyAxc5pAUzlBxCPXlyxey45ggwB++gwEMfhcSA3D5AiH65s0bWsQxMdloYMHgdyExAI8vUITu3r1Li3w8CgYWoMTx6BqBYQmGdgE1CogBAOiG5SW5u3jkAAAAAElFTkSuQmCC" alt="" />。

二、使用C3P0配置JNDI数据源

  Tomcat6.x中配置JNDI数据源时默认使用的是Tomcat6.x自带的DBCP连接池,Tomcat6.x使用DBCP连接池配置JNDI数据源如下:

JNDI学习总结——Tomcat下使用C3P0配置JNDI数据源
 1 <Resource
2 name="oracleDataSource"
3 auth="Container"
4 type="javax.sql.DataSource"
5 maxActive="50"
6 maxIdle="10"
7 maxWait="10000"
8 username="lead_oams"
9 password="p"
10 driverClassName="oracle.jdbc.OracleDriver"
11 url="jdbc:oracle:thin:@192.168.1.229:1521:lead"/>
JNDI学习总结——Tomcat下使用C3P0配置JNDI数据源

  如果想让Tomcat6.x使用C3P0连接池配置JNDI数据源,在配置时,以下配置项需要修改

  1、 type和factory的值发生变化

  2、username=>user

  3、url=>jdbcUrl

  4、driverClassName=>driverClass

  创建一个Web测试项目C3P0_JNDI_Config,解压aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAKEAAAATCAIAAAB3MfqfAAACeUlEQVRogWP4jgTevH39/PlzHV9+CHr27LmQSjYEPXzwMF7cGoK+j4IhBRgG2gGjgOYAGsc6vvw6PhJv33+5duN5RkOjkEr2m4+f7t9/f+D4/Xhx61fPXr35+OnA8fuNyqED69xRQAZAieOl25Z/ev9/4doNdjGRo9E8bABKHGv68i/fvvz1m+9TVyy0iAgdjebhARBx3L81V9FaTNWNzzpVMqLTomFFuJBKNqNCo5jzxNieA/Hi1i1qEc2q4VuSe0bjeGgBRBxHdFr0b83V8hT/tNn3y7VMSBxD2JA4vljLA+Hij2MGGBgMahhQAR6jyABE2o5VnFoOIEoZhEoz5NTxkYjotNDyFKckHyPbissFA6WGuoAY22nqAOIB1AUBCkxphpzm9rwUxjGK0aNxPKjiWMeXHxLNDi4CpMYxZpGFzMUsKjFDB7NEpWIcY9qOaRdWNWgewfQXQdsJBg5W20nyCDHmoLSrAxSYGt1FZ5foTqs2PT878sHBfgg6PzsSGSHHMVY/45Kibvzh9xh+M4lxKpp6XGrw205MmsAThvi9QKQ5KHGsps9abCewMEZtcYLezATdBwf7ZyVod3kJbyzWXpylBUdY45gY71E9jqmlBpdT0dTgzCh0iWOC9hIVx4rWYlqe4nGJCsVlenUlVpMyDBeWui4qtoFkX2LiGKtPaJqPaWQOMRFJTNwM0jimsD7GTOzEiGD1EqYuqqghaBee/ErQp8S4EJchyAxc5pAUzlBxCPXlyxey45ggwB++gwEMfhcSA3D5AiH65s0bWsQxMdloYMHgdyExAI8vUITu3r1Li3w8CgYWoMTx6BqBYQmGdgE1CogBAOiG5SW5u3jkAAAAAElFTkSuQmCC" alt="" />压缩包,找到c3p0-0.9.5-pre9\lib目录下的相关Jar包如下图所示:

  aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAe4AAABuCAIAAABusmdtAAAYaUlEQVR4nO2da2wc13XHJ0IQGAgapy0QFLWbxkGDpkaVNLE/pA83X4q0CNx+MOA+0LgV0KJ0g1hJ5La2KyWtLMtuFFlxHNXxmrajOHBjW0+LFE1SpESR5nOXEh9LLl/ikqK4K3KXS3K5u7Pv2w8jDWfnPuex3Jmd88cfxO6dM+feOzv8zeHl7o60vhmv8EZM47iwY3Rrwlh9OcSrdNuSxJTXNRbfRAtbZ25aX9FYt9eKGWsTbtyq8DrdFWGVSRh71Y+jlWZsYjiisfgmWhjTCY3F9zKRXDx/gm7W4JcrnLDumztjaWqsEwwGg8GutoRAIBAI5HJJicQtxf/1RhsYDAaD3egKlNf6ugICgUAgMwKUg0AgkOsFKAeBQCDXC1AOAoFArhcV5QHfg/5XHxh85Uv9x78YDoczmUythggCgUAgtsgoD/ge1AZ1/+j+gYGBmtBckghvl1QbdVvZT8XTgkAgkLtEQPkdjvs0Rp1HPtf+wmc/eO63Lzz7W00H7zn3/d8Ih8OyLJvsFYOmxJRuL+3uRHyrP2lJ8J/stDYKLhhswfEBgUyIgHL/qw8g+ccodazClTpz4FNHjx6dn5/XpyPRk9ArZRMbprRinBjGxrRueLpgWu8iU+NKZF+RXnYsxq6JC/aOX5uJ/eIvqL0DA4HcJWltbVmxivLBV76EYodR5GDvy7t17nrx8x0/+J3Ww59pPnhv08F7mg7eEw6H9RkFgGsC5RJPCPuVxgHNHgAb5dxJCYqbwegwdjLGXhF7F3+9DAWAQPUtAsr7j38RLezvfXk3a7/IQYTQL7778aNHj+ozkgDKrqqIjebIQiQCXsHpLgDEzOaYIiLxJB5EObFHQDkIxBYB5b0v70bBbwd8D1Yul1c427sHId+JvXft3btXn5HyFzEehu/CqLgZweytxEj8KTKFcm0e3eVB187OzB4hPgXi4HVheAx7OowYvHe8L2IMPn32LBjHBx8ScZDEKYBAdS8Cyrt/dD8KNPhffQAhH5J/TPR6x98g5HvzWx974okn9BnpyxrESFoLmz5EHAi2EGFnIhU+BpEHInm4XdiFaUSiMEPsPPgD2qyJVwVGRyKvKXeEIFAdi4Dyrhc/jwINvS/vRsiHYoeJjjT9FUK+17/5URrKhfo2jnIG0WgxxLS0ms4EQfAyU6RgFOcs8YGNKLcrhnv1QszLBqDcqnQT5x4HEwcK38X2o+3Zl8+yCCjvPPI5FGi4fPR3EfKhhf1Ez737Zwj5Xnt8FwPl3F8qKyhn5BdHORHEJkaoa+TGsCfC3t12lHNfL4tXHVoqdjCg3LAsolyS9Bbfy0bZntAzIqC8/YXPokBD6+HPIORDwW8TPX7ijxHy+Ro+olsrlyqlbSd3L0Y0XYuanFjfaYNpAUYbGcQRuR4QS1H8AqCbICOA2EIcPPeFMBfD7Yu2i2AYqnwFTRwfb8lEvcxGPwPl2k07VpV79pUVFgHl4XBY/RzQmQOfOvnMr7/zH598+8lf+cV3P35i711vfutjr3/zo689vsvX8JGHH3740KFDNgyC8juPP2XQAVX+2rPzM9jBGGENSeF8SDl/hLVUo7bg3YdWEUKraJ+mcV/7ndBgZXWsBKsbG2+3BzWNxGqaW2WbRjn+WBccbNQPW1D4mEX+UAAhhIgoz2QyAwMDhw4deoKnQ4cODQwM1HYCXlDNLyRcOX+EtVOwktQIBRtRYxChoB7fjcHtx+13QNi+bxvc7fvu7LKK9qnxJLwywE1DJAPlXMLaxVlGEji1eJLisRuKtd/BkslkwuHwJE/wNVsgEEeNEpIa+WHt++6EVaJ8m9rBimI82Lid1hDKtS1sXjNUDbDufI/1JWnl1nXF8CW3IJDd0nGZrka1csd2UTbpVi1W27fJjhMZF15066AvuMDC3dpYuS5EWFlSBr8PrSpLSY3bCRnFPqCcJ2lhfkQxoBwEslla4IqGUapy/QK0JkyEfTSUI0ohb6VGvk1q5bHmmqT+5aHMF/+rgr0uBGJKGh66qLjmtxkFg+vNh76DpEf8L9EDXnphXaHqP752p/G1eUlaf/I95ekbTz5yO4M+1XYYkiQ1ofhjtUX3VBcvulAuSdsZXnphnThrtZ0SoBsDPkgww9L+t6Lg+nZsdRZcG4dOFCUp18ONHEo3SKjhRGJ1Nrbakqvg4+GkEtNzGEl70iF1l5acJBVPDsVWZ5Ekqal0j9WneIy2RQ3WmjFg9tZY6ERRM9TkMW3aPemQPoAxBuL4wURL//nzCLi+XfOTzMPeBi7H26Sm7KJDueYiQUO59injgchTfBOLrSqpQyeKknqJ0rWTUc7uFMwwoLz+XfOTzMtOHtNU1gxzUb7aktMW+D2H1bQMlDPazaFcpK9tUmsGWdFuBOX8Kwd4dTYGKPeCa36SedstOW1lujobC50oHmuJ9RxGx1oqYm4/pRbyiZN77uQZSjeo8fp1CeIwbEE5N8n2BDVVuXr5SR7jL7CwBw9AZxhQXv82fE7wfmGUTwOJRIJjq7O3yatbL9atiVdinbom03NYideuv3MXWES4zEU5LQmhXUPqxMk96hxzJ80vsAgGeNmA8vq34XMCk65dG1nzMxhs7l+Uhv7tyV7F1sdTSC04F7ZrfrQda0B5/dvYCVH524LDGic7jniw8y1elRstlhMn9wj9ewBsqwHl9W8DZwOz6NZRmwt9hk+946v5qQ+23Xfed2iyJAdbMaC8/i16KmjK7RgdzbqtJorxU+/4FNf87AeD68aA8vq3mdOCznEi8cWBrnIcaF5bx2eHk8ePJI8fWQtcrvlgwNYNKK9/Gz4n6Ivg+AKLIZTrOA4032HHZ4c3f/7TTMOewu//XunT926+9WrNhwS2y4Dy+reBs4H030vawovRlRYix4HmO+CN999OP/Wd/EN/iHbtQpJU+vS9yZ/8oOajAttrh37fWLl826UyKpVQqYSKRVQolgvFcr5w27l8OZcvZ/NlOVeWc+VMtpzJltPZcloup+RSKlPaypSS6VIyXdpMlTZTpY2t0vpWaT1ZSiRLa5ultc1ifKMY2yjG1our68WVRHElUby1VoyuFaPxYiReWI4VbsYKN1cLSyuFGyuFG7cKi7cKC9HCQrQQjuTnI/n55fz15fzczfzszfzsUn5mKT99Iz99Iz+1mA8t5kILucmF3GQ4NxHOBedzwfnc+PXc2PXc2FxudC43Opsdmc2OzGSvzWSvTmevTmeHp7PDU9nAVDYwlfWHsv5QdmhSsTw4IQ9OyAOKg3J/UO4PyvainPFWcfaKipVFc7BdTh4/snHubW1L4vL51OEDua9/TcG34vLdn0g9d6DmowVXw4Byt6K8f1yU5sZOCDrKtU8B5c5x8vgRtGtX/k//aG24K3n8SO7rXyt/8m7d27HLd38i/e9747PDNR8tuEoGlDsC5YFQ1h/K+CfSA+OpwYnUQDA1MJ4enMiwUd4nRnNjJwRJugBdcM1PYi87cfl8+dd+lf2xGoC4FwworzHKh6ey/on0FX+8rfvGhY75pva5Cx3XL3TMvd8+29wZ7ui71T+eGghmdgzlYBeZy/Hs3z6yNtxV83GCd8CA8hqj3B/cauteer9tqrs/PD0XuxndjCfSK7HU9YW1Pv/imabguba5y0Nr/eNpQDlY6/jscOEPdgPEwYoB5bVEuX9iq6178XxrKDSzmpHzuoNQKpWXo5sXu2ZPNYc6B2J9Y+n+YEaP8hMRrm/MD4PrzEsjXbnd95Mh/pUHV375Ws1HCN5hA8prhvJrM5nLA9HzbVPTc7FSqUw7FBubckf33JmWqa7ARt9Yun88YxTlk2Pdk2Pd3C8qAoPrw8oJ7zVTUX7fY32K2czlxugCBOMZKFcCuChXwhSUK4+dhvLB8c2mi7OB0eVCsaQ9AtKfvK07Jqvx1LmWiebLN3quJfvG0kZR7u9v9fe3IklSHoDd7thf/jkDZIv7/rXmI6yhPXueV6BcxbcKXF0LkcLadjyGmJCYgWYGyrVhRJTr7CiU9wzHL3TMrMRSOo4rVlvKZVQqlwMjN0+3THcOJXpHU31KYS6MclmWZVlGkqQ8eP7556PRSZofffRRuVJ33XUX/Nyxn4LKTk/n2tpybW35H/6wsH9/Yf/+0le/WnroofIXvlD+8pfF89Sf1PPca5IYbKVhmk1eYhlO3Be/KiBeVU7sC6/K1U2OrcpHZuSuwVtdvddz+aKO49oHCsoLxdLi8sbplsnWvpWeq8lepTC3gHLikVeko7khvoBANZfXUc5mtA7lOPGJW0XoT4ssl28/IKJcXSsnolxpTGUqCnOnrZWPzMiXBm71+2/gHNc9LZXLuULpVjz1fttUc3e0K7BZVZTjNAftjOCqaYu8i3LiLzO7KhdEueD1gBavAF2LcrWdgfLbHL/zb08no7yzP9rnX8SPg26tvFgqZ/PFlbVUU/t005XIZf/6h6OpqqLc5/M99dRTkiTJwBeQ2wQoZ1HVHMq5u7A71aGcsZijmrhWri6w3OektfKRGfnSQPTSh9fx/3niqyvpbOHmSvL9tqnzXcuXhhJ2oXxiZl49D1KplCzL6XT6bNe1aHTS5/NJvF8J9bOgTojRfTyVPXKjEk9rpWu4atoi76KcttYhWFATV0sYqfDMIowWX2DR7qVW5cqbEdV2h6C8ezh2vi20lkjrOI4qV1ey+WIyk5+ej59pCTVfiV4aSvTYhPJ4PF4oFAqFwtbWVvzYV5THL/2yHSEUCATYVbmWWTR+1SrGXon0DnKOvItyNpptQTm7hZaN8W9P9lq59t+eOjuqKu8b3TjTEro6FimVULlMXivPFUpbmXxsI9MzuPBec6i5O2pjVR6NRjOZzNbW1sr3f/NW87NbW1uZTObZxrNalAudQ4ByOwRVuS0ClFdwllEyi/DaHMrxy4ZplCtr5eoCi1qSOwrl/slUa9eNcy3BhaX1QrGkuFQuKy4US3KumMzk15LZ4PTK2ZaJU63Xm3tWbFwrX1xc3NjYiMfji4uL8Xh8aWkpkUj824tvIUpVjq8zaJ/i6xs4BPFlEBtRjveO90WM0U0Enxe3d3wvYh5iXyB7BSgnU5VdlXNBL45yXbuVd7DgHxFyIMpHZ7PDU+kPr66faZ1pagtdX0xkcoV0tpDJFZQHW5n8+lY2viEHZ1abL069ez50tnOptS9u4ztY5ubmIpHIY9/76d/v/9/Hn38jEon8z5tn//m/jyNSVU5EG22TvZiWSRRmiJ0Hf8CdqXjvxOkw+tIKqnJbBCjnIJhGcHa7CMqJqZTVFdpaOc3aNyNq18oVO+odLKOz2avTmcHx5KXBlVMfTJ1rmbwWjEZiqUQym9jKriWzsfXMYmTTP7rc1Db53vnQ6YsLzVeiFwfXbHxf+eTk5M2bNxuea/y7Z37S8FzjP3zvlYWFhb/e9wIiVeVG+SjbinK7YmhD1cXQwG0I5dpUgruDrAtQ7ix54ztY5OFQum90o2Ng5Uzb7LtN4xc6prr6wr3+xV7/YldfuPni9MnzE+9emD7VvtB0JdLaF78cWLfl057KQQ6Hwycv9u998f9Ux+Pxv/iXA4hZleNPd6Yqr1IeEV6Ls1jksNAEVbktApQ7S15A+chs9upUZmgi9eHIRsdgrPnK0tmL86fb5k61zp384LZPty+c7Vxq7oq09q5e8id6RrZ038HyzIkI18orjaP8nw4ce+gb+3Q+29GLxNbK8dJVpIVwCpL2siWG2xej+ubOlJafmEcrxvBA1gUod5Y8gvKRmezwVGYwmOod2bjsj1/sX23pibb0RJu7I83dkebu6IUr0dbelYv98a7Aes/IVt94Wvclt1ZQzpChd7Bsn0yO/y2q9git5Ieq3BYByp0l76D82kw2EMoMTab7Rjd7rq5f9q9dCiQ6B+Odg/HOoUTn0FpXINE9vNE7luobJ3xf+TM/i3CtvNLmUC7OF+dXndUbofPn7h0Byp0lT6H86nR2eEr2T2YGJ9L946m+sa3ekWTvSPLDka3e0VTfeKp/LD0QzBDvIlRtlIN2TFCV2yJAubPkNZRfnc4OT2cDIdkfkv0heXAiMziRUe7OrD6wC+WPisloVQ4COUGAcmfJmygfnsoGprKBqaw/lPWHskOTimV7UW5UTvgWb+/8BFmUd1E+GZbBLjVCyNwCi6FbT4BALhKgHOw+m0Y54+8hoDnI1QKUg93naqAcaA5ytQDlYPe5SijX3noCBHKXAOVg99kiyh1y6wlbZFdHtCSuu7DZ8upU9XOq4mkNdQ0oB7vPFlEucusJ6nlTha/Ksi5zveCftrdpOGZ6tz2nlVeneoeieucGoBzsPltEuRNuPWGvAOV4TkC5RwQod7ERQs/8bJlr5ZU2d+uJinMF+4tY+xT/Sxz/daX9wY7n0TXiT2njIY4ZHyHeKDhN2kzNzYuYhzt3XV947+xjgrczYrgzpcWwZyHSO3HueB5dX4BysPtsEeVOuPUEbXdu7yJQYIyZGGZvZpHDQnwqPndu19wR6igsmJO2yegrKNg7cTq0vgDlYPfZIspFbj2xfaJYY5aJ3fEwWllH60UQFtVDOd4740LISEjMI3JI2SO0K0bkFWS8FoZQLvPOBEC5PBmW73usD+cFsZHRbsjsJPhW5X5AVpIY7dHJtohyJ9x6grG70Rj2IBmqHsqJLeIHltsXrXfTR96uPCJDFTmGjGEAynXaRrlCMRoo1duqaR9rG01znMZrXX52R9pNRHarjSLdWZyXW1AucuuJinMFq4aIpSK7hXwWMtPq2omRUqVMDwDPyZ44OzkjG7d3xtyJM2V0rbbYEsPtizsL8d6J7RJJ6lZAuR52RPYRH5tDHgO+xOQ4oNlmo7yqf2rsKMrfXOZaeaXh1hOgKqnar7uh/F5HuThMbSlguaSmIZgNX/YsuLgX6c5RdhTKRco3UP2peq+7ucyeRjkRcNwy1hD1dEilgZixgEO7bLCXVvDBsy8J7JrdaXYUykEgJ8jTKCdymVaM01BLbOdW7mxoMtZJRFAu2OI1lBu69QQI5C4ByjkoF+GmCdP4TqzKGfHcTbRLi4nLj3NsDuUgUB3Ls+d5Bcq5Cyy2I49bI3PXeUQ2ifTIzuNMm15ggVtPgOpVgHL+AjQjxrTFlzvYnBVvF4l0C82rsVYONAe5WoByIZTv2AIL94E2GC/hGfmtF+/OcZX+7Qk0B7lXgHLWOjIO9GovsOgYTaQ8jd3EZSJaj4zB1+taOdx6AlTH8jrKwW60RZRbvPWE/kyCN5VX58MyJj5vaTpGjTQ8SscIUA52ny2i3MqtJ8gnk1d/i6ono59rtxJTHwKUg91niyi369YT2yeTV3+LqidAuVEBysHus0WUi996gvi9RTL2NzsjRjCPLhLfShyVYF/s3hkxukb2eLiZie20mUpGEMwOIM6dFsaeBTHMIQKUg91nhNDTby5zrbzSVm49ocWK9rd6xx4QTlzeXiI/rQ+DNiq7uhBHufhWQ5cE4lCdCXFFgHKw+2wR5eK3nmBDUBcmYyzQlXW0GHwXEZTTercR5fgIBUdFnDs7hpHQ0NEwl4cYQHsFnSlAOdh9tohy8VtPmEa5uYLUBDTxhPaiXHBg7HpWJl202JlFEGz0cFmvyrnd1VCAcrD7bBHl4reeIEJQrqzX8Me6GK20Mbp2PDP13KXsRRszexa0GdFGSBsScYQMDnKTE6dJyyDSES2PYH6R41BDAcrB7jNC6Ok3lrlWXmnHfsmtCFzcIrePX5GrZwEo538JidHvYLEYYKg78b64X6dFbGd8urWGnwitD5TLYjW4k+X28Suqj1kAygl3geBiy/q3DHKTc799RZCzIvDlzk7w+1sA5SBQreRplDOgKQ5QcUCzzUa5IIXZKLdxPG5EOdx6AlTH8jTKVaLpgCUCKUbpyoYd94LBQK1gX+KYNjFa96IcBKpjefY8Jy+wEJ/q8EpDJw1/Rit3Lu5xsBqt2fFOiaxnXwkA5SCQc+TZ85zzb08R4DLgKLiVUZXbhXJGPT5JuTixxwAoB4EcKM+e59TvKxcpP62gnM1fdRNtPCYWT2gToW0FlINArpNnz3MD//ZkE7AaKBfMJri6QgxjEJyxwOJSlIPBXnBtkVorGVtg0VbEXMgKrlALtotEcq8KIheeeq3KQSBQHUsU5SbIxV1+IV4YDKGcG6arrGnd4RNkLKkLXskA5SAQaMfEegcLg3rstWk2fNmUFGc0o07XroEwuqPtbm7MgHIQCFQrwXewuNiAchAIpAhQ7mIDykEgkCJAuYsNKAeBQIr0b0bkLkCDnWNAOQgEUiSKcvYmcE2MEHr69WWua32OgUCgqgtQ7mIDykEgkCL9B/e1pMDfQA3LLI4yoBwEAin6fzSauZ3uracUAAAAAElFTkSuQmCC" alt="" />

  将C3P0的相关Jar包添加到项目中,在项目的META-INF目录下创建一个context.xml文件,目录结构如下图所示:

  aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAWQAAAEmCAIAAADa6X0QAAAgAElEQVR4nO2de2xc1Z3H5x/+j9RKu6xUiVZITVSJqFEVbSsRs9AGE1rIIrktbVlHXQhsjXiYdDGEYMdgY0LSmJAEmzSe8HASSBwMjoOBwDhJccJuRIxDw4QA9iRO/BpnBz9m7njGPfvHdYbxPY977mPua74fHY3unDnP63u+93tn7v05ROazf28zAQAAipDmvUWx6O+PVIfDJeFIdTjc3x+x0hQAwFNoxcIK/f2RkkikPBLp7u7eteu1knAEegFAYLDkLD5teyyXCCHVkUh5OBKOhCP91ZFIuLw6Ul4dtnGsAAAXMe8sevc/Nv9tVUk40t3dHYmUV4dLqsMlJdUlJeVhqwMEAHiDECGk/ejpqqZOOrUfPU1X2Lb+2W3rn922vmFmpGVmpCXZvz3+6XMXjqw7+/bD1eFwdThSHa6uLi8pry4vKa+urq5mdJmHJodXgC7DngwLQT79kUzLwv0pqpt7a7QFALxAiBBS1dTJ/IyZ/+zaTXXPnyDfHKVTf3+kJBwpCUdUT1FSzviOU7P+mTn0BrMMd0oSDRpq01DvgroA+Jo5schmM7OzcymbzWSzM6nkJE9EKh9+gYx1MJL6a0h1uKQ8UlNTw/x2U3JZ2igWmhYsioVRIBYgMMyJRSo1nUpNp1JTqdRUMjn1TWLsYuwLnlj8573N5OJr7KTbH2fxiC86vCkWvMsZehaaYsx2zF3jAOAYc2IxPf2N5uq9/1yfKhbq7yP5r4SQ0Y/Dsday0Y/DhJBVd7esununmsrv3rnqnp3l6vY9O1fdvVPbn0FnQb81cRnC1B2LYmH6Aoc3NSgF8DhzYjExcTmRiI+PD8XHLo2OXLgwcPbcmZM8Z0EIibWWkezpWGsZIeSt2Cwv/fsfXtX2B7HgOAvBAADwAnNiMRg7+2X0VPT0x5/3HT/zaU/fye5TJ97nicVo90YlWrNyYUiJ1ox2byKEvH4m/foZ5fUz6byk/KJsL6M/g19w8mqJpuTIF5y2OwsAPM6cWPSdjPR8eOBo194jXXuOdO3pfmf3sffe4IlFrLUsJxaquWjpmWj5aKKlZ2LnRxMtPRMtPRM/Xbmf2yX/2p5XgJepKUBv5KrkWwxmX7qN84bE7Eu3O7plqAbwOCFi8D6LWEfVePcqJVrTt3OZEq0Zj6w631G15VB8S+fYlkNjWzrjWw6NLV7R7vhE9NXEm8gbHADcxfDRGWstm/26dvzompULQ+NH18x+VRtrLVu4vCM/FWKgGkIU3m9Zt8dCdwSAFbQHqO6zIT111/3jwvZEtLFz6x2JaCM5v72n7rqCDQ8A4BUMn80uHt/VU3ddfrp4fFchRgYA8BSwvgAAKQxfhvBAiC0Agg2cBQBACg85i9XLllhsAQBQOFxwFseeW5pLhJDam6+mk/OjAgCIcdpZtN1/bf7bC6ferb356pnke8M9WzfetVzdgFgA4EEcdRbH6pYqw03KcFMi2jjc2zDQXfV//T21N1893LO1b1/N6mVL1A2IBQAexFFncbhuiZI4kZ8eu/2G2puv3njX8tXLlqhp413La2++Gt9fAOA1HHUWh6uXKMPt+Smb7M9dhqxetkR8GaK5BZve0BRzZlIAFAk2Owvx68HqJcrArlxqq1wsSIyxSkSCCFHPngIAbMHRFdVW+SMl2qimtsrFykATMw33NjDFgrBMBF2ggBMAoIhx9DuL1vuvVaINSrShrXKxukEngVJ8O2i+fYBYAFAgHF1aLeXfU3qr2ioXK701zCRWCuZ3FrxrE6gGAPbiqLPYfMfVbZWLld4qZpLxFAAAt3D69Nuy+oeC5PBgAADyeOjZEACAl8GFPQBACjgLAIAUEAsAgBS4DAEASOEVZ5GIdg3sWpCIdllpBABQOLziLAZ2LUicWDiwa4HbAylGtq27WU1uD8ROAjkpd7HkLAz9KzMxvTULBnYtEJsL+t//aG7WlPznQE7+AyFe13S+poyTo2KuKDozt/Z4i1C8MnOrV7yGZRa5poygZYiFjVg6KHn/DJWXH7qna+kTBxbXdCx86t1/fu6jBZv/56ptp0P3dJHcZUj3woEmHXPBfJBMsCFTXRJb1rBMI14QC3FJgZSYqMscCa8YXUayQWARS86iqqkzm83MzmZmZzOhUCibzWSzM6nkJE8s/unmJ5hJ/bS3ZkGi+5poow1iIbYV0vOzs66hRvwoFvLtQCx8ilVnkUpNp1LTqdRUKBRKJqe+SYxdjH3BEwtCyHXbVvGSeiUSbdT5mpN27OIcZgu8KvRTavQ1Dq8pyasb5jUIs1lNy7yR88ow58VExibQzp+XKUbSfci0xrwMMdQdMIRVZzE9/U1oPv3n+lSxoIPfEEKuqimt6nqCTlfVlCaiXb0NC4a7rok2iMwF7SzEOfLtMDd4VejC9Ktuv5ItE7kwPzJlmOjaBFoOmKd0J8VCxndIDglIYtVZTExcTiTi4+NDoVBodOTChYGz586cFDiLq2pKeYkQ0luzYLjrmt4aY2LB3JCBudrzP+WtvfwC+WdvXlOCRngt8zaYA+CVkZROc2Jh7ttEW8RC/iOIhY1YdRaDsbNfRk9FT38cCoXOfNrTd7L71In3eWJxpLJEnNQrkd4qnd9E6G151WBWJ3yjzivPe2tILHijlZmOIUHhDUbFtLPgFTPal7hT3RYEtSAWNmLVWfSdjPR8eOBo194jXXuOdO3pfmf3sffe4InFB/f95IuXH+alD+77SSLadaJqwXD7P5+o0poLnuvOLU4a9oQ5BcSuQZNPFyNyYsEcJN0RbRmYM5KZta5SELlvKzU/T9I/o9JeQ7JZuoDkb6vMX09lpgbMYclZGL3P4tBvr/1sw61qOj1/4/SGWw/99lpCiEAsZE6Spilcy+4iKRbBu0NBV3SAURxdIe23fFdNb93y3fbSK+mW77aXzuUQQk5ULVCTY6MqqAa5iLl5eW2NMe0McAVLzsKWigAAXxDAMyoAoBDY5iwAAMEGlyEAAClwGQIAkMIrzgLBbwDwOF5xFgh+A4DHcfSmLAEmgt8Y7UK+WZmODJWh8zVlbJpKYG8tA17A6u3ehvJtD35jFyHWveTi7iSHIVMMKxz4AqsPkrkb/MYuQtQDHXSOuWFALEBgsOos3A1+Q+bbePpSgi7Da1NTRvdiR/KCiHkNwpwCPVrmkARleJc8zHlBoYBRrDoLLwS/MbrBa9OQs+ANSeYjWizoDRNlJFvmTgMAIVadhbvBbwjrtKxbRrdNZo78kHQ/MrekmTPVbZmeO2wFMIdVZ+G14DeEZbzpMrw25U/FzC5MjFayU3lBEbyV/AgAJladhYvBb3JvdU+5zBMs89OcMRFX0VTULcBsnNcOr1m6Nd6uEGTKzAsAJpacRZCC3wAAxDi69rwZ/AYAIIMlZ2FLRQCAL4CrBwBIYZuzAAAEG1yGAACkwGUIAEAKrzgLBL8BwON4xVkg+A0AHsfRm7IE6Aa/MXTrobt3cAm6FtydKVPd3GDsagoUOVZv9zaUbzH4TUj4WARdzEXE94BbqQ6AW1h9kMzJ4DcQCwBcxKqzcDL4jeBBKboMz9jntnXLyDypJVOGngVzXoJG5MfMyxR0x5ssABqsOgsng9/kFoMmh5fJK8NcnAXa4M1CnGl6zExp0K3FGyoA+Vh1Fk4Gv+EtD/pUqalFn6jplnllLNYSzEKQKdmg7ryYLTP3GCQD6GLVWTgZ/EZ+CQneGs0Ri4VuLfHweOUN9W5xb8h8BACx7iycDH6TOwFqTqfMt/SZM7+uwCbI9yXO4S1dDTLN6o6Z16lMpnjAAOSw5CycDH4DAHAXR08mCH4DgH+x5CxsqQgA8AW4TAUASGGbswAABBtchgAApMBlCABACq84CwS/AcDjeMVZIPgNAB7H0ZuyBOgGvyHCGxbFNyCavjcRNzUCkMPq7d6G8i0Gv5lrROLZCl1kyuMOaADysfogmZPBb+ZG7IhY5J7aMNQsAAHGqrNwMvjN3Ij5YsF8Jkry8SpmLxALAHJYdRZOBr+ZG7HQWTC9Br3mZZRCtxgARYWfgt/MjbjwYkHw4DYAFH4KfjM3YkfEwlAxAIoBPwW/0Wzk3mp+QM3//kKTyavIA84CgBy+CX6DiwIA3AXBbwAAUnjl2RAAgMeBqwcASIHgNwAAKXAZAgCQApchAAAp4CwAAFK44CyOPbc0l5zvHQBgDqeD37Tdf63grWigeY+B8m7NEjxgiru5ALCIo8FvjtUtVYablOGmRLRxuLdhoLsq2v7Qsbql+Yk7UAmxYH5k+hFS6AsA+dgW/GZ2NqMb/OZw3RIlcUKQDtct4Q4UYgGAq9gW/CaVmtINfnO4eoky3C5ILeXXiMbKuqDQ5NBlZGrJtANAkeN08JvRj8Ox1rLRj8OEkLbKxYLEGCtlK2jXwNswWovAWQAwH9uC38THLskEv4m1lpHs6VhrGSFEGWhipuHeBnmx0FgAuzYIxAKA+dgW/ObzvuO6wW9Guzcq0ZqVC0NKtGa0exMhRIk2aBJPKYjQI9A5EAsA7MXR4Dex1rKcWMyZi96a/CRQCsL5dpN2Fry3dD7dDt0jJAMAFefus4h1VI13r1KiNX07lynRmvHIqvMdVUrvt0msFAAAd3HutBlrLZv9unb86JqVC0PjR9fMflUbay1rWf3D/OTYYAAARnHuEfWeuuv+cWF7ItrYufWORLSRnN/eU3ddgfoCANiOc87i4vFdPXXX5aeLx3c51jsAwCIIfgMAkMJ9sYA8AeAL8LsgAEAKOAsAgBR+chaImgOAi7jjLByOmqO5g1Pz5BszJ1dXt2XmTaIhDpJjBsCDuHP4Ohw1h3m7d/4G/aopJoC+bVx3AwA/4o6zcDhqDk8seOucriuA94yJuC8AfIdrzsKxqDk8saCFgPmWriK+VGGKBa5BQABwzVk4FjWHeYkh4ywkHQGvFpwFCBiuOQvHouYIxIJZMv+tjCmQFAsA/I5rzsKxqDlisRBfUDDzme0LakEsQDBwzVk4FjWHFgvmtw/Mt/S2pmVNO5ptulkA/IsP7rNA1BwAvIAPzniImgOAF/DBsyGImgOAF/CBszAfNScUQmInAIzjvrMoIFgVTLBbgCncFwvTPepXNLsqfvynjz7Z9rNAvlrZLaDICfRxc2VVRA41MBOvnrqugpc+2faz/N0CgCGKwlkc7tyQnslq0mdv/xdPL1xf1YVL+bsFAEME+ri5sirefXsjLRZffPDE3zl6AWcBAE1ROIvO9s1KOqumVDqjpLOpdHbgxOYvPnjis7fvO9T+F00911e16aQ7hfzdAoAhAn3cXFkV7W1bppXMtJJZVFpRsb55OpWtWN+8qLRiWskmlezbB7Zo6ll3FsSU4pirJd8OnAWwQlE4i32vb59MZiaTM/VN+xaVVkwkM4tKK+qb9k0mM5PJTNu+bZp6hVuu7orFj+EsgAUCfdxcWRWte5oTU5nEVCYxNaPKxKLSisTUjJqzd2+Tpl6+s8hlanI0n9IFyPwVS9fiNSVa5/NrMXuHswAFwvfOQvQaCpH5UXPGJ+bMRX3TvvGJ9PjEzPjEzCuv7dC0TK86Qxv0cuUV5hUTWwZmI4Le4SyALQT6uAmFyPyoOaOJdM5ZjCZmRhPp0US65ZWwpl7OWRBq1RGzYpFDsKTpHJ5emBMLOAtgBd87CxGhEB01Z1FpxdBlRZWMocvpocvpppZXNPVk1rNgQ8YyEDgL4DcCfdyEQnTUnIr1zYPxtPpryOC4MhhXtv61VVPPxHcWmnzeW01JTRm6ceZH+Rv0az5wFsBGAu4s6Kg558eU86Op82Op2KgSG0vFRpXNzXs19XSvBfyb1N1iboeDIifQx00oREfNGRhJDYyk+keU/pFU/0hqYCS1cfsbmnq4gxMAmoA7CzpqTt3WA/VbD9RtfbN+64H6Fw7Uv3Dg2a37NfVcX9WFS+puMbfDQZET6OMmFDIXNQfOAgCagDsLcy3/2O2oE4hnATwIxKL4wG4Bpgj0ceN6qEvPJgCME2hncYWDjdczg98cbLzeXNcAFCFFcZJp37xMDWOhpDNXNuaC30AvAJCkKJzF/o03TCuZl/b/7wu7ezaGj9a/9GFSyeSC3+zfeAOzluafEubn88rQ0B8xczSZvDK6I5SpBYA5iuJ42rPhxonpzGQyM5HMTCYzk9MZNZKFmvY8dyOzloxY5L81VEazQdelXyVHyBwPANYpCmfxSsNNienM/sN/39t1+pWOU/kWIzGVeaXhJmYtgVgw3+qKBU8R6PK8dmRGKNYXAExTFIfUzrpfqKErLk/MjFNpZ90vmLUkl6KkWDAlRqBBzHYkR4hrEFAIfO8sxK8qL9YuH02kmc5iNJF+sXY5s33mhYDAI1hxFuKKPCRHCIAtFMUh9Xx16aXL6SEqqZnPV5cya/GWoubULS8W4hzmR6bFAgDb8bGzkGfjuhWDcbazGIynN61bwawlXoqCDWJELMSXMBAL4B2K4sB65vFfxkYVXnrm8V8ya9FLkfnVgOY7C2Y+8+sJZhlmMc2QdEcIvQCFoCicxVOP/qp/RNF4iv7h1NfDqa+Hlace/VWhBwBAACiKU9CTf77ty6HUl0Opr+a/qhvVa25ze4AA+ICicBZrH1m5ds3KtWtuf/yR29WNK9u3r31k5dpHbi/0AAAIAEXhLAAA1ikKZwEAsA7EAgAgBS5DAABSwFkAAKTwk7M49tzSXHJ7LAAUHe44i/ajp6uaOunUfvQ0r0rb/dcK3goQ3OYovoGSbodZi/4It1GCQOLOAV3V1Gko/1jdUmW4SRluSkQbh3sbBrqrou0PHatbmp94fdFiIbkhaI1+a7QdAHyHO86iqqkzm83Mzs6lbDaTzc6kkpM8sThct0RJnBCkw3VLeH0JxIL52IVRsdBtGYBg4JqzSKWmU6npVGoqlZpKJqe+SYxdjH3BFYvqJcpwuyC1lF8j6E7yGa38HN4FhYxY4BoEBBLXnMX09DeaBdl/rk8VCzqGzcHqJcrArlxqq1wsSHR3PB9hi7Mg1NOouo0A4EdccxYTE5cTifj4+FB87NLoyIULA2fPnTnJcxZtlT9Soo1qaqtcrAw0MdNwb4MhsaDLMD9iFtO0jK8qQOBxzVkMxs5+GT0VPf3x533Hz3za03ey+9SJ93li0Xr/tUq0QYk2tFUuVjfoxFMKIucjbP+CE4CA4Zqz6DsZ6fnwwNGuvUe69hzp2tP9zu5j773BE4uW8u8pvVVtlYuV3hpmEigFYX27qfk+gvn1BN0IrxaZbzGgFyCQ+OM+i813XN1WuVjprWImsVIAAGzBN+fAltU/FCS3RwdA8MGzIQAAKXzjLAAA7uK+swAA+AL3xcKB/3UKALAOLkMAAFLAWQAApCgKZ4GoOQBYx2fOwuGoOczbMTW3jeN+TVAk+OxAdzJqjoquFkAsQJHgM2fhZNQcFYgFACo+O9AdjppD+NFuNDmQDBB4/OcsnIyaQ4SRLzRvoRcg2Pjs+HY4ag6BWABwBf85Cyej5hCIBQBX8Nnx7WTUHDraDWF9Q4HvLECR4DNngag5ALhF8M+HiJoDgC34zFnYUlFLKISEhERCercU2bPefI3ePgKgKDAqFj5yFrYBsQCABFosbKvI2kf19fVDQ2d4qayszFzXAHgXXIbowxELQQ3oBQggcBb6FY2LBYFegOABZ6GPKbFobm5+9NFHcS8WCA5wFvoVhWLx9y++Tl1hamoqlUpNT0+/2X1qaOhMc3OzvFjI3OjpWBnmzal2Id8spNZbwFnoIxSLeDyeyWQymczk5GT8L/+qbjfueY8QcvLkScnDXXN7uKfK2ItM78CjwFnoVxSKxdDQUDKZnJycHHnyX4YP1k5OTiaTydodbxIjYjG/N4gF8CRwFvoIxSIWiyUSiXg8HovF4vH4hQsXLl++vGbTK0RPLHiPnGk+ZT60qm7TFws2igXdO90Xs4xmIvS8dHunazHbYfYFCgicBa/it6+hkCZnxdNt+enSpUt3rXvx92u33Ve/89KlSw0tb95ds5UIxYK5eHgf2SsEhLXOBYjboTfoFc4sI9M7czqCvkBhgbPQh9pHC25cm58GBwfvfXrHnY+9cO/TO/5j3faBgYFfVz5D5MRC8FHhxMKuMryhasrwpMGQWOQ3JVkd2AychX5F1j66a88f89MDm3bnUjweL139BDEiFrqnUF4ZQbOGFrld7cgogvxql9ktwDngLPRh7aPQ0yvy0/V/qMxPbx7+iBj8zoI+/crk6DZLhGd7Q2VMTEF+prz2me3kIxgesBk4C/2K1D7qeeSndKLbMfdrSF63Xl8JhR6h9/dAcQFnoQ+1jzp/9/0zG1fkp87ffZ+uZ0UsvH/mLNwIvT/3IgXOQr8iLRYrFtCJbseiswDAW8BZ6MPaR2VyQCxAcICz0K+IBQ8AgVjIVGTtIwS/AUUHLkP04YiFoAb0AgQQOAv9isbFgkAvQPCAs9DHlFgg+A0IGnAW+hWFYuG14De2YFdHvEZ8p6G2/HUKeu+pfLPmu4az0EcoFp4KfmMv5nqh79G2aThmere9TSt/ncLtCoeODTgL/YpCsfBU8Bt7gVjQbUIsRJ8XqmMfIRQLTwW/4bWjyaTf8sbDHDM9QjpTcpq8mZqbF7Md3blr+qJ7F+8TOl9QRnemvDLiWcj0zpw73Q6zr1xRQcukmJ2FH4Pf8KrTx4fuBt2LYMzMYva2LLNbmG/l567bte4INetcsk3eR0b/gpK9M6cj6Cu/pk7L4o+LAmofeTb4jaA6XYx3auL1Ink4Fk4s6N4FUitokNmOzC4Vj9CuMjJ/QcHfwpBYELkjIVdUp2XN++JxFt/C2kfeDH4jqG60jHiQAgonFswc8SBl5i4orDtyyZYttiMzVKnVzh9GQcSiGGEuJK8Gv8kVE1ehT035b0PzMT0Auk3xxMWNC1rT7V0wd+ZMBV3ncmwpo9uX7izke2fmh1jwRiYYNoGzIISxjxD8BhSOQv/dzbcPZ6EPtY8Q/AYUiML93W1oGc5CvyItFgh+A4oQOAt9WPsIwW9A0QFnoV8RCx4AArGQqcjaRwh+A4oOXIbowxELQQ3oBQggcBb6FY2LBYFegOABZ6GPKbFA8BsQNOAs9CsKxcKu4DcacJMFKcztSSbuoTRdJlfS8Ci9CZyFPkKxsCX4Dadb7HybMXo3tJUyAQTOQr+iUCxsD36T123RHIVOAbGwBJyFPkKxMBH8hvfEju6jQWT+5YluO5qS9Keag56ZI27TxAg1meLx6LbMzOfNNGRkkYsLMOfOKyaeBbOYF4Gz4FUsXPCb/AM3/7hxbIM3JMGGzKv1YfBGZVcX8mIh/6kh0WEO1QcyoQJnoQ+1jywGvxEvM00xQh1tmlMTrwxdRUYseL3bKBb0CCVHxZy7uIygQUN7w1w7zAK8v6APgLPQh7WPrAS/MS0W5k6qJpYl3aC9YiE5MPE5mbBkUdyyzCI3urusOwvd7rwCnIU+zAVvIfgNc5mR+ecceltTJp/8Mpp8umX+LNm1eGMWz4I3I94IeUNijlCw0nQbZ06T14JMR7x2JNuX2Q9eAc5CH2ofORP8xhwyh69f8Pv4VYIxC0LgLGSg9pEDwW+s4LPzFYXfx68SjFnMA85CH1osEPwGFCFwFvqw9hGC34CiA85CHyx4AAjEQgaIBQAElyEcTvUe23pw04MdHVsPbiKhEBISEgkVt7M42Hg9nU71Hnuwo+PcyV3K0IkHOzp+1nn6VO8xc2MAoHgIuLM42Hh9eiarSS9/+imZ6v+8b9tHX9V3fvbSndve+E3VXrdHCoDXCbizeOsvy2ixeLCjY//ZM69273zt0C0tO39esS585wMmxcKuX9oD+KM9CBwBPzrbNpUo6ayaUumMks6m0tkHOzpuPBK7s7Vz3b03/fmBh+544M2H124y3YWNKxxiAbxMwJ3F3g3/Nq1kppXMotKKivXN06lsxfrmwx+89ZtX/3bT5s/++PD+X//x1V//8akdLz5rbgwEYgGKhoAfna823DiZzEwmZ+qb9i0qrZhIZhaVVtQ37Tv3+SeVz730+/u3/KmysXn7U8y6uceiyPxlTD9fJL6CyH2q2aBrQSyAl/G9sxC/7qz7eWIqk5jKJKZmVJlYVFqRmJpRc1rqfi5onykWMhvipngti1sAwHUCfnS+WLt8fGJGTapS1DftG59Iqzkv1i4XV2c+p6zJlBELwhIFiAXwFz52FjI8X1M6mkirKecsRhMzas6W6lJxdZn1DGcBioSAH50b160YupweupxWZWLosqJKhpq5cd0KcXV6PRPKbjDdB11es0G/8r7IAMAjBNxZ1D9+62BcuRhPq7+GDMbTFeubF5VWDI4rg3HlmcdvLVzXAASMgJ/Eah/91flR5fyoEhtVzo8p50dT58dSsVElNpaKjSq1Vb90e4AA+IaAO4sn/3xb/0hKTQMjqYGRVP+Iknv75H/fVriuAQgYAXcWa9fcLk5uDxAA3xBwZwEAsAuIBQBACn9fhuTHsEFMCgAKij+cxfHOhzXpq8/fQwwbAJzEH87ieOfD+QEpZjKzM5lZxLABwEn84Sz+1vFIKp3JpUx2NpOdNRTDRvK2SLtuoMRdmCB4+OOYPvLWo2pYCjWpzsLeGDY5sM4BYOIPZ/HBgccmpjOaZG8MmxwQCwCY+GNhvLt/bWI6k5++84MbvvODG2Ri2BB+uBrxE2KaivTzYOa6wwNjwKd4xVmIXzvfeDIXlkJNqlio25+c+ki3F1oXTG/ILHLrT7UD4DX8cbC271mfC0uhJlUs1O32Pet1WzAnFrqPn8t3x2wEYgF8hPvOQoZ9r9VdupzOT6pYqNv7XqvTbcGKs9DUMuosZDoFwPv442Dd/fIzg/H0YDydE4jv/OCGux+ay9z98jPi6hqDQH+DoMkXl9QU4PVI985sFgC/4A9n8Wp4Q2xUiY0qqqFQ02v731czXw1vcHuAWsRCAJkAfsQfR234r5v6R3GjnNsAAACASURBVJT+EeW1/e/nlELN+XpYCf/VhtsrbEHGMsBWAJ/iD2ex46XNXw6leGnHS5vdHiAAwccf57empufFye0BAhB8/OEsAACuA7EAAEjhj8sQAIDrWHUWuzfU5pJ9owIAeA5LzqKlvi57oTd7oXd24G+Zd3Y0VT5i17AAAF7j/wFAGYqO6axD4AAAAABJRU5ErkJggg==" alt="" />

  在tomcat服务器的lib目录下添加Oracle、MySQL、SQLServer三种数据库的驱动jar包,如下图所示:

  aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAW4AAAEaCAIAAAC+cyoPAAAgAElEQVR4nO2deYwj133nK0EQKAgiCVggWKzjtRWsdwPHghTYfySbLDYIskgW8B7ARjYWydi7SGIZQSTZsq0jkh1LsuRdW1IiRZHVM5KsTWDLkuaQpg/1OdPTPc0+2DPTJ9k3+ySnu9k3yeL99g+2ONXv+L1XF1lV/H3xxaC66tV7j2S9D3/vseo3GkGhUCjb0v72jQ40Go22aa3eLEOhUEEQogSFQjkgRAkKhXJAiBIUCuWATqBktOlz4dc+O/zqbw2+ck8sFstkMvXqFgqF8pduoWS06XPGA31/9+mhoSGkCQqFUtExSj7iSJPBpOcHn+r8/q9/+L1PtD798eanPvb+d/5lLBbTdd1iSxpOpuojfOdRNdDxRRZ+7bNEf4mkXjzhkzr/5K8+//zzS0tLdBUGQS25c0FL2/WmFN8xs2W0k6ruVKnWuMen7yqqjjq+XIZf/S2y/SyJPzXw8t2Ue1/4je7/+2/an/1ky1O/1vzUx5qf+lgsFqNrEVy13DKOy3LN9eqS2bdLVIwtw62Ze7r0tSNKUKZ0fLkMvnIPWX5i4OW7obLxpwgh//z1X37++efpWtSuYPcCkxqfaLNmlXZVUALUCf+pUieiBGVKx5fLwMt3k6mHRps+d3K55ISzA/+LkKa3HrztwQcfpGtR+JrlHhUF56IyVEnun3DN1s4CWmd7KGqoulNUs+i9kr6rFsBh9k1GoWAdXyh9f/dpMnp/+LXPEtJE9Je43uv+IiFNb/71Lz7wwAN0LWooIYIRUoMNaWfYs9h/1dtSb1dUUr02xfJmcaP+maJQpIqS3hd+g4zeP/Dy3YQ0ke1nuY43/1dCml7/q19wCiWE9wXOFhOVAVpX+drndsa4AaMEeBWiYtyjiBJUMHR8lfT84FNk9P7Lz/87QprI8hNcL7zzh4Q0nf7qz3skKlGpR70z7OmKKKljVCIqgyhB1V7HV0nn93+djN7f/uwnCWkiUw9xPfnW7xLS1HT/z1FrJaIQQHEAGM8V1cMGJtxTRGWg189EEwBQRDVz3wG4dW55R8pwi1GvCH5LgZpRKJGOL5RYLFa9D+38k7/63uP/4meP3PmTb/zKP3/9l9968LY3//oXX/+rXzj91Z9vuv/nPv/5zz/zzDNu9QYvXBTKnzoeuplMZmho6JlnnnlApmeeeWZoaMiVruDXIArlW90at5lMJhaLRWTCx/xQKBQrDAFQKJQDQpSgUCgHhGmi0Wi0A9ae+KcEOnje3ppHo2tp7W/+XxwdPNf9wkI3mhElwXTdLyx0oxlREkzX/cJCN5oRJcG06etA06QFKmWkJdGNaURJMG36OmBE7TeWrPtVi/agESXBtLmL4CQdWFiwZGERg25wI0qCaRNXABh0UNSQQgfw2Z811f1yR7tnREkwrfrxG8KNbTEaqKMWgpGzP2uquO5XPNolI0qCaSuXgpgjXOKoA6XKEaRJgI0oCaZNXwfiRRB2gmMKJRRHkCZBNaIkmDZxBfBWT0UTH7MzHS5HkCaBtIeeDC6Xj10qk1KJlEqkWCSFYrlQLOcLx87ly7l8OZsv67mynitnsuVMtpzOltN6OaWXUpnSUaZ0mC4dpksHqdJBqrR/VNo7Ku0dlnYPSzsHpZ2DYnK/uL1f3N4rbu0VN3eLm7vFmzvFxE4xkSzGk4WN7cL6dmF9q7C2WVjdLKzeLKzcLCwnCsuJQiyeX4rnlzbyixv5hfX8/Hp+fi0/t5afXc3PruZnVvLRlVx0ORdZzkViuelYbmopN7WUm1zMTSzmJhZy4wu58fns2Hx2bC57Yy57fTZ7fTZ7bTZ7bSY7OpMdncmGo9lwNDsSqVgfntaHp/Whiqf0wSl9cEp3FiXArSLwjMbOogk6qEaU+Aklg5OqNDF3EYhRYvwTUYIGjCipG0pGo9lwNBOeTg9NpoanU0NTqaHJ9PB0BkZJSI0m5i4CnqgCVOG6X7horxlRUgeUXJvJhqfTV8LJjr7V1u6l5s6F1u7F1u6FDzrnW3pi3aGbg5OpoalMzVCCRts3oqQOKAlPHXX0rX3QMdM3GJtd2F5PHCR305vbqcXlnVB45Xzz1PsdC5dHdgYn04gStF+MKKk1SsLTRx19Kxfbo9G5rYyep96EUqm8kTjo6p0/2xLtGdoOTaQHpzI0St6KS726dA2NrqURJTVFyY25zOWhxMWOmdmF7VKpLHor9g/07r6F820zvaP7oYn04GTGLEoiE31odC19AiV3nQpVDI95aRmqgGJ5ACWVAlKUVIpVUFLZ9hpKhicPmrvmR8c3CsWS8R3Qfu8n1HuylUy93zbdcnm1/8ZhaCJtFiXhwXY0upbWqvioDnhqD5cCxv1sGW6F3BpEBlBiLMZFCWVPoaT/WrK1e25zO0VxpOLqnnKZlMrl0bH1c22zPSO7A+OpUCUwUUaJflLPPfdcIhER+b777qPK33bbbfhvzf4NhjRqbIswAY98bhjCPddCVMJti41Kqoc8G5WMzem9wzd7BxZz+SLFEeNGBSWFYmllY/9cW6Q9tNl//XCgEpjYQAn3na+IokmQrm9UzURHJdSYF0UcoqMq9BGVLJePN7goqa6VcFFS2ZnKnAhMvLZWMjanXxq6ORheZTlC/Vkql3OF0s1k6oOOmZa+RO/ogasoYWmCqo2CRG3VqEQRJYo8EpWvAMWIkup+ACXHHPlo2dXLKOkZTITCK+z7QK2VFEvlbL64uZNq7pxtvhK/HN67Op5yFSVNTU2PPvqopml6sK5vVM1Eo8TBqATYo4gSlVkVd62kOsG5y0trJWNz+qWhxKWri+yaKzu7SWcL65uHH3TMXOzduDSy6xRKpueWqjtTqZSu6+l0+kLvjUQi0tTUVEGJd1Tf/ii2bqeTQaK2JhrSUliIACEd/Cpl7joVUp/gGM+qRiWVH4Or+z2Ckr5r2xc7oju7aYoj5OTsJpsvHmbys0vJ823RliuJSyO7/Q6hJJlMFgqFQqFwdHSUfPG3K9t//3YnIWR0dNS9qERlvHkNZChT0lg0OIISeI+oNmDZFV4rMS67UvZUVBIa3z/fFr0+ES+VSLnMXyvJFUpHmfz2fqZ/ePndlmhLX8LBqCSRSGQymaOjo83v/KubLU8fHR1lMpmnz1wwosSV6wxRwlOgohKWIKIIRZEOFiY4xm3LKKmslVQnONWQxFMoCUdS7b2r77dNLa/tFYqlikvlcsWFYknPFQ8z+Z3D7NTs5oW26bPtiy39mw6ulaysrOzv7yeTyZWVlWQyuba2tru7+80X/okIopLKw3vGbXgPe5axmKky7CnS/rA7qWcUzdbDjBda8OuiuiGtzdeyuOwKgEYdJdR+O7/gsLeoeRAl4/PZazPpq9f3zrfPNXdEF1d2M7lCOlvI5AqVjaNMfu8om9zXp+a2Wrpm3rkYvdCz1h5KOvgLzsLCQjweP/XtH/3pE//41efeiMfj/+fNC3/x3VcILyoxDgk7GzoTcaiUUTkLblQka32W1iaqEKgnUFGJSuxAxJMadr8KSrhVVWY3orUSkY0/BhvXSir21C844/PZ67OZ4cnDS8ObZz+ceb8tcmMqEd9O7R5md4+yO4fZ7b3MSvwgPL7R3BF592L0XNdyy5VE1/COg/eVRCKR9fX1+7935n8+/g/3f+/Ml7796vLy8hce/j4BoxLHUcLWLCrD/VPalpQC0tfF7Y+oKpWaAy98BqfGz+Do16Lp0Ph+99Dm+Y75d5onW7tnekOxgfDKQHilNxRr6Zp97+L0O62zZzuXm6/E20PJy6N7jtztWnmTY7HYe12DD77w06qTyeQff+VJEpSoBKjNbD1ORSXAucGMSuquRkDJ2Hz2+kxmZDp1dWy/e3i75craha6lcx0LZ9sX3vvw2Oc6ly/0rLX0xtsHti6Fd/vHjqhncB5/Ky419TFXUfLnT774H/7sYcoXugeILCoxit1f3WM8i77UmBiEG5hQlXC/89kC3I5B173g5bAFjHtEVYlqVulJYIQoqUvqo8zwVGpgbP9yONk1uNXWn2jrT7T0xVv64i19idYrifaBza7BZO/oXv/YUWgyTSUZsIMSQK7+guNx2Xnhds7FqMQVNQ5KbsxlR6OZkUg6NH7Qf33vcnjn0uhuz3CyZzjZM7LbM7LTO7rbd21/YCIVmuTkK3n8x3GpqY/ZFEqCdH2ryFrs0FARh4oQJXXL7XptRg9HMsPT6cHJVGjiaGDscGDs8OrY0cB4KjSZGpxID01luFnU3EYJqmYKErURJXXOOD8a1cNRPRzVh6czw9OZSnbo6oZTKLlPTY0ZlaAcEaLEZ/95hTWUmJUXsng0zr/BkBaJ6WgfmRBibYJjKvURCmVWiBKf2TJKgHgQaYKyL0SJz+wGSpAmKPtClPjMLqHEmPoIhbIgRInPbBMltU99JLr/wsG2kIBeEKLEZ7aJEpXUR6avITMP46KCKkSJz2wTJW6kPkKUoHREie9MCHn8xxtSUx+zqdRHJ64P8Ik7bgG2jC545o2tRFoP5woGz6Ie2IOrQtkRosRntokSx1Mf6TxMSMuonMWth38R20g+hHJKiBKf2SZKVFIf3bo4eCOQG6dYK8P9UxrycLsEtI4cqY20u06F2OuVuxPYb8pwJezRSj40O5WYbdHLtokSa6mP2D3+ikrg01GOSBON3uoYpraNOy1zRMQLqn64IeMhLjuqO1Was/m6/IISldRHJ64PXnwh2sktQ4lbrfFP7v7qIf5FjMmHPCBNOva429aGHDD4uZWzgIANo8TVUKumKHlzQ2rqYw52kgGfdjtgOrFWIhrMjnyBS0khQgA8+GEkSXGj0pynjCipCiMOT0kzDjDp17ipUUcNaREIgAmUCFvw1IbtPIwkOGbxmhElKG/qxFqJKBgRDXXufmnkAg9aYJ6ighLFPY2GElOpj1AoC4JQojJuLVjEF25UApSXHhKhzQL+vGNrKEGh3JZ8guP4kJPGCNJ5lsohlRbherxpyxMcTH2EclW3ll250QewSGHZ6tMNeJyr71cp6ReauLFWgjRB2ZccJTWb4Eg3jIXZEMYsSkwFL96xS8uuSBOUTWmidQQWKG5PcChGcCkjYgd3miZqEeh8UNdKMPURym3hMzg+s02UBDL1kVPyYJd8JESJz2wTJY2Z+ggZUQMhSnxmmyhpzNRHiJIaCFHiM9tEiX9TH4kezwMe/wN6yEqldW4xVEWIEp+ZEPLYmxtSUx9zUFMfWeuhtDZRhQgRQIgSn9kmSoKX+ogq4xRKgJpRXCFKfGabKAlY6qMaRyUqlTSsECU+s02U+Dr1Ef8KFrQC9FBUG0s3Uf9RrBAlPjMh5LE3NqSmPmZMMqCiBn/5NsW/cV60U3onqM0CpppTb0v6OB93P3B3bx3viEWUOC6MOBzRCZSoDBv7T9lKK5c+faM4zlUGv/TVKT6/gyhBNbhO5HY1O4DVAQEbRokiBWCUONgfP6IEUx+h3Nat1EeKMYWINSqDTQosYKgrtqWOCQu99S9KUCi3xU8TbRyW3G1uGfgQjJJqYfVZibWYhW2UyxqYRL5DCaY+QrktzrKryoAHBqfiUSAqcQolQDwSEcAR7oOvUQKskiBNUPalsUMO/vq1gxJ4/FcPifpjYfIieiGio42JEqQJyr4ky67wCHQDJYq1Kc5uuMUAggATnGCjBFMfoWxKPsExRgTSQa64QqG4X6WklEoq4GucqCRIqY9s3gyC3HRWEEosjBzp9IcLJlMokRajIgtRc+wLBJZUFEnqfZQELPUR4sA7on/BAUYdvDYBD354lKozAohTjHMQoDnR6db67DuUBCz1EaLEO8JncHxmmygJWOojxdZZqbSlWBWqIkSJz2wTJY2Z+gg+V3Q6QsSUECU+s02UBCz1kbWzRB2gAhP4dBSlE/9nMOX6LgqgubaJksZMfQSfa+10FCUIJfAhdF1MCHns9Q2pqY85kKmPFM8SQUEUlcCNokRClPjMNlECqNGSDDTUi62BNPgH17r/9ommjCixKYw4XJJ2F+/OKzt3qaFdNaIE5U3RKBHdNoYo8YitoQRTH6HcFj8qYfcgSjxiQshjr69LXe/rCtVw4q+VsA/I1n0IoSu2hhJMfYRyW3iLms9sGSXAKgnSBGVfiBKf2Q2UIE1Q9oUo8ZldQgmmPkLZFKLEZyaEPPr6utTUxxzI1Eem+kD1x6XKG1mIEp/ZJkoClvrIWs04+N0QosRntomSgKU+slYzosQNSe4rMVr9qOWHekSpFS1UFVTbREmwUx8ZH+Fjd5rqs6hLlFT6zC0WPEEo4SZhFCVktIYkbiVwikaVzgTYNlESsNRH3HocaUt95HNfJgCyoEry/+CoG3iWRx1JXJSoJ2RtBNtEScBSHwH1mGqLG4MoUgAOeRqEI7rKBEcxHgGIAOOG3aOCG+5GI5gQ8uiZdampjzmoqY+Aeqy1JT0XLmAnuvG7lFAC76FCj+o2XBV3MgWXYVtsNI7YR0mQUh+xrXMLAy8BKMbts6h1bj2KnQ+M5I/zmZ2VSBEAtCXdgyixiRJAmGTAmvBNq8j0WolowCsuuwLjH15YAQ411MorosQjaqiIQ0Um7iuBpy1OoQTeo1JPsI0oQXlTnNRH1J/SKIC7VgKwQGX6o16y0WhiDSWY+gjltjhRifpQr+6X/shiLBkRBDiKKDEVvATP1lCCQrkt/gSHiwDRwIYXa4HTudGNtBuiDjcIUCxPcDD1EcpV4TM4PrMbayVIE5R9IUp8ZpeWXZEmKJtClPjMLqEEUx+hbApR4jPbRIlLqY9UTlS5Y9V+GfX+oJwVosRntokSN1IfKV1nIAKou9otl0HVUYgSn9kmStxIfSS/yD56QAYuwG6bLYOqoxAlPrNNlFhLfcTuYZ+Oo46yD8I5NTGRlhH1mdrG296dFaLEZ7aJEjdSH7F/wpVIS9osowtCGJYmKAeFKPGZbaLEbOojbnzBuYzUlksV5zh2ynBLKr4KlB0hSnxmQsijp9elpj5mx1MfKe5XLOP4jzLSqES9KpSiECU+s02UOJj6iComv9TEcQGwwmKqjKg/Gk/SDqNMCVHiM9tECSA7v+B4bWR6rT+NIESJz+wplHjtG95r/WkoIUp8Zk+hBIWqClHiM1tDCaY+QrktTfplhfKaLKAEhXJbmsp1WXsTje4Yu0flkIWGavaK7PRB+v5QHzOmPkK5Le2R0+veMdE0YKO6DZzFtWKj7H62EmtNAK2whxQr555V/ZP6mDH1EcpteQsl1RFi/Fd9KHLLSAeqChrgJlQoYAolwJ8idlDFqI8ZUx+h3JbnUGIckPCIYgetIkpUBqqIIABlpC9K8ZA6SoB+Uh8zpj5CuS0PoQQIEOCowdTswz5KTNUAdB54sQAyFEMq6mN2JPWRs3dtKNaDdPOLPIQSdsCIhpN0wAMj3NTsRhSViFoEaoPjGrge+L3i7qc+ZgdTH+HYRnHlOZQYxyr3i1qEEoA+orEHDG8YJSxTpMNb1Bb7Gq3FTZSpj9nB1EeIEhRX3kIJ8G0PDB5gHqQSaMAoAWYfKrRSR8kjAjw5ixJHUh9RR0WP/LFlgGr5Vyevdapm9dpQrkp75PSaB000umOVPdz91Z3Go2xJqh6QO9CJ3KbZdqlDQCepQ8CJ6qY+ZqdSH+kKUQl7lrV6gFNYmqDqLu2RpjWPWDiwPzpa/ddY3riTOipqRb0weyLQH7haoF2qEtE7AL8cytTH7FTqI91MPgHHUQLUjKq7PIQSeNQp0gGAEVAJMFwpYLF9E/HC2DrMFLiHcN9EBaiP2anUR6Kd3AK1iUpUKkHVQJ5DCXf4mUIJfJbiBIGtjQsUET5MhUvWUALXSX3MjqQ+Eq2McK6qk8VEayUqZAECJZWeoGomz6FEBAXgG1g0yNVHpqkJDlChSuWOoERaCfUx1zfJgJ1qkRR+kedQwq6PPML75ucOcukYU/mG5x4STUZUXo6oKlHrZtHDvm+PeAkl1mIHjDh8Jw+hRLTEKI0CKPoAayUWUMK2CDdhjQLs+yCqHKZetTz1MWPqI5Tb8lC+knL52KUyKZVIqUSKRVIolgvFcr5w7Fy+nMuXs/mynivruXImWyaals6W03o5pZdSmRLRtMN06TBdOkiVDlKl/aMS0bS9w9LuYYlo2s5BMblf3N4vbu8Vt/aKm7vFzd3izZ0i0bREshhPFja2C+vbhfWtwtpmYXWzsHqzsHKzsJwoLCcKsXh+KZ5f2sgvbuQX1vPz6/n5tfzcWn52NT+7mp9ZyUdXctHlXGQ5F4nlpmO5qaXc1FJucjE3sZibWMiNL+TG57Nj89mxueyNuez12ez12ey12ey1mSzRtNGZbDiaDUezI5Es0bSRiD48rQ9P60PTOtG0oSl9cEofnNKlMVG1APUxY+ojlNvyPUoy2bIRJUeZEoWSvaNSBSU7ByURShI7xTqiZHQma0TJSCRrRMnQtF5FyeCkrhji1fu6QjWcECV1Q8loNBuOZsLT6aHJ1PB0amgqNTSZHp7OwCgJqdGE+pgx9RHKbSFK6oCSazPZ8HT6SjjZ0bfa2r3U3LnQ2r3Y2r3wQed8S0+sO3RzcDI1NJVxFiXAO480QdlXcFBCNM0vKAlPHXX0rX3QMdM3GJtd2F5PHCR305vbqcXlnVB45Xzz1PsdC5dHdgYn07VBCUGaoGwrUCghmuZ9lISnjzr6Vi62R6NzWxk9T70JpVJ5I3HQ1Tt/tiXaM7QdmkgPTmVqgBJMfYSyqUChhBuVVH/B8QJKbsxlLg8lLnbMzC5sl0pl0Vuxf6B39y2cb5vpHd0PTaQHJzNOocRC6qP68gXp5hcdo+SuU6G7ToWMG6wqh0R2BiVTZ4j2cHnLNEqAW+Ar9ghKhicPmrvmR8c3CsWS8bVrv/cT6t3YSqbeb5tuubzaf+MwNJF2CiX2Ux+hUFzRKAFoQuFGhT6mUWI1KiGaJlp2tRmVbL/0hoMo6b+WbO2e29xOURyp2PhWlMrl0bH1c22zPSO7A+OpUCUwsY0S+6mPUCiuNCILNyjEuBuVWEIJ0TTgFxybKDn64pe3XnrDEZSMzem9wzd7BxZz+SLFEeNG5a0oFEsrG/vn2iLtoc3+64cDlcDENkocSX3EfTCPfeRPdBZVGLo6HaoHVQPdQompYe8UPk7odGUycjzBKZ82zlC+VkqU84VyLt5Z1r5WjE8VNY1op3Mf3e3KndQ4gpLVma3sZ+7deukNR1ByaejmYHi1+oqpYKT6Z6lczhVKN5OpDzpmWvoSvaMHJ1Dy2prU1MdsLfXR8SVi8jF/oAxLAfkFiqmPfCJNNFWhYCGNXOyTpVwm5a3OWyjZ3KpGJYUPv0a008VjlGhEO53PlfVcmWiaaILjFEpWbhY2usKl2+/Y+vs37KOkZzARCq+wr51aKymWytl8cXMn1dw523wlfjm8d3U85QhKTKU+Or5EwORDOi9OYTeos9THP9w6csQ7OhGVSFdM2J0OhicUSk5McBKdZe1rpUQ1KpGvlTiIkuVE4eaPzxFNW+sM245KEpeuLrJrruzsJp0trG8eftAxc7F349LIrlMoMZX66PgSATEBHFIpLL9AMfWRT0RPcODFVPcWSrgoKTXRcxwAJS5NcKq/4Ox/5aHiHXeudYbtoKTv2vbFjujObpriCDk5u8nmi4eZ/OxS8nxbtOVK4tLIbr9DKDGb+kgHkw+xf+q8sIXaKSrAv0Ax9ZFPxEeJ9EccYI8zKNnsJJpGHuosWo1K3LivJPuZe4p33LnaGbaMktD4/vm26PWJeKlEymX+WkmuUDrK5Lf3M/3Dy++2RFv6Eg5GJYAUUSK/pBwd20gKv8gKSmoRlUycIdqZko0JzkGqRDTNWZSsDM0Wb7+jeMedKx1haygJR1Ltvavvt00tr+0ViqWKS+VyxYViSc8VDzP5ncPs1Ozmhbbps+2LLf2bDq6VqKPE2ne+U5ECRhy+E/8XHI9EJeXxY5QUX5NPcLhRCdG0yo3zRNMcuUVt470uomnFO+5cmNq0cF/JtZn01et759vnmjuiiyu7mVwhnS1kcoXKxlEmv3eUTe7rU3NbLV0z71yMXuhZaw8lHfwFBxDeV4KyI9X7SurwC07Hw9VVj9KH1ic4zqJkaSO/883vEE3TP3PvwuSmWZRcn80MTx5eGt48++HM+22RG1OJ+HZq9zC7e5TdOcxu72VW4gfh8Y3mjsi7F6PnupZbriS6hneo+0q+9dqa1NTHjKmPUG7LY8/giH7BUX6cD7CDN86n//3vV2gyP7lp8hkc/Vo0HRrf7x7aPN8x/07zZGv3TG8oNhBeGQiv9IZiLV2z712cfqd19mzncvOVeHsoeXl0j7rb1QJKUCi35TGUdD5MtDNlz+crWZzaLN5+R4UmcxObpp4Mvj6TGZlOXR3b7x7ebrmydqFr6VzHwtn2hfc+PPa5zuULPWstvfH2ga1L4d3+sSPqGRwLKMHURyi35SGUVG51JVv+SH203BGuBDv6Z+41n/ooMzyVGhjbvxxOdg1utfUn2voTLX3xlr54S1+i9UqifWCzazDZO7rXP3YUmkxTSQasoQR445EmKPvyEEp8l0Vt67svVGiy/4Uvm03IOBrNjETSofGD/ut7l8M7l0Z3e4aTPcPJnpHdnpGd3tHdvmv7AxOp0CQnX4njKCFIE5RtIUpsJRk4/OP/XqHJ3he+bDa367UZPRzJDE+nBydToYmjgbHDgbHDq2NHA+Op0GRqcCI9NJXhZlFzAyWY+ghlU4gSWyiZn9zMffyTt2hiPuP8aFQPR/VwVB+ezgxPZyrZoasbjqPEd6mPqjJ1p4lH+txQQpTYTX0U+zBc/ZFo774vu/2fV9hEid9TH3m/hw0rLRLT0Ta9/vyZKk3Wnz/jaluEEDso8XvqI+/3sGGFKHHGe39yqjY0sYkSb6Y+Ej2ep/7Un3qf2dZRjghR4oyjY/HMp++pAU0IId/60ZrU1Mfsx9RH3CYsrJVYax1lVj549m8AAAvPSURBVIgSx7zQOlT8lTvcpolNlPgo9ZEoTpGeKO0zcsQNIUqctHHRhGjaQuuQ403YRImPUh+pcE3lXJX+oOwLUeKwk3/+QBUlxdvvdJwmNlHi2dRH/KtT0JAUCkCf1VtHmRKixHkbF00cp4lNlADyZuoja/JCHxpNiBLnPdcXNS6aOEuTmqHE2rd3fb/zMeKooxAlrnjl9LvGRZPi7XdGx+KO1Fz7qASFUhGixC1vfv3bRppkfvNeR2hiDSWY+gjlthAlLjr1O//RcZpYQwkK5bYQJS46OhY3Lpo4QhNCyLd+tCo19TFj6iOU27KLkkpW17oPWmvdhntuoQyV7DYS02Nvd1B5ITO/eW9dUAKskiBNUPblQFRiGSXuMUg6/qXFjIdExdgy3JqpRROiabv3fclTKEGaoOyroVGiWMZsefbPgz/6b07RxCWUYOojlE1p3OCcGhXcPeyJorPYsN/sWUDrbA+lkw5RzdZQwu0hVSY6Fs/92iccoYlNlHg59ZGFm+JR3pEW4YXljm9Ihyt7Fvuvelvq7apPXmBLyy+0DrH/n4YFmthEid9TH6E8K436AucODG4ZEQKMp7iHEupENjDxGkoiMT3xnR+yNDH7ALFNlPg99RHKs7IelcAoURkVjqCkjlGJqAzQujFDkjWaEEK+9eqq1NTH7FTqI/Vn+bgncivhNiS8XplibM3qtaEclMZdRKAGDLDMwW6zZeBRLVr14KKEWzM3CJIuhUgDGWtlYJRQGZIs0MQmSpxKfcTuAYYuW4Z7loW1Em6FCJG6SFMcA2inTGVIMksTmyhxKvURexQewGzwwp5lbdlVVDOqxrqFEsU4Am3fVIYkU6mSbKLEZuojdqcHoxKVSlCOC2+cr4+5iyYq6QgIId98dVVq6mN2KvURsDgiuc5OnihaK1EhiygqYfuGqqUQJXUzd9FEShObKAFkLfWRtXFrZ7QjKbwpREndTGVIUqSJWZRwZ1JotINGlNTfVIakqoFUSRZQomPqI5RrQpR4xca00kaL0hFYQwmmPkK5JESJh8xdNBHRxBpKUCiXhCjxkNkMSQBNLE9wMPURyg0hSrxlNkOSkSbGkm6slSBNUJZ1AiWiW9SrVnzAxNrDe+iK2QxJVRsfIHZp2RVpgrKmWyiRPoxnCgEAdEQP5iFTqqbSSnNpUkHJT7/04rNPX3UQJZj6CGVNEEqMg596Uk66h3WEedxOGgQ1rLkZkiiaEEJ++qUXiaZduO+7FlBiIfWRTQX+DlTHX5r6nbvqNxmbrVml8opOoARAgBEr3D3cP+FZEvsYMbpqboYkI03Kb71V2R6/9z9bQEm9Uh95DSVe649R6s8iqYOm+ryCqSZUpBqVGLfVJz4ASkTYQlfNzZDEOv1Ld3zzH1dFpj7puqc+8trQ9Vp/jFLvm1mUWGhCKholbKIQLh0sRyUANRAlrNm00ly/+tDPzKJEPfURGwmzz+Nxi+m8SY2oZulZ3OBctIc9i1uz9Cz4ZYp6CPRZVD+3ZtHrYiUtwC2mcpb6+0NPcESwYGMHaRSjvh9RIrIoQxLl3j/4S7MoUU99VL1WjBcfsMFeqWxt8LVbsw22P9zCFgaq5f6oVG72qKiMU6+rss2Z4LCjmnvIJkpwgqNoUYYko9c+frdZlKinPgJQAnxfcS87lctXBUmKG9RXOrdpFZTAHQaqYluHy6hXbuqoqIDlWIb7rvLXStiVURFluHtEO+FDiBKRRRmSjH7yhxOmUKKe+oiLkuolBVx5dUeJtGZ2p1MoEb12aRlphdKS6kedjbY4v+CwEIFjBzaEgX+aQZS4gZKfnnrRFErUUx8BKKEuOPY71rhHOyn42uXWo1KnqKRoj84b4UANcLfhN4StR/qGcF+C2TKid54tZvZ1GevkT3BYKLADnkWPCDTUfpzgOM4RomlDv/NFUygBpPgLjuIAM1XS1wrqy1R8XbdQUvcxg2atyBHgJ2Hqk3YEJepf1LrJL3Y/Kqgv0OzrQpR42gutQ3v/488UafLCY221jEpQKKMQJT5wdCye+PYPch/71zBKLvzJd6UowdRHKJeEKPGTY293HPyn/yJCydy//V0uShSDGjTaphElPvNc/8zWQ0+UP8F53o/9Sdj4daE3auojgkFWDYUo8ZkJIW+femHhU79tRMmbXzkjRQmwShJUmiBKailEic9MCKnA4ntPD/T9/v/O/NLthHcHvW4GJUGlCaKklkKU+MxVlFT85A8n3j71wsQ9f2QTJYFMfYQoqaUQJT4zhRLgGRwuShxJfSS681I3c+8Jt5iz98ghSmop6HE+ytLbUk2djje5WrNNlLiX+gi4T5xbGOCRU0KU1FKSJ4Nhw7zgskPlCWO0BCWvrEqtC1DiXuojUyhhi1WDGssdYIUoqaWghIwqVsEN+ydLFnRtUKKe+uj4+mAiBdEeI0qkZXSrKIH7Q82zECW1lHyCYz8eoXbCDxCjYRNCvvHKqtS6ACXqqY90caDBJYKpDWkl0CUra726jSippZRQIt0TUUYJPhls0zZRop76SHcBJaJKdIXn7qUnskcRJbWUBCXqCyWK9YgQgzaDkhWpdQFK1FMf6bVFCbATKAO3hSippUyvlUgPiSgjOhFRYso2UaKe+uj4+hD81MKWodYpLKynUM2JsAK0TlWLKKmlTNxXIp2MqKAEJzg2bRMlgNR/wVEs5pLUW0eU1FL0BIf90/KPwYqHECV+QYniWoZLstA6oqSW4kQl1sY89dOvU9WiKZtCCbre46uBxJ/gUMMbDkNEq7BsjBPBCU4NUWIUpj5CuS18BsdntoYSFMptIUp8ZmsoaczUR6haClHiM1tGCbDgijRB2ReixGd2AyVIE5R9IUp8ZpdQEsjUR6haClHiM9tEiSOpj8xdYTW/G8UXN9oFT4gSn5kQ8o1/WJGa+phrkPpIcp05mh4N5UEhSnxmmyhxL/WR5DpDlARdiBKf2SZKTKU+Yh+Q05kn7oyP8OknpzPws3ncatnn/aStAwWg654pBr8ulFRaRCGtmTQXieJRs8XQrG2ixFrqI3YPO+qAMmxVKmU4F6v5pEoqtYkqRIiY0q3H+dgNlT8BRnCfDFSsBy2yTZSYSn2ki2MHONxg93NDALZy+fUqaN0mSoCaUYrioIQd/9SjehQXVJ4eBh7AQabUEiWmUh/dukpk4GB3SlECtCJSjaMSlUpQVUGpj7gP41F7RDvZbaSGF1BiKvURsBhhXEqA+aKdFLceaid0vZ6sSqVaKR+5/ZT2BEVJEpVQLOAeVUlowl2OAVZn0C6hBJCrv+C4JDsd9t2L9bg0NskIEG7YiUoiJ6c5iBJEiU1Zix0w4nBJGjCwgVUPCygRNYQoQZSgAiDJ/87HbnM3zE5wMCqpMUow9RHKbWkUEdiRz6UMlykAF3CtxClbQwkK5ba0u3jzF+5vtyKUADtV2IEocQkldc+r6n3Xe/QFShqXEfAiK/yzLgsgdl4DQwrtFEqqHzOmPmKFKHFW+AyOz+wGShqTJogSZ4Uo8ZldQkkDpj5ClDgrRInPTAh5+OUVqXUBSpxNfQTco8G9BdZ4i6p6E46UYYUocVaIEp/ZJkrcSH1kgQuKp7h6LxmixFkhSnxmmyhxI/WRSyiphjAWuqQiRImzQpT4zDZR4lTqI/h5OdFzekaUqJThVq7YFrXNFkOUOCtEic9sEyWOpz7iFhMVUN+wEL8AFXIrQZQ4K0SJz2wTJfZTH1EbutMooZpWWS5RiW5YIUqcFaLEZ7aJEqdSH9UAJfB+C21RQpQ4Kyj1EWX4tlTpUfWG0O6hxKXUR9wFC6Aq0Smindw6VdoC4hpEibPiRyXWUMJ9Vhg+F1Fi1jZRAsjULzhmJx2uylpbiBJndSvjvHFsm0WJ6IE9U4kI0H5BCfBVr7i64YhstoUocVb8/7zCFEpYfEhzFCBBLNsLKAmGECXOip/6SIQSeOainu4EUWLZ1lCCqY9YIUqclTmUKF7uXJTgHKf2KEFjvpKayZkJDjdBCXcDrgottTpKjHruuecSiYjIjZZeAOWG/j8i0HUBYX9R9wAAAABJRU5ErkJggg==" alt="" />

  1、在context.xml文件中加入如下配置信息

JNDI学习总结——Tomcat下使用C3P0配置JNDI数据源
 1 <Context>
2 <!-- 使用C3P0配置针对MySQL数据库的JNDI数据源 -->
3 <Resource
4 name="jdbc/MysqlDataSource"
5 auth="Container"
6 factory="org.apache.naming.factory.BeanFactory"
7 type="com.mchange.v2.c3p0.ComboPooledDataSource"
8 driverClass="com.mysql.jdbc.Driver"
9 idleConnectionTestPeriod="60"
10 maxPoolSize="50"
11 minPoolSize="2"
12 acquireIncrement="2"
13 user="root"
14 password="root"
15 jdbcUrl="jdbc:mysql://192.168.1.144:3306/leadtest"/>
16
17 <!-- 使用C3P0配置针对Oracle数据库的JNDI数据源 -->
18 <Resource
19 name="jdbc/OracleDataSource"
20 auth="Container"
21 factory="org.apache.naming.factory.BeanFactory"
22 type="com.mchange.v2.c3p0.ComboPooledDataSource"
23 driverClass="oracle.jdbc.OracleDriver"
24 idleConnectionTestPeriod="60"
25 maxPoolSize="50"
26 minPoolSize="2"
27 acquireIncrement="2"
28 jdbcUrl="jdbc:oracle:thin:@192.168.1.229:1521:lead"
29 user="lead_oams"
30 password="p"/>
31
32
33 <!--使用C3P0配置针对SQLServer数据库的JNDI数据源-->
34 <Resource
35 name="jdbc/SqlServerDataSource"
36 auth="Container"
37 factory="org.apache.naming.factory.BeanFactory"
38 type="com.mchange.v2.c3p0.ComboPooledDataSource"
39 driverClass="com.microsoft.sqlserver.jdbc.SQLServerDriver"
40 idleConnectionTestPeriod="60"
41 maxPoolSize="50"
42 minPoolSize="2"
43 acquireIncrement="2"
44 jdbcUrl="jdbc:sqlserver://192.168.1.51:1433;DatabaseName=demo"
45 user="sa"
46 password="p@ssw0rd"/>
47 </Context>
JNDI学习总结——Tomcat下使用C3P0配置JNDI数据源

  2.在web.xml引用JDNI数据源:

JNDI学习总结——Tomcat下使用C3P0配置JNDI数据源
 1 <?xml version="1.0" encoding="UTF-8"?>
2 <web-app version="2.5"
3 xmlns="http://java.sun.com/xml/ns/javaee"
4 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
5 xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
6 http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
7 <welcome-file-list>
8 <welcome-file>index.jsp</welcome-file>
9 </welcome-file-list>
10
11 <!--
12 JNDI配置的资源引用:
13 • res-ref-name:表示引用资源的名称
14 • res-type:此资源对应的类型为javax.sql.DataSource
15 • res-auth:容器授权管理
16 -->
17 <!--Oracle数据库JNDI数据源引用 -->
18 <resource-ref>
19 <description>Oracle DB Connection</description>
20 <res-ref-name>jdbc/OracleDataSource</res-ref-name>
21 <res-type>javax.sql.DataSource</res-type>
22 <res-auth>Container</res-auth>
23 </resource-ref>
24
25 <!--MySQL数据库JNDI数据 -->
26 <resource-ref>
27 <description>MySQL DB Connection</description>
28 <res-ref-name>jdbc/MysqlDataSource</res-ref-name>
29 <res-type>javax.sql.DataSource</res-type>
30 <res-auth>Container</res-auth>
31 </resource-ref>
32
33 <!--SQLServer数据库JNDI数据源引用 -->
34 <resource-ref>
35 <description>SQLServer DB Connection</description>
36 <res-ref-name>jdbc/SqlServerDataSource</res-ref-name>
37 <res-type>javax.sql.DataSource</res-type>
38 <res-auth>Container</res-auth>
39 </resource-ref>
40
41 </web-app>
JNDI学习总结——Tomcat下使用C3P0配置JNDI数据源

  3.部署C3P0_JNDI_Config Web应用到Tomcat服务器测试JNDI数据源

  aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAvkAAAAnCAIAAAAadcBZAAAOtklEQVR4nO1de3QU1R0eq3jac9SqtNpqEEEUUBEPr0KsTk89ChWtNpGiFhgehwAqNm8iFGfxkBIgEAgmhIcZxPAmCPJI5DVLEh4hCQmRx6LQ8KjA4kISHkkKgds/FpZl7tw7dze7mZvZ33e+s2d29t7f/d1vfjP329nsRli9fN68zZfmbb6ETIUoqYoiiqIkKqqoqKJ8i5KbiigpgmAL4IjCLQQwJqBFoLb6pO5+QUCyojZvLrxDo1V2VEcK/R7FGicjqa6ajuCJYw3lcVh1Xs0JAYPZGRkDT1UQBLfDEfjxOqIo3bY4t11OUIwOIJQRvDXJegCt2AFaAQAcgi+vo6qyINgoNDc9gJUAaxI7QCt2gFYAAIfQep3a6pNAIBAIBAKBlqHW67icDiAwFFhbfdL7aX5eceoXMbPnJqRnJabNjZ+RGTM9Izo/r9j0PHmgRisgaAUEtiw2q9d5tlM776cv9elm+vyBIUvNmjT9i2iE0KZzFZuc5e57nuWHzs/IjDY9Tx5IWr9fjOxrem68EbwOEMghm9Xr/DtOfKvfS58lDB49IiJ6dMRYqafp8weGLDVrUlpmPEJISBOEWULJvtqd+85vyC+dNT/e9Dx5IGn9bvfqHz3b3Qe8Y3qePBC8DhDIIZvV6ziLP75YGf3DtlE7lg26cTSh7kCs6fMHhiw1a9LseYnoBnozJ/avS2LteRX5ecWbt+5PX5Boep48UHf9Li3a9bveHYu2bnc/faZfuOl58kDwOkAgh2TyOmsLvk/K2ohzbcH3pLg7dxatXrVy+bJlHTo81bt3b/fO/9hHl64dtiw98qojrnz9CFfpJ3hHzVf5TRfIOyXTMwEGkFqvM3/czIyY2RkxszOj0zI/mZE5Ni0rZvZ8mtcJbKHyXGDeWr0wsO9z/V97sm+f34Z3fnRMUuuohKIt2x7u0b60oKiJWlnjLAOvAwRySCavk5S1UfdLXElZG0lxMzLm4DuV1AEHN0eN/0hclh6RPe2dPblD8Dbui533Y2Dpa0xPewtchYHe1KxJs+YlIISqL91mxWHjv9cJkfLA1+/SgqJHxyQhdPloTd6Dw+Jaj4x/ZFSiy+l44Nm2YX1e8FsrC8gIXgcI5JCsXqex8dr16zfZ2HitsfFqfd0litfZufOON3lfzk+PHdo5c9KrF/dHb1g4cE+udEwdtX/TKFL34F3y/PY6QIsR9zo1l9GSVQUrvileuW7PynXFa9bvnzr7Q3qQkPU6Lqej9cjEYxfz74sUqq87ztaXOC6sf2h43O5t9tLCXe3/0v2Fgf380MoCMoLXAQI5JKvXqa+/Ul9/pb7+cn395bq6y7U1P/904geK1ykrK3NvFBbskGP7v9ztITXziZEDOh7ZOurLaW9PG9/3mH30Z9FvkLrjlzzv+9uk++H4Tt2nPl1Pfbr3bo2b8CFCzOskTs8YO3XOmKnpo1NmR124cOpS9ZnaC2foQTS1gVcCXj+6FUUqVFKFN3OZeWvVc+Dfur/7tsvpKFELHpDiqhsddch5uu7AwXP5RceV+4cm7lULSVppNigTJ+lprg6+agUEAjkhq9e5cqVWuBNVP1ZSvM7irxSX01FWWjJlbLvJH4Z9l/7Ehplth7z1WOGKwRuz3188M+KoOkoaFEnqjl/ivTfwR8YNPLIhGftqkgHyT+33sLLibiBU34jqrqL6awghJMR2E2INviqIH3efCpJSXYy9TNHK5XQ81/+Vx8I7/1pKdP6v5HTdgcnbostOrd/+44JvD0/5TdQEilbB2OCK4HWAQA7J6nUuXrxQU+M6f/6M6+fT55ynTh0/8uOhUorX+WZNblHB1kkfdfk2Naz4y7DKnLDKnLCS7LDsyb3rDsRc/yF+y5LRlLSa4nU0HfF3hD4JxN6XzysvkETNmjRzbsyla6io7GxR2Znd+84hhO6K/0N2acpdceF/Xkj8JCuAq7Wh13GZd+NQd/1+pMdT9w8dd6R6w6Fz35WfWj9ceS3/cMaqg5MeGjbh4efbP/NmLxat8Bs5jFpxe7qB1wECOSSr1/nviSNHHeWO74sPV+4+tH9XZam9fM8WitdxOR3/HNqz7KuwLemPb0p73O11KnPCtswJy7T9afvSwUX2fErfgHgduK8DpBD3Ohevol3lZ9TiEwVlpxFCdyf0mVEwOXXH5GkFk34R16fz9HfxIM3pdUysLt31O+zl50vUHfe8H7P7hKIeXZh3OOPV5E45leMfGDK+vGiXy+no8tYdvzTIMqOWezuHrhUQCDSXrF6nslTdtX1NQf7yHfnLduQvs+ctLdy8kvYZ1oIpE0aEff15u8xP262a2mH3wrZlX920O2umPjZkAO2jAfxmjGenZ9ulZy907+KQdrJrZHhzyPMqz283gRriXqeuERVXOtdtPrZJPYGuo1aJ4QNXRw9cGTNgVUzkyk/6L40SPnzWu4t3YWjqEwe+34VVDh5Bt03z15ju+t2ub3jJjoJfDU745QcJm46krD74ec7+T1/89OH7Bul8UZ+UPGXipL4m6uC3VkAg0FwG6/d1psd1yc6Y8G5kRKtWreakp634es6KrFFz/9V55/w2lTlhX08K+yJtoumTB4Yyca9zFaGKI5e27Xba9/6MELp33EtvLB/+xtLhfZcMuTs+PGp1srkJC2S33cxauZyOLn9/3bP9YKc2976X2Gpg3H0fjHtwUJKFdfBPKyAQaDqD8rvJKRMHJY//wL3do0f3mTNSPS+lJsfPHf/0rgVtFtnamz55YChT63WyYvfsOz9/8ZaFOVuyF2+/UYfuSQwf9u179ya+/PTUCNOzdZOr+zoetu7Ztli1F2/bankdmq4VEAg0hUHxOsqkTt5P+/XrZ5M/894zU47MT38qfeIrps8fGLLE/8/5xJTBk1OHJ88c8fm0IbXnfxJiugvR3U3PkwfS1+9HX9H/8cDQJHgdIJBDBt7rjBn5j4QRXQ2b5a1bNCWma/q4Tk0cDgj0j7AmBUSr5we8HqhRrEGoKyCQQ2q9Tm31SSAQCAQCgUDLUOt1dP/vFQBgPdRWnzQ7hRYD0IodoBUAwCFajNeRFUVUVFlRzE4EYBHAmsQO0IodoBUAwCFahtcRVVVSVbvdvmhRjqioZqcDsAJ8XZMUVRWEIOXCO2D9ZgdoBQBwiBbgdWRVlRRVURW1SlZVRZJVSVbMTgrQ4uHTmiTKqiCgpXtrgpcPz8C1Kpzey0NTUuIWfnsdIWSttNngTXne8rEGOPU6NpvgoaiodrtdVSVZEWVFFGVRlBTdXt4/qKrZQ2qAtzGM7N2etB9/iSWyDwIRZudrhFAG+5rkNjqKquIvUerNv2PKJzRa5X7cgfJUF4ynA6kXe+Omt2ki8LpinHiQEmuhdciomK9tSNdq/9LztRd7cN3hSJca3QZ4G9JYOCj78ZdYIvuhQBMPEA4evY4kSahKQUhBVUqVKsmKIiuqrMiyJEqyJEqyLMt4L80x1t2Db+i2IYEloE8xfRqd0hfgBxi9DuWODmM9WADeWhUm92o4m9VwNqvGMetsRcpxe5JjbXRhci9v6gbxWxn29iwtg31cdOuKZe7BS8zvyGal5KtcpGaURaEp196m9PIjMixtAQFHXsft42w2QVFERRG3q/J2VXZvi4oqKqr7jo4oKbpa+HryNL0gSCePfwXhK6y0lJoCFq8jK7SPrigXCIsdHW+ttiZ3a6jZQ+HW5G66QfxWxqpeB88kSLm1XK/D2MaP405/yoKgFpIfiwgsbXTw5XVEWVUUESGEkHL7sUpBCMmyIkqqzWYTZdUnr+M5ct5P/XP3zVYQmgw1Oevu1DSg9AW4Yeh1lu6tEQQkk/8WnuR1rKf2HV5H7tZwdi2F2dKTukFIFavZwAUkFTYlOGObYMDv+zq6rxpeChDDTA17CXfCj16U0fEMSQN5dpIik7QyVBXP0DCa9yPLLPA2FEl145BmRJqdoaqGEUjDaebuR0yWnBnV0C0DlgrRgCOvgxASJbfXURBCCCnuj7FQlYKqpCpVdFOUVN2+jNJTit7XgkDYkfM1pu6rlID0yKSpsVdDSAFfk5burfE4G7fREWWVEkH3cGguE9aAt1Yb5G4Nxxd5mBvblULvILgypD2knaQ2/m0ECU3xOshIjeBtGCaD98If2cdiH5eyajJGY2xPmV3zbNDzMZwXLG108Ol1EMnoVKkiafmBgtDdY7FFN4DQrElucyPc+sSK5YtXoel1cmOfa3DMcjM3tmvD8Sxdnq1I0fU6GrBcxfzzOh5QIgcDAfQ6yGsilDikNpTRcX0Yk/HeoHsCyixIzXRfNbQChtEY21MkRcwVZdiG0ouUD6NWpINlGEG3MctMGQNSUmWMrLvH1xOZT6+jiKJEJ10OzemHglYQ9A3DmL4G9KkgfC2FUAO+Jrn/OkcQbm5QPr1yg/HwWQDeWi35uEODI6XBkZIb29W9gRM3OogskeF5Sl9x6Rv0yMEAP/d1WOKwJ4N3xx8ZRzdMgKVlU9rQV2KETUq3SxOPDvsFHJa2gCxtnHodVKWIonTzT5IVVZTvpKTqfpIl3AJpD96AtFPTAN/wdPE8ksYyDE5KSXcsw+HwyP5VhuVBWJNukwWUo2Al5b21ypbaNFQk5cZ2baiw6ZJkdDQFqSsU40lEOmV4OCPYv3NOSoOSMymOYR0aSk0CRXlPTFLOdAXoo+u2D0gb3Waa/fik8FAsx4IiBakLKR96HHoyupPF56vpopkC3sYwOCkl3bEMh2NRjAJOvc5to3Onv7n1PSxbc2blh6w8QKBeAgC6XsdzaydkfzZQF95apUX8Pje2a0NFki51jQ47LFCoQf3dZAvoE1Kg2BceEFJLG49ex1yjI2DgP7LhiMEeqCWCtCYJDJ9ehRo0WmVHdaTQ71GsUa7B8zrW0Cd0QLkhYW4+obm0ced1RFHCP64y644OwMKA/1vEDtCKHaAVAMAh+PI6qioLgo1Cc9MDWAmwJrEDtGIHaAUAcAit16mtPgkEAoFAIBBoGfJ1XwcAaDbUwvtvZoBW7ACtAAAO4XY4/wdXWCQLaxpgXQAAAABJRU5ErkJggg==" alt="" />

  部署到tomcat服务器的webapps目录之后,tomcat服务器就会自动在\conf\Catalina\localhost目录下生成一个C3P0_JNDI_Config.xml文件,如下图所示:

  aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAhgAAACKCAIAAABn16QmAAAccElEQVR4nO2dy28cyX3H+7gX/wEyAgTrg4Ec/BckBwO+BwGSW7JAYGNvPuyuD17vLpKDFwsICAIBCYJYlvxYZAGvzdXuSiQtSqIe1HIockguKT6GpESJokRSFJ8iOQ/Oq3JoudVTj1/9qrp7urrn98UXRE919a9qenp+n65u9pR38HK3w4c7Ie+ivaN2qBrUliN+oXYsQax8EDJ+laraAbjqYDtkbqttG4cDHj7v8IHaHdU6gwBb5cdbnQZWAd4MGb9KVQ30fsj4rSyC4+Pvqw11fqPD+9H9zHXvqb3/FGlv6f4wmUwmk8nW9hiJRCKRSBHk7e8/9/3vF4fI+TbzPHIWnfqRQybD7gBJ2lQjJSyPBqAZFH1qJOdFIOklUUrKouhTIzkvAkkviVJSFkWfGsl5KUEy/en3Aq+urpbL5bS6SIpNlJKyKPrUSM5LDpLpT78XrlQ4f2Z0dJRYknlRSsqi6FMjOS8JSArnzzDGGLsQMiucP8OZhinZE6WkLIo+NZLzUoDk+AI7/o8Od6pw/szFD79rPUzx6LuRijwvuT3v/mfqfg/lymi3Sb0kBUh2Pl6/8w/iKITz12fPjI6OdoQLCWo1me+Gtl03hdxjpnW8TgVF8XW8o0UxMvJgwDfBlVuEwkS2CMvFifk4zOAhTeo1eXt7G747QFL6uHD+zMqtn76q1ajy2219zBj7/b+dOXv2LB8xlMiUrbp3XpxWl0x3l6qaWEcSOdYEJ+ZluD/IONZ17ILEtUPgvWEdxy+yC0UidU1ykLQW3imcP1M9PNt5pyTksX9unP7Prz888+677/IRZZkxljNK1PvJLEiQdSzSbhgkyAgYwZ8pvpWugUQah0BCIkWXHCTrV340/rs3GfuMVf9b6q2b/zh9418++9l3kCCRNKy4EhJeFi8RqErEDTGR7bYCWhd7qGooKFRFVu0r7V6FMpruGhT+vasKtf2E9w/qXaiDmMZRlZh+yqoemnZbfiQQSEjOSw6Sbz/9funqDxm7wHY+lnjr44NrPyqcP/P222/bXdoSK4hbJbeg7Yy4lfgX3xa+XSD5IqNp6oPdi+V9wXsbEwfZlnYrVU+QLyPuDesDUlJIICE5LzlICue/e/jsA8YusKcfSfz4o0eXf3Txw+++/fbbQ0P88/B2IGGyk3exmqoO0Lp43ofsTHgBBgnwLlTVpGvTBYlYEjtIGG7/IOto25V+7tYgMeohfh/C/fGLxA6QSE5JDpKxC3/F2AVW+qnKt371N/51rdnZWT5iGiMSTBx8Z8TNkSDBJ1zp2iggUdVxASRGcZBt2SVu/MuIn7LdQStdSyAhuS8JSFZXVz/72Xe09q9rra6udoQLiSuXNy87fwzytTQOV67aRFUH2heddbgI3F9VZOkegFuX1o+lDl9NDRv4vYt7Vfo2uciq/mj3j6eWNLK0h0AnxbcAdAbYP6oewv2Bd4WkAwQSkvOSgKRcLo+Ojp49e/ZdUGfPnk30d1M8+v7ELtqlWRR9aiTnJQEJY6xcLq+urs6CSvQnUqRnaqSoov2ZRdGnRnJe3u7Oum/6Gfn8i1JSFkWfGsl5edvPV30TSPIvSklZFH1qJOflrT2a8U0gyb+89KcfJ9uYRHJb3tTEdd+pTx9PJpPJ5Cza+/DTLXK+vfPiAZlMJidn74Pfb5Lz7dQPMjKZnG8TSPLv1A8yMpmcbxNI8u/UDzKygx4bvcwYS70bzpr2j5EJJPm38THhedoKfh1tTbKzznGixByW2jrI/RPEEReCl2EZdTJDJpDk3xbfQ+nRn/svQ0+ZQBLX/gmfVEnDcqtyeRJGIMm/o3wJxcNd5IoIGLL77hGQqA7L6CARj3948EEgIWfbRt9A4EvIfUm0yAHc94dfpX7o97jzBBJ8Tt9BDCBM9w8QEOgPgYScMeO/jeIXA/7a2H0f+v7wK9+pH/297DyBhDN8TCIP4LjukahaJJCQM+YYv4rh8zvkmR3ngCLEknTdmyCRpntpfeSlLcyq6CN4900gyb8tvoeqKwPi2NwIJBxFiCUpOq8gAQ5IAB5ifdP9A4/gxdYJJOSM2ejLoBqY7whfUdNrXFKKEEvScq+BBCaHBUhU9z+AGyE5g0fHW+v2r0Ti1G6/cqvNWi3WarFmkzWa7UazXW+88mm9fVpv1+rt6mm7etqu1NqVWrtca5er7ZNq66TSOq60jsqto3Lr5Unr5Unr8Lh1cNw6OGrtH7X2Xrb2XjZ3D5s7h82dg+aLg+b2fnN7v/l8r7m119zabW7uNjZ2Gs92Gs9eNJ5uN9a3G+vPG0+eN9a2Gmtbjceb9Ueb9Ucb9dWN+sNn9QfP6g+e1lee1pfX68vr9aUn9dKT09La6eLa6eLj04XHp/OPTucfnc6tnt5fPb3/8HT24ensg9rMg9rMSu3bldr0cm16uTa1XJtaqk0u1SaXasVSrViqTSz6ro4vVMcXqvd8z1fH5qtj89V4QaI69HcU5MBcGia77FyCRHvBCrnWdP/AwyCANLkxgSSrIBmbw7LE+qsoLSGQ5MP5A4n20EWuMt0/MdIruyaQOAGSyVKtWKoUF8r35k7GF07uzZ/cmyuPL1RgkBRwLDE7IHSnTvm+1Ns7zhNIgONQegBjjlv8pS2gHBiO5Oy7QyBJGSRTS7XiQvlOcXdoZH3gxqMr1x4O3FgduPHw62sP+ocf3yg8H5s7uTdf6RpIyD3iPIGE9k/qJpCkDJLi/PHQyNOvh5ZGxh4vP9x5tvVyd7+8vXOyurZXKD65dGX+q6GHtyb2xubKBBIymeymCSRpgqS4cDw08uTy1VJp5UWlWud2QqvV3th6ef32g77+0vC9ncL98th8hQfJ7za1Xn80RSaTycmZQJIaSL5dqdy6t3V5aGn54U6r1VbtisOX1RsjDy8NLt2ePCzcL4/NVUxBsnh/hEwmk5OzEiRvvlXwDWd8bR2uArI+ABK/ghYkfjUfJP6yayAZn3t55fqDydmNRrMV3gPe333G7ZMXuydfDS7031q/++1R4X7ZFCTFsatkMpmcnDtAEsAjSPdciZQB4XKxjjSgNILKAEjC1aQg4ewUSO5O7Q7cWNneOeEo4jsoabdZq92enHn2xeDy8MT+6OxJwR+UoEFS7dSoTlVSzwg4pSOR8PKAzM4UkIDzvnQIIt1W2iF4RCJtSxyRBKucHZHMrFRvjz+/Pbp6Wm++/jD+gpAwS9pt1mi2nmwcfjG4eLWwfXf6aNQflEQACXBATExMDA8Pp5LUSN2XYbogkeTy4PEHZrShWssQ7FHVbLdfLUhBEtwjkYLELzypdAxKXLtHMrNSvXnv+Vhx/fUn0TkQCV622u3TRuv57snXQ0v9I1u3J18mDZJarUos6REZJwxSAvI86F41txaunJbkfYJHJGI1YK2WRqr6Pk7CIAnKAZC8oshfbra7DJLhsa1C8YnkI+m8R9JstWv15vbeyZVry1fubN4qHnwzexIFJMPDw8ABMRxSKqmN1E0BRwKpmwrjQUqOoFBccEEQSGIckQAlqkY5kACX0QJL75EEl7bedOkeycxK9ea9rZvfrIp32sXrWuVa49n20ddDS5dvb9yc2I8XJKW19Q+uXfzxr78ZvDXnl9QqlbXHj8Mg8Z/C7W6Kc1fBY8lpdyQGKdJC9hR8KJgK4hPmpg1hFrTjDFhcHdZJFKcowrhLW77wl7aY7p6HNvVj6rz5VgF/aSu8VTAi8f/9Nyh3BCQjUzuXh0p7++XXH4Zwj6TVbtfqzaNKffnR7qXBUv+drZsT+3fjAMnC3OJ773zEGPvxhV/+cm34J6OVv/+/dxlj773zUWltnTHGjUis82Y+Eq6ofLyvOHNJegJO56XVIp7di0MEDiRGAbWd52Kakq874jskzfLhVXB96Vq4RBUNuNkO3yMJ32zn7NSIpDB7eGmwNH1/s9Vi7bb8Hslpo3Vcqe8cVu6Or/2xv9Q/shXLiKRWqfgUYYz97U/++IMvLv/w0tgP3n1V8t47H4m3SQgknPLxvjA5wn0ZgURa2X2QqEYtjkjy77/igiktgFXIyuKlLSOQ+PdIgktbwXDEKZAUF0+u3l7/anB+7elBo9ny3Wq3fTearepp86hS3zuqzS9vfzm40Hd1tf/udvR7JAMDAyw0IrkyuPz9c//01+f/9T//6xZj7L13Ptrc2GCyEYkvsVCsExSqXgaF4iZiZEwduAPcsrihGBPTQ2mEbMkoWbgvOLeKydc6I3ud2d9LDCRADy26nZxiuNkOYAYPEq48yn9tiQ8kOgiS2Qe1qaXyN9MHl66uXBkqrT7Zr5w2yrVG5bThLxxX6gfHtd3D6vzKi/7rS59fLn05/PRqYTf6f20NDAzUalXGWLPB/yhLWAMDA+GtwulYuyDdUKogWZs2Yb2gBYC0M1yh9n1lRcABkDlpE6sX04hEGsQThimm0aQUAUJlCSTAWpgrqjjAVuFC/7qW6h6JyuF//w3fI/Ht1H9tzT6oTS9XxueObo5v9/156avBxW/ntzZ3TvaPavvHtb2j2s5B5cnmy+LsxpWhxT9eLn1xfa3/ztb18b3oz5EMDAw0G3UtSyxAUlWMEoBEBqRpbjChagtoXRxMILO/CAwCiePCZNW4QCJlRtIg8WTCN5G0HOpKWL3xW1vVqVK5MHt44972paEHn1+ZG7ixdLvweLT4ZLT45Hbhcf/15T9dXvh8YLnv2tqVO5tXC7u3Jg+iP9ne19dXq1Wbjfr5//2T1P5H0NfXF97KaCCCT7hJjEiApjHZn0YkmRMypYpZvjsgwUPOaBWBRK9eAMnMg9r0UmVi4eSbmcMb4zv9d55+ef3RF0MP+64+/NOfX/mLa2tfDj/tv715dfTFzeL+3Zlj7re2fvG7Ta253OGDxGcJ5/BHEAZJ+LyeO8GHRwDSatyqqiJNi5K2zq1SdYlb5jogdjW8IP5VvdPMKa0veLziPhG4jlhftQkQh1sQ/+LjiwHFCqoN8d1OWg51JaweAcnMSm1qqTI+fzI6c3iruHt97MXg3a3Bu1v9I5v9I5v9I1sDd7aujm5fH9u9PXlwd+a4MFfmfkbeAiQXL170QQKPSC5evJhKarOWl7vhQheU7te8l6VijFiughOBRK/eAcm3K7XJUmVisVyYfXl3+uBWce/m5P7w+O7w+O7wxP7wxN7tyf2RqcPR+yeFOcl8JL/47abWXO44d+6cDxJ/UBLcLOEGJefOnUsltUVRPkYJ3VR6X3FSrkQgSR8k08u1qaVqcbEyvlAemzsp3D8enTkanTn6ZuZ4dPakMHcydr98b74inSHRAiSffPJJABKOKAFXGGOffPJJKqmN1E2l+zUn5UYEEidAMr1cm1quTZaqxVK1WKqOL1TGFyrjC9XxhWqwEBdIPkArldRG6qbS/qKTciICiUMgmVqqTS7VJpdqxVKtWKpNLPquxgsSEilQ2l90Uk7kLT6ukjNqxpgFSGhiK1KgtPMPKScikGTYzBYkwAFBE1v1lLqVZ0g5F4Ekw2bJgIQmtuoddSvPkCBpHzTBV05LBJIMm1mBhCa2IgXqVp4haSQ+OMK99IRn5p0iCoEkw2ZxgAQzsVVV96i5WC6ukpZ0U/SUiagUUk4y0j6jF64Q5ck+LgiwAIeVfnG4LokvmcAVR0QgybBZBJCYTmzly5M9PQ4sSJc94QdRMIoLAASSsFJNPrHJU5/OS6sBC/jmwttyIDEKqO08F9OUfN0RgSTDZrYgsZjYypcn/IxV1QQkqhKMCCRJKLXEk5i0IJEmbvdBohq1OCICSYbNGPvFbze05nKH3cRWvhICSRAq/DJcyL2UdizoTHhB3IpAElaauSduaXOrWME6I3PZPzmQAD0kkJDjMbMFicXEVr5EQnDpXlVNFUS6lTTXawEgpRpXiInTU+pSmumigPTqxTQikQbxhGGKaTQpRYBQBBJyPGa2ILGY2MpXQiARhw52Iwlp97T96WV1L9N0S10AiZQZSYPEkwnfRNLqAMmbbxXEbCUtBMqNDAcR1/pzHUYJYtqiy2ZWILGb2MqXNCPHNSJBNgdXphGJkVJNPrEJvjokrgIW8M3hQYIJjuk2fpPu6zVI/ByqStPBhLXh5XChNUVUtODiww2FV0nJERRimov4vjIBEtOJrcSFYNAQHppwAxSgMNwlYEOxGtcTbpXYK2kPCSe+Uko78Ut7kh6u4AkybYhbEP/i44sBxQqqDfHdTlo8SODMK122S7hA6pcGF/EAGwZJosOsroLkNxtac7nDYmIrSr55VarJp6elYoxYroKTiyDBp/JYTt61nFABAE798LvQwgbTnFNmViDJ8cRWJFOllnhI+ZInJlkVP7QwQJIDGOIAl85U0IIvaomdh4EEj1dcM7MCCU1sRQqUavIh5Uf8iEQ7EFElemm5dtQCp2zgChUGJMiSXgMJTWxFCpR2/iHlRFiQYLK2hVV0kY5IgPraVSqwWcDPHTMrkJBIgdLOP6ScqAMk2ktbsSdc7fhAe4UNswrTIhzHTTMrkNDEVqRAaecfUk4kv9kuHXkAdayNv9AEZ3l8OaZmVljCbEECHBA0sVVPqVt5hpRzmYGka5e2tAvhyuLwBYgffeDijlkyIKGJrXpH3cozJEjaB03wldPSa5AA9w9EnCR9aYsjhJQxKnJIL9CpWgQ6n9d7JDSxFSlQt/IMSSPxwRHupSc8M+8UUei3tjJsFgdIkBNbZU70ECVGKaScZJTuk+3SBcwD7YC4OkzxWyyOiECSYbMIILGb2CpzIpDASjX5xCbgdF5aLeLZvThE4EBiFFDbeS6mKfm6IwJJhs1sQWI9sVXmRCCBlVriiVVGIJFWdh8kqlGLIyKQZNjMCiQWE1uFj91wqHAJpo6qpnRZ3FCMyS1I28Lk055VmrknAcG5VUy+1hmZy/7JgQToIYGEHI8ZY+//ZkNrLndYTGzlCb+km/SCFgDSznCFVQKJTl1KM12RNrF6MY1IpEE8YZhiGk1KESAUgYQcj5ktSEwntgLSNDeY4BbEOlWBE+JgApn9RWAQSEzVvUyTsDBZNS6QSJmRNEg8mfBNJC0CSYbNrEBiMbFVEiMSLjhcIopGJLEo1eQTm5ApVczy3QEJHnJGqwgk5HjMIoDEYmIrYETCjSq44YW4KlwhXMgtcx3g6nML4l9pW6SwUko7MYv7rOE6Yn2jjMwFYTKQGMUXA4oVVBviu520CCQZNmPs/YsbWnO5w2Jiqxjl0XDBJaWafHpaKsaI5So4OQoS7c+fmP7WVsQKRs3h29L+aKO0HHiSP8Wn35kVSFKf2IpGCe4otcRDypeUIMEkzei/pKsNrv2VLWSWx6R+7btD/k6X4yChia1IgVJNPqT8yINTNj594/EAGwYJkgEwSGLsTxZBQhNbkQKlnX9IOVHHjzZy6RKTIoHTdjjVanEFJHpkW3hIWPQ2uyAhkQKlnX9IOZH80pb0JZfcVYlblXxNRy1a2Ihp3XS8IjYqJQ3MocyBxGhiqzfeeCMTf0l2Sjv/kHIizc12TLoHUjNyLTAiiQskwFhkUYFGuA+ZBglwQGRxYitiibW6lWdIOZdyPhLMqXcUkMDZP1il6o/FZSvVG1Gt7VmQhH+xkXJ0vtWtPEOCpH3QBF85LRncbIfzbxIgQUZDXteSVgP4AVzayjRI8jexFdHOWt3KMySNxAdHuJee8My8U0Qxu7QVHg1oUzzyzgSyHFNTyyQM9nI/IjGa2MqFHE3PnSSnFFJOMtI+o5fok+3SBcwD7YC4OkzxWyyOCAsSi7ypvfAlxZIRSLTVuFGFqjnxDQK3UpAcdRwkmZvYCgCJC7TLqFJNPrEJOJ2XVot4di8OETiQGAXUdp6LaUq+7gj6ry0g58L3JODUD+doPCGAMUr46hPQnGpzuz5nCCT4ia3cydE0IklCqSWeWGUEEmll90GiGrU4IvqtrQybWYHEYmIrX/6xqyoJH99cBXFDMQK3IG1LlQ3doV3mlGbuSUBwbhWTr3VG5rJ/ciABekggIcdjZgsS/MRWQY4OA0O6IP6t4oYR0k24QmQokqm6lGa6Im1i9WIakUiDeMIwxTSalCJAKAIJOR4zW5CYTmxVRUxaBQBAywARGEYgoRGJtbqXaRIWJqvGBRIpM5IGiScTvomkxf/7r/bGA9kdMyuQGE1sFXFEEgjAAI1IUlSqySc2IVOqmOW7AxI85IxWZRIk8CpyKmaMvX9hQ2sud1hMbOVLHFtw50dVGRXCa6sCD8IbqoAktsKJRiTWSintxCzMeXp4bZRTey4Ik4HEKL4YUKyg2hDf7aRFIMmwmRVIjCa2ohydb6WafHpaKsaI5So4OQeSRcV/sooPTNAFLqfMrECS+sRWsYtoZ63UEg8pX3oNksXOMUcszySSEzWzAonRxFaUo/OtVJMPKT+CQKJ6SJBA4oiZFUiY55GzYgIJKRPSj0jEEgKJI2aMvX/hmdYiSPCJxoW5Rnp2PhICCSkrUoJkUfazJXSPxCkzW5DgJ7YipSgCCSkrogcSM2xmCxLggMjixFZ5FYGElBURSDJslgxIwhNbkVIUgaRHpH3QBF85LRFIMmyWAEiyOLFVXkUg6R2JD45wL4NCccEFEUgybMbYzy8801pMT+EjAJ7YKpD4bLnqpdf5uyZciSjpk1ZAubgKExmbWRU9t4hg2oQoAgle2mf0whXE48q0IcwCHFZ6eHNdEl8ygSuOiECSYbMIIDGa2MrrZIO0RFyQ1lEJE9AoplHrwLZJi0ASXZ76dF5aDVjANxfelgOJUUBt57mYpuTrjggkGTazBQl+YitfyJQdI0i4CBFBYioCSbZkBBJpZfdBohq1OKIOkOBnkMWvtf7xLtWkuRah8moWx4gEM7GVKtkFGT/80iLpi5WTAwnXQ67P0kKuArCt9C2EF8T6BJIYBedWMflaZ2Qu+ycHEqCHmQSJdHpd1VS7dkCSBoEn38V0Jsdm1iMS9MRWvpApG0iRpiCpChnfNKYqv2sXpNuq3hrQBykLuUI4AoHESNrE6sU0IpEG8YRhimk0KUWAUM6BxAgSGAO/2YVvSwoS/ETrvWBmCxLTia0IJKoRCdABaUwCSULCZNW4QCJlRtIg8WTCN5G0zC5tIcciAA+QbYmP0wOwkS70ghljP//1M63F9ISf2MqXKiFya+MFCbygjWka0G5Eou0AjUi6IGRKFbN8d0CCh5zRqmyDBC7hhh3BMhxKehkN05/FTlD1FEUWo4HEdGKr4CRIVSJWUBVyFcSFYJPgr6otbXBVl6RtaZsTI4v951oR34v0fUnfBYEEKW5PwnXE+qpNgDjcgvgXH18MKFZQbYjvdtIyAInF9SgtAIC2tCUEEhYNJJiJrZIWkEZdlocbUkQUgSTHUjFGLFfByTmQWN8jUaV75M12IPvDN1Si9DlPZtFA0v2JrcRvgvuRtS0m1wSBhJQVWT5HAl+wigskcAkmTr7NIoNEO7EVKUURSEhZEXRpS3ypHQFI75EAJMBc+MLX7DWWMFuQfIBT0lmMBItAQsqKXoMkYqIPyrX/WBWuuagY3CBBYjRwyZ+ZLUjIWTGBhJQJvb5HospWUgCo0jp8ix7YXDqy0XZD1eEewQmzAgmJFCjt/EPKiei3tjJsRiAhRVPa+YeUExFIMmxGICFFU9r5h5QTEUgybEYgIUVT2vmHlBMRSDJsRiAhRVPa+YeUExFIMmxGICFFU9r5h5QTEUgybEYgIUVT2vmHlBMRSDJsRiAhRVPa+YeUE/0/HHrPYlBQQDYAAAAASUVORK5CYII=" alt="" />

  C3P0_JNDI_Config.xml文件中的内容就是我们在META-INF目录的context.xml文件中配置的那些内容。

  jsp测试页面如下:

JNDI学习总结——Tomcat下使用C3P0配置JNDI数据源
 1 <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
2 <%--引入JSTL标签库 --%>
3 <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
4 <%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>
5 <!DOCTYPE HTML>
6 <html>
7 <head>
8 <title>C3P0配置JNDI数据源连接测试</title>
9 </head>
10
11 <body>
12 <h3>针对MySQL数据库JNDI数据源测试</h3>
13 <%--使用sql:query标签发送SQL语句去数据库查询数据,查询的结果集保存到rs变量当中,dataSource属性指明使用的数据源--%>
14 <sql:query var="rs" dataSource="jdbc/MysqlDataSource">
15 <%--MySQL JNDI数据源测试 SQL--%>
16 select * from ld_user
17 </sql:query>
18 <%--使用c:forEach标签遍历查询结果集rs中的每一行--%>
19 <c:forEach var="row" items="${rs.rows}">
20 <%--${row.字段名}获取字段的值--%>
21 ${row.id}---${row.username}---${row.password}<br/>
22 </c:forEach>
23 <hr/>
24 <h3>针对Oracle数据库JNDI数据源测试</h3>
25 <%--使用sql:query标签发送SQL语句去数据库查询数据,查询的结果集保存到rs变量当中,dataSource属性指明使用的数据源--%>
26 <sql:query var="rs" dataSource="jdbc/OracleDataSource">
27 <%--Oracle JNDI数据源测试 SQL--%>
28 SELECT * FROM LEAD_OAMS_DBSOURCES
29 </sql:query>
30 <%--使用c:forEach标签遍历查询结果集rs中的每一行--%>
31 <c:forEach var="row" items="${rs.rows}">
32 <%--${row.字段名}获取字段的值--%>
33 ${row.RESOURCEID}---${row.DBSOURCE_NAME}---${row.DBSOURCE_TYPE}<br/>
34 </c:forEach>
35 <hr/>
36 </body>
37 </html>
JNDI学习总结——Tomcat下使用C3P0配置JNDI数据源

C3P0 自动重连相关参数
     idleConnectionTestPeriod:C3P0会有一个Task检测pool内的连接是否正常,此参数就是Task运行的频率。默认值为0,表示不进行检测
    acquireRetryAttempts:pool请求取新连接失败后重试的次数
     C3P0目前存在问题:
     当数据库重启后,C3P0不会自动重新初始化数据库连接池,当新的请求需要访问数据库的时候,此时回报错误(因为数据库重启,连接失效),同时刷新数据库连接池,丢弃掉已经失效的连接,当第二个请求到来时恢复正常。
  C3P0目前没有提供当获取已建立连接失败后重试次数的参数,只有获取新连接失败后重试次数的参数(acquireRetryAttempts )。
要解决此问题,可以通过设置idleConnectionTestPeriod 参数折中解决,该参数的作用是设置系统自动检查连接池中连接是否正常的一个频率参数,时间单位是秒。