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 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 ......
•ºÎΪÉó¼Æ
Êý¾Ý¿âÉ󼯣¬¾ÍÊǶÔÊý¾Ý¿âµÄ»î¶¯×ö¸ú×ټǼ£¬Ö÷Òª°üÀ¨Êý¾Ý¿âÁ¬½Ó£¬SQLÓï¾äÖ´ÐУ¬Êý¾Ý¿â¶ÔÏó·ÃÎÊÕâЩ·½ÃæµÄ¸ú×ټǼ¡£
•ÏÖʵ×÷ÓÃ
°²È«¿ØÖÆ¡¢¸ú×ÙÊý¾Ý±ä»¯¡¢³ÌÐòBUGµ÷ÊÔ¡¢×Ô¶¨ÒåµÄÊý¾Ý»ã×Ü·ÖÎö¡¢²Ù×÷ÈÕÖ¾
•´æ´¢·½Ê½
Ò»ÖÖÊÇ´æ´¢ÔÚ²Ù×÷ϵͳÎļþÖУ¬Ò»ÖÖÊÇ´æ´¢ÔÚsystem±í¿Õ¼äÖеÄSYS.AUD$±íÖÐ
......
JSPÒ³ÃæimgͼƬ»º´æÎÊÌâÏÖÏó±íÊö¼°ÎÊÌâ½â¾ö
l ÎÊÌâ±íÊö£º
µ±¶Ôº¬ÓÐÍ·ÏñµÄ¿Í·þÈËÔ±ÐÅÏ¢½øÐÐÐÞ¸Ä(º¬¶ÔÍ·ÏñÐÅÏ¢µÄÐÞ¸Ä)ºó£¬ÖØÐ´ò¿ªÊý¾ÝÐ޸ĽçÃæ£¬·¢ÏÖÎı¾ÄÚÈÝÐ޸ijɹ¦£¬¶øÍ·ÏñÄÚÈÝÈÔÈ»ÏÔʾΪÔÀ´µÄÍ·Ïñ——Êý¾Ý¿âÖеĶÔÓ¦ÐÅϢͷÏñËùÔÚ×Ö¶ÎÊý¾ÝÒѾ³É¹¦¸üС£
l ǰÌ᣺
jspÒ³ÃæÖнøÐÐÁËҳà ......
jspÖÐÎÄÏÔʾÂÒÂë½â¾ö·½°¸2006-12-27 22:56
Ò»¡¢JSPÒ³ÃæÏÔʾÂÒÂë
¶þ¡¢±íµ¥Ìá½»ÖÐÎÄʱ³öÏÖÂÒÂë
Èý¡¢Êý¾Ý¿âÁ¬½Ó
´ó¼ÒÔÚJSPµÄ¿ª·¢¹ý³ÌÖУ¬¾³£³öÏÖÖÐÎÄÂÒÂëµÄÎÊÌ⣬¿ÉÄÜÒ»ÖÁÀ§ÈÅ×ÅÄú£¬ÎÒÏÖÔÚ°ÑÎÒÔÚJSP¿ª·¢ÖÐÓöµ½
µÄÖÐÎÄÂÒÂëµÄÎÊÌâ¼°½â¾ö°ì·¨Ð´³öÀ´¹©´ó¼Ò²Î¿¼¡£
Ò»¡¢JSPÒ³ÃæÏÔʾÂÒÂë
ÏÂÃæµÄÏÔÊ¾Ò³Ãæ(display.jsp)¾Í³öÏÖÂÒ ......
jsp »º´æ£¬ html »º´æ£¬ ajax»º´æ,½â¾ö·½·¨
url:http://blog.csdn.net/oklzh/archive/2009/08/14/4445722.aspx
ÓйØÒ³Ã滺´æÎÊÌ⣮Õâ¸öÎÊÌâÉÏÍøÕÒÁ˺ö࣮µ«·¢¾õ¸÷ÖÖ½â¾ö·½·¨£¬¶¼±Ë´Ë·ÖÀ룬ûÓÐһƪͳһµÄ½â¾ö·½·¨£¬±¾È˽üÈÕ£¬Ò²Óöµ½ÁËÒ³Ãæ»º´æµÄÎÊÌ⣬¸ù¾ÝÍøÉϸ÷Ò³Ãæ»º´æµÄ½â´ð£¬×öÁËÒ»¸ö×ܽᡣ
1.·þÎñÆ÷¶Ë»º´æµÄÎÊÌâ ......