ʹÓÃHibernate²åÈëoracle DateÀàÐ͵ÄÀý×Ó
package test;
import java.text.SimpleDateFormat;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.classic.Session;
import po.Stu;
public class Insert1 {
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
Configuration cf = new Configuration().configure();
SessionFactory sf = cf.buildSessionFactory();
Session session = sf.openSession();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
String aa = "1999-12-22";
java.util.Date timeDate = null;
try {
timeDate = sdf.parse(aa);
} catch (Exception e) {
// TODO ×Ô¶¯Éú³É catch ¿é
e.printStackTrace();
}// utilÀàÐÍ
java.sql.Date dateTime = new java.sql.Date(timeDate.getTime());// sqlÀàÐÍ
Stu stu = new Stu("00000", "ÕÅÈý", "ÄÐ", dateTime, "ɽ¶«", "111");
Transaction t = session.beginTransaction();
try {
session.save(stu);
t.commit();
} catch (Exception e) {
e.printStackTrace();
} finally {
t.rollback();
session.close();
}
}
}
Ïà¹ØÎĵµ£º
1 ´ÓÏÖÓеıíÖÐËæ»úÈ¡¼Ç¼
select * from (select st_base_id from t_base order by dbms_random.random) where rownum<=100; --Õâ¸öÊÇËæ»úÈ¡³ö100¸ö¼Ç¼¡£
2 ²úÉúËæ»ú×Ö·û´®
select dbms_random.string('u',100) from dual; --²úÉú´óд×Öĸ×é³ÉµÄ×Ö·û´®£¬'u'Ò²¿ÉÒÔд³É'U'
select dbms_random.string('l',100) from ......
±¾ÎĽéÉÜÁËʹÓÃPro*C/C++ÔÚVisual
C++»·¾³Ï¿ª·¢OracleÊý¾Ý¿â½Ó¿Ú³ÌÐòµÄ·½·¨
Éè¼ÆË¼Â·ÆäʵÕâÑù£ºÊ×ÏÈͨ¹ýVC½¨Á¢Ò»¸ö¹¤³Ì£¬×Ô¶¯»¯½¨Á¢MAKEFILE£¬UNIXÐèÒª×Ô¼ºÐ´MAKEFILE¡£
Æä´ÎÅäÖÃVCµÄ»·¾³£¬½«PROCµÄ.H£¬.LIBµÄ·¾¶¼ÓÈëDERECTIRY¡£Ð´Ò»¸öPCÎļþ£¬¼´PROCÎļþ¡£·Åµ½¹¤³ÌÏàÓ¦µÄĿ¼Ï¡£È»ºó°ÑPCÎļþ¼ÓÈ빤³Ì¡£Ê¹ÓÃPROCUI.E ......
ÔÚoracleÖУ¬ÓÐ4¸ö´ó¶ÔÏó£¨lobs£©ÀàÐÍ¿ÉÓ㬷ֱðÊÇblob,clob,bfile,nclob¡£
¡¡¡¡ÏÂÃæÊǶÔlobÊý¾ÝÀàÐ͵ļòµ¥½éÉÜ¡£
¡¡¡¡ blob:¶þ½øÖÆlob£¬Îª¶þ½øÖÆÊý¾Ý£¬×¿É´ï4GB£¬´æÖüÔÚÊý¾Ý¿âÖС£
¡¡¡¡ clob:×Ö·ûlob,×Ö·ûÊý¾Ý,×¿ÉÒÔ´ïµ½4GB,´æÖüÔÚÊý¾Ý¿âÖС£
¡¡¡¡ bfile:¶þ½øÖÆÎļþ;´æÖüÔÚÊý¾Ý¿âÖ®ÍâµÄÖ»¶ÁÐͶþ½øÖÆÊý¾Ý£¬×î´ó³¤ ......
1£®Ê²Ã´½Ð×öÂãÉ豸£¿
¡¡¡¡ÂãÉ豸£¬Ò²½ÐÂã·ÖÇø£¨Ôʼ·ÖÇø£©£¬ÊÇÒ»ÖÖûÓо¹ý¸ñʽ»¯£¬²»±»Unixͨ¹ýÎļþϵͳÀ´¶ÁÈ¡µÄÌØÊâ×Ö·ûÉ豸¡£ËüÓÉÓ¦ÓóÌÐò¸ºÔð¶ÔËü½øÐжÁд²Ù×÷¡£²»¾¹ýÎļþϵͳµÄ»º³å¡£
2£®ÈçºÎ±æ±ðÂãÉ豸£¿
¡¡¡¡ÔÚUnixµÄ/dev Ŀ¼Ï£¬ÓÐÐí¶àÎļþ£¬ÆäÖÐÓÐÁ½¸ö´óÀࣺ×Ö·ûÉ豸ÎļþºÍ¿éÉ豸Îļþ¡£
¡¡¡¡×Ö·ûÉè±¸Ì ......
·ÖÇø±í¡¢·ÖÇøË÷ÒýºÍÈ«¾ÖË÷Òý£º
ÔÚÒ»¸ö±íµÄÊý¾Ý³¬¹ý¹ý2000ÍòÌõ»òÕ¼ÓÃ2G¿Õ¼äʱ£¬½¨Ò齨Á¢·ÖÇø±í¡£
create table ta(c1 int,c2 varchar2(16),c3 varchar2(64),c4 int constraint pk_ta primary key (c1)) partition by range(c1)(partition p1 values less than (10000000),partition p2 values less than (20000000),part ......