MYSQLÊý¾Ý»Ö¸´ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql
ÎÒĿǰÓÐÒ»·ÝMS SQLµÄÊý¾Ý±¸·Ý£¬ÒòΪ»»·þÎñÆ÷ÁË£¬ÄǸö·þÎñÆ÷ÉÏÓõÄMYSQL£¬Ïë°ÑÄǸö±¸·ÝÎļþÖ±½Ó»Ö¸´µ½MYSQLÖУ¬ÎÒ¸ÃÈçºÎ²Ù×÷£¬ÄÄλ°ïÏ£¬Ð»Ð»ÁË¡£
ÎÒÄǸöÊý¾Ý±¸·ÝÎļþÊÇ.bakµÄ£¬»¹ÓÐÒ»¸ö.sqlµÄÎļþÒ»ÆðµÄ¡£
лл¸÷룬ÓÃ°Ù¶È googleÁËһϣ¬ÕÒµ½¸ö´ó¸ÅµÄ·½·¨£¬ÏÈÔÝʱֻÄܰÑMSSQLÊý¾Ý»Ö¸´µ½MSÖÐÁË£¬ÔÙͨ¹ýNavicatתµ½MYSQL°É¡£»¹ÓÐÎÊÌâÎÒÔÙÀ´ÎÊ´ó¼Ò£¬Ð»Ð»°¡¡£
ºÇºÇ¡£GOOD LUCK¡¡
½áÌûÀ²£¬Ð»Ð»¸÷λ¡£
Ïà¹ØÎÊ´ð£º
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
String sqlCount="select count(*) from usertable where username='"+
userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡
Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ
select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......
1¡¢ÊDz»ÊÇPHPÖÐÖ»ÄÜʹÓÃmysql_query("update user_aa set money=money2-".$bpanmm." where uid=".$userppp);¸üÐÂÊý¾Ý£¿£¿£¿
2¡¢PHP¸üÐÂmysql_fetch_row($res)Óëmysql_fetch_array($res)ÖеÄÊý¾ ......
ÎÒÊǸöÐÂÊÖ£¬Íû¸ßÊÖ½â´ð
ÎÒÏÖÔÚÒѾ°²×°ÁËmysql£¬Ò²ÓÐmysqlµÄjdbc¡£µ«ÎÒÔõôÅäÖú󣬲ÅÄÜÔÚMyEclipseÀï²Ù×÷mysqlÄØ£¿Çë¸ßÊÖ˵Ïêϸµã
´ò¿ªMyeclipse----window---open perspective---MyEclipse database explorer-- ......