This article mainly implements the Java drag mouse draw line function, in order to achieve the function of drawing line, respectively with implements MouseListener and Mousemotionlistener, and by mousepressed (), mousereleased () Gets the start and
4.3 single-line character function
Common Single-line character functions include the following:
█lower
█upper
█initcap
█concat
█substr
█length
█instr
█trin
█replac
Below, we introduce them separately by example.
LOWER(column name | expression):
Select Systemdate from dual--get timeSelect systemdate+300 from dual--date + number = date, which represents a date after several daysSelect systemdate-300 from dual--date + number = date, representing the date of the previous several daysSelect
The NVL () function, which handles NULL.Decode () function,: Majority value judgmentDecode (value \ column, Judge value 1, display value 1, Judge value 2, display value 2) If the judgment value is not included, the display is emptyThe Decode ()
The usual functions for handling strings are as follows :
No.
Name of function
Meaning
1
UPPER (C1)
To capitalize all strings
2
LOWER (C1)
Convert all strings to lowercase
#单行函数细分1. Character functions2. Mathematical functions3. Date function4. Other functions5. Process Control function#单行函数-Character functions#一, character functions#1. Length gets the bytes of the parameterSELECT LENGTH (' John ');SELECT LENGTH ('
Casing control functionsSELECT LOWER (' hellowrold'UPPER('HelloWorld');Character control functionsSELECT REPLACE ('abcdababab','P','m');Replace the character p in "Abcdababab" with M;SELECT TRIM ('from');Remove the spaces on both sides.SELECT Ten,'-'
1 character functions
length character length LENGTHB byte length lower to lowercase upper into uppercase initcap First letter capital
select Lower (' Xun Ying ') lowercase, Upper (' Xun Ying ')
Use DateOracle Internal use digital storage date: century, year, month, day, hour, minute, second.The default date display format is DD-MON-RR.--You can specify only the post-two bits of the year, allowing the 21st century date to be stored in 21st
-function functions like a black box (see the inside of the structure), there are parameter return values, you can do a certain function for us.-Single line This function evaluates each row in the result once, each row returns a result, and the
PHP MySQL wrong line of the function I want to know what the master has this function I remember there is ...
Reply to discussion (solution)
No one knows?
Mysql_error ()Do you know where you're wrong?
Well, thanks for the reply, but that's not
Most of the functionality is implemented through template columns, in order to easily select and delete the use of its own features and methods, it is easy to achieve, did not find any major problems, but in the deployment to the server, found that
Solution Idea:
1. Add a "-" + "number in the header for the user to click.
2, the user shrinks and expands the screen the behavior to save in the cookie inside. The page reloads or the user logs on to the system, still remembering the user's
Copy Code code as follows:
Replace special characters in HTML
Text that needs to be replaced.
Replace the finished text.
public string HtmlEncode (string thestring)
{
Thestring=thestring.replace (">", ">");
To introduce the character function first:Case Related:1.
Select lower (' Hellow '), Upper (' Hehhlo '), Initcap (' Oello ') from
dual;--dual empty table.
Results:
Hellow Hehhlo Oello
and Case Independent:1.
SELECT trim (' h ' from ' hellowhh '),
Date functionDate functions manipulate Date values (fields of date type), timestamp values (TIMESTAMP, TIMESTAMP with time ZONE, and TIMESTAMP with the fields of the local time ZONE type), and interval values (INTERVAL day to SECOND and INTERVAL
Classification of single-line functions in Oracle:1. Character Functionssubstr (): String interceptSelect substr (' I love you, you know? ', 0,4) from dualExecution result: I love you,Length function: string lengthsSelect Length (' I love you, you
16.L: Represents the local currency symbol, which is related to the region. This time we want to show the symbol of RMB: ¥$ VI. Bash_profile---write the following: Export Nls_lang='Simplified Chinese'_china. Al32utf8---Change to Simplified Chinese +
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.