hibernateµ÷ÓÃmysqlÖд洢¹ý³Ì

Ò»£® ½¨±íÓë³õʼ»¯Êý¾Ý
  ÔÚmysqlµÄtestÊý¾Ý¿âÖн¨Á¢Ò»ÕÅÐÂ±í£ºtbl_user,½¨±íÓï¾äÈçÏ£º
  DROP TABLE IF EXISTS `user`;
CREATE TABLE `tbl_user` (
   `userid` varchar(50) NOT NULL,
   `name` varchar(50) default '',
   `blog` varchar(50) default '',
   PRIMARY KEY  (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
  ½¨±í³É¹¦ºó£¬ÔڸñíÖÐÈÎÒâ²åÈ뼸ÌõÊý¾Ý¡£
¶þ£® ½¨Á¢´æ´¢¹ý³Ì
Ϊ²âÊÔhibernate3.xÖд洢¹ý³ÌµÄµ÷Óã¬ÎÒÃÇÔÚuser±íÖн¨Á¢getUserList¡¢createUser¡¢updateUserºÍdeleteUserÕâËĸö´æ´¢¹ý³Ì£¬ÔÚmysqlÖн¨Á¢´æ´¢¹ý³ÌµÄÓï¾äÈçÏ£º
1. »ñµÃÓû§ÐÅÏ¢ÁбíµÄ´æ´¢¹ý³Ì--getUserList
DROP PROCEDURE IF EXISTS `getUserList`;
CREATE PROCEDURE `getUserList`()
begin
     select * from  tbl_user;
end;
2. ͨ¹ý´«ÈëµÄ²ÎÊý´´½¨Óû§µÄ´æ´¢¹ý³Ì--createUser
DROP PROCEDURE IF EXISTS `createUser`;
CREATE PROCEDURE `createUser`(IN userid varchar(50), IN name varchar(50), IN blog varchar(50))
begin
    insert into tbl_user values(userid, name, blog);
end;
3. ͨ¹ý´«ÈëµÄ²ÎÊý¸üÐÂÓû§ÐÅÏ¢µÄ´æ´¢¹ý³Ì--updateUser
DROP PROCEDURE IF EXISTS `updateUser`;
CREATE PROCEDURE `updateUser`(IN nameValue varchar(50), IN blogValue varchar(50), IN useidValue varchar(50))
begin
    update tbl_user set name = nameValue, blog = blogValue where userid = useridValue;
end;
4. ɾ³ýÓû§ÐÅÏ¢µÄ´æ´¢¹ý³Ì--deleteUser
DROP PROCEDURE IF EXISTS `deleteUser`;
CREATE PROCEDURE `deleteUser`(IN useridValue int(11))
begin
    delete from tbl_user where userid = useridValue;
private String userid;
 /** Óû§ÐÕÃû*/
 private String name;
 /** Óû§blog*/
 private String blog;
//Ê¡ÂÔget/set·½·¨
}
User.hbm.xmlÎļþµÄÄÚÈÝÈçÏ£º
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="com.amigo.proc.model">
 &nbs