access db
class Program
{
static void Main(string[] args)
{
String conStr = "Data Source=mesqas;User ID=ctdsp_oee;Password=12345678";
OracleConnection con = new OracleConnection(conStr);
try
{
con.Open();
OracleCommand com = con.CreateCommand();
com.CommandText = "select * from temp";
OracleDataReader read = com.ExecuteReader();
while (read.Read())
{
Console.WriteLine(read.GetString(1));
}
Console.ReadLine();
read.Close();
Ïà¹ØÎĵµ£º
9.3 ͨ¹ýPHP²Ù×÷AccessÊý¾Ý¿â
9.3.1 Á¬½ÓAccessÊý¾Ý¿â
ÔÚPHPÖÐÁ¬½ÓAccessÓÐÈçÏÂ3ÖÖ·½Ê½¡£
£¨1£©´´½¨ÏµÍ³Êý¾ÝÔ´£¬ÓÃPHPÌṩµÄODBCº¯Êý
¼´¿É¡£
£¨2£©Í¬Ñù¿ÉÒÔʹÓÃPHPµÄODBCº¯Êý£¬µ«²»´´½¨
Êý¾ÝÔ´¡£¿ª·ÅÊý¾Ý¿âÁ¬½Ó£¨Open DateBase
Conection£¬ODBC£©ÊÇWindows Open
Server£¨¿ª·Å·þÎñ£©API£¨WOSA£©²úÆ·Ö®Ò ......
Ìõ¼þ½ÓÊÕϵͳ £¨CAs:Conditional Access System£©
¡¡¡¡ÓÐÌõ¼þ½ÓÊÕϵͳ£¨CAS£©ÊÇ¿ªÕ¹¸¶·ÑµçÊӵĺËÐļ¼Êõ£¬Á˽âËüµÄÔËÐлúÖÆ£¬ÕÆÎÕºÃËüµÄʹÓúÍά»¤¶Ô¸¶·ÑµçÊÓÒµÎñµÄ³É¹¦¿ªÕ¹·Ç³£¹Ø¼ü¡£CASµÄ×é³É°üÀ¨ÓУºÓû§¹ÜÀíϵͳSMS¡¢ÒµÎñÐÅÏ¢Éú³ÉϵͳSIG¡¢½ÚÄ¿¹ÜÀíPMS/SI±à¼ÏµÍ³¡¢½ÚÄ¿µ÷¶È´¦ÀíEIS¡¢Óû§ÊÚȨ¹ÜÀíϵͳSAS¡¢Ìõ¼þ½ÓÊÕCAµÈ ......
ÕâÒ»´ÎÀ´¼òµ¥½éÉÜÒ»ÏÂÎÒÔÚѧϰÖÐÓöµ½µÄÒ»¸öÎÊÌ⣬ÎÒÏÈÃèÊöһϣ¬È»ºó¿´²Ù×÷(ÉùÃ÷Ò»µã£ºÕâÒ»´ÎÎÒûÓаÑÕâ¸öÎÊÌâ½â¾öµô£¬Ï£ÍûÓÐÈ˰ïÎÒ½â´ð)
-------------------------------------------------------------------------
»·¾³£ºwin2003 tomcat6 jsp»·¾³
ÎÒʹÓÃaccess2003×öÊý¾Ý¿â£¬Êý¾ÝÔ´ÒѾÅäÖúã¬Á¬½ÓÊý¾Ý ......
ÓÉÓÚ³ÌÐòÐèÒª°ÑSQL SERVER ÀïµÄÊý¾Ýµ¼Èëµ½ACCESSÀï.
¸Õ¿ªÊ¼Ê¹ÓÃDataSetÀ´Ñ»·.
Êý¾ÝÁ¿ÉÙµÄʱºò»¹Ëã¿ÉÒÔÓ¦¸¶µÄ¹ýÀ´.
µ«µ±Êý¾Ý¶àµÄʱºò.
»á±¨´í"λÖôíÎó"
ÔÚÍøÉÏËÑѰһ·¬.ÕÒµ½Ò»¸ö·½·¨.
ʹÓÃinsert into openrowset
½Ó×Å´íÎóÒ»¸ö½ÓÒ»¸öµÄÀ´..
"²åÈë´íÎó: ÁÐÃû»òËùÌṩֵµÄÊýÄ¿Óë±í¶¨Ò岻ƥÅä¡£"
"δÄÜÕÒµ½ OLE DB Ì ......