ÏÖÔÚ½«javaµ÷ÓÃoracle´æ´¢¹ý³ÌµÄʾÀý×ܽáÈçÏÂ
ѧÉúÔÚѧϰjdbcµÄʱºò£¬»áÎʵ½Ôõôµ÷Óô洢¹ý³Ì£¬ÏÖÔÚ½«javaµ÷ÓÃoracle´æ´¢¹ý³ÌµÄʾÀý×ܽáÈçÏ¡££¨¹ØÓÚµ÷ÓÃsqlserverµÄ´æ´¢¹ý³Ì½«ÔÚÏ´νøÐÐС½áÇë¹Ø×¢£©
Ò»£ºÎÞ·µ»ØÖµµÄ´æ´¢¹ý³Ì
´æ´¢¹ý³ÌΪ£º
• create or replace procedure adddept(deptno number,dname varchar2,loc varchar2)
• as
• begin
• insert into dept values(deptno,dname,loc);
• end;
È»ºóÄØ£¬ÔÚjavaÀïµ÷ÓÃʱ¾ÍÓÃÏÂÃæµÄ´úÂ룺
• public class TestProcedure {
• Connection conn=null;
• CallableStatement cstmt=null;
• PreparedStatement pstmt=null;
• String url="jdbc:oracle:thin:@localhost:1521:mydb";
• String driver="oracle.jdbc.driver.OracleDriver";
• String name="";
• public TestProcedure() {
• try{
• Class.forName(driver);
• conn=DriverManager.getConnection(url,"scott","tiger");
• &nbs
Ïà¹ØÎĵµ£º
1, ±£Ö¤Ḭ̈߳²È«µÄÈýÖÖ·½·¨:
a, ²»Òª¿çÏ̷߳ÃÎʹ²Ïí±äÁ¿
b, ʹ¹²Ïí±äÁ¿ÊÇfinalÀàÐ͵Ä
c, ½«¹²Ïí±äÁ¿µÄ²Ù×÷¼ÓÉÏͬ²½
2, Ò»¿ªÊ¼¾Í½«ÀàÉè¼Æ³ÉḬ̈߳²È«µÄ, ±ÈÔÚºóÆÚÖØÐÂÐÞ¸´Ëü,¸üÈÝÒ×.
3, ±àд¶àÏ̳߳ÌÐò, Ê×Ïȱ£Ö¤Ë ......
ÄÚ´æÒç³öÓëÊý¾Ý¿âËø±íµÄÎÊÌ⣬¿ÉÒÔ˵ÊÇ¿ª·¢ÈËÔ±µÄجÃΣ¬Ò»°ãµÄ³ÌÐòÒì³££¬×ÜÊÇ¿ÉÒÔÖªµÀÔÚʲôʱºò»òÊÇÔÚʲô²Ù×÷²½ÖèÉϳöÏÖÁËÒì³££¬¶øÇÒ¸ù¾Ý¶ÑÕ»ÐÅÏ¢Ò²ºÜÈÝÒ×¶¨Î»µ½³ÌÐòÖÐÊÇij´¦³öÏÖÁËÎÊÌâ¡£ÄÚ´æÒç³öÓëËø±íÔò²»È»£¬Ò»°ãÏÖÏóÊDzÙ×÷Ò»°ãʱ¼äºóϵͳԽÀ´Ô½Âý£¬Ö±µ½ËÀ»ú£¬µ«²¢²»ÄÜÃ÷È·ÊÇÔÚʲô²Ù×÷ÉϳöÏֵ쬷¢ÉúµÄʱ¼äµãҲûÓÐ ......
Èç¹û×Ô¼ºµÄjava projectÖÐÐèÒªÒýÓöîÍâµÄjar°ü×÷Ϊ×ÊÔ´Îļþ£¬ÄÇôÐèÒª×Ô¶¨ÒåÅäÖÃÎļþMANIFEST.MF ,ÀýÈ磺
Manifest-Version: 1.0
Class-Path: lib\crimson.jar lib\jbcl.jar lib\junit.jar lib\log4j-1.2.13.jar lib\mysql-connector-java-3.1.13-bin.jar
Main-Class: src.YourMainClassName
ÆäÖеÄClass-Path¾ÍÖ¸¶¨ÁËÍ ......
1¡¢½«org.vssplugin_1.6.2Îļþ¼Ð¼°Îļþ¼ÐÖеÄÄÚÈÝcopyµ½...\Genuitec\Common\pluginsĿ¼Ï¡£
2¡¢ÔÚĿ¼...\Genuitec\MyEclipse 7.0\configuration\org.eclipse.equinox.simpleconfigurator µÄÎļþbundles.info×îºó¼ÓÒ»ÐÐ
org.vssplugin,1.6.2,file:plugins\org.vssplugin_1.6.2\,4,false
3¡¢ÖØÆôMyEclipse7.0¼´¿É  ......
JavaÖеķ½·¨µ÷ÓÃÖвÎÊý´«µÝÓÐÁ½ÖÖ£¬Ò»¸öÊǶÔÓÚ²ÎÊýÊÇ»ù±¾ÀàÐ͵ÄʹÓõÄÊÇÖµ´«µÝ£¨Ö±½Ó´«²ÎÊýµÄÖµ£©£¬ÁíÒ»¸öÊÇÒýÓô«µÝ£¬ËüÊÇÓÃÓÚ²ÎÊýÊÇÀàµÄ¶ÔÏó£¬Ëü´«µÝµÄÊÇÕâ¸ö¶ÔÏóµÄÒýÓá£
ÃæÏò¶ÔÏóµÄ˼Ïëanything is Object£¨ÍòÎï½Ô¶ÔÏ󣩳éÏ󣬴ӶԾßÌåµÄ¶ÔÏóÖгéÈ¡ÓÐÓÃÐÅÏ¢¡£¶ÔÏóÓÐÆä¹ÌÓÐÊôÐÔ£¬¶ÔÏóµÄ·½·¨£¬¼´¶ÔÏóµÄÐÐΪ£¨¶ÔÏóÄÜ×öʲ ......