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
Ïà¹ØÎĵµ£º
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 ×éºÍÓû ......
10ÔÂ10ÈÕµÄÃÀ¹ú¾É½ðɽһÏÂÓ¿ÈëÁË4ÍòÈËÁ÷£¬ËûÃǾۼ¯ÔھɽðɽµÄMoscone»áÕ¹ÖÐÐÄ£¬ÖÜΧ81000¸ö¾Æµê´²Î»±»¶©¹ºÒ»¿Õ£¬¾É½ðɽÊÐÕþ¸®×¨ÃÅ·âËøÁËÖܱßÈýÌõµÀ·µÄ½»Í¨£¬ÒÔΪÕâЩÅÓ´óÈËÁ÷Ìṩ±ãÀû¡£ÕâЩÈ˶¼ÊÇÈ«ÇòITÒµ½çµÄ¾«Ó¢——´ÓIT¾ÞÍ·µÄÁìÐäµ½ÆÕͨµÄÆóÒµIT¼¼ÊõÈËÔ±£¬´Ó×Éѯ»ú¹¹µÄ·ÖÎöÈËÊ¿µ½¸÷ÐÐÒµµÄÐÅÏ¢»¯Ö÷¹Ü£¬µ ......
³ÌÐòÔ´´úÂ룺
import java.awt.BorderLayout;
import java.awt.Container;
import java.awt.Cursor;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.io.IOException;
import javax.swing.JEditorPane;
import javax.swing.JFrame;
import javax.swing.JOptionPane; ......
µÚ2Ìõ£ºÓöµ½¶à¸ö¹¹ÔìÆ÷²ÎÊýʱҪ¿¼ÂÇÓù¹½¨Æ÷
ij¸öÀàµÄÊôÐԽ϶࣬³õʼ»¯µÄʱºòÓÖÓÐһЩÊDZØÐë³õʼ»¯µÄ£¬¶øÇÒÀàÐÍÓÐÐÎͬ£¬
±ÈÈçnew Contact("ÐÕÃû","ÏÔʾÃû","ÊÖ»úºÅ","·ÉÐźÅ","ËùÔÚµØ",ÄêÁä,ÐÔ±ð);
ǰ5¸öÊôÐÔÊÇString ÀàÐÍ£¬ºó2¸öÊÇintÀàÐÍ£¬ÔÚÌîд¹¹Ôì·½·¨µÄʱºòºÜÈÝÒ×Ìîд´í룬»òÕßÉÙÌîд£¬»òÕߵߵ¹ÁËÊôÐÔ£¬
ÈçÏ ......