R mysql选择查询
SELECT column_names FROM table_name WHERE conditions
R mysql插入查询
INSERT into table_name (column1, column2) values (value1, value2)
R 来自mysql的php while语句关联数组
while($row = mysql_fetch_assoc($res)) {
}
Bash 自动添加当前目录中的所有新文件。
#!/bin/bash
if [ ! "$1" ]
then
1='.'
fi
echo "Processing $1"
svn add $1 `svn st $1 | grep '^?.*' | tr -d '? ' | sort -n | tr '\n' ' '`
Other TiVo导航快捷方式
From the TiVo Central screen (press the "TiVo" button to get there), press the following keys to jump to their respective functions:
* 0 = Show the TiVo cartoon introduction
* 1 = Season Pass Manager
* 2 = To Do List
* 3 = Search Using Wishlists
* 4 = Search by Title
* 5 = Browse by Channel
* 6 = Browse by Time
* 7 = Record Time/Channel
* 8 = TiVo's Suggestions
* 9 = Showcases
* TiVo = Now Playing
Other TiVo演员
##to undo, redo the given sequence or else reboot the TiVo
#display clock and elapsed track time
Select, Play, Select, 9, Select
#make the skip-ahead button into a 30-second skip button
Select, Play, Select, 3, 0, Select
#make the play bar go away faster
Select, Play, Select, Pause, Select
Groovy 全面的Maven 2存储库配置文件
<profile>
<id>extra-repos</id>
<repositories>
<repository>
<id>central</id>
<name>Maven Repository Switchboard</name>
<url>http://repo1.maven.org/maven2</url>
<releases>
<enabled>true</enabled>
<updatePolicy>interval:240</updatePolicy>
</releases>
<snapshots>
<enabled>true</enabled>
<updatePolicy>interval:240</updatePolicy>
</snapshots>
</repository>
<repository>
<id>maven2-repository.dev.java.net</id>
<name>Java.net Repository for Maven</name>
<url>http://download.java.net/maven/2</url>
<releases>
<enabled>true</enabled>
<updatePolicy>interval:240</updatePolicy>
</releases>
<snapshots>
<enabled>true</enabled>
<updatePolicy>interval:240</updatePolicy>
</snapshots>
</repository>
<repository>
<id>maven-repository.dev.java.net</id>
<url>
https://maven-repository.dev.java.net/nonav/repository
</url>
<layout>legacy</layout>
<releases>
<enabled>true</enabled>
</releases>
<snapshots>
<enabled>true</enabled>
</snapshots>
</repository>
<repository>
<id>ibiblio-public-repository</id>
<name>Ibiblio</name>
<url>http://www.ibiblio.org/maven2</url>
<releases>
<enabled>true</enabled>
<updatePolicy>interval:240</updatePolicy>
</releases>
<snapshots>
<enabled>true</enabled>
<updatePolicy>interval:240</updatePolicy>
</snapshots>
</repository>
<repository>
<id>codehaus-repo</id>
<name>CodeHaus Repository</name>
<url>http://repository.codehaus.org</url>
<releases>
<enabled>true</enabled>
<updatePolicy>interval:240</updatePolicy>
</releases>
<snapshots>
<enabled>true</enabled>
<updatePolicy>interval:240</updatePolicy>
</snapshots>
</repository>
<repository>
<id>apache-incubating</id>
<name>Apache M2 Incubating Repository</name>
<url>
http://people.apache.org/repo/m2-incubating-repository
</url>
<releases>
<enabled>true</enabled>
<updatePolicy>interval:240</updatePolicy>
</releases>
<snapshots>
<enabled>true</enabled>
<updatePolicy>interval:240</updatePolicy>
</snapshots>
</repository>
<repository>
<id>codehaus-snapshots</id>
<name>CodeHaus Snapshots Repository</name>
<url>http://snapshots.repository.codehaus.org</url>
<releases>
<enabled>true</enabled>
<updatePolicy>interval:240</updatePolicy>
</releases>
<snapshots>
<enabled>true</enabled>
<updatePolicy>interval:240</updatePolicy>
</snapshots>
</repository>
<repository>
<id>apache.snapshots</id>
<name>Maven Plugin Snapshots</name>
<url>
http://people.apache.org/maven-snapshot-repository
</url>
<releases>
<enabled>true</enabled>
<updatePolicy>interval:240</updatePolicy>
</releases>
<snapshots>
<enabled>true</enabled>
<updatePolicy>interval:240</updatePolicy>
</snapshots>
</repository>
<repository>
<id>ibiblio-mirror-m2</id>
<name>Ibiblio Mirror Maven 2</name>
<url>
http://mirrors.ibiblio.org/pub/mirrors/maven2
</url>
<releases>
<enabled>true</enabled>
<updatePolicy>interval:240</updatePolicy>
</releases>
<snapshots>
<enabled>true</enabled>
<updatePolicy>interval:240</updatePolicy>
</snapshots>
</repository>
<repository>
<id>jboss</id>
<url>http://repository.jboss.com/maven2</url>
<releases>
<enabled>true</enabled>
</releases>
<snapshots>
<enabled>false</enabled>
</snapshots>
</repository>
<repository>
<id>jboss-snapshot</id>
<url>http://snapshots.jboss.org/maven2</url>
<releases>
<enabled>true</enabled>
</releases>
<snapshots>
<enabled>true</enabled>
</snapshots>
</repository>
<repository>
<id>lunarlogic</id>
<url>
http://labs.lunarlogic.com/proximity/repository/lunarlogic
</url>
</repository>
<repository>
<id>jboss-repo</id>
<url>http://repository.jboss.org/maven2</url>
</repository>
</repositories>
<pluginRepositories>
<pluginRepository>
<id>maven2-repository.dev.java.net</id>
<url>
https://maven2-repository.dev.java.net/nonav/repository
</url>
<releases>
<enabled>true</enabled>
<updatePolicy>interval:240</updatePolicy>
</releases>
<snapshots>
<enabled>true</enabled>
<updatePolicy>interval:240</updatePolicy>
</snapshots>
</pluginRepository>
<pluginRepository>
<id>maven-repository.dev.java.net</id>
<url>
https://maven-repository.dev.java.net/nonav/repository
</url>
<layout>legacy</layout>
<releases>
<enabled>true</enabled>
<updatePolicy>interval:240</updatePolicy>
</releases>
<snapshots>
<enabled>true</enabled>
<updatePolicy>interval:240</updatePolicy>
</snapshots>
</pluginRepository>
<pluginRepository>
<id>codehaus.org</id>
<name>CodeHaus Plugin Snapshots</name>
<url>http://snapshots.repository.codehaus.org</url>
<releases>
<enabled>true</enabled>
<updatePolicy>interval:240</updatePolicy>
</releases>
<snapshots>
<enabled>true</enabled>
<updatePolicy>interval:240</updatePolicy>
</snapshots>
</pluginRepository>
<pluginRepository>
<id>apache.org</id>
<name>Maven Plugin Snapshots</name>
<url>
http://people.apache.org/maven-snapshot-repository
</url>
<releases>
<enabled>true</enabled>
<updatePolicy>interval:240</updatePolicy>
</releases>
<snapshots>
<enabled>true</enabled>
<updatePolicy>interval:240</updatePolicy>
</snapshots>
</pluginRepository>
<pluginRepository>
<id>central</id>
<name>Maven Plugin Repository</name>
<url>http://repo1.maven.org/maven2</url>
<releases>
<enabled>true</enabled>
<updatePolicy>interval:240</updatePolicy>
</releases>
<snapshots>
<enabled>true</enabled>
<updatePolicy>interval:240</updatePolicy>
</snapshots>
</pluginRepository>
<pluginRepository>
<id>codehaus.plugin.snapshots</id>
<name>CodeHaus Plugin Snapshots</name>
<url>
http://snapshots.maven.codehaus.org/maven2
</url>
<releases>
<enabled>true</enabled>
<updatePolicy>interval:240</updatePolicy>
</releases>
<snapshots>
<enabled>true</enabled>
<updatePolicy>interval:240</updatePolicy>
</snapshots>
</pluginRepository>
<pluginRepository>
<id>ibiblio-mirror-m2</id>
<name>Ibiblio Mirror Maven 2</name>
<url>
http://mirrors.ibiblio.org/pub/mirrors/maven2
</url>
<releases>
<enabled>true</enabled>
<updatePolicy>interval:240</updatePolicy>
</releases>
<snapshots>
<enabled>true</enabled>
<updatePolicy>interval:240</updatePolicy>
</snapshots>
</pluginRepository>
<pluginRepository>
<id>jboss-plugins</id>
<url>http://repository.jboss.com/maven2</url>
<releases>
<enabled>true</enabled>
</releases>
<snapshots>
<enabled>false</enabled>
</snapshots>
</pluginRepository>
<pluginRepository>
<id>jboss-snapshot-plugins</id>
<url>http://snapshots.jboss.org/maven2</url>
<releases>
<enabled>true</enabled>
</releases>
<snapshots>
<enabled>true</enabled>
</snapshots>
</pluginRepository>
</pluginRepositories>
</profile>
Ruby String.capitalize_each_word
class String
def capitalize_each_word
(self.split(' ').each {|w| w.capitalize! }).join(' ')
end
end
C# 将XmlNodeList转换为DataTable
public static DataTable ConvertXmlNodeListToDataTable(XmlNodeList xnl)
{
DataTable dt = new DataTable();
int TempColumn = 0;
foreach (XmlNode node in xnl.Item(0).ChildNodes)
{
TempColumn++;
DataColumn dc = new DataColumn(node.Name, System.Type.GetType("System.String"));
if (dt.Columns.Contains(node.Name))
{
dt.Columns.Add(dc.ColumnName = dc.ColumnName + TempColumn.ToString());
}
else
{
dt.Columns.Add(dc);
}
}
int ColumnsCount = dt.Columns.Count;
for (int i = 0; i < xnl.Count; i++)
{
DataRow dr = dt.NewRow();
for (int j = 0; j < ColumnsCount; j++)
{
dr[j] = xnl.Item(i).ChildNodes[j].InnerText;
}
dt.Rows.Add(dr);
}
return dt;
}
C# 从HTTP标头获取所有Cookie
public static CookieCollection GetAllCookiesFromHeader(string strHeader, string strHost)
{
ArrayList al = new ArrayList();
CookieCollection cc = new CookieCollection();
if (strHeader != string.Empty)
{
al = ConvertCookieHeaderToArrayList(strHeader);
cc = ConvertCookieArraysToCookieCollection(al, strHost);
}
return cc;
}
private static ArrayList ConvertCookieHeaderToArrayList(string strCookHeader)
{
strCookHeader = strCookHeader.Replace("\r", "");
strCookHeader = strCookHeader.Replace("\n", "");
string[] strCookTemp = strCookHeader.Split(',');
ArrayList al = new ArrayList();
int i = 0;
int n = strCookTemp.Length;
while (i < n)
{
if (strCookTemp[i].IndexOf("expires=", StringComparison.OrdinalIgnoreCase) > 0)
{
al.Add(strCookTemp[i] + "," + strCookTemp[i + 1]);
i = i + 1;
}
else
{
al.Add(strCookTemp[i]);
}
i = i + 1;
}
return al;
}
private static CookieCollection ConvertCookieArraysToCookieCollection(ArrayList al, string strHost)
{
CookieCollection cc = new CookieCollection();
int alcount = al.Count;
string strEachCook;
string[] strEachCookParts;
for (int i = 0; i < alcount; i++)
{
strEachCook = al[i].ToString();
strEachCookParts = strEachCook.Split(';');
int intEachCookPartsCount = strEachCookParts.Length;
string strCNameAndCValue = string.Empty;
string strPNameAndPValue = string.Empty;
string strDNameAndDValue = string.Empty;
string[] NameValuePairTemp;
Cookie cookTemp = new Cookie();
for (int j = 0; j < intEachCookPartsCount; j++)
{
if (j == 0)
{
strCNameAndCValue = strEachCookParts[j];
if (strCNameAndCValue != string.Empty)
{
int firstEqual = strCNameAndCValue.IndexOf("=");
string firstName = strCNameAndCValue.Substring(0, firstEqual);
string allValue = strCNameAndCValue.Substring(firstEqual + 1, strCNameAndCValue.Length - (firstEqual + 1));
cookTemp.Name = firstName;
cookTemp.Value = allValue;
}
continue;
}
if (strEachCookParts[j].IndexOf("path", StringComparison.OrdinalIgnoreCase) >= 0)
{
strPNameAndPValue = strEachCookParts[j];
if (strPNameAndPValue != string.Empty)
{
NameValuePairTemp = strPNameAndPValue.Split('=');
if (NameValuePairTemp[1] != string.Empty)
{
cookTemp.Path = NameValuePairTemp[1];
}
else
{
cookTemp.Path = "/";
}
}
continue;
}
if (strEachCookParts[j].IndexOf("domain", StringComparison.OrdinalIgnoreCase) >= 0)
{
strPNameAndPValue = strEachCookParts[j];
if (strPNameAndPValue != string.Empty)
{
NameValuePairTemp = strPNameAndPValue.Split('=');
if (NameValuePairTemp[1] != string.Empty)
{
cookTemp.Domain = NameValuePairTemp[1];
}
else
{
cookTemp.Domain = strHost;
}
}
continue;
}
}
if (cookTemp.Path == string.Empty)
{
cookTemp.Path = "/";
}
if (cookTemp.Domain == string.Empty)
{
cookTemp.Domain = strHost;
}
cc.Add(cookTemp);
}
return cc;
}