ÇóC#¶ÁдoracleÊý¾Ý¿âÖÐclobÊý¾ÝµÄ´úÂë
ÈçÌ⣬ÇóC#ÖвÙ×÷oracleÊý¾Ý¿âÖÐclobÀàÐÍÊý¾ÝµÄÏà¹Ø´úÂ룬µÚÒ»´Î½Ó´¥£¬Ò»µãÒ²²»»á°¡£¬²»ÖªµÀÈçºÎд£¬¸øµã²Î¿¼´úÂ룬лÁË
°ïÄã¶¥Ò»ÏÂ
string file_name = this.filepath1_txt.Text.ToString();//ͼƬ·¾¶
Bitmap bmp = new Bitmap(file_name);
FileInfo fi = new FileInfo(file_name);
int w = bmp.Width;//¿í
int h = bmp.Height;//¸ß
long s = fi.Length;
string conn_str = "Provider=OraOLEDB.Oracle.1;Password=123;Persist Security Info=True;User ID=123;Data Source=123;Extended Properties=";
OleDbConnection cn = new OleDbConnection(conn_str);
cn.Open();
OleDbCommand cmd;
cmd = new OleDbCommand("insert into Table_1(fphoto) values(:FPHOTO1)", cn);
cmd.Parameters.Add("FPHOTO", OleDbType.Binary);
FileStream fs = new FileStream(file_name, FileMode.OpenOrCreate, FileAccess.Read);
byte[] MyData = new byte[fs.Length];
fs.Read(MyData, 0, System.Convert.ToInt32(fs.Length));
fs.Close();
cmd.Parameters["FPHOTO"].Value = MyData;
int result = cmd.ExecuteNonQuery();
if (result >
Ïà¹ØÎÊ´ð£º
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
ÎÒÓÐÒ»¸öÀàËÆµÄxmlµÄ string£¬Ïëͨ¹ý±éÀúÔõô¸öxml Êä³öÎÒÏëÒªµÄelementµÄÖµ
xml Ϊ£º
<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
<RequestType>DISCOVER_XML_ME ......
˼·£ºÒªÓÃc#Éú³ÉÒ»¸ö²¥·Å»úµÄ²¥·ÅÁбíµÄxml£¬ÀýÈ磺
<daty datys='2010-04-05' datye='2010-05-01' > //ÕâÊDz¥·ÅµÄÈÕÆÚ¶Î
<time times='01:12:00' timee='02:30:00'> ......