Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 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 ......

×ܽ᣺JSPÒ³ÃæimgͼƬ»º´æÎÊÌâÏÖÏó±íÊö¼°ÎÊÌâ½â¾ö

JSPÒ³ÃæimgͼƬ»º´æÎÊÌâÏÖÏó±íÊö¼°ÎÊÌâ½â¾ö
l  ÎÊÌâ±íÊö£º
µ±¶Ôº¬ÓÐÍ·ÏñµÄ¿Í·þÈËÔ±ÐÅÏ¢½øÐÐÐÞ¸Ä(º¬¶ÔÍ·ÏñÐÅÏ¢µÄÐÞ¸Ä)ºó£¬ÖØÐ´ò¿ªÊý¾ÝÐ޸ĽçÃæ£¬·¢ÏÖÎı¾ÄÚÈÝÐ޸ijɹ¦£¬¶øÍ·ÏñÄÚÈÝÈÔÈ»ÏÔʾΪԭÀ´µÄÍ·Ïñ——Êý¾Ý¿âÖеĶÔÓ¦ÐÅϢͷÏñËùÔÚ×Ö¶ÎÊý¾ÝÒѾ­³É¹¦¸üС£
 
l  ǰÌ᣺
jspÒ³ÃæÖнøÐÐÁËҳà ......

JSPÑéÖ¤ÂëµÄʵÏÖ

       ×î½ü¿´SSHÐèҪʹÓÃÑéÖ¤Â룬ËùÒÔÔÚÍøÉÏÕÒÁËһϡ£Õâ¸ö´úÂëÔÚÍøÉÏÒѾ­Á÷´«ºÜ¾ÃÁË£¬´ó²¿·Ö¶¼´óͬСÒ죬Ìù³öÀ´ÒÔ±¸ºóÓá£
      ´úÂëÈçÏÂ(image.jsp)£º
<%@ page contentType="image/jpeg" import="java.awt.*,
java.awt.image.*,java.util.*,javax.image ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ