Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ʹÓÃJavaµ÷ÓÃOracleÊý¾Ý¿âµÄ´æ´¢¹ý³ÌʵÀý

Ò»£ºÎÞ·µ»ØÖµµÄ´æ´¢¹ý³Ì
1¡¢½¨Á¢´æ´¢¹ý³Ì
CREATE OR REPLACE PROCEDURE TESTA(PARA1 IN VARCHAR2,PARA2 IN VARCHAR2) AS
BEGIN
INSERT INTO T_TEST (I_ID,I_NAME) VALUES (PARA1, PARA2);
END TESTA;
2¡¢ÏàÓ¦µÄJAVA³ÌÐò
import java.sql.*;
import java.io.OutputStream;
import java.io.Writer;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import oracle.jdbc.driver.*;
public class TestProcedureOne {
public TestProcedureOne() {
}
public static void main(String[] args ){
String driver = "oracle.jdbc.driver.OracleDriver";
String strUrl = "jdbc:oracle:thin:@192.168.10.216:1521:ctbu";
Statement stmt = null;
ResultSet rs = null;
Connection conn = null;
CallableStatement cstmt = null;
try {
Class.forName(driver);
conn = DriverManager.getConnection(strUrl, "dbname", "password");
CallableStatement proc = null;
proc = conn.prepareCall("{ call dbname.TESTA(?,?) }");
proc.setString(1, "100");
proc.setString(2, "TestOne");
proc.execute();
}
catch (SQLException ex2) {
ex2.printStackTrace();
}
catch (Exception ex2) {
ex2.printStackTrace();
}
finally{
try {
if(rs != null){
rs.close();
if(stmt!=null){
stmt.close();
}
if(conn!=null){
conn.close();
}
}
}
catch (SQLException ex1) {
}
}
}
}
¶þ£ºÓзµ»ØÖµµÄ´æ´¢¹ý³Ì£¨·ÇÁÐ±í£©
1¡¢´æ´¢¹ý³ÌΪ
CREATE OR REPLACE PROCEDURE TESTB(PARA1 IN VARCHAR2,PARA2 OUT VARCHAR2) AS
BEGIN
SELECT INTO PARA2 from TESTTB WHERE I_ID= PARA1;
END TESTB;
2¡¢JAVA´úÂë
public class TestProcedureTWO {
public TestProcedureTWO() {
}
public static void main(String[] args ){
String driver = "oracle.jdbc.driver.OracleDriver";
String strUrl = "jdbc:oracle:thin:@192.168.10.216:1521:ctbu";
Statement stmt = null;
ResultSet rs = null;
Connection conn = null;
try {
Class.forName(driver);
conn = DriverManager.getConnection(strUrl, "dbname", "password");
CallableStatement proc = null;
proc = conn.prepareCall("{ call HYQ.TESTB(?,?) }");
proc.setString(1, "100");
proc.registerOutParameter(2, Types.VARCHAR);
proc


Ïà¹ØÎĵµ£º

JavaÉè¼ÆÄ£Ê½Ö®:IteratorÁ´±íģʽ

ÏÈÀ´Á˽âÒ»ÏÂÁ´±íģʽµÄÔ­Àí£º
Ê×ÏÈдһ¸öJavaBean£¬ÄÚÈÝÊÇÒªÌí¼ÓµÄÔªËØºÍ¸ÃÔªËØµÄ½Úµã¡£
public class NodeBean implements Serializable
{
   
    private Object data; //ÔªËØ±¾Éí
    private NodeBean next; //ÏÂÒ»¸ö½Úµã
   
  &n ......

Oracle11gR2 for Linux ¾²Ä¬°²×°±Ê¼Ç


±¾ÎĵµÊÇOracle
Database 11.2.0.1 for RHEL5 Server(°üÀ¨x86ºÍx86_64ƽ̨)µÄ¾²Ä¬°²×°Ö¸ÄÏ. ËùÓвÙ×÷ÎÞÐèʹÓÃͼÐνçÃæ. ¾²Ä¬°²×°ÄܼõÉÙ°²×°³ö´íµÄ¿ÉÄÜÐÔ, Ò²ÄÜ´ó´ó¼Ó¿ì°²×°ËÙ¶È.
# ºó¸úÃüÁî±íʾÒÔ²Ù×÷ϵͳÏÂrootÓû§²Ù×÷;  ºó¸úÃüÁî±íʾÒÔ²Ù×÷ϵͳÏÂoracleÓû§²Ù×÷;
1.1 ÉÏ´«Èí¼þ
¼ÙÈç·ÅÔÚ/wangnc/oracle/11g/Ä ......

¹ØÓÚJAVA,JSPµÄ1¸öÎÊÌâ

×î½üÔÚѧJAVA£¬Á·Ï°µÄʱºòÓöµ½¸öÎÊÌ⣬Çë´ó¼Ò°ïæ¿´¿´……
Ö÷ÒªÎÊÌâÊÇ£¬ÔÚJSPÖÐûÓа취µ¼ÈëÎÒÏëÓõÄÀ࣬Ã÷Ã÷µ¼ÈëÁ˰ü£¬È´±¨£ºMyDAO cannot be resolved to a type
JSP´úÂ룺
<%@ page contentType="text/html;charset=GBK"%>
<%@ page import="java.util.Date"%>
<%@ page import="java.t ......

Java 23ÖÖÉè¼ÆÄ£Ê½Ò»µã¾Íͨ

Ò»¡¢´´½¨ÐÍģʽ
¡¡¡¡FACTORY£¿È˲ÅÊг¡£ºÒÔÍùÊÇÒªÄĸöÈ˲ţ¬¾ÍÕÒÄĸöÈ˲ţ¬Ð§Âʵͣ¬ÏÖÔÚÓÐÁËÈ˲ÅÊг¡£¬ÎÒÃÇÖ»ÐèÖ±½ÓÈ¥È˲ÅÊг¡ÌôÒ»¸öºÃÁË£»
¡¡¡¡BUILDER£¿Éú²úÁ÷Ë®ÏߣºÒÔǰÊÇÊÖ¹¤Òµ×÷·»Ê½µÄÈ˹¤µ¥¸öµ¥¸öµÄÉú²úÁã¼þÈ»ºóÒ»²½Ò»²½×é×°×ö£¬ºÃ±ÈÓÐÁ˹¤Òµ¸ïÃü£¬ÏÖÔÚ¶¼ÓÉÉú²úÁ÷Ë®Ïß´úÌæÁË¡£ÈçÒªÔì·áÌïÆû³µ£¬ÏÈÖÆ¶¨Æû³µµÄ¹¹ÔìÈç ......

JavaÄÚ²¿ÀࣨInner Class£©

¼òµ¥µÄ˵£¬ÄÚ²¿£¨inner£©ÀàÖ¸ÄÇЩÀඨÒå´úÂë±»ÖÃÓÚÆäËüÀඨÒåÖеÄÀࣻ¶ø¶ÔÓÚÒ»°ãµÄ¡¢ÀඨÒå´úÂ벻ǶÌ×ÔÚÆäËüÀඨÒåÖеÄÀ࣬³ÆÎª¶¥²ã£¨top-level£©Àà¡£¶ÔÓÚÒ»¸öÄÚ²¿À࣬°üº¬Æä¶¨Òå´úÂëµÄÀà³ÆÎªËüµÄÍⲿ£¨outer£©Àà¡£
1 Static member class£¨¾²Ì¬³ÉÔ±Àࣩ
ÀàÉùÃ÷Öаüº¬“static”¹Ø¼ü×ÖµÄÄÚ²¿Àà¡£ÈçÒÔÏ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ