Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 8i Êý¾Ý¿âʱÓöµ½µÄÎÊÌâ

oracle8i Çý¶¯ ojdbc14.jar Õâ¸öÇý¶¯ÓÐÎÊÌ⣬·ÖҳʱҪÊÖ¶¯ д rownum<m ,Ëü×Ô¶¯³ÉÉúµÄ·ÖÒ³²»ÕýÈ·£¬ÓõÄmysqlµÄtop m
Null value was assigned to a property of primitive °ÑentityÖÐintÀàÐ͸ijÉInteger  ¿âÖв»ÉèÖÃnullable
number(9) µÄid ²»ÄÜÓÃInterger,µÃÓÃBigDecimal,Òª²»È»È¡idʱ»á±¨´í ......

OracleÓ¦ÓÃÌåϵ½á¹¹

OracleÓ¦ÓÃÌåϵ½á¹¹
°üº¬ÈçÏÂÖ÷Ì⣺
¡£¿Í»§¶Ë/·þÎñÆ÷Ìåϵ½á¹¹¼ò½é
¡£¶à²ãÌåϵ½á¹¹¸ÅÊö
¡£OracleÍøÂç·þÎñ¸ÅÊö
1¡£¿Í»§¶Ë/·þÎñÆ÷Ìåϵ½á¹¹¼ò½é
ÔÚOracleÊý¾Ý¿âϵͳÖУ¬Êý¾Ý¿âÓ¦ÓóÌÐòÓëÊý¾Ý¿â±»·ÖΪÁ½²¿·Ö£ºÇ°¶Ë(front-end)»ò³ÆΪ¿Í»§¶Ë(client)£¬ºǫ́(back-end)»ò³ÆΪ·þÎñ¶Ë---Õâ¾ÍÊÇ¿Í»§¶Ë/·þÎñÆ÷Ìåϵ½á¹¹Ãû×ÖµÄÓÉÀ´¡£ ......

Oracle 10g R2 RACÔÚVMWAREÉϵݲװ

½¨Á¢sshÐÅÈΣ¬racµÄ°²×°ÒªÓÃsshºÍscpÀ´¿½±´°²×°Îļþ¡£
ÔÚËùÓеĽڵãÉÏÔËÐУº
mkdir ~/.ssh
chmod 700 ~/.ssh
ssh-keygen -t rsa
ssh-keygen -t dsa
ÔÚrdb1½ÚµãÉÏÖ´ÐУº
ssh rdb1 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
ssh rdb1 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys
ssh rdb2 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ