¹ØÓÚʹÓÃÊÓͼȡ²»µ½¼Ç¼(Êý¾Ý¿âʹÓÃmysql)
ÔÚphpadminÖн¨Á¢ºÃÁËÒ»¸öÊÓͼroute1,È»ºóµã»÷SQL£¬ÊäÈëÓï¾ä£º
select * from route1 where startstop='¾ÅÁú' and endstop='8753²¿¶Ó';
ÔËÐÐͨ¹ý£¬·µ»ØÒ»Ìõ¼Ç¼¡£
ÏÖÔÚÎÒÏëÓô«²ÎÊýµÄ·½Ê½£¬ÔÚÒ³Ãæ±àдʼþʵÏÖ¶¯Ì¬²éѯ£¬ÎÊÌâÊǼ´±ãÓõÄÊǾ²Ì¬²éѯ·½Ê½£¬»¹ÊÇÈ¡²»µ½¼Ç¼£¡
ÈçÏ£º
mysql_connect("localhost","root","");
mysql_select_db("yangzheng");
mysql_query("set names utf8");
$re=mysql_query("select * from route1 where startstop='¾ÅÁú' and endstop='8753²¿¶Ó' ");
while($row=mysql_fetch_array($re, MYSQL_ASSOC)) {
echo("
" . $row["linename"] . "
");
}
Õâ¸öÊÂÇéÕæ¹îÒ죬»¹Íû¸ßÈËÖ¸µã¡£¡£¡£
ËäÈ»Õâ¸öÎÊÌâÎÒÒѾÊÂÏÈ×Ô¼º½â¾öÁË£¬µ«»¹ÊÇÒª½áÌù¸ø·Ö¡£ÖÁÉÙר¼ÒûÓÐ˵´í£¬ÎÒ¾ÍÊǸ͝ mysql_query("set names utf8"); ÕâÒ»¾äΪ mysql_query("set names gbk");Ö®ºóÔËÐÐͨ¹ýµÄ¡£
Ïòhelloyonu0Ö¾´¡£
Ïà¹ØÎÊ´ð£º
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿
ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ
¿ÉÒÔÓÃÈ ......
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
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 ......
ÈçÌâ
²¹³äÏ£º
ÎÞ³ÌÐò£¬¸øË¼Â·Ò²ÐУ»
1. ÏÈÅжÏ֮ǰµÄͬ²½ÊÇ·ñÍê³ÉÁË¡£ ###ÈçºÎÅжϣ¿
2. ½øÐÐCHANGE MASTER TO ²Ù×÷¡£###ÎÒÖªµÀ¿ÉÒÔÇл»³É±¸·Ý»ú£¬µ«ÊDz»ÖªµÀÈçºÎÇл»»ØÖ÷·þÎñÆ÷£¬
ÎÒµÄÓÊÏäÊÇdo ......
ÔÚmysqlµÄ½Å±¾Ä£Ê½Ï£¬-t±íʾÒÔ±í¸ñµÄÐÎʽÊä³ö½á¹û£¬Èç¹ûÐèÒªÖÆ±í·û¶¨½çµÄÊä³ö¿ÉÒÔÊ¡ÂÔ´ËÑ¡Ïî¡£ ÕâÑùµÄÊä³öÊǾßÓбí¸ñÐÎʽµÄÊä³ö£¬
Õâ¸öÊÇÊéÉÏ˵µÄ£¬Õâ¾ä»°ÊDz»ÊÇÓÐʲôÎÊÌ⣿
ÊDz»ÊÇÖÆ±í·ûºÍ±í¸ñÐÎʽ£¬²»ÊÇÒ»»ØÊ ......