תÌû´¦£ºhttp://dong-java.javaeye.com/blog/375150
1¡£ÍƼöʹÓÃOralce±È½ÏеÄ10.2.0.3 JDBC Drivers¡£Õâ¸ö°æ±¾¶Ô±È9.2µÄ×î´óµÄºÃ´¦ÊÇDriverManager.setLoginTimeoutº¯ÊýÊÇÆð×÷Óõġ£ÉèÖÃÁËÕâ¸ö²ÎÊý£¬ÔÚ¶ñÁÓµÄÍøÂç»·¾³ÖоͲ»»áÓÐÁ¬½ÓÊý¾Ý¿âµÄº¯Êý³¤Ê±¼ä²»·µ»ØµÄÇé¿ö¡£
2¡£JDBC Developer!ˉs Guide and Reference 10g Release 2 (10.2)
¸ø³öµÄÁ¬½ÓÊý¾Ý¿âµÄʾÀý£º
import java.sql.*;
import oracle.jdbc.pool.OracleDataSource;
class JdbcTest {
public static void main (String args []) throws SQLException {
// Create DataSource and connect to the local database
OracleDataSource ods = new OracleDataSource();
ods.setURL("jdbc:oracle:thin:@//myhost:1521/orcl");
ods.setUser("scott");
......
תÌû´¦£ºhttp://dong-java.javaeye.com/blog/375150
1¡£ÍƼöʹÓÃOralce±È½ÏеÄ10.2.0.3 JDBC Drivers¡£Õâ¸ö°æ±¾¶Ô±È9.2µÄ×î´óµÄºÃ´¦ÊÇDriverManager.setLoginTimeoutº¯ÊýÊÇÆð×÷Óõġ£ÉèÖÃÁËÕâ¸ö²ÎÊý£¬ÔÚ¶ñÁÓµÄÍøÂç»·¾³ÖоͲ»»áÓÐÁ¬½ÓÊý¾Ý¿âµÄº¯Êý³¤Ê±¼ä²»·µ»ØµÄÇé¿ö¡£
2¡£JDBC Developer!ˉs Guide and Reference 10g Release 2 (10.2)
¸ø³öµÄÁ¬½ÓÊý¾Ý¿âµÄʾÀý£º
import java.sql.*;
import oracle.jdbc.pool.OracleDataSource;
class JdbcTest {
public static void main (String args []) throws SQLException {
// Create DataSource and connect to the local database
OracleDataSource ods = new OracleDataSource();
ods.setURL("jdbc:oracle:thin:@//myhost:1521/orcl");
ods.setUser("scott");
......
Ê×ÏÈһЩ±»³õʼ»¯¶ÔÏóµÄ¸ÅÄ
Àà±äÁ¿£¨Àྲ̬³ÉÔ±£©£º Àà±»¼ÓÔØÊ±²úÉú£»ËüµÄÉú´æÆÚÊÇÀàµÄÉú´æÆÚ£»×Ô¶¯³õʼ»¯£¨Àà±»¼ÓÔØ£©
³ÉÔ±±äÁ¿£¨Àà³ÉÔ±£©£º ÔÚʹÓÃnew´´½¨¸ÃÀàʵÀýʱ²úÉú£»ËüµÄÉú´æÆÚÓë¸ÃÀàʵÀý¶ÔÏóµÄÉú´æÆÚÏàͬ£»
×Ô¶¯³õʼ»¯£¨¹¹Ôì·½·¨±»µ÷Óã©
¾Ö²¿±äÁ¿£¨ÀàµÄ·½·¨ÖеıäÁ¿£©£º ¸Ã·½·¨±»µ÷ÓÃʱ²úÉú£» Ôڸ÷½·¨Í˳öºó½áÊø£» ±ØÐëÏÔʽ³õʼ»¯
1 ·½·¨ÖеıäÁ¿£¬²»»á±»×Ô¶¯³õʼ»¯¡£±ÈÈçmain·½·¨ÖеıäÁ¿index£¬¶¨ÒåÈçint index; Ëü²»»á±»×Ô¶¯³õʼ»¯¡£
2 µ±ÓÃnew¶¨ÒåһЩ±äÁ¿£¬»á×Ô¶¯³õʼ»¯£¬Èç int [] d = new int[100]; Ëü×Ô¶¯³õʼ»¯Îª0¡£
¸÷Êý¾ÝÀàÐ͵ÄÊý×é×Ô¶¯³õʼֵÈçÏ£º
byte 0
short 0
int 0
long 0l
float 0.0f
double 0.0d
char \u0000 ¼´ÊýÖµ0£¬¶ø·Ç×Ö·û0£¬ÒòΪËüÊÇ0~~65535µÄÐòÁС£×Ö·û0λ
ÖÃÔÚ48ÉÏ£¬¼´\u0030
boolean false
reference null ÈçString
3 Àà³ÉÔ±Èç¹ûûÓб»¶¨Òå»á×Ô¶¯»ñȡһ¸ö³õʼֵ¡£Ê×ÏÈÔËÐÐÉùÃ÷µÄÀà³ÉÔ±£¬Èç¹ûÓж¨Ò壬ÔòÈ¡¶¨ÒåÖµ£¬Ëæºóµ÷Óù¹Ô캯Êý£¬È ......
¼òµ¥µÄ˵µ¥Àý¾ÍÊÇ Ö»ÄÜÓÐÒ»¸öʵÀý£¬ËùÒԵط½Óõ½µÄʵÀý¶¼ÊÇͬһ¸ö¡£
¾ÍºÃÏñ¼ÒÈ˳Է¹£¬×À×ÓÊǵ¥ÀýµÄ£¬´ó¼ÒÓõÄÊÇͬһ¸ö¡£¶øÍëÊǶàÀýµÄ£¬Ã¿È˶¼ÓÐ×Ô¼¸µÄ¡£ ÏÂÃæÊǾßÌåµÄÀý×Ó£º
Javaģʽ֮µ¥Àýģʽ£º
µ¥Àýģʽȷ±£Ò»¸öÀàÖ»ÓÐÒ»¸öʵÀý£¬×ÔÐÐÌṩÕâ¸öʵÀý²¢ÏòÕû¸öϵͳÌṩÕâ¸öʵÀý¡£
ÌØµã£º
1£¬Ò»¸öÀàÖ»ÄÜÓÐÒ»¸öʵÀý
2£¬×Ô¼º´´½¨Õâ¸öʵÀý
3£¬Õû¸öϵͳ¶¼ÒªÊ¹ÓÃÕâ¸öʵÀý
Àý: ÔÚÏÂÃæµÄ¶ÔÏóͼÖУ¬ÓÐÒ»¸ö"µ¥Àý¶ÔÏó"£¬¶ø"¿Í»§¼×"¡¢"¿Í»§ÒÒ" ºÍ"¿Í»§±û"Êǵ¥Àý¶ÔÏóµÄÈý¸ö¿Í»§¶ÔÏ󡣿ÉÒÔ¿´µ½£¬ËùÓеĿͻ§¶ÔÏó¹²ÏíÒ»¸öµ¥Àý¶ÔÏó¡£¶øÇÒ´Óµ¥Àý¶ÔÏóµ½×ÔÉíµÄÁ¬½ÓÏß¿ÉÒÔ¿´³ö£¬µ¥Àý¶ÔÏó³ÖÓжÔ×Ô¼ºµÄÒýÓá£
SingletonģʽÖ÷Òª×÷ÓÃÊDZ£Ö¤ÔÚJavaÓ¦ÓóÌÐòÖУ¬Ò»¸öÀàClassÖ»ÓÐÒ»¸öʵÀý´æÔÚ¡£Ôںܶà²Ù×÷ÖУ¬±ÈÈ罨Á¢Ä¿Â¼ Êý¾Ý¿âÁ¬½Ó¶¼ÐèÒªÕâÑùµÄµ¥Ï̲߳Ù×÷¡£Ò»Ð©×ÊÔ´ÖÎÀíÆ÷¾³£Éè¼Æ³Éµ¥Àýģʽ¡£
Íⲿ×ÊÔ´£ºÆ©Èçÿ̨¼ÆËã»ú¿ÉÒÔÓÐÈô¸É¸ö´òÓ¡»ú£¬µ«Ö» ......
JAVA³ÌÐòÔ±ÃæÊÔÖ®¿û»¨±¦µä
1¡¢ÃæÏò¶ÔÏóµÄÌØÕ÷ÓÐÄÄЩ·½Ãæ
1.³éÏ󣺳éÏó¾ÍÊǺöÂÔÒ»¸öÖ÷ÌâÖÐÓ뵱ǰĿ±êÎ޹صÄÄÇЩ·½Ã棬ÒÔ±ã¸ü³ä·ÖµØ×¢ÒâÓ뵱ǰĿ±êÓйصķ½Ãæ¡£³éÏó²¢²»´òËãÁ˽âÈ«²¿ÎÊÌ⣬¶øÖ»ÊÇÑ¡ÔñÆäÖеÄÒ»²¿·Ö£¬ÔÝʱ²»Óò¿·Öϸ½Ú¡£³éÏó°üÀ¨Á½¸ö·½Ã棬һÊǹý³Ì³éÏ󣬶þÊÇÊý¾Ý³éÏó¡£
2.¼Ì³Ð£º¼Ì³ÐÊÇÒ»ÖÖÁª½áÀàµÄ²ã´ÎÄ£ÐÍ£¬²¢ÇÒÔÊÐíºÍ¹ÄÀøÀàµÄÖØÓã¬ËüÌṩÁËÒ»ÖÖÃ÷È·±íÊö¹²ÐԵķ½·¨¡£¶ÔÏóµÄÒ»¸öÐÂÀà¿ÉÒÔ´ÓÏÖÓеÄÀàÖÐÅÉÉú£¬Õâ¸ö¹ý³Ì³ÆÎªÀà¼Ì³Ð¡£ÐÂÀà¼Ì³ÐÁËÔʼÀàµÄÌØÐÔ£¬ÐÂÀà³ÆÎªÔʼÀàµÄÅÉÉúÀࣨ×ÓÀࣩ£¬¶øÔʼÀà³ÆÎªÐÂÀàµÄ»ùÀࣨ¸¸Àࣩ¡£ÅÉÉúÀà¿ÉÒÔ´ÓËüµÄ»ùÀàÄÇÀï¼Ì³Ð·½·¨ºÍʵÀý±äÁ¿£¬²¢ÇÒÀà¿ÉÒÔÐ޸ĻòÔö¼ÓÐµķ½·¨Ê¹Ö®¸üÊʺÏÌØÊâµÄÐèÒª¡£
3.·â×°£º·â×°Êǰѹý³ÌºÍÊý¾Ý°üΧÆðÀ´£¬¶ÔÊý¾ÝµÄ·ÃÎÊÖ»ÄÜͨ¹ýÒѶ¨ÒåµÄ½çÃæ¡£ÃæÏò¶ÔÏó¼ÆËãʼÓÚÕâ¸ö»ù±¾¸ÅÄ¼´ÏÖʵÊÀ½ç¿ÉÒÔ±»Ãè»æ³ÉһϵÁÐÍêÈ«×ÔÖΡ¢·â×°µÄ¶ÔÏó£¬ÕâЩ¶ÔÏóͨ¹ýÒ»¸öÊܱ£»¤µÄ½Ó¿Ú·ÃÎÊÆäËû¶ÔÏó¡£
4. ¶à̬ÐÔ£º¶à̬ÐÔÊÇÖ¸ÔÊÐí²»Í¬ÀàµÄ¶ÔÏó¶ÔͬһÏûÏ¢×÷³öÏìÓ¦¡£¶à̬ÐÔ°üÀ¨²ÎÊý»¯¶à̬ÐԺͰüº¬¶à̬ÐÔ¡£¶à̬ÐÔÓïÑÔ¾ßÓÐÁé»î¡¢³éÏó¡¢ÐÐΪ¹²Ïí¡¢´úÂë¹²ÏíµÄÓÅÊÆ£¬ºÜºÃµÄ½â¾öÁËÓ¦ÓóÌÐòº¯ÊýͬÃûÎÊÌâ¡£
2¡¢StringÊÇ×î»ù±¾µÄÊý¾ ......
package org.bupt.test;
import java.util.ArrayList;
class MyResource {
ArrayList<Integer> arrList= new ArrayList<Integer>();
public MyResource(ArrayList<Integer> arrList) {
this.arrList = arrList;
}
public void insertionSort() {
boolean conFlag = true;
for (int i = 0; i < arrList.size(); i++) {
while (conFlag) {//ÿÌ˱ȽÏǰÏÈÅжÏÉϴαȽÏÊDz»ÊÇûÓл¥»»¶¯×÷·¢Éú£¬ÈôÊÇÔò˵Ã÷Ê£ÏÂûÓÐÅŵÄÒѾÂú×ã˳Ðò
conFlag =false;
for (int j = 0; j < arrList.size()-i-1; j++) {
if (arrLi ......
°²×°MySQL
sudo apt-get install mysql-server mysql-admin mysql-navigator mysql-query-browser
Õâ¸öÓ¦¸ÃºÜ¼òµ¥ÁË£¬¶øÇÒÎÒ¾õµÃ´ó¼ÒÔÚ°²×°·½ÃæÒ²Ã»Ê²Ã´Ì«´óÎÊÌ⣬ËùÒÔÒ²¾Í²»¶à˵ÁË£¬ÏÂÃæÎÒÃÇÀ´½²½²ÅäÖá£
ÅäÖÃMySQL
×¢Ò⣬ÔÚUbuntuÏÂMySQLȱʡÊÇÖ»ÔÊÐí±¾µØ·ÃÎʵģ¬Èç¹ûÄãÒªÆäËû»úÆ÷Ò²Äܹ»·ÃÎʵϰ£¬ÄÇôÐèÒª¸Ä±ä/etc/mysql/my.cnfÅäÖÃÎļþÁË£¡ÏÂÃæÎÒÃÇÒ»²½²½µØÀ´£º
ĬÈϵÄMySQL°²×°Ö®ºó¸ùÓû§ÊÇûÓÐÃÜÂëµÄ£¬ËùÒÔÊ×ÏÈÓøùÓû§½øÈ룺
$mysql -u root
ÔÚÕâÀïÖ®ËùÒÔÓÃ-u rootÊÇÒòΪÎÒÏÖÔÚÊÇÒ»°ãÓû§£¨firehare£©£¬Èç¹û²»¼Ó-u
rootµÄ»°£¬mysql»áÒÔΪÊÇfirehareÔڵǼ¡£×¢Ò⣬ÎÒÔÚÕâÀïûÓнøÈë¸ùÓû§Ä£Ê½£¬ÒòΪû±ØÒª¡£Ò»°ãÀ´Ëµ£¬¶ÔmysqlÖеÄÊý¾Ý¿â½øÐвÙ×÷£¬
¸ù±¾Ã»±ØÒª½øÈë¸ùÓû§Ä£Ê½£¬Ö»ÓÐÔÚÉèÖÃʱ²ÅÓÐÕâÖÖ¿ÉÄÜ¡£
½øÈëmysqlÖ®ºó£¬×îÒª½ôµÄ¾ÍÊÇÒªÉèÖÃMysqlÖеÄrootÓû§ÃÜÂëÁË£¬·ñÔò£¬Mysql·þÎñÎÞ°²È«¿ÉÑÔÁË¡£
mysql> GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY "123456";
×¢Ò⣬ÎÒÕâ¶ùÓõÄÊÇ123456×öΪrootÓû§µÄÃÜÂ룬µ«ÊǸÃÃÜÂëÊDz»°²È«µÄ£¬Çë´ó¼Ò×îºÃʹÓôóСд×ÖĸÓëÊý×Ö»ìºÏµÄÃÜÂ룬ÇÒ²»ÉÙÓÚ8λ¡£
ÕâÑùµÄ»°£¬¾ÍÉèÖúÃÁËMySQLÖ ......