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

oracleÁ´½ÓÎÊÌâ

ÎÒÔÚ¿ª·¢µçÄÔÉϲâÊÔûÓÐÒ»µãÎÊÌ⣬µ«ÊÇÔÚÐÞ¸ÄÎļþÖеÄÊý¾Ý¿âIPµØÖ·ÒԺ󣬽«warÎļþ·ÅÉϿͻ§µÄµçÄÔÉÏÒÔºóÀÏÊÇ´´½¨Á¬½Óʧ°Ü£¬´íÎóÐÐÔÚ50ÐС£
´´½¨Á¬½Ó´úÂëÈçÏ£º
String proPath = this.getClass().getResource("").getPath().toString();
String path = proPath.substring(0,proPath.indexOf("classes"))+"/classes/DB.properties";
String driver = "";
String url = "";
String username = "";
String password = "";
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
private static Properties p = new Properties();
private void loadProperty(){  //´ÓÎļþ»ñµÃÊý¾Ý¿âÁ´½ÓÐÅÏ¢
try {
p.load(new FileInputStream(path));
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
driver = p.getProperty("driver");
url = p.getProperty("url");
username = p.getProperty("username");
password = p.getProperty("password");
}
public Connection getCon(){ //´´½¨Á¬½Ó
loadProperty();
try {
Class.forName(driver);  //µÚÎåÊ®ÐÐ
con = DriverManager.getConnection(url, username, password);
} catch (ClassNotFoundE


Ïà¹ØÎÊ´ð£º

OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?

1.OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?

2.OracleתÂëʱ,Èç¹û¿Í»§¶ËΪ×Ó¼¯(UASCII)·þÎñ¶ËΪ³¬¼¯(AL32UTF8).
ÄÇÑϸñµÄ½²ÊÇ×Ó¼¯×ª³¬¼¯, ¿ÉÒÔתµÄͨ.
²éѯµÄʱºò³¬¼¯×ª×Ó¼¯ÄDz»¾Í³öÎÊÌâÁËô?
Äĸö»Ø¸öÌ ......

ORACLEÊý¾Ý¿âÖÐµÄ group by Óï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

OracleÈçºÎʹÓô°¿Úº¯ÊýʵÏÖÕâÑùµÄ²éѯ

±í¼Ç¼
======================================
name        date        score
Fei Zhang  1          100
Fei Zhang  ......

Oracle²ÎÊýÀàÐͺÍC#ÀàÐÍÎÊÌ⡾ÔÚÏߵȣ¡£¡¡¿

´æ´¢¹ýÊÇÕâÑù¶¨ÒåµÄ

create or replace procedure PROC_ReportStoreBanBao1(stime    in varchar2,
                        &n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ