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

ibatisÁ¬½ÓoracleÀý×Ó£¡

Ò»¸öʹÓÃ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 student
 (
  id int primary key auto_increment,
  firstname varchar(20) not null,
  lastname varchar(20) not null
 )
2.´´½¨POJOÀà,Student.java£¬´Ë³ÌÐòÖÐÓõ½µÄËùÓÐÀà¶¼·ÅÔÚcn.itcast°üÏÂÃæ£¬
 ÆäËûµÄÅäÖÃÎļþ¶¼·ÅÔÚtxd.configfile°üÏÂÃæ¡£
 package cn.itcast;
 
 public class Student {
  private Integer id;
 
  private String firstname;
 
  private String lastname;
 
  public String getFirstname() {
   return firstname;
  }
 
  public void setFirstname(String firstname) {
   this.firstname = firstname;
  }
 
  public Integer getId() {
   return id;
  }
 
  public void setId(Integer id) {
   this.id = id;
  }
 
  public String getLastname() {
   return lastname;
  }
 
  public void setLastname(String lastname) {
   this.lastname = lastname;
  }
 }
3.¸úStudentÀà¶ÔÓ¦µÄxmlÅäÖÃÎļþStudent.xml,
 <?xml version="1.0" encoding="UTF-8"?>
 <!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd">
 <sqlMap namespace="student">
  <!--insertÔªËØ,idÊôÐÔÖµ×÷Ϊ±êʶ´ËÔªËØ,parameterClassÊôÐÔÊDzÎÊýµÄÀàÐÍ,´Ë
  ÊôÐÔµÄÖµÊÇJavaÀàµÄÈ«ÏÞ¶¨Ãû£¨¼´°üÀ¨ÀàµÄ°üÃû£©¡£ËüÊÇ¿ÉÑ¡µÄ£¬µ«Ç¿ÁÒ½¨ÒéʹÓá£
  ËüµÄÄ¿µÄÊÇ ÏÞÖÆÊäÈë²ÎÊýµÄÀàÐÍΪָ¶¨µÄJavaÀ࣬²¢ÓÅ»¯¿ò¼ÜµÄÐÔÄÜ¡£##·ûºÅÖÐ
  ¼äµÄÃû×ÖÀ´×Ô´ËÀàµÄÊôÐÔ.-->
  <insert id="insert_student" parameterClass="cn.itcast.Student">
   insert into student(firstname,lastname) values
  


Ïà¹ØÎĵµ£º

oracle ´óÊý¾Ý²éѯÓÅ»¯µÄ·½°¸

ijÊý¾Ý¿âÖеÄÒ»ÕűíA,±íAµÄÊý¾Ý¿âÁ¿ÏÖÔÚ´ó¸ÅÓÐ10ÒÚÌõÊý¾ÝÖ®¶à.
×î³õµÄ×ö·¨ÊÇÈ«²¿´æ·ÅÔÚÒ»¸ö±í¿Õ¼äÖÐ.Ôì³ÉÏÖÔڵIJéѯËٶȹêÅÀËÆµÄ.ÏÖÔÚ²»µÃ²»¶ÔÊý¾Ý¿â×ö³öÖØÐÂÆÀ¹ÀºÍÓÅ»¯.
×î³õµÄǰÌá:
1.ÖÐÓ¦¸Ã½¨Á¢µÄË÷Òý¶¼ÒѾ߱¸
2.²éѯÓï¾ä¶¼ÒѾ­×öµ½ÓÅ»¯:ÏÖÔÚÀàËÆÓÚ select count(1) from A Õâô¼òµ¥µÄÒ»¾äͳ¼ÆSQL¶¼ÐèÒª100S×óÓÒ
ta ......

oracleº¯Êý´óÈ« Êý×Ö´¦Àíº¯Êý


oracleº¯Êý´óÈ«-Êý×Ö´¦Àíº¯Êý
F.3    Êý×Öº¯Êý
º¯Êý½ÓÊÜNUMBERÀàÐ͵IJÎÊý²¢·µ»ØNUMBERÀàÐ͵ÄÊýÖµ.³¬Ô½º¯ÊýºÍÈý½Çº¯ÊýµÄ·µ»ØÖµ¾«È·µ½36λ.ACOS¡¢ASIN¡¢ATAN¡¢ATAN2µÄ½á¹û¾«È·µ½36λ.
l         ABS
Óï·¨:   ABS(x)
¹¦ÄÜ:   µÃµ½xµÄ¾ø¶ÔÖ ......

OracleÆô¶¯·þÎñÏê½âÒÔ¼°ÊÖ¶¯¿ØÖÆ

OracleÆô¶¯Ê±ÐèÒªµÄ·þÎñ£º
Ô­ÌûµØÖ·£ºhttp://www.blogjava.net/sidanzhou/archive/2008/03/03/183507.html
×¢£ºSID - Êý¾Ý¿â±êʶ
HOME_NAME - Oracle HomeÃû³Æ£¬ÈçOraHome92¡¢OraHome81
£¨1£©OracleServiceSID
Êý¾Ý¿â·þÎñ£¬Õâ¸ö·þÎñ»á×Ô¶¯µØÆô¶¯ºÍÍ£Ö¹Êý¾Ý¿â¡£Èç¹û°²×°ÁËÒ»¸öÊý¾Ý¿â£¬ËüµÄȱʡÆô¶¯ÀàÐÍΪ×Ô¶¯¡£·þÎñ½ø³ ......

Oracle DB Link


Êý¾Ý¿âÖ®¼äµÄÁ´½Ó½¨Á¢ÔÚDATABASE LINKÉÏ¡£Òª´´½¨Ò»¸öDB LINK£¬±ØÐëÏÈÔÚÿ¸öÊý¾Ý¿â·þÎñÆ÷ÉÏÉèÖÃÁ´½Ó×Ö·û´®¡£
  
1¡¢ ÅäÖÃTNS £¬ $ORACLE_HOME/NETWORK/ADMIN/tnsname.ora
10gstandby =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = HFCC-KF-3068)(PORT = ......

Ò»¸ö¼òµ¥µÄhibernateÁ¬½ÓoracleÊý¾Ý¿âÀý×Ó£¡

Ò»¡¢ Hibernate½éÉÜ
    HibernateÊÇ»ùÓÚ¶ÔÏó/¹ØÏµÓ³É䣨ORM£¬Object/Relational Mapping£©µÄÒ»¸ö½â¾ö·½°¸¡£ORM·½°¸µÄ˼ÏëÊǽ«¶ÔÏóÄ£ÐͱíʾµÄ¶ÔÏóÓ³Éäµ½¹ØÏµÐÍÊý¾Ý¿âÖУ¬»òÕß·´Ö®¡£HibernateĿǰÊÇORM˼ÏëÔÚJavaÖÐ×î³É¹¦¡¢×îÇ¿´óµÄʵÏÖ¡£ËüÓÚ2001ÄêµÄÄêÄ©·¢²¼µÚÒ»¸ö°æ±¾£¬Á¢¼´ÒýÆðÁ˹㷺µÄ×¢Òâ¡£2003Äê6Ô£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ