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
Ïà¹ØÎĵµ£º
SQL> select dbms_metadata.get_ddl('PROCEDURE','PRO2','SCOTT') text from dual;
TEXT
----------------------------------------
CREATE OR REPLACE PROCEDURE "SCOTT"."P
RO2"
is
begin
dbms_output.put_line('wangpeng up');
end;
SQL> select dbms_metadata.get_ddl('PROCEDURE','PRO1','SCOTT') te ......
//±¾³ÌÐòÁ¬½ÓµÄÊÇ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 ......
Ô´´úÂ룺
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; // ÒªÏÔʾµÄ×Ö·û ......
µÚ2Ìõ£ºÓöµ½¶à¸ö¹¹ÔìÆ÷²ÎÊýʱҪ¿¼ÂÇÓù¹½¨Æ÷
ij¸öÀàµÄÊôÐԽ϶࣬³õʼ»¯µÄʱºòÓÖÓÐһЩÊDZØÐë³õʼ»¯µÄ£¬¶øÇÒÀàÐÍÓÐÐÎͬ£¬
±ÈÈçnew Contact("ÐÕÃû","ÏÔʾÃû","ÊÖ»úºÅ","·ÉÐźÅ","ËùÔÚµØ",ÄêÁä,ÐÔ±ð);
ǰ5¸öÊôÐÔÊÇString ÀàÐÍ£¬ºó2¸öÊÇintÀàÐÍ£¬ÔÚÌîд¹¹Ôì·½·¨µÄʱºòºÜÈÝÒ×Ìîд´í룬»òÕßÉÙÌîд£¬»òÕߵߵ¹ÁËÊôÐÔ£¬
ÈçÏ ......