Javaµ÷ÓÃOracle´æ´¢¹ý³Ì
µÚÒ»ÖÖÇé¿ö£ºÎÞ·µ»ØÖµ.
create or replace procedure test_a(param1 in varchar2,param2 in varchar2) as
begin
insert into test value(param1,param2);
end;
Javaµ÷ÓôúÂë:
package com.test;
import java.sql.*;
import java.io.*;
import java.sql.*;
public class TestProcA
{
public TestProcA(){
}
public static void main(String []args)
{
ResultSet rs = null;
Connection conn = null;
CallableStatement proc = null;
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:test", "test", "test");
proc = conn.prepareCall("{ call test_a(?,?) }");
proc.setString(1, "1001");
proc.setString(2, "TestA");
proc.execute();
}catch(Exception e){
e.printStackTrace();
}finally{
try{
if(null!=rs){
rs.close();
if(null!=proc){
 
Ïà¹ØÎĵµ£º
Êý¾Ý¿â²éѯÖÐÄÑÃâ»áÓöµ½ÐÐÁÐת»»µÄÇé¿ö£¬ÕªÁÐһЩ½Ï¾«µäµÄ½â¾ö·½°¸
--####################################################################
Ò»¡¢²ÉÓÃSQL decodeºÍPL/SQLº¯ÊýʵÏÖ
--####################################################################
1¡¢¹Ì¶¨ÁÐÊýµÄÐÐÁÐת»»
Èç
student subject grade
------ ......
<!--
/* Font Definitions */
@font-face
{font-family:ËÎÌå;
panose-1:2 1 6 0 3 1 1 1 1 1;
mso-font-alt:SimSun;
mso-font-charset:134;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:3 135135232 16 0 262145 0;}
@font-face
{font-family:"\@ËÎÌå" ......
°ó¶¨±äÁ¿¾ÍÊÇÄܹ»Ìæ´úSQLÓï¾äÖг£Á¿µÄÌæ´ú±äÁ¿
×÷Óãº
°ó¶¨±äÁ¿Ö»ÊÇÆðµ½Õ¼Î»µÄ×÷Óã¬Í¬ÃûµÄ°ó¶¨±äÁ¿²¢²»Òâζ×ÅÔÚËüÃÇÊÇͬÑùµÄ£¬ÔÚ´«µÝʱҪ¿¼ÂǵÄÊÇ´«µÝµÄÖµÓë°ó¶¨±äÁ¿³öÏÖ˳ÐòµÄ¶Ô룬¶ø²»Êǰ󶨱ä Á¿µÄÃû³Æ¡£
°ó¶¨±äÁ¿ÊÇÔÚͨ³£Çé¿öÏÂÄÜÌáÉýЧÂÊ£¬·ÇÕý³£µÄÇé¿öÈçÏ£º
ÔÚ×Ö¶Î(°üÀ¨×ֶμ¯)½¨ÓÐË÷Òý£¬Ç ......
Java Reflect±àд ͨÓÃÊý×éÀ©Õ¹Àà
package com.accp.array;
import java.lang.reflect.Array;
public class GrowArrayTest {
public static void main(String[] args) {
Integer[] array = {1,2,3,4}; //ͨÓÃÀ©Õ¹
arrayPrint(arra ......
Ïֽ׶ÎJAVA²Ù×÷ExcelµÄJARÖ÷ÒªÓÐapache µÄ POI¼° JXL.
ÒòΪÏÖÔÚµÄeclipse²Ù×÷excelÓõIJå¼þΪjxl£¬ËùÒÔÔÚÏîÄ¿ÖоÍʹÓÃÁËjxl£®
ÏëÏëÁ½Õ߶¼²î²»ÁËÌ«¶à£®
´Ë¼òµ¥ÏµÁÐΪÁ½¸ö²¿·Ö£¬Ò»ÊÇAPIϵÁУ¨ÔÙ¹ÙÍøhttp://www.andykhan.com/jexcelapi/download.html¿ÉÒÔÖ±½ÓÏÂÔØ£©£¬
ÁíÒ»²¿·ÖÔòÊÇÓ¦ÓÃϵÁУ®
ÔÚÕâÀïÏÈÕÒÁ˸öÀý×Ó¸ø´ó¼Ò£ ......