ÀûÓÃJAVAÏòOracleÊý¾Ý¿âÖвåÈë´ó¶ÔÏó
ͨ¹ýJDBC£¬ÎÒÃÇ¿ÉÒÔÏòoracle²åÈë´ó¶ÔÏó£¬ÈçͼƬ£¬ÒôƵ£¬³¤Îı¾µÈ£¬Æä²åÈë·½·¨Óкܶ࣬ÕâÀïÑÝʾһÏÂͨ¹ýÁ÷¸üиüеÄÐÎʽ²åÈëCLOB´ó¶ÔÏó¡£
ÕâÊÇÒ»¸ö´æ´¢Îı¾µÄÀý×Ó£¬½âÊÍÎÒ»áÔÚ³ÌÐòÖÐÒÔ×¢Ê͵ÄÐÎʽд³ö
/**
* ½«Éú³ÉµÄ±íÑù´æ´¢µ½Êý¾Ý¿â
*
* @param htmlParam
* @return
*/
public static boolean addToDB(HtmlParam htmlParam) {
//´Ë´¦¶¨ÒåÊý¾Ý¿â²Ù×÷ʱʹÓõĶÔÏó
Connection conn = null;
//Óë²éѯ²Ù×÷Ôڴ˺¯ÊýÖжà´ÎʹÓÃ
PreparedStatement stmt = null;
ResultSet rs = null;
//ORACLEÖеĴó¶ÔÏó
CLOB clob = null;
//дÈë´ó¶ÔÏóËùÐèµÄÁ÷
Writer write = null;
try {
// jdbcÁ¬½ÓÊý¾Ý¿â²ÎÊý
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@192.168.1.210:1521:moe210";
conn = DriverManager.getConnection(url, "tjdemo", "tjdemo");
// ÏȲåÈëÏàÓ¦µÄÊý¾Ý
String sql = "insert into html_demo values(SEQ_HTML.nextval, ?, ?, ?, ?, ?, ?, ?, empty_clob(), ?)";
//×¢ÒâÉÏÒ»¾ä²åÈëµÄÊÇÒ»¸ö¿ÕµÄ´ó¶ÔÏó empty_clob(),£¬¼´Ã»ÓÐÏò´ó¶ÔÏóÖвåÈëÈκÎÊý¾Ý
stmt = conn.prepareStatement(sql);
stmt.setInt(1, htmlParam.getProjectId());
stmt.setString(2, htmlParam.getReptName());
stmt.setInt(3, htmlParam.getStartRow());
stmt.setInt(4, htmlParam.getStartColumn());
stmt.setInt(5, htmlParam.getEndRow());
stmt.setInt(6, htmlParam.getEndColumn());
stmt.setString(7, htmlParam.getCharset());
stmt.setString(8, htmlParam.getPath());
stmt.executeUpdate();
// ²éѯµ±Ç°sequenceÖµ£¬¼´²éѯ¸Õ¸Õ²åÈëµ½Êý¾Ý¿âÖеÄ×ֶεÄid
String seq = "select SEQ_HTML.currval from dual";
stmt = conn.prepareStatemen
Ïà¹ØÎĵµ£º
ÈÏʶ´æ´¢¹ý³ÌºÍº¯Êý
´æ´¢¹ý³ÌºÍº¯ÊýÒ²ÊÇÒ»ÖÖPL/SQL¿é£¬ÊÇ´æÈëÊý¾Ý¿âµÄPL/SQL¿é¡£µ«´æ´¢¹ý³ÌºÍº¯Êý²»Í¬ÓÚÒѾ½éÉܹýµÄPL/SQL³ÌÐò£¬ÎÒÃÇͨ³£°ÑPL/SQL³ÌÐò³ÆÎªÎÞÃû¿é£¬¶ø´æ´¢¹ý³ÌºÍº¯ÊýÊÇÒÔÃüÃûµÄ·½Ê½´æ´¢ÓÚÊý¾Ý¿âÖеġ£ºÍPL/SQL³ÌÐòÏà±È£¬´æ´¢¹ý³ÌÓкܶàÓŵ㣬¾ßÌå¹éÄÉÈçÏ£º
* ´æ´¢¹ý³ÌºÍº¯ÊýÒÔÃüÃûµÄÊý¾Ý¿â¶ÔÏóÐÎʽ´æ´¢ ......
¶¹¶¹Íø ¼¼ÊõÓ¦ÓÃÆµµÀ 2009Äê06ÔÂ10ÈÕ ¡¾×ֺţºÐ¡ÖÐ´ó¡¿ Êղر¾ÎÄ
JProfiler memcached JavaCC EclEmma Jester Java¼ÓÃܼ¼Êõ£¨Æß£©¡£
¡¡¡¡ECC
¡¡¡¡ECC-Elliptic Curves Cryptography£¬ÍÖÔ²ÇúÏßÃÜÂë±àÂëѧ£¬ÊÇĿǰÒÑÖªµÄ¹«Ô¿ÌåÖÆÖУ¬¶Ôÿ±ÈÌØËùÌṩ¼ÓÃÜÇ¿¶È×î¸ßµÄÒ»ÖÖÌåÖÆ¡£ÔÚÈí¼þ×¢²á ......
×î½üÔÚдjava²âÊÔ³ÌÐòµÄʱºòͻȻÓöµ½ÁËÒ»¸öÎÊÌ⣺javaĬÈϰüÖеÄpublicÀàÊDz»ÄÜÔÚÆäËû°üÖÐÖ±½Óµ÷ÓõÄ
Ê×ÏÈ£¬×ܽáÒ»ÏÂĬÈϰüÖÐÀàµÄʹÓ÷¶Î§£¬javaĬÈϰüÖеÄÀà¿ÉÒÔʵÀý»¯ÆäËü°üÖеÄpublicÀ࣬µ«ÊÇÆäËü°üÖеÄÀàÊDz»ÄÜÏÔʽʵÀý»¯Ä¬ÈϰüÖеÄÀàÕâ¸öÌØÐÔÔÚJDK1.4ÒÔºóµÄ°æ±¾³ÉÁ¢£»
& ......
HMAC
HMAC£¨Hash Message Authentication Code£¬É¢ÁÐÏûÏ¢¼ø±ðÂ룬»ùÓÚÃÜÔ¿µÄHashËã·¨µÄÈÏÖ¤ÐÒé¡£ÏûÏ¢¼ø±ðÂëʵÏÖ¼ø±ðµÄÔÀíÊÇ£¬Óù«¿ªº¯ÊýºÍÃÜÔ¿²úÉúÒ»¸ö¹Ì¶¨³¤¶ÈµÄÖµ×÷ΪÈÏÖ¤±êʶ£¬ÓÃÕâ¸ö±êʶ¼ø±ðÏûÏ¢µÄÍêÕûÐÔ¡£Ê¹ÓÃÒ»¸öÃÜÔ¿Éú³ÉÒ»¸ö¹Ì¶¨´óСµÄСÊý¾Ý¿é£¬¼´MAC£¬²¢½«Æä¼ÓÈëµ½ÏûÏ¢ÖУ¬È»ºó´«Êä¡ ......