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();
}
}
//ÏòÊý¾Ý¿âÖÐÔö¼ÓÊý¾Ý
Ïà¹ØÎĵµ£º
ÓÐ600¸öÆ»¹û£¬10¸öºÐ×Ó£¬ÒªÇó°Ñ600¸öÆ»¹û·Ö×°µ½10¸öºÐ×ÓÀï¡£Èç¹ûÓÐÈËÀ´ÂòÆ»¹ûËæ±ã˵³öÒ»¸öÊý£¬Ö±½ÓÄÃÕâЩºÐ×Ó×éװһϾͿÉÒÔ¸øËû²»Óòð·ÖºÐ×Ó¡£ÇëÎÊÕâ10¸öºÐ×ÓÓ¦¸Ã·Ö±ð×°¶àÉÙÆ»¹û£¿
´úÂëÈçÏÂ
import java.util.Scanner;
public class Test {
public static void main(String[] args) {
int box[] = ......
°²×°Java¿ª·¢Èí¼þʱ£¬Ä¬Èϰ²×°°üº¬Á½¸öÎļþ¼Ð£¬Ò»¸öJDK(Java¿ª·¢¹¤¾ßÏä)£¬Ò»¸öJRE(JavaÔËÐл·¾³£¬ÄÚº¬JVM)£¬ÆäÖÐJDKÄÚÁíº¬Ò»¸öJRE¡£Èç¹ûÖ»ÊÇÔËÐÐJava³ÌÐò£¬ÔòJREÒÑ×ã¹»£»¶øJDKÔòÖ»Óпª·¢ÈËÔ±²ÅÓõ½¡£
Ò»¡¢JVMÄÚ´æ·ÖÅäÉèÖÃ
1. JVMÄÚ´æ·ÖÅäÉèÖõIJÎÊýÓÐËĸö£º
-Xmx Java Heap×î´óÖµ£¬Ä¬ÈÏֵΪÎïÀíÄÚ´æµÄ ......
µÚ10ÕÂ ÍøÂçÓëÊý¾Ý¿â±à³Ì»ù´¡
(Ò»)¿Î³ÌÄÚÈÝ
10.1 JavaÍøÂç±à³Ì»ù´¡
10.1.1 IPµØÖ·ºÍInetAddressÀà
10.1.2ͳһ×ÊÔ´¶¨Î»·ûURL
10.1.3¿Í»§»ú/·þÎñÆ÷ģʽ
l0.2 JavaÊý¾Ý¿â±à³Ì»ù´¡
10.2.1 Java³ÌÐòÓëÊý¾Ý¿âÁ¬½Ó
10.2.2¼¸¸öÖØÒªµÄÀàºÍ½Ó¿Ú
10.2.3Êý¾Ý¿â²éѯ
10.2.4Êý¾Ý¿â¸üÐÂ
(¶þ)ѧϰĿµÄÓëÒªÇó
±¾Õ½éÉÜJavaÍøÂç± ......