JDBC £¨javaÁ¬½ÓÊý¾Ý¿â£©
ÕâÊÇÎÒÕâÁ½ÌìÁ¬Ò¹·ÜÕ½£¨×Ôѧ£¬ÔÚÕâ֮ǰû½Ó´¥¹ý£©µÄÐÁ¿à³É¹û£¬¾Í²Î¿¼Á˽̲ĺÍJDK APIÎĵµ£¬²ÐȱµÄÊÓƵ½Ì³ÌдµÄ£¬ºóÓÖÓеã¸Ä½ø£¨ÓÅ»¯£©¡£
ÎÒ×ܽáÁËһϣºÕâJDBC³õ¼¶ÖÐÖ÷ÒªÓõ½ÁËÈý¸ö½Ó¿Ú£¬Ò»¸öÀࣨËûÃǵÄʹÓ÷½·¨ºÍÖ÷Òª·½·¨ÎÒ¶¼ÔÚ³ÌÐòºó¼ÓÁË×¢ÊÍ£¬¿ÉÒԲο¼£©£¬¶¼ÊÇjava.sq°üÖеġ£»ù±¾²½ÖèÎÒÔÚ³ÌÐòÖض¼¼ÓÁË×¢ÊÍ£¬ÕâÀï²»Ïêϸ½éÉÜÁË¡£(ËùÓõÄÊý¾Ý¿âÊÇoracle)
ÏÂÃæÎÒÀ´·ÖÀà½éÉÜ£º
1.¡£¡£¡£±íµÄ´´½¨ £¨»ùÓÚÕâÕűíµÄ²Ù×÷£©
drop table person;
create table person
(
pid number(3),
pname varchar2(20),
padress varchar2(20)
);
2.¡£¡£¡£¡£Ö÷³ÌÐò £¨×¢²áÇý¶¯ ¶ÔÊý¾Ý¿âµÄËÄÖÖ²Ù×÷£©
×¢Ò⣺ÆäÖйØÓÚperson_infomation pi µÄ´«Öµ£¬person_infomationÊDZíµÄÐÅÏ¢ÀàÔÚºóÃæ¸ø³öÁË£¬¿ÉÒÔÁ¬½ÓÆðÀ´¿´¡£
package JDBC;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
public class oracle_demo {
private Connection conn=null;
private Statement stmt=null;
private ResultSet rse=null;
// private int pid=0;
// private String pname=null;
// private String padress=null;
//Óù¹Ôì·½·¨À´×¢²áÇý¶¯
public oracle_demo()
{
//×¢²áÇý¶¯
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
}
catch (ClassNotFoundException e)
{
e.printStackTrace();
}
}
//ÏòÊý¾Ý¿âÖÐÔö¼ÓÊý¾Ý
Ïà¹ØÎĵµ£º
Ò»¡¢JavaÔËÐÐʱµÄÁ½ÖÖºËÐÄ»úÖÆ
£¨1£©JavaÐéÄâ»ú£¨Java Virtual Machine£©
ÓÃÀ´´¦ÀíJavaÔ´Îļþ±àÒëºóµÄ×Ö½ÚÂ룬ÆÁ±Îµ×²ãÔËÐÐƽ̨µÄ²îÒ죬ʵÏÖ“Ò»´Î±àÒ룬Ëæ´¦Ö´ÐД£¬¶øÇÒ²»Í¬µÄÔËÐÐÆ ......
¡¶javaÓïÑÔ³ÌÐòÉè¼Æ£¨Ò»£©¡·2009Äê×Ôѧ¿¼ÊÔ´ó¸ÙµÚ3ÕÂ
www.wesiedu.com 2009-5-5 ÔÚÏßÄ£Ä⿼³¡
µÚ3Õ ÃæÏò¶ÔÏó±à³Ì»ù´¡
(Ò»)¿Î³ÌÄÚÈÝ
3.1 ÃæÏò¶ÔÏóµÄ»ù±¾¸ÅÄî
3.2 JavaµÄÀàºÍ¶ÔÏó
3.2.1 Àà
3.2.2¶ÔÏó
3.2.3ʵÀý±äÁ¿ºÍÀà±äÁ¿
3.2.4ʵÀý·½·¨ºÍÀà·½·¨
3.2.5·ÃÎÊȨÏÞ
3.2.6¼Ì³Ð
3.2.7 Java ......
µÚ9Õ ÊäÈëºÍÊä³öÁ÷
(Ò»)¿Î³ÌÄÚÈÝ
9.1×Ö½ÚÁ÷ºÍ×Ö·ûÁ÷
9.1.1 File¶ÔÏó
9.1.2Á÷¶ÔÏó
9.2»º³åʽÊäÈëÊä³ö
9.2.1»º³åʽÊäÈë
9.2.2»º³åʽÊä³ö
9.3Ëæ»ú·ÃÎÊ
9.4Îļþ¶Ô»°¿ò
(¶þ)ѧϰĿµÄÓëÒªÇó
±¾Õ½éÉÜJava³ÌÐòÊý¾ÝÎļþµÄÊäÈëÊä³ö¼¼Êõ¡£ÒªÇóÄܱàд¼òµ¥µÄJavaÎļþ´¦Àí³ÌÐò¡£
(Èý)¿¼ºË֪ʶµãÓ뿼ºËÒªÇó
1.´´½¨File¶ÔÏó£ ......
......