HibernateµÄÓ³ÉäÀàÐÍ hibernate mysqlÓ³ÉäÀàÐÍ
1¡¢HibernateµÄÓ³ÉäÀàÐÍ hibernate mysqlÓ³ÉäÀàÐÍ
Hibernate Ó³ÉäÀàÐÍ
Java ÀàÐÍ
±ê×¼ SQL ÀàÐÍ
´óСºÍÈ¡Öµ·¶Î§
integer »òÕß int
int »òÕß java.lang.Integer
INTEGER
4 ×Ö½Ú
long
long Long
BIGINT
8 ×Ö½Ú
short
short Short
SMALLINT
2 ×Ö½Ú
byte
byte Byte
TINYINT
1 ×Ö½Ú
float
float Float
FLOAT
4 ×Ö½Ú
double
double Double
DOUBLE
8 ×Ö½Ú
big_decimal
java.math.BigDecimal
NUMERIC
NUMERIC(8,2)8 λ
character
char Character String
CHAR(1)
¶¨³¤×Ö·û
string
String
VARCHAR
±ä³¤×Ö·û´®
boolean
boolean Boolean
BIT
²¼¶ûÀàÐÍ
yes_no
boolean Boolean
CHAR(1) (Y-N)
²¼¶ûÀàÐÍ
true_false
boolean Boolean
CHAR(1) (T-F)
²¼¶ûÀàÐÍ
2 ¡¢ Java ʱ¼äºÍÈÕÆÚÀàÐ굀 Hibernate Ó³Éä
Ó³ÉäÀàÐÍ
Java ÀàÐÍ
±ê×¼ SQL ÀàÐÍ
ÃèÊö
date
util.Date »òÕß sql.Date
DATE
YYYY-MM-DD
time
Date Time
TIME
HH:MM:SS
timestamp
Date Timestamp
TIMESTAMP
YYYYMMDDHHMMSS
calendar
calendar
TIMESTAMP
YYYYMMDDHHMMSS
calendar_date
calendar
DATE
YYYY-MM-DD
3 ¡¢ Java ´ó¶ÔÏóÀàÐ굀 Hibernate Ó³ÉäÀàÐÍ
Ó³ÉäÀàÐÍ
Java ÀàÐÍ
±ê×¼ SQL ÀàÐÍ
MySQL ÀàÐÍ
Oracle ÀàÐÍ
binary
byte[]
VARBINARY( »ò BLOB)
BLOB
BLOB
text
String
CLOB
TEXT
CLOB
serializable
Serializable ½Ó¿ÚÈÎÒâʵÏÖÀà
VARBINARY( »ò BLOB)
BLOB
BLOB
clob
java.sql.Clob
CLOB
TEXT
CLOB
blob
java.sql.Blob
BLOB
BLOB
BLOB
ÔÚ³ÌÐòÖÐͨ¹ý Hibernate À´±£´æ java.sql.Clob »òÕß java.sql.Blob ʵÀýʱ£¬±ØÐë°üº¬Á½¸ö²½Ö裺
ÔÚÒ»¸öÊý¾Ý¿âÊÂÎñÖÐÏȱ£´æÒ»¸ö¿ÕµÄ Blob »ò Clob ʵÀý¡£
½Ó×ÅËø¶¨ÕâÌõ¼Ç¼£¬¸üÐÂÉÏÃæ±£´æµÄ Blob »ò Clob ʵÀý£¬°Ñ¶þ½øÖÆÊý¾Ý»òÎı¾Êý¾Ýдµ½ Blob »ò Clob ʵÀýÖÐ
½éÉÜMYSQLµÄÊý¾ÝÀàÐÍÁË£¬±Ï¾¹ÎªÄãÏëÒªµÄÊý¾ÝÑ¡¶¨Ò»¸öºÏÊʵÄÀàÐÍ£¬¶ÔÓÚÊý¾Ý¿âµÄ´æȡЧÂÊÓкܴóµÄ¸Ä½ø¡£
MYSQLÊý¾Ý¿âÓÐÒÔϼ¸ÖÖÀàÐÍ£ºÕûÊýÐÍ(int,binint,smallint,tinyintµÈµÈxxxintÐÍ)¡¢¸¡µãÐÍ(float,double,realµÈ)¡¢¶¨µãÊýÐÍ(decimal£¬Ò²¾ÍÊÇ´«ËµÖеĸ¡µãÐ͵Ä×Ö·û´®±í´ïÐÎʽ)¡¢ÈÕÆÚÓëʱ¼äÐÍ£¨data,time,datetime,timestamp£©£¬×Ö·û´®ÐÍ£¨char,varchar,text,tinytext,mediumtext,longtextµÈ£©£
Ïà¹ØÎĵµ£º
³£ÓÃMySQLµÄͯЬ¶¼ÖªµÀÕâ¸ömyisamÀàÐÍµÄ±í¼«ÈÝÒ×Ë𻵣¬¶àÊýÈË¿ÉÄܶ¼ÊÇÓÃmyisamchkÃüÁîÀ´È˹¤ÐÞ¸´£¬ÏÂÃæ½éÉÜÒ»ÖÖ×Ô¶¯ÐÞ¸´myisamµÄ·½·¨£¬Ò²ÊÇÎÒÉÏÎç¸ÕѧµÄ£¬¹²Í¬½ø²½£¬ºÇºÇ~
ÔÚMySQLµÄÅäÖÃÎļþmy.cnfÖУ¬Æô¶¯Ï·Ö¼ÓÈëmyisam-recoverÉèÖÃÊý¾Ý»Ö¸´¹¦ÄÜ£¬¾ßÌå ......
http://www.cnblogs.com/amboyna/archive/2009/11/16/1603867.html
ÓÐÒ»¶ÎÈÕ×ÓÁË£¬Ôø¾ÉèÖÃÁËÒ»´Î¼Ç¼ÔÚmysqlÖвéѯÂýÓÚ1ÃëÖÓµÄSQLÓï¾ä¡£¸Õ²ÅͻȻ»ØÏëÉèÖõķ½·¨£¬Óм¸¸ö²ÎÊýµÄÃû³ÆËÀ»î»ØÒä²»ÆðÀ´ÁË£¬ÓÚÊÇÖØÐÂÕûÀíһϣ¬×Ô¼º×ö¸ö±Ê¼Ç¡£
¶ÔÓÚÅŲéÎÊÌâÕÒ³öÐÔÄÜÆ¿¾±À´Ëµ£¬×îÈÝÒ×·¢ÏÖ²¢½â¾öµÄÎÊÌâ¾ÍÊÇMYSQLµÄÂý²éѯÒÔ¼°Ã»Óеà ......
ÎÅÃûåÚåǵÄMySQLÂÒÂëÎÊÌ⣨ת£©
2009-06-07 11:22
Ò»¡¢¸ÅÊö
¡¡¡¡¹«Ë¾Ð¹ºÁËÒ»ÅúPC£¬×¼±¸°Ñ¼¸¸öÐÔÄܽÏÓŵÄPCÉý¼¶ÎªÊý¾Ý¿â·þÎñÆ÷£¬Ìæ»»ÀϾɵĻúÆ÷¡£¹«Ë¾ÓÐÌ×POSÖÕ¶ËÈí¼þ£¬ºǫ́Êý¾Ý´æ´¢ÊÇ MySQL 3.23 °æ¡£ÎÒ×¼±¸Ó²¼þÉý¼¶µÄͬʱÉý¼¶Êý¾Ý¿âÈí¼þ¡£µ«ÊÇÉý¼¶¹ý³ÌÖÐÓöµ½ÎÅÃûµÄ MySQL µÄÂÒÂëÎÊÌâ¡£¾¹ý²éÕÒ×ÊÁÏ£¬¼ÓÉÏ×Ô¼ºµÄÃþË÷ºÍ¾ ......
½«SQLÓï¾ä·Åµ½Ò»¸öÎļþÖÐÈ»ºó¸æËßmysql´Ó¸ÃÎļþ¶ÁÈ¡ÊäÈ룬eg£º
shell>mysql db_name < text_file
Èç¹ûÕýÔÚÔËÐÐmysql£¬¿ÉÒÔʹÓÃ"source"»ò"\."ÃüÁîÖ´ÐÐSQL½Å±¾Îļþ£º
mysql>source filename
mysql>\. filename
ÀýÈ磬ҪÔÚÊý¾Ý¿âtestÖд´½¨±íºÍ²åÈëÊý¾Ý£¬ÆäÖд´½¨±íºÍ²åÈëÊý¾ÝµÄSQLÓï ......
1)
°²×°Apache/2.2.14 ºÍ PHP/5.2.12 Ö®ºó£¬ÖØÐÂÆô¶¯Apache£¬Æô¶¯Ê§°Ü¡£²éÁËһЩ×ÊÁÏ£¬»ù±¾Éϸø³öµÄ½¨ÒéÊǽûµôExtension¡£ÎÒ¾Í×°ÁËÒ»¸öExtesion Mysqli¡£
ÐÞ¸Äphp.ini ×¢Ê͵ôÕâÒ»ÐУ¬¹ûÈ»ÉúЧ¡£
[PHP_MYSQLI]
;extension=php_mysqli.dll
°²×°Íêmysql£¬ÔÙÖØÐÂenableÕâ¸öÅäÖþͺÃÁË£¬¹À¼ÆÊÇÒÀÀµÄ³Ð©mysqlµÄ¿â¡£
......