ʹÓÃ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 10g
°²×°Íê³Éºó,
怫EM
ÊäÈëϵͳÓû§ÃûºÍÃÜÂëºÍÊý¾Ý¿âÓû§ÃûºÍÃÜÂëºó,
µãÆô¶¯±¨´í,
¿ÉÄÜÊÇÒòΪÊý¾Ý¿âµÄ×´Ì¬Îª×°ÔØ»ò²»×°ÔØ,
ʼÖÕÎÞ·¨µÇ½½øEM
µÄ½â¾ö°ì·¨......
×´¿ö£º
´ò¿ªhttp://ty-:5500/em
£¬ÏµÍ³ÏÔʾÈçÏÂÐÅÏ¢£º
Êý¾Ý¿â״̬µ±Ç°²»¿ÉÓ᣿ÉÄÜÊÇÒòΪÊý¾Ý¿âµÄ×´Ì¬Îª×°ÔØ»ò²»×°ÔØ¡£µ¥»÷ ......
oracleÌṩÈýÖָ߼¶±¸·Ý¹¦ÄÜ
¸ß¼¶¸´ÖÆ£¨Advanced Replication£©
Á÷¸´ÖÆ£¨Streams Replication£©
±¸¿â£¨Dataguard£©
Ò» dataguard£º
dataguardÔڸ߿ÉÓü°ÈÝÔÖ·½ÃæÒ»°ãÊÇdbaµÄÊ×Ñ¡£¬²»¹ÜÊÇÎïÀí±¸Óÿ⣨physical standby database£©»¹ÊÇÂß¼±¸Óÿ⣨logical standby database£©£¬ËüÃǶ¼¾ßÓÐһЩ¹²Í¬µÄ´ýÕ÷¡£
ÅäÖú͹ÜÀí· ......
1 ²é¿´oracleµÄ°æ±¾ÐÅÏ¢
£¨1£©Óÿͻ§¶ËÁ¬½Óµ½Êý¾Ý¿â£¬Ö´ÐÐselect * from v$instance
²é¿´versionÏî
£¨2£©select * from product_component_version
£¨3£©»ò²éѯV$VERSION²é¿´×é¼þ¼¶ÐÅÏ¢ ......
SQL:½á¹¹»¯²éѯÓïÑÔ
C R U D: Ôöɾ¸Ä²é
table : name age score
desc+±íÃû ---> ²éѯ±í½á¹¹
»òÕßÓà describe ÃüÁî (descÊÇdescribeµÄ¼òд)
²éѯÓïÑÔ£ºSELECT [DISTINCT] {*,column[alias],...} from table;
SELECT identifies what columns from identifies which tab ......
Óû§µÄ¹ÜÀí
Ò»¡¢ORACLEµÄ°²È«Óò
1¡¢TABLESPACE QUOTAS£º±í¿Õ¼äµÄʹÓö¨¶î
2¡¢DEFAULT TABLESPACE£ºÄ¬Èϱí¿Õ¼ä
3¡¢TEMPORARY TABLESPACE£ºÖ¸¶¨ÁÙʱ±í¿Õ¼ä¡£
4¡¢ACCOUNT LOCKING£ºÓû§Ëø
5¡¢RESOURCE LIMITE£º×ÊÔ´ÏÞÖÆ
6¡¢DIRECT PRIVILEGES£ºÖ±½ÓÊÚȨ
7¡¢ROLE PRIVILEGES£º½ÇÉ«ÊÚȨÏȽ«Ó¦ÓÃÖеÄÓû§»®Îª²»Í¬µÄ½ÇÉ«£¬ ......