mysql µÄÊý¾Ý¿â±íÉú³ÉhibernateµÄÎÊÌâ¡£¡£¡£¡£¡£¡£¼±
´ó¼ÒºÃ£¬ÎÒÏÖÔÚµÄÇé¿öÊÇ£º
ÎÒ°ÑoracleÊý¾Ý¿â»»³ÉmysqlµÄ ÐèÒªÐÞ¸Ähbm.xmlÎļþ ÕâÀïÉæ¼°µ½ÁË ×Ô¶¯Ôö³¤ÁеÄÎÊÌâ £¬Ó¦¸ÃÔõÑù¸Ä×Ô¶¯Ôö³¤ÁÐÄØ £¿£¿£¿£¿
ÕâÀïÊÇ oracleÖÐµÄ ´úÂë
Java code:
<id name="id" type="java.lang.Long">
<column name="ID" precision="10" scale="0" />
<generator class="native">
<param name="sequence">TRADELOG_SEQ</param>
</generator>
</id>¡¢
лл¸÷λÁË
¾Ý˵ native ЧÂʲ»¸ß£¬Èç¹ûÊÇÖ÷¼ü¿ÉÒÔ identity
¿ÉÒÔʹÓÃnative .
<id name="id" type="java.lang.Long">
<column name="ID" precision="10" scale="0" />
<generator class="identity">
</generator>
</id>
È»ºó mysqlÖÐÖ÷¼üÒªÊÇauto_increment
mysqlµÄÊÇincrement
¿ÉÒÔÓÃnative
hibernateµÄincrementÊÇhibernate×Ô¼ºÉú³É»úÖÆ£¬ÎÊÌâ±È½Ï¶à
¶¥#1,ÒªÊÇÖ÷¼üµÄ»°identity
orcale ºÍmysqlµÄÖ÷¼üÉú³É·½Ê½ÊDz»Ò»ÑùµÄ
mysql Ö÷¼üÉú³É·½Ê½Ò»°ãд³ÉÈçϾͿÉÒÔÁË
&
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
MySQLÈëÃÅ
¿ÉÒÔÏÈ¿´Ê²Ã´Êé¼®°¡£¿
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·,ÕÆÎÕÊý¾Ý¿âµÄ»ù´¡ÀíÂÛ¡£
È»ºóÔÙ´Ö¿´Ò»±éMYSQLµÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html
¾ÍÕÒÒ»±¾ºÜ»ù´ ......
ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø
jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5
ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......
ÓÐÒ»ÌõsqlÓï¾ä select a.name ,b.name from tableA a,tableB b where a.id = b.id and ¡£¡£¡££¨ÆäËû¹ýÂËÌõ¼þ£©
ÆäÖÐa.id ΪtableAÖ÷¼ü ÓÐΨһÐÔË÷Òý Êý¾ÝÁ¿²Å1ǧ¶à
b.id ΪÈÕÖ¾±ítableB µÄÍâ¼ü £¬ÂýÈ¥Ìõ¼þµÄ²Å ......