ãã1.æ·»å mysqlæ°æ®åºé©±å¨
ããå¯å¨netbeanså¼åå·¥å
·ï¼å¨services(æå¡)çªå£ä¸å±å¼databases(æ°æ®åº)èç¹ï¼å¤§å®¶å°±å¯ä»¥çå°ä¸ä¸ªæ°æ®åºçèµæºç®¡çå¨
å
¶ä¸å¨Driverså
ä¸å
å«äºæææ°æ®åºç驱å¨ç¨åºï¼å¦æè¦ä½¿ç¨netbeansæ¥æä½mysqlï¼å¿
éå¨è¿éæ·»å mysqlç驱å¨ç¨åºï¼å³é®åå» Drivers(驱å¨ç¨åº)èç¹ï¼ç¶åéä¸âNew Dirver...âå½ä»¤ï¼æå¼ä¸ä¸ªæ°å»ºJDBC驱å¨ç¨åºççªä½
å¨è¿ä¸ªæ°å»ºå¯¹è¯æ¡ä¸éæ©add(æ·»å )æé®ï¼éæ©ä½ è¦æ·»å ç驱å¨(mysqlæ°æ®åºé©±å¨mysql-connector-java-3.1.3-beta-bin.jar)ï¼æ·»å ç¡®å®ånetbeansä¼èªå¨å¡«åDrivers Class:(com.mysql.jdbc.Driver)åNameææ¬è¾å
¥æ¡ï¼ç¶åæå»Okï¼å®ææ°æ®åºé©±å¨ç¨åºå¨netbeansä¸çé
ç½®ã
ã2.éè¿netbeansè¿æ¥mysqlæ°æ®åº
ããåé¢å·¥ä½é½å好åï¼æ们å¯ä»¥ç¨netbeanså½mysqlç客æ·ç«¯æ¥æä½mysqlæ°æ®åºãå³å»databases(æ°æ®åº)èç¹ï¼éæ©ânew connection ...â(æ°å»ºä¸ä¸ªè¿æ¥)é项ï¼å¼¹åºå¦ä¸çé¢ï¼å
¶ä¸name(å称)为ä¸é¢é
好çæ°æ®åºé©±å¨çå称ï¼host(主æº)为mysqlæ°æ®åºç计ç®æºåæè
ipå°åï¼port为mysqlç端å£å·ï¼é»è®¤ä¸º3306;database为è¦è¿æ¥çæ°æ®åºçåå(å¦yang为æ¬äººå»ºç«çæ°æ®åº)ï¼ç¶åè¾å
¥æ°æ®åºç ç¨æ·ååå¯ç ï¼åå»OK(ç¡®å®)æé®
ãå®æåï¼å°å¨databases(æ°æ®åº)èç¹ä¸å¤åºä¸é¡¹æ们èªå·±åæ·»å çæ°æ®åºï¼å³å»å®ï¼ç¶åéæ©connect(è¿æ¥)ï¼å°ä¼æå¼æ们è¦è¿æ¥çmysqlæ°æ®åºã
ãå
¶ä¸Tablesæ¯yangè¿ä¸ªæ°æ®åºä¸æ建ç表ï¼Views为è§å¾ï¼procedures为åå¨è¿ç¨ï¼å¨è¿éæ们å¯ä»¥ç´è§ççå°æ°æ®åºçç»æï¼æ们å¯ä»¥éè¿netbeans对mysqlæ°æ®åºè¿è¡åç§æä½ã
ãã3ãæä½æ°æ®åº
ããå¦æè¦æ¥çperson表ä¸çæ°æ®ï¼å¯ä»¥å³é®åå»personï¼éæ©view data(æ¥çæ°æ®)é项ï¼é©¬ä¸æ¾ç¤ºç»åçªä½ï¼ä¸é¢ä¸ºsqlç¼è¾å¨
ãè¿éæ们è½å¤æ¸
æ¥çå°person表ä¸æ2æ¡æ°æ®ï¼å½ç¶æ们ä¹å¯ä»¥å¨ä¸é¢çSQLç¼è¾å¨å½ä¸ç¼åsqlè¯å¥æ¥è¯¢æ们æéè¦çæ°æ®ï¼å¨è¿éæ们å¯ä»¥åå¾å¤å½ä»¤è¡ä¸æä½mysqlæ°æ®åºåè½çæä½ã
温馨提示:答案为网友推荐,仅供参考