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

hibernate¸ù¾Ýʱ¼äÈÕÆÚÀ´²éѯoracleÊý¾Ý¿â

ʹÓÃÄ£ºý²éѯ£º
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-mm-dd"); 
Date startdate = sdf.parse(start_date);
Date enddate = sdf.parse(end_date);
List list = sess.createCriteria(MyTabel.class)
               .add( Restrictions.eq("clinid", start_clinId) )
               .add( Restrictions.between("idate", startdate, enddate) ) .list();
ʹÓÃoracle±¾ÉíµÄº¯Êý
session.find("from Weather w where w.recordTiime=to_date('"+ datestr +"', 'yyyy-mm-dd hh24:mi:ss')")
ÆäÖÐdatestrÊÇÐÎÈç"2005-03-01 11:30:00"¸ñʽµÄ×Ö·û´®
Spring¼¯³Éhibernate
public List findResult(final String bankid,final String begintime,final String endtime) {
   log.debug("finding Result Ydopehb instances");
   java.util.Date bd=DateUtil.getDate(begintime);
   java.util.Date ed=DateUtil.getDate(endtime);
  
  
  
   java.sql.Date bdate = new java.sql.Date(bd.getTime());  
   java.sql.Date edate = new java.sql.Date(ed.getTime());
   try {
    String queryString = "from Ydopehb where bankid='"
     + bankid +"' and feetime between :begintime and :endtime ";
    
   
    return getHibernateTemplate().findByNamedParam(queryString, new String[]{"begintime","endtime"}, new java.sql.Date[]{bdate,edate}) ;
   } catch (RuntimeException re) {
    log.error("find Result failed", re);
    throw re;
   }
}
ÆäÖÐDateUtil ÊÇ×Ô¶¨ÒåµÄ¹¤¾ßÀ࣬ÓÃÀ´ÔÚDateÀàÐͺÍStringÀàÐÍÖ®¼ä»¥Ïàת»»¡£


Ïà¹ØÎĵµ£º

oracle¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......

OracleÓû§¡¢½ÇÉ«¡¢È¨ÏÞºÍϵͳ×ÊÔ´¹ÜÀí³£ÓòÙ×÷

²éѯÓû§ÐÅÏ¢
SELECT USERNAME,DEFAULT_TABLESPACE, TEMPORARY_TABLESPACE, PROFILE, ACCOUNT_STATUS, CREATED from dba_users; ²éѯÓû§¿Õ¼äʹÓúÍÉÏÏÞÇé¿ö
SELECT username, tablespace_name, bytes/1024/1024 space_used_in_mb, max_bytes/1024/1024 max_space_in_mb from dba_ts_quotas; ´´½¨ ......

oracle¸´Ï°£¨¶þ£© Ö®OracleʵÀýµÄ¹ÜÀí

      ½ñÌ츴ϰµÚÈýÕ£¬±¾À´ËãÆðÀ´Ó¦¸ÃÊǵڶþյ쬵«ÊǵڶþÕµÄÄÚÈÝÊǽéÉÜÊý¾Ý¿âµÄ¹ÜÀí¹¤¾ß£¬¶ø¶ÔÓÚÎÒÃǶøÑÔ£¬ÕâЩÏà¶ÔÀ´ËµÃ»Óжà´óµÄ±ØÒª£¬ËùÒÔ£¬ÏÖÔÚ²½È븴ϰOracleʵÀýµÄ¹ÜÀí¡£ÕâÕµÄÄÚÈݰüÀ¨³õʼ»¯²ÎÊýÎļþµÄά»¤ºÍ¹ÜÀí£¬ÒÔ¸÷ÖÖ²»Í¬µÄ·½Ê½Æô¶¯ºÍ¸ÅÄî±ÈÊý¾Ý¿âOracle Instance£¬ÒÔ¼°¶ÔOracle I ......

´î½¨Oracle 10g Proc+VS2008¿ª·¢»·¾³

1¡¢ÏÂÔØ°²×°Microsoft Visual Studio 2008£º
     ÏÂÔØµØÖ·£ºhttp://www.microsoft.com/downloads/details.aspx?FamilyId=83C3A1EC-ED72-4A79-8961-25635DB0192B&displaylang=zh-cn£¬Õâ¸öÊÇ“Visual Studio 2008 רҵ°æ£¨90 ÌìÊÔÓð棩”¡£
     °²×°²½ÖèÂÔ¡£
2¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ