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µÈ£©£
Ïà¹ØÎĵµ£º
1¡¢mysql±àÒë²ÎÊý£º
#cat /usr/local/mysql/bin/mysqlbug|grep configure
# This is set by configure
CONFIGURE_LINE="./configure '--prefix=/usr/local/mysql' '--with-openssl' '--enable-thread-safe-client' '--enable-local-infile' '--with-charset=gbk' '-with-extra-charsets=gb2312,gbk'"
±íʾ±àÒëÖÐÖ§³Öope ......
³£ÓÃMySQLµÄͯЬ¶¼ÖªµÀÕâ¸ömyisamÀàÐÍµÄ±í¼«ÈÝÒ×Ë𻵣¬¶àÊýÈË¿ÉÄܶ¼ÊÇÓÃmyisamchkÃüÁîÀ´È˹¤ÐÞ¸´£¬ÏÂÃæ½éÉÜÒ»ÖÖ×Ô¶¯ÐÞ¸´myisamµÄ·½·¨£¬Ò²ÊÇÎÒÉÏÎç¸ÕѧµÄ£¬¹²Í¬½ø²½£¬ºÇºÇ~
ÔÚMySQLµÄÅäÖÃÎļþmy.cnfÖУ¬Æô¶¯Ï·Ö¼ÓÈëmyisam-recoverÉèÖÃÊý¾Ý»Ö¸´¹¦ÄÜ£¬¾ßÌå ......
¹Ø¼ü×Ö: key×Ö¶ÎÊÇmysqlÀïÃæµÄ¹Ø¼ü×Ö
insert into app(name,created,key,secret,masterSecret) values ('aa',null,null,null,null);
ÒòΪÕâÀïµÄkey×Ö¶ÎÊÇmysqlµÄ¹Ø¼ü×Ö£¬ËùÒÔÒ»Ö±²å²»½øÈ¥¡£
ÐÞ¸ÄÈçÏÂ:ÔÚkeyµÄÍ·ÉϼÓÉÏÁ½µã(·´ÒýºÅ£¬ËüÔÚ¼üÅ̵Ä~Õâ¸ö¼üÉÏ)¡£¼´¿É¸ã¶¨
sql½¨±íÈçÏ£º
Java´úÂë
CREATE T ......
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö²ÎÊý-h»úÆ÷IP
µ ......
1¡¢MYSQLµÄ°²×°
1£©Ê×Ïȵ±È»ÊÇÏÂÔØÔ´Âë°ü¿©£¬È磺mysql-5.0.27µÄ°²×°£¬http://www.mysql.com
2£©½âѹËõ£¬>tar -zxvf mysql-5.0.27.tar.gz
3£©½âѹÍê³É£¬½øÈëmysql-5.0.27Îļþ¼Ð£¬>cd mysql-5.0.27
4£©°²×°ÅäÖã¬>./configure --prefix=/opt/mysql --with-extra-charsets=all --with-unix-socket-path=/opt/m ......