Oracleʱ¼ä¾«È·µ½Ê±¡¢·Ö¡¢Ãë´¦Àí·½·¨
Ò»°ãÊý¾Ý¿âÖÐʱ¼äµÄ¸ñʽΪDATEÀàÐÍ£¬¶øÎÒÃÇ´ÓÒ³ÃæÖлñÈ¡µÄʱ¼äÍùÍùΪStringÀàÐÍ£¬Õâ¸ö¾ÍÐèÒªÀàÐ͵Äת»»¡£Ò»°ãÎÒÃÇ»áͨ¹ýµ÷Óà Java.text.SimpleDateFormat JAVAÀàÀ´¶ÔÆä½øÐÐת»»¡£Õâ¸öJAVAÀàÖÐÎÒÃǾ³£Óõ½µÄ·½·¨ÓÐÁ½¸ö£¬Ò»¸öÊÇformat(½«Ê±¼ä¸ñʽµÄÊý¾Ýת»»³ÉStringÀàÐÍ)£¬ÁíÒ»¸ö¾ÍÊÇ parse(½«StringÀàÐÍת»»³ÉDATEÀàÐÍ)¡£ÎÒÃÇÒ»°ã¿ÉÒÔ½«parse·â×°µ½×Ô¼ºµÄ·½·¨ÖУ¬Àý:
/**
* ·½·¨ÃèÊö£ºÒ³ÃæÖÐ×Ö·û´®×ª»¯ÎªÈÕÆÚÀàÐÍ
*
* ÊäÈë²ÎÊý£º´ÓÒ³ÃæÖеõ½µÄÒÔ×Ö·û´®ÐÎʽ±íʾµÄÈÕÆÚÊý¾Ý
* Êä³ö²ÎÊý£º×ª»»ºóµÄÈÕÆÚ
*/
Public class TimeExh{
public static Date transToDate(String strDatefromPage) {
Date date = null;
//´Ë´¦Îªyyyy-MM-dd ÔòΪ2005-1-13
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
//½¨Á¢Ò»¸öÒ»¶¨¸ñʽµÄ SimpleDateFormat
if(strDatefromPage==null) {
return new Date();
}
if (strDatefromPage.length()>10) {
sdf = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
//´Ë´¦Ê±¼ä·½Ê½Îª2005-1-13 20:00:12
}
try {
date = sdf.parse(strDatefromPage);
} catch (Exception ex) {
ex.printStackTrace();
}
return date;
}
}
¡¡¡¡ÔÚOracleÊý¾Ý¿âÖÐÌṩÁËto_dateµÄ·½·¨À´¶ÔStringÀàÐ͵Äʱ¼äÀ´½øÐÐת»»¡£¶øÔÚOracleÊý¾Ý¿âÖв»Äܽ«Ê±¼äÖ±½Ó·Åµ½VOÖд«¸øÊý¾Ý¿â£¬ÕâÑùÊý¾Ý¿âÖеÄʱ¼äΪ¸ñÁÖÊÏʱ¼ä£¬²»·ûºÏÖйúÈ˵Äʱ¼äÏ°¹ß¡£ËùÒÔÔÚÕâÀïÓÐÁ½Öв»Í¬µÄ´¦Àí·½Ê½½øÐд¦Àí¡£
¡¡¡¡µÚÒ»ÖÖ£ºVOÖд洢ʱ¼äµÄÀàÐÍΪStringÀàÐÍ¡£
¡¡¡¡ÎÒÔÚÕâÀïдһ¸ö¼òµ¥µÄVOΪ£º
public class DateVO {
..........//Ê¡ÂÔµô¶¨Ò岿·Ö
public void setStart_Date(String Start_Date){
start_Date= start_Date
}
Ïà¹ØÎĵµ£º
Ò» Êý¾Ý¿âµÄÊÂÎñ´¦Àí
¶¨Ò壺ÊÂÎñÊÇÒ»×éÏà¹ØµÄÊý¾Ý¸Ä±äµÄÂß¼¼¯ºÏ¡£ÔÚÒ»¸öÊÂÎñÖеÄÊý¾Ý¸Ä±ä£¨DML£©±£³Ö×ÅÒ»ÖµÄ״̬£¬Êý¾ÝµÄ¸Ä±äͬʱ³É¹¦»òÕßͬʱʧ°Ü¡£
¶þ Êý¾Ý¿âµÄÊÂÎñÓÉÏÂÁÐÓï¾ä×é³É
Ò»×éDMLÓï¾ä£¬Ð޸ĵÄÊý¾ÝÔÚËûÃÇÖб£³ÖÒ»ÖÂ
Ò»¸ö DDL (Data Define Language) Óï¾ä
Ò»¸ö DCL (Data Control Language)Óï¾ä
1¡¢¿ª ......
/*============´´½¨Customer±í==========*/
create table Customer
(
Customer_id number(6) not null,
Customer_name varchar2(50) not null,
Password varcha ......
³ÉÔ±º¯ÊýºÍ¹ý³Ì
¹¹Ô캯Êý·½·¨
-oracleµÄÿ¸ö¶ÔÏó¾ùÓÐÒ»¸öÄÚÖõĹ¹Ô캯Êý·½·¨
-ÓÃÓÚ´´½¨¶ÔÏóµÄÒ»¸öʵÀý
-ÎÞÐèÏÔʽµØ¶¨Òå
-Óë¶ÔÏóÀàÐÍͬÃû
¶¨Òå¶ÔÏóÀàÐÍ
create or replace
type persontype as object
(
id int,
name varchar(20),
member function ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´Ð ......
ORACLEÈÕÆÚʱ¼äº¯Êý´óÈ«
TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02 13:45:25ΪÀý)
Year:
yy two digits Á½Î»Äê &nb ......