login.aspx.vb:
Public ReadOnly Property nameT() As String
Get
Return TextBox1.Text
End Get
End Property
Protected Sub Button1_Clic ......
¸÷λ´óÏÀ£¬ÏÖÓÐÒ»ÄÑÌâÇó½Ì£º¼ÙÉèÊý¾Ý¿â£¨mysql»òoracle¡¡µÈÊý¾Ý¿â£©°²×°ÔÚLINUXϵͳµÄ·þÎñÆ÷ÉÏ£¬ÎÒÔÚ¿Í»§¶Ë£¨windowsϵͳ£©ÓÃVBÈçºÎ½¨Á¢ÓëÊý¾Ý¿âµÄÁ¬½Ó£¬ÊÇ·ñ¿ÉÒÔʹÓÃÀàËÆADO»òDAOµ±ÖеÄÁ¬½ÓÓï¾ä£¿ÇëÄÄλ´óÏÀÖ¸µ¼Ò»Ï£¬Ô½ÏêϸԽºÃ£¬ÏÈлÁË£¡£¡£¡×îºÃÄÜÓÐÀý×Ó˵Ã÷¡£
¿ÉÒÔ£¬Ö»ÐèÒªÊý¾Ý¿â¿ª·ÅÔ¶³ÌÁ¬½ÓµÄȨÏÞ£¬°ÑÁ¬½ÓÀïÃæµÄl ......
¸÷λ´óÏÀ£¬ÏÖÓÐÒ»ÄÑÌâÇó½Ì£º¼ÙÉèÊý¾Ý¿â£¨mysql»òoracle¡¡µÈÊý¾Ý¿â£©°²×°ÔÚLINUXϵͳµÄ·þÎñÆ÷ÉÏ£¬ÎÒÔÚ¿Í»§¶Ë£¨windowsϵͳ£©Óà VBÈçºÎ½¨Á¢ÓëÊý¾Ý¿âµÄÁ¬½Ó£¬ÊÇ·ñ¿ÉÒÔʹÓÃÀàËÆADO»òDAOµ±ÖеÄÁ¬½ÓÓï¾ä£¿ÇëÄÄλ´óÏÀÖ¸µ¼Ò»Ï£¬Ô½ÏêϸԽºÃ£¬ÏÈлÁË£¡£¡£¡×îºÃÄÜÓÐÀý×Ó˵Ã÷¡£
¿ÉÒÔ£¬²»¹ýÄãÒªÏÈ°²×° oracle »òÕß mysql µÄODBCÇý¶¯Ô ......
¸÷λ´óÏÀ£¬ÏÖÓÐÒ»ÄÑÌâÇó½Ì£º¼ÙÉèÊý¾Ý¿â£¨mysql»òoracle¡¡µÈÊý¾Ý¿â£©°²×°ÔÚLINUXϵͳµÄ·þÎñÆ÷ÉÏ£¬ÎÒÔÚ¿Í»§¶Ë£¨windowsϵͳ£©Óà VBÈçºÎ½¨Á¢ÓëÊý¾Ý¿âµÄÁ¬½Ó£¬ÊÇ·ñ¿ÉÒÔʹÓÃÀàËÆADO»òDAOµ±ÖеÄÁ¬½ÓÓï¾ä£¿ÇëÄÄλ´óÏÀÖ¸µ¼Ò»Ï£¬Ô½ÏêϸԽºÃ£¬ÏÈлÁË£¡£¡£¡×îºÃÄÜÓÐÀý×Ó˵Ã÷¡£
ÕâÀàÊý¾Ý¿âserver²»¹Ü×°µ½Ê²Ã´Æ½Ì¨£¬Í¨Ñ¶ÐÒ鶼²»»á±ä ......
INSERT INTO StudAchieve(studID,studName)
VALUES('2','abc'),('2','bcd'),('2','cde')
Æ´ÁË°ëÌìÒ²²»¶Ô£¬¼°°¡ ¡£¡£¡£¡£
SQL code:
INSERT INTO StudAchieve(studID,studName)
select '2','abc'
union all select '2','bcd'
u ......
SELECT Count(*) from In_fo WHERE Reader_Time between #" + time1 + "# AND #" + time2 + "# and id=" + userid + ";
ÉÏÃæÊÇÎÒдµÄsqlÓï¾ä Reader_TimeÊÇʱ¼äÀàÐÍ idΪÊý×Ö
µ±ÎÒÓÃOleDbDataReaderÖ´ÐдËÓï¾äʱ»á³öÏÖ ¡°´Ó×Ö·û´®¡°SELECT Count(*) from In_fo ¡±µ½ÀàÐÍ ......