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º¯Êý´óÈ«-Êý×Ö´¦Àíº¯Êý
F.3 Êý×Öº¯Êý
º¯Êý½ÓÊÜNUMBERÀàÐ͵IJÎÊý²¢·µ»ØNUMBERÀàÐ͵ÄÊýÖµ.³¬Ô½º¯ÊýºÍÈý½Çº¯ÊýµÄ·µ»ØÖµ¾«È·µ½36λ.ACOS¡¢ASIN¡¢ATAN¡¢ATAN2µÄ½á¹û¾«È·µ½36λ.
l ABS
Óï·¨: ABS(x)
¹¦ÄÜ: µÃµ½xµÄ¾ø¶ÔÖ ......
oracle9 startupʱ ±¨´íORA-00600: ÄÚ²¿´íÎó´úÂ룬²ÎÊý: [kcratr1_lostwrt], [], [], [], [], [], [], []
ÔÒò¿ÉÄÜÊÇ·Ç·¨¹Ø»ú»òµôµçÔì³É,ÒÔÏÂÊdzöÏÖµÄÎÊÌâ¼°½â¾ö·½·¨:
C:\Documents and Settings\Administrator>sqlplus
SQL*Plus: Release 9.2.0.1.0 - Production on ÐÇÆÚÈÕ 5ÔÂ 13 09:23:23 2007 ......
OracleÓ¦ÓÃÌåϵ½á¹¹
°üº¬ÈçÏÂÖ÷Ì⣺
¡£¿Í»§¶Ë/·þÎñÆ÷Ìåϵ½á¹¹¼ò½é
¡£¶à²ãÌåϵ½á¹¹¸ÅÊö
¡£OracleÍøÂç·þÎñ¸ÅÊö
1¡£¿Í»§¶Ë/·þÎñÆ÷Ìåϵ½á¹¹¼ò½é
ÔÚOracleÊý¾Ý¿âϵͳÖУ¬Êý¾Ý¿âÓ¦ÓóÌÐòÓëÊý¾Ý¿â±»·ÖΪÁ½²¿·Ö£ºÇ°¶Ë(front-end)»ò³ÆÎª¿Í»§¶Ë(client)£¬ºǫ́(back-end)»ò³ÆÎª·þÎñ¶Ë---Õâ¾ÍÊǿͻ§¶Ë/·þÎñÆ÷Ìåϵ½á¹¹Ãû×ÖµÄÓÉÀ´¡£ ......
insert into dts_auction_comments (id,auction_id,user_id,user_nick,comments,gmt_create,gmt_modified,status,comm_type)
values(409,127380, ......
1. ½«Êý¾Ý¿âÍêÈ«µ¼³ö
Óû§Ãûsystem ÃÜÂësystem µ¼³öµ½OracleÓû§Ä¿Â¼ÏµÄtestdb20100522.dmpÎļþÖÐ
#exp system/system@testdb file=testdb20100522.dmp full=y
2. ½«Êý¾Ý¿âÖÐsystemÓû§ÓësysÓû§µÄ±íµ¼³ö
#exp system/system@testdb file= testdb20100522.d ......