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

mysql´æ´¢Í¼Æ¬µÄÎÊÌâ - .NET¼¼Êõ / C#

°ÑͼƬ´æÈëµ½mysqlÖУº
  DateTime dt = (DateTime)para[0];
  string plateNo = (string)para[1];
  byte[] photo = (byte[])para[2];

  string sqlString = "insert into table1(Time,PlateNo,PlateImg) VALUES(?dt,?plateNo,?photo)";

  MySQLCommand dbCommand = new MySQLCommand();
  dbCommand.Connection = dbConnection;
  dbCommand.CommandText = sqlString;
  dbCommand.CommandType = System.Data.CommandType.Text;

  MySQLParameter mp1 = new MySQLParameter("?dt", System.Data.DbType.DateTime);
  mp1.Value = dt;
  dbCommand.Parameters.Add(mp1);
  MySQLParameter mp2 = new MySQLParameter("?plateNo", System.Data.DbType.String);
  mp2.Value = plateNo;
  dbCommand.Parameters.Add(mp2);
  MySQLParameter mp3 = new MySQLParameter("?photo", System.Data.DbType.Binary);
  mp3.Value = photo;
  dbCommand.Parameters.Add(mp3);
  MessageBox.Show("photo length:" + ((byte[])(mp3.Value)).Length.ToString());
  dbCommand.ExecuteNonQuery();
°ÑͼƬ¶Á³öÀ´£º
  byt


Ïà¹ØÎÊ´ð£º

C# DataSetµ¼³öxml Åú´¦Àí(Ñ­»·)µÃÔõô´¦Àí

DataSetµ¼³öxml Åú´¦Àí(Ñ­»·)µÃÔõô´¦Àí
XMLÎļþ
<A>
      <B>
        <C>
        </C>
  &nb ......

mysqlÎÊÌ⣡ - Java / Java SE

String sqlCount="select count(*) from usertable where username='"+
userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡
Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ
select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......

XmlDocumentÈçºÎÉú³É±ÕºÏ±ê¼ÇµÄXML - .NET¼¼Êõ / C#

ÎÒÓÃXmlDocumentÉú³ÉXML
XmlElement remarkNode = node.OwnerDocument.CreateElement("remark");
remark1Node.InnerXml = "";
Èç¹ûInnerXml¸³Öµ²»Îª¿Õ£¬ÔòÉú³ÉµÄ±ê¼ÇÊÇûÎÊÌâµÄ£¬±ÈÈ磺<r ......

MYSQLµ÷¶ÈµÄÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ


3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£
MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10.
ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ