using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using MySql.Data.MySqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
string mySqlConnectionString="Database=newdb;Data Source=localhost;User Id=root;Password=";
using (MySqlConnection myCon = new MySqlConnection(mySqlConnectionString))
{
using (MySqlCommand cmd = new MySqlCommand("INSERT INTO Test(uid,regdate,remark) values(@uid,curdate(),@remark)", myCon))
{
cmd.Parameters.Add(new MySqlParameter("@uid",this.TextBox1.Text.Trim()));
cmd.Parameters.Add(new MySqlPa ......
using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using MySql.Data.MySqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
string mySqlConnectionString="Database=newdb;Data Source=localhost;User Id=root;Password=";
using (MySqlConnection myCon = new MySqlConnection(mySqlConnectionString))
{
using (MySqlCommand cmd = new MySqlCommand("INSERT INTO Test(uid,regdate,remark) values(@uid,curdate(),@remark)", myCon))
{
cmd.Parameters.Add(new MySqlParameter("@uid",this.TextBox1.Text.Trim()));
cmd.Parameters.Add(new MySqlPa ......
1£¬ÔÚweb·þÎñÆ÷ÉÏ°²×°OracleÊý¾Ý¿â¿Í»§¶Ë£¬ÕâÊÇÁ¬½ÓOracleÊý¾Ý¿âµÄ»ù´¡£¨µ«£¬²»Ò»¶¨ÊDZØÐëµÄ£©¡£
2£¬ÔÚ¿Í»§¶ËµÄNet Manager ÖнøÐÐÅäÖ÷þÎñµÄÃû³Æ£¬ÅäÖÃÈçͼ£¨ÕâÒ»µã·Ç³£µÄÖØÒªÒÔºóµÄÁ´½ÓÈ«¶¼ÔÚÕâ¸ö·þÎñÃû³ÆµÄ»ù´¡ÉϽøÐеģ©
3£¬ASPÁ´½Ó·þÎñµÄÁ´½Ó×Ö·û´®ºÍ·½·¨ÈçÏ£º
<%
connstr= "Provider=MSDAORA.1;Password=***;User ID=***;Data Source=ipcheck;"
set conn=server.createobject("ADODB.CONNECTION")
conn.open connstr
%>
4£¬ASP.net(C#) Á´½ÓÊý¾Ý¿â ¿ÉÒÔʹÓÃÕâƪÎÄÕ½éÉܵķ½Ê½
Ìí¼Ó
<appSettings>
<add key="SysDSN" value="Data Source=ServerName;User ID=userid;Password=password;Unicode=True"/>
</appSettings>
ÔÙÕߣ¬¾Í¿ÉÒÔÌí¼ÓÒ»¸ömyclassÎļþ¼Ð£¬Ö®ºóÔÚÆäÖн¨¸öÀàÎļþ£¬Ä¬ÈÏÃüÃû¿Õ¼äÊÇmyClass
ÀàÎļþÃûΪconn.cs
ÓÉÓÚVS.NET2005²»Ä¬ÈÏÖ§³ÖoracleÊý¾Ý¿â£¬ËùÒÔÒªÌí¼ÓÆäÒýÓãºÔÚ½â¾ö·½°¸×ÊÔ´¹ÜÀíÆ÷ÀïÌí¼ÓÒýÓãºSystem.Data.OracleClient£¨×ÐϸÕÒÕÒàÞ~ÔÚ.NETÑ¡ÏÖУ©
ÄÚÈÝ£¨²»¶Ï¸üУ©£º
1using System;
2 ......
1£¬ÔÚweb·þÎñÆ÷ÉÏ°²×°OracleÊý¾Ý¿â¿Í»§¶Ë£¬ÕâÊÇÁ¬½ÓOracleÊý¾Ý¿âµÄ»ù´¡£¨µ«£¬²»Ò»¶¨ÊDZØÐëµÄ£©¡£
2£¬ÔÚ¿Í»§¶ËµÄNet Manager ÖнøÐÐÅäÖ÷þÎñµÄÃû³Æ£¬ÅäÖÃÈçͼ£¨ÕâÒ»µã·Ç³£µÄÖØÒªÒÔºóµÄÁ´½ÓÈ«¶¼ÔÚÕâ¸ö·þÎñÃû³ÆµÄ»ù´¡ÉϽøÐеģ©
3£¬ASPÁ´½Ó·þÎñµÄÁ´½Ó×Ö·û´®ºÍ·½·¨ÈçÏ£º
<%
connstr= "Provider=MSDAORA.1;Password=***;User ID=***;Data Source=ipcheck;"
set conn=server.createobject("ADODB.CONNECTION")
conn.open connstr
%>
4£¬ASP.net(C#) Á´½ÓÊý¾Ý¿â ¿ÉÒÔʹÓÃÕâƪÎÄÕ½éÉܵķ½Ê½
Ìí¼Ó
<appSettings>
<add key="SysDSN" value="Data Source=ServerName;User ID=userid;Password=password;Unicode=True"/>
</appSettings>
ÔÙÕߣ¬¾Í¿ÉÒÔÌí¼ÓÒ»¸ömyclassÎļþ¼Ð£¬Ö®ºóÔÚÆäÖн¨¸öÀàÎļþ£¬Ä¬ÈÏÃüÃû¿Õ¼äÊÇmyClass
ÀàÎļþÃûΪconn.cs
ÓÉÓÚVS.NET2005²»Ä¬ÈÏÖ§³ÖoracleÊý¾Ý¿â£¬ËùÒÔÒªÌí¼ÓÆäÒýÓãºÔÚ½â¾ö·½°¸×ÊÔ´¹ÜÀíÆ÷ÀïÌí¼ÓÒýÓãºSystem.Data.OracleClient£¨×ÐϸÕÒÕÒàÞ~ÔÚ.NETÑ¡ÏÖУ©
ÄÚÈÝ£¨²»¶Ï¸üУ©£º
1using System;
2 ......
1£¬ÔÚweb·þÎñÆ÷ÉÏ°²×°OracleÊý¾Ý¿â¿Í»§¶Ë£¬ÕâÊÇÁ¬½ÓOracleÊý¾Ý¿âµÄ»ù´¡£¨µ«£¬²»Ò»¶¨ÊDZØÐëµÄ£©¡£
2£¬ÔÚ¿Í»§¶ËµÄNet Manager ÖнøÐÐÅäÖ÷þÎñµÄÃû³Æ£¬ÅäÖÃÈçͼ£¨ÕâÒ»µã·Ç³£µÄÖØÒªÒÔºóµÄÁ´½ÓÈ«¶¼ÔÚÕâ¸ö·þÎñÃû³ÆµÄ»ù´¡ÉϽøÐеģ©
3£¬ASPÁ´½Ó·þÎñµÄÁ´½Ó×Ö·û´®ºÍ·½·¨ÈçÏ£º
<%
connstr= "Provider=MSDAORA.1;Password=***;User ID=***;Data Source=ipcheck;"
set conn=server.createobject("ADODB.CONNECTION")
conn.open connstr
%>
4£¬ASP.net(C#) Á´½ÓÊý¾Ý¿â ¿ÉÒÔʹÓÃÕâƪÎÄÕ½éÉܵķ½Ê½
Ìí¼Ó
<appSettings>
<add key="SysDSN" value="Data Source=ServerName;User ID=userid;Password=password;Unicode=True"/>
</appSettings>
ÔÙÕߣ¬¾Í¿ÉÒÔÌí¼ÓÒ»¸ömyclassÎļþ¼Ð£¬Ö®ºóÔÚÆäÖн¨¸öÀàÎļþ£¬Ä¬ÈÏÃüÃû¿Õ¼äÊÇmyClass
ÀàÎļþÃûΪconn.cs
ÓÉÓÚVS.NET2005²»Ä¬ÈÏÖ§³ÖoracleÊý¾Ý¿â£¬ËùÒÔÒªÌí¼ÓÆäÒýÓãºÔÚ½â¾ö·½°¸×ÊÔ´¹ÜÀíÆ÷ÀïÌí¼ÓÒýÓãºSystem.Data.OracleClient£¨×ÐϸÕÒÕÒàÞ~ÔÚ.NETÑ¡ÏÖУ©
ÄÚÈÝ£¨²»¶Ï¸üУ©£º
1using System;
2 ......
/// <summary>
/// ·½·¨Ò»:ͨ¹ýʹÓà new ÔËËã·û´´½¨¶ÔÏó
/// </summary>
/// <param name="strSource">ÐèÒª¼ÓÃܵÄÃ÷ÎÄ</param>
/// <returns>·µ»Ø16λ¼ÓÃܽá¹û£¬¸Ã½á¹ûÈ¡32λ¼ÓÃܽá¹ûµÄµÚ9λµ½25λ</returns>
public string Get_MD5_Method1(string strSource)
{
//new
System.Security.Cryptography.MD5 md5 = new System.Security.Cryptography.MD5CryptoServiceProvider();
//»ñÈ¡ÃÜÎÄ×Ö½ÚÊý×é
byte[] bytResult = md5.ComputeHash(System.Text.Encoding.Default.GetBytes(strSource));
//ת»»³É×Ö·û´®£¬²¢È¡9µ½25λ
string strResult = BitConverter.ToString(bytResult, 4, 8);
//ת»»³É×Ö·û´®£¬32λ
//string strResult = BitConverter.ToString(bytResult);
//BitConverterת»»³öÀ´µÄ×Ö·û´®»áÔÚÿ¸ö×Ö·ûÖмä²úÉúÒ»¸ö·Ö¸ô·û£¬ÐèҪȥ³ýµô
strResult = strResult.Replace("-", "");
return strResult;
}
/// <summary>
/// ·½·¨¶þ:ͨ¹ýµ÷ÓÃÌض¨¼ÓÃÜËã·¨µÄ³éÏóÀà ......
/// <summary>
/// ·½·¨Ò»:ͨ¹ýʹÓà new ÔËËã·û´´½¨¶ÔÏó
/// </summary>
/// <param name="strSource">ÐèÒª¼ÓÃܵÄÃ÷ÎÄ</param>
/// <returns>·µ»Ø16λ¼ÓÃܽá¹û£¬¸Ã½á¹ûÈ¡32λ¼ÓÃܽá¹ûµÄµÚ9λµ½25λ</returns>
public string Get_MD5_Method1(string strSource)
{
//new
System.Security.Cryptography.MD5 md5 = new System.Security.Cryptography.MD5CryptoServiceProvider();
//»ñÈ¡ÃÜÎÄ×Ö½ÚÊý×é
byte[] bytResult = md5.ComputeHash(System.Text.Encoding.Default.GetBytes(strSource));
//ת»»³É×Ö·û´®£¬²¢È¡9µ½25λ
string strResult = BitConverter.ToString(bytResult, 4, 8);
//ת»»³É×Ö·û´®£¬32λ
//string strResult = BitConverter.ToString(bytResult);
//BitConverterת»»³öÀ´µÄ×Ö·û´®»áÔÚÿ¸ö×Ö·ûÖмä²úÉúÒ»¸ö·Ö¸ô·û£¬ÐèҪȥ³ýµô
strResult = strResult.Replace("-", "");
return strResult;
}
/// <summary>
/// ·½·¨¶þ:ͨ¹ýµ÷ÓÃÌض¨¼ÓÃÜËã·¨µÄ³éÏóÀà ......
SqLite.netµÄdllΪSystem.Data.SQLite.dll£¬ÕâÖÖdll·ÖΪ32λ¡¢64λºÍÊÊÓÃÓÚcompactframeworkÈýÖÖ£¬ÔÚÒýÓÃʱҪעÒ⣬ѡÔñÕýÈ·µÄdll¡£
½«Òª±£´æͼƬµÄ×Ö¶ÎÀàÐÍÉèΪblob¡£´úÂëÈçÏ£º
private void savePicture£¨£©
{
using (SQLiteConnection cnn = new SQLiteConnection(dbPath))
{
cnn.Open();
using (SQLiteCommand cmd = cnn.CreateCommand())
{
//cmd.CommandText = "Create Table test(data Image)";
//cmd.ExecuteNonQuery();
cmd.CommandText = "insert into person values('12',@data,'14','13')";
SQLiteParameter para = new SQLiteParameter("@data", DbType.Binary);
string file = @"F:\Image\·É»ú.png";
FileStream fs = new FileStream(file, FileMode.Open);
//StreamUtil su = new StreamUtil();
//byte[] buffer = su.StreamToBytes(fs);
byte[] buffer ......
SqLite.netµÄdllΪSystem.Data.SQLite.dll£¬ÕâÖÖdll·ÖΪ32λ¡¢64λºÍÊÊÓÃÓÚcompactframeworkÈýÖÖ£¬ÔÚÒýÓÃʱҪעÒ⣬ѡÔñÕýÈ·µÄdll¡£
½«Òª±£´æͼƬµÄ×Ö¶ÎÀàÐÍÉèΪblob¡£´úÂëÈçÏ£º
private void savePicture£¨£©
{
using (SQLiteConnection cnn = new SQLiteConnection(dbPath))
{
cnn.Open();
using (SQLiteCommand cmd = cnn.CreateCommand())
{
//cmd.CommandText = "Create Table test(data Image)";
//cmd.ExecuteNonQuery();
cmd.CommandText = "insert into person values('12',@data,'14','13')";
SQLiteParameter para = new SQLiteParameter("@data", DbType.Binary);
string file = @"F:\Image\·É»ú.png";
FileStream fs = new FileStream(file, FileMode.Open);
//StreamUtil su = new StreamUtil();
//byte[] buffer = su.StreamToBytes(fs);
byte[] buffer ......
Anders Hejlsberg(°²µÂ˹-º£É²©¸ñ) ×øÔÚ×Ô¼ºµÄ°ì¹«ÊÒ£¬Ë«ÑÛÖ±Ö±µÄ¶¢×ÅÇ°·½¡£ËûÒª×öÒ»¸ö¾ö¶¨£¬¾ö¶¨×Ô¼ºÎ´À´µÄÃüÔ˺ÍÀíÏë¡£ÕâÊÇ1996ÄêÒ»¸öÆÕͨµÄÏÂÎ磬¼¸¸öСʱǰ£¬Ëû¸ÕÓë±È¶û-¸Ç´Ä½áÊøÁËÒ»´ÎÓä¿ìµÄÎç²Í£¬Í¬ÎªÈí¼þ½çµÄ¾«Ó¢£¬ËûÃÇÏà̸Éõ»¶£¬¸Ç´Ä¸øËû¿ª³öÈý°ÙÍòÒÔÉϵÄÄêнºÍÊýÍò¹ÉµÄ΢Èí¹ÉƱ¡£ÕâÊÇÒ»¸öÓÕÈ˵ÄÌõ¼þ£¬µ«¸üÖØÒªµÄÊÇ£¬¸Ç´ÄÐíŵËû¿ÉÒÔÓгä·ÖµÄʱ¼äºÍ×ÊԴͶÉí×Ô¼º¸ÐÐËȤµÄ¼¼Êõ·½Ïò¡£
AndersÔÚÓÌÔ¥£¬ËûÊÇ·ñÕæµÄÒªÀ뿪ÒѾ¹¤×÷ÁËÊ®ÈýÄêµÄBorland¡£´ÓTurbo Pascal¡¢SideKickÔÙµ½Delphi£¬BorlandÊÇAnders»Ô»ÍµÄÆðµã£¬ËûÔÚÕâÀï³ÉΪÈËÃǾ´ÑöµÄÈí¼þ´óʦ£¬²¢Ò»ÊÖÖý¾ÍÁËBorland´«Æ棻ÔÚBorland£¬AndersÓÐÌ«¶àÃÀºÃµÄ»ØÒäºÍδÍê³ÉµÄÀíÏë¡£
Anders Hejlsberg
È»¶ø£¬Ëæ×Å1994ÄêPhilippe Kahn£¨Borland¹«Ë¾´´Ê¼ÈË£©µÄÀëÈ¥£¬Anders½¥½¥Ê§È¥ÁË×îÇ¿ÓÐÁ¦µÄÖ§Ô®£»BorlandµÄÐÂÈÎCEO Delbert YocamÏ£Íû¼ÓÇ¿DelphiÔÚIDEÊг¡µÄÍõÕßµØ룬ÒòΪDelphi²ÅÊÇBorland×îÖ÷ÒªµÄ²ÆÎñÀ´Ô´£»µ«AndersÒѾ¿´µ½JavaºÍÐéÄâ»úÓïÑÔµÄDZÁ¦£¬ÓëÆäÔÚÒÑÓеIJúÆ·ÉÏÅÇ»²²»Ç°£¬Ëû¸üÏëרעÓÚвúÆ·Borland Java£¨ºóÀ´µÄJBuilder£©µÄÑз¢£»BorlandµÄ¹ ......
Anders Hejlsberg(°²µÂ˹-º£É²©¸ñ) ×øÔÚ×Ô¼ºµÄ°ì¹«ÊÒ£¬Ë«ÑÛÖ±Ö±µÄ¶¢×ÅÇ°·½¡£ËûÒª×öÒ»¸ö¾ö¶¨£¬¾ö¶¨×Ô¼ºÎ´À´µÄÃüÔ˺ÍÀíÏë¡£ÕâÊÇ1996ÄêÒ»¸öÆÕͨµÄÏÂÎ磬¼¸¸öСʱǰ£¬Ëû¸ÕÓë±È¶û-¸Ç´Ä½áÊøÁËÒ»´ÎÓä¿ìµÄÎç²Í£¬Í¬ÎªÈí¼þ½çµÄ¾«Ó¢£¬ËûÃÇÏà̸Éõ»¶£¬¸Ç´Ä¸øËû¿ª³öÈý°ÙÍòÒÔÉϵÄÄêнºÍÊýÍò¹ÉµÄ΢Èí¹ÉƱ¡£ÕâÊÇÒ»¸öÓÕÈ˵ÄÌõ¼þ£¬µ«¸üÖØÒªµÄÊÇ£¬¸Ç´ÄÐíŵËû¿ÉÒÔÓгä·ÖµÄʱ¼äºÍ×ÊԴͶÉí×Ô¼º¸ÐÐËȤµÄ¼¼Êõ·½Ïò¡£
AndersÔÚÓÌÔ¥£¬ËûÊÇ·ñÕæµÄÒªÀ뿪ÒѾ¹¤×÷ÁËÊ®ÈýÄêµÄBorland¡£´ÓTurbo Pascal¡¢SideKickÔÙµ½Delphi£¬BorlandÊÇAnders»Ô»ÍµÄÆðµã£¬ËûÔÚÕâÀï³ÉΪÈËÃǾ´ÑöµÄÈí¼þ´óʦ£¬²¢Ò»ÊÖÖý¾ÍÁËBorland´«Æ棻ÔÚBorland£¬AndersÓÐÌ«¶àÃÀºÃµÄ»ØÒäºÍδÍê³ÉµÄÀíÏë¡£
Anders Hejlsberg
È»¶ø£¬Ëæ×Å1994ÄêPhilippe Kahn£¨Borland¹«Ë¾´´Ê¼ÈË£©µÄÀëÈ¥£¬Anders½¥½¥Ê§È¥ÁË×îÇ¿ÓÐÁ¦µÄÖ§Ô®£»BorlandµÄÐÂÈÎCEO Delbert YocamÏ£Íû¼ÓÇ¿DelphiÔÚIDEÊг¡µÄÍõÕßµØ룬ÒòΪDelphi²ÅÊÇBorland×îÖ÷ÒªµÄ²ÆÎñÀ´Ô´£»µ«AndersÒѾ¿´µ½JavaºÍÐéÄâ»úÓïÑÔµÄDZÁ¦£¬ÓëÆäÔÚÒÑÓеIJúÆ·ÉÏÅÇ»²²»Ç°£¬Ëû¸üÏëרעÓÚвúÆ·Borland Java£¨ºóÀ´µÄJBuilder£©µÄÑз¢£»BorlandµÄ¹ ......
protected void BindData1()
{
OracleConnection orcn = new OracleConnection("User ID=wesoftwcp; Password=wesoft; Data Source=oradb");
orcn.Open();
string MyData = "";
StreamReader rs = new StreamReader(@"c:\1.txt");
MyData = rs.ReadToEnd();
rs.Close();
//OracleConnection orcn = new OracleConnection("User ID=wesoftwcp; Password=wesoft; Data Source=oradb");
//orcn.Open();
OracleType lobtype = OracleType.Clob; //Èç¹ûÊÇblobÕâÀï¸Ä³ÉOracleType.blob
string CreateTempBlob = "DECLARE A " + lobtype + "; " +
&n ......
protected void BindData1()
{
OracleConnection orcn = new OracleConnection("User ID=wesoftwcp; Password=wesoft; Data Source=oradb");
orcn.Open();
string MyData = "";
StreamReader rs = new StreamReader(@"c:\1.txt");
MyData = rs.ReadToEnd();
rs.Close();
//OracleConnection orcn = new OracleConnection("User ID=wesoftwcp; Password=wesoft; Data Source=oradb");
//orcn.Open();
OracleType lobtype = OracleType.Clob; //Èç¹ûÊÇblobÕâÀï¸Ä³ÉOracleType.blob
string CreateTempBlob = "DECLARE A " + lobtype + "; " +
&n ......