Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ʹÓÃ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();
  }
 }
}


Ïà¹ØÎĵµ£º

oracle²úÉúËæ»úÊý»ò×Ö·û´®

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 ......

Oracle±í¿Õ¼äºÍ±íµÄÇø±ð

ORACLEÎïÀíÉÏÊÇÓÉ´ÅÅÌÉϵÄÒÔϼ¸ÖÖÎļþ:Êý¾ÝÎļþºÍ¿ØÖÆÎļþºÍLOGFILE¹¹³ÉµÄ ±í¿Õ¼ä¾Í̸ֻÏà¹ØµÄÊý¾ÝÎļþ Ê×ÏÈÃ÷È·¸ÅÄî:±í¿Õ¼äÊÇORACLEÄÚ²¿¶¨ÒåµÄÒ»¸ö¸ÅÄî,ÊÇΪÁËͳһORACLEÎïÀíºÍÂß¼­ ÉϵĽṹ¶ø×¨ÃލÁ¢µÄ,´ÓÎïÀíÉÏÀ´Ëµ,Ò»¸ö±í¿Õ¼äÊÇÓɾßÌåµÄÒ»¸ö»ò¶à¸ö´ÅÅÌÉÏÊý ¾ÝÎļþ¹¹³ÉµÄ(ÖÁÉÙ1¶Ô1,¿ÉÒÔ1¶Ô¶à),´ÓÂß¼­ÉÏÀ´ËµÒ»¸ö±í¿Õ¼äÊ ......

RAWÉ豸ÓëORACLEµÄÎÊ´ð


1£®Ê²Ã´½Ð×öÂãÉ豸£¿
¡¡¡¡ÂãÉ豸£¬Ò²½ÐÂã·ÖÇø£¨Ô­Ê¼·ÖÇø£©£¬ÊÇÒ»ÖÖûÓо­¹ý¸ñʽ»¯£¬²»±»Unixͨ¹ýÎļþϵͳÀ´¶ÁÈ¡µÄÌØÊâ×Ö·ûÉ豸¡£ËüÓÉÓ¦ÓóÌÐò¸ºÔð¶ÔËü½øÐжÁд²Ù×÷¡£²»¾­¹ýÎļþϵͳµÄ»º³å¡£
2£®ÈçºÎ±æ±ðÂãÉ豸£¿
¡¡¡¡ÔÚUnixµÄ/dev Ŀ¼Ï£¬ÓÐÐí¶àÎļþ£¬ÆäÖÐÓÐÁ½¸ö´óÀࣺ×Ö·ûÉ豸ÎļþºÍ¿éÉ豸Îļþ¡£
¡¡¡¡×Ö·ûÉè±¸Ì ......

Oracle 9.2.0.1Éý¼¶µ½9.2.0.8°æ±¾

¾°£ºÔÚwindows xp serverÉϰ²×°ÁËOracle 9.2.0.1£¬ÏÖʹÓÃp4547809_92080_WINNT.zip½«ÆäÉý¼¶µ½9.2.0.8°æ±¾£¬²¢´òÉÏ×î
Ðµİ²È«²¹¶¡April 2008°æ¡£
1.Éý¼¶oracle£¨administratorÓû§È¨ÏÞ£©£¨ÏÂÔØp4547809_92080_WINNT.zipÍøÖ·£º
ftp://updates.oracle.com/4547809/p4547809_92080_WINNT.zip£©
£¨1£©¡¢Ñ¹Ëõ°üÃû³ÆÎª p45478 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ