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
 
Ïà¹ØÎĵµ£º
CHAR ¹Ì¶¨³¤¶È×Ö·û´® ×î´ó³¤¶È2000 bytes
VARCHAR2 ¿É±ä³¤¶ÈµÄ×Ö·û´® ×î´ó³¤¶È4000 bytes ¿É×öË÷ÒýµÄ×î´ó³¤¶È749
NCHAR ¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¹Ì¶¨³¤¶È×Ö·û´® ×î´ó³¤¶È2000 bytes
NVARCHAR2 ¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¿É±ä³¤¶È×Ö·û´® ×î´ó³¤¶È4000 bytes
DATE ÈÕÆÚ£ ......
oracle9iжÔØ
1,ÔÚ·þÎñÖÐÍ£Ö¹oracleµÄËùÓзþÎñ
2,ÔÚ³ÌÐòÁËжװËùÓÐOracle²úÆ·£¬(µ«Universal Installer±¾Éí²»Äܱ»É¾³ý)
3,ɾ³ý×¢²á±í:
(1)ÔËÐÐregeditÑ¡ÔñHKEY_LOCAL_MACHINE\SOFTWARE\ORACLE£¬É¾³ýÕâ¸öÏî
(2)Ñ¡ÔñHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Oracle,ɾ³ýÕâ¸öÏî.
(3),Ñ¡ÔñHKEY_LOCAL_MACHI ......
oracleº¯Êý´óÈ«-Êý×Ö´¦Àíº¯Êý
F.3 Êý×Öº¯Êý
º¯Êý½ÓÊÜNUMBERÀàÐ͵IJÎÊý²¢·µ»ØNUMBERÀàÐ͵ÄÊýÖµ.³¬Ô½º¯ÊýºÍÈý½Çº¯ÊýµÄ·µ»ØÖµ¾«È·µ½36λ.ACOS¡¢ASIN¡¢ATAN¡¢ATAN2µÄ½á¹û¾«È·µ½36λ.
l ABS
Óï·¨: ABS(x)
¹¦ÄÜ: µÃµ½xµÄ¾ø¶ÔÖ ......
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ʱ»á±¨´í ......
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 ......