如果您对织梦(今日更新等)经常用到的统计代码SQL调用语句和织梦系统基本参数感兴趣，那么这篇文章一定是您不可错过的。我们将详细讲解织梦(今日更新等)经常用到的统计代码SQL调用语句的各种细节，并对织梦

如果您对织梦(今日更新等)经常用到的统计代码SQL调用语句和织梦系统基本参数感兴趣，那么这篇文章一定是您不可错过的。我们将详细讲解织梦(今日更新等)经常用到的统计代码SQL调用语句的各种细节，并对织梦系统基本参数进行深入的分析，此外还有关于40个经常用到的java代码块、asp下经常用到的代码、C#程序员经常用到的10个实用代码片段、Dede(织梦)sql调用之代码大全的实用技巧。

• 织梦(今日更新等)经常用到的统计代码SQL调用语句（织梦系统基本参数）
• 40个经常用到的java代码块
• asp下经常用到的代码
• C#程序员经常用到的10个实用代码片段
• Dede(织梦)sql调用之代码大全

织梦(今日更新等)经常用到的统计代码SQL调用语句（织梦系统基本参数）

织梦CMS经常用到的内容统计代码SQL调用语句：

·共有新闻：多少篇

{dede:sql sql="select count(*) as c from idea_archives where channel=1"}·共有新闻：[field:c /]篇{/dede:sql}

·共有图集：多少个

{dede:sql sql="select count(*) as c from idea_archives where channel=2"}·共有图集：[field:c /]个{/dede:sql}

·共有软件：多少个

{dede:sql sql="select count(*) as c from idea_archives where channel=3"}·共有软件：[field:c /]个{/dede:sql}

·共有评论：多少条

{dede:sql sql="select count(*) as c from idea_feedback"}·共有评论：[field:c /]条{/dede:sql}

·共有会员：多少名

{dede:sql sql="select count(mid) as c from idea_member "}·共有会员：[field:c /]名{/dede:sql}

·新闻阅读：多少人次

{dede:sql sql="select sum(click) as c from idea_archives"}新闻阅读：[field:c /]人次{/dede:sql}

·今日更新：多少篇

{dede:sql sql="SELECT count( * ) AS c FROM idea_archives WHERE pubdate & gt; UNIX_TIMESTAMP( CURDATE( ) ) "}今日更新：[field:c /]篇{/dede:sql}

总共留言：{dede:sql sql="select count(*) as cc From idea_guestbook"}[field:cc/]{/dede:sql}条

40个经常用到的java代码块

下面是20个非常有用的Java程序片段，期望能对你有用。

1. 字符串有整型的相互转换

1
2
String a = String.valueOf(2); //integer to numeric string
int i = Integer.parseInt(a);//numeric string to an int

2. 向文件末尾添加内容

1
2
3
4
5
6
7
8
9
10
11
BufferedWriter out =null;
try {

out =new BufferedWriter(new FileWriter(”filename”,true)); 
out.write(”aString”); 

}catch (IOException e) {

// error processing code 

}finally {

if (out !=null) { 
    out.close(); 
} 

}

3. 得到当前办法的名字

1
String methodName = Thread.currentThread().getStackTrace()[1].getMethodName();

4. 转字符串到日期

1
java.util.Date = java.text.DateFormat.getDateInstance().parse(date String);
或者是：

1
2
SimpleDateFormat format =new SimpleDateFormat("dd.MM.yyyy" );
Date date = format.parse( myString );

5. 运用JDBC链接Oracle

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
public class OracleJdbcTest
{

String driver; 

Connection con; 

public void init(FileInputStream fs)throws ClassNotFoundException, SQLException, FileNotFoundException, IOException 
{ 
    Properties props =new Properties(); 
    props.load(fs); 
    String url = props.getProperty("db.url"); 
    String userName = props.getProperty("db.user"); 
    String password = props.getProperty("db.password"); 
    Class.forName(driverClass); 

    con=DriverManager.getConnection(url, userName, password); 
} 

public void fetch()throws SQLException, IOException 
{ 
    PreparedStatement ps = con.prepareStatement("select SYSDATE from dual"); 
    ResultSet rs = ps.executeQuery(); 

    while (rs.next()) 
    { 
        // do the thing you do 
    } 
    rs.close(); 
    ps.close(); 
} 

public static void main(String[] args) 
{ 
    OracleJdbcTest test =new OracleJdbcTest(); 
    test.init(); 
    test.fetch(); 
} 

}

6. 把 Java util.Date 转成 sql.Date

1
2
java.util.Date utilDate =new java.util.Date();
java.sql.Date sqlDate =new java.sql.Date(utilDate.getTime());

7. 运用NIO进行快速的文件复制

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
public static void fileCopy( File in, File out )

        throws IOException 
{ 
    FileChannel inChannel =new FileInputStream( in ).getChannel(); 
    FileChannel outChannel =new FileOutputStream( out ).getChannel(); 
    try
    { 

// inChannel.transferTo(0, inChannel.size(), outChannel); // original -- apparently has trouble copying large files on Windows

        // magic number for Windows, 64Mb - 32Kb) 
        int maxCount = (64 *1024 *1024) - (32 *1024); 
        long size = inChannel.size(); 
        long position =0; 
        while ( position < size ) 
        { 
           position += inChannel.transferTo( position, maxCount, outChannel ); 
        } 
    } 
    finally
    { 
        if ( inChannel !=null ) 
        { 
           inChannel.close(); 
        } 
        if ( outChannel !=null ) 
        { 
            outChannel.close(); 
        } 
    } 
}

8. 创立图片的缩略图

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
private void createThumbnail(String filename,int thumbWidth,int thumbHeight,int quality, String outFilename)

    throws InterruptedException, FileNotFoundException, IOException 
{ 
    // load image from filename 
    Image image = Toolkit.getDefaultToolkit().getImage(filename); 
    MediaTracker mediaTracker =new MediaTracker(new Container()); 
    mediaTracker.addImage(image,0); 
    mediaTracker.waitForID(0); 
    // use this to test for errors at this point: System.out.println(mediaTracker.isErrorAny()); 

    // determine thumbnail size from WIDTH and HEIGHT 
    double thumbRatio = (double)thumbWidth / (double)thumbHeight; 
    int imageWidth = image.getWidth(null); 
    int imageHeight = image.getHeight(null); 
    double imageRatio = (double)imageWidth / (double)imageHeight; 
    if (thumbRatio < imageRatio) { 
        thumbHeight = (int)(thumbWidth / imageRatio); 
    }else { 
        thumbWidth = (int)(thumbHeight * imageRatio); 
    } 

    // draw original image to thumbnail image object and 
    // scale it to the new size on-the-fly 
    BufferedImage thumbImage =new BufferedImage(thumbWidth, thumbHeight, BufferedImage.TYPE_INT_RGB); 
    Graphics2D graphics2D = thumbImage.createGraphics(); 
    graphics2D.setRenderingHint(RenderingHints.KEY_INTERPOLATION, RenderingHints.VALUE_INTERPOLATION_BILINEAR); 
    graphics2D.drawImage(image,0,0, thumbWidth, thumbHeight,null); 

    // save thumbnail image to outFilename 
    BufferedOutputStream out =new BufferedOutputStream(new FileOutputStream(outFilename)); 
    JPEGImageEncoder encoder = JPEGCodec.createJPEGEncoder(out); 
    JPEGEncodeParam param = encoder.getDefaultJPEGEncodeParam(thumbImage); 
    quality = Math.max(0, Math.min(quality,100)); 
    param.setQuality((float)quality /100.0f,false); 
    encoder.setJPEGEncodeParam(param); 
    encoder.encode(thumbImage); 
    out.close(); 
}

9. 创立 JSON 格局的数据

请先阅览这篇文章 了解一些细节，

并下面这个JAR 文件：json-rpc-1.0.jar (75 kb)

1
2
3
4
5
6
7
8
9
import org.json.JSONObject;
...
...
JSONObject json =new JSONObject();
json.put("city","Mumbai");
json.put("country","India");
...
String output = json.toString();
...

10. 运用iText JAR生成PDF

阅览这篇文章 了解更多细节

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
import java.io.File;
import java.io.FileOutputStream;
import java.io.OutputStream;
import java.util.Date;

import com.lowagie.text.Document;
import com.lowagie.text.Paragraph;
import com.lowagie.text.pdf.PdfWriter;

public class GeneratePDF {

public static void main(String[] args) { 
    try { 
        OutputStream file =new FileOutputStream(new File("C:\\Test.pdf")); 

        Document document =new Document(); 
        PdfWriter.getInstance(document, file); 
        document.open(); 
        document.add(new Paragraph("Hello Kiran")); 
        document.add(new Paragraph(new Date().toString())); 

        document.close(); 
        file.close(); 

    }catch (Exception e) { 

        e.printStackTrace(); 
    } 
} 

}

11. HTTP 署理设置

阅览这篇 文章 了解更多细节。

1
2
3
4
System.getProperties().put("http.proxyHost","someProxyURL");
System.getProperties().put("http.proxyPort","someProxyPort");
System.getProperties().put("http.proxyUser","someUserName");
System.getProperties().put("http.proxyPassword","somePassword");

12. 单实例Singleton 示例

请先阅览这篇文章 了解更多信息

1
2
3
4
5
6
7
8
9
10
11
12
13
14
public class SimpleSingleton {

private static SimpleSingleton singleInstance = new SimpleSingleton(); 

//Marking default constructor private 
//to avoid direct instantiation. 
private SimpleSingleton() { 
} 

//Get instance for class SimpleSingleton 
public static SimpleSingleton getInstance() { 

    return singleInstance; 
} 

}
另一种完成

1
2
3
4
5
6
7
8
public enum SimpleSingleton {

INSTANCE; 
public void doSomething() { 
} 

}

//Call the method from Singleton:
SimpleSingleton.INSTANCE.doSomething();

13. 抓屏程序

阅览这篇文章 获得更多信息。

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
import java.awt.Dimension;
import java.awt.Rectangle;
import java.awt.Robot;
import java.awt.Toolkit;
import java.awt.image.BufferedImage;
import javax.imageio.ImageIO;
import java.io.File;

...

public void captureScreen(String fileName)throws Exception {

Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
Rectangle screenRectangle =new Rectangle(screenSize);
Robot robot =new Robot();
BufferedImage image = robot.createScreenCapture(screenRectangle);
ImageIO.write(image,"png",new File(fileName));

}
...

14. 列出文件和目录

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
File dir =new File("directoryName");
String[] children = dir.list();
if (children ==null) {

  // Either dir does not exist or is not a directory 

}else {

  for (int i=0; i < children.length; i++) { 
      // Get filename of file or directory 
      String filename = children[i]; 
  } 

}

// It is also possible to filter the list of returned files.
// This example does not return any files that start with `.''.
FilenameFilter filter =new FilenameFilter() {

  public boolean accept(File dir, String name) { 
      return !name.startsWith("."); 
  } 

};
children = dir.list(filter);

// The list of files can also be retrieved as File objects
File[] files = dir.listFiles();

// This filter only returns directories
FileFilter fileFilter =new FileFilter() {

  public boolean accept(File file) { 
      return file.isDirectory(); 
  } 

};
files = dir.listFiles(fileFilter);

15. 创立ZIP和JAR文件

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
import java.util.zip.*;
import java.io.*;

public class ZipIt {

public static void main(String args[])throws IOException { 
    if (args.length <2) { 
        System.err.println("usage: java ZipIt Zip.zip file1 file2 file3"); 
        System.exit(-1); 
    } 
    File zipFile =new File(args[0]); 
    if (zipFile.exists()) { 
        System.err.println("Zip file already exists, please try another"); 
        System.exit(-2); 
    } 
    FileOutputStream fos =new FileOutputStream(zipFile); 
    ZipOutputStream zos =new ZipOutputStream(fos); 
    int bytesRead; 
    byte[] buffer =new byte[1024]; 
    CRC32 crc =new CRC32(); 
    for (int i=1, n=args.length; i < n; i++) { 
        String name = args[i]; 
        File file =new File(name); 
        if (!file.exists()) { 
            System.err.println("Skipping: " + name); 
            continue; 
        } 
        BufferedInputStream bis =new BufferedInputStream( 
            new FileInputStream(file)); 
        crc.reset(); 
        while ((bytesRead = bis.read(buffer)) != -1) { 
            crc.update(buffer,0, bytesRead); 
        } 
        bis.close(); 
        // Reset to beginning of input stream 
        bis =new BufferedInputStream( 
            new FileInputStream(file)); 
        ZipEntry entry =new ZipEntry(name); 
        entry.setMethod(ZipEntry.STORED); 
        entry.setCompressedSize(file.length()); 
        entry.setSize(file.length()); 
        entry.setCrc(crc.getValue()); 
        zos.putNextEntry(entry); 
        while ((bytesRead = bis.read(buffer)) != -1) { 
            zos.write(buffer,0, bytesRead); 
        } 
        bis.close(); 
    } 
    zos.close(); 
} 

}

16. 解析/读取XML 文件

XML文件

    John
    B
    12


    Mary
    A
    11


    Simon
    A
    18

Java代码

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
package net.viralpatel.java.xmlparser;

import java.io.File;
import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;

import org.w3c.dom.Document;
import org.w3c.dom.Element;
import org.w3c.dom.Node;
import org.w3c.dom.NodeList;

public class XMLParser {

public void getAllUserNames(String fileName) { 
    try { 
        DocumentBuilderFactory dbf = DocumentBuilderFactory.newInstance(); 
        DocumentBuilder db = dbf.newDocumentBuilder(); 
        File file =new File(fileName); 
        if (file.exists()) { 
            Document doc = db.parse(file); 
            Element docEle = doc.getDocumentElement(); 

            // Print root element of the document 
            System.out.println("Root element of the document: "
                    + docEle.getNodeName()); 

            NodeList studentList = docEle.getElementsByTagName("student"); 

            // Print total student elements in document 
            System.out 
                    .println("Total students: " + studentList.getLength()); 

            if (studentList !=null && studentList.getLength() >0) { 
                for (int i =0; i < studentList.getLength(); i++) { 

                    Node node = studentList.item(i); 

                    if (node.getNodeType() == Node.ELEMENT_NODE) { 

                        System.out 
                                .println("====================="); 

                        Element e = (Element) node; 
                        NodeList nodeList = e.getElementsByTagName("name"); 
                        System.out.println("Name: "
                                + nodeList.item(0).getChildNodes().item(0) 
                                        .getNodeValue()); 

                        nodeList = e.getElementsByTagName("grade"); 
                        System.out.println("Grade: "
                                + nodeList.item(0).getChildNodes().item(0) 
                                        .getNodeValue()); 

                        nodeList = e.getElementsByTagName("age"); 
                        System.out.println("Age: "
                                + nodeList.item(0).getChildNodes().item(0) 
                                        .getNodeValue()); 
                    } 
                } 
            }else { 
                System.exit(1); 
            } 
        } 
    }catch (Exception e) { 
        System.out.println(e); 
    } 
} 
public static void main(String[] args) { 

    XMLParser parser =new XMLParser(); 
    parser.getAllUserNames("c:\\test.xml"); 
} 

}

17. 把 Array 转换成 Map

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
import java.util.Map;
import org.apache.commons.lang.ArrayUtils;

public class Main {

public static void main(String[] args) {

String[][] countries = { {"United States","New York" }, {"United Kingdom","London" }, 
    {"Netherland","Amsterdam" }, {"Japan","Tokyo" }, {"France","Paris" } }; 

Map countryCapitals = ArrayUtils.toMap(countries); 

System.out.println("Capital of Japan is " + countryCapitals.get("Japan")); 
System.out.println("Capital of France is " + countryCapitals.get("France")); 

}
}

18. 发送邮件

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
import javax.mail.*;
import javax.mail.internet.*;
import java.util.*;

public void postMail( String recipients[ ], String subject, String message , String from)throws MessagingException
{

boolean debug =false; 

 //Set the host smtp address 
 Properties props =new Properties(); 
 props.put("mail.smtp.host","smtp.example.com"); 

// create some properties and get the default Session 
Session session = Session.getDefaultInstance(props,null); 
session.setDebug(debug); 

// create a message 
Message msg =new MimeMessage(session); 

// set the from and to address 
InternetAddress addressFrom =new InternetAddress(from); 
msg.setFrom(addressFrom); 

InternetAddress[] addressTo =new InternetAddress[recipients.length]; 
for (int i =0; i < recipients.length; i++) 
{ 
    addressTo[i] =new InternetAddress(recipients[i]); 
} 
msg.setRecipients(Message.RecipientType.TO, addressTo); 

// Optional : You can also set your custom headers in the Email if you Want 
msg.addHeader("MyHeaderName","myHeaderValue"); 

// Setting the Subject and Content Type 
msg.setSubject(subject); 
msg.setContent(message,"text/plain"); 
Transport.send(msg); 

}

19. 发送代数据的HTTP 恳求

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.net.URL;

public class Main {

public static void main(String[] args)  { 
    try { 
        URL my_url =new URL("http://coolshell.cn/"); 
        BufferedReader br =new BufferedReader(new InputStreamReader(my_url.openStream())); 
        String strTemp =""; 
        while(null != (strTemp = br.readLine())){ 
        System.out.println(strTemp); 
    } 
    }catch (Exception ex) { 
        ex.printStackTrace(); 
    } 
} 

}

asp下经常用到的代码

C#程序员经常用到的10个实用代码片段

OperatingSystem os = System.Environment.OSVersion;
Console.WriteLine(“Platform: {0}”, os.Platform);
Console.WriteLine(“Service Pack: {0}”, os.ServicePack);
Console.WriteLine(“Version: {0}”, os.Version);
Console.WriteLine(“VersionString: {0}”, os.VersionString);
Console.WriteLine(“CLR Version: {0}”, System.Environment.Version);

private static UInt32 CountPhysicalProcessors()
{
     ManagementObjectSearcher objects = new ManagementObjectSearcher(
        “SELECT * FROM Win32_ComputerSystem”);
     ManagementObjectCollection coll = objects.Get();
     foreach(ManagementObject obj in coll)
    {
        return (UInt32)obj[“NumberOfProcessors”];
    } 
    return 0;
}
private static UInt64 CountPhysicalMemory()
{
   ManagementObjectSearcher objects =new ManagementObjectSearcher(
      “SELECT * FROM Win32_PhysicalMemory”);
   ManagementObjectCollection coll = objects.Get();
   UInt64 total = 0;
   foreach (ManagementObject obj in coll)
   {
       total += (UInt64)obj[“Capacity”];
    }
    return total;
}

Console.WriteLine(“Machine: {0}”, Environment.MachineName);
Console.WriteLine(“# of processors (logical): {0}”, Environment.ProcessorCount);
Console.WriteLine(“# of processors (physical): {0}”  CountPhysicalProcessors());
Console.WriteLine(“RAM installed: {0:N0} bytes”,  CountPhysicalMemory());
Console.WriteLine(“Is OS 64-bit? {0}”,   Environment.Is64BitOperatingSystem);
Console.WriteLine(“Is process 64-bit? {0}”,  Environment.Is64BitProcess);
Console.WriteLine(“Little-endian: {0}”, BitConverter.IsLittleEndian);
foreach (Screen screen in  System.Windows.Forms.Screen.AllScreens)
{
     Console.WriteLine(“Screen {0}”, screen.DeviceName);
     Console.WriteLine(“\tPrimary {0}”, screen.Primary);
     Console.WriteLine(“\tBounds: {0}”, screen.Bounds);
     Console.WriteLine(“\tWorking Area: {0}”,screen.WorkingArea);
     Console.WriteLine(“\tBitsPerPixel: {0}”,screen.BitsPerPixel);
}

using (RegistryKey keyRun = Registry.LocalMachine.OpenSubKey(@”Software\Microsoft\Windows\CurrentVersion\Run”))
{
    foreach (string valueName in keyRun.GetValueNames())
    {
     Console.WriteLine(“Name: {0}\tValue: {1}”, valueName, keyRun.GetValue(valueName));
    }
}

ServiceController controller = new ServiceController(“e-M-POWER”);      
controller.Start();      
if (controller.CanPauseAndContinue)      
{      
    controller.Pause();      
    controller.Continue();      
}      
controller.Stop();

if (args[0] == "/i")
 {
       ManagedInstallerClass.InstallHelper(new string[] { Assembly.GetExecutingAssembly().Location });
 }
 else if (args[0] == "/u")
 {
   ManagedInstallerClass.InstallHelper(new string[] { "/u", Assembly.GetExecutingAssembly().Location });
 }

[DllImport("mscoree.dll", CharSet=CharSet.Unicode)]
static extern bool StrongNameSignatureVerificationEx(string wszFilePath, bool fForceVerification, ref bool  pfWasVerified);
bool notForced = false;
bool verified = StrongNameSignatureVerificationEx(assembly, false, ref notForced);
Console.WriteLine("Verified: {0}\nForced: {1}", verified, !notForced);

Microsoft.WindowsAPICodePack.Dialogs.CommonOpenFileDialog ofd = new  Microsoft.WindowsAPICodePack.Dialogs.CommonOpenFileDialog();
ofd.AddToMostRecentlyUsedList = true;
ofd.IsFolderPicker = true;
ofd.AllowNonFileSystemItems = true;
ofd.ShowDialog();

long available = GC.GetTotalMemory(false);
Console.WriteLine(“Before allocations: {0:N0}”, available);
int allocSize = 40000000;
byte[] bigArray = new byte[allocSize];
available = GC.GetTotalMemory(false);
Console.WriteLine(“After allocations: {0:N0}”, available);

Before allocations: 651,064
After allocations: 40,690,080

Process proc = Process.GetCurrentProcess();
Console.WriteLine(“Process Info: “+Environment.NewLine+

“Private Memory Size: {0:N0}”+Environment.NewLine +
“Virtual Memory Size: {1:N0}” + Environment.NewLine +

“Working Set Size: {2:N0}” + Environment.NewLine +
“Paged Memory Size: {3:N0}” + Environment.NewLine +
“Paged System Memory Size: {4:N0}” + Environment.NewLine +

“Non-paged System Memory Size: {5:N0}” + Environment.NewLine,
proc.PrivateMemorySize64,   proc.VirtualMemorySize64,  proc.WorkingSet64,  proc.PagedMemorySize64, proc.PagedSystemMemorySize64,  proc.NonpagedSystemMemorySize64 );

System.Diagnostics.Stopwatch timer = new System.Diagnostics.Stopwatch();
timer.Start();
Decimal total = 0;
int limit = 1000000;
for (int i = 0; i < limit; ++i)
{
      total = total + (Decimal)Math.Sqrt(i);
}
timer.Stop();
Console.WriteLine(“Sum of sqrts: {0}”,total);
Console.WriteLine(“Elapsed milliseconds: {0}”,
timer.ElapsedMilliseconds);
Console.WriteLine(“Elapsed time: {0}”, timer.Elapsed);

class AutoStopwatch : System.Diagnostics.Stopwatch, IDisposable
{
   public AutoStopwatch()
   { 
       Start();
   }
   public void Dispose()
   {
       Stop();
       Console.WriteLine(“Elapsed: {0}”, this.Elapsed);
   }
}

using (new AutoStopwatch())
{
    Decimal total2 = 0;
    int limit2 = 1000000;
    for (int i = 0; i < limit2; ++i)
    {
       total2 = total2 + (Decimal)Math.Sqrt(i);
    }
}

class AutoWaitCursor : IDisposable
{
private Control _target;
private Cursor _prevCursor = Cursors.Default;
public AutoWaitCursor(Control control)
{
   if (control == null)
   {
     throw new ArgumentNullException(“control”);
   }
   _target = control;
   _prevCursor = _target.Cursor;
   _target.Cursor = Cursors.WaitCursor;
}
public void Dispose()
{
   _target.Cursor = _prevCursor;
}
}

using (new AutoWaitCursor(this))
{
...
throw new Exception();
}

	

		{dede:sql sql='select  字段 From 数据库名.表名称 where 条件语句'}

		[field:字段名/]

		{/dede:sql}

	

		{dede:sql sql='select  * From dede_archives where typeid=1 limit 10'}

		PHP?aid=[field:id/]">[field:title/]
		{/dede:sql}

		说明：如果是在相同数据库内不需要加数据库名称，否则就要在表名称前面加"数据库名."，比如“Dedecms.dede_archives”;如果不指定调用哪个栏目的文章则去掉“where typeid=1”；如果调用多个栏目的文章则代码格式为“where typeid='1' or typeid='2'   ”；用order by id desc 可以设列表排序，by id表示按id从大到小排列，这个语句用的时候加在 表名称后面， limit 10表示调用最新的10条文档，可以自由设定调用的数量。

	

		{dede:sql sql="SELECT * FROM dede_archives limit 10"}

		etoneArchive($id);@me=$url['arcurl'];[/field:id]'  title="[field:title/]" target="_blank">[field:title function=cn_substr(@me,30,0)/]sql}

	

		{dede:sql sql='Select * from dede_ask where status=1 order by id desc limit 0,3'}

		PHP?id=[field:id/]">[field:title function="cn_substr(@me,10)"/]
		[field:content function="cn_substr(@me,10)"/]…

		{/dede:sql}

		 

	

		{dede:sql sql='Select q.id,q.title,a.askid,a.ifanswer,a.content from dede_ask as q,dede_askanswer as a where q.status=1 and a.ifanswer=1 and q.id=a.askid and q.bestanswer=a.id order by q.id desc limit 0,3'}

		PHP?id=[field:id/]">[field:title function="cn_substr(@me,10)"/]
		
		{/dede:sql}

	

		 {dede:sql sql="select count(*) as c from dede_archives where channel=1"}·共有文章：[field:c /]篇{/dede:sql}

	

		{dede:sql sql="select count(*) as c from dede_archives where channel=2"}·共有图集：[field:c /]个{/dede:sql}

	

		{dede:sql sql="select count(*) as c from dede_archives where channel=3"}·共有软件：[field:c /]个{/dede:sql}

	

		{dede:sql sql="select count(*) as c from dede_Feedback"}·共有评论：[field:c /]条{/dede:sql}

	

		{dede:sql sql="select count(mid) as c from dede_member "}·共有会员：[field:c /]名{/dede:sql}

	

		{dede:sql sql="select sum(click) as c from dede_archives"}文章阅读：[field:c /]人次{/dede:sql}

	

		{dede:sql sql="SELECT count( * ) AS c FROM dede_archives WHERE pubdate > UNIX_TIMESTAMP( CURDATE( ) ) "}今日更新：[field:c /]篇{/dede:sql}

	

		{dede:sql sql="select count(*) as cc From dede_guestbook"}[field:cc/]{/dede:sql}条

	

		{dede:sql sql='Select * from dede_archives where mid=1'}

		PHP?aid=[field:id/]" target="_blank" >[field:title="" ]<="" a>
		{/dede:sql}