三层构架实例（Example of three story frame）.docVIP

三层构架实例（Example of three story frame） 1, write a SQLHelper class, as follows Public class SQLHelper { Public (SQLHelper) { / / TODO: Add constructor logic here// / / there is no need to write something in the constructor. / / } Public static SqlConnection (DataBaseConnection) / / returns an instance of the SqlConnection object { SqlConnection con = new (SqlConnection) (ConfigurationManager.AppSettings[0].ToString); Return con; } Public static void Open (SqlConnection con) / / open database connection { If (con = null) { Con = new (SqlConnection) (ConfigurationManager.AppSettings[0].ToString); } If (con.State = ConnectionState.Closed) { Try { (con.Open); } Catch (Exception Ex) { SystemError.SystemLog (ex.Message); } } } Public static void Close (SqlConnection con) / / close the database connection { If (con! = null) { If (con.State = ConnectionState.Open) { (con.Close); } } } Public static void Dispose (SqlConnection con) / / database connection release { If (con! = null) { (con.Dispose); Con = null; } } Public static SqlParameter CreateParameters (string ParamName, SqlDbType DbType, int Size, ParameterDirection Direction, object Value) { SqlParameter param; If (Size 0) { Param new = SqlParameter (ParamName, DbType, Size); } Else { Param new = SqlParameter (ParamName, DbType); } Param.Direction = Direction; (if! (Direction = ParameterDirection.Output and Value = = null)) { param. value = value; } return param; } / / 創建sql參數 public static sqlparameter createinparameters (string paramname, sqldbtype dbtype, int size, object value) / / 創建輸入參數 { return createparameters (paramname, dbtype, size, parameterdirection. input, value); } public static sqlparameter createoutparameters (string paramname, sqldbtype dbtype, int size) / / 創建輸出參數 { return createparameters (paramname, dbtype, size, parameterdirection. output, etc.); } public static sqlcommand createcommand (string procname, sqlconnection con, sqlparameter [] prams) / / 創建並返回一個command對象, 設置command對象所需要的參數, 並且為每個command