程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> 其他數據庫知識 >> MSSQL >> SQL Server觸發器和事務用法示例

SQL Server觸發器和事務用法示例

編輯:MSSQL

SQL Server觸發器和事務用法示例。本站提示廣大學習愛好者:(SQL Server觸發器和事務用法示例)文章只能為提供參考,不一定能成為您想要的結果。以下是SQL Server觸發器和事務用法示例正文


明天我要向年夜家分享一款很特殊的CSS3分頁插件,這款分頁插件不只可以點擊分頁按鈕來完成分頁,並且可以滑動滑桿來完成隨意率性頁面的跳轉,看看都異常酷,很合適一些特性化的小我網站應用,固然,這款分頁插件也合適ajax翻頁,後果都挺不錯的。先來看看後果圖:


怎樣樣,還挺酷的吧。

固然你也能夠在這裡檢查插件的DEMO演示。

接上去我們來分享一下源碼的完成思緒,這裡用到了jQuery UI框架,這麼酷的滑桿是靠它完成的,否則,寫的累逝世。。

起首是HTML代碼:



<div class="pageSlider long"></div>
<form class="pageForm" action="#">
<label class="pageLabel" for="pageInput">
Page number you'd like to go to. (Max of 30)
</label>
<a
class="pagePrev pageSkip"
href="#?page=6"
title="Previous Page (6)">Previous Page</a>
<input id="pageInput" class="pageInput"
type="text" maxlength="3" placeholder="#">
<a
class="pageNext pageSkip"
href="#?page=8"
title="Next Page (8)">Next Page</a>
<button class="pageButton"
title="Go to chosen page of results">Go</button>
</form>


這裡我們看到,先是界說了滑桿的區域,然後是兩個分頁按鈕,可以向前翻和向後翻,最初是一個隨意率性頁跳轉的頁碼輸出框和一個按鈕。

別看這個滑桿很英俊,會很難完成,其實應用jQuery UI這個器械異常簡略。

接上去看看CSS代碼:

前後翻頁按鈕:



.pageSkip {
display: inline-block;
background: transparent url('css/monotone_arrow_left_small.png') no-repeat -10px -10px;
text-indent: -999em;
background-size: 40px;
opacity: 0.7;
vertical-align: middle;
width: 20px;
height: 20px;
}
.pageNext {
background-image: url('css/monotone_arrow_right.png');
}

很遺憾,應用了兩張箭頭圖片作為配景,不外,後果也還可以。

然後是輸出框:



.pageNumber {
position: relative;
top: -38px;
left: 50%;
font-size: 12px;
color: #333;
width: 60px;
display: block;
text-align: center;
margin-left: -17px;
background: white;
padding: 5px 10px;
border-radius: 3px;
box-shadow: 0 0 5px rgba(151, 38, 20, 0.15);
}
.pageNumber:after {
content: " ";
display: block;
position: absolute;
width: 0;
height: 0;
top: 24px;
border: 6px solid transparent;
border-top-color: white;
}

然後是滑桿的配景,應用了CSS3線性突變屬性:



.ui-slider-horizontal {
width: 60%;
height: 6px;
top: 0px;
margin: 0px 10px 2px;
border-radius: 6px;
position: relative;
display: inline-block;
background: #F46652;
background-image: repeating-linear-gradient(28deg, transparent, transparent 10px, #dd5846 10px, #dd5846 20px);
box-shadow: inset 0 2px 5px rgba(0, 0, 0, 0.4);
}
.ui-slider-horizontal:before {
content: " ";
position: absolute;
width: auto;
height: 16px;
top: -5px;
left: -4px;
right: -4px;
border-radius: 10px;
z-index: -1;
background: linear-gradient(rgba(0, 0, 0, 0.1) 0%, rgba(255, 255, 255, 0.8) 90%);
}
.ui-slider.long .ui-slider-handle {
height: 12px;
width: 30px;
background: #f1f1f1;
display: block;
position: absolute;
border-radius: 50px;
margin-top: -3px;
margin-left: -15px;
text-decoration: none;
background: #f5f5f5;
background: linear-gradient(#f5f5f5 0%, #cccccc 100%);
box-shadow: 0 0 10px 0px rgba(0, 0, 0, 0.35), 0 0 2px 1px rgba(0, 0, 0, 0.15), 0 3px 3px rgba(0, 0, 0, 0.2), 0 7px 5px rgba(0, 0, 0, 0.1), 0 11px 10px rgba(0, 0, 0, 0.1);
}
.ui-slider.long .ui-slider-handle::before,
.ui-slider.long .ui-slider-handle::after {
content: " ";
width: 2px;
height: 40%;
position: absolute;
background: transparent;
border-radius: 0px;
box-shadow: -1px 0px 0px rgba(255, 255, 255, 0.8), 1px 0px 0px rgba(255, 255, 255, 0.8), 2px 0 0 rgba(0, 0, 0, 0.3), 1px 0 0 rgba(0, 0, 0, 0.3) inset;
}
.ui-slider.long .ui-slider-handle::before {
left: 10px;
top: 30%;
}
.ui-slider.long .ui-slider-handle::after {
right: 12px;
top: 30%;
}
@media (max-width: 550px) {
.pagination {
width: auto;
}
.pageForm {
display: block;
margin-top: 20px;
}
.pageInput {
margin: 0;
}
.pageSlider {
width: 260px;
margin: 0 15px;
}
}

最初是js,這是用來完成翻頁邏輯的,來看看:


$(document).ready( function() {
var pagesMax = 30;
var pagesMin = 1;
var startPage = 7;
var url = "<a href="http://yoe.com/results?page={{1">http://yoe.com/results?page={{1</a>}}";
$('.pagination .pageSlider').slider({
value: startPage, max: pagesMax, min: pagesMin,
animate: true,
create: function( event, ui ) {
$('.pagination .pageSlider .ui-slider-handle').attr({
"aria-valuenow": startPage,
"aria-valuetext": "Page " + startPage,
"role": "slider",
"aria-valuemin": pagesMin,
"aria-valuemax": pagesMax,
"aria-describedby": "pageSliderDescription"
});
$('.pagination .pageInput').val( startPage );
}
}).on( 'slide', function(event,ui) {
// let user skip 10 pages with keyboard ;)
if( event.metaKey || event.ctrlKey ) {
if( ui.value > $(this).slider('value') ) {
if( ui.value+9 < pagesMax ) { ui.value+=9; }
else { ui.value=pagesMax }
$(this).slider('value',ui.value);
} else {
if( ui.value-9 > pagesMin ) { ui.value-=9; }
else { ui.value=pagesMin }
$(this).slider('value',ui.value);
}
event.preventDefault();
}
$('.pagination .pageNumber span').text( ui.value );
$('.pagination .pageInput').val( ui.value );
}).on('slidechange', function(event, ui) {
$('.pagination .pageNumber')
.attr('role','alert')
.find('span')
.text( ui.value );
$('.pagination .pageInput').val( ui.value );
$('.pagination .pageSlider .ui-slider-handle').attr({
"aria-valuenow": ui.value,
"aria-valuetext": "Page " + ui.value
});
});
$('.pagination.pageSlider.ui-slider-handle').on('keyup',function(e){
if(e.which==13){
varcurPage=$('.pagination.pageSlider').slider('value');
alert('wewouldnowsendyouto:'+url.replace(/{{.}}/,curPage));
}
});
$('.pagination.pageInput').on('change',function(e){
$('.pagination.pageSlider').slider('value',$(this).val());
});
vartmr;
$('.pageSkip').on('click',function(e){
e.preventDefault();
var$this=$(this);
if($this.hasClass('pageNext')){
varcurPage=$('.pagination.pageSlider').slider('value')+1;
}elseif($this.hasClass('pagePrev')){
varcurPage=$('.pagination.pageSlider').slider('value')-1;
}
$('.pagination.pageSlider').slider('value',curPage);
clearTimeout(tmr);
tmr=setTimeout(function(){
alert('wewouldnowsendyouto:'+url.replace(/{{.}}/,curPage));
},1000);
});
functionsliderPips(min,max){
varpips=max-min;
var$pagination=$('.pagination.pageSlider');
for(i=0;i<=pips;i++){
vars=$('<spanclass="pagePip"/>').css({
left:''+(100/pips)*i+'%'
});
$pagination.append(s);
}
varminPip=$('<spanclass="pageMinPip">'+min+'</span>');
varmaxPip=$('<spanclass="pageMaxPip">'+max+'</span>');
$pagination.prepend(minPip,maxPip);
};
sliderPips(pagesMin,pagesMax);
functionsliderLabel(){
$('.pagination.ui-slider-handle').append(
'<spanclass="pageNumber">Page<span>'+
$('.pagination.pageSlider').slider('value')+
'</span></span>');
};
sliderLabel();
$('.pagination.pageButton').on('click',function(e){
e.preventDefault();
varcurPage=$('.pagination.pageSlider').slider('value');
alert('wewouldnowsendyouto:'+
url.replace(/{{.}}/,curPage));
});
});

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved