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µÈ£©£
Ïà¹ØÎĵµ£º
ÎÒµÄϵͳÊÇredhat as5 ½¨Òé´ó¼ÒÍêÈ«°²×°£¬ÒÔÃⰲװʱȱÉÙÏà¹ØµÄ±àÒëÆ÷µÈµÈ¡£
Ò»¡¢°²×°mysql£¨mysql-5.0.21.tar.gz£©
# tar zxf mysql-5.0.21.tar.gz
# cd mysql-5.0.21
#./configure --prefix=/usr/local/mysql --sysconfdir=/etc --localstatedir=/var/lib/mysql/
˵Ã÷£º
#prefix=/usr/lo ......
SQL Server´´½¨ÁÙʱ±í£º
´´½¨ÁÙʱ±í
·½·¨Ò»£º
create table #ÁÙʱ±íÃû(×Ö¶Î1 Ô¼ÊøÌõ¼þ,
×Ö¶Î2 Ô¼ÊøÌõ¼þ,
.....)
create table ##ÁÙʱ±íÃû(×Ö¶Î1 Ô¼ÊøÌõ¼þ,
×Ö¶Î2 Ô¼ÊøÌõ¼þ,
.....)
·½·¨¶þ£º
select * into #ÁÙʱ±íÃû from ÄãµÄ±í;
select * into ##ÁÙʱ±íÃû from ÄãµÄ±í;
×¢£ºÒÔÉϵÄ#´ú±í¾Ö²¿ÁÙʱ±í£¬##´ú±íÈ«¾ ......
MySQL+PHP²úÉúÂÒÂëÔÒò£º
¡ô MySQLÊý¾Ý¿âĬÈϵıàÂëÊÇutf8,Èç¹ûÕâÖÖ±àÂëÓëÄãµÄPHPÍøÒ³²»Ò»ÖÂ,¿ÉÄܾͻáÔì³ÉMySQLÂÒÂ룻
¡ô MySQLÖд´½¨±íʱ»áÈÃÄãÑ¡ÔñÒ»ÖÖ±àÂë,Èç¹ûÕâÖÖ±àÂëÓëÄãµÄÍøÒ³±àÂë²»Ò»ÖÂ,Ò²¿ÉÄÜÔì³ÉMySQLÂÒÂ룻
¡ô MySQL´´½¨±íʱÌí¼Ó×Ö¶ÎÊÇ¿ÉÒÔÑ¡Ôñ±àÂëµÄ,Èç¹ûÕâÖÖ±àÂëÓëÄãµÄÍøÒ³±àÂë²»Ò»ÖÂ,Ò²¿ÉÄÜÔì³ÉMySQ ......
ÎÅÃûåÚåǵÄMySQLÂÒÂëÎÊÌ⣨ת£©
2009-06-07 11:22
Ò»¡¢¸ÅÊö
¡¡¡¡¹«Ë¾Ð¹ºÁËÒ»ÅúPC£¬×¼±¸°Ñ¼¸¸öÐÔÄܽÏÓŵÄPCÉý¼¶ÎªÊý¾Ý¿â·þÎñÆ÷£¬Ìæ»»ÀϾɵĻúÆ÷¡£¹«Ë¾ÓÐÌ×POSÖÕ¶ËÈí¼þ£¬ºǫ́Êý¾Ý´æ´¢ÊÇ MySQL 3.23 °æ¡£ÎÒ×¼±¸Ó²¼þÉý¼¶µÄͬʱÉý¼¶Êý¾Ý¿âÈí¼þ¡£µ«ÊÇÉý¼¶¹ý³ÌÖÐÓöµ½ÎÅÃûµÄ MySQL µÄÂÒÂëÎÊÌâ¡£¾¹ý²éÕÒ×ÊÁÏ£¬¼ÓÉÏ×Ô¼ºµÄÃþË÷ºÍ¾ ......
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö²ÎÊý-h»úÆ÷IP
µ ......