Tidy up the QQ space, pick out the small knowledge

Database:

SQL Server changed password, "exec sp_password null, ' 1234 ', ' sa '", modify sa password to 1234, MySQL cannot connect LAN host exception, need to change MySQL The database in the user table in the Host field to rename localhost%, do not forget to execute the flush privileges; MySQL is case-sensitive, Oracle table partitioning can effectively deal with massive data; Oracle Direct delete data does not log Will clean up the number of extent that the table occupies, "TRUNCATE TABLE AA"; Oracle supports regular expressions from 10g, Oracle queries Select * from V$sqlarea, and the most important feature of SQLite is that its data type is no data type ( typelessness).
A machine Oracle 10g-B machine Oracle 9I,B machine plsql a machine, export DMP, then the DMP, pour into the B machine;

Javascript:

jquery's HTML () method, which has different effects in different browsers, sometimes has a fatal problem; jquery layout plug-in isotope very useful, what waterfall flow is a cloud; Jquyer cross-domain operation, pass the past Jsoncallback parameters, To use Request.getparamter to get.  Then add to the returned JSON string before Eg:request.getParamter ("Jsoncallback") + "(" +jsonstring+ ")"; Although they look the same, the results are different. The jquery function passes the value $ (this). bind (' click ', {id:f_id, tag:0, B:belongid}, vote); function parameters such as functions vote (event), value such as: EVENT.DATA.B, with Chrome browser as the end of the page effect (with JS), to be deployed under Tomcat or other middleware to see, otherwise it will not be allowed, For example, parent.document (the child window gets a variable from the parent window, it is not available). function Stopdefault (event) {if (Event&&event.preventdefault ()) {Event.preventdefault ();} Else{window.event.returnvalue=false;}} A tag page scrambling problem, add in the onclick Ajax does not support GBK, need to decode;

Work Flow:

Activiti5 to note that the file name of the process files must end with Bpmn20.xml;

Single Sign-on:

CAS clients with no special needs, the dependent jar packages are only placed in Cas-client-core-3.2.1.jar and Commons-logging.jar. CAS related downloads http://downloads.jasig.org/cas/.

Ldap:

LDAP more useful client jxplorer, download address: http://www.jxplorer.org/; server side is convenient apacheds. The ldaptemplate of spring can be used in the program.

Encryption:

Encrypt and decrypt transmitted data, using Sun.misc.BASE64Decoder (encryption) and Sun.misc.BASE64Encoder (decryption). If a servlet is to use Request.getheader ("XX") to receive parameters, the requesting initiator will use the URL to create a httpurlconnection connection to the servlet. Then use Setrequestproperty to set the parameters, after the connection the servlet receives parameters and processing returns the results of processing, the request initiator uses Getresponsecode to get the result code, close the connection, complete.

Instant Messaging:

OpenFire + Spark combination of real-time communication tools, online information is not much, only one by one a bit of content is also covered, the official web site also does not have much useful information, even the Mongolian guess two days from deployment to plug-in development, and then to the XMPP protocol communication (CS both ends of the communication), finally pass, s end need to note: Org.jiresoftware.openfire.handler.iqhandler.java;c end to note: Org.jiresoftware.smack.provider.IQProvider.java. The most important thing that bothers me the most is how the request originated and finally found Sparkmenager.getconnection (). Sendpacket (New Packet ());

Regular Expressions:

"1,2,3,4,", using split in Java, the last comma is ignored by var arr = Str.match (reg);//returns all matches with regular expression m multi-line match, G Global match, example: var reg = new RegExp (/<\*\ *[^\s]*\s (\d+) \s\*\*>/gm);

Java Anti-compilation:

Jad-o-r-8-sjava-dsrc ' D:/classes/**/*.class ';

Discuz Docking:

Diszuc print function sprintf ("%02d", $day); %02d meaning is less than two digits to fill 0, data migration to diszuc7.2, you need to note that the user password only need to import into the Cdb_uc_member table, but note that the salt field is a random password, Discuz encryption method is MD5 (MD5 (user real password) + Random code), another need to pay attention to the introduction of the history of the Avatar, the specific address of the avatar is not stored in the database, but through the way the file in the Uc_server folder to create a folder, such as a user ID of 173, then the way to deal with 9-bit,173-> 000000173 then split into 000/00/01/73.jpg, the front of the 000/00/01 is a folder, 73 for the specific document; Discuz Forum starting from 6.1 to install ucenter at the same time, and Ucenter and Ucenter Home is two things.
Project Management:

Coding to pay more attention to the Open-close principle, visual svn,visualsvn,http and SVN two ways to access, no additional Apache to manage passwords, more convenient.

Barcode Recognition: Online to find a lot of Barcode generator website, most of them are fake, I think my program has problems, find a long-range to find a reliable free online barcode Generator website: http://barcode.tec-it.com/ Barcode-generator.aspx? LANG=ZH-CN. Yesterday, Google's barcode recognition open source code site is: http://code.google.com/p/zxing/, not only support Android, but also support the iphone. CSS style:
_ is the CSS hack method in IE6