public IList GetCustomersByFirstname(string firstname)
{
//写法1
//return _session
// .CreateQuery("select from Customer c where c.Firstname='" + firstname + "'")
// .List();
//写法2:位置型参数
//return _session
// .CreateQuery("select from Customer c where c.Firstname=?")
// .SetString(0, firstname)
// .List();
//写法3:命名型参数(推荐)
return _session
.CreateQuery("select from Customer c where c.Firstname=:fn")
.SetString("fn", firstname)
.List();
}
[Test]
public void GetCustomerByFirstnameTest()
{
IList customers = _queryHQL.GetCustomersByFirstname("YJingLee");
Assert.AreEqual(1, customers.Count);
foreach (var c in customers)
{
Assert.AreEqual("YJingLee", c.Firstname);
}
}
实例2:获取顾客ID大于CustomerId的顾客:
public IList GetCustomersWithCustomerIdGreaterThan(int customerId)
{
return _session
.CreateQuery("select from Customer c where c.CustomerId > :cid")
.SetInt32("cid", customerId)
.List();
}
There really isn’t any formatting within a strong, beyond it’s alignment. Alignment works for any argument being printed in a String.Format call.
Sample
Generates
String.Format("->{1,10}<-", "Hello");
-> Hello<-
String.Format("->{1,-10}<-", "Hello");
->Hello <-
Numbers
Basic number formatting specifiers:
Specifier
Type
Format
Output (Passed Double 1.42)
Output (Passed Int -12400)
c
Currency
{0:c}
$1.42
-$12,400
d
Decimal (Whole number)
{0:d}
System.FormatException
-12400
e
Scientific
{0:e}
1.420000e+000
-1.240000e+004
f
Fixed point
{0:f}
1.42
-12400.00
g
General
{0:g}
1.42
-12400
n
Number with commas for thousands
{0:n}
1.42
-12,400
r
Round trippable
{0:r}
1.42
System.FormatException
x
Hexadecimal
{0:x4}
System.FormatException
cf90
Custom number formatting:
Specifier
Type
Example
Output (Passed Double 1500.42)
Note
0
Zero placeholder
{0:00.0000}
1500.4200
Pads with zeroes.
#
Digit placeholder
{0:(#).##}
(1500).42
.
Decimal point
{0:0.0}
1500.4
,
Thousand separator
{0:0,0}
1,500
Must be between two zeroes.
,.
Number scaling
{0:0,.}
2
Comma adjacent to Period scales by 1000.
%
Percent
{0:0%}
150042%
Multiplies by 100, adds % sign.
e
Exponent placeholder
{0:00e+0}
15e+2
Many exponent formats available.
;
Group separator
see below
The group separator is especially useful for formatting currency values which require that negative values be enclosed in parentheses. This currency formatting example at the bottom of this document makes it obvious:
Dates
Note that date formatting is especially dependant on the system’s regional settings; the example strings here are from my local locale.
Specifier
Type
Example (Passed System.DateTime.Now)
d
Short date
10/12/2002
D
Long date
December 10, 2002
t
Short time
10:11 PM
T
Long time
10:11:29 PM
f
Full date & time
December 10, 2002 10:11 PM
F
Full date & time (long)
December 10, 2002 10:11:29 PM
g
Default date & time
10/12/2002 10:11 PM
G
Default date & time (long)
10/12/2002 10:11:29 PM
M
Month day pattern
December 10
r
RFC1123 date string
Tue, 10 Dec 2002 22:11:29 GMT
s
Sortable date string
2002-12-10T22:11:29
u
Universal sortable, local time
2002-12-10 22:13:50Z
U
Universal sortable, GMT
December 11, 2002 3:13:50 AM
Y
Year month pattern
December, 2002
The ‘U’ specifier seems broken; that string certainly isn’t sortable. Custom date formatting:
Specifier
Type
Example
Example Output
dd
Day
{0:dd}
10
ddd
Day name
{0:ddd}
Tue
dddd
Full day name
{0:dddd}
Tuesday
f, ff, …
Second fractions
{0:fff}
932
gg, …
Era
{0:gg}
A.D.
hh
2 digit hour
{0:hh}
10
HH
2 digit hour, 24hr format
{0:HH}
22
mm
Minute 00-59
{0:mm}
38
MM
Month 01-12
{0:MM}
12
MMM
Month abbreviation
{0:MMM}
Dec
MMMM
Full month name
{0:MMMM}
December
ss
Seconds 00-59
{0:ss}
46
tt
AM or PM
{0:tt}
PM
yy
Year, 2 digits
{0:yy}
02
yyyy
Year
{0:yyyy}
2002
zz
Timezone offset, 2 digits
{0:zz}
-05
zzz
Full timezone offset
{0:zzz}
-05:00
:
Separator
{0:hh:mm:ss}
10:43:20
/
Separator
{0:dd/MM/yyyy}
10/12/2002
Enumerations
Specifier
Type
g
Default (Flag names if available, otherwise decimal)
f
Flags always
d
Integer always
x
Eight digit hex.
Some Useful Examples
String.Format("{0:$#,##0.00;($#,##0.00);Zero}", value);
This will output "$1,240.00" if passed 1243.50. It will output the same format but in parentheses if the number is negative, and will output the string "Zero" if the number is zero.
String.Format("{0:(###) ###-####}", 18005551212);
This will output "(800) 555-1212".
//Javascript
<script language="Javascript">
function getIE(e){
var t=e.offsetTop;
var l=e.offsetLeft;
while(e=e.offsetParent){
t+=e.offsetTop;
l+=e.offsetLeft;
}
alert("top="+t+"/nleft="+l);
}
</script>
光标是停在文本框文字的最后
<script language="javascript">
function cc()
{
var e = event.srcElement;
var r =e.createTextRange();
r.moveStart("character",e.value.length);
r.collapse(true);
r.select();
}
</script>
<input type=text name=text1 value="123" onfocus="cc()">
<script language=Javascript>
function cc(dd,dadd)
{
//可以加上错误处理
var a = new Date(dd)
a = a.valueOf()
a = a - dadd * 24 * 60 * 60 * 1000
a = new Date(a)
alert(a.getFullYear() + "年" + (a.getMonth() + 1) + "月" + a.getDate() + "日")
}
cc("12/23/2002",2)
</script>
选择了哪一个Radio
<HTML><script language="vbscript">
function checkme()
for each ob in radio1
if ob.checked then
window.alert ob.value
next
end function
</script><BODY>
<INPUT name="radio1" type="radio" value="/style" checked>Style
<INPUT name="radio1" type="radio" value="/blog/barcode">Barcode
<INPUT type="button" value="check" onclick="checkme()">
</BODY></HTML>
<html>
<head>
<script language="JavaScript">
var scrtxt="怎麽样 ! 很酷吧 ! 您也可以试试."+"Here goes your message the visitors to your
page will "+"look at for hours in pure fascination...";
var lentxt=scrtxt.length;
var width=100;
var pos=1-width;
function scroll() {
pos++;
var scroller="";
if (pos==lentxt) {
pos=1-width;
}
if (pos<0) {
for (var i=1; i<=Math.abs(pos); i++) {
scroller=scroller+" ";}
scroller=scroller+scrtxt.substring(0,width-i+1);
}
else {
scroller=scroller+scrtxt.substring(pos,width+pos);
}
window.status = scroller;
setTimeout("scroll()",150);
}
</script>
</head>
<body onLoad="scroll();return true;">
这里可显示您的网页 !
</body>
</html>
<script language="JavaScript1.2">
var isnMonth = new Array("1月","2月","3月","4月","5月","6月","7月","8月","9月","10月","11月","12月");
var isnDay = new Array("星期日","星期一","星期二","星期三","星期四","星期五","星期六","星期日");
today = new Date () ;
Year = today.getYear();
Date = today.getDate();
if (document.all)
document.title="今天是: "+Year+"年"+isnMonth[today.getMonth()]+Date+"日"+isnDay[today.getDay()]
</script>
显示所有链接
把如下代码加入<body>区域中
<script language="JavaScript1.2">
function extractlinks(){
var links=document.all.tags("A")
var total=links.length
var win2=window.open("","","menubar,scrollbars,toolbar")
win2.***("<font size='2'>一共有"+total+"个连接</font><br>")
for (i=0;i<total;i++){
win2.***("<font size='2'>"+links[i].outerHTML+"</font><br>")
}
}
</script>
<input type="button" onClick="extractlinks()" value="显示所有的连接">
回车键换行
把如下代码加入<body>区域中
<script type="text/javascript">
function handleEnter (field, event) {
var keyCode = event.keyCode ? event.keyCode : event.which ? event.which : event.charCode;
if (keyCode == 13) {
var i;
for (i = 0; i < field.form.elements.length; i++)
if (field == field.form.elements[i])
break;
i = (i + 1) % field.form.elements.length;
field.form.elements[i].focus();
return false;
}
else
return true;
}
</script>
<form>
<input type="text" onkeypress="return handleEnter(this, event)"><br>
<input type="text" onkeypress="return handleEnter(this, event)"><br>
<textarea>