Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ :

һƪ²»´íµÄ½²½âJavaÒì³£µÄÎÄÕÂ


±¾ÎÄÓɲ©Ö÷´Óhttp://www.blogjava.net/freeman1984/archive/2007/09/27/148850.html×ªÔØ£»Ô­Îijö´¦£¬²©Ö÷Ò²²»ÖªµÀ£¬Ï£Íû¶Ô´ó¼ÒÓеã°ïÖú......
ÁùÖÖÒì³£´¦ÀíµÄªϰ
Äã¾õµÃ×Ô¼ºÊÇÒ»¸öJavaר¼ÒÂð£¿ÊÇ·ñ¿Ï¶¨×Ô¼ºÒѾ­È«ÃæÕÆÎÕÁËJavaµÄÒì³£´¦Àí»úÖÆ£¿ÔÚÏÂÃæÕâ¶Î´úÂëÖУ¬ÄãÄܹ»Ñ¸ËÙÕÒ³öÒì³£´¦ÀíµÄÁù¸öÎÊÌâÂ𣿠
1 OutputStreamWriter out = ... 
2 java.sql.Connection conn = ... 
3 try { // ¢É 
4 ¡¡Statement stat = conn.createStatement(); 
5 ¡¡ResultSet rs = stat.executeQuery( 
6 ¡¡¡¡"select uid, name from user"); 
7 ¡¡while (rs.next()) 
8 ¡¡{ 
9 ¡¡¡¡out.println("ID£º" + rs.getString("uid") // ¢Ê 
10 ¡¡¡¡¡¡"£¬ÐÕÃû£º" + rs.getString("name")); 
11 ¡¡} 
12 ¡¡conn.close(); // ¢Ç 
13 ¡¡out.close(); 
14 } 
15 catch(Exception ex) // ¢Æ 
16 { 
17 ¡¡ex.printStackTrace(); //¢Å£¬¢È 
18 }
¡¡¡¡×÷Ϊһ¸öJava³ÌÐòÔ±£¬ÄãÖÁÉÙÓ¦¸ÃÄܹ»ÕÒ³öÁ½¸öÎÊÌâ¡£µ«ÊÇ£¬Èç¹ûÄã²»ÄÜÕÒ³öÈ«²¿Áù¸öÎÊÌ⣬Çë¼ÌÐøÔĶÁ±¾ÎÄ¡£ 
¡¡¡¡±¾ÎÄÌÖÂ۵IJ»ÊÇJavaÒì ......

¹ØÓÚJavaÄÚ´æÐ¹Â©

1 ÒýÑÔ
     JavaµÄÒ»¸öÖØÒªÓŵã¾ÍÊÇͨ¹ýÀ¬»øÊÕ¼¯Æ÷GC £¨Garbage Collection£©×Ô¶¯¹ÜÀíÄÚ´æµÄ»ØÊÕ£¬³ÌÐòÔ±²»ÐèҪͨ¹ýµ÷Óú¯ÊýÀ´ÊÍ·ÅÄÚ´æ¡£Òò´Ë£¬ºÜ¶à³ÌÐòÔ±ÈÏΪJava ²»´æÔÚÄÚ´æÐ¹Â©ÎÊÌ⣬»òÕßÈÏΪ¼´Ê¹ÓÐÄÚ´æÐ¹Â©Ò²²»ÊdzÌÐòµÄÔðÈΣ¬¶øÊÇGC »òJVMµÄÎÊÌâ¡£Æäʵ£¬ÕâÖÖÏë·¨ÊDz»ÕýÈ·µÄ£¬ÒòΪJava Ò²´æÔÚÄÚ´æÐ¹Â©£¬µ«ËüµÄ±íÏÖÓëC++²»Í¬¡£Èç¹ûÕýÔÚ¿ª·¢µÄJava ´úÂëҪȫÌì24 СʱÔÚ·þÎñÆ÷ÉÏÔËÐУ¬ÔòÄÚ´æÂ©¶´ÔÚ´Ë´¦µÄÓ°Ïì¾Í±ÈÔÚÅäÖÃʵÓóÌÐòÖеÄÓ°ÏìÒª´óµÃ¶à£¬¼´Ê¹×îСµÄ©¶´Ò²»áµ¼ÖÂJVMºÄ¾¡È«²¿¿ÉÓÃÄÚ´æ¡£ÁíÍ⣬ÔںܶàǶÈëʽϵͳÖУ¬ÄÚ´æµÄ×ÜÁ¿·Ç³£ÓÐÏÞ¡£ÔÚÏà·´µÄÇé¿öÏ£¬¼´±ã³ÌÐòµÄÉú´æÆÚ½Ï¶Ì£¬Èç¹û´æÔÚ·ÖÅä´óÁ¿ÁÙʱ¶ÔÏ󣨻òÕßÈô¸ÉÍÌÊÉ´óÁ¿ÄÚ´æµÄ¶ÔÏ󣩵ÄÈκÎJava ´úÂ룬¶øÇÒµ±²»ÔÙÐèÒªÕâЩ¶ÔÏóʱҲûÓÐÈ¡Ïû¶ÔËüÃǵÄÒýÓã¬ÔòÈÔÈ»¿ÉÄÜ´ïµ½Äڴ漫ÏÞ¡£
2 Java ÄÚ´æ»ØÊÕ»úÖÆ
     Java µÄÄÚ´æ¹ÜÀí¾ÍÊǶÔÏóµÄ·ÖÅäºÍÊÍ·ÅÎÊÌâ¡£·ÖÅäÄÚ´æµÄ·½Ê½¶àÖÖ¶àÑù£¬È¡¾öÓÚ¸ÃÖÖÓïÑÔµÄÓï·¨½á¹¹¡£µ«²»ÂÛÊÇÄÄÒ»ÖÖÓïÑÔµÄÄÚ´æ·ÖÅ䷽ʽ£¬×îºó¶¼Òª·µ»ØËù·ÖÅäµÄÄÚ´æ¿éµÄÆðʼµØÖ·£¬¼´·µ»ØÒ»¸öÖ¸Õëµ½ÄÚ´æ¿éµÄÊ×µØÖ·¡£ÔÚJava ÖÐËùÓжÔÏó¶¼ÊÇÔÚ¶Ñ£¨Heap£©ÖзÖÅäµÄ£¬¶ÔÏóµÄ´ ......

¼¼Êõ±¸Íü Ϊphp5ÅäÖÃmysql

ÏÖ´æÎÊÌ⣺
1.ÎÞ·¨¼ÓÔØ mcrypt À©Õ¹£¬Çë¼ì²éÄúµÄ PHP ÅäÖá£
°´ÕÕÍøÉÏ˵µÄ¸Ã×öµÄÃ²ËÆ¶¼×öÁË µ«ÊǵÚÒ»´Î´ò¿ªphpmyadminÖ÷ҳʱ »¹ÊÇÓÐÕâ¸öÌáʾ Ææ¹ÖµÄÊǽøÈ¥Ö®ºó ÀïÃæÃ»ÓÐÕâ¸öÌáʾ È»ºóÍ˳öÍâÃæÒ²Ã»ÁË
2.ÅäÖÃÎļþÏÖÔÚÐèÒªÒ»¸ö¶ÌÓïÃÜÂë¡£
ÍøÉÏÕÒÁË µ«ÊÇÎÊÌ⻹ÊÇû½â¾ö
×òÌìÎÊÌâÈ«²¿½â¾ö
ÒòΪÅäÖÃÎļþÃû³ÆÎ´¸Ä ÕýÈ·µÄÃû³ÆÊÇconfig.inc.php
Ê£ÓàÎÊÌ⣺
1.Á´½Ó±íµÄ¶îÍâÌØÐÔÉÐδ¼¤»î¡£Òª²é³öÔ­Òò£¬Çëµã»÷´Ë´¦¡£
2.ÄãµÄ PHP MySQL ¿â°æ±¾ 5.0.51a ºÍÄãµÄ MySQL ·þÎñÆ÷°æ±¾ 5.1.44 ²»Í¬¡£Õâ¿ÉÄÜÔì³ÉһЩδ֪µÄÎÊÌâ¡£ ......

mysqlʵÓÃÃüÁî

Ò») Á¬½ÓMYSQL£º
   ¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £­pÓû§ÃÜÂë
1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL
   Ê×ÏÈÔÚ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëmysql°²×°Ä¿Â¼ÏµÄbinĿ¼Ï£¬ÀýÈ磺 D:\mysql\bin£¬ÔÙ¼üÈëÃüÁîmysql -uroot -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂë
£¬Èç¹û¸Õ°²×°ºÃMYSQL£¬³¬¼¶Óû§rootÊÇûÓÐÃÜÂëµÄ£¬¹ÊÖ±½Ó»Ø³µ¼´¿É½øÈëµ½MYSQLÖÐÁË£¬MYSQLµÄÌáʾ·ûÊÇ£ºmysql>
2¡¢Àý2£ºÁ¬½Óµ½Ô¶³ÌÖ÷»úÉϵÄMYSQL
   ¼ÙÉèÔ¶³ÌÖ÷»úµÄIPΪ£º10.0.0.1£¬Óû§ÃûΪroot,ÃÜÂëΪ123¡£Ôò¼üÈëÒÔÏÂÃüÁ
   mysql -h10.0.0.1 -uroot -p123
  £¨×¢£ºuÓëroot¿ÉÒÔ²»Óüӿոñ£¬ÆäËüÒ²Ò»Ñù£©
3¡¢Í˳öMYSQLÃüÁî
   exit £¨»Ø³µ£©
(¶þ) ÐÞ¸ÄÃÜÂ룺
   ¸ñʽ£ºmysqladmin -uÓû§Ãû -p¾ÉÃÜÂë password ÐÂÃÜÂë
1¡¢Àý1£º¸øroot¼Ó¸öÃÜÂë123¡£Ê×ÏÈÔÚDOSϽøÈëĿ¼C:\mysql\bin£¬È»ºó¼üÈëÒÔÏÂÃüÁ
   mysqladmin -uroot -password 123
   ×¢£ºÒòΪ¿ªÊ¼Ê±rootûÓÐÃÜÂ룬ËùÒÔ-p¾ÉÃÜÂëÒ»Ïî¾Í¿ÉÒÔÊ¡ÂÔÁË¡£
2¡¢Àý2£ºÔÙ½«rootµÄÃÜÂë¸ÄΪ456
   mysqladmin -uroot -pab12 password 456
(Èý) Ôö¼ÓÐÂÓû§ ......

MySQLÑ§Ï°Ëæ±Ê1

²é¿´Êý¾Ý¿â°æ±¾  select version(), current_date();
ÏÔʾÊý¾Ý¿âÓà show databases;
Ñ¡Ôñij¸öÊý¾Ý¿âÓÃuse db_1;
´´½¨Êý¾Ý¿âÓÃcreate db_1;
²åÈëÊý¾ÝÓÃinsert into db_1 values(...);
ÏÔʾµ±Ç°Ñ¡ÔñµÄÊý¾Ý¿âÓÃselect database();
´´½¨±íÓÃcreate table tb_1 (...);
ÏÔʾËùÓбíÓÃshow tables;
ÏÔʾij¸ö±íµÄËùÓÐÄÚÈÝselect * from tb_1;
ÏÔʾÂú×ãÌõ¼þµÄij¸ö±íselect * from tb_1 where name = 'he';
ÏÔʾMySQLÉϵÄËùÓÐÓû§select user,host,password from mysql.user;
Ôö¼ÓÐÂÓû§£ºgrant ȨÏÞ on Êý¾Ý¿â.* to Óû§Ãû@µÇ¼Ö÷»ú identified by "ÃÜÂë"
ÀýÈ磺Ôö¼ÓÒ»¸öÓû§user1ÃÜÂëΪpassword1£¬ÈÃÆä¿ÉÒÔÔÚ±¾»úÉϵǼ£¬ ²¢¶ÔËùÓÐÊý¾Ý¿âÓвéѯ¡¢²åÈë¡¢Ð޸ġ¢É¾³ýµÄȨÏÞ¡£Ê×ÏÈÓÃÒÔrootÓû§Á¬Èëmysql£¬È»ºó¼üÈëÒÔÏÂÃüÁgrant select,insert,update,delete on *.* to user1@localhost Identified by "password1";
Èç¹ûÏ£Íû¸ÃÓû§Äܹ»ÔÚÈκλúÆ÷Éϵǽmysql£¬Ôò½«localhost¸ÄΪ"%"¡£
Èç¹ûÄã²»Ïëuser1ÓÐÃÜÂ룬¿ÉÒÔÔÙ´òÒ»¸öÃüÁÃÜÂëÈ¥µô¡£
grant select,insert,update,delete on mydb.* to user1@localhost identified by "";
¼òµ¥µÄÊýѧ¼ÆËã¼ÆËãÓÃÈçÏÂÃüÁ
mys ......

Tomcat+mysqlÁ¬½Ó³ØµÄÅäÖÃÓë²âÊÔ


»·¾³:
Tomcat6.0.18
Mysql: 5.1.36
Windwos XP sp2
×î½üÐèÒªÓõ½Tomcat+mysqlÁ¬½Ó³ØµÄÅäÖÃ,½ñÌìÔÚÍøÉϲéÁ˺öà×ÊÁÏ,ÀÏ×ÊÁÏÌ«¶à,¶ÔÓÚÒÔÉϵÄÀϰ汾tomcat¿ÉÄÜÓÐÓÃ,±¾ÈËûÓвâÊÔ¹ý,Õýȷд³ötomcat6.0ÅäÖõÄÎļäºÜÉÙ!ºÃ¶à×ÊÁÏÉÏÃæµÄÅäÖöÔÓÚÏÖÔÚаæµÄ¼¸ºõ¶¼ÊÇÓÐÎÊÌâµÄ,Ê®´íÆß°Ë!½ñÌì°ÑÎÒÅäÖõÄÕýÈ··½·¨Ð´ÏÂÀ´,¹©´ó¼Ò²Î¿¼!
1.°²×°tomcat,ÂÔ;
2.°²×°mysqlÂÔ,
½øÈëmysql,н¨Êý¾Ý¿âtest1;
test1 Êý¾Ý¿â Öн¨±ípet,±í½á¹¹ÈçÏÂ;
mysql> desc pet;
+---------+----------+------+-----+---------+-------+
| Field | Type     | Null | Key | Default | Extra |
+---------+----------+------+-----+---------+-------+
| name | char(20) | YES   |     | NULL |    |
| owner | char(20) | YES   |     | NULL |    |
| species | char(20) | YES   |     | NULL |    |
| sex     | char(1)   | YES   |     | NULL |    |
| birth | date     | YES ......
×ܼǼÊý:40319; ×ÜÒ³Êý:6720; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [2079] [2080] [2081] [2082] 2083 [2084] [2085] [2086] [2087] [2088]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ