Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

Çómysql+php ÖÐÎÄÈ«ÎÄËÑË÷

×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£

µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ

È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......

MySQLÊý¾Ý°ü¹ý´ó

ÎÒÓÃÒ»¸öÑ­»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõ쬵«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ


public static final DataBase.MAXSIZE=102 ......

mysqlÓï¾äÓÅ»¯ÎÊÌâ ´ó¼Ò¸øÓÅ»¯¸öSQLÓï¾ä

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. ......

mysql ¼òµ¥ÎÊÌâ

¼ÙÈçÊý¾Ý¿âÖÐÓиötest±í£¬±íÖÐÓÐid£¬Name£¬num£¬¼Ç¼ʱ¼ä
idΪ×ÔÔö³¤Ö÷¼ü£¬nameÊÇÃû×Ö£¬num±íʾÆäÊýÁ¿

1  nike  100        ϵͳʱ¼ä
2  nike  300  &n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ