prettyprint

  1 <!DOCTYPE html>
  2 <html xmlns="http://www.w3.org/1999/xhtml">
  3 <head>
  4     <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  5     <title>Prettify</title>
  6     <link href="prettify.min.css" rel="stylesheet">
  7     <script src="prettify.min.js"></script>
  8     <style>
  9         pre.prettyprint
 10         {
 11             border: 2px dashed #888;
 12             background: #ddd;
 13         }
 14     </style>
 15     <script>
 16         window.onload = function ()
 17         {
 18             // Load Prettify
 19             prettyPrint();
 20         }
 21     </script>
 22 </head>
 23 <body>
 24 <pre class="prettyprint lang-java">
 25     // 异步方式
 26     // 结果以事件回调方式返回
 27     Command command = new Command("/system/bin/ping",
 28             "-c", "4", "-s", "100",
 29             "www.baidu.com");
 30     Command.command(command, new Command.CommandListener() {
 31         @Override
 32         public void onCompleted(String str) {
 33             Log.i(TAG, "onCompleted：
" + str);
 34         }
 35         @Override
 36         public void onCancel() {
 37             Log.i(TAG, "onCancel");
 38         }
 39         @Override
 40         public void onError() {
 41             Log.i(TAG, "onError");
 42         }
 43     });
 44 </pre>
 45 <pre class="prettyprint lang-C#">
 46 using System;
 47 using System.Collections;
 48 using System.Collections.Generic;
 49 using System.Configuration;
 50 using System.Data;
 51 using System.Data.SqlClient;
 52 using System.Linq;
 53 using System.Text;
 54 
 55 namespace Justin.FrameWork.Helper
 56 {
 57     /// <summary>
 58     /// Sql访问数据库帮助类
 59     /// </summary>
 60     public abstract class SqlHelper
 61     {
 62 
 63         /// <summary>
 64         /// 如"data source=.;initial catalog=PrivilegeDB;integrated security=True;multipleactiveresultsets=True;"
 65         /// </summary>
 66         public static string ConnStr = "";
 67         public static int CommandTimeout = 600;
 68 
 69         private static Hashtable parmCache = Hashtable.Synchronized(new Hashtable());
 70 
 71         public static int ExecuteNonQuery(string connectionString, CommandType cmdType, string cmdText, params SqlParameter[] commandParameters)
 72         {
 73             SqlCommand cmd = new SqlCommand();
 74             using (SqlConnection connection = new SqlConnection(connectionString))
 75             {
 76                 PrepareCommand(cmd, connection, null, cmdType, cmdText, commandParameters);
 77                 int val = cmd.ExecuteNonQuery();
 78                 cmd.Parameters.Clear();
 79                 return val;
 80             }
 81         }
 82         public static int ExecuteNonQuery(SqlConnection connection, CommandType cmdType, string cmdText, params SqlParameter[] commandParameters)
 83         {
 84             SqlCommand cmd = new SqlCommand();
 85             PrepareCommand(cmd, connection, null, cmdType, cmdText, commandParameters);
 86             int val = cmd.ExecuteNonQuery();
 87             cmd.Parameters.Clear();
 88             return val;
 89         }
 90         public static int ExecuteNonQuery(SqlTransaction trans, CommandType cmdType, string cmdText, params SqlParameter[] commandParameters)
 91         {
 92             SqlCommand cmd = new SqlCommand();
 93             cmd.CommandTimeout = 600;
 94             PrepareCommand(cmd, trans.Connection, trans, cmdType, cmdText, commandParameters);
 95             int val = cmd.ExecuteNonQuery();
 96             cmd.Parameters.Clear();
 97             return val;
 98         }
 99 
100         public static SqlDataReader ExecuteReader(SqlConnection connection, CommandType cmdType, string cmdText, params SqlParameter[] commandParameters)
101         {
102             SqlCommand cmd = new SqlCommand();
103             try
104             {
105                 PrepareCommand(cmd, connection, null, cmdType, cmdText, commandParameters);
106                 SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
107                 cmd.Parameters.Clear();
108                 return rdr;
109             }
110 
111             catch
112             {
113                 connection.Close();
114                 throw;
115             }
116         }
117         public static object ExecuteScalar(string connectionString, CommandType cmdType, string cmdText, params SqlParameter[] commandParameters)
118         {
119             SqlCommand cmd = new SqlCommand();
120             using (SqlConnection connection = new SqlConnection(connectionString))
121             {
122                 PrepareCommand(cmd, connection, null, cmdType, cmdText, commandParameters);
123                 object val = cmd.ExecuteScalar();
124                 cmd.Parameters.Clear();
125                 return val;
126             }
127 
128         }
129         public static object ExecuteScalar(SqlConnection connection, CommandType cmdType, string cmdText, params SqlParameter[] commandParameters)
130         {
131             SqlCommand cmd = new SqlCommand();
132             PrepareCommand(cmd, connection, null, cmdType, cmdText, commandParameters);
133             object val = cmd.ExecuteScalar();
134             cmd.Parameters.Clear();
135             return val;
136         }
137 
138         public static DataTable ExecuteDataTable(SqlConnection connection, CommandType cmdType, string cmdText, params SqlParameter[] commandParameters)
139         {
140 
141             SqlCommand cmd = new SqlCommand();
142             PrepareCommand(cmd, connection, null, cmdType, cmdText, commandParameters);
143             SqlDataAdapter MyAdapter = new SqlDataAdapter();
144             MyAdapter.SelectCommand = cmd;
145             DataSet ds = new DataSet();
146             MyAdapter.Fill(ds);
147             cmd.Parameters.Clear();
148             DataTable table = ds.Tables[0];
149             ds.Dispose();
150             return table;
151         }
152         public static DataTable ExecuteDataTable(string connectionString, CommandType cmdType, string cmdText, params SqlParameter[] commandParameters)
153         {
154             using (SqlConnection connection = new SqlConnection(connectionString))
155             {
156                 SqlCommand cmd = new SqlCommand();
157 
158                 try
159                 {
160                     PrepareCommand(cmd, connection, null, cmdType, cmdText, commandParameters);
161                     SqlDataAdapter MyAdapter = new SqlDataAdapter();
162                     MyAdapter.SelectCommand = cmd;
163                     DataSet ds = new DataSet();
164                     MyAdapter.Fill(ds);
165                     cmd.Parameters.Clear();
166                     DataTable table = ds.Tables[0];
167                     ds.Dispose();
168                     connection.Close();
169                     return table;
170                 }
171                 catch
172                 {
173                     connection.Close();
174                     throw;
175                 }
176             }
177         }
178 
179 
180         public static void CacheParameters(string cacheKey, params SqlParameter[] commandParameters)
181         {
182             parmCache[cacheKey] = commandParameters;
183         }
184         public static SqlParameter[] GetCachedParameters(string cacheKey)
185         {
186 
187             SqlParameter[] cachedParms = (SqlParameter[])parmCache[cacheKey];
188             if (cachedParms == null)
189                 return null;
190             SqlParameter[] clonedParms = new SqlParameter[cachedParms.Length];
191             for (int i = 0, j = cachedParms.Length; i < j; i++)
192                 clonedParms[i] = (SqlParameter)((ICloneable)cachedParms[i]).Clone();
193             return clonedParms;
194         }
195         private static void PrepareCommand(SqlCommand cmd, SqlConnection connection, SqlTransaction trans, CommandType cmdType, string cmdText, SqlParameter[] cmdParms)
196         {
197             if (connection.State != ConnectionState.Open)
198                 connection.Open();
199             cmd.Connection = connection;
200             cmd.CommandText = cmdText;
201             cmd.CommandTimeout = CommandTimeout;
202             if (trans != null)
203                 cmd.Transaction = trans;
204             cmd.CommandType = cmdType;
205             if (cmdParms != null)
206             {
207                 foreach (SqlParameter parm in cmdParms)
208                     cmd.Parameters.Add(parm);
209 
210             }
211 
212         }
213 
214 
215         public static SqlConnection GetConnection(string connectionString)
216         {
217             return new SqlConnection(connectionString);
218         }
219     }
220 }
221 
222 
223 </pre>
224 </body>
225 </html>