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

oracle--jdbcÎÊÌâ


public void addUser(User user) {
Connection connection = null;
PreparedStatement pstat = null;
String sql = "insert into t_user(user_id,user_name,password,contact_tel,email,create_date)" +
" values(?,?,?,?,?,?)";
try {
connection = Utils.getConnection();
pstat = connection.prepareStatement(sql);

pstat.setString(1, user.getUserId());
pstat.setString(2, user.getUsername());
pstat.setString(3, user.getPassword());
pstat.setString(4, user.getContactTel());
pstat.setString(5, user.getEmail());
pstat.setTimestamp(6, new Timestamp(user.getCreateDate().getTime()));

pstat.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}finally {
Utils.close(pstat);
Utils.close(connection);
}
Ìá½»µÄʱºò ×ÜÊÇÖ´Ðв»¹ýÈ¥£¬ÔÚpstat.executeUpdate();ÕâÒ»¾äÉϾͿ¨×¡ÁË£¬³ÌÐò¾Í²»ÍùÏÂÖ´ÐÐÄǸöÁË£¬ÎÒ´òÓ¡ÁË´«ÈëµÄ²ÎÊý£¬Ò²¶¼ÊÇÕýÈ·µÄ¡£ÓÐʱºòÐУ¬ÓÐʱºò²»ÐС£µ«ÊDz»ÐеͼÊdzöÏÖÖÐÎĵÄʱºò£¬µ«ÊÇÖÐÎÄÓÐʱºòÐС£ÓÐʱºòÖÐÎÄÖ´ÐÐÁËÒ»Ìõ¹ýÈ¥ÁË£¬ºóÃæµÄ¾Í¶¼ÐÐÁË¡£µ«ÊǵÈÎÒ°ÑÊý¾Ý¿âÀïÃæµÄ¸Õ²Å²åÈëµÄÊý¾Ýɾ³ýÁË£¬ÎÒÔÚÖ´ÐоÍÓÖ²»ÐÐÁË¡£ÎÒÊÔÁ˺öà´ÎÁË¡£¶¼ÊÇÕâÑùµÄ¡£ÎÒ²»ÖªµÀÊÇʲôÎÊÌ⣬Çë½Ì¸ßÊÖ¡£Õâ¸öÎÊÌâ±È½Ï¼¬ÊÖ Ö÷ÒªÊÇÎÊÌâµÄ²»È·¶¨ÐÔ¡£¶øÇÒûÓб¨´í¡£
Èç¹ûË­ÖªµÀÒ²¿ÉÒÔ¼ÓÎÒQQ¸øÎÒ½²½â £¬Ð»Ð»ÁË QQ£º406635982


ʲôÒâ˼£¿
ÎÒÊÇÊÖ¹¤É¾³ýµÄ ¶Ô°¡ 

ÄãµÄ


Ïà¹ØÎÊ´ð£º

ÇóÖúORACLEÅúÁ¿Çå³ý±íÊý¾ÝµÄÎÊÌâ - Oracle / ¿ª·¢

±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......

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 jobÎÊÌ⣡ÔÚÏßµÈ

ÎÒдµÄÒ»¸öJob
declare
  job1 integer;
begin
  dbms_job.submit(job1,
    'Sale_FinanceUseFee(4,null,null,null);',
    TRUNC(SYSDATE)+1.103, ......

ssh oracle Á¬½Ó


Ðֵܠ ͼ¹ÒÁË¡£

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value ......

sqlplusÁ¬½ÓoracleÊý¾Ý¿âÔ­Àí£¿

sqlplusÁ¬½ÓOracleÊý¾Ý¿âµÄÕû¸öÁ÷³Ì£¬
ÀýÈç sqlplus /nolog
    conn system/oracle£¨ÃÜÂ룩

Õâ¸öÁ¬½ÓOracleµÄÕû¸ö»úÖÆÊÇʲô£¨×¢ÖØÓÚÁ¬½ÓµÄÔ­ÀíÉÏ£©

Èç¹ûÓÐË­¶®»òÓÐÏà¹ØÄÚÈݸøÓèÌáÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ