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

CodeSmith,SqlServer,C#ÖеÄÀàÐͶÔÕÕ

SQLServer          CodeSmith                            C#
bigint                    Int64                                 Int64
binary                   Binary                                System.Byte[]
bit                         Boolean                              bool
char                      AnsiString                          string
datetime              DateTime                            string
decimal                Decimal                              Decimal
float                      Double                &


Ïà¹ØÎĵµ£º

ÉîÈëdz³öÉè¼ÆÄ£Ê½(C#/Java°æ)

GRASPģʽ:General Responsibility Assignment Software Patterns£ºÍ¨ÓÃÔðÈηÖÅäÈí¼þģʽ
ÀïÃæÖØÒªµÄ¸ÅÄîÊÇÔðÈΣ¬ÔðÈÎÊÇÀà¼äµÄÒ»ÖÖºÏÔ¼»òÊÇÒåÎñ£¬¿ÉÒÔϸ·ÖΪÁ½²¿·Ö£¬Óù«Ê½±íʾÈçÏ£º
ÔðÈÎ = ÖªµÀÔðÈÎ + ÐÐΪÔðÈΣ¨ÕâÀïÃæËÆºõ´æÔÚ¸ÅÄîµÄÑ­»·¶¨Ò壩
×¢£ºÓÃͨË׵ϰÀ´½²£¬ÔðÈξÍÊÇÒ»¸öÀàÖªµÀÒª×öʲô£¬²¢ÇÒÄܹ»×öʲô¡£
· ......

SunÈÏΪC#²»»áÌæ´úJava

SunÈÏΪC#²»»áÌæ´úJava ¡¡Õª×Ô£ºÎÒ°®ÄϹϸçÍøÕ¾¡¡ Microsoft(΢Èí¹«Ë¾)˵¡ÃC#ͬJava²»Ò»Ñù£¬½«³ÉΪһ¸ö¹ú¼ÊÐÔ±ê×¼¡£ ¡¡¡¡C#ͬJava½ÏÁ¿µÄµÚÒ»¾Ö±ÈÈüÒѾ­¿ªÊ¼£¬Sun¹«Ë¾Éù³ÆMicrosoftÒѾ­¸øÒ»¸ö²»Ïà¹ØµÄ±ê׼ίԱ»áµÝ½»ÁËÒ»¸öÁíÈË»ìÏýµÄ¡¢²»ÍêÉÆµÄ¼¼Êõ±ê×¼¡£ ¡¡¡¡Sun¹«Ë¾µÄ¹¤³ÌʦÃÇ×ÔMicrosoft¹«Ë¾ÓÚÐÇÆÚÒ»·¢²¼ÁËC#±ê×¼ÒÔÀ´£¬Ò» ......

XpϵͳÏÂsqlServer 2000ÖÐ1433¶Ë¿Ú´ò²»¿ªµÄÎÊÌâ

 ÎÒ×°µÄÊÇXpϵͳ£¬µ±ÎÒ×°Sql Server2000Êý¾Ý¿âºó£¬ÓÃJava³ÌÐòÀ´½øÐÐÊý¾Ý¿âÁ¬½Óʱ³ö´íÁË£¬·¢ÏÖÊÇ1433¶Ë¿ÚûÓдò¿ª£¬ÔÚÍøÉÏÕÒÁËЩ½â¾ö°ì·¨£¬·½·¨ËµµÄ²»ÊǺÜÇå³þ£¬»¹ÓеãÂÞàÂÁË¡£ÎÒ½â¾öºó·¢ÏÖ°ì·¨ÊÇ£ºÊ×ÏÈÊDz鿴ÄãµÄ°æ±¾£¬¿ÉÒÔÓÃselect @@versionÀ´²é¿´¡£×°ÍêSql Server 2000 1433¶Ë¿ÚÓÐÊÇûÓдò¿ª£¬¿ÉÒÔÓÃnet -an -p tcp ......

javaÊý¾Ý¿âÁ¬½Ó¼°²âÊÔ(sqlserver)


package com.test.util;
import java.sql.*;
public class ConnectDB {
 private Connection conn=null;
 private PreparedStatement pt=null;
 private ResultSet rs=null;
 private String uname="sa";
 private String upwd="sa";
 private String url="jdbc:microsoft:sqlserv ......

mysqlÊý¾Ýµ¼³öµ½sqlserver·½·¨

ÕâÀïÊÇʹÓÃODBCÀ´×ª»»Êý¾Ý¿âµÄ¡£
1.°²×°mysqlÊý¾Ý¿âµÄODBCÇý¶¯£¬mysql¹ÙÍøÓÐÏÂÔØhttp://dev.mysql.com/downloads/connector/odbc/
2.´ò¿ª¿ØÖÆÃæ°å\¹ÜÀí¹¤¾ß\Êý¾ÝÔ´ODBC£¬ÔÚÓû§DSNÖÐÌí¼ÓÒ»¸öMySQL ODBC Êý¾ÝÔ´¡£
3.½Ó×ÅÔÚÏÂÃæµÄ´°ÌåÖÐÊäÈëÊý¾ÝÔ´Ãû³Æ£¬Èçmysqlodbc£»È»ºóÊäÈë·þÎñÆ÷ServerµØÖ·£¨localhost»òÆäËû£©£¬Óû§Us ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ