Hibernate MySql Ö÷¼üÉú³ÉÎÊÌâ
ÎÒÏÖÔÚboÀïÃæÖ÷¼üÓõÄÊÇIntegerÀàÐ͵ģ¬ÎÒÏëÖ÷¼ü×Ô¶¯Ôö³¤£¬ÓÃidentityÕâ¸öÐÐô£¿
/**
* @return id
* @hibernate.id generator-class="identity"
*/
public Integer getId() {
return id;
}
µ«ÊÇÏÖÔÚ±¨´ícould not instantiate id generator²»ÄÜÉú³ÉIDÉú³ÉÆ÷
ÔÀ´ÓõÄOracleÊý¾Ý¿â£¬ÓõÄÊÇSequenceÉú³É·½Ê½£¬ÏÖÔÚÊý¾Ý¿âÇ¨ÒÆÓÃMySQLÁË£¬
MySQLûÓÐSequence
increment
Java code:
<id name="memId" type="java.lang.Integer">
<column name="mem_id" precision="7" scale="0" />
<generator class="increment" />
</id>
ÎÒÒ²Óöµ½Á˲¶àµÄÎÊÌâ ÓÐЩÖ÷¼üÉú³É²ßÂÔÔÚMysqlÖпÉÄܲ»Ö§³Ö ½¨ÒéʹÓÃnative
Ò»°ãÇé¿öÏÂʹÓÃnative¾Í¹»ÁË£¬ºÜ°²È«ºÜ¼òµ¥£¬ÎÒÒ»°ã¶¼ÕâôÓõġ£
лл¥Éϸ÷룬ÎÒÓÃnative£¬identity ¶¼²»ÐУ¬×îºóÓõÄincrement¾ÍÐÐÁË£¬²»ÖªµÀΪʲônative£¬identity ²»ÐУ¬Hibernate¶ÔÕâÁ½¸ö¶¼ÊÇÖ§³ÖµÄ°¡
identity¿ÉÒÔ
ÎÒÓÃmysql¶¼ÊÇÓÃÕâ¸ö
Ö»ÊÇmysqlÖÐÖ÷¼üÒªÊÇauto_increment
ʹÓà native ¸ù¾Ý²»Í¬µÄÊý¾Ý¿â×Ô¶¯Ñ¡ÔñÖ÷¼üÉú³É·½Ê½¡£
SQL ServerÖ÷¼ü×Ô¶¯Ôö³¤ÓõÄÊÇidentity£¬
mySqlÔòÓÃauto_increment,
OracleÓõÄÊÇsequence.
Ó¦¸ÃÊÇnative ÎÒÒ²Òª°Ñoracle»»³Émysql Â¥Ö÷͸©µã¶
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£
µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ
È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......
ÎÒÓÃÒ»¸öÑ»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõ쬵«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ
public static final DataBase.MAXSIZE=102 ......
SELECT a.tguildname ,SUM(a.ct) + if (SUM(b.ct) IS NULL ,0,SUM(b.ct)) from (
SELECT tg.tguildname,c.cid, (
cf.fbb + cf.fgjbb + cf.fjybb + cf.fqb + cf.fgjqb + cf.fjyqb + cf.fqib + cf. ......
¼ÙÈçÊý¾Ý¿âÖÐÓиötest±í£¬±íÖÐÓÐid£¬Name£¬num£¬¼Ç¼ʱ¼ä
idΪ×ÔÔö³¤Ö÷¼ü£¬nameÊÇÃû×Ö£¬num±íʾÆäÊýÁ¿
1 nike 100 ϵͳʱ¼ä
2 nike 300 &n ......