mysqlǰ̨ СÎÊÌâ - Java / JavaÏà¹Ø
ÓÃmysqlǰ̨Èí¼þ £¬ ÎÒÔÚtest¿âϽ¨¸ötable ¿ÉÊÇ ÀÏ·¢ÉúÒ»ÑùµÄÎÊÌâ £¬ ÎÒ°ÑÑ¡Ïî¶¼Ò»¸öÒ»¸ö³¢ÊÔÁË ¿É¶¼²»ÐÐ £¡
Çë ¸ßÊÖ½øÀ´½âÄÑ! ¼±£¡
Ìáʾ£º²»ÄÜð¤Ìù ÂÔ
ʲôÎÊÌâѾ£¿ËµÇå³ýÈü
ÓÉÓÚ²»ÄÜð¤Ìù ¾ßÌåÒ²ºÜÄÑ˵Çå³þ
ÏÖÔÚ Ö»ÏëÎÊ ÔÚmysql query browserÈí¼þ £¨MySQLǰ̨Èí¼þ£© ÈçºÎÔÚÒ»¸ö¿âÀï¼Ó±íµÄ¾ßÌå²Ù×÷£¡
ÄãÕâÊÇÔÚÃüÁîÐÐÀïÊäµÄ°É
ÎÒÔÚ Ç°Ì¨Èí¼þÀïÊä ¾Í»á²úÉú´íÎó
ÌáʾÊÇ £º ENGINE = .... ´íÎó
....´ú±í ÈκÎģʽ ¶¼²»ÐÐ ÎÒÊÔ¹ýÁË
ÄǸöÈí¼þÃûÊÇ MYSQL QUERY BROWSER
ÓÃÕâ¸ö°É
Navicat for MySQL
Ïà¹ØÎÊ´ð£º
ÎÒÔÚ javaºËÐļ¼ÊõÉÏ ¿´ÁËÒ»¸ö ÀûÓà Java socket emailµÄÀý×Ó ¿ÉÊÇÔõôҲ ²»³É¹¦ Ϊʲô£¿
Ô´Âë
Java code:
package cn.com.test.email;
import java.awt.GridBagLayout;
import java.awt.event.Action ......
String sqlCount="select count(*) from usertable where username='"+
userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡
Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ
select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......
ÓÐËÓÃjava×ö¹ý´òÓ¡·¢Æ±µÄ³ÌÐò£¬¸Ð¾õÕâ·½Ãæ²»ÊǺܺÿØÖÆ£¬Ï£Íû¸øµã½¨Ò飬×îºÃÄܸø³ö´úÂë
¼òµ¥µã¾Íµ÷ÓÃwindow.print()
ÄãÒ²¿ÉÒÔ°ÑÏÂÃæ´úÂë·Åµ½ÄãJSPÖÐ:
<html>
<head>
<title> ......
ÇëÎʸ÷λ¸ç¸ç½ã½ã£¬ÈçºÎÔËÓÃÏֳɵÄÄ£°åÀ´ÖÆ×÷ƯÁÁµÄJSPÍøÒ³Ñ½,»ØÕßÓзÖ!
×Ô¼º¶¥Ï£¬×ÜÓиßÊÖ°É,ÆÚ´ýÖÐ......
Èç¹ûÖ±½ÓÒýÓýøÈ¥
¿ÉÒÔÖ±½ÓÓÃjspµÄÖ¸ÁҲ¿ÉÒÔÓÃfreemarkÒýÓ㬼ǵøø·Ö
лл¸÷λÁË£¬¿´À´Î ......