export/Common/SQLFormat.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.OleDb;
using System.Globalization;

namespace export.Common
{
    public class SQLFormat
    {

        /// <summary>
        /// 拼接数据库链接字符串
        /// </summary>
        /// <param name="server"></param>
        /// <param name="database"></param>
        /// <param name="user"></param>
        /// <param name="pwd"></param>
        /// <returns></returns>
        public static string GetConnection(string server, string database, string user, string pwd)
        {
            string connectionStr = string.Format("Data Source={0};Initial Catalog={1};" +
                                                 "User ID={2};Password={3}", server, database, user, pwd);
            return connectionStr;
        }


        /// <summary>
        /// 删除表
        /// </summary>
        /// <param name="tableName"></param>
        /// <returns></returns>
        public static string SelectTable(string tableName)
        {
            if (!string.IsNullOrEmpty(tableName))
            {
                string sql =
                    string.Format(@" SELECT * FROM {0} ", tableName);
                return sql;
            }
            return "";
        }


    }
}