ÇëÎÊMyEclipseÈçºÎÅäÖÃMySqlµÄÇý¶¯Îļþ
ÎÊÌ⣺µ±Ê¹ÓÃEditPlusÔËÐÐjava³ÌÐòʱ£¬ÌáʾÎÞ·¨ÕÒµ½Çý¶¯£º com.mysql.jdbc.Driver
¶øµ±ÎÒ°ÑÇý¶¯£¨mysql-connector-java-3.1.10-bin.jar£©Ìí¼Óµ½»·¾³±äÁ¿
classpathÖУ¨D:\java\javahomework\mysqlDriver\mysql-connector-java-3.1.10-bin.jar£©
ºóÔÙ´ÎÔËÐиÃjava³ÌÐò,½á¹ûÈÔÈ»ÎÞ·¨ÕÒµ½¸ÃÇý¶¯¡£ºóÀ´ÎÒÖ»ºÃ°ÑÔËÐгÌÐòд³ÉÒ»¸öcmdÃüÁ
ÔÚÃüÁîÖÐÖ¸¶¨¸ÃÇý¶¯µÄ¾ßÌåλÖ㬳ÌÐò·½¿ÉÕý³£ÔËÐС£
cmdÃüÁîÈçÏ£º
set CLASSPATH=%CLASSPATH%;D:/java/javahomework/mysqlDriver/mysql-connector-java-3.1.10-bin.jar
java BooksellManagementSystem
cmd
µ±ÎÒÓÃMyEclipseÔËÐгÌÐòʱ£¬ÈÔÓöµ½ÏàͬÎÊÌâ--ÎÞ·¨ÕÒµ½Çý¶¯¡£ÇëÎÊMyEclipseÈçºÎÅäÖøÃMySqlµÄÇý¶¯Îļþ
ÎÒµÄ×ÊÔ´ÀïÓб¾ myEclipse ¿ª·¢ÖÐÎĽ̡̳£¹ØÓÚ¸÷¸öÊý¾Ý¿âÇý¶¯°üµÄ°²×°ÅäÖýéÉܵĺÜÏêϸ¡£Í¼ÎIJ¢Ã¯¡£Â¥Ö÷¿ÉÒÔÈ¥¿´¿´¡£
Äã¼ÓÈëÁËjar°ü£¬µ«±àÒëµÄʱºòÒý½øÀ´Ã»Óа¡£¿
ÎÒÒѾÔÚMyEclipseÖÐÒýÓÃÁËMySqlµÄÇý¶¯Îļþ£¬ÎªºÎϵͳÈÔÈ»ÌáʾCannot load JDBC driver class 'com.mysql.jdbc.Driver' ÄØ£¿
ÊÊÓû·¾³ Win2003 Server +Server2005
Sql Server2005Êý¾Ý¿â
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url= "jdbc:sqlserver://localhost:1433;databaseName=dbName;user=sa;password=";
ʹÓÃjtds°ü·ÃÎÊSql Server:
Driver---net.sourceforge.jtds.jdbc.Driver
URL------jdbc:jtds:<server_type>://<server>[:<port>][/<database>][;<property>=<value>[;...]]
¡¡¡¡
URLÀýÈ磺j
Ïà¹ØÎÊ´ð£º
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿
ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ
¿ÉÒÔÓÃÈ ......
´ó¼Ò°ïÎÒ¿´Ï°ɣ¬±¾À´Êý¾Ý¿âûÓж«Î÷£¬ÄÜÏÔʾûÓж«Î÷µÄÐÅÏ¢£¬µ«ÊÇÎÒÌí¼ÓÁËÒ»ÌõÄÚÈݺó£¬×ÖûÁË£¬µ«ÊÇͼƬҲÎÞ·¨ÏÔʾ£¬ºì²æ²æÒ²Ã»ÓУ¬Ôõô»ØÊ°¡£¿
PHP code:
<?php
$str="select * from product wh ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
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 ......