Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Îļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

Winform+MySQL×öÏîÄ¿

Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡
Çë¸÷λ¸øÒÔÌáʾ¡£
ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É
1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔC ......

MySqlÎÊÌâ

MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()

SQL code:

sqlÀïÊÇ£º
getdate()

ÒýÓÃ
now()


ѧϰ

SQL code:
select now();

SQL code:
TODAY()
?

SQL code:
select now();
/* ......

MYSQL Êý¾Ý½ØÈ¡

MYSQL ½ØÈ¡Ò»¸öÊý¾Ý±íÖÐ,ijһ¸ö×Ö¶Î(fulltext) µÄǰÈý°Ù¸ö×Ö·û,·Åµ½¸Ã±íÏÂÁíÒ»¸ö×Ö¶Î(introtxt)Àï.
ÇóʵÏÖÕâ¸öЧ¹ûµÄÃüÁî
SQL code:
update ±í set introtxt=left(`fulltext`,300);

¶¥£¬Ñ§Ï°

SQL code: ......

mysql µ¼ÖÂËÀ»ú

»·¾³£ºwin2003 apache2 resin3 php5 mysql5
mysql´íÎóÀï³öÏÖÕâ¸ö£¬·þÎñÆ÷Ö±½ÓËÀµ½ÄÇÀï¡£
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_log ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ