- C# code
using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Data.SqlClient;using System.Data;/// <summary>///SQLHELPER 的摘要说明/// </summary>public class SQLHELPER{ public static string connstr = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True"; public static void runsql(string sqltext,string returntype,params SqlParameter[] p) { SqlConnection conn = new SqlConnection(connstr); conn.Open(); SqlCommand comm = conn.CreateCommand(); comm.CommandText = sqltext; foreach(SqlParameter ps in p) { comm.Parameters.Add(ps); } switch (returntype) { case "dr": SqlDataReader dr = comm.ExecuteReader(); return dr; break; case "dt": SqlDataAdapter da = new SqlDataAdapter(); DataTable dt = new DataTable(); da.Fill(dt); conn.Close(); return dt; break; default: comm.ExecuteNonQuery(); conn.Close(); break; } }}
此代码有问题
如何实现一个可以返回多种类型的 ?????谢谢
------解决方案--------------------------------------------------------
用泛型可以,但是你不觉得每次调用要多传个参数很麻烦?
封装的目的不是为了封装的时候写代码简单,而是为了之后使用的人方便