MyBatis 用户表记录数查询

时间:2021-04-07 01:15:46
搭建MyBatis开发环境,实现用户表记录数查询

  1、在MyEclipse中创建工程,导入MyBatis的jar包

    aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAkYAAAA6CAIAAADawAGoAAAVZ0lEQVR4nO1dXW/bxtL239If6D/Rpe97c25a1AIKRBAat8hFVSVO4BcoJCcqoZpR7dhJ7F5ISIwDpIZaoLBxjlW4ro9j65OiKOG9oEjO7swuSVmWKWUe6MKkdndm18t5OLOrnRVHxP7+vjMcOs5wNHJGI2c8Ho3HI8cZjsejWq1mmma1WnUYDAaDwUgeVqTrvb294dDGrDYejw4PD3u93vb29s7Ozn2oymAwGAyGDjKl7e7u2vaAZLVqtWqapsJRM9IraWNWSjWyqZVUtjGr5hZcDQaDcYdompnVwhG+f1Qgb88BTTOzmjGb96rDwkKmtJ2dHXtgvX7XqB2f1I9P68entd9O6senteOTN+9//6vZPD05uRNKa2RTKx6B6LnESK+sKIQ1sqmVCegCZF0jTVdiSvuU0TQzqxMAo3JUmNxzLY5wW7Q9fklkkqAJ1VUURcCKtG7TKq/rRdCaos4tARRV9+aOMSNKOypMO0biIGTM5kJQGpgV0n9RmGGqSeV9GXzltlI4csBM1cxWFWRKq1arA6u/X//gXtq2/fHXgm3bjuPs1z+47pppmqidW1JaI5tKpcIJxOW9dDpFCjPSfv1GFhVR1DXSTFsMhKOC/yAFFi+wNM5RYRXcXM0UCoJZbJqZyVVQEHyXMZvqiliEVJHUbTrlBblImUBsJnOHlHbHNjtURCIoTSEpsZSmnhXilFNMqglA94RJCceSmK1ayJRmmqbV722/fWdZVr/f/8f8+uKg8PHoJ8uytt++uyNKa2RTqWwjMrkQfKVoMrSuqhiD4QNykP9sSWZIbZVkSyddixV1IkiT6el2K+V1vXDrT2+uQ8CUplEgvg7zgmZWoM7oxt/r3lFBdMZgy3GniExplUql3+sVqwetVuv6+vrvylcX659dXl5eXV0VqwfuulqlUkHtQEoLAnliKM+/n8pmAX15tBJQWghnRaE0FcWKdRvZVCqbDdRqKMsSIU33ayNN1GQsE8Bzp2QY5XMXwmhSRY0I2mKGmjyt8sBzo3sROIbzo7SmmfFfy8EbehCLApqIN2Fjk79BBAvFyMSiQUngN0C3ISwMJpthtRS5CQ0LxNRhPtDNCnwvlNLkWSi2EvulR6Y0wzB63e7Gi+rFxcX3xZdPHj0oPH328+vaw83K4+cvR85wNHIMA5OFTyFGGlp4I70C7gv8gOhrhpSmdvjEunBpDa+cBWUb2bT3TdAPl+VmtymGkUj4T5fWaSKtErE6hCgoql9Gclco04QoH0JpgmWdx1oaIJOM2QRSybd2+dWeojR0t4DjWWANR7jvD3k0nyEoFUGKehBEbo6pwzygnRXErRBKIyl6lmtp5XK51+k82iyfnZ2Zb2qZ/Fbmh+e/HNTXNyvfPXvhOEPHGZbLZdSOR2kymXi0IN33LiHDUJRmUB5UCKVB8kRAlAYaVukeXAl+WhRnkbHYkAP8U3lpWlsUzUujmg9dY4isPK2MtItlvoFH16Z5MgUL532h9wdoSvOuBQpVETmMiiHppMrShNBJ0Q4CprSIOtw9tLOC7GN44BG9m6D4RBwGlymtVCp12+31ja3jP/780Tx4auy7n/Pz8/WNLXdzf6lUQu1oKE2KKnrFU9kGpAkYqryFl6blM1RXXEpTUhrtVTKlLTnkR0l4ziKvpYUQE6I0SgSuGI/PQpQnlcG72O5iQ2JkSsMmfApKg1s3laNLUVoEApF3RYRI0Q4CSWn3HG10oZ0VdBejrKXBYPPkvhhejtF5mdKKxWKn1friYeGbJ0Xhs1H68tvH7k/WisUiakcdeJxcqAKPQhPTBB6DgCG16V6+h7eHoF8OCH/IPN3IpthL+wRAxPeFh1O/JNb0NzzChqK8w5IiiDLaRzyy8qFraR7m7KW54oB2ksPpm/vAYTDFOCqwkfR/TSogMjkO+mHpREdwlJRWI3QQ6MBjqA7zhjQrorj+uAUY8KX9v1t6afl8vt1qdVqtbrvd7XR63U6/2+33ela/P7Ase2DZ9iCfz6N2ImwPCVwycXsIaCKM0mSvLm0ABoJi/VilSHhyXVFbeVFNdMgmjQa/AmBKW17IcR7BROFXU/zOSu8PQCxIvOxiEVJFlW5TKB/YYYUyoMm5/C5tElBUEBPSDfXIvwG3jk9ueotUqEDTzKwWCmh3CLS3pHQwOCq1ZCnTU1qIDvcC5PkTXrNmUjlEOHzyrxencLzuypSWy+XaNzft1o3Ham2R1fr2wMrlcnFEUNBv2E8IWSREDcZSYGpWSErMicFYBMiUtra21rq+9lmtQ7Ha2tpafEGNbEpw40IYLQHb4hOiBmMpwIzGYMwDMqV9Hg3TiAKRPyVTTKKA9+0bJUQNBoPBYMSBTGkMBoPBYCwomNIYDAaDsSRgSmMwGAzGkoApjcFgMBhLAqY0BoPBYCwJZErbV+PVq1dU8k8Gg8FgMBIBgtKc4dBxhqOR46aSGY9HjjMcj0e1Ws00TWY1BoPBYCQTMqXt7e25ZxNLrDYejw4PD3u93vb29s7Ozn2oymAwGAyGDjKl7e7uumcTY1arVqumac7OUZv2vKkknOqRBB0YDMYMoMkGcE+HKQbnJd6fDgsLmdJ2dnbsgfX6XaN2fFI/Pq0fn9Z+O6kfn9aOT968//2vZvP05GShKM0/lZgSReSqjvYtU9rSgz4l1j9PFeV3kk9X9UtqD9/XVVQfph9yhq/aChLi4BmxpKqaQbi9tZVOtr0X8z0jSpv+5DJxEIQcBEmlNDxnNNMPZttBzcgTGKeHu2UK0Gq1OrD6+/UP7qVt2x9/Ldi27TjOfv2D666ZphlHhAqxKG06/gsOlqTyqBlpn5WI5vXfMpYbRwUibyeZ7cR9XsHB75ObQT4T6RH3DtZXVSQTqsCKpG6gNJ18hhSnN8SqQVB2LT50mUdmhFARiaA0dbK95FEanc1aNf2aZiaTUaRDkpLLwCQIMJ97rDGQKc00Tavf2377zrKsfr//j/n1xUHh49FPlmVtv323aJQGoD/7X0oGGu9bxnIDcpAq3aHaKsnPv3SNEq0pRZAm0088IxkBlXHFakc0w1TJGZyozJSmUSC+DvMAOWeU088trRobmLRblXot7hSRKa1SqfR7vWL1oNVqXV9f/1356mL9s8vLy6urq2L1wF1Xq1QqqB0jvZLKGpNIXdoIAn5S1jK/bGPCUihdmYMjfiATWirbAOymDxwi/TSkBPO9RfgWMiyhBOgaU+HCAzx3SoaJnDxTnztUI4K2CkEF7+VYnyAUMWjGNKVAJ90AYVtnkSOAGDeYkRO8oQexKDHfMbgJG5v8DSJYKDGcWBSH0mCXSenq4dBLkZuIli8tig5zADlnVNMvCCxoKI2YcFIW1VisLlOaYRi9bnfjRfXi4uL74ssnjx4Unj77+XXt4Wbl8fOXI2c4GjmGgY0/MN8uAUlpMgGlePzgUgHMxOnVSXs0AG8KPOY3EOa5NQDLqqEnPOJbmB1UoS0f5L8cEFJAR6c0z6jhXJooDBnJLyNf17EOYStSiEFxvIiiNJTscVYLX+IykpTUOJBKvrXLr/YUpaG7BRzPAms4wn2YUTqCzwCzkIdKUQ+CyM0xdZgDyDnjXYjzQuiGitJIip7lWlq5XO51Oo82y2dnZ+abWia/lfnh+S8H9fXNynfPXjjO0HGG5XIZtQPNPvk3/IPMCi1cIs+HorQJeUK68f05mYM0KdqoZbawb0XdddoyFhlygH8qL01ri6J5aVTz4hqD9F4bLfAo9kFndxSBuTsLPLo2zWtdztMtER7VGE1p3rVAoaoYMoyKIemkytT7hUKKdhAwpUXUYQ6g5wwx/aRdUJrAI55IcnwiDoPLlFYqlbrt9vrG1vEff/5oHjw19t3P+fn5+saWu7m/VCqhdkIpbbIeRVKTcNnIplZAHR2lBRUjBPhoT2waPnMkT1GrLWNhIT9KyFWJtJYWQkwajlFb5RDdNCFBIvCor6W1J7cPPUamNP3yDW6MHDy49U45uhSlReil2F6oFO0gkJSWkESw5Jwhpt+RuJeV9uu97sFgM2iWvAqDTGnFYrHTan3xsPDNk6Lw2Sh9+e1j9ydrxWIRtRNOaU4jm0ql0ylhH6G4ICWHKEEJOvCYFdaukFIgk3awmkf9JVSJ8i0VUKW1ZSwkSE8HmB79kliwKxA2RBo1NTUqqZDSTbinoSF1U0TgUSGI6NrUoA2923XQvuQt++Y+cANMcR0H2Ej6vyYVEKiQCPph6URHcJSUViN0EOjAY6gO84F+zjjk9AvbHuKIAc2Zemn5fL7danVarW673e10et1Ov9vt93pWvz+wLHtg2fYgn8+jdiJQmhz9a2RTK+k03h0ShPFS6bS8E0R09Ki9JQIUWzdS2Yaw6YTYyKL/VnTIkLZMaQsOOc4jmCi8YIDfROn9AYgFiVdYLEKqqNANNkcZAIU40Jy8QBIu6PaGVdJq8savICYkFY2VfwP+WmFy0wuGoQJNM7NaKOAf5wF7q+3zZJwotWQp01PajMf9dsBbaUKmXwRK85olpl687sqUlsvl2jc37daNx2ptkdX69sDK5XJxRAQI23a4OGDOYsTE1KGj5MScGIzkQ6a0tbW11vW1z2oditXW1tamEbVENMCHhzBighmNwZgHZEr7PBriioEb+xcbk4DkMnSFwWAwlgycApTBYDAYSwKmNAaDwWAsCZjSGAwGg7EkWNmu//dB6cO/Nt7zhz/84Q9/+JPYz4PSh+36fwf2UEdpldp//teyRgwGg8FgJBj/a1mV2n+2Dk91lNa3BMbbV+PVq1czSv7JYDAYDEZs9K3hl//3b02BldFoBK/39/ed4dBxhqOR46aSGY9HjjMcj0e1Ws00TWY1BoPBYNwLRqPRvzbeawrIlLa3t+eeTSyx2ng8Ojw87PV629vbOzs7d6s1g8FgMBgIsSltd3fXPZsYs1q1WjVN8z4cNX1+zsXEQh5Aoj4eOkpfFrLLjKWHJhvAPR2mGJwCfH86JBWxKW1nZ8ceWK/fNWrHJ/Xj0/rxae23k/rxae345M373/9qNk9PTpjSZoC7se/CYctk80ZaffaJMtuch0+J0uhTYv3zVFF+J/l0Vb+k9vB9XUV1JoDQE2xjKa/rRdDa3ZzKJR1bfC/me0aUNv3JZeIgCDkIkkhpZH5OXdJO9fwRugeSpGpai01p1Wp1YPX36x/cS9u2P/5asG3bcZz9+gfXXTNNM9YQ3BoJpLSEHlipPRjaze0Gshugbyd1w9PELT2OCkTeTjLbifu8goPfJzeDfCaSUfIO1ldVJBOqwIqkbtMpL8hFygRiM7dPI0NDcz793EQkgtLUyfaSSGlRstd50M0fKbkMTIKgylUTm9JM07T6ve237yzL6vf7/5hfXxwUPh79ZFnW9tt3TGkeEmrcI+Q60HhaQn4fFe0lsNd3DMhBQjKNSClA5WddukaJ1pQiSKMhZ6yZSnldL9z6d3Z2MlOaRoH4OswFsShNP39g0m4pgZLqtS02pVUqlX6vV6wetFqt6+vrvytfXax/dnl5eXV1VaweuOtqlUoFtWOkV1JZY5I7LG0EQSwxz1hQtkEmM5PSlAVeg8qQBuW99mELsNlUNptGJfFNsk3pZjYQAfwaJNQlACNNRvIgO8gDIQyXmJRUlqEcDmURBS2JY6ygRtAjKCNoUjWkoV0OG677BHjulAyjtEohjCZV1IigrUKoydMqLyfxpBJ3efmr5kZpMCMneEMPYlFivmNwEzY2+RtEsIK0plKU0y2Kc4DBISOli5DNsFoKlb81PF9aFB3mAjCmwswlosdh8+eosFo4IlLJSllU4eDEpjTDMHrd7saL6sXFxffFl08ePSg8ffbz69rDzcrj5y9HznA0cgyDtIieJYKn7lPZnyfGkzCtQsAL5AtVUZqYUhTfCdoDK0gBRahuCmziaS8JgtqrhLpmW5Oc1CuWBglT5eECObxxMTXU61Y0pUl3NZS2IvTbp2DNOEfrsn647g/+06V1mkirRKwOIQqK6peR3BXKNCHKh1CaYFnnsZYmJTUOpJJv7fKrPUVp6G4Bx7PAGo5wH2aUDgn1iqUiSFEPgsjNMXWYLwguQkmv9fNnQoTou1mupZXL5V6n82izfHZ2Zr6pZfJbmR+e/3JQX9+sfPfsheMMHWdYLpdRO6FZreEfwPxJjhC0gcGlVMWrhe2ufIdiVKeRTZHsRSazXkllG5SBF1Nr00IxTQDlxS+R0wI9WX0x2iNSxyBjeWlS+1Jd71Ly0uRxpiWjviQxqikH+Kfy0rS2KJqXRjUfmr8+svK0MtIulvkGHl2bRu498L7AOoVTmnctUKiKyGFUDEknVZYmhE6KdhAwpUXUYd7QxSCjzB+3e+jdBMUnwPDEprRSqdRtt9c3to7/+PNH8+Cpse9+zs/P1ze23M39pVIJtRNKaRMLh+yWa9koiiIoTS2TvqNlLxWlRWIHPaWRBCBCID7kknmtBrSgKKZGfEoLikdcS5uW0ui+JI7SZM4QnrPIa2khxIQojRKBK8bjsxDlSWWkvYiUyzkDRKa0KKs3oZQGt94pR5eitAgEIrYXKkU7CCSlJYPERGj+MZHmj9c9GGzG7QpXsSmtWCx2Wq0vHha+eVIUPhulL7997P5krVgsonbCKc1pZFOpdDoVXGaFRRRHDKhBs6cLPPpRsKznVeBFuxiUJgc/A2dIFKQNPEZhHsqBbGRTwgDA4VIVkwYE6yQHALGvhAhYuclEVpAKPKIh9UWEdDlRlKaMqQQrO5olsWDDIx2HodtUiiDKaO1bZOVD19I8zNlLC4witUfzqOCb+8ANMMU4KrCR9H9NKiAyOQ76YelER3CUlFYjdBDowGOoDvNBIBx4V+RNWCfSjkfaq7ull5bP59utVqfV6rbb3U6n1+30u91+r2f1+wPLsgeWbQ/y+TxqJwKloSUptM0AbcII3R4SRK/IDSbi9pBIlKbYhYEETW6Ebw+hx13yTiZ9FjbYS8ylKiYCRyLJ7SW+opDwiMGklE6jf1tcSqP7kiRKk+M8gokSXzjlt1G4ciKUlDcn0hUJEVJFlW5TKB/YYYUyoMl5rKV5AUUFMSHdUI/8G/D3CJObXjAMFWiamdVCAe0OgfaWlA4GR6WWLGV6SgvRYa7wJxg5LamJEoHSvCa87SSqyRib0nK5XPvmpt268VitLbJa3x5YuVwucu8FRNhiPnXpRUOSDPic8Al2GWBqVkhozInBuA/EprS1tbXW9bXPah2K1dbW1qbRJa5FW2pKU+9IXFp8gl0GYEZjMGaA2JT2eTTE1QNu7I9RZykt4CQ2+Cn5K59glxkMxh0gNqUxGAwGg5FMhFLa/wMZCOc8NWMCoAAAAABJRU5ErkJggg==" alt="" />

  2、创建MyBatis配置文件mybatis-config.xml配置数据库信息
mybatis-config.xml文件
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd"> <!-- 通过这个配置文件完成mybatis与数据库的连接 -->
<configuration>
<!-- 引入 jdbc.properties 文件-->
<properties resource="jdbc.properties"/><typeAliases></typeAliases> <environments default="development">
<environment id="development">
<!--配置事务管理,采用JDBC的事务管理 -->
<transactionManager type="JDBC"></transactionManager>
<!-- POOLED:mybatis自带的数据源,JNDI:基于tomcat的数据源 -->
<dataSource type="POOLED">
<property name="driver" value="${driver}"/>
<property name="url" value="${url}"/>
<property name="username" value="${username}"/>
<property name="password" value="${password}"/>
</dataSource>
</environment>
</environments> <!-- 将mapper文件加入到配置文件中 将来mapper文件很多所以是mappers -->
<mappers>
<mapper resource="cn/bdqn/dao/UserMapper.xml"/>
</mappers>
</configuration>


jdcb.properties文件(com.mysql.jdbc.Driver 一定要大写)
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/testdb
username=root
password=bdqn

    mybatis-config.xml的头文件:去dbf的文件开始位置找

<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">

    a、复制mybatis-3.2.2\org\apache\ibatis\builder\xml下的2个文件(如下)放到你想要的地方(我直接放工程里去)

    aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAkcAAAArCAIAAAD9iLuoAAAL3ElEQVR4nO2dvXLyOBSGuS1fkMtcwN4AdB5ugOEGoGA8zHicZLJNmjS07r5t2DrhxxhsmC38dyQdSTax+Tb+3qcKRpZkwHp8jhVrlAEAAABDYaRu+ttIkiSP7yUAAADQBN5qWZpmWXq9Ztdrdrtdb7drlqW32/Xj4yMMw6/d1+M7CgAAAFhhrPb29pamF1Vst9v1/f09juPn5+fPz8/H9xUAAAAww1jt9fX1cjmzYgvDMAiCIAjCMOyi9chzRq5/336OF3XRhW6IPGc0Go1c796O+a59vyZlAAAy22DyNN9o3tzMJ8GWvtQXBT8DxmovLy+Xc3K5nNPLJUsvktj+3W7/+fXrR1nNd0c59zTVtDt53XfrFlb7H7INJk8FZKDbzIttwmCYbxbHw6qkMkxKw+w2mMjVkTJ8N0SY1vU16+ps0lD3kFbFlquPT3xTW97IZs59DBmRWvEHrNYx+rOgfFv+Bc43mfTt81+dFsZqYRiekxMrtsptQRC0PDaWVla7T4GR5xQ7+W5fXutAN3UV+sOE1R4KuYavJbQNJk/VKPhENj5N5nPZVMWruiB5j5yn22AymUzkM7csw3ZDKqi2bqpZU6e1oZ4QG+MvDugGa/lMMR9HfrD1N1EePqzWJaazICu3l5uFIvQyRLevDsZqQRAkp/icnM7n5HImYst+otUIvVkBVhs65eAnjKhMwKW9HJWTXPXrvGollGBjC9GG8lty65qam9RpaKhzlJ7LG4xW4zbQd+Q3xHwjdbpOfKAbND/E8tvdzMUPnBZve5XFWG29Xp/iWBJbKoptvV4r+/nuyPH8/AbTyPXrzJ/jRXJurhig8xG8yhCS0by4UVVtrMuMHC8iI79cUI9RCnX9ZRnSYl2z744cz6PHRcu5vqCk6h3H89i2aRN5deJh8mXA4yGnnpiLFEMu/tQzSa2OyAziU7rBwI31Us0kzrTV+ciARf3cpC02q7XRmii1KtAjFkes1g+6q6vN/Gm+YX6apHzr1AFjNd/34+PxFB9FsZ1LsaXXa+b7qkF8Vxrp61tNpZiIMVw/K5VUaqBOEUaeWw7fdKOgsqoCW/wWEdHy+K7sC3FL3QffFY6rNo8SaNF8Z+Q5qpCEhChpjx6Srgx4KNUJpg63JquVaTDphCTDphAqSMMtqxp99KANHM1WY+u0hXfd0qfVmFyv+Go+n8w3gvxgtW7RnAUVRZDMZMk7va+2Wq3iw6ESW5KczokgtixLV6uVsh+Nhdi/6R+KqJSXShDGWa3wJx3sSYSkakQOgBwv4oI4eQtn5izyHL3VpBqsTbAZSGsloH/kZP9dsRqbTKE7yElJpSbbrQVtbtSgKLbOtvcwvg1rKYPireWV6usboWI8HARbNUcJq/WDnGEk2+cb5l3h22r5o2Sstlwuj/v98XCIj4dCbCdRbGm6XC6V/axWKzzA2kl4SWMbcX4hv19hwHsnETaymiTmDFb7E5DPJpN8DBGDGC8RqXFz/JiKGpzUdCdtzdY6H660jDlcJhtrtJo1tNSFA1mZouRuquHGWteYs+rbYCJPNSal26UPGKstFovDbieILa7EluT/yrZYLJT97FbLIs9xXNehYpDydLISSAk+A+mRvZkcYz0F0jDrnib6fK8I39S7gFkLq+kykHUndClKXQaSTWOC/mBvQ5EhVT7RxNGWBAGkoib33hhZNjihG9Rc16Q9tN8xjKtzGtU7LOY5kLZel9Li//MBsVp/8GeBgDQHks8xfD9Wm81m+91OENvxeBLFNpvNlP0aWE3WReQ5I9dVJ4vU2UfHdeWJIWK4x001EWg0naQupM71UGaLNLKacBD1bBGqVjpDxZNErs5F0U05Af0gX79T6UiDpBwbkfn+Ykl9qkxwjzKhwRg+8K3zNT+VE0jUOu0N9YTYf/scGWt5YU/6ieQv5UsRWK1PrP8DqST12d9ju6+Esdp0Ot1/fe13X6XY9qLYTpdzMp1OWx5dwR+aRftDDxsINEmjPHamxlApxlJ2LCzeq6JWWG1wMFYbj8e7z89KbAdObOPx+J7Wvv0vZz8HkvrE7EWQZZAaAI+BsdpfzWjbEp3t/0dAUp9QGgAAPAbGagAAAMAPBVYDAAAwHGA1AAAAwwFWAwAAMBxgNQAAAMOBsdrfRpIkeXwvAQAAgCbwVsvSVFoCO8vS2+368fERhuHX7uvxHQUAAACsMFZ7e3vLH2Esie12u76/v8dx/Pz8/Pn5+fi+AgAAAGYYq72+vl7KZ/NLYgvDMAiCIAjCMOyi9XufNaJ/UPEwafLALTyUCwAe47KT4kKieGLWAGCs9vLyUjyb/3LJ8pVCidj+3W7/+fXrR1mtekLwj32wCaz2W+CfzFo9dlVZD0p+8GBVUhkmmefyK0/KqspYHxDLt66vWVdnk4a6R3o6s/g4foli3eo7nnurfRRZJbXiD1itO9QlkSxrsec7lMvON3yGtQpjtTAM80cYq2Kr3BYEwT1HKdPKavcpsH4eo7Cw9M+CXxRAVwZ0ArmGryVE1tOoV8fI1TGfy6aql6wxLnO5DSaTibJMR1mG7YZUUG3dVLOmTmtDPaGuLKNeHJhXouGvGixUTzcWpQar9YXmRyWtREMX6K1+j22X/WOsFgRBcorPyel8zlcKLcWW/USrEX7uuA+r/WbKwU+74rT6ksAsgymsPToJtkoowcYWhkWfmdY1NTep07i6dMcoPZc32FYN1X/w6hP5pXwjdbpOfKATdN9S+e3KC+XR323bqyzGauv1+hTHkthSUWzr9VrZz3dHjucXj/R1/Trz53iRnDQshuB8jOaWSJNXRSOrnanLaTdLMOqHfXPPdc3oOq8/KGG1tEguLHeOLvCWvyt+CHwZ0Afk1NMu19tkRVDldR2RGcSndIOBG+ulmvl1G9k6HxmwqJ+btMVmtTZaE6VWBXrE4ojVesGQAX6ab5ifpn4dXTuM1Xzfj4/HU3wUxXYuxZZer5nvqwYhQzN9Pn9lIGIV3y2XsnbIsF+nCCPPJWuOGtfCtsdvEdEVj63n+v7wnee3SyuOcp+A2CVuJRvdStlY7aZHqhNMHW5NVivTYPoFvIRQQRpuWdXoowdt4Gi2GlvnY5fD6dNqTK5XfDWfT+YbQX6wWh/of1JFkMxkyTu9r7ZareLDoRJbkuRLYNdiy7J0tVop+1nXwqZ/KKJSXirREWe1wkJ0OK/CFy72kUMcqWOGv439EV5qtoth1YiEsIxupbiSzUBqy4AukZP9d8VqbDKF7iAnJZWabLcWtLlRg6LYOtvew/g2rKUMireWV6qvb4SK8XAQbLFq6CMwBVv55y3nH6Vvq+WPkrHacrk87vfHwyE+HgqxnUSxpelyuVT2s7sh8hw1fcgIIPIcJjjR71cY5+5pgraeW/sjvNRbjWkcVvtfI59NJvkYTl0xXiJS4+b4MRU1OKnpTtqarXU+XGkZc7hMNtZoNWtoqQsHsjJFyd1Uw421zrD8YwWZ6au9ZGyXPmCstlgsDrudILa4EluS/yvbYrFQ9msQ8USe47iuIyTihPtRSq6SlOAzkJ5wN0vpFFmSWv/vALae6/vDdF67XUoYcmqsu0gL81LVlwGdwN6GIieofKKJ5y4JAkhFTe69MbJscEI3qLmuSXtov2MYV+c0qndYzHMgbb0upcX/5wNitZ4xG0maA8nnGL4fq81ms/1uJ4jteDyJYpvNZsp+jfJ44u2fyHNGrqvOq6izfY7ryhNDxHCPnZVBaTCdxNpztj+mznPbDVNOaAFy77FKVXqSVsW7gEoZ0AHy9TuVjjRIyrERme8vltSnygT3KBMajOED3zpf81M5gUSt095QT4j9t8+RsZYX9qSfSP5SvhSB1XrFdrGkJPXZ32O7r4Sx2nQ63X997Xdfpdj2othOl3MynU7btFIzoDyZbqbKt/8DAQyUJmmUx87UGCqF+dixsHivilphtcHBWG08Hu8+PyuxHTixjcfje1ob1IAPq4FWQGoAPALGan81o21LdM78IIDVAADgfwdWDQUAADAcYDUAAADDAVYDAAAwHGA1AAAAwwFWAwAAMBz+AxKkN4GFzcJ6AAAAAElFTkSuQmCC" alt="" />    
   b、然后在window-->prefenence-->xml-->xml catalog-->add-->config.dtd这个文件,然后key写-//mybatis.org//DTD Config 3.0//EN-->确认后就可以正常使用这个文件了   3、编写实体类User
 
package cn.bdqn.pojo;

public class User {
private Integer id;
private String username;
private String userCode;
private String userPassword;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getUserCode() {
return userCode;
}
public void setUserCode(String userCode) {
this.userCode = userCode;
}
public String getUserPassword() {
return userPassword;
}
public void setUserPassword(String userPassword) {
this.userPassword = userPassword;
} }

测试类:

public class UserTest {

    private Logger logger = Logger.getLogger(UserTest.class);

    @Test
public void countTest() {
String resource = "mybatis-config.xml";
int count = 0;
SqlSession sqlSession = null;
try {
//1、读取配置文件(mybatis-config.xml)的输入流
//引入包,是ibatis的包
InputStream is = Resources.getResourceAsStream(resource);
System.out.println("is======"+is);
//2、创建sqlSessionFactory对象,完成对配置文件的读取(application作用域,创建完就没必要销毁)--一个就够了(单例)
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is);
System.out.println("factory======"+factory);
//3、创建sqlSession对象(request作用域,用完后要关闭)
sqlSession = factory.openSession();
System.out.println("sqlSession====="+sqlSession);
System.out.println( sqlSession.selectOne("cn.bdqn.dao.UserMapper.count"));
//4、调用mapper文件进行数据操作(调用之前必须要把mapper文件加入到mybatis-config.xml)
count = sqlSession.selectOne("cn.bdqn.dao.UserMapper.count");
System.out.println("count===="+count);
//打日志用log4j.properties
logger.debug("countTest--->"+count);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
sqlSession.close();
}
Assert.assertEquals(6, count); }

 4、配置映射文件UserMapper.xml

    a、头文件 :搜索:sqlsession就可以找到探索映射sql语句下的头文件
    b、然后在window-->prefenence-->xml-->xml catalog-->add-->mapper.dtd这个文件,然后key写-//mybatis.org//DTD Mapper 3.0//EN-->确认后就可以正常使用这个文件了
  
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!-- 如果我要调用mapper文件,就去拿到namespace+id(方法名)的名字就可以访问 -->
<mapper namespace="cn.bdqn.dao.UserMapper">
<!-- id要唯一的,一般是下拉类的方法名 -->
<!-- 返回的是什么类型int -->
<select id="count" resultType="int">
select count(1) from user
</select>
<!-- 增加 -->
<!-- <insert id=""></insert> -->
</mapper>

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAUkAAAHhCAIAAABsp9t8AAAgAElEQVR4nO2df3AUx4Hv55/U/flcr3KV471KOZc4FTuuOxLFUuyNA65XdQZy9Y7EOVKQZxDG9tgEpwzKD+MzfsIywuJHwhwILOdsSfYZED+ECbHXkNgleASQMAaBIVbYA0kIbP1avEhIO6sl6ffH7M52z3TP7C/tbre+n+qidnqne2ZtfbZ7Zre/q0UAACqiFfsEAACTAtwGQE20ZgCAimgEAKAicBsANcmn293dbdVNTTOb2qqbmrq72/LYMwAgU/Lmdnd328y2tsq2tsOHDzc3vzmzqQ16A1BEsnf7bOuzdiGEVLe1VTa1NbU1tXVXt7U1VVa3VVY35e00syNkBLSAESryWQBQFLJ0u3Pvs+zmyplNbYcPH25rq6xumlndNHNm9cyZlU2udiEjoGkc34I6t5p5Okn6tvq4bffK7hPUNU3Tg549p7MPAEUlM7e3vrBu6wvrtr5QNzHQODHQON69bfjshr4jz//5wIrqpqbqprbqpurqypmV1ZUzK6urq6tdHYSMgBYIBBzCWcZ7u20/GdS9rQoZgXSso7xP9RgyApoW0HWvHtLZB4Dik5nb6577Ve2/t5Mb/89durvbZja1zWxqs0bsmZXc22khI6DphsO+kBEIGIaeptt+7qbnNrOXo0k6PaT5DgJA0ch4Tl61YgsZ+h23dHe3VVc3zaxsW716teBGWkIJ2tXERqKKnUYn96P2Z6VKjPhacoZMTd4DRojal7MjpSZzPnAbKEHGbj/6xCvk2pve5dEnXhG0TirBToMTNZZelGe2gILr7ZChu2fqDqH1IOGY6KiA20A9Mnb7R5WNpHsb6d5W+fhrix97bfFjjYsfsx68VvnYa4sff63Sevz4a4sfe83VmrEtYIR4StNVCX2c47zHyM11O/HmQPmbwbjNveUGt0Gpk7Hb3/vxdnJxnVUeWvjGb3v/Iio/ePg/Xa0pJYK6Rl9ls9NudkLtcC+5Zd3VsupTe3PdTh1dc83ycb0NlCRjt2f+625y4Xly4fl/+lHLrj+Zuy6Yu/4U2/Un61+7mP80r4XX2iEs9UGS43ZZQNcD7utuu13ympm+CveckxtB4qwKcGcFBG4DNcjY7fJ/aSVnf3Hf3NbGYyONx0ZeOz7SeHyk8dhI4/GR146NNB4faTw+ct/39wpai29Pu4Zm52YKpoPEdJn6TCr1iRrrr7g1p8rxhOMl+O0DQPHJ2O1/nLN/+vd+u/md4c3vDG8ODm1+Z2hzcHjzO0Obg0NWzfTv7c/9tJxDKQAgQ7L5XtqdD/7Oo+ThpDDhBSBnSm6NJ3sVDgDIkpJzGwCQF+A2AGoCtwFQE7gNgJrAbQDUBG4DoCZwGwA1KRW39RllxT4FAJSi0G4f3VBhF0JIzaxp7lLgUwJASQrqdutTd9CbfWcO1cyaNjH++/7j9RsXPmg9gNsA5IXCuX20tsLsbzD7GyJdRn9nXc/hlZ91H6+ZNa3/eP25Pav1GWXWA7gNQF4onNvv1ZaZkXa6PDv3gZpZ0zYufFCfUWaVjQsfrJk1jXvtLchXocOPU+s4sYYMgAK6XV1m9u+ny63xbntOrs8o85qTc1aGWbLT67+hNAApCuf229VlZk+zXVqrpnsUV2tX4JlDdyz4BoClcG63Vt1tdhlWaa2abvY0cEt/Zx3PbQv6Z0ngNgBeFM7t7U/dYXbVmV11rVXTrQfuIhTbO/CMEDb9NGhAczDlKZzbjZVfNDtXtlZNNztXc4vniO0OPONmjiPCDIAEhXN700PTWqumm50rucVbbABAphT0uyuN+tc8SiHPBADlKZXvkwMA8gvcBkBN4DYAagK3AVATuA2AmsBtANQEbgOgJnAbADWR0u05c+ZMWt/p/c5gfpemYKELmATkcHvNmjVLxaxZsyZ/h4LbQBHkcHvp0qV9Q6Zd3Jv5OxTcBoogh9tPPPFE35BpPe4bMp98ktl84okn8ncouA0UQQ63H3vsMVrmt99+25z4q725ZcsWz9aOHLWgrgUMQxckq1ExbM71oqlKtiW33vso4t5cuXCunbGCFaSFHG4vWbLEnoFP3PrrnDlzrCvtMfMvY+ZfDhw4IG7qzlEL6kyeosM7NoYtlfhAZz/QnXrVi48iahUy9OSO7KHZdxLoDfyRwO05c+YsWlS5aFHlpk2bOjo65syZM3/+fMvz+fPn23fU+I050126KmQEOG5T6iQ3Hf3Ym6J676MIWyUPSQ/RzpeQ3lUDmPJI4DYh5OH/87AlsznxV+tGmmMH4R01udwOGQFqCA8I3cbVOfBHDrcXLJhv+/zII4utx/StcvHdcneOGs+61LQ5ZARSDagNuh9aQY96j6MIWlGNHIdm5uRQG6SBHG7PmzfPdnvhwoWWyVw4jZ05av5u67r3rbSAYVB98Ou9jyJqlTrXgK4H2Ety3EsDGSGH2w/98IfW4Dxm/uXHP/7xY4895t6HW1loMKiCkkEOt3/2s5/N/f7cud+fu6Z2zdE/Ht2xc+fiRxY/8eSTdCn2ORJC4DYoIeRw28Hq1auLfQoC4DYoGaR0GwDgC9wGQE3gNgBqArcBUBO4DYCawG0A1ER9t9uCddxS7PMCYHJR3+333lkfm7jlKOcPLIXe2RLU8b1XGVDf7UMHNrrdvvj+qgs+eru+hpLr+ivru+LuLoK6IL2hVIHbcqC+2+/s32TGblklGoubsVvR2K2e9k0X3191/sCTwf2/FrSbFLcDAd6aUrgNJgH13d7funnMjI+Z8btmL1v2witj0VvLXnjlrtnLxsxb4+atA/s2C9pNitu64QhWCBkBdlWZBMBtOVDf7T27to2Ox0fHJ9Y27Llr9rKR8fhds5etbdgzOh4fHY+37tkqaOflNi/UzJHKRpjotYARSoYtMP1aG471oM6uRRFuaUW7CU6GUEdLtEuuKQ/qWsAIJk4jUcF0BbflQH23t+98JXIzHrkZj9ycsKy+a/ayyM0Jq6alpUHQTuw2J9TIaaceJM7oNTrChQpSY0NduHlpogg3j2g335NxnTqTGENlRWjOk4XbsqC+203/+Wp4ZMIqlthrG/aER2JWzRtv/oegnce4bf3JU8+ymaXJ5wTxTHZEgyCYyTVye/XDj3/yPxnHK6VfTlD3eQy35UB9t3/T3DwYiVnFHrcHIxNWTeMbTYJ2Lhl4mYR0LLLrglnkZCrg2JnRws1Ly8Jt/5Ohgdtqor7bW19789PrsU+vxyyrP71uWoZblQ2Nb4gaMslpbNCwwVzxElcmsbeThJ3s8pMVqaOLItzSiXYTnAyV7mQd01XhODMCt6VDfbeN3+y8OmxeG45Z98mvDses++RXw+bVYbP+1e0ebenprSOY1Hn/SngPzG7EbDIb9PU2Jy9NFOEmjnbzPRnqsoA5tHPch9sSo77bv3p595VB88qg2TtoXhkyrwxGrwxFewfN3qFo76C56ZWWYp+gL6LpNILKgRfqu123bW/3QNQqPQPRnoFo94Bpb27ctrvYJ+gL3AbZoL7ba+v3rd2yr3bLvrX1+2rrrX/fsirXbtm3rn5vsU/QF7gNskF9twGYmsBtANQEbgOgJnAbADWB2wCoCdwGQE3gNgBqIqvbK+7/wuR0nN6HxgX+3S/6x30BSA9p3G6r+eaRf/sHu2yZdzu92VbzzTwdB24DRZDG7SPP3B1qa7zW8fq1jtdP79nQuHw+vXnkmbvzdJySdBuAzJHG7bZffP1ax+uxG38In93x8cGXG5fPpzfbfvH1PB0HbgNFkMbtP6z4+rWO18Nnd4TP7vj4UIPltr35hxUebjvCw5LBCK6Vm4SQNEPI2Jbc+rwchbtAk7cDAC6kcfvdn955es+Gjw++/PGhhhPNNc/OfYDefPendwraUSuUqRpqZTQ3U5gbQsYNavCqz+4o7JuGI2FFsAMALuRwe8X9X9gy7/bG5fOt8uzcB6xi12yZdzv/zjln8uyICuRY5x9UJIg6YxMFcz6KXU/nu3B3AMCFHG4TQvY9+lX65tmzcx+gN/c9+lV+M+ndZoMMRTsA4EIat3ct/orHvbRdi78iaEdPW4OGM7iQloeKI/QJIaMjCz3qszyKM72ceM7JoTYQII3b2x/+sse9tO0Pf1nYMhUexo3v5ljHDyGjb8kZbI4Ypz7bo+BeGsgT0rj9xoIv0zfPGpfPpzffWCB2u5CkO5BmeJ2My2qQOdK4fezFsuYFf2+XLfNupzePvVhW7BMkhEyW2/haGsgCadx2MGnfJ8+NvLudmIBj0AYZI6vbAABv4DYAagK3AVATuA2AmsBtANQEbgOgJuq7fWD9N7il2OcFwOSivttv1X0zNnHLUc4fWFo0vfFNFFAQ1Hd770tlbrcvvr/qgo/erq+h5GvNFdwGBUF9t1vWfisau2WVE73hO5dsW2a819O+6eL7q84feHJX7bcE7SbNbQAKgvpuv/niPWPR+Fg0Pm7GbbfHzPi4GR8z49vX3CNoB7eB3KjvdlNN+eh4fHQ8PjKecnt0LD46Fh8djzfXlAvaebmdWjbKW3pJ75UIRaN7or9L7uyIma87lntjVSfICPXdfrW6PDIaj4xORG6m3I7cnIiMxj+7GX+1ukLQTuw2Z6GHY7V2SlSOjKnmIUOnF4E7klWofty7AeCH+m6//Py3h0cmwjcmhkdittvDNybCI7HwyMS2Vd8WtPMYt60hmnqWTTpNPidY7MVWu4bk5HF9dgPAB/Xd3vzcvQOfxQY+iw1EUm4PRGKDkdhAJLblufsE7Vxm8nII6Vhk16W4n9t0BBO1r9VZ6p1EsBsA3qjv9q+fue+T6+aJ3vBPmo/9pPmY5fYn4dgn181Pw+avnhG5zWaa0UFlIcNwZh05koxT2cXsyCsMNnTmpwV03b64F+0GgCfqu133y+/0DZknesMzqnZaYl8dMvuGzL5hs28otu6X3/FoS8+1HXGmzgkyZ9Ls5zbVJqDrAUdfvPk4uxsAXqjvdu3P7u8dMHsHzXfPXX333NXeQbN30OwZNHsHzN7B6Jqf31/oE8K8GhQE9d1+YcX93f3Ry/1md3+0O/FvtLs/erk/erk/WrOi0G7ja2mgMKjvdvXy7z739IxVy2esWj7jOerfVU/PWPX0jOrl3y3cqSD8DBQQ9d0GYGoCtwFQE7gNgJrAbQDUBG4DoCZwGwA1gdsAqImsbk/a74Gl960x/PA1KHmkcbut5ptH/u0f7LJl3u30ZlvNN/N0HLgNFEEat488c3eorfFax+vXOl4/vWdD4/L59OaRZ+7O03EK43YW3ynH19BBZkjjdtsvvn6t4/XYjT+Ez+74+ODLjcvn05ttv/h6no4Dt4EiSOP2H1Z8/VrH6+GzO8Jnd3x8qMFy2978wwoPtx1JZkFdCxiG7l65SQhhQs6cX/5m01VSLbn1Hkeh9meCXJg92TWj7iYA+CCN2+/+9M7TezZ8fPDljw81nGiueXbuA/Tmuz+9U9COylSgaqgF1A5X2JCzVOaCI32B0VJU730U6hiurDXOII1xG2SGHG6vuP8LW+bd3rh8vlWenfuAVeyaLfNu598550yeHS55WEdtOvqxN0X16R+Fn7XmimSD2yBD5HCbELLv0a/SN8+enfsAvbnv0a/ym0nhtnCaTUWywW2QIdK4vWvxVzzupe1a/BVBO3rOHDScwYVJ6xxR4Ex8uHtOTqcTetT7HMU97yd21honkg1ug8yQxu3tD3/Z417a9oe/LGyZuivFhgQnnuNZp3vfSgsYBtUHv977KMmTEv+0gPtuHtMEAD+kcfuNBV+mb541Lp9Pb76xQOx2IcF3WkDJII3bx14sa17w93bZMu92evPYi2XFPkFCCNwGJYQ0bjuYtO+T5wbcBiWDrG4DALyB2wCoCdwGQE3UdPvGjRtXrly5CDy5cuXKjRs3iv3/CkwWCrodDof7+vrGxsbi8VsoHmVsbKyvry8cDhf7/xiYFBR0+/KlSzEzFotNxIAPEzEzdvnSpWL/HwOTgoJuX7x4MR6Pm7GYVQ6s/wa32DtM5RKPxy9evFjs/2NgUlDW7WjUtMpbdd+MTdxylPMHlh5Y/w17HynL+Y33avduOJ9TJ3BbYdR0e2JiYjwatcrel8rcbl98f9WFA0sPrP+GvZur7F+i3bv+PFVzfsO99274SLi/T9n/qObk0f3ZdZU6H8cZZl4mJibgtqqo6XYsNjE2Nm6VlrXfisZuWeVEb/jOJduWGe/1tG+6+P6q8wee3FX7LXtPtuxfot27/hxVc279vfeuP8ffOf2yf4m25K2MW320/l5tyVs5HppTYjG4rSyquh27meTNF+8Zi8bHovFxM267PWbGx834mBnfvuaem3z2LdEq1p2jKs6tq2ArsmLfEm3JvoxbnVtXkU0zX2KxGNxWFTXdNs3YyMioVZpqykfH46Pj8ZHxlNujY/HRsfjoeLy5ptzeky37HtEq6s5QNWfWVVSsOzMyOjIyeqauIjmxfmRvav8EFXVnR0ZGR0bO1lVoj+zd94imacmGIyP7Hkk1ETV09J/agepndOTMugq7qzPrqAaJQzO9WQ2du42aJtxWFjXdjkajN5K8Wl0eGY1HRiciN1NuR25OREbjn92Mv1pdcYPP3sVaxUtnqIozL1VYFWdeqtAW7xXubD995qUKTePsSdfwGnL651RRdWdeWpzsY+/ixBFTHVPn49otGo3CbVVR1u1Ikpef//bwyET4xsTwSMx2e/jGRHgkFh6Z2Lbq2xE+exZrFS+dpipOv1SRqNizWNM0+lmrgqLipdORyOmXKrTFe9zdUnX8hq7+uV2xdadfsodkqzJ5/p67wW2FUdPtsbHxcPi6VTY/d+/AZ7GBz2IDkZTbA5HYYCQ2EIltee4+e0+2fFhbrlXuomp2VWrla0+xO2haee0p91OCHsLXw+HdlVrlLmGfzuaJ/rldnVpbbnV1am25ppXXfshUhq/vqtTKaz88VVtOPeXcbWxsHG6rippu37x5czjJr5+575Pr5one8E+aj/2k+Zjl9ifh2CfXzU/D5q+euW9YwMk15Zq2qCWx1bJI08rXnLSeWNOS2mVRS+JZalfrof0sTcsipo7XkNM/1dXJNeXWidAHT5wZe84n15SXL1pUnnyOt9vNmzfhtqoo6/ZQkrpffqdvyDzRG55RtdMS++qQ2Tdk9g2bfUOxdb/8zpCYlkWp2XL5mg5O/aKWRFXHmnJnXcea8tTzVFO2jtOQ039ir/I1HR1ryq1zSXWf6qJ80aJyxzmljsbZDW4rjJpuj46ODiSp/dn9vQNm76D57rmr75672jto9g6aPYNm74DZOxhd8/P7BySl/cV7tIU7c+tjdHQUbquKmm6PjIz0J3lhxf3d/dHL/WZ3f7Q78W+0uz96uT96uT9as+L+fjlpr7lHu6emPbdORkZG4LaqKOv2J598apXq5d997ukZq5bPWLV8xnPUv6uenrHq6RnVy79r7ylNefNhTdM07eE3c+4KbiuMgm5fvnw5EokMDg5+AjwZHByMRCKXL18u9v8xMCko6HY4HO67ciUSiQi+lAISRCKRvitXkM2gKgq6TQgJh8OXL10qRC6RzFy+dAliK4yabgMA4DYAagK3AVATuA2AmpSK2/qM0vixPgBUodBuH91QYRdCSM2sae5S4FMCQEkK6nbrU3fQm31nDtXMmjYx/vv+4/UbFz5oPYDbAOSFwrl9tLbC7G8w+xsiXUZ/Z13P4ZWfdR+vmTWt/3j9uT2r9Rll1gO4DUBeKJzb79WWmZF2ujw794GaWdM2LnxQn1FmlY0LH6yZNY137R0yApoeDOqalvyB66CeXAdp/+J1yAgk6/RgomFqt1Sl1ZnzcTqHSPOgABSfArpdXWb276fLrfFue06uzyjznJNbBtHGMnLpQdbY1G7Ub90H9UQPYrcdbwqpthkcFICSoHBuv11dZvY026W1arpHcbVmHaIH49QoatVSPtIy0p14jduitmkfFIDSoHBut1bdbXYZVmmtmm72NHBLf2ddWm4LbbKG36R3TrcDRigHt9M5KAClQeHc3v7UHWZXndlV11o13XrgLgKxiWvua0+vrY3ETNtw+uqak1sbISOQrA4ZAY3rNnOIoJEcotM4KAAlQeHcbqz8otm5srVqutm5mlvEYhOOOd73zfjT91St3Tqg6/xxmzkEPcinc1AAik/h3N700LTWqulm50pu8RQbAJAxBf3uSqP+NY9SyDMBQHlK5fvkAID8ArcBUBO4DYCawG0A1ARuA6AmcBsANYHbAKgJ3AZATeRwW9O0z/3N33gXTeO9Fuqr4wyphR/Sfg9c9NIAIIRI5PZ/W9riXeA2ADSquy1CVrflOltQTKRxOx0y6BFuA9WRxu0s92FcYJNTGLe5KzU56WjEq4lX4hrVcUZHpPsM2CtMtYARErw0BLkBC5nctgdn7ojt57YjWYFxm0phsPdy56UxnfKaeCauiXZjjujKY3P2SQnNvDQEuQEnMrmdzT50BAttqnBOntz0S1DiNPFJZRLsRh+RxZX/RPhuI8gN8JDJ7ZzG7ZJwOxXplPYR03MbQW7AhUxuZ7MPf04eMgLsnJx5wr1/0DBC1GdOoiacxDVOWltaR0zmsaXjNoLcAA+Z3M7tepu932Sw47bOu7HlyEtj3eY1cVskvpfmc0Tu7yRQuzjupSHIDbiQye1s9pmUQSvHTjGQgkIgjduOr5dycTecnO9uwW0gAXK4nQ2JKelkSAS3gQSo6zYAUxu4DYCawG0A1ARuA6AmcBsANYHbAKgJ3AZATeRwW8s6L40E9Tx+llyyMUYle2KgeEjjdraZSjm77VxXUpIKleyJgeIBt70JGYFAoES9wffbgBfSuJ0OvKY5uW0tufZaH11M4DbwQhq3s92Hdpu74pKup9d+psIUPHMTkZ0GShSZ3LYHZ+6I7ee2KL3MK7PBGUcmcBvZaaAEkcntrPZJui1KLxNkLTkyHfzGbfcmstNAkZHJ7ZzGbVF6Gd9tag5Lz6Pz6Tay08DkIpPbWe0jnpNTl8G8OTnThXPcRnYaKHlkcju3620ivJeWGqTZe2lUF95uIzsNlCAyuZ37Pv54f97lPyfPFAykYLKQxu3s8tLSIGQEBHezebu6nobboESRw+3JhZrECsUWpq/BbVCiwG0A1ARuA6AmcBsANYHbAKgJ3AZATeA2AGoijdttwTpuKfZ5AVCiSOP2e++sj03ccpTzB5ZOgt7ZfuZc0GCjxIfyujGpB81r2hwoLNK4fejARrfbF99fdSH/ekvgduoUJ/egcFtipHH7nf2bzNgtq0RjcTN2Kxq71dO+6eL7q84feDK4/9f5O1RGbhfni2WFinmC2xIjjdv7WzePmfExM37X7GXLXnhlLHpr2Quv3DV72Zh5a9y8dWDf5vwdCm7Tx4HbsiKN23t2bRsdj4+OT6xt2HPX7GUj4/G7Zi9b27BndDw+Oh5v3bNV0C6oawEjmPjGOB1pYieZuJZVizPMnMsnqWWb7ELLNPLJ3Klm3EWgQd1aeUrtSe2nB/lJaZzFqvRK8eQib+//OARuS400bm/f+UrkZjxyMx65OWFZfdfsZZGbE1ZNS0uDoB2VRmj94TpiDqgRMPmHLI5A05O2sIFnzoAE/7HcveDMK87NfWnNi3lKO2SCzaXw+o8Dt2VGGreb/vPV8MiEVSyx1zbsCY/ErJo33vwPQTt69sp9TD/wizfhDMjC8BPWLWpEdQc5EXcNNyTJTmLiuS0IfnP916BPLJ3/OHBbVqRx+zfNzYORmFXscXswMmHVNL7RJGjn++ebMIbrKLPJD0EVt/PIJ0vLbcdbD4HbICOkcXvra29+ej326fWYZfWn103LcKuyofENQTt/t0nICAR0PUArxMswY1t4z8n98sno+XPQSEaRCuLc0nNbNCd3zeS5U3u4rR7SuG38ZufVYfPacMy6T351OGbdJ78aNq8Om/Wvbhe0S8Ntp1heEWiJibWuO2+bsUO/fz5ZqjPvOLf03RYEvyVVpl6j/dYEt1VGGrd/9fLuK4PmlUGzd9C8MmReGYxeGYr2Dpq9Q9HeQXPTKy25dF6oj5QKiIIvCWSGNG7XbdvbPRC1Ss9AtGcg2j1g2psbt+3OvmtFco0yCH4DUwFp3F5bv2/tln21W/atrd9XW2/9+5ZVuXbLvnX1e7Prlv7oR3rSCX4DUwZp3AYAZATcBkBN4DYAagK3AVATuA2AmsBtANQEbgOgJqXitj6jLIO90/nSFb6YBaY2hXb76IYKuxBCamZNcxf/XuA2AH4U1O3Wp+6gN/vOHKqZNW1i/Pf9x+s3LnzQepCh2+Lvi8JtMLUpnNtHayvM/gazvyHSZfR31vUcXvlZ9/GaWdP6j9ef27Nan1FmPYDbAOSFwrn9Xm2ZGWmny7NzH6iZNW3jwgf1GWVW2bjwwZpZ0wTX3vQSSM1etsh+f9q9DwBTlAK6XV1m9u+ny63xbntOrs8o85yT08EDzqXI7mQzgpVQYMpTOLffri4ze5rt0lo13aM4GwsDg9g8BP9QIQCmCoVzu7XqbrPLsEpr1XSzp4Fb+jvr4DYAuVM4t7c/dYfZVWd21bVWTbceuAtfbELEAb2iOTk/xBeAqUPh3G6s/KLZubK1arrZuZpbxGITQtisfipYPxVXJt4HgClI4dze9NC01qrpZudKbvERGwCQIQX97kqj/jWPUsgzAUB5SuX75ACA/AK3AVATuA2AmsBtANQEbgOgJnAbADWB2wCoiTRurxZQ7PMCoESRyW3S3eSurKyszPehsv3tP+qHrUuDxPdxdSPbE0N2lcxI5Ta3srsp33oXxm37u++T9UODqZeR9ZsO3JYZ+dzWtNVWqW5qs8Zti/wdKiO3s3sjSP2eLhMokVfyIB2yq2RGSrerm9ra2tqsB4SQ7u422dymmDQ34PYUR0q329raCCHVTW2atpr4uB3UtYARTPwwtR5MzYUDRsg5W038mVp/x6n1oqm/aeoHrkBP60EAABKKSURBVPUgYeLZAkaI+vt37ijGUw16zWrIUcPmRwUMg35d9H56kBHTfka0DBa5dIowFdxm/95Tl6BJPSlv9CBJiulOfAgZevKPmK5khLY78BvLQ9TbjfjMWWvYmtQ5BHXmdaX8cw26vvEVyKVTh6ngdoAy0v2YfuDS1bXpGpB5bifeRRwJT/wxjnKD3cc9oDtreO9PJGQExG77xk4hu0oh4HbCBq6jzCY/ykncLvE+kO2N5rTcdrw9EbgNbKR0O5N7af5uk5ARCOh6gNbDMXN1ikHtwZ+TG1Rrzqw7dZvc4/MpeuobNBJDufvuAMnAbdGcPHUSyKVTByndtj8Ds2pyddspTcgIaLruvpWWmo8HdN1524wd+nk34hjSutmW2sl9J8x1Ly0tt5kXkbqXRr/BIJdOFeRz203un4FN0XnlFH3ZUwWZ3D4sJie3c/6IWh6oiwHc4VYdmdyu9CS7bunPxaYE1MUAxFYbadwGAGQE3AZATeA2AGoCtwFQE7gNgJrAbQDURBq3kZcGQEbI5Dby0koLJC6VNlK5za1EXlqxgNuljXxuIy+tVEDiUmkjpdvISysJ4HZpI6XbUyMvzfvMRYcRnbz4RXFS2aideTkxKZCmVsJMBbclzkvzOnPx+fBPnl/vWPvN+y/AnhLS1GRhKrgtZ15aeqkSXufDbArq2SFWo6YznDcdJC5JBdwu1bw03zP3PR9mU+w25+BwWwWkdHvK5KV5nrn4fDgnL6x3TKF5bxBIU5MTKd2eGnlpvmfOPR+vk+fVe9yQo3dAmpp8yOe2G+SlUYju402h4ChgIZPbyEtLA7gNEsjkNvLS0gBugwTSuA0AyAi4DYCawG0A1ARuA6AmcBsANYHbAKgJ3AZATUrC7UjXwZ7m2yJdB4t9IsUj9b3OYnwQPdjS8vzSU4Ou+gvrt9a3XCeEkL5T9bMOXSjsWYHcKAm3e5pvi7Tf2dN8m89+7MIj3up/tp7viO93vQuAS+BiuH1p96ytz8/auvt4Tm5fWL/1ec5T148s3fr8LLq0HOljdzl+KPEU79CC/rndJl5I4lRBgpJwu3P1bT3Nt/kP3YIQH2rlka8YjlVK6UuUX+U8eiuo2z5DsY/bfafqZ22tX3/Id0gfbGl5fv0lV9uE7RfWb3U+m17/dLepUwUJCue29vjBilX7pq/+3Z0vHvq7Dcdu23Tyc1s/0h4/SOw5+eE7exo8h25RQJedquArhrVWO5vTh9uinf2n69ePLN26+zhTxdju3YPwWaZbuO2icG5/YdYqbrGe7Vx9W+Twl7qMLNymlyBmNG67mzuCD+yZu1ckGLX60S/ejD2oa05Or532DDxzLvHk7qPrvNdFk3KbMc2eKtMTXUqwwZYWayafwNft44fcs+4L62nbL+12z9htRP2z3cJtFwWdk//j1sWiYk3LuwzPaTn/epv+m2Wvt70ut9ksQEdkGuctwhE/4M4Y8403E/XmqEgv8CzNsDRnFBwDz+3jh6iL20u7XW5fWO+6PPZzm2edYyTPxm1Ht3DbRUHd/tzq2SsPrnKXz62eHek62Fl3W//BL3XViYdu3rjNDsTpTmgT7wHOHCBbAXfgGTd4gX53SSsEQnieGYciUa9C+Ebifl0MHLeFwvSdqp91aDf3wjirGXWu47arEm67KLTbokII6Vx9W//BL3WuFrotiCZzhvikfbHKjHdsbkqqN819+5qf5FBYt9MKSxO9rgSZur21finvdrqn25y7aI6e/XrgPuvuFm67KJzbR6pmehdrWt65UjQtF15XU0+kcS+NuQUniEzjBJ6J3k3sjLF8ui0KPBOdu/ACwBkFx+A3J7d8Zufkgy0tzk+8WPfYj9OcA3LqWaqVj5YctznjPNx2UTi333/ynouvrxCV95+8J9J1sH3lbf37/659pXPodl0jcwY3+0KZ+8E3uyvnetyRpM2/l+V1Hytjt5nTdIy9osAzXsqZMyyNfWvzSAjn30u7sH6r/bHzEe59cutm2/pLlvzUjbek/Em33R+bO5+1GnI/AEsc1Nk/t1sCtzkUzu3g/DvOr/9nq3zEPvho/T8H599BCBG5XYjTUycyjcHjdQnuk8sJ3HZROLf3z/m8VX475/P7ZyfLnM/vn52oIYS0r7zNKgU7qwSqJg55vi77e2nXjywtATHYz95433UTge+lcSmJ76UVF+Ui0xKk9boSM3DJB23AA24DoCZwGwA1gdsAqAncBkBN4DYAagK3AVATuA2AmpSE2+rnpU1GZBK78BwAByXhduZ5afmCm6+WTuiad+xaQeLQ4DbwpCTczjwvLV9wTUtDP58zKYnIJDDFkTQvLV9k57Zv6hrcBsVH0rw09ypLZobKToE95tZZuR0yAgHDSE7JixSH5ohccOe3+b10oDrS5qW508I4iUvcUDEabr6aX+haUGf3zTx6IS9xaEyulCu/DfODKY+keWmEcMYlOqPUkT6U9k0vYaXwNHgXCgWJQ2NTGGmS+W2CWQWYGsiZl8ZPC0tolroaFuzG7dKvkn1+st1OJw6NdluoMB35BqYWcual8dPCXPFgot3YPrO6l0aLV6Q4NGZO7spv40S+gamFxHlpiflnKi2MuBQW7UbcO1D3ofxD1/x+VKwgcWj0Fu/CoxR+9wwUEeSlAaAmyEsDQE1K4ntpAIC8A7cBUBO4DYCawG0A1ARuA6AmcBsANYHbAKgJ3AZATUrC7cnMSyuZb1MjVgkUlpJw2zcvzbH42vEn7fkXnr5IguUkWYLINFBkSsJt/7w0Zhmjc92iZ9RS2iKFjEAgkL8xHrFKoMhIkpfGDFBBXdN1nVnYKR670hXJ6iWo58s6uA2KjCx5aWwCgx4UBBa4Y8NE+WTu/pNpJewEwSfbzHOZJyLTQBGRJi+NThlJ5IFZf8KpoZYXGybMJ2NJNXXnLfplm4mT2BCZBoqIPHlpCZltpxMPGCtZOOFpgr932gxH5Eka2WbphbcgMg0UFony0pJzcSoxybnN+TNOx0OXGZlJODluIzIN5IZEeWmJe2jM/XHntis2TJhPxvbLVNrbXtlmPn0iMg0UGzny0hLQweC8beHNJ04+GdsrW52s8cw28+wTkWmg6CAvzQPRcIdhEEgA8tI8gNtAYkrie2mlCtwGEgO3AVATuA2AmsBtANQEbgOgJnAbADWB2wCoCdwGQE1Kwu3JzEsjhCB7CExFSsJt37y0BPxV1oSQdMJX0nObXn0FgMyUhNv+eWkWWbvN7OfxlbJEZhrcBgogSV6axSS7bUemwW2gALLkpRFC0nQ7qGsBw9CZ5LCE0VQGg1tfbmIaANIiTV4aIem7TQcZOIKV/Jd/wG2gBvLkpZFMxu0QW+vnNl0Lt4EaSJSXRhvoUlQYVJqO22xGCoJKgBJIlJfGfJDFppQF9dQVdDbjNg3GbaAGcuSlJW6CuVPNOLfGvN1OjtFifeE2UAPkpQGgJshLA0BNSuJ7aQCAvAO3AVATuA2AmsBtANQEbgOgJnAbADWB2wCoCdwGQE2Udxu/3QWmKIV2++iGCruk38rxE9mO+DPPNDSvBdvc76MDoAYFdbv1qTs8Nr1gFnBYWqa2PVd3pPVbnI73jkzAvACUKIVz+2hthdnfYPY3RLqM/s66nsMru/YvP1pbQRdhY2ZoDuqaruu2Uf4Rp/6/sxvU4TZQjMK5/V5tmRlp9yjv1ZaJW1MKBXVNDwpWZKfWfSZ1t55O1VPvCMxjdpUoN6LBXe8ZwAZAUSmg29VlZv9+j9JY+SWP5raLiSHWHq1TQ65j5bZVbU3gqcAk6i2B5yUd80DvL6rHuA1KlMK5/XZ1mdnTbJfWqukehdM+IbPtdOIBE6bE4oxlSPSScj5lLT3wMyNwcjdRPdwGpUrh3G6tutvsMqzSWjXd7Gnglv7OOr7b9lycCk9ybnMmxv5uM3ZzHOYmG9NvMXAblCKFc3v7U3eYXXVmV11r1XTrgbuIxSYkeQ+NmRg7t+kBmJp70xfWvLk0dcHtmnv71MNtUKIUzu3Gyi+anStbq6abnau5xVtsQpjoce42fRHN3DPTXbfSeOM5NXaneS+NOibupYESo3Bub3poWmvVdLNzJbf4iw0AyISCfnelUf+aRynkmQCgPMp/nxyAKQrcBkBN4DYAagK3AVATuA2AmsBtANQEbgOgJnAbADWB2wCoiTRuZxe05g5gShLUU9VsdlpyTacTx1fIxQtE7O6oBeTsCbBLTRyrUgHIC3K4nX3QmrXEK+BMXWIXeHis5eKFLYWMQCDgvfqLWhKaXKziCIDAMjIwyUjgdk5Ba5Y8hsOgkBEIGEY6gnHctpZueyesOd0OsrFNcBtMPhK4nZegNSZbwdpISzC3wqK0Bmcz1m3XKlK4DSYZGdzOKWiNCkVypDKILnoZ1VxuM2kNQrk5btN2Cw6Ny22QRyRwO7egNSZEiQlYy2rcpoWmHtu33tzeOwNV2VkExm0wWUjgdm5Ba2z4MX2VnY3b7tvn/HYCt5N263AbTDoSuJ1b0Joz85DJM87Ubefvjwh/j0Todga36AHICQnczi1ozZV5yIkrdny+7fi0ivn1EffVN/czMsfn2+wuISMAt8GkI4HbCFoDIAskcJsgaA2AzJHDbQBApsBtANQEbgOgJnAbADWB2wCoCdwGQE3gNgBqArcBUBO4DYCaSON2dnlpju97s+kn9iYnL4041nwJllYjGg2ULHK4nX1eGhOg4HQv+SR/wYZjqbbHSjFEo4ESRAK3c8pLY0bqoK7puk4nJVhP+bvtvQoU0WigBJHA7bzkpRGSWK/JRhw5H9F4rMH22Q3RaKAEkMHtnPLSUkollmLbo3VqaTY/Ly2d622CaDRQqkjgdm55abbM9AycyU1LZ05OXXAjGg3IgQRu55aXRlJzcSq4kNlOx21xqimi0UBpIoHbueWlEZK8h8YMwsx2RuO2x26IRgMlhARu55aXRghJzKMdmYbOEdZ1LcxmmvKtRDQaKFkkcBt5aQBkgQRuE+SlAZA5crgNAMgUuA2AmsBtANQEbgOgJnAbADWB2wCoCdwGQE3gNgBqArdFJJeApqIW8KVRIBPqu51d0BrcBrKjuNvZB61R0Q1J4DaQCZXdziloDW4DyVHZ7dyC1ug5OR2rllr6Cc9BKaO02zkFrfHdZuPUYDcoXVR2O7egNdG4be+AKTooaVR2O7egNbgN5EZlt3MLWhPMyZ05pgCUKCq7nVvQmmDc1nErDciBym4jaA1MZVR2myBoDUxhFHcbgCkL3AZATeA2AGoCtwFQE7gNgJrAbQDURH23L53e+b93fvAvOzq+v7P9oZaO7+86dfns7mKfFACTjuJuz205OWfHqRO/30LIX88NHj/Q0V5/6oO5tS3/t2FXsU8NgMlFZbf/eUf7bz842Xmy5frQh4QQQv6y9tiJPw93/PD0qf+1bv+K/3gnr0ebjKUj7nwIANJFWbff+aD9wTdOEPLX8ImW1dWPDw6cGfzjTkLI74Y/+Nczp763s/uOF989eMDI3wHhNigtlHX7X3a0fzR4ghAy0H/q7T2P7mj/9cnjG0eGzn5v5955rZ0/NjrnL3+rof7p/B0QboPSQlm3f7Cz48LQiQ8+PUEI+ax9/9qTT+8+uXw8cvE3e34+76lZP64/v+Dnv332Fyvyd0C4DUoLZd3+15aOLSc7PhrsiIxfu9Zz7JNw+yfhjtCV9/uvtp+/ePxk6NOTnf/VceyEqHlQTwQXM+FJqdpUalpyN580NXq9d7LHoK4FjKARsPdPtqYODbdBlijr9g9bTv5gR8fWkycvDV9b8tN1D+tr5i+pnr/4+fmPVC94tGbB43XzHjcWPFpjF0fz1Cgc1AOBgCVbUm1K/NSO/mlqiWaONwi7a7s1fWy4DbJFWbff/fCDh1o+mHf6ZEf46iPL1nYRYpXzhJwh5DQhZwk5nyxut23BgnrACAX1gBEiISOQVJslYITSS1yyWtrvC/R7BPcx3AbZo6zbF07tmtvy4Y/2nDp55erin9ReJETT/rumfX737/4YJeQmIaOEWGbObzjIcTthMmV10HAM36794TYoIZR1mxDy9p51P2g909F1bfFPam0VNe1vo4TcIOQzQjRNI4RomvbDx//d3TxkBAKB1ITbnpk7JtxB3TNNLfWTQwllXRXJbuA2yCsqu00IeeetDSc+/GTx0jV/JkTT/lbT/qem/Y8YIWOE3KTcXvBEHacxbStlpP0Ue89MkKaWbBjU7QHb7hdug0lEcbcJISOf/Vflky/+KbmpadP+mnqccPvhJ2uLcm4ATB6aCQBQEe0yj0tJent7jx49un379vr6+vr6+q0U7hogF/Us27dvP3r0aC9Qhf8PGeD+WlKYZJ0AAAAASUVORK5CYII=" alt="" />