Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 Êý¾Ý¿âɾ³ý²»ÁËÔõô°ì

ÎÒ֮ǰµ¼ÈëµÄÊý¾Ý¿â£¬ÏÖÔÚɾ³ý²»ÁË£¬ÓÃÁËÃüÁîÐк͹¤¾ß¶¼²»ÐУ¬ÖØÆôÒ²²»ÐУ¬ÕâÊÇÎªÊ²Ã´ÄØ£¿
ÄãÊÇÈçºÎɾ³ýµÄ£¿
ÓÐʲôÌáʾ£¿


ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©

......

mysqlµÄÁ¬½Ó³¬Ê±Ê±¼äÔõôÉèÖà - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))

AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......

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. ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ