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
ʲôÒâ˼£¿
ÎÒÊÇÊÖ¹¤É¾³ýµÄ ¶Ô°¡
ÄãµÄ
Ïà¹ØÎÊ´ð£º
»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î
http://blog.csdn.net/zxf_feng/archive/2008/12/21/3571961.aspx
¿´¿´Õâ¸ö
ÒýÓÃ
vStream := TMemorySt ......
3-5ÈË£¬¹¤×÷µØµãÉϺ£ÆÖ¶«Èí¼þÔ°£¬2-3Äê¾Ñ飬ӢÎÄÁ÷Àû£¬ÓÐÒâÕßÇëÁªÏµ38954510-1355£¬15821699737£¬y.ming@live.cn
×Ô¼º¶¥¡£¡£¡£
ûÓÐORACLE ERPµÄ¾Ñé,ÓÐÓÃÓѺÍTIPTOP¾Ñé,Ó¢Óï˵²»ºÃ,¿´»¹ÊÇ¿ÉÒÔ!
²»ÖªµÀÓÐûÓÐ ......
Óиö´æ´¢¹ý³ÌÓÐÈý¸öInt²ÎÊýºÍÒ»¸öOut²ÎÊý.
Ö´ÐÐʱÏȽ«Ò»Ð©Êý¾Ý²åÈëµ½Ò»¸ö±íÖÐ.È»ºóÔÙ´Ó±íÖÐÈ¡³öÊý¾Ý½øÐÐÐÐתÁÐ,ºÏ¼ÆµÈÂß¼.½«´¦Àí½á¹û·Åµ½Ò»¸ö±íÖÐ.²¢½«Idͨ¹ýOut²ÎÊý·µ»Ø.
µ«ÔÚÖ´ÐÐʱ¿ÉÒÔ»ñÈ¡µ½OutÖµ,µ«¾ÍÊÇà ......