oracleµ÷ÓÃjava·½·¨´íÎó - Oracle / ¿ª·¢
oracleµ÷ÓÃjava·½·¨´íÎó: ORA-29541: ÎÞ·¨½âÎöÀà.
¹ý³ÌÈçÏÂ:
1.Ê×ÏÈÎÒ×öÁËн¨ÁËÒ»¸ö²âÊÔµÄÏîÄ¿,ÀïÃæ¾ÍÖ»ÓÐÒ»¸öµ¥¶ÀµÄMain²âÊÔÀà. ÀïÃæÓÐÒ»¸ö·½·¨:
public static String sayHello(String name){
return " hello " + name;
}
2.È»ºó°ÑÏîÄ¿´ò°ü³Éprj.jar.
ÎÒÓÃloadjava -user sys/sys@databaseName prj.jar
select DBMS_JAVA.LONGNAME(OBJECT_NAME) as OBJECT_NAME
from USER_OBJECTS
where OBJECT_TYPE like 'JAVA%'
and object_name like '%Main'
ÒѾ²éѯµ½Õâ¸öÀà.
3.È»ºóÔÚoracleÖз¢²¼java³ÌÐò:
create or replace function hello (name VARCHAR2) return VARCHAR2
as language java name
'Main.sayHello (java.lang.String) return java.lang.String ';
Ö´ÐÐ:
select hello(' world! ') from dual;
Ìáʾ:ORA-29541: ÎÞ·¨½âÎöÀà SYS.Main.
ÇëÖ¸½Ì.
ÎÊÌâÊÇÎÒµ¼ÈëÁËjar°ü.È»ºóÔõô"ÉèÖÃ"²ÅÄÜÈÃÎÒÀ´ÒýÓÃÕâ¸ö°üÄØ?¡¡
¸øÄã¸öÀý×Ó£º
ÏÖÔÚ,10G¼°ÆäÒÔºó°æ±¾µÄOracleÊý¾Ý¿âÌṩÁ˶ÔJava³ÌÐòµÄ¸ü¶àµÄÖ§³Ö,ºÜºÃµÄ½â¾öÁËÕâ·½ÃæµÄÎÊÌâ. ½â¾ö·½·¨ÈçÏÂ,
1. Ê×ÏÈÎÒÃÇ´´½¨µ÷ÓòÙ×÷ϵͳÃüÁîµÄJava·½·¨
create or replace and compile java source named oscmd as
import java.io.*;
import java.lang.*;
public class OSCmd extends Object {
public static int OSCmd(String args) {
Runtime rt = Runtime.getRuntime();
int rc = -1;
try
Ïà¹ØÎÊ´ð£º
µ±ÖªµÀÒ»¸öÈÕÆÚ£¬ÈçºÎ°ÑÕâ¸öÈÕÆÚËùÔÚÑ®µÄǰºóÁ½¸öÈÕÆÚÈ¡³ö
±ÈÈçÊäÈë20090905£¬¾ÍÊäÈë20090901 20090910
Êä³ö20090901 20090910
È¡µÃÌìÊýºó×÷Ò»ÏÂÅжÏÔÙ°ÑÕâ¸ö·½·¨ÓÃÏÂvoid set(int field, int value)
......
JSPÒ³ÃæÖÐÓжà¸öradio°´Å¥
JSPÒ³Ãæ½«²ÎÊýPOST¸øservlet
ÒªÇóÈçÏÂ;
1.Ñ¡ÔñÒ»¸öradio£¬µ÷ÓÃservlet servletÖиù¾Ý²ÎÊýµ÷ÓÃÆäËû½Ó¿Ú£¬³ý·ÇÑ¡ÖиÃradio²¢µã»÷JSPÖеÄʵР......
org.apache.jasper.JasperException: Unable to compile class for JSP:
An error occurred at line: 52 in the jsp file: /vip_info.jsp
ÕË cannot be resolved
49: <table border="1& ......
ÎÒдÁ˸öjspÒ³Ãæ£¬È»ºó¸Ä¶¯ÁËһϣ¬¸Ä¶¯µÄÄÚÈݾÍÊÇÔÚjspÒ³ÃæµÄjsº¯ÊýÀï¼ÓÁ˸öalert()Óï¾ä£¬µ«ÊÇÎÒ·ÃÎÊÕâ¸öÒ³ÃæÊ±£¬ËÀ»î¶¼ÊÇÔÀ´Ò³ÃæµÄÄÚÈÝ£¬ÎÒ¼ÓÁ˺ܶàalertº¯Êý»¹ÊÇû¸Ä¶¯Ç°µÄÒ³ÃæÄÚÈÝ£»tomcatÖØÆôÁË£¬Ò²ÖØÐ²¿ÊðÕâ ......
id name datetime
1 a 2010-05-13 10:15:00
2 b 2010-05-14 09:10:00
3 d 2010-05-14 10:10:00
ÈçºÎ½«¾àÀëĿǰ×î½üµÄÄǸö¼Ç¼µÄname ¸üÐÂΪ¡°x¡±ÄØ
лл¿© °¡ ºÇºÇ
update table_n ......