¡¾×ªÔØ¡¿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
Ïà¹ØÎĵµ£º
javaÖо²Ì¬±äÁ¿ºÍ¾²Ì¬·½·¨·Ö±ðÓÐÊ²Ã´ÌØµã£¿
ÐüÉÍ·Ö£º0 - ½â¾öʱ¼ä£º2006-4-10 10:28
ÌáÎÊÕߣº vv_clear - ¶þ¼¶
×î¼Ñ´ð°¸
ΪʲôÎÊÁËÁ½´Î£¿ÔÙÌùÉÏÁíһƪ
Thinking:JavaÖÐstaticÓ÷¨- -
Tag£º Thinking:JavaÖÐs
Ò»¡¢static
ÇëÏÈ¿´ÏÂÃæÕâ¶Î³ÌÐò£º
public class ......
µÚÒ»µã£º
ÔÚ±àд³ÌÐòµÄ¹ý³ÌÖУ¬java»á±£Ö¤¾¡Á¿ÔÚʹÓõÄʱºò³õʼ»¯£¬ËùÒÔÔÚûÓгõʼ»¯µÄ±äÁ¿ÔÚʹÓùý³ÌÖбàÒëÆ÷»á±¨´í£¬ÕâÀïÎÒÃÇ˵µÄ±äÁ¿ÓÐ2ÖÖ£¬Ò»ÖÖÊÇÈ«¾Ö±äÁ¿£¬Ò»ÖÖÊǾֲ¿±äÁ¿£¬È«¾Ö±äÁ¿±àÒëÆ÷»á×Ô¶¯¸³¸ø³õÖµ£¬¶ø¾Ö²¿±äÁ¿²»ÄÜ£¬¿´ÏÂÃæÀý×Ó£º
public class Chushihua {
private int j;
priv ......
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 ¸ù¾ÝÅ ......
Ò»¡¢¼òµ¥²éѯ
¡¡¡¡ ¼òµ¥µÄTransact-SQL²éѯֻ°üÀ¨Ñ¡ÔñÁÐ±í¡¢from×Ó¾äºÍWHERE×Ӿ䡣
ËüÃÇ·Ö±ð˵Ã÷Ëù²éѯÁС¢²éѯµÄ
±í»òÊÓͼ¡¢ÒÔ¼°ËÑË÷Ìõ¼þµÈ¡£
ÀýÈ磬ÏÂÃæµÄÓï¾ä²éѯtesttable±íÖÐÐÕÃûΪ“ÕÅÈý”µÄnickname×ֶκÍemail×ֶΡ£
SELECT nickname,email
from testtable WHERE name='ÕÅÈý'
(Ò»)Ñ¡ÔñÁбí
¡ ......
ÓÐÖ´ÐÐsqlÌõ¼þÓï¾äwhere id in(@²ÎÊý)µÄʱºò£¬Èç¹û´¦Àí²»µ±£¬¾Í»á³öÏÖÎÊÌ⣺
ÈçÏÂÃæÕâ¸ö´æ´¢¹ý³Ì£º
alter proc Web_gettwtwgoldgameserverGoldSell
@ID int
as
declare @twgoldsellID nvarchar(1000)
select @twgoldsellID=twgoldsellID from twgoldgameserver where ID=@ID
set @twgoldsellID=replace(@twgoldsell ......