mysqlÔõôµ÷ÊÔ´æ´¢¹ý³Ì
ÈçÌ⣬ллÁË
ÃüÁîÐд°¿Ú¡£
ÃüÁîÐд°¿ÚÔõôµ÷ÊÔ£¿ÄÜ˵¾ßÌåµãô£¿
Äã¾Í°Ñ´æ´¢¹ý³Ì´úÂë¸´ÖÆµ½ÃüÁîÐд°¿ÚÖÐÖ´Ðа¡£¡ÓдíÎó¾Í»áÓÐÌáʾµÄ¡£
¹Ø¼üÊÇûÓдíÎó µ«Êǽá¹ûÓÐ´í ¿ÉÄÜÊÇÄÄÀïÂ߼дµÄÓÐÎÊÌâ ÎÒÏëÓÐûÓÐÏñplsqlÀïÒ»ÑùÄܵ¥²½µ÷ÊÔÖ®ÀàµÄ
ÕâÑù¿ÉÒԺܷ½±ã
1¡¢ÔÚMYSQLÃüÁîÐÐÖÐÊäÈëSP´úÂ룬ÔÙµ÷Óã»
2¡¢ÔÚͼÐλ¯¹ÜÀí¹¤¾ßÖÐÔËÐУ¬ÈçSQLYOGÖ®ÀàµÄ¡£
ÔÚÃüÁîÐÐϽøÈëmysqlµÄbinĿ¼£¬Ö´ÐÐmysql -h [localhost] -u [usename] -p ½øÈëÃüÁîÐпͻ§¶Ë£¬
ÓÃuse [databasename]ÃüÁî½øÈëҪʹÓà µÄÊý¾Ý¿â£¬Ê¹ÓÃcall [procedurename] [parameters]µ÷ÓÃÒÑÓеĴ洢¹ý³Ì½øÐе÷ÊÔ£¬»áÊä³öÄãÐèÒªµÄÐÅÏ¢µÄ¡££¨×¢£º[]ÄÚµÄÄÚÈÝÌæ»»³Éʵ¼ÊµÄÃû×Ö£©
ºÇºÇ лл¸÷λ ÎÒÊÇÏÂÔØÒ»¸öµ÷ÊÔ¹¤¾ß ºÜ·½±ã ʲôÐÅÏ¢¶¼Äܲ鿴 ÀàËÆplsqlµ÷ÊÔ´æ´¢¹ý³Ì
ÊǸö¹úÍâµÄÈí¼þ ºÜºÃÓà ¾ßÌåÃû×ּDz»µÃÁË
Ç¿ÁÒ½¨Òénavicat£¬²éѯ£¬´æ´¢¹ý³Ì¶¼ºÜ·½±ã£¡
»¶Ó·ÃÎÊ£ºwww.webgameexpress.com
Ïà¹ØÎÊ´ð£º
¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿
ÃÜÂëÐ޸ķ½·¨£º
1.ÒÔϵͳ¹ ......
ÎÒÔÚÇåÀímysqlµÄʱºò£¬Ò»²»ÁôÉñ½«mysql(¼´dataÀïµÄmysqlÎļþ¼Ð)Êý¾Ý¿â¸øÉ¾µôÁË£¬¸ôÁ˼¸¸öСʱÎÒÖØÆôÁËmysqlÈí¼þ£¬mysql¾Í×Ô¶¯³õʼ»¯ÁËÊý¾Ý¿â£¬µ¼Ö´Óɾ³ýmysqlÎļþ¼Ð¿ªÊ¼µ½ÖØÆôÕâ¶Îʱ¼äµÄÊý¾Ý¶ªÊ§£¬ÄÇλ¸ßÊÖ°ïÏëÏë°ì ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡¡µ½µ×¸Ãզд°¡
Íò·Ö¸Ðл£¡
String SQL=&q ......
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 ......