ÀûÓÃ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
Ïà¹ØÎĵµ£º
²Ù×÷ϵͳµÄÖ§³Ö °æ±¾ºÍ·¢Ðаæ ʵÀý¡¢Êý¾Ý¿âºÍ±í¿Õ¼ä ʵÀýÃûºÍSID ϵͳÊý¾Ý¿âºÍϵͳ±í¿Õ¼ä
Ò»°ãµÄ¹«Ë¾Í¨³£»áÔÚËûÃǵÄÐÅϢϵͳ¼Ü¹¹ÖÐÒýÈë¶àÖÖÊý¾Ý¿âƽ̨£¬Í¬Ê±ÒýÈëÈýµ½ËÄÖÖ²»Í¬µÄRDBMS½â¾ö·½°¸µÄÖдóÐ͹«Ë¾Ò²²¢²»ÉÙ¼û£¬µ±È»ÕâЩ¹«Ë¾ÀïÃæµÄDBAÃÇͨ³£Ò²ÐèҪͬʱӵÓйÜÀí¶àÖÖ²»Í¬Æ½Ì¨µÄ¼¼ÄÜÁË¡£
Ö»ÔÚÒ»ÖÖÆ½Ì¨ÉÏÕ¹¿ª¹¤×÷µÄÊý¾Ý ......
ÔÚEclipseÖÐÎÒÃǾ³£»áÏòÖ÷·½·¨×¢Èë²ÎÊý£¬ÒÔÌṩ¸ø³ÌÐòµÄÔËÐУ¬Æä·½·¨ÈçÏ£º
1.µãÔËÐа´Å¥£¨»òÓÒ»÷ÒªÔËÐеÄÀࣩ
2.µã»÷Open Run Dialog..
3.Ñ¡ÖÐ×ó²àÐèÒªÔËÐеÄÀà
4.ÔÚÓÒ²àÑ¡ÖÐArgument
5.ÔÚProgram ArgumentÖÐÊäÈëÄãҪעÈëµ½Ö÷º¯ÊýÖеIJÎÊý
6.µã»÷ÔËÐУ¨Run£©£¬¾Í¿ÉÒÔÔËÐÐÁË¡£¡£¡£ ......
HMAC
HMAC£¨Hash Message Authentication Code£¬É¢ÁÐÏûÏ¢¼ø±ðÂ룬»ùÓÚÃÜÔ¿µÄHashËã·¨µÄÈÏÖ¤ÐÒé¡£ÏûÏ¢¼ø±ðÂëʵÏÖ¼ø±ðµÄÔÀíÊÇ£¬Óù«¿ªº¯ÊýºÍÃÜÔ¿²úÉúÒ»¸ö¹Ì¶¨³¤¶ÈµÄÖµ×÷ΪÈÏÖ¤±êʶ£¬ÓÃÕâ¸ö±êʶ¼ø±ðÏûÏ¢µÄÍêÕûÐÔ¡£Ê¹ÓÃÒ»¸öÃÜÔ¿Éú³ÉÒ»¸ö¹Ì¶¨´óСµÄСÊý¾Ý¿é£¬¼´MAC£¬²¢½«Æä¼ÓÈëµ½ÏûÏ¢ÖУ¬È»ºó´«Êä¡ ......
1.¶ÔcollectionsµÄÖ§³Ö
Java´úÂë
List<String> list = new ArrayList<String>();
list.add("item");
String item = list.get(0);
Set<String> set = new HashSet<String>(); &nb ......