Login AS04 - Oracle command: 1.Telnet as04.wh.wistronits.com 2.login: Oracle 3.chdb # Select Database Spectro Oracle_sid = IASDB # Default, you can enter Enter Oracle_Home = / OPT / App / Oracle / Product / 10.1.0 / db_1 4.cd $ ORACLE_HOME 5.CD BIN 6.DBSTART #Lock Database 7.lsnrctl Start # launch listener login 251 - Oracle command: cd /opt/ora9/product/9.2/bin lsnrctl Start Agentctl start export ORACLE_SID = essp sqlplus / nolog connect / as sysdba startup exit export ORACLE_SID = essptemp sqlplus / nolog connect / as sysdba startup 2. Lu Liang QQ:? 17535856 3.
3. Pay attention to these tables after the database is imported: Essp_hr_employee_main_t Essp_UPMS_Function Essp_upms_user_fun is best retransmitted.
5.CVS Import a folder You can use the import command: The work directory is set to: D: / ESSP / ESSP2005 right click on the folder to import, select Import. In the next setting, you set the modul name: "Root Module Name / ... (Path) / This folder", such as ESSP2 / PMS, the root directory is ESSP2, and the path to this folder is ESSP2 / PMS. Just pay attention: is the left slash / instead of right alarm. 6. Hibernate's strange error: If the field type in the database is DATE, and the data is defined in the Database bean, and the value of the actual saved is a Date type Object rotted string result .: value Non-numeric characters, expected to be Numeric,
*************************** Linux learning ******************** ****************************************************** 1. LS column The commands for files and directories: LS commands have a lot of options: -a options are used to list all files, including those hidden files (such as .bashrc) -l used to display a list, display each file Size, modification date, etc. -R Displays all files (including subdirectory) Recursive - Help2. CD is the same as Windows: CD / -> Enter the root CD .. -> Previous directory CD ~ Enter users Personal directory, root user is / root directory, KRIS users are / home / kris directory CD - into the previous prompt directory
The CD command does not take any parameters so that you can return to your directory / usr3. PWD prints the current directory 4. MKDIR New directory name 5. RM to be deleted with the file name or directory name (delete a directory, if a directory is already There are files, RM is not letting direct deletion) -RF -> delete directory, which makes it in the file, also deletes it 6. MV old file name new file name MV old directory name new directory name 7. CP old file name New file name 8. Man command name, view command manual 9. Cat Loveletter Display file content 10. The shutdown command is the HALT restart command is the reboot shutdown command shutdown command to securely turn off or restart the Linux system, which before the system is turned off Give all login users on the system a warning message. This command also allows the user to specify a time parameter, which can be a precise time or a time period from now. The exact time is format is HH: mm, represents hours and minutes; the time period is represented by " " and minutes. After the system executes this command, the data synchronization is automatically performed. The general format of this command is: Shutdown [Option] [Time] [Warning Information] Command The meaning of each option is: - K does not really shut down, but just issue a warning message to all users. - Retart immediately after shutdown. - The h is turned off after shutdown. - f Qu quickly and skips FSCK when restarting. - n Quick shutdown, no init program. - C Cancel a rundown that has been run. It is important to specify that this command can only be used by superuser. Example 1: The system is turned off after ten minutes and will be restarted immediately. # Shutdown - R 10 Case 2: The system is turned off immediately and does not restart. # Shutdown - h Now
11. mount -t iso9660 / dev / cdrom / mnt / cdrom Plug the optical drive to / mnt / cdrom directory -t parameter is the file system type specified in the disc, in general, the disc is used in the ISO9660 standard format / dev / CDROM refers to CD / MNT / CDROM for a directory MOUNT / DEV / FD0 / MNT / FLOPPY mount floppy disk umount / mnt / cdrom or umount / dev / cdrom cancels mount. After mount the disc, the disc will not be "popped up", even if the button is not used. Umount / dev / fd012. More pipe command more loveletter -> Loveletter The content is displayed on the screen. If you don't get a page, you will stop it, wait for your button, then continue to display the next page below. > A pipe that is larger than the symbol is used to create a new file filenames.txt, and if you already have the same name, you already have the previous content. >> Two larger than the symbolic pipe is used to add new content behind the existing files, and if this file is not created. CAT >> Friends << "eof" means saving us to the Friends file, when we enter "EOF", end. "<<" means that a data is transmitted to the previous command. 13. The feature of the free command Free command is to view the usage of the current system memory, which displays the remaining and used physical memory and exchange memory in the system, and shared memory and buffer used by the core. The general format of this command is: The meaning of each option in the free [-b | -k | -m] command is shown below: -b Display in bytes. -K is displayed in k bytes. -M is displayed in megabytes. 21. Gao Ning's phone: 13970229725
Ren Yan 13995603712
Chen Jiali 13972158072
Xiong Lei's 13971294793
Yuyang 027-62998772
Xiao Bin 13330021260
Xiao Bin 0792-8814227
Li Wei 13871270956 He Zhihao 13886152331
22. Interesting questions: Define an Abstract method of the Package Scope-free Package Scope in the Abstract Class, the implementation class of the method must be in the same package, in different packages, compile Error, it is considered not to implement the AbsCTract method. This is said: Abstract Class in Abstract Class does not default to public scope? 23.jboss Rugged: Click the JBoss window to close the button, do not close the window, wait for you to end. Re-open. 24: Oracle's query tree statement: select count (*) from dept start with rid =? Connect by prior rid = PARENTRID;
25: Catalina Run> D: /log.txt This command writes the output text of Tomcat to the file log.txt.
27: Method for DOS command: 1. Use echo command: echo ^ g Due to special characters ^ g can't enter the text directly, use the following method to write in the DOS console: Echo "Echo ^ g "> C: /a.bat can be removed before and after the file a.bat. (Enter ^ g on the console is: Alt 7 or Ctrl G) 2. Use the choice command: echo a ^ _ | choice / c ^ _ / n can be written to the text in the text as the same method go with. (Enter ^ _ method on the console is: Alt 255, actually a displayed character, but not empty characters)
28: CVS: 1. Login command: cvs -d: pserver: huaxiao: huaxiao@as04.Wh.Wistronits.com/home/cvsroot/essp login Note Two "huaxiao" for username and password, if one is omitted, then It is considered to be a username. If the user's password is not empty, you will prompt the input password; the average Anonymous account does not require a password 2. Command CVS History -c printing the module (which module is related to the current module) History "Submit" action (M modification, A, R deletion, R deletion,) each file is the "-x" parameter as the "-x" parameter, which specifies the output specified action, see 3. For example, "CVS History -x A" prints all "new" action "-c" and "-x mar" equivalent CVS HISTORY -C -Z 0800 parameter "-z 0800" specified output information Time value, ie 8 hours 0 minute, CVS History -c -z 0800 -f new.txt print parameter "-f new.txt" Historical action cvs history -c -l parameter "-l "Indicates that only the latest historical action. If you don't specify, you will output a typical example of the previous action: 1. CVS -D: PServer: huaxiao: huaxiao@as04.Wh.Wistronits.com: / home / cvsroot / Essp History - C> e: /ssp/t/cvs.log / home / cvsroot / ESSP is a CVS warehouse, this command prints all of the HISTORY of the modules, such as modules ESSP and ESSP2. Defect: When the file is imported into the museum with the import command, these files will not have History, which is the output of these files without the output of the History command. The log command will not have this problem. History commands in the console, such as: M 2006-01-16 13:49 0000 huaxiao 1.4 build.xml Essp2 / attendance ==
4. CVS log command: CVS log prints the most detailed information cvs log -l parameter "-l" means not to pass the middle of the child, only the current directory CVS log -r parameter "-r" means only the output of each file RCS file (RCS file is the name of each file ", V") its output, such as: rcs file: /Home/cvsroot/ersp/sp2/crm/rc/server/ssp/RM/Resources/application.properties, v Working file: src / server / essp / crm / resources / application.properties head: 1.1 branch: locks: strict access list: symbolic names: V2_20060109: 1.1 V1_6_0: 1.1 V1_5_3: 1.1 V1_5_2: 1.1 V1_5_Branch: 1.1.0.2 V1_5_1: 1.1 v1_5_0: 1.1 V1_4_0: 1.1 Keyword Substitution: KV Total Revisions: 1; SELECTED Revisions: 1 Description: -------------------------------------------------------------------------------------------------- Revision 1.1 Date: 2005/10/20 01:18:28; Author: rongxiao; state: exp; no message ========================= ============================================================================================================================================================================================================= == Typical example: cvs -d: pserver: huaxiao: huaxiao@as04.Wh.Wistronits.com: / home / cvsroot / Essp Log> E: /ssp/t/cvs.log Explanation: CVS logs on the console When the command, it will traverse all the subdirectory of the current directory, find out the document belonging to the CVS jurisdiction (actually reading the CVS / Repository file acquisition module name), generates LOG, "Current Directory" Important (Imagine if the current directory of the same module is 2 copies by Checkout, then 2 times log).
4. Add a user guest in WinCVS (can also be used to change your password): cvs passwd -r administrator -a guest explanation: cvs passwd (passwd command) -r administrator (Administrator is an existing "Real" user, pay attention Is the "real" user, the user generated by this command is not a "real" user. The machine's administrator is a "real" user) -a guest (new user) command will prompt the password, enter: Guest Then add success. If the user already exists, it is equivalent to a change password. This command will add a row in the passwd file: guest: o0jupqwoobdsu: administrator explanation: Username: Encrypted password: Exes already exists. In fact, the Passwd file will be used directly. 5. Add permissions to users: (as if there are 4 new users with the same privileges that have existing users) modify the Writers and Readers files, add the username to the username. 6. On the CVS Museum can use the following Keyword $ Author $ AuThor's login name. $ DATE $ This version is checked in the date and time (UTC). $ HEADER $ GSH includes the full path, version number, date (UTC), author, status, and locks (if there is lock). Film in the use of CVS usually does not need to be locked. $ ID $ In addition to the RCS file does not include a path, the rest and $ header $ is the same. $ Name $ Checks the label used in this file. This keyword is expanded when the label is explicitated. For example, when running the cvs co -r first command, the keyword extension is `Name: first '. $ Locker $ Lock version of the user login (if you do not lock this is empty, it is usually the case unless you use CVS Admin-L to lock). $ Log $ log information is available at the time of submission, the front is a header including the RCS file name, version number, author, date (UTC). Existing log information will not be replaced. Instead, the new log information will be plugged in $ log: ... $. By default, each new line is used in front of the string before the same $ log $ keyword unless MaxcommentLenelength is set in CVSROOT / Config. For example, the file file contains: / * Here is what people have been up to: * * $ log: frob.c, v $ * revision 1.1 1997/01/03 14:23:51 Joe * Add the superfrobnicate option * / $ RCSFile $ has a RCS file name without a path. $ Revision $ The revision number of the file. The full path for the $ source $ RCS file.
$ State $ Inly, CVS will be inserted into Keyword with the actual value such as: $ Author: Administrator $ No matter where Keyword is, it will be replaced. 7. Checkout Command: CVS -D: PServer: huaxiao: huaxiao@as04.Wh.Wistronits.com: / home / cvsroot / essp2 checkout -d essp2.2 -r head command creates a directory Essp2.2 in the current directory ( If you already exhibited, you will have an exception, then you will go in the new ESSP2.2 directory of Modul Essp2. Note that the ESSP2 subdirectory will be created in ESSP2.2.
8. UPDATE command: cvs update -p parameter '-p' clears the empty directory cvs update -d parameter '-d' creates a new directory cvs update -r 1.1 tc / build.xml Get file 1.1 version 9. DIFF command : CVS DIFF -R 1.6 -r 1.7 TC / Build.xml Difference Difference Difference Difference Diff Results DIFF results: 1. General output below: 236C237 <
Indicates that 1.6 version deletes a row 247 (relatively 1.7 version, starting from the 246 line of the 1.7 version). 29. Interesting mail exception: Send a message with a mail.jar package, then use a batch to run the sendmail program, find that all JAR (including mail.jar, sendmail.class, etc.) is a JAR Run error: javax.mail.nosuchProvideRexception: No provider for SMTP solution is to separate mail.jar separately, not with other hits. Somehow.
30. Oracle 1. ORCALE function example: Time field string: to_char (b.datefrom, 'yyyy') is turned to time type: to_date ('20060101', 'YYYYMMDD') (to_date (to_char (B.dateFrom, 'YYYY'), 'YYYY') -> Transfer the monthly day of the time field to the number type: to_number (,) 2. Insert Into Table1 (RID) SELECT RID from Table2 Insert the contents of Table2 to Table1 Go, pay attention to no values keyword 3. Export data: exp ESSP / ESSP @ ESSP_AS04, where Essp_AS04 is the configured service name. Import data: IMP ESSP / ESSP @ ESSP_AS04, where Essp_AS04 is a configured service name. 4. Delete the table: Drop Table PMS_ANT; Remove Table and Table with Its Foreign Key Relation: Drop Table PMS_ANT Cascade Constraints; 5. Exp Command Parameters: UserId: User name / password of the account running the export command / password Buffeer: Used to take the data line Buffer size File: Export the name of the dump file Compress: Export should compress a fragmentation section into a range, which will affect the Storage clause: Deport whether you want to export the authorization INDEXES on the database object: Export Index Rows on the table: Whether it should be guided. If it is 'n', only DDL consstraints of the database object in the export file: Does the old agreement condition full: If set to 'y', then a whole database is executed Owner: To export one Series database account, then execute these accounts User export operation Tables: A series of tables to be exported; the Table Export operation of these tables is executed RECordLength: The length of the dump exported file log (in bytes), usually used by default Unless you want to pass the export file in both different operating systems: The type of exported operation being executed (the valid value has the COMPLETE, Cumulative, and Ivcremental) Record: A tag in the incremental export type, indicate Whether to store the log to the list of log exported in the data dictionary: The name to be passed to the exported parameter file. This file will contain all parameters of entry Analyze: indicate whether to write a statistics of the object to consistent: indicate whether to keep all exported objects to read the uniform copy log: Export the name of the file to be written Example: Exp ESSP / ESSP @ ESSP_AS04 file = ESSP_20060223_2.DMP log = ESSP_20060223.LOG TABLES = PMS_ANT, PMS_ACTIVITY
Imp Command Parameters: UserID: Username / Password Buffeer running the import command: The size of the buffer used to take the data row: Import the name of the dump file show: specify whether the file content is displayed, not being executed ( ? Don't understand!) Ignore: Whether to ignore the incorrect error when executing the 'create' command. If the object being imported already exists, you should use this parameter full: If set to 'y', the entire database introduction operation fromUser: In the case of full = n, there is a parameter. It is a series of database accounts that should read Touser from export dump files: A series of database accounts, exporting objects that deduct dump files will import these accounts GRANTS: Import to import authorized INDEXES on the database object: Do you want to import an index rows on the table: Whether it should be transferred. If it is 'n', execute the DDL Tables of the Database object in the import file: a series of tables to imported: Type of the File log (in bytes), usually use default, unless you want Passing the import file in two different operating systems: The type of imported operation being executed (the valid value has a COMPLETE, Cumulative and Ivcremental) PARFILE: The name to be passed to the imported parameter file. This file will contain all parameters, INDEXFILE, which is displayed in the import dump file, which is displayed to the imported dump file: Import the log, the imported action, only generate the text of the index 6. Isolated all tables: select Table_name from user_tables 31: email:
33: About learning C , I recommend some books to you (of course, it is better to combine the project practice): 1. THE C Programming Language (Bjarne Stroustrup) 2. Inside THE C Object Model (Stanley B. Lippman) (This book introduces some internal implementation of C ) 3. Advanced C Programming Styles and IDioms (James O. Coplien) (This book introduces some C programming habitual usage) 4. STL TUTORIAL AND REFERENCE (David R. Musser) (Professor Musser is one of my alma mater, one of the founders of STL. This book introduces Generic Programming ideas and standards). 5. Design Patterns (Erich Gamma) (Subsicative Oriented Components and Examples) Of course, you have to do your hand (test routine or exercises) when you look at any book. Then try to test the method in the classroom project to deepen the impression. "Foreign C almost all textbooks are translated into Chinese. If there is no translation, there is already a copy version. 50 TCPL and D & E are referred to as" THE C Programming Language "and" The Design and Evolution of C ", all From the hand of Bjarne Stroustrus. Say that they are C language Bible, not too.
Chinese name: "C programming language (special edition)", mechanical industrial publishing house "C language design and evolution", Machinery Industry Press 6. Getting Started Tutorial Stanley B.Lippman, Josee Lajoie, C Primer (3rd Edition) C Primer (3RD) Chinese version ", China Electric Press, 7. Stanley B. Lippman, Essential C " Essential C Chinese version ", Huazhong University of Science and Technology Press 8." Essential C (Copy Edition) ", China Electric Press 9 Efficient, health program "Effective C Chinese version", Huazhong University of Science and Technology Press, "More Effective C Chinese version", China Power Press 11. "Exceptional C Chinese version", China Electric Press 12 "More Exceptional C Chinese ", Huazhong University of Science and Technology Publishing House Template and Wizard Programming 13" C Templates Full View (Simplified Edition ", People's Posts Publishing House 14" C Design New Thinking: Wide Programming and Design Mode ", Huazhong University of Science and Technology Publishing Social standard library 15 "C standard library: self-development tutorial and reference manual", Huazhong University of Science and Technology Press, 16 "Effective STL (Copy)", China Power Press Network Programming 17 "C Network Programming, Volume 1: Apply ACE and Mode elimination complexity ", Huazhong University of Science and Technology Publishing House 18" C Network Programming, Volume 2: Systematic Reuse Based on ACE and Framework ", Electronic Industry Press Miscellaneous 19" C Programming Ideology (2nd Edition) Volume 1: Standard C Guide ", Machinery Industry Press 20" C Programming Thought (English Edition 2nd Edition) ", Machinery Industry Press 21" C Shen Shu ", People's Posts Publishing House 22" Depth Exploration C Object Model ", Huazhong Technology University Press 23 "Depth Exploration C Object Model (Cast)", China Power Press 24 C Engineering Sumber: "Design mode: Object-Oriented Software Foundation", Machinery Industry Press
34: Interesting JBuilderX Set Tomcat4 and Tomcat5: In Config Server, configure a Tomcat 4.0, in general, as long as you specify a Tomcat directory. Other, such as starting JAR (Bootstrap.jar) / Run Tomcat JAR (Common / lib / serlet.jar) JBuilder provides default settings. After configuring Server, you can create a web module and use Tomcat 4.0 Server. When you run this web, JBuilder will do two things: generate a Tomcat's temporary directory under the project directory, generate CONFIG / Server8080.xml and WebApp / JB-Test.xml two files. These two files correspond to Tomcat default Server.xml and Web.xml. For Tomcat4.0, all this is right, you can guarantee Tomcat to start. But it is not possible to Tomcat5.0. If the Tomcat5.0 is configured, JBuilder still thinks it is a tomcat4.0, which will appear three questions: 1. Serlet.jar is not in Tomcat5.0, and does not need to set up the run in JBuilder. 2. Automatically generated server8080.xml specifies that the Connect class is org.apache.coyote.tomcat4.coyoteconnector, this tomcat4 is not, to change to Tomcat5 3. JB-Test.xml placed in WebApp. The modification is: 1. Tomcat4 in the file server8080.xml is Tomcat5; 2. Merge the contents of JB-TEST.XML to Server8080.xml. Note: This sentence is deleted when Server8080.xml is modified: " "JBuilder2005 will correct Tomcat4 and Tomcat5 correctly, and make correct settings.