MYSQL ·ÖÒ³Óï¾ä
+------+------+-------+
| id | name | bumen |
+------+------+-------+
| 2400 | a | 1 |
| 2300 | b | 1 |
| 2200 | a | 2 |
| 2200 | b | 2 |
+------+------+-------+
´ÓµÚ3¸ö¿ªÊ¼µ½µÚ4¸ö ¸ù¾ÝID ×ܹ²È¡³ö2¸öÊý¾Ý
զд£¿
SQL sever 2000ºÍ MYSQL²î±ðÕæ´ó
Ïà¹ØÎÊ´ð£º
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
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: ......
try
{
sql::Driver *driver;
sql::Connection *con;
//´´½¨Á¬½Ó
driver = get_driver_instance();
con = driver->connect("tcp://192.168.18.52:3306", "root", "1234 ......
mysqlÖÐÓм¸¸ö×Ö¶Î
id
name
img(ÒÔ¶þ½øÖƵķ½Ê½´æÈëmysqlÖÐ)
ÎÒÄܹ»µ¥¶À¶ÁȡͼƬ(Ö»ÄܶÁÈ¡ÆäÖÐÒ»¸öͼƬ)
µ«Êǵ±ÎÒ°ÑËùÓÐÐÅÏ¢¶¼·Åµ½requestÖеÄʱºò
ͼƬÄܶÁÈ¡³öÀ´µ«ÊÇÆäËû¶«Î÷£¨name,id£©È´¶Á²»³öÀ´
(
¶ÁÈ¡ ......
ÇëÎÊ
Ìí¼ÓÐÂÊý¾ÝÔ´->Êý¾Ý¿â->Ìí¼ÓÁ¬½Ó
Õâ¸ö½çÃæÏ£¬Êý¾ÝÔ´Ñ¡Ôñ£ºMicrosoft SQL Server (SqlClient)£»
·þÎñÆ÷Ãû£º
Ó¦¸ÃÐ´Ê²Ã´ÄØ£¿
ÓÐËÖªµÀ£¿¶àл¸÷λ£¡£¡
Äãµ½µ×ÊÇÒªÁ¬mysql»¹ÊÇmssql£¿
ÒýÓÃ
ÇëÎÊ
......