1、sql server中从表中随机取出n条记录
select top n * from table order by newid()
2、oralce中从表中随机取出n条记录
select * from (select table .*,dbms_random.random num from table order by num)
where rownum<=n
转换
public static string Display(this string s)
{
string restr = "";
string[] strs = s.Split(new char[]{' '});
for (int i = 0; i < strs.Length; i++)
{
restr = restr + strs[i].Substring(0, 1).ToUpper() + strs[i].Substring(1);
}
return restr;
}
冒泡
int[] Arrays = new int[]{6,5,2,9,7,4,0};
int temp = 0;
int i,j;
for (i = 0; i < Arrays.Length; i++)
{
for (j = i; j < Arrays.Length; j++)
{
if (Arrays[i] < Arrays[j])
{
temp = Arrays[i];
Arrays[i] = Arrays[j];
Arrays[j] = temp;
}
}
Response.Write(Arrays[i]);
}
//第二种方法
for (i = 0; i < Arrays.Length - 1; i++)
{
for (j = 0; j < Arrays.Length - 1 - i; j++)
{
if (Arrays[j] > Arrays[j + 1])
{
// 交换元素
temp = Arrays[j];
Arrays[j] = Arrays[j + 1];
Arrays[j + 1] = temp;
}
}
}
for (i = 0; i < Arrays.Length; i++)
{
Response.Write(Arrays[i] + "\n");
}
递归
public int fun(int n)
{
if (n == 1)
{
return 1;
}
else
{
return n * fun(n - 1);
}
}
九九乘法表
public class qiuqiubiao{
public static void main(String[] args){
int i,j;
for(i=1;i<=9;i++){
for(j=1;j<=i;j++){
System.out.print(i+"*"+j+"="+i*j+" ");
}
System.out.println();
}
}
}
顺三角
public class shunsanjiao{
public static void main(String[] args){
for (int i=0;i<=9;i++){
for(int j=1;j<=i;j++){
System.out.print("*");
}
System.out.println();
}
}
}
创建存储过程语法:
Create proc[edure] 存储过程名
[ {@参数1 数据类型} [=默认值] [output],
……,
{@参数n 数据类型} [=默认值] [output]
]
As
sql语句
Execute语句用于调用执行存储过程
//1234.56转换为壹仟贰佰叁拾肆圆零伍角陆分:基本功能完成(笔试写这样可以)
public static void ShowMoneyString(double moneyNumber)
{
//整数对位标志
string[] Pen = new string[] { "圆", "拾", "佰", "仟", "万", "拾", "佰", "仟", "亿", "拾", "佰", "仟", "兆" };
string[] MaxRmb = new string[] { "零", "壹", "贰", "叁", "肆", "伍", "陆", "柒", "捌", "玖" };
string[] Pen2 = new string[] { "分", "角" };
string strNumber = moneyNumber.ToString();
//分隔小数位
string[] split = moneyNumber.ToString().Split(new char[] { '.' });
string strOut = "";
if (split.Length == 2)
{
//转化整数部分
for (int i = 0; i < split[0].Length; i++)
{
int num = int.Parse(split[0].Substring(i, 1));
strOut += MaxRmb[num] + Pen[split[0].Length - i - 1];
}
//转化小数位
if(split[0].Length==1)
{
split[0]=split[0]+"0";//一位补0
}
for (int j = 0; j < split[1].Length; j++)
{
int num = int.Parse(split[1].Substring(j, 1));
strOut += MaxRmb[num] + Pen2[split[1].Length - j - 1];
}
}
else {
for (int i = 0; i < split[1].Length; i++)
{
int num = int.Parse(split[1].Substring(i, 1));
strOut += MaxRmb[num] + Pen[split[1].Length - i - 1];
}
strOut=strOut + "整";
}
Console.WriteLine(strNumber + "数字:人民币为" + strOut);
// return strOut;
}
1、 编写程序计算1+2+3+....+100的和。
int c=0; for(int i=1;i<=100;i++){ c+=i; }
2、已知一个int数组, 编程从数组中获取最大数。
public int GetMax(int[] array){
int max=array[0]; for(int i=1;imax) max=array[i]; }
return max; }
3、用户输入一个“2008-01-02”格式的日期分析用户输入的日期然后按照“2008年1月2日”的格式重新输出。 public string GetDate(string s){
string[] s=s.split('-');
return string.format("{0}年{1}月{2}日",s[0],s[1],s[2]);
}