一、搭建Hibernate开发环境，这里就不说了，直接说环境搭好后的事情。
二、项目的目录结构
aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAO8AAACxCAIAAACjln1pAAAbS0lEQVR4nO2d73PTVrrHz3/B9BWz9Jabwmx3CSQNKs3w5rad+wbuzmSbLDBkk6zuvWU7TbptKT+6kJCEEEJXFyjQAiGwDQSS0gCLaBbYADsBst1CEygJ0YZgyC87tuP8sC3HNue+kCwdSUeynTi2ZZ/vPMNIR+c55wh/fHSk6PED4Lwpo+jQ/DVORKQVmItz1zdbJNMeTV6aOYYCFMMlehhEsdbsaf6xZYty91NVhdSlmaWBKJo1KOQYCq2AKSCKraKm+YvyPV+U7/mivGbGWj9jrfcMHLJ37X1+87PHF8u+KK+BEK7541mhZvLSHLVQDFlawauwiS0kNMdbeJrb29tramqwh/Zs21f1f3fhxC28IRCnJs0cQ2mndWwhoTnuwtB8/fr1pUuXLl68WM/nw7IDcOwS3iBsvtWTUXQoo+jQib92aX05hgKoaBZClgYUw4oHxAIAABBWA8plAUsDiuFELvQu7iwdckYXADpLALkCAiRayMgtUAynmIYhWl9TSGiOt9Q0Cyjn5+cb0Fz831/Coa91LUKJXEIRHWFboEh1oZZrQpYWioQvhfbiryyHLA2U3wTZW1ohSMfR/lTLaiWGIupKLjGF6m8uxosoplLQLKFcUFBgQDOE0NZ5wtKYZ+s8ASEsLKkvLDku2MaS44W/O75R2P7d8cKS43h/9ewowYPdRjewS1JpV4OdgsrQUQW3ComTr3rZgJlURVSVpcpCMjfHWzLNKMphabY05sHAA0tjHoTwgiWoZ/+1/s84bxUvYWkW16XK1evsaJYWL+pZX3d0mO7QqgarDkJzvCXTXFNTsxhRdXW1no/tRh3fu3NtBuB7d9pu7IMQnn3kO/uIP/vIhxj/H3lNOG/tRxqeZsgxFEXTlGJVoFgG4+dszUpD2FGsNNBrhLaQZRT4I08s0BaxhYTmuGs2z5stjXkSzcL0XH97sr5jsv725PGOyfrbk/W3J1eubcH6qq/t0l2gMc1qMDmGAjStfeyL/aoY3gUii1vZUS5ErgXobSm2Y8ObTfzoiGKqqGm2XPrUcaOQ793ZfTyX793paC98dunT/ax9/+Wx/ezY/sv2/ezYL/6zNeYDVV7/58YFoSpFFT3NjXnBJxWOWx+tzQCOWx8F+yssjXkZb11CLfbDVPM3Jx7JH7ZTVVHTfLvqtRfPD7l6mcsHf+XqZeCzQ7erXpuPkUlCn9qFNFuasQ/XiFJFUdM8dKfhdtVrqA3daZiPkRERRas5vUNHRJRUIjQTpY4IzUSpI0IzUeqI0EyUOiI0E6WOkohmOjcz0UMgMrcSQPPf92ZLBiGsePslrcV/VEQpoHjT/M3v/w3dfX6/reLtl2Y8fx29fbBuw1vCBqGZaHaKMc0GAYUQwr9XZfOjR/jRI65eZvTHmqc3Ph0fuF3x9kujtw92N++kczOFDUIz0ewUS5rDBhReq8rkXXdR27JmdcXbL9VteIvOzRSsbsNbFW+/hF1Da17eNIoCJK8VpaFiRnMkAYXXdmTyo62oBTwD0kqDzs00WmnoRjPpRAESpZ9iQ/PsAgq/+fAXBqZxFeZdFFfjuCmitFMMaJ51QCH/9AjWRn+swdEsSJiPcaFKhOa0VwxonktAId9bozJdlDmGUUcoYaIAlfF8ROmluD6h0wYU8j/uRM1wVtb+0hs28I78bEX6Kn40YwMK+R9lM0aZiCis4kgzLqCwnv531OI2GKKUVPxojn9AIVG6KX40k4BCovlWEr1DR0Q0RxGaiVJHhGai1BGhmSh1RGgmSh0RmolSRyamuWzVgnlpF/+jixG/0zRPv9k4T+9UpdYvTJqJ5vaKZTe3/lyyA3kL0d32imWx6YbQbFqZieabm5dy7fVDnSeHOk/ea95bX5qP7t7cvDTWHarSBCb0U090/6ZQstBsHFAo1vl4yVDnSd/EVUfX6Z7vDteX5qO77R8vifWgCM0mU1LQHDagUNDVsiVDnScdXacdXad72o4INEu7V8sMaFbFC7I0kgdQJ2UPq0kTiKQO1KRbk9tRpW/TzYMo9WXwDqsyr4YybYbGb1bdqUar939iEiWe5kgCCgVdeT/jXvPenu8O97QdudNQsWXNanT3yvsZOn7aeEGWVkTK6iUHVCck1rjg0g0qUwQZ5UGEHEMjOV7UPKsyDCkieTFJEGfXnWq0ev8nJlGCaY48oLBs1YIDeQvrS/MF27JmtWBSyYG8hfinHJhrtIrCCGnWuGDTDeJTa+pmJ9KdnfXS0OklQZxdd7qJQAnNUSqqgEII4fniV9Dbvi1rVqO754tfwbvNK83YnNsR0swxFGZ9ojNsI5q1ByLujtAcK0UeUCjobOHLBneBZwtf1vHTxgviPjnp8ho5zdh0g5HTrMyHiEyW2sZREnWSIM6+O0JzItS4fpHBXWDj+kW6nup4wQhpRtME6nzYYe+rjC79sjNF05SaZuUdJqNOnoi/C5xNd4TmROhUwSL0tq++NB/dPVWgTzNReshMNHfsymwo+JlkB/IWorsdu8gP5qa7zESzSvP1ngaRaWVimomIVCI0E6WOCM1EqSNCM1HqiNBMlDoiNBOljtKC5ou1v8RaosdFFGOlBc3f1izzzQRU9vDi/yYp0KZ9ITPhSguaW3Znamnuu779J0Ogpdca4v1b0ITm2cqsNHd0dExPT0dYual6udcXEOyOxZFRdGgTc+3p3T/1Xd/+8OL/nK1arudIwpfMJbPSfPr06aamJrvdHknlr3etcHv9bq/fw/slmt2838P73by/sXKFniOh2VwyMc02m+3o0aODg4NhK5+oyJry+Kc8/kmPTPOU2z/l9k95/A0VWXqOCM2zDvKT3t7UfatTJzAR26ZiFSLvhIkvTBeZmGYIod1uZximr6/PuPKxHVmuKb9rasY1LdPsmp5xTfnHp/3HdmTrOSppnkWQn8Eb95qAQknGbcquSACJUXxhGsncNEMIR0ZGysvLnU6nQeXDn71un5xxTMzYJ30SzfaJGcekzzE5c2j763qO6rk52qg7g2gobUChJCXemmkXjYwyqJaOMjfNDocjkrl5/7Yc67jPOu6zumSarS6fzeWzunwHtq3Uc4yCZmzUXaSxfUopgvYwgYOCtxwfYhxfmE4yMc1jY2MRrps/37xy2MnfsTjea+h4r6FDoHnY4Rt28iMOft/mWNCMjbozjO3DBRQqJ118m0KgE01TmKEpqqWfTExz5M80aj554/kYf8fiyP3wjIDy4Bj/fIx/buefj/n2fPIG1kv5vHlWUXfKYsVdID6gEBNmi2lTDa1etbSTWWmO6nlz1R9WWay8xcZf6R680j1osfEWG//UxlusvMXmrfxo1bwOVVaED/zSe7UwF5mV5qhUXrZqYNT7ZJQfGPUOiP96B0a9T0a9T0a9FWXzRzPHULifKwrnQ55yz05pQfOO0je3fZC7vTR3e2nuNuTf7R/kbv8gd0fpm/PYN7KiCI+o+KyDTMyzVFrQTJQmIjQTpY4IzUSpo9SkOfgCPrYGb/0r0NZDLNnt1r8Cj63B4IsYfO6pSfPD4WDPaHDa9yL4AhJLcpv2vegZDT4cDs79c09Nmq89DswEYCBIzBw2E4DXHgfm/rmnJs1tPYHgC+gPitbO1mBNqkAssRZ8Adt6CM06ausJBJD/rGuXa7FxgeGA5vatBCWX5/OD7GNWAmpfX5zpYUswnc7/yeJHQl8KwkCQ0Kyvtp6APwh9AdHaLtbpxQW2szVSNY1xdStBySW9o7GwXiYHUHW989kFxtgSTKfzf7L4kdAXAtBPaDaQSLNftMutf+J9AcG8Pj/vC3h9ASkukG39XKqptNAHjD9qXmNLAFXXkwwny5YA+oKf0Gyotp7ATBB6/aK1frPfzfvdvP/VdzZtKv/S7Q1sKv/y1Xc2ufmAhw9cPL9fqqk0bu9KUHwJe8jUxhYDam9PMpwsWwzoVj+cITQbqK0n4AtAzwxcu27j5bObJas+0vzqO5smPf5X39lUfaRZCBb8pvkLzwzEGVe7EhRdZItCL1oUXQwdesTkaAof7JPf8WwVW5B9c/ZxmC4eMTliZbYIULUXxWaLLkLPRVrtiOsU6YKq3UeDlcyD8F2zRUJlQSWs4clGMDD59MUTby0Rmg3ryxYBunUG+gKEZn219QR4P3T74Np1G1VAS0y7pmdc037X9ExT0xG3D+KMq80BANDfCrsX6NA2V1vCdKsKHzE5Uk3R2CJA1T6Smyq6oOlC9mKLAAA5TLfYJgAlrLICrlMfWwSkZrnanFALYbpmixTtCzX1TjbswGT7tgTk1HHuCzQyDGNftgjQ3/og7yc060ugWUB57bqNJ/58DKVZmJiFoEDH5Mypr49O+yDOuD05oOgCfre7Tp6Jz/vgtPDJAWrPo1D9C+rgv+w6Tt3FIyZbdpd89bY1nYa4kXsUdsN0jbbJ7ckRtvVONqKBIS2j/wlhfdkiQJ8nNBurrSfgRWj+qqHB5vIJtnbdRmFutrlmhJL6UyemeIgzbk8O+O0Fze5PTDYA2XXcFC9s0+eVLgBQe36CUxdokMN04VsOmezO/lbw0tvGdqrqQtoN0zXaPrcnR9jWOdmwA1O3HDr9SE6KZ38L6PM89BKaDdTWExAWzYJ9cfzrEadvxOmrPtIslAjTs1B4pP7UhBfijNudA0AxK+ze30sBQLd44UQrDXKY+6rCh8zuVtmrsBVOeNlCIGzACS9sKaZbtF08ZLIFdy9bCKjdD4Vy3Da2U0UX3O4cEKqD6/ohky02i7bP7c4RtnVONuzA5GZhSzHI3svd30shwzD09bKFgG7xQs8MoVlfbT0B9wx0eeHadRtdXsh8dWbQzg/Zfa++s0mgWXimMejgB+38wWONLi/EGbc7BxQWS1dtuhkpF6/gxXR2qLy5OFSxmBVbeMhkh8oKW3FdPGRC7uIH7NLdxneKdEHt3kuDHOaeXtch7JTtizTrn2y4gYWabS4God7FL0YEJ8UWArrZC92EZgO19QTcPjjuEafnfYfPPbPxz2y8NFuvXbfRYuMtY16Ljf/Tl03jHpgK1kqDHOZewocRvbl9hGZ9tfUEpn3Q6YFOD1Q90JBoHrB6B6zep1Zv3aFzQs35N3aj8uZsY+scG+Sqc+hzSONZtVy8ziWWNk1oNlBbT2DKBx1u0bRAVx38tvrg+eoD56sPnN9zsEWqaT7rZrJC342sWi7x45mVTRGaDdTeFxj3QKcHD3TCPzxiqAmLjfY+QrOOHo0EfxoJThg/HSOWHDbBw59Ggj+NkLf1dRQIwgfDwWuPEx8mRCysXXsceDAcDMQA5uSmORB8cb3bcfCKpbKln1jkdvCK5Xq3IxCMRaidqZTUNP/ln7bL9+yDTv8kD4lFboNO/+V79r/805boDzDeSmqaa1ufONxBhwfa3cSiMIcHOtzB2tYnif4A462kprmypX+Ch2PTxKK2CR5WtvQn+gOMt5KdZpcXWqfwVrZqgd6hOVkXswJQu7pU5ewGTGHk7vE2l5fQnGSqbOkf98LRSdHaK5bd3PpzyQ7kLUR32yuWSTXnZPeZFYCquK8qZzdgCiN3j7eNE5qTTZUt/U4PHJ4U7ebmpVx7/VDnyaHOk/ea99aX5qO7NzcvlWrGyLjybLC+Rdhm1wOq/H5s24+896hdnB5Cc+LU3t5eU1OjKqxs6Xe44aBLtPaPlwx1nvRNXHV0ne757nB9aT662/7xEqlmjIzbmQ3WNQvb7DpA7bwX2/Yj7z1qF4eb0JwgXb9+fenSpYsXL1aVV7b0j01Dy7hoV8uWDHWedHSddnSd7mk7ItAs7V4tWyLV1Bj7m9DLDMurOcs4+xtA7aimkRKk8j1mOaAbEBeQxdxUuoBCVqdlyR2KvZxjlgMAAPjNOWg5p+nxnnhUrIAbMMhibmI7Goc3q+VQFNWAO6cJzYmQgHJ+fj6WZusUHHCKduX9jHvNe3u+O9zTduROQ8WWNavR3SvvZ0g1lcYWAJBZzalKwEZ2wAkHfmAyAfXHH5D6PzCZgD7hhANO7o9ZoOCcgQtbIPuGKsvubAEAIIu54YQDAseye6j9jcwNodNzNBALJVP1btARxsU6RWiOuySUCwoKsDSPTsF+O4QQ2jpPWBrzbJ0nIIT1pflb1qwWrL40X7ADeQvLVi3ot0O1NdEgi/mbopAtANRn/xC2uc+ypG3Yb4f9/2AyAX1cPAQKmvRdmtThd5mVHOKOuuhtw79VyvPrccUgkd6xHdnZAgAAQAcvu4wSmuMsFGU9mocnYN8YhBBaGvNg4IGlMQ9CKNz2bVmzGr0LPF/8St8YxFgTDbKYq4pC9l1AbesUtrltWdI27BuDfZ3MMkAfEw+Bd5v0XTAto+6oC267k1kGwLJKTuklGdI7tiOkGhAbl12GJwjN8VVNTc1iRNXV1aoKlS39gy4IIbTdqON7d67NAHzvTtuNfRBC7V3g2cKXe60QZ+y7ALx7RtzeuovrtbLvAmrrXaGE27qC2noX9t5llgFpg/5KPCQ7YlwULcOvNtBfWVF31AW3fYYGK5g2K+y1wrZdFACSu1BT1Tumo61npPEIR2WXQRehOclU2dL/3AUhhJbGPIlmYXrW3gU2rl/0yArxdpdZFrqaf2mFj6zsrwG15a5wlNuygtpyV6gjbQjV4He7KAAAWMF8h3VRtAx+fUYq0faC3ea2rBB9l22gRS9pGIrecR1Z4ZcbQkUb2EfKAf+d0Jxsqmzpf+aElkufOm4U8r07u4/n8r07He2Fzy59eqehor40H70LPFWw6OEIJCbYMyehOclU2dL/1AktjXnBJxWOWx+tzQCOWx8F+yssjXkNBT87kLewoeBnknXsyuwehsQEe0poTjZVtvQPOOHtqtdePD/k6mUuH/yVq5eBzw7drnqtaxiWrVrQNQyJYW2A0Jxs+vzS097RwNCdhttVr6E2dKfhxyFITM8eDMPe0cDnl54m+gOMt5Ka5iv3xlq/d3C2oM6fRYjhjbMFW793XP6BvK2fTPL5g5e+t9W2Pkl4bJK5rLb1yaXvbT5/LELtTKWkppmIKCoRmolSR4RmotRRWtB8sfaXWEv0uIhirLSg+duaZdh8gSkONMdQgGK4RA8jjkoLmlt2Z+rlCzQAmmPEdzVpNh6DZNVvfc65Y0KzWdTR0TE9PR1h5abq5V5fQLA7FkdG0aFNzDUpX+DZquV6jiwdfxxYejYUcwwVp29dMsusNJ8+fbqpqclut0dS+etdK9xev9vr9/B+iWY37/fwfjfvb6xcoedIaDaXTEyzzWY7evTo4OBg2MonKrKE1ICTHpnmKbd/yu2f8vgbKrL0HBGaWRpQDCsuPmhWXhnIuEtLE8UaQVpBUAyDfjnklYXyC6OlGVNT2RWySEHbQglXj02xCpF38KdgGpmYZgih3W5nGKavr8+48rEdWa4pv2tqxjUt0+yannFN+cen/cd2ZOs5KmkOsSLAI3zaMjEcQ4foYOnQYXlLJEVsDp30VdOqimZcTcxEjJubjccmNyzVw56CmWRumiGEIyMj5eXlTqdTryYaUGif9Ek02ydmhJSBh7a/ruernps5TbFyMaKe2lQrFWlXc8eH1FLSjK8plOrNw/gyzbQbGk2YamaSuWl2OBxh52Y0oNDqkmm2unw2l8/q8h3YtlLPNwqa0ZlX4sOAZt31uIZm3ZoCePISQZdm7NhCbXMMhRzCVDORTEzz2NhY2HWzNqDwvYYOgeZhh2/YyY84+H2bY0EzUsYxVAQrDRkWllYtLVS7mpocwyBtSsCK1aRVMO5LhYwNQo6hKJqmMKeoqGYemZjmSJ5paAMKBZQHx/jnY/xzO/98zLfnkzewvsrnzWFXGvIlmqJp3O2X8i5Q94quuQvE1ZQXIKp+hMlWvYTQGZsaWr1qppFZaY7keTM2oPBK96DFxlts/FMbb7HyFpu38qNV8RlzvB/4mXO1MBeZleZIhA0oHBjlB0a9gj0Z9T4Z9VaUzR/NHEMp5tN4w5xefwpMaZqxAYXbSnO3l+YK/27/IHf7B7k7St+cx0Eg64T4oSUuRNJrYoapTTM2oDDRgyKaR6UyzUTpJkIzUeqI0EyUOiI0E6WOCM1EqSNCM1HqyMQ0l61aMC/t4v/qEPHf8eL2Rwu5o9m94J+CMhPNYfMFxqYbQrNpZSaaw+YLjHWH6IsOiQiqwgj77gWhWVSy0IzNF6iuEy5fYKwHRWg2mZKCZr18gSqFzReo76oKrWNp4f1M7OsTIjCqYDuFCwKPJmhP5m3WoYRQ2Y7OkBQdIe82mzZyZO5KPM0G+QJVCpsvUMdP+/IaSwM0sE95UPlaMDI3a12Mg/ZmF0qoHYbOkLQ0p98roColdb5AVGWrFhzIWyhlB9TLF4jxxKwRVBRGSLPGBRu0p5qbow0lxAwjYpox8YLppaTOF6jS+eJX0Ns+bb5AvNu80qwlJ3KajePwZkOzXDs9mU7qfIEqnS182eAu8Gzhyzp+6FWcZdQYhtDUCUAyolknaC9SmrFxeIphoOGnEa00NPGC6aXEr5sjV+P6RQZ3gY3rF+l6ypdzLWcGNCPBdnrTuXahEMVKAxeHp4ZYHaWnjP9Tz83aeMG0kploPlWwCL3t0+YLTPQAiRIsM9HcsSsTTRCozReY6AESJVhmolml+XpPg8i0MjHNREQqEZqJUkeEZqLUEaGZKHVEaCZKHRGaiVJHaUEzyReYJkoLmmOfL1CZKcQ0f0WOKvjKhL/KmBY0zy5fIIZUxY9/JxXNmtf5NK8GioWE5iRUXPIF6tNsWDQPCtuLAc1pFHxlVprjki+Q0GwymZjm+c8XaLzSQF84xr6Jqc3zh1TWxBoaZrZSNaRtWY/mOYQSqsMF0EqKVYhy2ZXIN1JNTDOc93yByIcjC0MzEgxA67xCLbups5eoYw2xwYIGcQPatCyhI9q5OapQQuP4xaRMN2hummEE+QIhhIc/e90+OeOYmIkyX2Dkc7OmBj7Pn6qybkCXZo5DHHUzCM6KZoNQQuVgNUNKxnSD5qY5knyBEML923Ks4z7ruC/KfIFzoxlDSAQ044MFlTSHbxk7d0YZSqi8omgbS8J0gyamOZJ8gYI+37xy2MnfsTjea+iIJl9gpDQrl5fynKcOGYyEZnzSPtVKQ9uychyKH12IMpRQG1FmnnSDJqY58mcaNZ+88XyMv2Nx5H54JvJ8gVHMzTTuJhBz0Y1kpYELFlREKOpeztE1CDrNRhdKiImPxA9JA61etfjJrDRH9by56g+rLFbeYuOvdA8mMl+guZQkfxeKRmalOSqVl60aGPU+ETMFxjNfoIllwj8FpgfNO0rf3PZB7nYkU2D88gWaUaZNN5gWNBOliQjNRKkjQjNR6uj/AZXdy42vRlY8AAAAAElFTkSuQmCC" alt="" />
三、base_image.hbm.xml配置文件内容
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd"> <hibernate-mapping>
<class name="cn.itheima.domain.Image" table="base_image">
<id name="id" column="IMAGE_ID">
<!-- <generator class="native"></generator> -->
</id>
<property name="number" column="AD_NUMBER" type="java.lang.String" />
<property name="ad_name" column="AD_NAME" type="java.lang.String" />
<property name="desc" column="AD_DESC" type="java.lang.String" />
<property name="image_name" column="IMAGE_NAME" type="java.lang.String" />
<property name="url" column="IMAGE_URL" type="java.lang.String" />
</class> </hibernate-mapping>
四、Image.java中内容
package cn.itheima.domain;
public class Image {
public String id;
public String number;
public String desc;
public String ad_name;
public String image_name;
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getNumber() {
return number;
}
public void setNumber(String number) {
this.number = number;
}
public String getDesc() {
return desc;
}
public void setDesc(String desc) {
this.desc = desc;
}
public String getAd_name() {
return ad_name;
}
public void setAd_name(String ad_name) {
this.ad_name = ad_name;
}
public String getImage_name() {
return image_name;
}
public void setImage_name(String image_name) {
this.image_name = image_name;
}
public String getUrl() {
return url;
}
public void setUrl(String url) {
this.url = url;
}
public String url;
}
五、HibernateUtils.java中
package cn.itheima.utils; import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration; public class HibernateUtils { private static final SessionFactory factory; //只加载一次
static {
Configuration config = new Configuration().configure();
factory = config.buildSessionFactory();
} public static Session getSession() {
return factory.openSession();
}
}
六、ImageTest中的增删改查
package cn.itheima.test; import java.util.List; import org.hibernate.Criteria;
import org.hibernate.Query;
import org.hibernate.SQLQuery;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.junit.Test; import cn.itheima.domain.Image; public class ImageTest {
// 添加
@Test
public void save() {
// 1.得到session
Configuration configuration = new Configuration().configure();
SessionFactory sessionFactory = configuration.buildSessionFactory();
Session session = sessionFactory.openSession();
// 2.开启事务
Transaction transaction = session.beginTransaction();
// 3.操作
Image book = new Image();
book.setId("3");
book.setAd_name("aaa");
book.setDesc("desc");
book.setImage_name("imagename");
book.setNumber("number");
book.setUrl("url");
session.save(book);
// 4.提交
session.getTransaction().commit();
session.close();
sessionFactory.close();
} // 删除 by id
@Test
public void delete() {
Configuration configuration = new Configuration().configure();
SessionFactory sessionFactory = configuration.buildSessionFactory();
Session session = sessionFactory.openSession();
Transaction transaction = session.beginTransaction();
Image image = new Image();
image.setId("1");
session.delete(image);
transaction.commit();
session.close();
sessionFactory.close();
} // 修改所有 by id
@Test
public void update() {
Configuration configuration = new Configuration().configure();
SessionFactory sessionFactory = configuration.buildSessionFactory();
Session session = sessionFactory.openSession();
Transaction transaction = session.beginTransaction();
Image image = new Image();
image.setId("3");
image.setAd_name("i");
image.setDesc("i");
image.setImage_name("i");
image.setNumber("i");
image.setUrl("i");
session.update(image);
transaction.commit();
session.close();
sessionFactory.close();
} // 查询一个，根据id
@Test
public void select() {
Configuration configuration = new Configuration().configure();
SessionFactory sessionFactory = configuration.buildSessionFactory();
Session session = sessionFactory.openSession();
Transaction transaction = session.beginTransaction();
Image image = (Image) session.get(Image.class, "8a8ae4fe4fa54c0e014fa6f65c3d0000");
transaction.commit();
System.out.println(image.getAd_name());
session.close();
sessionFactory.close();
} // 查询所有by sql;
@Test
public void SelectAllbySql() {
Configuration congConfiguration = new Configuration().configure();
SessionFactory sesseionFactory = congConfiguration
.buildSessionFactory();
Session session = sesseionFactory.openSession();
Transaction transaction = session.beginTransaction();
String sql = "select * from base_image";
SQLQuery sqlQuery = session.createSQLQuery(sql);//注意SQLQuery
sqlQuery.addEntity(Image.class);//指定查询类型为Image
List<Image> list = sqlQuery.list();
System.out.println(list.get(0).getAd_name());
session.close();
sesseionFactory.close();
} // 查询所有 hql
@Test
public void SelectAllByHql() {
Configuration configuration = new Configuration().configure();
SessionFactory sessionFactory = configuration.buildSessionFactory();
Session session = sessionFactory.openSession();
Transaction transaction = session.beginTransaction();
String hql = "from Image";// 根据Image类查询
Query query = session.createQuery(hql);
List<Image> list = query.list();
System.out.println(list.get(0).getAd_name());
session.close();
sessionFactory.close();
} // 查询所有qbc
@Test
public void selectAllByQbc() {
Configuration configuration = new Configuration().configure();
SessionFactory sessionFactory = configuration.buildSessionFactory();
Session session = sessionFactory.openSession();
Transaction transaction = session.beginTransaction();
//QBC
Criteria criteria = session.createCriteria(Image.class);
List<Image> list = criteria.list(); session.close();
sessionFactory.close();
}
}