基本编程总结(冒泡+转换+乘法表)

 

 

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]);

    }