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
 
Ïà¹ØÎĵµ£º
F.1×Ö·ûº¯Êý——·µ»Ø×Ö·ûÖµ
ÕâЩº¯ÊýÈ«¶¼½ÓÊÕµÄÊÇ×Ö·û×åÀàÐ͵IJÎÊý(CHR³ýÍâ)²¢ÇÒ·µ»Ø×Ö·ûÖµ.³ýÁËÌØ±ð˵Ã÷µÄÖ®Íâ,ÕâЩº¯Êý´ó²¿·Ö·µ»ØVARCHAR2ÀàÐ͵ÄÊýÖµ.×Ö·ûº¯ÊýµÄ·µ»ØÀàÐÍËùÊܵÄÏÞÖÆºÍ»ù±¾Êý¾Ý¿âÀàÐÍËùÊܵÄÏÞÖÆÊÇÏàͬµÄ,±ÈÈç: VARCHAR2ÊýÖµ±»ÏÞÖÆÎª2000×Ö·û(ORACLE 8ÖÐΪ4000×Ö·û),¶øCHARÊýÖµ±»ÏÞÖÆÎª255×Ö·û(Ô ......
½¨Á¢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 ......
1. ´´½¨ÆÕͨÓû§
>create user username identified by username;
>grant create tablespace, resource ,connect to username;
2. ´´½¨±í¿Õ¼äºÍÓû§
2.1 ´´½¨ÁÙʱ±í¿Õ¼ä
>create temporary tablespace DB_TEMP
tempfile '/opt/oracle/oradata/mydb/t ......
Ò»¡¢ Hibernate½éÉÜ
HibernateÊÇ»ùÓÚ¶ÔÏó/¹ØÏµÓ³É䣨ORM£¬Object/Relational Mapping£©µÄÒ»¸ö½â¾ö·½°¸¡£ORM·½°¸µÄ˼ÏëÊǽ«¶ÔÏóÄ£ÐͱíʾµÄ¶ÔÏóÓ³Éäµ½¹ØÏµÐÍÊý¾Ý¿âÖУ¬»òÕß·´Ö®¡£HibernateĿǰÊÇORM˼ÏëÔÚJavaÖÐ×î³É¹¦¡¢×îÇ¿´óµÄʵÏÖ¡£ËüÓÚ2001ÄêµÄÄêÄ©·¢²¼µÚÒ»¸ö°æ±¾£¬Á¢¼´ÒýÆðÁ˹㷺µÄ×¢Òâ¡£2003Äê6Ô£ ......