Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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·þÎñ

ÓÃInstallAnywhere´ò°üJava³ÌÐò°üº¬MySQLÊý¾Ý¿â
 
InstallAnywhere´ò°üJava³ÌÐòʱ¿ÉÒÔ×Ô¶¯Íê³ÉjreµÄ´ò°ü£¬µ«ÊÇÐèÒªMySQLÊý¾Ý¿âµÄ³ÌÐò¾ÍµÃÊÖ¶¯Ìí¼Ó¡£×ÊÁÏÌ«ÉÙ£¬¾À½áÁËÈýÌ죬ÖÕÓÚ½â¾ö
1¡¢  ÏÂÔØÂÌÉ«°æµÄMySQL£¬¿ÉÒÔÈ¥¹ÙÍøÏÂÔØ¡£ÍøÓÑÖÆ×÷ÁËMySQLµÄÂÌÉ«¾«¼òBat°æ£¨http://download.csdn.net/source/524812£©£¬¿ÉÒÔ ......

mysqlÊý¾ÝµÄµ¼ÈëºÍµ¼³ö

MySQLµ¼Èëµ¼³ö.sqlÎļþ²½ÖèÈçÏ£º
Ò».MySQLµÄÃüÁîÐÐģʽµÄÉèÖãº
×ÀÃæ->ÎҵĵçÄÔ->ÊôÐÔ->»·¾³±äÁ¿->н¨->
PATH=“£»path\mysql\bin;”ÆäÖÐpathΪMySQLµÄ°²×°Â·¾¶¡£
¶þ.¼òµ¥µÄ½éÉÜÒ»ÏÂÃüÁîÐнøÈëMySQLµÄ·½·¨£º
1.C:\>mysql -h hostname -u username -p
°´ENTER¼ü£¬µÈ´ýÈ»ºóÊäÈëÃÜÂë¡£Õâ ......

shell״̬ÏÂÀûÓÃmysqladmin¿ìËÙ¸ü¸ÄmysqlÏÂÓû§µÄÃÜÂë

Óï·¨:
/usr/local/mysql/bin/mysqladmin -u username -p newpassword
ϵͳ»áÌáʾÄúÊäÈë¾ÉÃÜÂë:
°´Enterºó,ϵͳ½«¾ÉµÄÃÜÂë¸Ä³Énewpassword,
×¢Òânewpassword²»ÊÇÃüÁî,ÊÇÒ»¸ö×Ö´®,¾ÍÊÇÐÂÃÜÂëµÄ×Ö´®,Äã¿ÉÒÔ¸ü¸Ä³ÉÆäËüµÄ.
-uºóÃæ¸ú×ÅÊÇÓû§Ãû,¾ÍÊÇÄãËùÒª¸ü¸ÄµÄÓû§Ãû. ......

ÎÅÃûåÚåǵÄMySQLÂÒÂëÎÊÌâ

ÎÅÃûåÚåǵÄMySQLÂÒÂëÎÊÌ⣨ת£©
2009-06-07 11:22
Ò»¡¢¸ÅÊö
¡¡¡¡¹«Ë¾Ð¹ºÁËÒ»ÅúPC£¬×¼±¸°Ñ¼¸¸öÐÔÄܽÏÓŵÄPCÉý¼¶ÎªÊý¾Ý¿â·þÎñÆ÷£¬Ìæ»»ÀϾɵĻúÆ÷¡£¹«Ë¾ÓÐÌ×POSÖÕ¶ËÈí¼þ£¬ºǫ́Êý¾Ý´æ´¢ÊÇ MySQL 3.23 °æ¡£ÎÒ×¼±¸Ó²¼þÉý¼¶µÄͬʱÉý¼¶Êý¾Ý¿âÈí¼þ¡£µ«ÊÇÉý¼¶¹ý³ÌÖÐÓöµ½ÎÅÃûµÄ MySQL µÄÂÒÂëÎÊÌâ¡£¾­¹ý²éÕÒ×ÊÁÏ£¬¼ÓÉÏ×Ô¼ºµÄÃþË÷ºÍ¾ ......

mysql ³£ÓÃÃüÁî £¨×ª£©

µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö²ÎÊý-h»úÆ÷IP
µ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ