mySqlÊý¾Ý¿âÁ¬½Ó
Class.forName("com.mySQL.jdbc.Driver");
String strUrl="jdbc:mysql://localhost:3306/stu?useUnicode=true&characterEncoding=GB2312";
String strUser="nuey";
String strPassword="password";
Connection conn=DriverManager.getConnection(strUrl, strUser, strPassword);
Statement rs=conn.createStatement();
String strSqlInsert="insert into tblScore (Name,Class,Score) values ('"+strName+"','"+strClass+"','"+strScore+"')";
int iResult=rs.executeUpdate(strSqlInsert);
if(iResult!=0)
{
out.println("Ìí¼Ó³É¹¦£¡");
}
else
{
out.println("Ìí¼Óʧ°Ü£¡");
}
µ¼Èëjar°ü£¬È»ºóÔõôµ÷ÊÔ¶¼ÊdzöÏÖ
java.lang.ClassNotFoundException: com.mySql.jdbc.Driver£¬
Ö´Ðе½µÚÒ»²½¾Í³ö´í£¬
ÉÏmysqlÍøÕ¾ÏÂ×îеÄÇý¶¯£¬»¹ÊDz»ÐУ¬
ÓôÃÆÖ®¼«£¬×îºó·¢ÏÖʱ´óСдµÄÎÊÌ⣬
µÚÒ»¾äÓ¦¸ÃÊÇ
Class.forName("com.mysql.jdbc.Driver");
Ïà¹ØÎĵµ£º
1.Ëü¿ÉÒÔ±»·ÖΪÈýÀࣺÊý×ÖÀàÐÍÈÕÆÚÀàºÍʱ¼äÀàÐÍ£¬×Ö·û´®ÀàÐÍ¡£
ÁÐÀàÐÍÓÃÓÚÃèÊö:
M£ºÖ¸³ö×î´óµÄÏÔʾ³ß´ç¡£×î´óµÄºÏ·¨ÏÔʾ³ß´çΪ255.
D£ºÊÊÓÃÓÚ¸¡µãÀàÐͲ¢Ö®³õ¸úËæÔÚÊ®½øÖÆСÊýµãºóµÄÊýÂëµÄÊýÁ¿¡£×î´óµÄ¿ÉÄÜÖµÊÇ30£¬µ«ÊDz»Ó¦´óÓÚM.
2.·½À¨ºÅ("[","]")Ö¸³ö¿ÉÑ¡µÄÀàÐÍÐÞÊηûµÄ²¿·Ö£®
£ªÈôÖ¸¶¨ÁËÁÐÀàÐÍΪZEROFILL,MYSQL½«¸Ã ......
MySQL ÃüÁîÐÐ
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈ ......
groupadd mysql
н¨Ò»¸öÃûΪmysqlµÄÓû§×é
useradd -g mysql mysql
ÔÚmysqlÓû§×éÏÂн¨Ò»¸öÃûΪmysqlµÄÓû§
gunzip ½âѹÏÂÔص½µÄ.gzÎļþ
cd mysql-VERSION
½øÈë½âѹºóµÄĿ¼
CFLAGS="-O3 -mcpu=pentium4" CXX=gcc CXXFLAGS="-O3 -march=pentium4 -felide-constructors -fno-exceptions -fno-rtti" ./configu ......