ÓÐÒ»¸öjsÎļþ£¬ÊÇʵÏÖÎÄ×Ö¹ö¶¯µÄ£¬ÆäÖеıäÁ¿ÐèÒªµ½mysqlÊý¾Ý¿âÖжÁÈ¡£¬ÄÇôÔõÑùʵÏÖÊý¾Ý¿âÁ¬½Ó¶ø¶ÁÈ¡Êý¾Ý£¿
ÎÒÊDzËÄñ£¬×îºÃÓÐÍêÕûµÄ´úÂëºÍ½âÊÍ£¬Ð»Ð»¸÷λ´óϺ°¡°¡°¡°¡°¡°¡£¡£¡£¡
http://blog.csdn.net/jemlee2002/archive/2009/08/23/4474906.aspx
ÕÒÒ»ÕÒASP°É£¬²»ÒªËµÊÇʹÓÃJSÁ´½ÓµÄ£¬ÒòΪJS×î»ù±¾µÄÎļþ²Ù×÷¶¼²»ÔÊÐ ......
²»ÊÇ»¹ÓÐsybase paradox sqllite µÈµÈ
Ö»¼û¹ýwinformÓÃÕâЩºÃ¼ûµÃÊý¾Ý¿â
asp.netÃ²ËÆÖ»ÓÐÈËÓÃaccess mssql mysql
Ë˵µÄ£¬ÏÖÔÚÖ÷Á÷ÊÇmssqlºÍoracle
oracleµÄ·¹ý~
΢Èí¼ÒµÄ£¬µÁ°æµÄ~~~~~~
΢Èí×Լҵģ¬Ö§³Ö±È½ÏºÃ£¬ÓÃÆðÀ´·½±ã
mssql
ÏÖÔÚÖ÷Á÷µÄÊý¾Ý¿âÓÐMSSQL ORACLE ¼°IBM¹«Ë¾µÄ ÖÁÓÚÆäËüÊý¾Ý¿â ³öÓÚ ......
ÎÒ½¨µÄÊÇJava Application£¬°ümysql-connector-java-5.1.10-binÒ²µ¼½øÈ¥ÁË£¬ÎªÊ²Ã´»¹ÊdzöÏÖÕâÖÖÇé¿ö£¿£¿
Exception in thread "main" org.hibernate.HibernateException: JDBC Driver class not found: com.mysql.jdbc.Driver
at org.hibernate.connection.DriverManagerConnectionProvider.configure ......
Example code
SQL code:
create table t(idx int,cname varchar(30));
insert into t values(1,'a');
insert into t values(2,'b');
insert into t values(3,'c');
select * from tµÄ½á¹ûÕâÑù
SQL code:
mysql> select * from t;
+------+-------+
| idx | cname |
+------+-------+
| ......
ÇómysqlµÄÒ»¸ö¼òµ¥sqlÓï¾ä
id locate
1 11,1,111,2
2 111,22,33
3 1£¬11£¬23
....
ÒªÇó£¬ÎÒÏëÈ¡µÃlocateÖÐÓÐ11µÄÊý¾Ý£¨1£¬3Êý¾Ý£©£¬µ«ÊÇÓÃlikeµÄ»°Á¬µÚ¶þ¸öÊý¾ÝÒ²µÃµ½ÁË£¬¸ÃÔõô°ìÄØ£¿Õâ¸ösql¸ÃÔõÃ´Ð´ÄØ£¿
select ......
´ò¸ö±È·½ OracleÖÐÕâôдµÄÓï¾ä
select a.x,
b.y,
c.z
from a,
b,
c
where a.x=b.x(+)
and a.y=b.y(+)
and a.z=c.z(+)
ÔÚmysqlÖÐÈçºÎд£¿
select d.x, ......