°ïÎÒд¸öMySqlÖеÄsqlÓï¾ä¡­¡­

ÎÒÓÐÈý¸ö±í£º
student_t:id name
student_course_t:student_id,course_id
course_t:id name
ÎÒÏëʵÏÖÕâÑùµÄɾ³ý£º±ÈÈç˵student_course_tÖÐÓÐÊý¾Ý1 1£¬ÎÒÏë°ÑËüɾ³ý¡­¡­Ò²¾ÍÊÇɾ³ý¶à¶Ô¶à¹ØϵÖÐÖмä±íµÄµ¥ÌõÊý¾ÝµÄsqlÓï¾ä¡­¡­

---

ûÈË°ï棿£¿£¿£¿

---

²»¿ÉÒÔ£¬ÕâÑùÎÒÊÔ¹ýÁË¡­¡­É¾³ý»áÌáʾ´íÎó¡­¡­

---

ÒýÓÃ

²»¿ÉÒÔ£¬ÕâÑùÎÒÊÔ¹ýÁË¡­¡­É¾³ý»áÌáʾ´íÎó¡­¡­

±¨Ê²Ã´´íÎó£¿ 2Â¥µÄÓ¦¸ÃÊǶԵÄ

---

²»ºÃÒâ˼¡­¡­Åª´íÁË¡­¡­¿ÉÒÔÁË¡­¡­µ«ÊÇÈçºÎÓÃhqlÓïÑÔдÄØ£¿

---

ÊDz»ÊÇÓÐÍâ¼ü°¡

---

ÒýÓÃ

²»ºÃÒâ˼¡­¡­Åª´íÁË¡­¡­¿ÉÒÔÁË¡­¡­µ«ÊÇÈçºÎÓÃhqlÓïÑÔдÄØ£¿

°Ñ±íÃ÷»»³ÉÀàÃû£¡

---

¾ÍÊǶà¶Ô¶àµÄ¹Øϵ£¬ÖмäµÄ±íÓÃÁ½¸ö±íµÄId×öÖ÷¼ü¡­¡­

---

Öмä±íÄÄÓÐÀàÃû°¡£¿Õâ¸öÎÒÒ²ÖªµÀ°¡¡­¡­

---

дһ¸öÊÂÎñ
ÏÈɾ³ýÖ÷¼ü±í£¬ÔÙɾ³ýÍâ¼ü±í

ÖÁÓÚhqlÓï¾ä£¬ÍøÉϺܶࡣÕÕ×Åд¾ÍÊÇÁË

---

¼ÈÈ»Óõ½hibernateÁË£¬¾ÍÖ±½ÓÒ»¸ö¶ÔÏó£¬ÔÙÔÚDaoÀïÃæthis.getHibernateTemplate().delete(entity);²»¾ÍÐÐÁË¡£ËüÊǸ±±í£¬É¾ÁËûɶÎÊÌâµÄ£¬ÓÖ²»ÊÇɾ³ýcourseºÍstudent¿ÉÄÜ»á³öÏÖÎ¥·¨²ÎÕÕÍêÕûÐÔµÄʶù¡£

---

ÊÔ¹ýÁËÍøÉϵģ¬ºÜ¶à¶¼²»ÐС­¡­Ìáʾ´íÎó¡­¡­

---

---

±¾µØͼƬ²»¿ÉÒԵİ¡¡­¡­

---

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'wher
exists (select courseid from course_t c where sc.course_id = c.courseid an' at
line 1

---