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

jspÁ¬½Óoracle£¨javabean£©


package DBbean;
import java.sql.*;
public class ConnBean
{
private Connection con;
//³õʼ»¯Á¬½Ó¡£
public ConnBean()
{
        
  try
  {
   Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
   String url="jdbc:oracle:thin:@localhost:1521:orcl";
         String user="scott";
         String password="tiger";
         con= DriverManager.getConnection(url,user,password);
  }
  catch (InstantiationException e)
  {
      e.printStackTrace();
  } catch (IllegalAccessException e)
  {
      e.printStackTrace();
  }
  catch(ClassNotFoundException e)
   {
    System.out.println("DRIVER NOT FOUND!");
    con=null;
   }
  catch(SQLException e)
   {
    con=null;
   }
    
}
//²éѯÊý¾Ý¿â
public  ResultSet getContact(String id)
{
  try
  {
   Statement stm=con.createStatement();
   ResultSet result=stm.executeQuery("select * from student where id='"+id+"'");
   return result;
  }
  catch(Exception e)
  {
  }
  return null;
}
}  


Ïà¹ØÎĵµ£º

oracle nvl decode

SELECT
DECODE(ÁÐ,0,'Q'1,'P',2,'O')¡¡AS ret
from dual
--·ÖÎö: µ± ÁÐ=0ʱ,½«"Q"¸³Öµ
--µ± ÁÐ =1ʱ,½«"P"¸³Öµ
--µ± ÁÐ=2ʱ,½«"O"¸³Öµ
--NVL()º¯Êý:
--NVL(ARG,VALUE)´ï±êÈç¹ûÇ°ÃæµÄARGֵΪNULLÄÇô·µ»ØµÄֵΪºóÃæµÄVALUE¶þÕß½áºÏʹÓÃ:
DECODE(NVL(±äÁ¿ ''),'','-','OK')
//·ÖÎö:
--Èô ±äÁ¿ ÊÇ·ñΪ¿Õ.ÈôΪ¿Õ¸³¸ø¿ ......

oracle PL SQLѧϰ°¸Àý£¨¶þ£©

¡¾ÑµÁ·6.1¡¿¡¡Ê¹ÓÃÒþʽÓαêµÄÊôÐÔ£¬Åж϶ԹÍÔ±¹¤×ʵÄÐÞ¸ÄÊÇ·ñ³É¹¦¡£
²½Öè1£ºÊäÈëºÍÔËÐÐÒÔϳÌÐò£º
BEGIN
  UPDATE emp SET sal=sal+100 WHERE empno=1234;
  IF SQL%FOUND THEN
       DBMS_OUTPUT.PUT_LINE('³É¹¦Ð޸ĹÍÔ±¹¤×Ê£¡');
       ......

oracle grant

oracle grant
ÊÚȨÓï¾ä--select * from dba_users; ²éѯÊý¾Ý¿âÖеÄËùÓÐÓû§
--alter user TEST_SELECT account lock; Ëø×¡Óû§
--alter user TEST_SELECT account unlock; ¸øÓû§½âËø
--create user xujin identified by   xujin; ½¨Á¢Óû§
--grant create tablespace to xujin; ÊÚȨ
--grant select ......

EOS6ÖÐÔÚJSPÒ³ÃæÖжÁÈ¡Ò³ÃæÁ÷ÖеÄDataObject¶ÔÏó


EOS6ÖÐÔÚJSPÒ³ÃæÖжÁÈ¡Ò³ÃæÁ÷ÖеÄDataObject¶ÔÏó
´úÂëÈçÏ£º
<%@page pageEncoding="UTF-8" import="java.util.*"%>
<%@page import="com.eos.web.taglib.util.*" %>
<%@page import="commonj.sdo.DataObject,commonj.sdo.Property" %>
<%@include file="/common/common.jsp"%>
<%@incl ......

jspÒ³Ãæ·ÀˢУ¬Ìá½»Êý¾ÝÖØ¸´

ÔÚÌá½»±íµ¥µÄÒ³Àï¼ÓÉÏ
<%
org.apache.struts.util.TokenProcessor.getInstance().saveToken(request);
%>
<input type="hidden" name="org.apache.struts.taglib.html.TOKEN" value="<%=session.getAttribute("org.apache.struts.action.TOKEN")%>" />

struts actionÀï
if(isTokenValid(request ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ