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Óï¾ä);
Ïà¹ØÎĵµ£º
×î½üѧÁËservletºÍoracle£¬Ò²¾Í°ÑËûÃǽáºÏÏ£¬×ö¸ö·ÖÒ³µÄÒ³Ãæ³öÀ´¡£ËãÊÇÒ»ÖÖ¸´Ï°°É¡£
1.Ê×ÏÈÊÇoracleµÄ·ÖÒ³ÏÔʾSQLÓï¾ä£º
select * from(select a.*, rownum rn from (select * from Person) a where rownum <= MaxN ......
JavaɳÏäʵÏÖÊÇÖØÐ´Àà¼ÓÔØÆ÷ºÍ°²È«¹ÜÀíÆ÷,ͨ¹ýÉèÖõÄÈ«¾Ö°²È«¹ÜÀíÆ÷À´¿ØÖÆÖ´ÐгÌÐòµÄȨÏÞ
˵Ã÷: °²È«²ßÂÔÖ»¶Ô°²×°°²È«¹ÜÀíÆ÷Ö®ºóµÄÀàÉúЧ,֮ǰµÄÀ಻Ôٴ˹ÜÀí·¶Î§Ö®ÄÚ,ÀûÓÃÕâÒ»µã¿ÉÒÔÔ¤ÏÈÉèÖÃÎÒÃÇÐèÒªµÄ²Ù×÷,¶ø¶Ôij¸öµãÖ®ºóµÄËùÓзǷ¨²Ù×÷½øÐÐȨÏÞÉèÖÃ.
Àà¼ÓÔØÆ÷ÖØÐ´
/**
* [ÖØÐ´µÄÀà¼ÓÔØÆ÷]
* ɳÏä³ÌÐòÀà¼ÓÔØÆ÷,¿ ......
µ½ÕâÀïÎÒÃÇ×öÒ»¸öÍêÕûµÄÀý×ÓÀ´ËµÃ÷Ï̲߳úÉúµÄ·½Ê½²»Í¬¶øÉú³ÉµÄÏ̵߳ÄÇø±ð£º
package debug;
import java.io.*;
import java.lang.Thread;
class MyThread extends Thread{
public int x = 0;
public void run(){
System.out.println(++x);
}
}
class R implements Runnable{
private int x = ......
ÎÒÏÖÔÚÊÇ´óÈýµÄѧÉú£¬ÎÒÔÚÊî¼Ù¿ªÊ¼½Ó´¥Java web±à³Ì£¬ÏÖÔڲ¶àѧÁËÓаëÄêÁ˰ɡ£ÄÇʱJava×Ô¼ºÒ»µãÁ˲»¶®£¬¼ÇµÃÉÏÍøÒ³Éè¼ÆÀÏÊÇÌáÆðjsp£¬ÊǵÚÒ»´Î½Ó´¥µ½Java¡£´ÓÄÇʱ×Ô¼º¾ÍÔÚͼÊé¹Ý½èÔĹØÓÚJavaµÄÊé¼®¡£Êî¼ÙºÍ¼¸¸öͬѧҲ²Î¼ÓÁËÒ»¸ö¹ØÓÚweb±à³ÌµÄ±ÈÈü£¬ÄÇʱÎÒÃÇËÄÈËÿÌì¶¼ÔÚʵÑéÊÒÖÐ×ö±ÈÈüµÄÌâÄ¿¡£
......