Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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.creating function-based indexes
sql> create index summit.item_quantity on summit.item(quantity-quantity_shipped);
 
2.create a B-tree index
sql> create [unique] index index_name on table_name(column,.. asc/desc) tablespace
sql> tablespace_name [pctfree integer] ......

ORACLE PL/SQLÓëSQL SERVER T SQLһЩ±È½Ï

ORACLE PL/SQLÓëSQL SERVER T-SQLһЩ±È½Ï
×Ö·û´®Á¬½Ó
OracleÓÃ|| ·ûºÅ×÷ΪÁ¬½Ó·û£¬¶øSQL ServerµÄÁ¬½Ó·ûÊǼӺţº+ ¡£
Oracle²éѯÈçÏÂËùʾ£ºSelect ‘Name’ || ‘Last Name’ from tableName
SQL Server²éѯÈçÏ£ºSelect ‘Name’ + ‘Last Name’
GUID
OracleÓÃSYS_GUID ......

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

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

Æô¶¯oracleϵͳÎļþ¼ÓÔØË³Ðò

ÔÚÆô¶¯oracle·þÎñʱ,Ê×ÏÈ»áÔÚ·þÎñ¶ËÕÒ
1.spfile<sid>.ora
ÓÃÓÚÆô¶¯Àý³Ì,Èç¹ûÕÒ²»µ½spfile<sid>.ora,ÔòʹÓ÷þÎñ¶ËȱʡµÄ
2.spfile
À´Æô¶¯,Èç¹ûȱʡµÄspfileÒ²ÕÒ²»µ½,ÔòʹÓÃ
3.init<sid>.ora
À´Æô¶¯Àý³Ì,×îºóÔòÊÇʹÓÃȱʡµÄ
4.pfile
.µ±È»ÄãÒ²¿ÉÒÔÖ¸¶¨pfileÀ´¸²¸ÇȱʡspfileÆô¶¯Àý³Ì,»òͨ¹ýspfile= ......

Oracle¶¨ÒåÔ¼Êø Íâ¼üÔ¼Êø

Íâ¼üÔ¼Êø±£Ö¤²ÎÕÕÍêÕûÐÔ¡£Íâ¼üÔ¼ÊøÏÞ¶¨ÁËÒ»¸öÁеÄȡֵ·¶Î§¡£Ò»¸öÀý×Ó¾ÍÊÇÏÞ¶¨ÖÝÃûËõдÔÚÒ»¸öÓÐÏÞÖµ¼¯ºÏÖУ¬Õâ¸öÖµ¼¯ºÏÊÇÁíÍâÒ»¸ö¿ØÖƽṹ——Ò»ÕŸ¸±í
    ÏÂÃæÎÒÃÇ´´½¨Ò»ÕŲÎÕÕ±í£¬ËüÌṩÁËÍêÕûµÄÖÝËõдÁÐ±í£¬È»ºóʹÓòÎÕÕÍêÕûÐÔÈ·±£Ñ§ÉúÃÇÓÐÕýÈ·µÄÖÝËõд¡£µÚÒ»ÕűíÊÇÖݲÎÕÕ±í£¬State×÷ΪÖ÷¼ü
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ