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
ʲôÒâ˼£¿
ÎÒÊÇÊÖ¹¤É¾³ýµÄ ¶Ô°¡
ÄãµÄ
Ïà¹ØÎÊ´ð£º
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
ÎÒдµÄÒ»¸öJob
declare
job1 integer;
begin
dbms_job.submit(job1,
'Sale_FinanceUseFee(4,null,null,null);',
TRUNC(SYSDATE)+1.103, ......
ÐÖµÜ Í¼¹ÒÁË¡£
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value ......
sqlplusÁ¬½ÓOracleÊý¾Ý¿âµÄÕû¸öÁ÷³Ì£¬
ÀýÈç sqlplus /nolog
conn system/oracle£¨ÃÜÂ룩
Õâ¸öÁ¬½ÓOracleµÄÕû¸ö»úÖÆÊÇʲô£¨×¢ÖØÓÚÁ¬½ÓµÄÔÀíÉÏ£©
Èç¹ûÓÐ˶®»òÓÐÏà¹ØÄÚÈݸøÓèÌáÊ ......