public static void main(String[] args) {
// ×°ÔØSQLÇý¶¯³ÌÐò
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String urlString="jdbc:microsoft:sqlserver://localhost:1433;DataBasename=master";
Connection connection=DriverManager.getConnection(u ......
ÇëÎÊ
Ìí¼ÓÐÂÊý¾ÝÔ´->Êý¾Ý¿â->Ìí¼ÓÁ¬½Ó
Õâ¸ö½çÃæÏ£¬Êý¾ÝÔ´Ñ¡Ôñ£ºMicrosoft SQL Server (SqlClient)£»
·þÎñÆ÷Ãû£º
Ó¦¸ÃÐ´Ê²Ã´ÄØ£¿
ÓÐËÖªµÀ£¿¶àл¸÷λ£¡£¡
Äãµ½µ×ÊÇÒªÁ¬mysql»¹ÊÇmssql£¿
ÒýÓÃ
ÇëÎÊ
Ìí¼ÓÐÂÊý¾ÝÔ´->Êý¾Ý¿â->Ìí¼ÓÁ¬½Ó
Õâ¸ö½çÃæÏ£¬Êý¾ÝÔ´Ñ¡Ôñ£ºMicrosoft SQL Server (SqlClient)£»
·þ ......
ÎÒÊDzËÄñ£¬¸ÕѧVBºÍsqlserver£¬Âé·³ÓÐËÄܸúÎÒ½²Ò»ÏÂÔÚVB2008ÉÏÈçºÎ×ö¶ÔÊý¾Ý¿âµÄ²éѯ¡¢¸ü¸ÄÔõô×ö£¿ADO.NET ÎÒÁ˽âһЩ£¬Ö»»áÓÃDataGridView BindingSource BindingNavigator ÕâЩ¿Ø¼þÖ±½Óµ÷ÓÃÊý¾Ý¿â±í£¬¿ÉÊǸüÉîÈëµÄ£¬±ÈÈçÔÚǰ̨ÉÏÔö¼ÓÈô¸ÉTextBOX ¶ÔÓ¦Êý¾Ý¿âÌõÄ¿ ǰ̨Ìîд£¬¸ü¸Äµ½Êý¾Ý¿âÉÏ£¬ÕâÑù¸ÃÈçºÎ×ö£¿Ç°Ì¨ÓëÊý¾Ý¿âÈç ......
ÎÒÏë¼ÆËã¡°×Ö¶Î1¡±ÖеÄÊý¾Ý¡£
¾ÍÊÇÔÚ¡°×Ö¶Î1¡±ÖÐÉÏÒ»Ìõ¼Ç¼¼õÏÂÒ»Ìõ¼Ç¼£¬Ò»Ö±µ½×îºóÒ»Ìõ¼Ç¼£¬
µÃ³öµÄ½á¹ûÊä³öµ½¡°×Ö¶Î2¡±ÖС£
×Ö¶Î1 ×Ö¶Î2
9
7
8
5
2
2
¡
¡
¡
n
Çë¸÷λ¸ßÊÖд³ö´úÂëÀ´£¡Ð»Ð»£¡
ßÀ£¡ÎªÊ²Ã´Ã»ÓÐÈ˻صģ¬ÊÇ¿´²»Ã÷°×£¬»¹ÊÇÌ«ÄÑÁË£¿£¿
ÏÂÃæifº ......
1¡£ÔõÑùʹxp_cmdshellÄÜÍêÕûÊä³ö³¬¹ý255¸ö×Ö·ûµÄ×Ö·û´®¡£
2¡£select ʱ£¬¼ìË÷ËÙ¶ÈÊÇÓëfromºóµÄ TABLE˳ÐòÓйأ¬»¹ÊÇÓëwhereÌõ¼þµÄ˳ÐòÓйØ(TABLEÊý¾Ý¶àÉÙ )
ÔÚϵͳÊôÐÔÉ趨ÀïÓиöÑ¡Ïî,¿ÉÒÔÐ޸ĵ¥×Ö¶ÎÊä³ö×ÖÊýÏÞÖÆ.ĿǰĬÈÏÊÇ255¸ö×Ö·û. ¿ÉÒÔÐ޸ĵ½×î¶à8000»ò4000×Ö·û.
Êä³öµ½ÎļþÖÐÈ¥
EXEC master..xp_cmdshell 'ec ......
ÔÚÒ»ÕÅgoods±íÖÐÓвúÆ·Ãû³Æ,¹æ¸ñ,ͼƬ·¾¶µÈ×Ö¶Î,ÒѾ°ÑͼƬµÄ·¾¶±£´æµ½goods±íÖÐ,ÇëÎÊÔõôÑù²ÅÄܲéѯgoods±íʱ,²é³öµÄ¼Ç¼˫»÷»òÊÇÔõôÑù¿ÉÒÔÖ±½Ó´ò¿ªÍ¼Æ¬Â·¾¶Õâ¸ö×Ö¶ÎÏà¶ÔÓ¦µÄͼƬ,лл
²»ÖªÊÇʲô¸ñʽµÄͼƬ
bmp, jpeg¸ñʽµÄÓÃTImageÕâ¸ö¿Ø¼þ¼ÓÔØ¾Í¿ÉÒÔÁË¡£
ÎÒ·¢¶Î´úÂë¸øÄã.ÕâÊDz»¹Üʲô¸ñʽµÄÖ»ÒªÄã Uses ÉÏͼƬµ ......