javaÁ¬½ÓÊý¾Ý¿â
1.javaÁ¬½ÓOracleÊý¾Ý¿â£º
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@127.0.0.1:1521:È«¾ÖÊý¾Ý¿âÃû";
String uname="Óû§Ãû";
String pwd="ÃÜÂë";
Connection cn =DriverManager.getConnection(url,uname,pwd);
Statement s=cn.createStatement();
ResultSet rs=s.executeQuery(sqlÓï¾ä);
2.jdbcÇŽÓodbc
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:odbcÊý¾ÝÔ´";
String uname="Óû§Ãû";
String pwd="ÃÜÂë";
Connection cn =DriverManager.getConnection(url,uname,pwd);
Statement s=cn.createStatement();
ResultSet rs=s.executeQuery(sqlÓï¾ä);
3.javaÁ¬½Ómysql
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://127.0.0.1:3306/Êý¾Ý¿âÃû";
String uname="Óû§Ãû";
String pwd="ÃÜÂë";
Connection cn =DriverManager.getConnection(url,uname,pwd);
Statement s=cn.createStatement();
ResultSet rs=s.executeQuery(sqlÓï¾ä);
Ïà¹ØÎĵµ£º
Java NIO APIÏê½â
ÔÚJDK
1.4ÒÔǰ£¬JavaµÄIO²Ù×÷¼¯ÖÐÔÚjava.ioÕâ¸ö°üÖУ¬ÊÇ»ùÓÚÁ÷µÄ×èÈû£¨blocking£©API¡£¶ÔÓÚ´ó¶àÊýÓ¦ÓÃÀ´Ëµ£¬ÕâÑùµÄAPIʹÓúܷ½
±ã£¬È»¶ø£¬Ò»Ð©¶ÔÐÔÄÜÒªÇó½Ï¸ßµÄÓ¦Óã¬ÓÈÆäÊÇ·þÎñ¶ËÓ¦Óã¬ÍùÍùÐèÒªÒ»¸ö¸üΪÓÐЧµÄ·½Ê½À´´¦ÀíIO¡£´ÓJDK 1.4Æð£¬NIO
API×÷Ϊһ¸ö»ùÓÚ»º³åÇø£¬²¢ÄÜÌṩ·Ç×èÈû(non-blo ......
×î½üѧÁËservletºÍoracle£¬Ò²¾Í°ÑËûÃǽáºÏÏ£¬×ö¸ö·ÖÒ³µÄÒ³Ãæ³öÀ´¡£ËãÊÇÒ»ÖÖ¸´Ï°°É¡£
1.Ê×ÏÈÊÇoracleµÄ·ÖÒ³ÏÔʾSQLÓï¾ä£º
select * from(select a.*, rownum rn from (select * from Person) a where rownum <= MaxN ......
import java.util.Properties;
import javax.activation.DataHandler;
import javax.activation.FileDataSource;
import javax.mail.*;
import javax.mail.internet.*;
/**
* ±¾³ÌÐòÓÃjavaÀ´ÊµÏÖEmailµÄ·¢ËÍ£¬ËùÓõ½µÄÐÒéΪ£ºSMTP£¬¶Ë¿ÚºÅΪ25£»<br>
* ·½·¨£ºÓÃSocket½øÐÐʵÏÖ£¬´ò¿ª¿Í»§¶ËµÄSocket£¬²¢Á¬½Ó ......
»Øµ÷¸ÅÄî:
Èí¼þÄ£¿éÖ®¼ä×ÜÊÇ´æÔÚ×ÅÒ»¶¨µÄ½Ó¿Ú£¬´Óµ÷Ó÷½Ê½ÉÏ£¬¿ÉÒÔ°ÑËûÃÇ·ÖΪÈýÀࣺͬ²½µ÷Óᢻص÷ºÍÒì²½µ÷Óá£Í¬²½µ÷ÓÃÊÇÒ»ÖÖ×èÈûʽµ÷Ó㬵÷Ó÷½ÒªµÈ´ý¶Ô·½Ö´ÐÐÍê±Ï²Å·µ»Ø£¬ËüÊÇÒ»ÖÖµ¥Ïòµ÷Ó㻻ص÷ÊÇÒ»ÖÖË«Ïòµ÷ÓÃģʽ£¬Ò²¾ÍÊÇ˵£¬±»µ÷Ó÷½ÔÚ½Ó¿Ú±»µ÷ÓÃʱҲ»áµ÷ÓöԷ½µÄ½Ó¿Ú£»Òì²½µ÷ÓÃÊÇÒ»ÖÖÀàËÆÏûÏ¢»òʼþµÄ»úÖÆ£¬² ......
×î½üÏîÄ¿ÖÐÓиöÐèÇó£¬ÒªÓÃSocketʵÏÖ³¤Á¬½Ó£¬²¢ÇÒÔÚͨÐŹý³ÌÖÐÒª»¥ÎªserverºÍclient£¬¼´ÔÚÒ»¸öÁ¬½ÓÖУ¬¼ÈÄܹ»·¢ËÍÏûÏ¢£¬£¨´Ëʱ×÷Ϊ¿Í»§¶Ë£©£¬ÓÖÒªÄܹ»½ÓÊÕÏûÏ¢£¨´Ëʱ×÷Ϊserver¶Ë£©£¬Ñо¿ÁËÏ£¬ÊµÏÖ·½Ê½ÈçÏ£º
Ò»¡¢·¢ËÍÏûϢʱ½¨Á¢Á¬½Ó£¬¹¹½¨Í¨µÀ¡£
Socket socket = new Socket();
SocketAddress endpoint = new In ......