C# code:
SqlConnection myConn = new SqlConnection("Server=localhost;Database=Scores;uid=sa;pwd=;");
SqlCommand cmd= new SqlCommand();;
cmd.CommandType = System.Data.CommandType.Text;
myConn.Open();
cmd.CommandText = " ......
´ó¼Ò·¢±íÒ»ÏÂ×Ô¼ºµÄÒâ¼û°¡£¡
1 ¿ªÔ´ÐÔ²»Ò»Ñù
2 Êý¾Ý¿âÈÝÁ¿ÐÔÄܽç±ð²»Äܲ¢ÂÛ
3 ¹«Ë¾¹æÄ£ÍêÈ«²»Ò»Ñù
OracleÄ¿Ç°ÊǹØϵÊý¾Ý¿âÖв¢·¢ÐÔÄÜ×îºÃµÄ£¬Ò²µÃµ½¹«ÖÚÈÏ¿É¡£
Mysql³äÆäÁ¿¿ÉÒÔËã¸öÖÐÐÍÊý¾Ý¿â
oracleÊÇÃæÏò´óÖÐÐÍÆóÒµÓ¦ÓõÄÊý¾Ý¿âϵͳ£¬¾ßÓнϸߺͽÏÍêÉƵÄÐÔÄÜ£¬µ«¶ÔÊý¾Ý¿â¹ÜÀíÔ±¾ßÓнϸߵÄÒªÇó¡£Ö ......
SQL code:
create
-----alter
proc AddNewAlm( @DID int ,
@UID int , @ATID int , @P1 int ,@P2 int, @SCIP nvarchar(20), @ATime datetime )
--returns int
as
begin
declare @IsHas int;
declare @AID int;
set @AID = 0;
update AlmInfoTmp set UID=UID where DID=@DID ......
²»ÖªµÀÄÜ·ñͨ¹ýÒ³Ã淽ʽ×öµ½ÈçϵijÌÐò£ºÓû§´ò¿ªÒ³Ãæºó£¬¿ÉÒÔÔÚºǫ́¼Ç¼Óû§ÔÚ¼üÅÌÖÐÊäÈëµÄ18λÉí·ÝÖ¤ºÅÂë¡£»ñÈ¡µ½Éí·ÝÖ¤ºÅÂëºóºÍ·þÎñÆ÷¶ËµÄÊý¾Ý¿â½øÐбȶԡ£WINFORM³ÌÐò¿Ï¶¨ÄÜ×öµ½£¬¹Ø¼üÊÇ×ö³ÉB/S½á¹¹ÄÜ·ñ×öµ½ÒÔÉϵŦÄÜ¿ª·¢ÒªÇó£¿
Èç¹û¿ÉÒÔ£¬ÐèÒªÓõ½Ê²Ã´¼¼Êõ£¬Çë´ó¼Ò½²½âһϡ£Âé·³ÁË¡£
¿ÉÒԵģ¬²éѯ½øÐбȽϡ£¡£¡£Òª ......
ÎÒÐèҪʹÓÃnhibernateµ÷ÓÃmysqlº¯Êý£¬ÀàËƵÄsqlÓï¾ä£º
select * from concat(',', ServiceCodes, ',') like '%,33,%';
»òselect * from (','||ServiceCodes||',') like '%,33,%';
ËùÒÔÎÒ¾ÍÕâÑùµ÷Óãº
//.....
C# code:
or.Add(Restrictions.Like(Projections.SqlFunction("concat", NHibernateUtil.Str ......
ÈçÌâ
¹Ø×¢£¬¶¥!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
C# code:
string queryString = "SELECT USERINFO.USERNAME from USERINFO WHERE UESERID='" + uid + "'";
using (OracleConnection connection = new OracleConnection(connectionString))
{
OracleCommand ......