¡¾×ªÔØ¡¿Java/Hibernate/±ê×¼SQL Êý¾ÝÀàÐͶÔÓ¦±í
JavaÊý¾ÝÀàÐÍ
HibernateÊý¾ÝÀàÐÍ
±ê×¼SQLÊý¾ÝÀàÐÍ
(PS:¶ÔÓÚ²»Í¬µÄDB¿ÉÄÜÓÐËù²îÒì)
byte¡¢java.lang.Byte
byte
TINYINT
short¡¢java.lang.Short
short
SMALLINT
int¡¢java.lang.Integer
integer
INGEGER
long¡¢java.lang.Long
long
BIGINT
float¡¢java.lang.Float
float
FLOAT
double¡¢java.lang.Double
double
DOUBLE
java.math.BigDecimal
big_decimal
NUMERIC
char¡¢java.lang.Character
character
CHAR(1)
boolean¡¢java.lang.Boolean
boolean
BIT
java.lang.String
string
VARCHAR
boolean¡¢java.lang.Boolean
yes_no
CHAR(1)('Y'»ò'N')
boolean¡¢java.lang.Boolean
true_false
CHAR(1)('Y'»ò'N')
java.util.Date¡¢java.sql.Date
date
DATE
java.util.Date¡¢java.sql.Time
time
TIME
java.util.Date¡¢java.sql.Timestamp
timestamp
TIMESTAMP
java.util.Calendar
calendar
TIMESTAMP
java.util.Calendar
calendar_date
DATE
byte[]
binary
VARBINARY¡¢BLOB
java.lang.String
text
CLOB
java.io.Serializable
serializable
VARBINARY¡¢BLOB
java.sql.Clob
clob
CLOB
java.sql.Blob
blob
BLOB
java.lang.Class
class
VARCHAR
java.util.Locale
locale
VARCHAR
java.util.TimeZone
timezone
VARCHAR
java.util.Currency
currency
VARCHAR
Ïà¹ØÎĵµ£º
2008 Äê 6 ÔÂ 24 ÈÕ
ÔÎĵØÖ·£º http://www.ibm.com/developerworks/cn/data/library/techarticles/dm-0806wangys/
±¾ÎĽéÉÜ IBM FileNet P8 4.0 Platform ÌṩµÄ Content Java API¡£Ê×ÏÈ¶Ô FileNet P8 Content Engine ºÍ API ½øÐиÅÒª½éÉÜ, ²¢ËµÃ÷ÁËһЩ»ù±¾¸ÅÄî£¬ËæºóÏêϸ½éÉÜÁË FileNet Content EngineÌṩµÄ»ùÓÚ EJB ......
ÖÚËùÖÜÖª£¬JavaÓïÑÔÊÇÒ»Ãŷdz£ÊʺÏÍøÂ翪·¢µÄÓïÑÔ£¬Óà JavaÓïÑÔ½øÐÐÐÔÄܲâÊԽű¾¿ª·¢½«»á´ó´óÌá¸ß²âÊÔ¿ª·¢Ð§ÂÊ¡£LoadRunnerÖÐÌṩÁ˶ÔJavaÐéÄâÓû§µÄÖ§³Ö¡£JavaÐéÄâÓû§ÒÀÍÐÓÚJDK£¬Õâ´ó´óÀ©³äÁËLoadRunnerµÄ½Å±¾¿ª·¢¹¦ÄÜ¡£²âÊÔÈËÔ±¼È¿ÉÒÔÓÃJavaÐéÄâÓû§À´²âÊÔ»ùÓÚJavaµÄÓ¦ÓÃϵͳµÄÐÔÄÜ£¬ÓÖ¿ÉÒÔʹÓÃJavaÓïÑÔµÄÇ¿´ó¿ª·¢½Å±¾ ......
select upper(name) from syscolumns
where id =any
(
select Id from sysobjects where name='tb_city'
)
lower
select row_number() over(order by firmid) from dbo.tb_BuildingMaterial
Éú³É ×ÔÔö 123
select rank() over(order by firmid) from dbo.tb_BuildingMaterial
Éú³É×ÔÔö123 ¸ù¾ÝÅ ......
µÚÒ»ÖÖ£º
SELECT
CASE
WHEN
price IS NULL THEN
'Not yet priced'
WHEN
price < 10 THEN
'Very Reasonable Title'
WHEN
price >= 10 AND
price < 20 THEN
'Coffee Table Title'
EL ......