mysql 满足某个条件的时候求和

[不指定 2014/08/07 15:37 | by 吕进 | Via 本站原创 ]
数据库结构表
CREATE TABLE IF NOT EXISTS `ceshi` (
  `id` int(5) NOT NULL auto_increment,
  `Type` enum('1','2') character set utf8 NOT NULL default '1' COMMENT '1:收入,2:支出',
  `Name` varchar(4) character set utf8 NOT NULL,
  `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `Amount` decimal(9,2) NOT NULL COMMENT '金额',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

按Name汇总收入和支出的语句:
select NAME, sum(if(Type=1,Amount,0)) as 收入,  
sum(if(Type=2,Amount,0)) as 支出 from ceshi group by name

效果图:
点击在新窗口中浏览此图片
Tags:

CuteFTP显示主机隐藏文件

[不指定 2014/08/07 10:39 | by 吕进 | Via 本站原创 ]
CuteFTP默认不显示如.htaccess类型的文件。但我们有时候需要找到这个文件进行修改或删除,怎么办呢?
具体方法:
1、将您的站点添加到“站点管理器”(主机框最右侧的那个带加号的按钮);
2、在“站点管理器”中找到您的站点,右键到“属性”管理;
3、动作 -> 过滤 -> 过滤属性
4、在“启动过滤”和“启动服务器端过滤(服务器运用过滤)”前打钩;
5、在“远程过滤”框中 输入“-a”,点运用、确定即可
点击在新窗口中浏览此图片
Tags:

CuteFTP清除主机和密码的连接记录

[不指定 2014/08/07 10:18 | by 吕进 | Via 本站原创 ]
点击在新窗口中浏览此图片
要清除CuteFTP中,缓存的主机、用户名和密码,可以通过注册表完成。具体方法是:
1、运行:regedit
2、展开注册表路径:HKEY_CURRENT_USER\Software\GlobalSCAPE\CuteFTP 8 Professional\QCToolbar(或者直接通过注册表查找:QCToolbar或QCHistory);
3、删除QCHistory项即可,如图所示:
点击在新窗口中浏览此图片

LvQuan.com域名终结版

[不指定 2014/08/05 12:59 | by 吕进 | Via 本站原创 ]
真不想过LvQuan.com可以卖钱,从注册(2005年10月26日)到转让,差不多10年了。
LvQuan.com最初是在新网注册的,因解析受限且备案麻烦。一气之下,转到了name.com,当时还费了些周折(新网不肯转出)。
一直以来,欲收购LvQuan.com域名的人比较多,但一直没想过真卖。
今天,几点几不点,居然真的出手了,可惜啊,亏了500(比最低价)!

通过ADMIN5.net完成交易。

Excel宏代码:密码破解

[不指定 2014/07/05 10:07 | by 吕进 | Via 本站原创 ]
忘记对EXCEL加密的密码怎么办?可以用以下宏代码解决。
注意:破解后的文件需另存为——
Public Sub 工作表保护密码破解()
Const DBLSPACE As String = vbNewLine & vbNewLine
Const AUTHORS As String = DBLSPACE & vbNewLine & _
"作者:McCormick   JE McGimpsey "
Const HEADER As String = "工作表保护密码破解"
Const VERSION As String = DBLSPACE & "版本 Version 1.1.1"
Const REPBACK As String = DBLSPACE & ""
Const ZHENGLI As String = DBLSPACE & "JOBSH整理"
Const ALLCLEAR As String = DBLSPACE & "该工作簿中的工作表密码保护已全部解除!!" & DBLSPACE & "请记得另保存" _
& DBLSPACE & "注意:不要用在不当地方!"
Const MSGNOPWORDS1 As String = "该文件工作表中没有加密"
Const MSGNOPWORDS2 As String = "该文件工作表中没有加密2"
Const MSGTAKETIME As String = "解密需花费一定时间,请耐心等候!" & DBLSPACE & "按确定开始破解!"
Const MSGPWORDFOUND1 As String = "密码重新组合为:" & DBLSPACE & "$$" & DBLSPACE & _
"如果该文件工作表有不同密码,将搜索下一组密码并修改清除"
Const MSGPWORDFOUND2 As String = "密码重新组合为:" & DBLSPACE & "$$" & DBLSPACE & _
"如果该文件工作表有不同密码,将搜索下一组密码并解除"
Const MSGONLYONE As String = "确保为唯一的?"
Dim w1 As Worksheet, w2 As Worksheet
Dim i As Integer, j As Integer, k As Integer, l As Integer
Dim m As Integer, n As Integer, i1 As Integer, i2 As Integer
Dim i3 As Integer, i4 As Integer, i5 As Integer, i6 As Integer
Dim PWord1 As String
Dim ShTag As Boolean, WinTag As Boolean
Application.ScreenUpdating = False
With ActiveWorkbook
WinTag = .ProtectStructure Or .ProtectWindows
End With
ShTag = False
For Each w1 In Worksheets
ShTag = ShTag Or w1.ProtectContents
Next w1
If Not ShTag And Not WinTag Then
MsgBox MSGNOPWORDS1, vbInformation, HEADER
Exit Sub
End If
MsgBox MSGTAKETIME, vbInformation, HEADER
If Not WinTag Then
Else
On Error Resume Next
Do 'dummy do loop
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
With ActiveWorkbook
.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If .ProtectStructure = False And _
.ProtectWindows = False Then
PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _
Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
MsgBox Application.Substitute(MSGPWORDFOUND1, _
"$$", PWord1), vbInformation, HEADER
Exit Do 'Bypass all for...nexts
End If
End With
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
Loop Until True
On Error GoTo 0
End If
If WinTag And Not ShTag Then
MsgBox MSGONLYONE, vbInformation, HEADER
Exit Sub
End If
On Error Resume Next
For Each w1 In Worksheets
'Attempt clearance with PWord1
w1.Unprotect PWord1
Next w1
On Error GoTo 0
ShTag = False
For Each w1 In Worksheets
'Checks for all clear ShTag triggered to 1 if not.
ShTag = ShTag Or w1.ProtectContents
Next w1
If ShTag Then
For Each w1 In Worksheets
With w1
If .ProtectContents Then
On Error Resume Next
Do 'Dummy do loop
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If Not .ProtectContents Then
PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _
Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
MsgBox Application.Substitute(MSGPWORDFOUND2, _
"$$", PWord1), vbInformation, HEADER
'leverage finding Pword by trying on other sheets
For Each w2 In Worksheets
w2.Unprotect PWord1
Next w2
Exit Do 'Bypass all for...nexts
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
Loop Until True
On Error GoTo 0
End If
End With
Next w1
End If
MsgBox ALLCLEAR & AUTHORS & VERSION & REPBACK & ZHENGLI, vbInformation, HEADER
End Sub
分页: 7/135 第一页 上页 2 3 4 5 6 7 8 9 10 11 下页 最后页 [ 显示模式: 摘要 | 列表 ]