Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

JAVAʵÏÖOracleÊý¾Ý¿âµÄÊý¾ÝµÄ·ÖÒ³ÏÔʾ

 
×î½üѧÁËservletºÍoracle£¬Ò²¾Í°ÑËûÃǽáºÏÏ£¬×ö¸ö·ÖÒ³µÄÒ³Ãæ³öÀ´¡£ËãÊÇÒ»ÖÖ¸´Ï°°É¡£
1.Ê×ÏÈÊÇoracleµÄ·ÖÒ³ÏÔʾSQLÓï¾ä£º
select * from(select a.*, rownum  rn from (select * from Person) a where  rownum <= MaxNum) where rn > MinNum;
2.È»ºóÔÚjavaÖУ¬Á¬½ÓÊý¾Ý¿âµÄÓï¾äÓÐÏÂÃæ¼¸¶Î£º
//¼ÓÔØÇý¶¯
Class.forName("oracle.jdbc.driver.OracleDriver");
//´ò¿ªÊý¾Ý¿â
Connection ct = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:myora1", "sys as sysdba", "abc");
/*
*Õâ¸öº¯ÊýÓÐÈý¸ö²ÎÊý 
*µÚÒ»¸ö²ÎÊý jdbc:oracle:thin@ + IPµØÖ· + ¶Ë¿ÚºÅ + Êý¾Ý¿âÃû
*µÚ¶þ¸ö²ÎÊý Óû§Ãû
*µÚÈý¸ö²ÎÊý ÃÜÂë
*/
//´´½¨Á¬½ÓÊý¾Ý¿âµÄ»á»°
Statement sm = ct.createStatement();
//ÉèÖÃSQLÓï¾ä
ResultSet rs = sm.executeQuery("............");
3.É趨·ÖÒ³µÄËĸö¹Ø¼üÖµ
int pageSize = 5;   //Ò»Ò³ÏÔʾµÄÌõÄ¿Êý    ×Ô¼ºÉ趨
int pageNow = 1;   //µ±Ç°µÄÒ³Êý   ³õʼֵΪ1
int rowCount = 0;   //Ò»¹²µÄ¼Ç¼Êý
int pageCount = 0;   //Ò»¹²µÄÒ³Êý
µÚ¶þ¸öÊÇÓû§Ñ¡¶¨³öÀ´µÄ£¬ËùÒÔ¼ÓÉÏ
String id = (String)req.getParameter("id");
if(!(id == null || id.equals("")))
{
pageNow = Integer.parseInt(id);
}
ÏÂÃæÁ½¸öÊÇÒª¼ÆËã³öÀ´µÄ~
rowCount:
ResultSet rst = sm.executeQuery("select count(*) from Person");
while(rst.next())
{
rowCount = rst.getInt(1);
}
pageCount:
pageCount = (rowCount % pagesize == 0) ? rowCount / pageSize : rowCount / pageSize + 1;
OK,»ù±¾ÒªËؽ²ÍêÁË£¬ÏÂÃæÉÏÍêÕûCode£º
package com.testing;
import javax.servlet.http.*;
import java.io.*;
import javax.servlet


Ïà¹ØÎĵµ£º

Java NIO APIÏê½â

 
Java NIO APIÏê½â
ÔÚJDK
1.4ÒÔǰ£¬JavaµÄIO²Ù×÷¼¯ÖÐÔÚjava.ioÕâ¸ö°üÖУ¬ÊÇ»ùÓÚÁ÷µÄ×èÈû£¨blocking£©API¡£¶ÔÓÚ´ó¶àÊýÓ¦ÓÃÀ´Ëµ£¬ÕâÑùµÄAPIʹÓúܷ½
±ã£¬È»¶ø£¬Ò»Ð©¶ÔÐÔÄÜÒªÇó½Ï¸ßµÄÓ¦Óã¬ÓÈÆäÊÇ·þÎñ¶ËÓ¦Óã¬ÍùÍùÐèÒªÒ»¸ö¸üΪÓÐЧµÄ·½Ê½À´´¦ÀíIO¡£´ÓJDK 1.4Æð£¬NIO
API×÷Ϊһ¸ö»ùÓÚ»º³åÇø£¬²¢ÄÜÌṩ·Ç×èÈû(non-blo ......

½ÌÄã°²×°oracle£¡

 Oracle ×°Åä¹£¸Å
Òª²é¿´¿ÉÓà RAM ºÍ»¥»»¿Õ¼ä´óС£¬ÔË×÷ÒÔ´ÎÏÂÁ
grep MemTotal /proc/meminfo
grep SwapTotal /proc/meminfo
±ÈÈ磺
# grep MemTotal /proc/meminfo
MemTotal:512236 kB
# grep SwapTotal /proc/meminfo
SwapTotal:1574360 kB
½ÓÏÂÀ´£¬´´ÔìÓÃÀ´×°ÅäºÍά»¤ Oracle Ê®g Èí¼þµÄ Linux ×éºÍÓû ......

javaÓësql server 2005µÄÏà¹Ø²Ù×÷

//±¾³ÌÐòÁ¬½ÓµÄÊÇsql server 2005£¬ÓëÁ¬½Ósql server 2000Óе㲻ͬ£ºdriverNameºÍURL¶¼²»Í¬
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class create{
   public void getConnection() th ......

javaÄ£ÄâÎ趯×Ö·û

 Ô´´úÂ룺
import java.applet.Applet;
import java.awt.Color;
import java.awt.Font;
import java.awt.Graphics;
import java.awt.event.MouseEvent;
import java.awt.event.MouseListener;
public class brandishString extends Applet implements Runnable, MouseListener {
String str; // ÒªÏÔʾµÄ×Ö·û ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ