Çë¸ßÊÖÖ¸½ÌÒ»¶þ ·············· ·Ç³£¸Ðл£¡£¡£¡
ÐèÒªÏÂÔØlinux°æ°¡£¬»¹ÓÐÎļþ¸ñʽ
ÎÒÊÇÏÂÔصÄLinux°æµÄ
ÎûÎû£¬Ö»ÖªµÀÄǸö.rpm°üÀàËÆÓÚwindowsµÄ.exe¹þ£¬²»ÖªµÀÂ¥Ö÷ÏÂÔصÄÎļþÀïÃæÓÐûÓпÉÖ´ÐеÄÄØ£¿
isoµÄÒªmount
bin ......
û¸É¹ýÕâÊ£¬Ò²²»ÖªµÀoracleÊý¾Ý¿âɶÑù£¬Çë½Ì´óϺÃǾßÌå²½ÖèÊÇʲô£¿ÐèҪעÒâЩʲô£¿
ÊÇÕû¸ö¿âµÄÊý¾Ý»¹ÊÇ±íµ¥?
Õæ¸öÊý¾Ý¿â
Õû¸öÊý¾Ý¿â£¬ÁíÍâÎÒÊÇ´Óһ̨װÓÐoracleµÄµçÄÔµ¼Èëµ½Áíһ̨װÓÐsql serverµÄµçÄÔÖС£¶àл£¡
ÒýÓÃ
ÊÇÕû¸ö¿âµÄÊý¾Ý»¹ÊÇ±íµ¥?
¸ÕgoogleÁËÏ£¬Ò²Ã»ÕÒµ½oracle µ¼ÈëSQL serverµÄ· ......
û¸É¹ýÕâÊ£¬Ò²²»ÖªµÀoracleÊý¾Ý¿âɶÑù£¬Çë½Ì´óϺÃǾßÌå²½ÖèÊÇʲô£¿ÐèҪעÒâЩʲô£¿
ORACLEÊý¾Ý¿âÀï±íµ¼ÈëSQL ServerÊý¾Ý¿â
1¡¢ÔÚÄ¿µÄSQL ServerÊý¾Ý¿â·þÎñÆ÷ÉÏ°²×°ORACLE ClientÈí¼þ»òÕßORACLE ODBC Driver.
ÔÚ$ORACLE_HOME\network\admin\tnsnames.oraÀïÅä ......
ÏÖÔÚÓбíA£¨barcode varchar2£¬length number£©£¬B£¨barcode varchar2£¬serial number£©ÆäÖÐbarcode¹ØÁªA:BΪ1£ºn
ÓÐÈçÏÂsqlÓï¾ä
insert into a values('b1',10)
insert into a values('b2',20)
insert into a values('b3',30)
insert into b values('b1',1)
......
Ôõô°ÑÏÂÃæµÄ¸Ä³Ésql serverµÄ·½·¨£¿
to_char(img_comm_metadata.scene_centre_time,'yyyy-mm-dd hh24:mm:ss')>='1990-10-13 09:41:20'
SQL code:
datediff(ss,'1990-10-13 09:41:20',img_comm_metadata.scene_centre_time)>0
CONVERT(varchar(20),img_comm_metadata.scene_centre_time,120 ......
±¾È˸ÕѧϰORACLE£¬Çë¸ßÊÖÖ¸µãһϣ¬Íò·Ö¸Ðл£¡£¡£¡
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBUtil {
//oracleÁª½Ó
priva ......