MySQLÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql
ÎÞͼÎÞÕæÏà
²»ºÃÒâ˼£¬Í¼Ã»´«ÉÏÀ´£¿ ÖØ·¢ÁËÒ»±é¡£
windows server 2003ϵͳ
´íÎóÌáʾÈçÏ£º
uhandled exception has occurr in your application£¬If you Click countie£¬the
application will ignore this error and attempt to countie£¬If Click quite£¬the
application will close immediately¡£
MySQLdriveCS exception £ºMySQLdriveCS Error£ºCan't connect.Can't create new
thread £¨errno 12£©if you not out of available memory£¬you can consult the
manual for a possible OS-dependent bug.
ÕâÊÇʲôÎÊÌ⣬ÈçºÎ½â¾ö£¿
ʲôÇé¿öϳöÏÖÕâÖÖ¹ÊÕÏ£¿
ÎÞ·¨°²×°£¿ °²×°Õý³££¬ÎÞ·¨Æô¶¯£¿ Æô¶¯Õý³£ÎÞ·¨Á¬½Ó£¿ £¿£¿£¿
ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©
²¹³ä£º°²×°£¬Æô¶¯£¬Á¬½ÓÕý³££¬
¾ÍÊÇÔÚ Ó¦ÓóÌÐòÔËÐÐʱ£¨Ó¦ÓóÌÐòÐè²»¶Ï¶ÁÈ¡£¬¸üÐÂ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: ......
CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
(FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......
ÇëÎÊ
Ìí¼ÓÐÂÊý¾ÝÔ´->Êý¾Ý¿â->Ìí¼ÓÁ¬½Ó
Õâ¸ö½çÃæÏ£¬Êý¾ÝÔ´Ñ¡Ôñ£ºMicrosoft SQL Server (SqlClient)£»
·þÎñÆ÷Ãû£º
Ó¦¸ÃÐ´Ê²Ã´ÄØ£¿
ÓÐËÖªµÀ£¿¶àл¸÷λ£¡£¡
Äãµ½µ×ÊÇÒªÁ¬mysql»¹ÊÇmssql£¿
ÒýÓÃ
ÇëÎÊ
......
ÎÒÏÖÔÚÏëÓÃJSPʵÏÖQQÓÊÏäÀïµÄ¶¨Ê±·¢ËÍ£¬ÎÒÏëͨ¹ýÊý¾Ý¿â½øÐж¨Ê±²åÈëÊý¾Ý¡£
µ«²»ÖªµÀÈçºÎʵÏÖ£¬»òÕß´ó¼ÒÓиüºÃµÄ·½·¨£¬²»Ò»¶¨ËµÊÇÊý¾Ý¿â¡£
Çë´ó¼Ò¸øµãÒâ¼û£¬°ÝлÀ²¡£
quataz¶¨Ê±Æ÷×é¼þÊǸöºÜºÃµÄ½â¾ö·½°¸¡£
È ......
CREATE PROCEDURE dowhile()
BEGIN
DECLARE v1 INT DEFAULT 5;
WHILE v1 > 0 DO
SET v1 = v1 - 1;
END WHILE;
END
ÎÒÔËÐÐmysql°ïÖúÀïÃæµÄ³ÌÐò»á±¨´í£¬²»ÖªµÀΪʲô£¬Çë ......