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

ÀûÓÃ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


Ïà¹ØÎĵµ£º

Éî¶È¶Ô±ÈOracleÓëSQL Server——µÚÒ»²¿·Ö

²Ù×÷ϵͳµÄÖ§³Ö °æ±¾ºÍ·¢Ðаæ ʵÀý¡¢Êý¾Ý¿âºÍ±í¿Õ¼ä ʵÀýÃûºÍSID ϵͳÊý¾Ý¿âºÍϵͳ±í¿Õ¼ä
Ò»°ãµÄ¹«Ë¾Í¨³£»áÔÚËûÃǵÄÐÅϢϵͳ¼Ü¹¹ÖÐÒýÈë¶àÖÖÊý¾Ý¿âƽ̨£¬Í¬Ê±ÒýÈëÈýµ½ËÄÖÖ²»Í¬µÄRDBMS½â¾ö·½°¸µÄÖдóÐ͹«Ë¾Ò²²¢²»ÉÙ¼û£¬µ±È»ÕâЩ¹«Ë¾ÀïÃæµÄDBAÃÇͨ³£Ò²ÐèҪͬʱӵÓйÜÀí¶àÖÖ²»Í¬Æ½Ì¨µÄ¼¼ÄÜÁË¡£
Ö»ÔÚÒ»ÖÖÆ½Ì¨ÉÏÕ¹¿ª¹¤×÷µÄÊý¾Ý ......

EclipseÔËÐÐjava³ÌÐòΪÖ÷·½·¨´«µÝ²ÎÊý

ÔÚEclipseÖÐÎÒÃǾ­³£»áÏòÖ÷·½·¨×¢Èë²ÎÊý£¬ÒÔÌṩ¸ø³ÌÐòµÄÔËÐУ¬Æä·½·¨ÈçÏ£º
1.µãÔËÐа´Å¥£¨»òÓÒ»÷ÒªÔËÐеÄÀࣩ
2.µã»÷Open Run Dialog..
3.Ñ¡ÖÐ×ó²àÐèÒªÔËÐеÄÀà
4.ÔÚÓÒ²àÑ¡ÖÐArgument
5.ÔÚProgram ArgumentÖÐÊäÈëÄãҪעÈëµ½Ö÷º¯ÊýÖеIJÎÊý
6.µã»÷ÔËÐУ¨Run£©£¬¾Í¿ÉÒÔÔËÐÐÁË¡£¡£¡£ ......

¼ÌÐø Âþ̸Java¼ÓÃܼ¼Êõ£¨Ò»£©

  HMAC
    HMAC£¨Hash Message Authentication Code£¬É¢ÁÐÏûÏ¢¼ø±ðÂ룬»ùÓÚÃÜÔ¿µÄHashËã·¨µÄÈÏ֤ЭÒé¡£ÏûÏ¢¼ø±ðÂëʵÏÖ¼ø±ðµÄÔ­ÀíÊÇ£¬Óù«¿ªº¯ÊýºÍÃÜÔ¿²úÉúÒ»¸ö¹Ì¶¨³¤¶ÈµÄÖµ×÷ΪÈÏÖ¤±êʶ£¬ÓÃÕâ¸ö±êʶ¼ø±ðÏûÏ¢µÄÍêÕûÐÔ¡£Ê¹ÓÃÒ»¸öÃÜÔ¿Éú³ÉÒ»¸ö¹Ì¶¨´óСµÄСÊý¾Ý¿é£¬¼´MAC£¬²¢½«Æä¼ÓÈëµ½ÏûÏ¢ÖУ¬È»ºó´«Êä¡ ......

Java 7.0µÄ±ä»¯

1.¶ÔcollectionsµÄÖ§³Ö 
Java´úÂë
List<String> list = new ArrayList<String>();   
list.add("item");  
String item = list.get(0);     
Set<String> set = new HashSet<String>(); &nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ