C# SqlServer - .NET¼¼Êõ / C#
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 = "insert into INFO(ѧºÅ) values ('111')";
int num = cmd.ExecuteNonQuery();
cmd.Connection = myConn;
ΪʲôûÓ𡣿´ó¼Ò°ï°ï棡Êý¾Ý¿âÖеıíû±ä°¡£¡
cmd.Connection = myConn;
·Åµ½µÚ3ÐÐÈ¥
ÒªÏÈΪSqlCommand¶ÔÏóÖ¸¶¨SqlConnectionÁ¬½Ó£¬È»ºóÔÙÖ´ÐÐÃüÁî¡£
¶÷ UP
ȷʵȷʵ£¬Ð»Ð»¶þ룬µ«ÊÇÎªÊ²Ã´ÄØ£¿
cmd.Connection = myConn; ·ÅÔÚ int num = cmd.ExecuteNonQuery(); Ç°ÃæÖ´ÐоÍOKÁË
SqlConnection myConn = new SqlConnection("Server=localhost;Database=Scores;uid=sa;pwd=;");
myConn.Open();
SqlCommand cmd= new SqlCommand('insert into INFO(ѧºÅ) values ('111')',myConn);
int num = cmd.ExecuteNonQuery();
myConn.Close();
1¡¢2Â¥¶¼ÕýÈ·
ÊÂʵÉϰÑcmd.Connection = myConn;
·Åµ½num = cmd.ExecuteNonQuery();֮ǰ¾ÍÐУ¬
cmdÒªÓÐÁ¬½Ó ²¢ÇÒÁ¬½Ó´ò¿ª²ÅÄÜexcute
Ïà¹ØÎÊ´ð£º
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......
txt ºÍXML ¸ñʽÏàÓ¦
²»½èÖúDataSet
µ¼Èë¶ÁÈ¡TXTÎļþ
È»ºóÖ±½ÓдÈëXML(ͬһÎļþ,²»Í¬Êý¾Ý,µÝÔöÔÊý¾ÝûÓб»¸²¸ÇÇé¿öÏÂÔö¼ÓÊý¾Ý.)
½Ì¸öÒªµã»ò×îºÃÊÇÓиö´úÂëÌáʾµÄ
¹ý·ºÃºº °ï¸öæÈö^^
²»»á£¬°ïÂ¥Ö÷ ......
´ó¼ÒºÃ£º
ÎÒÏëʵÏÖ¼ì²âµ½²åÈëSD¿¨ºó×Ô¶¯½«SD¿¨¸ñʽ»¯µÄ¹¦ÄÜ£¬²»ÖªC/C++ÖÐÓÐûÓиñʽ»¯UÅ̵ĺ¯Êý£¿
ÁíÍ⣬ÎÒ²»ÏëʹÓÃSHFormatDrive£¬ÒòΪÕâ¸öº¯Êý»áµ¯³öÊÇ·ñÒª¸ñʽ»¯µÄÌáʾ¿ò£¬ÎÒÐèÒªµÄÊÇϵͳ×Ô¶¯¸ñʽ»¯£¬¶ø²Ù×÷Õß² ......
ÎÒÓÐÒ»¸öÀàËÆµÄxmlµÄ string£¬Ïëͨ¹ý±éÀúÔõô¸öxml Êä³öÎÒÏëÒªµÄelementµÄÖµ
xml Ϊ£º
<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
<RequestType>DISCOVER_XML_ME ......
1¡£ÔõÑùʹxp_cmdshellÄÜÍêÕûÊä³ö³¬¹ý255¸ö×Ö·ûµÄ×Ö·û´®¡£
2¡£select ʱ£¬¼ìË÷ËÙ¶ÈÊÇÓëfromºóµÄ TABLE˳ÐòÓйأ¬»¹ÊÇÓëwhereÌõ¼þµÄ˳ÐòÓйØ(TABLEÊý¾Ý¶àÉÙ )
ÔÚϵͳÊôÐÔÉ趨ÀïÓиöÑ¡Ïî,¿ÉÒÔÐ޸ĵ¥×Ö¶ÎÊä³ö×ÖÊýÏÞÖÆ. ......