ÈçºÎÅäÖòÅÄÜʹ¿Í»§¶ËÁ¬µ½oracleÊý¾Ý¿â
Ҫʹһ¸ö¿Í»§¶Ë»úÆ÷ÄÜÁ¬½Ó
oracle
Êý¾Ý¿â£¬ÐèÒªÔÚ¿Í»§¶Ë»úÆ÷ÉÏ°²×°
oracle
µÄ¿Í»§¶ËÈí¼þ£¬Î¨Ò»µÄÀýÍâ¾ÍÊÇ
java
Á¬½ÓÊý¾Ý¿âµÄʱºò£¬¿ÉÒÔÓÃ
jdbc thin
ģʽ£¬²»ÓÃ×°
oracle
µÄ¿Í»§¶ËÈí¼þ¡£¼ÓÈëÄãÔÚ»úÆ÷ÉÏ×°ÁË
oracle
Êý¾Ý¿â£¬¾Í²»ÐèÒªÔÚµ¥¶ÀÔڸûúÆ÷ÉÏ°²×°
oracle
¿Í»§¶ËÁË£¬ÒòΪװ
oracle
Êý¾Ý¿âµÄʱºò»á×Ô¶¯°²×°
oracle
¿Í»§¶Ë¡£
Óùý
sql server
Êý¾Ý¿âÈ»ºóÓÖÓÃ
oracle
µÄÐÂÊÖ¿ÉÄÜ»áÓÐÕâÑùµÄÒÉÎÊ£ºÎÊʲôÎÒÓÃ
sql server
µÄʱºò²»ÓÃ×°
sql server
µÄ¿Í»§¶ËÄØ£¿ÔÒòºÜ¼òµ¥£¬
sql server
Ò²ÊÇ
microsoft
µÄ£¬ËüÔÚ²Ù×÷ϵͳÖм¯³ÉÁË
sql server
¿Í»§¶Ë£¬Èç¹û
microsoft
Óë
oracle
ÓÐÐÒ飬½«
oracle
¿Í»§¶ËÒ²¼¯³Éµ½²Ù×÷ϵͳÖУ¬
ÄÇÎÒÃÇÒ²¾Í²»ÓÃÔÚ¿Í»§¶Ë»úÆ÷×°
Oracle
¿Í»§¶ËÈí»ú¾Í¿É·ÃÎÊÊý¾Ý¿âÁË£¬²»¹ý£¬ÕâºÃÏñÊDz»¿ÉÄÜʵÏÖµÄÊÂ
Çé¡£
IXDBA.NETÉçÇøÂÛ̳
Ò²ÓеÄÈË»áÎÊ£ºÎªÊ²Ã´ÔÚ
sql server
ÖÐûÓÐÕìÌý¶Ë¿Úһ˵£¬¶øÔÚ
oracle
ÖÐÒªÅäÖÃÕìÌý¶Ë¿Ú£¿Æäʵ
sql server
ÖÐÒ²ÓÐÕìÌý¶Ë¿Ú£¬Ö»²»¹ý
microsoft
½«ÕìÌý¶Ë¿Ú¹Ì¶¨Îª
1433
£¬²»ÔÊÐíÄãËæ±ã¸Ä¶¯£¬ÕâÑù¸øÄãÒ»¸ö´í¾õ¸Ð¾õ
sql server
ÖÐûÓÐÕìÌý¶Ë¿Ú£¬¿È£¬
microsoft
°ÑÌ«¶àµÄ¶«Î÷¶¼·â×°µ½ºÚºÐ×ÓÀ·½±ãʹÓõÄͬʱҲ´øÀ´µÄÐèÒª¸±
×÷Ó᣶ø
oracle
ÖеÄÕìÌý¶Ë¿ÚÖ±½ÓÔÚÅäÖÃÎļþÖУ¬ÔÊÐíËæ±ã¸Ä¶¯£¬Ö»²»¹ýÎÞÂÛÔõÑù¸Ä¶¯£¬ÒªÓë
oracle
·þÎñÆ÷¶ËÉèÖõÄÕìÌý¶Ë¿ÚÒ»Ö¡£
ºÃ£¬ÑÔ¹éÕý´«£¬ÎÒÃÇÈçºÎ×ö²ÅÄÜʹ¿Í»§
¶Ë»úÆ÷Á¬½Óµ½
oracle
Êý¾Ý¿âÄØ£¿
A
£®
°²×°Ïà¹ØÈí¼þ
B
£®
½øÐÐÊʵ±µÄÅäÖÃ
A
£®ÔÚÊʵ±µÄλÖð²×°Êʵ±µÄÈí¼þ£º
¡¡¡¡ÔÚ¿Í»§¶Ë»úÆ÷£º
1
£®ÔÚ¿Í»§¶Ë»úÆ÷ÉÏ°²×°
ORACLE
µÄ
Oracle Net
ͨѶÈí¼þ£¬Ëü°üº¬ÔÚ
oracle
µÄ¿Í»§¶ËÈí¼þÖС£
2
£®ÕýÈ·ÅäÖÃÁË
sqlnet.ora
Îļþ£º
NAMES.DIRECTORY_PATH = (TNSNAMES, ….)
NAMES.DEFAULT_DOMAIN=DB_DOMAIN
Ò»°ãÇé¿öÏÂÎÒÃDz»
ÓÃ
N
Ïà¹ØÎĵµ£º
1import java.sql.*;
2import java.util.logging.Level;
3import java.util.logging.Logger;
4
5/** *//**
6 * Title: JDBCÁ¬½ÓÊý¾Ý¿â
7 * Description: ±¾ÊµÀýÑÝʾÈçºÎʹÓÃJDBCÁ¬½ÓOracleÊý¾Ý¿â£¬²¢ÑÝʾÌí¼ÓÊý¾ÝºÍ²éѯÊý¾Ý.
8 */
9public class JDBCExampl ......
Ò»¡¢ Hibernate½éÉÜ
HibernateÊÇ»ùÓÚ¶ÔÏó/¹ØϵӳÉ䣨ORM£¬Object/Relational Mapping£©µÄÒ»¸ö½â¾ö·½°¸¡£ORM·½°¸µÄ˼ÏëÊǽ«¶ÔÏóÄ£ÐͱíʾµÄ¶ÔÏóÓ³Éäµ½¹ØϵÐÍÊý¾Ý¿âÖУ¬»òÕß·´Ö®¡£HibernateÄ¿Ç°ÊÇORM˼ÏëÔÚJavaÖÐ×î³É¹¦¡¢×îÇ¿´óµÄʵÏÖ¡£ËüÓÚ2001ÄêµÄÄêÄ©·¢²¼µÚÒ»¸ö°æ±¾£¬Á¢¼´ÒýÆðÁ˹㷺µÄ×¢Òâ¡£2003Äê6Ô£ ......
Ò»¸öʹÓÃibatis¶ÔÊý¾Ý¿âÔöɾ¸Ä²éµÄÀý×Ó:
ÕâÀïÓõĿª·¢»·¾³ÊÇ:Eclipse3.2+mysql5.0.20,ibatis°üÊÇibatis-common-2.jar,
ibatis-dao-2.jar,ibatis-sqlmap-2.jar,mysql°üÊÇmysql-connector-java-5.0.3-bin.jar.
²½Öè:
1.´´½¨Êý¾Ý¿â:
create database itcast;
use itcast;
´´½¨±í£º
create table stu ......
µ±±¾»ú°²×°ÁËORACLEÊý¾Ý¿âºó£¬ÔÙ°²×°ÔËÐÐOC4JµÄ»°£¬»·¾³±äÁ¿“ORACLE_HOME”ÓëORACLEÊý¾Ý¿âÓгåÍ»£¬¿ÉÒÔ°´ÕÕÈçÏ·½·¨½â¾ö´ËÎÊÌ⣺
·½·¨Ò»
µÚÒ»²½£ºÔÚ»·¾³±äÁ¿ÖÐн¨“OC4J_HOME”£¬Ö¸¶¨µ½ÄãµÄOC4J°²×°¸ùĿ¼£»
µÚ¶þ²½£º´ò¿ªOC4J°²×°µÄĿ¼£¬¼´../OC4J/bin/£¬ÀïÃæÓÐÒ»¸öoc4j.cmd£¬ÓÒ¼üµ¥»÷¸ÃÎļþ£¬Ñ ......