Browse by Tags

• Mindscape LightSpeed

  一个轻量级的O/R Mapping Framework。 现在版本为2.0。2.1据称将完全支持WCF Remoting。 http://www.mindscape.co.nz/Products/LightSpeed/features.aspx Rich domain model framework Model objects inherit off LightSpeed Entity class, which implements important .NET model object interfaces: IEditableObject , INotifyPropertyChanged , and IDataErrorInfo . Convention over configuration LightSpeed uses conventions that mandate how particular aspects of your domain model should look. Being prescriptive in this way allows you to focus... Posted Oct 07 2008, 03:43 PM by wicky with | with no comments Filed under: Development, Database

• MD5加密

  MD5加密 pl/sql版 CREATE OR REPLACE function md5(input_string VARCHAR2 ) return varchar2 IS raw_input RAW ( 128 ) : = UTL_RAW.CAST_TO_RAW(input_string); decrypted_raw RAW ( 2048 ); error_in_input_buffer_length EXCEPTION; BEGIN sys.dbms_obfuscation_toolkit.MD5(input => raw_input, checksum => decrypted_raw); return lower (rawtohex(decrypted_raw)); END ; from: unknown Java版 public static String encodePassword(String password, String algorithm) { byte [] unencodedPassword = password.getBytes(); MessageDigest... Posted Jul 12 2007, 10:29 AM by wicky with | with 1 comment(s) Filed under: Development, Database

• Top 15 free SQL Injection Scanners

  http://www.security-hacks.com/2007/05/18/top-15-free-sql-injection-scanners While the adoption of web applications for conducting online business has enabled companies to connect seamlessly with their customers, it has also exposed a number of security concerns stemming from improper coding. Vulnerabilities in web applications allow hackers to gain direct and public access to sensitive information (e.g. personal data, login credentials). Web applications allow visitors to submit and retrieve data... Posted Jul 07 2007, 06:44 PM by wicky with | with no comments Filed under: Development, Database

• MD5 Hash SQL Server Extended Stored Procedure

  http://www.codeproject.com/database/xp_md5.asp Introduction This is an extended stored procedure for Microsoft SQL Server 2000 that implements an optimized MD5 hash algorithm. It is intended to work much like the MySQL MD5() function. The algorithm was taken from here . I only added the md5_string() function. The DLL should work for older versions of SQL Server too, although I have not tested that. The source was compiled and tested on Microsoft Visual C++ 6.0 and .NET 2003. Installation Extract... Posted May 28 2007, 11:11 AM by wicky with | with no comments Filed under: Development, Database

• Firebird Data Access Designer (DDEX) installation

  Prerequisites Make sure that you have Visual Studio .NET 2005 Standard or higher edition. Express editions are not supported. Registry update Save the following file ( FirebirdDDEXProviderPackageLess32.reg ) to your computer. Remeber to update the path "C:\\Program Files\\FirebirdClient\\FirebirdSql.VisualStudio.DataTools.dll" if you have changed the default provider location during the installation. Install the .reg file into the registry. Machine.config update Add the following two sections to... Posted Jan 25 2007, 08:52 AM by wicky with | with no comments Filed under: Development, Database

• Count(*)和Exists

  通常我们判断一条记录是否存在，都会用Count(*)，比如 select count(*) from table_name where id=44444; 但是，这样做会令数据库找出所有符合条件的记录，在某些情况下，比如表很大或者索引很大，就会显得慢和耗费资源。 通过使用exists，我们可以改善这个状况。 select 1 from dual where exists (select 1 from table_name where id=44444); 这时，找到第一条记录就会中止查询。 Firebird: select 1 from rdb$database where exists (select 1 from table_name where id=44444); Posted Jan 25 2007, 08:41 AM by wicky with | with 2 comment(s) Filed under: Development, Database

• Oracle:PL/SQL 中如何使用Array

  http://www.365tech.net/Oracle/20669 因为在PL/SQL 中并没有数组. 这是偶查资料找的范例和自己写的范例来解释如何在PL/SQL 中使用数组. 也许很多人已知道, 不过就是让不知道的朋友们了解一下吧。 ---------------------- 单维数组 ------------------------ DECLARE TYPE emp_ssn_array IS TABLE OF NUMBER INDEX BY BINARY_INTEGER; best_employees emp_ssn_array; worst_employees emp_ssn_array; BEGIN best_employees(1) := '123456'; best_employees(2) := '888888'; worst_employees(1) := '222222'; worst_employees(2) := '666666'; FOR i IN 1..best_employees.count LOOP DBMS_OUTPUT.PUT_LINE('i='... Posted Dec 29 2006, 06:23 PM by wicky with | with no comments Filed under: Development, Database

• Oracle关于时间/日期的操作

  在oracle中有很多关于日期的函数，如: 1、add_months()用于从一个日期值增加或减少一些月份 date_value:=add_months(date_value,number_of_months) 例: SQL> select add_months(sysdate,12) "Next Year" from dual; Next Year ---------- 13-11月-04 SQL> select add_months(sysdate,112) "Last Year" from dual; Last Year ---------- 13-3月 -13 SQL> 2、current_date()返回当前会放时区中的当前日期 date_value:=current_date SQL> column sessiontimezone for a15 SQL> select sessiontimezone,current_date from dual; SESSIONTIMEZONE CURRENT_DA --------------- -----... Posted Aug 22 2006, 08:53 AM by wicky with | with no comments Filed under: Development, Database